Moneydance Discussion - Nationwide (UK Bank)

Chris Darlaston New Member	Nationwide (UK Bank) Mar 6^th, 2006, 9:33am Hi, Nationwide bank in the UK supports Microsoft Money connection (and I have verified this) ... Is there anyway to get the information out of the connection packet stream to work out what URL I need to enter to access the information correctly using Moneydance? Thanks, Chris
Back to top	IP Logged

SeanReilly

Administrator

Re: Nationwide (UK Bank)
Reply #1 - Mar 7^th, 2006, 3:11pm

It depends exactly what type of connection they support. There are web-based connections which is basically the same as logging into the bank's web site and downloading a file into Moneydance/Money/Quicken/etc, and then there are direct connections where the application can connect directly to the financial institution's OFX server. If Nationwide supports the latter type of connection then it should be possible for Moneydance to do the same. If not, then the best option is to use the bank's web site to download files that are then loaded into Moneydance.

I don't know if MS Money contains a log of the connections that it makes, but Quicken sometimes keeps this information in a file called OFXLOG.txt. You can sometimes view this information in Quicken by selecting the Help->Customer Support menu and then clicking the "OFX log" link.

Back to top

WWW

IP Logged

Chris Darlaston

New Member

Re: Nationwide (UK Bank)
Reply #2 - Mar 8^th, 2006, 1:15pm

Quote from Forum Admin on Mar 7^th, 2006, 3:11pm:

It depends exactly what type of connection they support. There are web-based connections which is basically the same as logging into the bank's web site and downloading a file into Moneydance/Money/Quicken/etc, and then there are direct connections where the application can connect directly to the financial institution's OFX server. If Nationwide supports the latter type of connection then it should be possible for Moneydance to do the same. If not, then the best option is to use the bank's web site to download files that are then loaded into Moneydance.

It does support from inside of Money the download without using the website.

Quote from Forum Admin on Mar 7^th, 2006, 3:11pm:

I don't know if MS Money contains a log of the connections that it makes, but Quicken sometimes keeps this information in a file called OFXLOG.txt. You can sometimes view this information in Quicken by selecting the Help->Customer Support menu and then clicking the "OFX log" link.

I'll have a look around and see if I can find anything ...

Thanks

Back to top

IP Logged

theremster

New Member

Re: Nationwide (UK Bank)
Reply #3 - Nov 7^th, 2006, 8:22am

Quote from Chris Darlaston on Mar 8^th, 2006, 1:15pm:

Quote from Forum Admin on Mar 7^th, 2006, 3:11pm:

It depends exactly what type of connection they support. There are web-based connections which is basically the same as logging into the bank's web site and downloading a file into Moneydance/Money/Quicken/etc, and then there are direct connections where the application can connect directly to the financial institution's OFX server. If Nationwide supports the latter type of connection then it should be possible for Moneydance to do the same. If not, then the best option is to use the bank's web site to download files that are then loaded into Moneydance.

It does support from inside of Money the download without using the website.

Quote from Forum Admin on Mar 7^th, 2006, 3:11pm:

I don't know if MS Money contains a log of the connections that it makes, but Quicken sometimes keeps this information in a file called OFXLOG.txt. You can sometimes view this information in Quicken by selecting the Help->Customer Support menu and then clicking the "OFX log" link.

I'll have a look around and see if I can find anything ...

Thanks

Did you have any joy with MD and Nationwide? I also bank with Nationwide and am looking at this package.

THanks.

Back to top

IP Logged

Chris Darlaston

New Member

Re: Nationwide (UK Bank)
Reply #4 - Jan 2^nd, 2007, 12:50pm

Quote from theremster on Nov 7^th, 2006, 8:22am:

Did you have any joy with MD and Nationwide? I also bank with Nationwide and am looking at this package.

THanks.

I have not succeded in getting the information out of Ms Money ... I could track down the information that i thought was correct .. but I cannot get Moneydance to connect to Nationwide at all Sad

Back to top

IP Logged

Moneydance Support Senior Member	Re: Nationwide (UK Bank) Reply #5 - Jan 2^nd, 2007, 1:01pm I only see a Nationwide bank that is here in the US. Most UK/European banks do not support DIRECT OFX connections. Therefor most are downloading the info into a .qif file and then importing it into Moneydance.
Back to top	Thank you for using Moneydance. WWW IP Logged

dpwrussell

New Member

Re: Nationwide (UK Bank)
Reply #6 - Jun 11^th, 2007, 2:50pm

Quote from Moneydance Support on Jan 2^nd, 2007, 1:01pm:

I only see a Nationwide bank that is here in the US. Most UK/European banks do not support DIRECT OFX connections. Therefor most are downloading the info into a .qif file and then importing it into Moneydance.

I'm pretty definite they support OFX as Money apparently uses that with Nationwide [Building Society]. If anyone has Money and has been able to figure out how it connects to Nationwide, I'd appreciate the information.

Back to top

IP Logged

eunna New Member	Re: Nationwide (UK Bank) Reply #7 - Jun 27^th, 2007, 10:32am I am a Mac user in the UK and want to use Moneydance for online banking. My bank in the UK is First Direct (part of the HSBC family). Would I be able to download my accounts into Moneydance from First Direct?
Back to top	Email IP Logged

