Nationwide to remove support for Microsoft money

jonfarmer

rpb424 wrote: »

There are various OFX versions, and the options in mt2ofx allow you to create many of them. If you compare a downloaded OFX from Nationwide that will not import with one converted by mt2ofx that will import then there are some marked differences.

The problem would appear to be that Money only seems to support version 102 OFX files, but the Nationwide ones are produced to version 203. If I edit the mt2ofx options to produce a version 203 from the csv file instead then the resultant OFX file it generates looks substantially similar to a Nationwide one as you would expect, but Money will not import it.

I only have Nationwide accounts, so I don't know what OFX versions other banks are producing. Also, I am using Money 2001, so I also don't know whether or not later versions might support other OFX versions.

We should all begin our posts with a vote of thanks to rpb424 for the key successful work in modifying the vbs script to give us a csv to OFX v102 conversion. That means we can at least keep going using CSV conversion while Nationwide sees if it can sort out the 102 vs 203 format differences. There are 2 or 3 oddments that give possible ways forward:

1. Barclays offers users a dropdown list of about 6 different formats that they can use for downloads, one of which is Money 2002. This works for import into Money 2005 which we use. The same applies to our bank in France (Credit Agricole) which has slightly fewer options but one of them is Money OFX which again imports into Money 2005 directly. So one key aim is that we should all ask Nationwide for the same dropdown list of format options.

2. The Barclays OFX download option covers 'all day-to-day accounts' (which in practice means the current account, eSavings, and eISAs). So a 2nd key aim is to ask Nationwide for a composite OFX download, and not just one download for each separate account. Money can happily import several accounts from the same OFX, and so can other financial management packages. This saves lots of time each day having to import each account separately.

3. Another possible route is to see whether it is possible just to modify the OFX 203 format directly by a script and convert it into a 102 format. I contacted the international OFX group, and the advice they gave was that it should be possible. They gave some initial advice which included substituting the initial header section, removing the <(/
[*])> closers which are part of the 203 format, and ensuring that the final <(/OFX)> remained. I have tried this approach but my scripting skills are limited and I had to do the trial using Find/replace in Word, so perhaps it was not surprising that this was not immediately successful. However I mention it so that people like rpr424 who can do coding may like to have a look at working along these lines.

Again, best wishes and sincere thanks to everyone who has worked so hard to help us all get through this.

rpb424

jonfarmer wrote: »

We should all begin our posts with a vote of thanks to rpb424 for the key successful work in modifying the vbs script to give us a csv to OFX v102 conversion.

I should inject a note of modesty here and state that the real thanks ought to go to Colin Smale who wrote mt2ofx in the first place. I'm indebted to him, and without his program I'd have given up on Nationwide two years ago and gone elsewhere when direct download into Money disappeared. At that time, and in the absence of mt2ofx, csv only downloads from Nationwide would have then involved typing all transactions by hand into Money, which would have driven me insane.

As I stated in the past though, it wasn't really Nationwide's fault for what happened at the time, it was Microsoft who pulled the plug on Money direct download support, forcing Nationwide into an impossible position.

That said though there is simply no excuse for Nationwide taking two more years to implement OFX downloads, and then to get it wrong anyway.

It does look as though Colin doesn't support mt2ofx any more. The forum still exists on the mt2ofx website but he no longer contributes to it, where as he used to be quite prolific in the past. Fortunately the program does all it needs to for our purposes. Cheers Colin.

Imnoexpert_2

Please can you help?

I'm not a VB user but have tried to get all this working. I think I got close at one point with the program running ok and opening money but money not being able to open the file.

I ended up reinstalling MT2OFX and adding your files all over again. I've mad the changes in the scripts although I'm not sure I followed all the changes around the IF statements.

What I have had since I reinstalled is the following message

Script control
unable to ad module nationwidecc-csv an object with the given name has already been added

In the time I've spent on this I could have typed in the statement many times! I would still like to get it working.

Thanks

Marc_C

My problem s that W7 does not recognize the rpb424's downloaded file as a .vbs file. So.........

