HSBC online transaction
chris
My understanding on the current unsupported banks page is that HSBC does not support OFX. I have a credit card with them, and I remember I can connect directly to HSBC online banking within Quicken. Does moneydance use a different protocol from Quicken?
Comments are currently closed for this discussion. You can start a new one.
Support Staff 2 Posted by Jessica Little on 02 Dec, 2010 03:04 PM
Hi Chris,
There are two methods that personal finance software can use to access your accounts: direct connect and web connect. With web connect, the software basically connects to your bank's website and downloads and imports OFX, QFX, QIF, and OFC files automatically. Direct connect actually connects to a server at your bank instead of their website and usually requires different login credentials than you would use to log into your banks website. Moneydance only supports automatic connections through direct connect and not web connect. You can still download OFX, QFX, QIF, and OFC files files from your bank and import them, but there's currently no way to do this automatically from within Moneydance.
Jessica Little
Moneydance Support
3 Posted by neville on 02 Dec, 2010 03:22 PM
Chris
As Angie states the download is via the web page and I have been using HSBC downloads for my credit cards since starting MD, but be careful HSBC only store recent transactions as OFX/QIF older statements can be downloaded I think as CSV. Therefore I update accounts regularly.
Regards
Neville
4 Posted by chris on 02 Dec, 2010 04:09 PM
Thanks to both of you. I usually update transactions a few times each month, thus it's a little bit annoying to have many duplicate downloads from HSBC (they don't support download of arbitrary date range thus each time I have to download everything after last statement).
Support Staff 5 Posted by Jessica Little on 03 Dec, 2010 03:16 PM
Hi Chris,
Are you downloading OFX or QIF files? If possible, you should grab the OFX files. Usually those have a transaction ID in them for each transaction, so Moneydance will be able to detect and merge duplicate transactions. QIF files do not h2ave transaction IDs, so you'll have to remove the dupes by hand.
Jessica Little
Moneydance Support
6 Posted by chris on 03 Dec, 2010 03:57 PM
Thanks Jessica. I think that I've used QIF. I'll try OFX next time.
7 Posted by Darren on 01 Jan, 2011 05:53 PM
Any prospect of getting direct connect running with HSBC in 2011?
Support Staff 8 Posted by Angie Rauscher on 02 Jan, 2011 08:50 AM
Darren,
We'd love to support direct connect with HSBC, but they still haven't implemented a direct OFX server. I'm sorry I don't have a more immediate fix,
Angie Rauscher
Moneydance Support
9 Posted by Darren on 02 Jan, 2011 07:26 PM
Angie, thanks for the response.
Some HSBC accounts offer .OFX, but it comes with the caveat "You have selected 'OFX' as your download format. It is only possible to view your current period of transactions with this format. If you wish to view previous transactions, you will need to select a different download format. (EU7)"
Internationally, HSBC seems inconsistent in its download options for both credit cards and checking.
My experience so far:
US cc:
Quicken Web Connect 2003+ .QFX
Quicken pre2003 .QIF
Microsoft Money pre2003 .OFC
Microsoft Money 2003+ .OFX
US checking:
Quicken windows .QFX
Quicken mac .QIF
Money .OFX
UK cc & checking:
Money 98 onwards .OFX
Money .QIF
Quicken 2002 .OFX
Quicken .QIF
CAN cc:
Quicken 2007 .QFX
Quicken 2000-2002 .QIF4
Microsoft Money 2003+ .OFX
Microsoft Money 2000-2002 .OFC
CAN check:
MS Money 2000 onwards .OFX
Quicken 2003 onwards .QFX
Quicken 2000-2002 .QIF
10 Posted by Darren on 06 Jan, 2011 02:53 PM
Angie, thanks for the response. I've looked at a few different HSBC accounts and some do have OFX. Here's a summary of what I've found.
US cc:
Quicken Web Connect 2003+ .QFX
Quicken pre2003 .QIF
Microsoft Money pre2003 .OFC
Microsoft Money 2003+ .OFX
US checking:
Quicken windows .QFX
Quicken mac .QIF
Money .OFX
UK cc & checking:
Money 98 onwards .OFX
Money .QIF
Quicken 2002 .OFX
Quicken .QIF
CAN cc:
Quicken 2007 .QFX
Quicken 2000-2002 .QIF4
Microsoft Money 2003+ .OFX
Microsoft Money 2000-2002 .OFC
CAN checking:
MS Money 2000 onwards .OFX
Quicken 2003 onwards .QFX
Quicken 2000-2002 .QIF
11 Posted by David Gleeson on 06 Jan, 2011 02:59 PM
Angie,
For some reason I can't post replies on the forum.
I have accounts with HSBC in UK, US, and Canada.
doesn't seem to be much consistency in how they offer download info, but here's what I've found - hopefully it's of some use to you.
regards,
US cc:
Quicken Web Connect 2003+ .QFX
Quicken pre2003 .QIF
Microsoft Money pre2003 .OFC
Microsoft Money 2003+ .OFX
US checking:
Quicken windows .QFX
Quicken mac .QIF
Money .OFX
UK cc & checking:
Money 98 onwards .OFX
Money .QIF
Quicken 2002 .OFX
Quicken .QIF
CAN cc:
Quicken 2007 .QFX
Quicken 2000-2002 .QIF4
Microsoft Money 2003+ .OFX
Microsoft Money 2000-2002 .OFC
CAN checking:
MS Money 2000 onwards .OFX
Quicken 2003 onwards .QFX
Quicken 2000-2002 .QIF
12 Posted by a9 on 06 Jan, 2011 03:29 PM
I have been downloading qfx files ("Quicken") with good success in Canada. Would my reconciliation process be made easier with the ofx ("Microsoft Money") files?
Support Staff 13 Posted by Jessica Little on 06 Jan, 2011 03:59 PM
Actually, QFX and OFX files are basically the same thing. Moneydance imports both of them just fine, and I don't think there's a particular advantage of one over the other. You may as well stick with the QFX download, since I imagine they'll stop offer the MS Money downloads at the end of the month when Money is no longer supported.
Jessica Little
Moneydance Support
14 Posted by jp on 03 Mar, 2011 10:43 PM
I would really like to be able to download transactions automatically from within MD for HSBC. Are there any plans in the future for MD to support web connect?
Also, if I would like to petition HSBC to support direct connect, for what specifically do I need to ask?
Support Staff 15 Posted by Jessica Little on 04 Mar, 2011 12:49 PM
Hi JP,
We do plan to add some kind of web connect support to a future version of Moneydance. It's too late in the 2011 release cycle to put it in there, but we do plan to have the feature included in MD 2012 at the latest (if not in a future release of 2011). I can't give a firm timeline at the moment, but we'll definitely let everyone know when it's ready.
Jessica Little
Moneydance Support
16 Posted by jp on 08 Mar, 2011 03:32 AM
Web connect is critical for simplifying my financial accounting. Right now I'm using mint.com (an Intuit product - which I hate) and I'm hoping to just use MD. I'll hope for web connect in 2011, but I will be very disappointed if I keep hoping until 2012 and it's not there. That's a long wait!
Support Staff 17 Posted by Jessica Little on 08 Mar, 2011 04:01 PM
Hi JP,
I definitely hear you on that one! This is by far our most requested feature. I'll likely be personally making sure it gets done as soon after 2011 is released as possible, since it's a feature I'd really love to see as well. Sean and I have already done a first design pass on this, so I'm very hopeful that it will make it into a future release of MS 2011, though I certainly can't say for sure at this point.
As a stopgap measure, the first release of MD 2011 will allow you to associate a webpage with an account and then open that webpage from within Moneydance. It's not automatic, but at least it should make it a little faster to download transaction files from your bank.
Thanks for your input, and thanks for your interest in Moneydance!
Jessica Little
Moneydance Support
18 Posted by breaghva on 02 Jan, 2012 07:15 AM
Happy New Year Jessica !
Any update on this? Do we need to drum up support, or is there a timeline?
Thanks,
Tony
Support Staff 19 Posted by Ben Spencer on 02 Jan, 2012 04:09 PM
It's in the pipeline and I am afraid that we cannot at this time provide a time line. There is no nee to drum up support this feature is a priority to the developers.
Ben Spencer
Moneydance Support
20 Posted by breaghva on 02 Jan, 2012 06:06 PM
Thanks Ben. I'll be grateful when it's done.
One suggestion to whichever developer picks up the burden. Assuming the input file is to be deleted after reading (should always be the case), it should be first overwritten to avoid leaving sensitive data on disk.
Thanks again
Tony
Scott Meehan closed this discussion on 22 Apr, 2013 02:18 AM.