OFX import not working

[jjb]

I'll apologise right now as this is likely to be me doing something dumb! I'm a new user attempting to migrate from Microsoft Money.

When I drag an OFX file from my bank to the relevant account in MM, it just comes up with an "Import Complete" dialog box which says "No transactions were imported" but I know that there are new transactions in there, some which should reconcile with existing manual entries on the account and some which should be brand new.

Could this be an issue with the format of the OFX file provided by the bank? If so, is there a way I can validate it other than to just go through the file looking for stuff like non-matching tags, non-printable characters etc?

Alternatively, could it be because I tried importing it previously and it just created a new account rather than associating it with the existing account?

image.png (13.35 KiB) Viewed 209 times

[Campbell]

It's difficult to say, without being able to see your data file.

Can you open it in a text editor, and tell me a few things.

• What is the version in the header? (Should be something like OFXHEADER:100 or OFXHEADER=200)
• Does it contain a DATA:OFXSGML entry?
• Do you see any entries in the file starting <STMTTRN>? If so, does it contain a sub-node containing <DTPOSTED> ?

I suspect the issue will be around a different or non-standard format of the OFX file.

If you are able to send me a sample from the file, that would be even better. Obviously you can remove/alter any sensitive data.

[jjb]

Thanks for the speedy response!

My suspicion is the same as yours . The file is from Barclays and they've always worked fine with MS Money but I know they've been doing something with them recently as they've made downloading them more difficult and the reset all the FITID values which caused me a lot of pain!

One other thought that's occurred to me is that I've tried to import the same file a couple of times now so I'm wondering whether MM keeps track of files (or FITIDs) its already imported so that it doesn't import them again and risk causing duplicates. If that's the case, is there a way to reset that?

I'm happy to send the file to you by email if that helps?

Headers are:

Code: Select all

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

[Campbell]

Maxim Money does keep track of what is imported, but it does that by storing the download ID against each transaction. If the same download is imported, it will match against the same transaction, but it would still import again.

So I think it’s really just a case that the transactions aren’t importing at all.

If you’re able to send me a file demonstrating the issue that would be amazing and I’ll see why it isn’t bringing them in.

[jjb]

Replying to note that Campbell identified the issue as being with the date format used by Barclays not being supported by the current version of MM. It will be covered in a future version. Many thanks for the help identifying this, Campbell!