Irish bank statements into Excel and CSV

Irish banks export a year or two of transactions at most, but keep eStatements for longer, and a mortgage application asks for statements anyway. Add Ulster Bank, whose former customers now rely on saved PDFs and copies from Ulydien, and most of the history people need is in PDF form. Pick your bank, or upload a statement.

Currency
Euro (EUR)
Date order
Day first, DD/MM/YYYY
Money columns
Debit, credit, balance
Common imports
Xero, Sage, QuickBooks Online

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.

Banks

Irish banks and what their statements do

Pillar banks 3

  • AIB

    Historical Transactions exports two years as CSV; eStatements stay available for up to seven.

  • Bank of Ireland

    365 online exports 12 months, and credit card transactions not at all; eStatements stay seven years.

  • PTSB

    eStatement access ends when an account closes, so save the PDFs before switching banks.

App accounts and closed banks 2

Statement layout

What Irish statements look like

Debit and credit columns in euro

Statements print debits and credits in separate columns beside the balance, and amounts with a euro sign or comma separators paste into Excel as text. Each row comes out with one signed amount as a plain number.

SEPA and card details on extra lines

SEPA transfers and card payments often wrap onto a second line, and AIB adds codes such as VDP, VDC and VDA for Visa debit activity. Wrapped lines are joined into one description and the codes stay in it, so card spending filters apart from transfers.

Archives from several sources

Older history is often a mix of downloaded eStatements, browser Print to PDF copies, scans of An Post Money's annual statement and copies ordered from Ulydien. All of them convert; a PDF with its text intact reads better than a scan.

Output and review

What you download, and what's checked

You get rows of date, description, signed amount and balance in Excel, CSV or JSON, or in CSV layouts for Xero and QuickBooks. The running balance is checked from opening to closing. Signed in, upload several years of statements for one account and missing, duplicate or overlapping periods are flagged, which tells you which copies to request.

Benchmark vs free tools

Xero, Sage and QuickBooks

  • Xero

    Xero imports the Xero CSV through its manual statement import, where Date and Amount are the only required columns, and remembers your mapping afterwards.

    Step-by-step import guide
  • Sage Accounting

    Sage's three-column CSV import reads Date, Description and Amount, the same layout as the QuickBooks CSV.

  • QuickBooks Online

    Upload the QuickBooks CSV to the bank account and match its three columns during the upload.

    Step-by-step import guide

FAQ

Questions about Irish bank statements

My bank's export only covers a year or two. Where does older history come from?
From eStatements. AIB and Bank of Ireland keep up to seven years, and Bank of Ireland keeps a closed account's statements for seven years after closing. PTSB ends access on closing, so download everything first.
I banked with Ulster Bank. Can I still convert my statements?
Yes. Upload the PDFs you saved and any copies from Ulydien, which provides copy statements for up to seven years without a fee for closed accounts. The period check then lists the months still missing.
Can I convert credit card statements?
Yes. At Bank of Ireland it's the only way to get card transactions into a spreadsheet, since 365 online can't export them. Each purchase becomes a row with a signed amount.

Any bank, any country

Bank statement converter