Convert AIB bank statements to Excel or CSV
AIB customers can export a CSV from Historical Transactions, but only for the previous two years. eStatements stay available for up to seven, so anything older, such as an earlier tax year or a mortgage application asking for history, comes from the PDF. If you'd rather have those statements as rows in Excel or CSV than pages to retype, start here.
Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.
Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your AIB statement into Excel
-
Download the PDF statement from AIB online banking
- Log in to AIB Internet Banking.
- Click on Accounts, select Statements and Fees, and click on Statements.
- Choose the account and statement date; AIB presents the eStatement in Adobe PDF format (in the app, tap the download icon).
- Save the statement for the period you need as a PDF.
-
Upload it here
Scans and phone photos work too.
-
Download Excel, CSV, or QuickBooks and Xero CSV
Check the rows against the statement, then export.
Sample result
Your AIB statement in Excel
Made-up sample rows, not a real statement.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | Card payment - Fictional Coffee Co | 15.00 | 2,385.00 |
Statement notes
What to know about AIB statements
Two years of CSV, seven of PDFs
Historical Transactions goes back two years and exports a CSV for a current account or credit card. eStatements cover up to seven years. When the period you need falls between those two limits, the eStatement is the only digital record, and converting it gives you the same kind of rows the export would have.
SEPA and card details on extra lines
Card and SEPA transfer details on AIB statements often wrap onto extra lines under the transaction. Pasted into a spreadsheet, one payment becomes two or three rows. The conversion joins those lines into a single description, so each payment keeps its date and amount on one row.
Euro amounts Excel can add up
Amounts printed with a euro sign or comma thousands separators often paste into Excel as text that won't sum. In the output they are plain numbers. Debits and credits, which AIB prints in separate columns beside the balance, become one signed amount per transaction.
Visa debit codes in the narrative
The statement narrative uses short codes for card activity: VDP for a Visa debit purchase at a point of sale, VDC for a contactless payment and VDA for a withdrawal at a non-AIB ATM. They stay in the description after conversion, so a filter in Excel separates card spending from transfers and direct debits.
Output and review
From AIB PDF to your books
Accounting tip
Xero takes the Xero-ready CSV through its manual bank statement import, where Date and Amount are the only required columns and money out is a negative amount. After the first import Xero remembers how you mapped the columns, which saves time when you're loading several years of statements.
-
Checked before export
Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.
-
Export formats
Excel, CSV, JSON, or QuickBooks and Xero CSV.
-
Private workspace
HTTPS uploads, kept private until you ask support to delete them.
FAQ
AIB statement questions
How do I get AIB transactions older than two years into Excel?
Does AIB's export include credit card transactions?
Can I import converted AIB rows into QuickBooks or Xero?
Convert your AIB statement to Excel
Page 1 free, no sign-up to see it; just an email to download.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by AIB.