[GNC] How to change MANY Deposits to Withdrawals? (Import error)

[Fran_3]

 Well, turns out I did have a copy of the GC file just before import :-)And I have the data ready to import again.I can experiment and find this out but my question now is... 

Does the sign need to be minus for Withdrawals?
I think, when I originally imported the 663 transactions I may have had both the Deposit & Withdrawal columns populated with positive numbers...
Our bank puts deposits & withdrawals in the same column with a negative sign for withdrawals...
Preparing the spreadsheet for import into GC I used 
=if(A2>0, A2,) to get the positive numbers into the Deposit column and then used=if(A2<0, A2,) to get the negative numbers into the Withdrawal field.So the withdrawal column should have the negative sign in front of each withdrawal...Maybe GC wants both to be positive and uses the Column Heading to figure things out... I'm not sureI'll experiment
Anyway thanks for talking me through this guys :-)
Wish me luck.


    On Sunday, February 16, 2020, 1:27:33 PM EST, David Carlson <david.carlson.417 at gmail.com> wrote:  
 
 In the future,  be sure to save a copy of the file just before importing! 
David Carlson 
On Sun, Feb 16, 2020, 12:14 PM Fran_3 <mailbox0600 at yahoo.com> wrote:

 They are the last 663 checking transactions and they were already saved gnuCash and its going to be hard to go back to an earlier version.
My plan is to export those last 633 transactions and edit them in a spreadsheet... which I've already doneand I ended up with just 5 columns...  Date, Num, Description, Deposit, Withdrawal
Next I need to delete the last 633 transactions from the check register but I have not been able to select multiple checking transactions...
Any idea on how do select multiple checking transactions so you can just delete them all at once?
Thanks for the help !

    On Sunday, February 16, 2020, 12:34:02 PM EST, David Carlson <david.carlson.417 at gmail.com> wrote:  
 
 The easiest way is to close gnucash without saving to abandon the current data and import again.  
If you saved the file with the incorrect import, close it and open the last save before the import.
If you didn't notice the error until much later, there is no mass correction possible, but you could import again if it was a qif import then delete the ones that are wrong. 
David Carlson 
On Sun, Feb 16, 2020, 10:30 AM Fran_3 via gnucash-user <gnucash-user at gnucash.org> wrote:

I imported a big bunch of checking transactions and guess I got the Deposit & Withdrawal columns labeled wrong during the import process.
Is there any way to select a bunch of checking transactions and change Deposits to Withdrawals?
Thanks for any help.

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.