API access
You will need to check with each institution if they provide an API for direct access. Some will provide access over a dial-up line, others have more modern IP based service. Each will likely require you to register and pay a fee.
Easier is to require the user to download their statement from the bank and import it into your application. Most online banking systems provide this functionality.
Formats
Either way, there are several formats supported by banks (taken from here).
- OFX (Open Financial Exchange)
- QIF (Quicken Interchange Format)
- CSV (Comma-Separated Variable)
You might see OFX referred to as Quickbooks, Microsoft Money 2005 or Sage Line 50. QIF is sometimes called Quicken 98 or 2000, or Microsoft Money 2003.
CSV formats will be propriety per institution and require parsing logic developed for each instance.
Who uses what format
The UK banks that support OFX or QIF formats are:
- Abbey (QIF, but not Abbey Business)
- Alliance and Leicester (OFX and QIF)
- Barclays (OFX)
- Clydesdale (QIF)
- Coutts & Co (OFX and QIF)
- First Direct (QIF)
- Halifax (OFX and QIF)
- HSBC (OFX)
- Lloyds (QIF)
- NatWest(OFX)
- Nationwide (OFX)
- Royal Bank of Scotland (OFX and QIF)
- Tesco (OFX and QIF)
- Yorkshire (QIF)