Is there a way to swap Deposit/Withdrawal columns?

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
borisv
New MMEX User
Posts: 6
Joined: Thu Jul 15, 2021 12:33 am
Are you a spam bot?: No

Is there a way to swap Deposit/Withdrawal columns?

Post 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.
borisv
New MMEX User
Posts: 6
Joined: Thu Jul 15, 2021 12:33 am
Are you a spam bot?: No

Re: Is there a way to swap Deposit/Withdrawal columns?

Post 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).
whall3y
MMEX Developer
Posts: 343
Joined: Fri Aug 21, 2020 5:44 pm
Are you a spam bot?: No

Re: Is there a way to swap Deposit/Withdrawal columns?

Post 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.
borisv
New MMEX User
Posts: 6
Joined: Thu Jul 15, 2021 12:33 am
Are you a spam bot?: No

Re: Is there a way to swap Deposit/Withdrawal columns?

Post by borisv »

That "bulk edit" is nice! Thank you.
Post Reply