Error when opening QFX file from single online account

javellar's Avatar


28 Nov, 2020 03:02 PM

After I download transaction data from one of my online accounts, I get the following message: There was an error importing the file 'Transaction 31.qfx': java.lang.NumberFormatException: For input string: "R".

This started about a month ago after years of successful weekly updates. It is a credit card account. I don't have this problem with any of my other accounts. I updated my MoneyDance to version 2021 and still get the error. My OS is Windows 10. Is this a know problem? If so, how can I fix it? Thanks.

  1. 1 Posted by dwg on 28 Nov, 2020 07:56 PM

    dwg's Avatar

    I'm a fellow user.

    It is a known problem to the extent that it is known that some Financial Institutions have changed their OFX downloads to have the "R" as a value in what should be a date. Who knows why.

    Moneydance has implemented a solution that ignores this value in the latest preview build, this can be obtained from:.

  2. 2 Posted by javellar on 28 Nov, 2020 10:50 PM

    javellar's Avatar


  3. Melissa closed this discussion on 17 Dec, 2020 07:07 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