Credit card OFX download with positive/inverted balance

Clemens's Avatar


29 Mar, 2023 09:43 AM


I have a CC with a bank that unfortunately provides OFX downloads with an inverted/positive balance. I have contacted, but to no avail ("we know better than the standard" ...).

This leads to 2 issues, (a) a warning dialog every time I try to reconcile, and (b) a vast balance mismatch. I can of course click the "Ok" in the warning dialog, but the balance discrepancy is cumbersome.

Would it be possible to have a checkbox "Inverted balance" for credit card accounts, so that MD can take care of that for me?

Thank you,

  1. 1 Posted by dwg on 29 Mar, 2023 09:59 AM

    dwg's Avatar

    I'm a fellow user.

    We have seen banks provide OFX data like this over the years unfortunately.

    Moneydance has a setting that usually correct this.

    Go to the preferences: from the Moneydance menu select File --> Preferences

    Then on the Network Tab select the option to "Ignore Transaction types in favor of Amount signs" Hopefully that fixes the import issue. it will not change any transactions already imported.

  2. 2 Posted by Clemens on 29 Mar, 2023 10:07 AM

    Clemens's Avatar

    Thank you for the tip, dwg, I will certainly try this.

    To clarify: It's only the balance that has the wrong sign, the individual transactions are correct.

    Also, I can of course manually change the sign in the initial popup on every reconciliation. But when the process makes me do such a repetitive job manually, why use a computer in the first place?


  3. 3 Posted by dwg on 29 Mar, 2023 10:13 AM

    dwg's Avatar

    Well that is a different problem.

    A couple of things come to mind.

    Often when we see the balance has the wrong sign we find that the starting balance has been incorrectly set.

    With the register Open select Edit Account and the starting balance is on this screen.

    Another thing that throws people is if the sort order is not "by date" click on date in the header to do a simple sort by date.

  4. 4 Posted by Clemens on 29 Mar, 2023 10:15 AM

    Clemens's Avatar

    Thanks - to clarify: the absolute balance amount is correct, it's just the wrong sign.


  5. System closed this discussion on 28 Jun, 2023 10:20 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? 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