Page 1 of 1
Is there a way to swap Deposit/Withdrawal columns?
Posted: Thu Jul 15, 2021 12:41 am
by borisv
I am setting up my new DB. I have two QIF files to Import where I want Deposit/Withdrawal columns being swapped.
(In my very old Quicken those were set up as loans, that's why).
Is there a way to do that either during the import or later?
Thanks.
Re: Is there a way to swap Deposit/Withdrawal columns?
Posted: Thu Jul 15, 2021 9:56 am
by borisv
I'm afraid my description wasn't clear.
It's not about changing places, to edit the order in the table.
But what I want is to change value's signage (-$100 to become +$100 and vise versa).
Re: Is there a way to swap Deposit/Withdrawal columns?
Posted: Thu Jul 15, 2021 4:49 pm
by whall3y
There is no way to adjust this on the import. Your options as I see it:
1. Edit the QIF file to change the 'T' entries the import
2. Import and then go the the the transaction view and bulk edit the the transactions to change Withdrawal to Deposit and vice versa.
Re: Is there a way to swap Deposit/Withdrawal columns?
Posted: Sat Jul 17, 2021 12:36 am
by borisv
That "bulk edit" is nice! Thank you.