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
Online·Preparing offline mode…·
  • 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.

BankAllied Irish Banks, p.l.c.
Country Ireland
CurrencyEUR
Typical date formatDD MMM YYYY
Statements supportedCurrent account, Savings, Credit card, Business current account
Export toExcel, CSV, Xero, Sage, QuickBooks, OFX, QIF, JSON

How to download your AIB statement as a PDF

  1. Log in to AIB Internet Banking or the AIB Mobile app.
  2. Select the account and go to its eStatements.
  3. Choose the statement date you need.
  4. 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

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.

FAQ

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