Home > Uncategorized > Using MS Money with Nationwide Online Banking after sync service stopped

Using MS Money with Nationwide Online Banking after sync service stopped

November 28, 2009 Leave a comment Go to comments

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.

Advertisements
Categories: Uncategorized
  1. August 6, 2010 at 12:18 pm

    To overcome the issues mentioned above regarding duplication of transactions due to the lack of transaction IDs, try iCreateOFX Basic from
    http://icreateofx.co.uk/Convert-CSV-to-OFX
    The program has nationwide specific scripts that will generate persistent unique transaction IDs and elminate the pssibiltyof duplicate transactions.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: