Using MS Money with Nationwide Online Banking after sync service stopped
It took me a month to get around to checking why my MS Money 2005 was no longer directly syncing with Nationwide – and so I found, like many others, that Nationwide have discontinued the service after Microsoft terminated support.
Since the only other option for electronic format that Nationwide offer is a plain CSV of the transactions on the screen in web-banking, some workarounds are needed. Fortunately, quite a few people have been looking at this, and there’s a tool (MT2OFX) to convert the CSV to OFX (which MSMoney supports), combined with some scripts specific to Nationwide accounts. A recent discussion in MoneySavingExpert covers how to set it all up. Note there are updated scripts for both Nationwide and CC here.
Since this method does not have unique IDs for the transactions, it will overlap/duplicate any that were brought in via the direct sync. However, you can delete those, and from then on, it’ll work fine. Thanks to specifying your own dates on Nationwide (except Credit Cards, which export in monthly statements), you can set the precise date of your last sync, and limit it to a handful of duplicates.
From what I can see, the main detail is there, and Money continues to auto-classify as before. It’s a pain – I have 5 accounts, and you have to select dates and export each in turn – but it’ll do until I move to another bank.