Which bank statement formats does FreeAgent support?
FreeAgent uses electronic statement data to help you track money in and out of your business. It accepts electronic statements in one of three formats:
- OFX (Open Financial Exchange)
- QIF (Quicken Interchange Format), which is an older format
- CSV (Comma-Separated Variable), for some other banks that don't support OFX or QIF.
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.
The UK banks that support OFX or QIF formats are:
- Alliance and Leicester (OFX and QIF)
- American Express (OFX and QIF)
- Barclays (OFX)
- Cater Allen Private Bank (OFX)
- Clydesdale (QIF)
- Coutts & Co (OFX and QIF)
- First Direct (QIF)
- Halifax (OFX and QIF)
- HSBC (QIF)
- Lloyds (QIF)
- NatWest (OFX)
- Nationwide (OFX - full statement)
- Royal Bank of Scotland (OFX and QIF)
- Santander (QIF)
- Tesco (OFX and QIF)
- Yorkshire (QIF)
We support CSV downloads for the following banks:
- Co-operative Bank (Business Banking only)
- NatWest Bankline
- Paypal Business
In certain circumstances you may need to create or edit a CSV file of bank transactions to upload into your FreeAgent account.