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.

The 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 (more below). 

If you would like a specific format supported, please contact our support team.

See:

Generating Bank Statement Files (Online Banking) 

We regularly add support for other bank formats. Contact your local support team for further assistance. 

The following are the currently supported bank files:

• AIB (.EMTS)
• AIB Multi-Currency (.XML)
• ANZ Online (.ABA)
• BACS – UK (e.g., Barclays)
• Bank Of Ireland
• Bank of Ireland BACS UK
• Bank Of Ireland EFT
• Bank Of Ireland SEPA
• Bank Of New Zealand (.AFI)
• Bank Of Scotland - COL Bacs (Multiple Payment)
• Barclays.NET
• Bendigo (.ABA)
• CBA (.ABA)
• Citibank Cross Border Funds Transfer (GDFF)
• Citibank Cross Border Funds Transfer (CDFF)
• Citibank Domestic Funds Transfer (CDFF)
• Citibank SEPA Credit Transfer - Individual Debit (CDFF)
• Citibank UK ACH Credit/BACS (CDFF)
• Citibank UK Faster Payments - Single Immediate (CDFF)
• Citibank US ACH Credit (USFF)
• Citibank US ACH Credit (USFF) with Addenda Information
• Citibank US Funds Transfer (USFF)
• Generic Export JSON Format (.JSON)
• Generic Export XML Format (.XML)
• HSBC Asia Pacific, ACH (via iFile)
• HSBC Asia Pacific, Priority Payment (via iFile)
• HSBC Net (.TXT)
• HSBC Net PP/HVP (.XML)
• Lloyds BACS
• Lloyds BACS v2
• Lloyds Commercial Banking - BACS
• MUFG (.CSV)
• NAB (.ABA)
• NatWest (.TXT)
• NatWest Bankline International Payment (.TXT)
• NatWest Standard Domestic Payment (.TXT)
• On Pay
• PTX – Bottomline
• RBS Bankline, Ad Hoc Bulk Payment 
• Santander BACS (.TXT)
• SEPA
• Splitska Banka SEPA (.XML)
• St George (.ABA)
• Ulster Bank with IBAN & BIC
• Ulster Bank, RBS
• Westpac (.ABA)

Adding a Payment File

1. To set up a bank account go to Bank > Bank List > Add New Bank. If your account is already set up, click A/C Details. 
   
   

   Info: Our New Look

   If you are using our new look navigation, Bank Accounts can be found in the Bank tab in the new sidebar:

   

   
    

    
2. In Payments File Settings, under Type, select the appropriate format for your company and country.
3. Click Save. 
   
   

See:

Setting up a Bank Account 

Using Generic Bank Payment File Formats