Reconciliation Issue

Fred Squier's Avatar

Fred Squier

29 Mar, 2023 08:29 PM

When I download transactions to my American Express card the charges increase the balance as they should. Payments are also increasing the balance. They list in the payments column, but they increase the total balance. Impossible to reconcile. Do I have something set up wrong?

  1. 1 Posted by dwg on 29 Mar, 2023 09:23 PM

    dwg's Avatar

    I'm a fellow user.

    It has been observed that some financial institutions have reinterpreted the OFX specification and as such have changed the structure of the data they are providing.

    We have seen this reflected in data being incorrectly categorized between deposits and withdrawals when they are stored in Moneydance. This sounds like it may be the problem you are experiencing.

    To deal with this an option has been implemented under the menu path File → Preferences → Network to Ignore Transaction Types in Favor of Amount Sign.

    Selecting this option will result in Moneydance interpreting OFX data in a different way to account for the change in structure that some financial institutions have implemented for the data.

    Give this a try and see if it corrects your imports, naturally it will not change any data that is already in the register.

  2. 2 Posted by fasquier on 30 Mar, 2023 04:46 PM

    fasquier's Avatar

    Changed it and it seems to have worked. Thank you very much. I appreciate the assist.

  3. 3 Posted by fasquier on 30 Mar, 2023 04:56 PM

    fasquier's Avatar

    I lied. Tried reconciling account and when I pay the bill it increased the balance even though it shows in the payment column.

  4. 4 Posted by dwg on 30 Mar, 2023 10:09 PM

    dwg's Avatar

    Can you take a screen shot of the register and show us that, we may be able to pick up something from the visual.

    The following site shows various ways of taking a screen shot if you need help.

  5. System closed this discussion on 29 Jun, 2023 10:10 PM.

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