Westpac OFX/QIF export to MS Money a joke
Having moved to Australia and opened Westpac accounts, I thought it was time I tried importing my statement data into MS Money 2005. Yes, it’s old, and even Nationwide UK have stopped supporting it, and whenever I break both my legs in a freak snowboarding accident, I’ll have the time at home to get round to finding a new program. In the meantime, Nationwide works fine (although now via MT2OFX), Amex works great! (single download for multiple accounts direct to OFX, auto-identifies each account, everything just works)… and it’s time to add Westpac to the mix.
Which turns out to be a pain.
Westpac do have a specific ‘export’ tab, and it has multiple formats listed. But both QIF and OFX, and any others that I can see for that matter, simply put all the details of the transaction into the Memo field. That’s native to the exported data itself – nothing to do with MS Money. So, there’s no Name for the transaction whatsoever, and thus little for Money’s automatic handling of future transactions (based on the Name) to go on.
Here’s the OFX (which is an XML-based format):
<STMTTRN><TRNTYPE>POS<DTPOSTED>20110317000000<TRNAMT>-5.50<FITID>201103170003<MEMO>WITHDRAWAL BY EFTPOS 0022202 STARBUCKS TRANSPORT HOUSE SYDNEY NS 16/03
As you can see, all the detail is in one Memo field: no Name field at all. Painful.
So – Westpac. #fail on you. I know MS Money is outdated, but it seems this would be true for any financial app – you just drop everything in one field, and probably hope that the application will be able to figure things out for itself.