Convert AIB statements to Excel & CSV
Turn Allied Irish Banks, p.l.c. PDF statements into clean spreadsheets or accounting imports in seconds. The conversion runs on your device, so your AIB statement is never uploaded.
Drop AIB bank statement PDFs here
or choose files · multiple files OK · scanned PDFs & photos supported
Select PDF statements- 🔒 Never uploaded
- ∞ Free & unlimited
- ✓ Balance-checked
- Your PDF never leaves your device
- Unlimited pages, no signup
- Works offline
- Every row balance-checked
AIB statement format at a glance
Date, Details, Debit, Credit and Balance columns in euro, with the date typically printed once per day and longer details wrapping onto extra lines.
| Bank | Allied Irish Banks, p.l.c. |
|---|---|
| Country | Ireland |
| Currency | EUR |
| Typical date format | DD MMM YYYY |
| Statements supported | Current account, Savings, Credit card, Business current account |
| Export to | Excel, CSV, Xero, Sage, QuickBooks, OFX, QIF, JSON |
How to download your AIB statement as a PDF
- Log in to AIB Internet Banking or the AIB Mobile app.
- Select the account and go to its eStatements.
- Choose the statement date you need.
- Download the PDF.
Menu names change from time to time. If you can’t find statements, search your online banking help for “e-statements”.
Tips for converting AIB statements
- Irish statements put the day before the month. When exporting, choose DD/MM/YYYY or YYYY-MM-DD so that 03/04 isn't read as 4 March by software set to US date order.
- If your spreadsheet uses a European locale (decimal commas), export XLSX rather than CSV. XLSX stores real numbers, so 1,250.00 can't be misread as one and a quarter.
- Rows without a date belong to the last date printed above them. Check the preview after any page break, where a missing date is easiest to overlook.
Helpful guides
- PDF statement to Excel: every method compared
- Import AIB transactions into QuickBooks
- Import AIB statements into Xero
- Reconcile a bank statement in Excel
How the conversion stays accurate
When your AIB statement prints a running balance, pdf2statement replays every transaction against it and compares opening balance + money in − money out with the closing balance. Rows that don’t reconcile are highlighted before you export, which catches the classic problems of manual copy-paste: missed lines, merged descriptions and flipped signs.
AIB statement conversion FAQ
Can I convert AIB eStatements to Excel?
Yes. Download the eStatement PDF from Internet Banking and open it in the converter. The Debit and Credit columns can be kept separate or combined into one signed Amount column before you export to XLSX or CSV.
Why do my AIB dates look wrong after opening a CSV in Excel?
Excel reads CSV dates using your computer's regional settings. If those are set to US order, day and month get swapped. Export as XLSX, or choose the YYYY-MM-DD date format, which every locale reads the same way.
Is it safe to convert my AIB statement here?
Yes. Your AIB PDF is converted inside your own browser and never uploaded, so pdf2statement never receives your account number, balances or transactions. You can confirm this by converting with your internet connection switched off.
Can I convert AIB credit card statements too?
Yes. Credit card statements are detected automatically. Purchases become money out and payments or refunds money in, and you can export a credit card OFX/QBO for accounting software.
Other banks in Ireland
Convert your AIB statement now
Free, unlimited and private. No signup, no upload, no catch.
Choose PDF statements