reverse debit and creit

[Derek Atkins]

It sounds like you imported them incorrected.

Alas, there is no "mass fix" for this; you'll have to either re-do the
imports or modify each one by hand.

-derek

Jonathan Silvey <jonathan.silvey at gmail.com> writes:

> Agreed - my recording has been unbelievable!
>
> I can only download them as CSV or OFX, but I can't get either into a test
> gnucash account. I can, of course, get csv into Excel or Calc.
>
> I'll be opening a new set of gnucash accounts, starting on April 5th, our
> new tax year.
>
>
> Jonathan
>
> *Think before you print.*
>
> On 30 March 2017 at 23:55, Greg Feneis <mfeneis at gmail.com> wrote:
>
>> Did you really manually enter 3k transactions before realizing they were
>> faulty?  Or, did you import them and they didn't import to your
>> satisfaction?​
>>
>> I might try downloading those transactions from the credit card's web site,
>> and in GnuCash I would test import them into a test account in a duplicate
>> set of books (don't use your original  data file to test on).  See how it
>> goes.  If it goes correctly, in another duplicate set of books, delete the
>> offending transactions and import the correct transactions that were
>> downloaded from the credit card's web site.  If that goes well, archive
>> your original set of books and work from the set in which all went well.
>>
>>
>>
>>
>>
>>
>>
>> Kind regards,
>>
>> Greg Feneis
>>
>>  <http://www.linkedin.com/in/electromechanical>
>>
>>
>>
>>
>> On Thu, Mar 30, 2017 at 2:41 PM, Jonathan Silvey <
>> jonathan.silvey at gmail.com>
>> wrote:
>>
>> > Hi Colin,
>> >
>> > It's only my credit card entries that are the wrong way round, due to the
>> > fact that a credit card is a Liability, not an Asset. When I pay every
>> > month, it's by Direct Debit, so it gets paid OK. I also record it
>> > accurately in my Bank Asset account, so it is correct in the card account
>> > too.
>> >
>> > In other words, it's not quite accurate to say ALL my entries are wrong,
>> > but almost all my Tot Payment entries should be entered as Tot Charge.
>> I'm
>> > trying to correct this in a few clicks, not 3000+!
>> >
>> >
>> > Jonathan
>> >
>> > *Think before you print.*
>> >
>> > On 30 March 2017 at 21:15, Colin Law <clanlaw at gmail.com> wrote:
>> >
>> > > Please note that your post went just to me and not to the list, due to
>> > the
>> > > way this list is set up it is necessary to use Reply All or Reply List
>> > when
>> > > replying. I am forwarding it to the list, along with my further
>> comment:
>> > >
>> > > On 30 March 2017 at 20:59, Jonathan Silvey <jonathan.silvey at gmail.com>
>> > > wrote:
>> > >
>> > >> Thanks for quick reply. Maybe I did not explain correctly.
>> > >>
>> > >> On my Liability: Credit card, all the Tot Payments should be Tot
>> Charge,
>> > >> and vice versa. You are right, it doesn't balance, and this is what I
>> > >> wanted to correct.!
>> > >>
>> > >
>> > > So are all your expense accounts the wrong way round too?  Also when
>> you
>> > > pay off the credit card from the bank account that would have to be the
>> > > wrong way round too.
>> > > I can't understand how you can have been using it for so long without
>> > > noticing.
>> > >
>> > > Colin
>> > >
>> > >
>> > >
>> > >>
>> > >>
>> > >> Jonathan
>> > >>
>> > >> *Think before you print.*
>> > >>
>> > >> On 30 March 2017 at 20:49, Colin Law <clanlaw at gmail.com> wrote:
>> > >>
>> > >>> On 30 March 2017 at 20:41, Jonathan Silvey <
>> jonathan.silvey at gmail.com>
>> > >>> wrote:
>> > >>>
>> > >>>> I have put all my debit/credit card transactions the wrong way
>> round.
>> > >>>> Does
>> > >>>> anyone know a way to reverse them all together at once? There are
>> over
>> > >>>> 3000
>> > >>>> separately!
>> > >>>>
>> > >>>
>> > >>> I don't understand how you could get debit and credit cards the wrong
>> > >>> way round, but other accounts (eg bank and expense accts) the right
>> way
>> > >>> round. Nothing would balance.
>> > >>>
>> > >>> Colin
>> > >>>
>> > >>>
>> > >>>
>> > >>
>> > >
>> > _______________________________________________
>> > gnucash-user mailing list
>> > gnucash-user at gnucash.org
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > -----
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> >
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available