Convert AIB statements to Xero

About AIB statements

AIB (Allied Irish Banks) is one of the two main Irish retail banks and a familiar name on most high streets in Ireland. You grab the statement PDF from AIB Internet Banking, under Statements — same as you would for any branch-based account.

The part a copy-paste can't handle is the layout. An AIB statement carries SEPA references and, on transfers, the counterparty's IBAN inside the Details column, all in euro. The converter reads all of that into its own columns instead of losing it.

You keep EUR (euro) amounts and DD/MM/YYYY dates end to end, so nothing needs re-checking after the import. Scanned or photographed PDFs work too: OCR reads them into the same columns, and the running balance is checked before anything downloads.

You end up with a file Xero accepts on the first try, with the PDF-wrangling taken care of before it gets there.

Why people convert AIB to Xero

If you're catching up a set of books in Xero, or onboarding a client, you'll have AIB PDFs that never came through a feed. Converting them gives you an Import a Statement file for each gap, so the history lines up without manual entry.

It also saves the back-and-forth at year end. Instead of asking a client for a CSV their AIB login may not even offer, you take the PDF they already have and convert it, so the numbers in Xero match the statement line for line.

Import an AIB statement into Xero

Xero takes the CSV through its own Import a Statement screen.

1. Convert the PDF above and download the Xero CSV.
2. In Xero: Accounting → Bank accounts.
3. Open the account, then Manage account → Import a statement.
4. Upload the CSV — the date, description and amount columns line up.
5. Reconcile the imported lines as usual.

The totals are checked first

The totals are checked before you download. If a row is missing, the statement gets flagged right here — so a gap shows up before it reaches Xero or your client, not after.

Frequently asked questions