Convert Your AIB Bank Statement to Excel & CSV

Why won't AIB just give me a CSV?

If you've gone digging around AIB Online Banking looking for an export button, you'll know the answer already: for a personal or current account, there isn't one. You can pick your account, pick the period, and download — but it only ever comes out as a PDF. No CSV, no Excel, nothing you can drop straight into a spreadsheet.

It's a bit mad when you think about it — the bank clearly has the transaction data sitting there, they just don't hand it to you in a usable format. That's the whole reason this page exists. Upload the PDF you already have, and we'll turn it into a proper spreadsheet for you.

Personal account or Business account? It matters here.

Most people land on this page with a personal or current account statement, and for that, it's PDF-only, full stop — the converter below is your only route to Excel or CSV.

If you're on AIB Business Online, though, you're actually a bit better off — there's a native CSV export sitting under Transaction History. It'll do the job if all you need is a bare CSV. But if you want it properly formatted — clean headers, sensible columns, something you can hand straight to Xero, QuickBooks or Big Red Cloud without touching it — converting the PDF here will still get you a tidier result.

How it works

1. 1

   Download your AIB PDF statement. In AIB Online Banking or the app, pick the account and the period, and download it the usual way.

2. 2

   Upload it above. It's processed in memory only — nothing is saved to a server, Zero-Retention Protocol, start to finish.

3. 3

   Download your Excel or CSV file. Date, Description, Debit, Credit, Balance — laid out properly and ready to use.

Built around how AIB actually formats a statement

This isn't a generic PDF-to-Excel tool that happens to work on AIB statements — it's built around the way AIB actually lays them out. Dates come through as DD/MM/YYYY, the way they should, instead of getting silently swapped into the American MM/DD format the way a lot of generic converters do. Debit and Credit stay in their own columns, with the running balance carried alongside, exactly as it appears on the statement.

Everything comes out in euro, obviously, and the output is clean enough to drop straight into Xero Ireland, QuickBooks, Big Red Cloud or Surf Accounts without any reformatting. If what you're really after is something to hand to your accountant, or to have ready for a Revenue or ROS submission, this gets you there without an evening lost to manual data entry. Scanned or photographed statements work too, not just the digital ones — the OCR handles both.

Who actually uses this

Sole traders use it to turn a stack of monthly AIB statements into proper records for their Revenue return, without typing out a single transaction by hand.

Bookkeepers and accountants use it to get client AIB statements into a format their existing tools already accept — no re-keying, no cleanup pass afterwards.

Small business owners use it to line up business and current account statements side by side for reconciliation, instead of retyping everything into a spreadsheet manually.

AIB is just one of the Irish banks we handle — if you bank with Bank of Ireland, Permanent TSB, or another Irish bank, you'll find the same PDF-only problem, and the same fix, on our Ireland page.

Questions people actually ask