How to fix issue when importing a "bad" OFX file into Microsoft Money (Sunset)

Question

I was importing an OFX file into Microsoft Money and something about the file cause Money to abort. Restarting Money resulted in it exiting immediately each time because the import was still pending.

Answer 1

For some reason Barclays have made changes to the .ofx format which fails to import in MS Money, it is simple to fix but annoying to have to keep doing it every time I do an import.

I have found they have amended the "TRNTYPE" descriptors in the file, so download the .ofx file, and then open the file in notepad and change all the TRNTYPE descriptors to "PAYMENT" or another descriptor that you prefer that money is happy with and it then imports without a problem.

Hope it helps you too

Answer 2

Two solutions worked:

1. Uninstall and reinstall the app (which is time consuming)
2. Open regedit and go to: Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Money\17.0 Clear out the contents of the "Import Files" key. That key has the list of files that will be imported when Microsoft Money starts. The original files are copied to temporary files in %USERPROFILE%\AppData\Local\Temp.

Answer 3

Some details on the P.Towers's anwser :

• the possible OFX TRNTYPE are listed here in page 235 here https://financialdataexchange.org/common/Uploaded%20files/OFX%20files/OFX%20Banking%20Specification%20v2.3.pdf
• The "OTHER" TRNTYPE is a generic TRNTYPE (not related to a credit (+) or debit (-))

(same problem happened a month ago to a French Bank "La Banque Postale" and I cannot comment because I don't have enough reputation)