Compatible Bank Statement Files
Find your Bank Statement file format
Most popular online banking file formats used by major international banks are compatible. Using these standard supported formats will allow you to import your bank file, without amendment, directly into the Bank Reconciliation system.
To check which Bank Statement file formats your bank uses, go to the area of the online banking system for downloading statement transactions. A list of available download file formats should be available. Alternatively, check your bank’s website or contact them directly.
The file format you can use will vary. To find out which file format will work, extract all possible file formats, and import them one by one into AIQ under Import Transactions in the Import Bank Statement option.
Supported formats
AccountsIQ supports generic formats:
- QIF (Quicken Interchange Format)
-
OFX (Open Financial Exchange)
AccountsIQ supports specific file formats:
- AIB Ireland
- Bank of Ireland
- Barclays
- CODA
- Lloyds Bank
- OCREX
-
Ulster Bank
Unsupported formats
If your format is not in the list above, see if your online banking system lets you create a CSV (comma-separated values) file. Most banks have this as a backup facility. With minor adjustments, the system will accept it.
See:
Bank Feeds (6B.1) - AIQ Academy
