Importing : Change transactions from charges to payments + vv
Hi
I trust this finds you well.
I have been finding Moneydance really good since I made the switch from Microsoft Money.
For one of my credit cards, QIF files are imported the wrong way round.
I've been using a longwinded work around of manually changing charges to payments + vv
i.e. '+' to '-' and '-' to '+'
Please is there any way of changing the way transactions are imported into the account please>
OR
Is there a way of batch changing charges to payments + vv
i.e. '+' to '-' and '-' to '+'?
I've attached a QIF for that account
Thank you
Tim
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by dtd on 21 Jul, 2021 10:24 PM
just a user
have you tried Preferences/Network/Ignore Transaction Types in favor of Amount signs?
Not saying that will work, but it can be tried.
EDIT - seems that is for OFX files, but here's a thread with other alternatives:
https://infinitekind.tenderapp.com/discussions/problems/69613-signs-reversed
btw - you uploaded the bank statement, not the QIF file. Hopefully someone from Infinite Kind will delete that for you.
2 Posted by dwg on 21 Jul, 2021 10:47 PM
I'm a fellow user.
Obviously I have not see the QIF file as it has not been posted, but over the years some institutions have provided QIF files that have the amounts in them from the perspective of the bank rather than the customer.
A fellow user created QIF loader extension that can potentially help with this.
You can find this extension at:
https://bitbucket.org/mikerb/moneydance-2019/wiki/QIF%20Loader
3 Posted by Tim Norman on 23 Jul, 2021 01:39 AM
Thank you for your comments, which led me to this - which works for me:
"I’m in the same situation as you with one of my Credit Cards…. The following maybe of interest, but only if your bank will let you grab a CSV file.
In MD go to File → Import, find your CSV file, click Open. On the next screen top item, make sure the account you want to import into is selected. Check the other fields are correct. On the next screen you will see Amount. Change this to Debit Amount, then finish.
The above I think will only work with CSV, but as most Banks normally offer CSV, maybe this will help you. I’ve been importing this way for years.
Jeff – Fellow User"
Support Staff 4 Posted by Ethan on 25 Jul, 2021 09:15 PM
I've deleted your bank statement PDF from the original post, since it's generally not a good idea to post things like that publicly on the internet.
I'm glad to hear you've found a solution that will work for you. I think the first suggestion would have worked for the original problem, but if you've found that CSVs meet your needs, that's fine.
Ethan
Infinite Kind Support
Ethan closed this discussion on 25 Jul, 2021 09:15 PM.