Moneydance Support Senior Member	Re: Nationwide (UK Bank) Reply #8 - Jun 28^th, 2007, 10:14pm Most of the UK banks do not allow Direct Connections for downloads. They only support .qif downloads. If you call your bank most will not have clue on what you are talking about.
Back to top	Thank you for using Moneydance. WWW IP Logged

rtufty

New Member

Re: Nationwide (UK Bank)
Reply #9 - Aug 31^st, 2007, 4:40am

From "Euros" on a googlegroup, here's the relevant bit of fipartnr.ini for the Nationwide Building Society, UK from Quicken 2003:

NNationwide Building Society
G40002
OC70D1A2C-B527-4f35-8836-DF960645F1AD
W1
IY
D07/08/2002
K|nationwide building society|nationwide bs|nbs|nw|
Hhttp://www.nationwide.co.uk
Thttps://olb2.nationet.com/default.asp
Ahttps://olb2.nationet.com/default.asp
Vhttp://www.nationwide.co.uk/banking/internet-banking/ms_money/msm_default.htm
SY
BY
UCustomer Number
PMemorable Data item + Passnumber
Mhttp://www.microsoft.com/money/money2003/gbr/nationwide.mnn
X07/08/2002
RO
*

And according to the Nationwide site, this version is still supported. So, which bits need to go where in MoneyDance???

Back to top

Email

IP Logged

Ash Administrator	Re: Nationwide (UK Bank) Reply #10 - Aug 31^st, 2007, 10:59am can you email that data to me in a plain text file that has been zipped up? the forums (and mail) will sometimes mess with the data and render it unreadable for me. support at moneydance point com
Back to top	Visit the Moneydance Wiki WWW IP Logged

grege

New Member

Re: Nationwide (UK Bank)
Reply #11 - Sep 14^th, 2007, 1:13pm

Hello - did this go anywhere?

Nationwide BS, definitely supports direct connection for the downloading of statements in MS Money, I've been using it for years. It works very (almost surprisingly) well. I think they are still the only UK bank to do this.

Has anyone mapped the fields from the rtufty's post yet?

I'd love to dump Money 2002, for something Mac native!

Back to top

IP Logged

aspuzling

New Member

Re: Nationwide (UK Bank)
Reply #12 - Nov 25^th, 2007, 2:45pm

I've been trying to get Nationwide to work with MD today. I found the above link on google groups to Microsoft Money's mmn file which contains the following info:

[Common]
Version=2000
StandAlone=0
[OFX]
Org=MFS_ORG
FID=MFS_FID
AcctListAvail=1
ClientActReq=0
BrokerID=MFS_BROKER_ID
OFXHeaderVer=102
FullSyncSupp=0
DisallowUSASCIIEncoding=0
DisallowUNICODEEncoding=1
DisallowUTF8Encoding=1
DisallowGenMail=1
DisallowPinChange=1
[SignOn]
Min=4
Max=32
Alpha=1
Numeric=1
Special=0
Spaces=0
ChangePin=0
TANRequired=0
[BankingCapabilities]
Bank=1
BankMail=0
IntraXferCanSched=0
CreditCard=0
DfltDays=1
IntraXferSupp=0
IntraSyncSupp=0
[BillPayCapabilities]
Pay=0
BillPayMail=0
DfltDaysWith=0
DfltDaysToPay=0
XferDfltDaysWith=0
XferDfltDaysToPay=0
IdDfltDaysWith=0
IdDfltDaysToPay=0
CountNonBusDays=0
PmtByAddr=0
PmtByXfer=0
PmtByPayeeID=0
DisallowRecPmt=1
DisallowCreditCardPmt=1
UseProcessDateModel=0
[InvestmentCapabilities]
BrkStmt=0
INVMail=0
DisallowInvTranDownload=1
DisallowOODownload=1
DisallowPositionDownload=1
DisallowInvBalanceDownload=1
[URLS]
OFX=https://pfmanagement.nationet.com/OFXSecurity/OFX_SSL_128.dll
SVCUPD=
[SubstituteComm]
SubcommCLSID=
ProvName=
SuppressPinDlg=0

But when I try to enter this information as a new Manual Online Banking connection I get this error:

Is there a log for MD which will show the full response from the server? What might be causing this?

Back to top

« Last Edit: Nov 25^th, 2007, 2:47pm by aspuzling »

IP Logged

Ash Administrator	Re: Nationwide (UK Bank) Reply #13 - Nov 29^th, 2007, 12:04pm Off topic replies have been moved to This Thread
Back to top	Visit the Moneydance Wiki WWW IP Logged

paulb

New Member

Re: Nationwide (UK Bank)
Reply #14 - Jan 2^nd, 2008, 2:32pm

Hi

I just switched from HSBC to Nationwide and I'd love to get this going.

HSBC would let me download QIF files, but Nationwide looks like it's CSV all the way. I've had a quick play with the Text File Importer. I have a problem though, I think because Nationwide puts debits and credits in separate fields and doesn't mark debits with a minus. Basically all amounts get imported as a credit.

I guess I could write a a bit of perl to munge the CSV file before importing. It would be pretty trivial. Does anyone using Nationwide have a better way ?

BTW - is the source for the Text File Importer available ? I'm always happy to tinker improvements together.

Back to top

IP Logged