Nationwide OFX file

OnVac247365

I'm attempting to import OFX file generated by Nationwide into MSMoney Sunrise 

My “flex account” export to OFX appears fine as on import all transactions appear without error .

My “credit card” export on the other hand appears to create a fully populated OFX file but only 4 of the 20 transactions are transferred during the MSMoney import.

Any help appreciated.

WillPS

Can you share what the 5th transaction is? Are there any non-alphanumeric characters perhaps?

pochisoldi

First thing - are you sure that you aren't processing an OFX file which has 20 transactions, of which 16 have already been reconciled, with 4 left to match up? (i.e. you've already previously downloaded an OFX file containing 16 transactions, which you have reconciled)?

Each transaction in an OFX file has a unique identifier (FITID) which (post reconciliation) MS Money stores with the transaction so that you only have to reconcile the transaction once. This is unlike QIF files which require you to reconcile every transaction in the file, even if has been reconciled before.

Otherwise...

You need to look at the OFX file, however if Nationwide's credit card OFX files are anything like their current/savings account OFX files, you'll find a "slab" of text with no line endings, so looking in a text editor won't help, so rename the file so the .ofx becomes .xml then double click on the file, and it should open in a web browser.

There won't be anything wrong with the headers - if there was, Money would reject the file with an error, or you wouldn't get any transactions.

First thing - look for <DTSTART> and <DTEND> - the start and end dates of the OFX statement. Do they look right?
- DTSTART should either be the date of the first transaction or the first date of the credit card month
- DTEND should either be the date you downloaded or the date of the last transaction in the file.
Second thing - count the number of <STMTTRN> entries - each one represents a transaction.

Do that and you should be able to work out whether it's you not selecting the right date range when downloading, Nationwide not delivering the required data, or MS Money not processing it correctly.

Note that this is all based on a few years of playing with/generating OFX+QIF files to get them to load data into Money with consistent payee names, I don't actually have a Nationwide credit card OFX file to play with...

PochiSoldi