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....@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 <mailbox0...@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....@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@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@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.
_______________________________________________
gnucash-user mailing list
gnucash-user@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.
