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
-
An Post Money
The app holds 12 months of PDFs, with an annual statement sent by post.
-
Ulster Bank Ireland
No online banking since June 2025; copy statements come from Ulydien, free for closed accounts.
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.
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?
I banked with Ulster Bank. Can I still convert my statements?
Can I convert credit card statements?
Any bank, any country