Importing : Change transactions from charges to payments + vv

Tim Norman's Avatar

Tim Norman

21 Jul, 2021 10:09 AM

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

  1. 1 Posted by dtd on 21 Jul, 2021 10:24 PM

    dtd's Avatar

    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. 2 Posted by dwg on 21 Jul, 2021 10:47 PM

    dwg's Avatar

    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. 3 Posted by Tim Norman on 23 Jul, 2021 01:39 AM

    Tim Norman's Avatar

    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"

  4. Support Staff 4 Posted by Ethan on 25 Jul, 2021 09:15 PM

    Ethan's Avatar

    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

  5. Ethan closed this discussion on 25 Jul, 2021 09:15 PM.

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