Allied Irish Banks (AIB) · Ireland

AIB Statement to Excel, CSV & Xero | AI Bank Statement

AIB keeps seven years of eStatements, and a current account statement may only come once a year unless you ask for more. Its CSV export covers two years. Here's how to get AIB statements, and how to turn AIB PDFs into Excel, CSV, Xero or QuickBooks data.

Last updated 14 October 2026

At a glance

Official statement format
PDF eStatements in Internet Banking and the AIB Mobile app
Statements online
Seven years from when each eStatement becomes available
Statement frequency
Annually by default for current accounts; free to change, up to monthly
Transaction export
CSV from Historical Transactions, covering the previous two years
Converts to
Excel (.xlsx), CSV, JSON, Xero CSV, QuickBooks 3- and 4-column CSV

How to download an AIB eStatement

In Internet Banking

  1. Click Accounts, select Statements and Fees, then Statements.
  2. Open the eStatement, which is a PDF you can save or print.

In the AIB Mobile app

  1. Log in and tap the account, or the three dots next to it.
  2. Tap Statements, then Account statements.
  3. Tap a statement, then the download icon at the top right.

Need a statement covering the last few weeks? Use Order a statement in the app or Internet Banking. It covers the period from your last statement to the day you order, and is usually ready by the next working day.

Things to know about AIB statements

  • One statement a year, by default. AIB's current account terms provide a statement annually on the account's anniversary unless you ask otherwise. A year of transactions in one PDF is a lot to retype. You can ask for statements up to monthly, free of charge.
  • Seven years online, but only while the account is open and you have online banking access.
  • Duplicates are free for personal accounts, and eStatements can be printed free of charge.

AIB's CSV export

In Internet Banking:

  1. Select Historical Transactions in the Accounts menu.
  2. Choose the account and filter the transactions if you wish.
  3. Click Export and open or save the CSV file.

Historical Transactions covers the previous two years. AIB notes that some data may display incorrectly depending on the software you open the file in. Business customers on iBusiness Banking can download filtered transactions as a CSV file with a published column layout.

For anything older than two years, a closed account, or a client's PDFs, convert the statements.

Converting an AIB PDF statement

  1. Upload one or more AIB eStatements. Batch upload handles a year of monthly statements at once.
  2. Pick the output: Excel, CSV, JSON, Xero CSV, or QuickBooks 3- or 4-column CSV.
  3. Download one transaction per row, with date, description, amounts and balance in separate columns.

Dates stay day-first and amounts stay in euro.

Getting AIB data into Xero or QuickBooks

  • Xero: choose Xero CSV and import it as a bank statement for the matching account.
  • QuickBooks: choose the 3- or 4-column CSV and upload it from file.

AIB credit card statements convert with the credit card statement converter.

Choose your output format

Frequently asked questions

How far back can I get AIB eStatements?

AIB says eStatements are available for seven years from the date they become available. You can't view them if the account is closed, the online banking agreement ends, or your access is removed, so save copies you need.

How often does AIB send current account statements?

Under AIB's current account terms, a statement is provided annually on the anniversary of opening the account, unless you ask otherwise. You can ask for statements more often, free of charge, up to monthly.

Can I export AIB transactions to Excel?

Yes, as CSV. In Internet Banking, select Historical Transactions in the Accounts menu, choose the account, filter if needed and click Export. Historical Transactions covers the previous two years.

Does AIB charge for duplicate statements?

AIB's personal fees guide lists duplicate bank statements under services with no charge, and eStatements can be printed free of charge.

Can I import a converted AIB statement into Xero or QuickBooks?

Yes. Choose Xero CSV or QuickBooks 3- or 4-column CSV as the output, then import it into your accounting software.

Is it safe to upload an AIB statement?

Statements show your IBAN and transaction history. Uploaded files are processed for conversion and automatically deleted immediately afterwards, as set out in our privacy policy.

More bank guides

Life's too short to retype a bank statement.

Upload one and see for yourself. Plans from $12 a month.

Secure checkout · instant access · files deleted right after processing