GnuCash, OFX and Nationwide

Posted by alex on November 18th, 2008

A couple of people have been coming here looking for information about how to get Nationwide accounts loaded via OFX into GnuCash. Here are some instructions contributed by Mercurio:

Install GnuCash

These are instructions for installing on flavours of Linux Debian or Ubuntu. If you already have GnuCash installed skip to the Setup GnuCash section.

Follow the following instructions to install GnuCash on Ubuntu or Debian. Since Debian Lenny and Ubuntu 8.10 Intrepid the packages for GnuCash come with online banking enabled so you should be able to use the same packages included in your distribution: http://wiki.gnucash.org/wiki/Debian.

Install compiled apps

Once you have your compiled GnuCash packages install them by running the following command:

sudo dpkg –install gnucash_*.deb gnucash-common_*.deb

Add backport repository

This step might not be necessary but probably worth doing:

sudo nano /etc/apt/sources.list
deb http://ppa.launchpad.net/gnucash/ubuntu hardy main
deb-src http://ppa.launchpad.net/gnucash/ubuntu hardy main
sudo apt-get update

You might need to run this as well:

sudo apt-get install –f

Install packages

Use Adept to ensure the following packages have been installed:
Gnucash
Libaq

Setup GnuCash

Enable OFX

Go to Tools -> Online Banking Setup -> Forward -> Start Aqbanking Wizard -> Backends.
Select OFX, enable and exit.

Setup OFX

Go to Tools -> Online Banking Setup -> Forward -> Start Aqbanking Wizard -> Users -> New

Apply these settings:
Backend=aqofxconnect, ok

On the General Tab:
User Name=Nationwide
User Id=Nationwide Customer Number
Customer Id=Nationwide Customer Number
Country=United Kingdom
Bank Id =070116

On the OFX Tab:
FID (OFX Tag )=MFS_FID
ORD (OFX Tag )=MFS_ORG
Broker Id=Nationwide
Url is: https://pfmanagement.nationet.com/OFXSecurity/OFX_SSL_128.dll
Server Options=Supports Account List Download

Select Get Accounts

If all is well, that should be it. Note these instructions may well not be 100% accurate. If you have questions or can provide corrections or improvments, please leave your comments below.

< Back to Nationwide OFX Downloader

7 Comments »

7 Responses to “GnuCash, OFX and Nationwide”

Should the user id and customer number be the same? And, if so, I then get a password prompt after selecting Get Accounts: should that be the memorable data, or passnumber, or a combination?

Left by Dave on February 6th, 2009

Dave, the password is your memorable data and your passnumber concatenated (so if my memorable data is foobar and my passnumber is 123456, the password is foobar123456)

Left by Matt on February 23rd, 2009

Gone through these steps, when I click on Get Accounts, I enter my passnumber and then I get sent back to the User Configuration window. No accounts appear anywhere in AqBanking nor Gnucash.

When I run Gnucash in the terminal I get this message:
3:2009/03/05 18-12-38:gwen(17259):io_tls.c: 1154: gnutls_handshake: -9 (A TLS packet with unexpected length was received.) [fatal]
3:2009/03/05 18-12-38:(null)(17259):provider.c: 659: Error exchanging getAccounts-request (-66)
3:2009/03/05 18-12-38:qt3_wizard(17259):cfgtabpageuserofx.cpp: 283: Error requesting account list

Checking the Force SSLv3 option doesn’t help, am I doing something wrong?

Left by Moggers87 on March 5th, 2009

Dave,

According to https://www.wesabe.com/groups/39-uk-wesabe-users/discussions/1774-nationwide-ofx-download-success your “password” is “your memorable data plus your 6 digit pass number concatenated to a single string”.

Left by sil on March 19th, 2009

I was unable to get this working either – perhaps someone who has a complete set of working settings with the Nationwide could let us know their secret :-)

I guess I could reenable paper statements from my bank and reconcile that way :)

Left by Rob Butler on April 27th, 2009

I have tried these instructions and I get an error 500 internal server error requesting accounts list, is there something missing in the instructions?

Left by Bob on August 17th, 2009

Has this mechanism been killed by Nationwide stopping support for MS Money? http://www.nationwide.co.uk/troubleshooting/MicrosoftMoney/MicrosoftMoney.htm
It feels very much like the same mechanism and GNUcash doesn’t manage to get a list of my accounts. A page flashes by with some details but I don’t know how to retrieve it.

Mark

Left by Mark on October 29th, 2009

Something to say?