I opened the old mt2ofx .vbs file with notepad, deleted all the entries (after making a copy of the file of course!) and copied the new downloaded file entries into the old vbs file. File saved. Old file deleted from the programe and deleted from the scripts as well.

New file added via options, scripts, update and added to the programme.

On trying to convert a downloaded Nationwide flex account file an error message appears:

"MT2OFX has been unable to recognise the format of the file ........... etc"

Have I missed an important step?

Marc_C

It all gets curioser and curioser!

I downloaded from my Flex account - full statement – a .csv file and a .ofx file.

MT2OFX was able to convert the csv file but MS Money was unable to open it. However, I then used MS Money to import the downloaded ofx file and it imported correctly with the credits and debits on the correct side!

Flushed with success, I then download an ofx version of my cc account and successfully imported it. This time however, the debits and credits were (still) on the wrong side.

Half way there. Sigh..........

rpb424

What version of Money are you using? I just downloaded a full Flexaccount statement as OFX and it wouldn't open in Money - still version 203. I'm using Money 2001.

Going back to csv downloads, are you absolutely sure you've set up the Flexaccount vbs file correctly and that mt2ofx is really seeing it? If mt2ofx IS using it and claims to successfully convert the file then you're nearly there, except that it may not be putting the correct account number information into the created OFX file.

Two possibilities...

1. Did you change your account name on the NW website such that the script is looking for a name other than 'Flexaccount'?
2. Can you check in an OFX file that mt2ofx has converted that an account number appears after the <ACCTID> field.

Marc_C

rpb424 wrote: »

What version of Money are you using?

I am using MS Money 2005 version 14.0.120.1105


Going back to csv downloads, are you absolutely sure you've set up the Flexaccount vbs file correctly and that mt2ofx is really seeing it? If mt2ofx IS using it and claims to successfully convert the file then you're nearly there, except that it may not be putting the correct account number information into the created OFX file.

Two possibilities...

1. Did you change your account name on the NW website such that the script is looking for a name other than 'Flexaccount'?

Yes – must have done that years ago and had forgotten about it.

2. Can you check in an OFX file that mt2ofx has converted that an account number appears after the <ACCTID> field.

This is what I see:

<ACCTID>
<ACCTTYPE>CHECKING


Some other information which may be of interest....... MT2OFX w ould not convert the “mini statement “ file but would convert the “full statement” file.

rpb424

That <ACCTID> is your problem then, immediately after <ACCTID> on the same line should be your account number. The number is not getting inserted because the script cannot find an account name match because you changed it.

Can you open the csv file that gets downloaded and check the first line, it should normally read

"Account Name:","FlexAccount ****12345"

You won't actually see '12345' but will see the last five digits of your Flexaccount number. The bit in bold is the important bit. In your case you will not see the word 'FlexAccount' but something else because you changed it on the website.

Whatever name you see, you need to make sure that it is EXACTLY matched (it is case sensitive) in at least one of the lines in the 'Multi Account' vbs script and that the line below that name contains the account number itself (rather than 'xxxxxxxx')

If StartsWith(sName, "FlexAccount") Then ............Change this to the csv file account name up to the first '*'
sAcct = "xxxxxxxx" ................Replace with your account number, leave the quote marks
ElseIf StartsWith(sName, "e_Savings") Then
sAcct = "xxxxxxxx"
ElseIf StartsWith(sName, "ISA") Then
sAcct = "xxxx/xxxxxxxxx"
End If

Hopefully it will then work!

Marc_C

rpb424,

Followed your instructions and it has all worked out perfectly; many thanks to you and NOT Nationwide!

Converting the csv file and importing it displays more information that importing the ofx file so I will use that in future.

Now to try and get my cc files working properly (currently on holiday with Mrs Marc C saying that I am spending too much time on this already - hmmmmmmm).

BTW, if anyone would like a copy of MS Money 2005 build 1105 say so here and I will upload a copy to Dropbox.

Marc_C

Marc_C wrote: »

.......

Now to try and get my cc files working properly......

Took all of 5 minutes and all the converted and the imported file has all the debits and credits are on the correct sides.

Thank you once again rpb424 for sorting this all out.

Regards,
Marc