IE
About Permanent TSB statements
Permanent TSB is a smaller Irish retail bank and its online banking goes by the name Open24. The file you want is the official statement PDF from Open24 internet banking, under Statements, not a printed mini-statement or a transaction search.
The part a copy-paste can't handle is the layout. A Permanent TSB statement shows card payments, direct debits and SEPA transfers in the description, in euro, usually on a personal account. The converter reads all of that into its own columns instead of losing it.
Dates come through as DD/MM/YYYY and the figures stay in EUR (euro), so the converted file matches what you'd expect locally. A scanned statement is no problem; it's read with OCR into the same layout, with the balance checked either way.
After that you're just reconciling in Xero; the awkward part of getting the data out of the PDF is handled.
Why people convert Permanent TSB to Xero
Sometimes it's simplest to skip the Permanent TSB feed altogether — a one-off account, a client who won't share logins, a period the feed never covered. The converted file drops straight into Xero's Import a Statement screen and reconciles like any other month.
It's handy mid-year too, not just at catch-up. A one-off Permanent TSB account, a statement the feed skipped, or a closed account you still need on file — convert the PDF and it goes into Xero like any other import.
Import a Permanent TSB statement into Xero
Xero takes the CSV through its own Import a Statement screen.
- Convert the PDF above and download the Xero CSV.
- In Xero: Accounting → Bank accounts.
- Open the account, then Manage account → Import a statement.
- Upload the CSV — the date, description and amount columns line up.
- Reconcile the imported lines as usual.
The totals are checked first
Before the Xero-ready CSV downloads, the running balance is checked end to end. A missing or doubled line is caught at this step, not after it's already in Xero.
Frequently asked questions
How does a Permanent TSB statement get into Xero?expand_more
Yes — the CSV goes in through Xero's Import a Statement screen and the date, description and amount columns line up, so you go straight to reconciling. If Xero asks you to confirm the column mapping the first time, save it and later imports remember the layout.
What does a Permanent TSB statement look like?expand_more
A Permanent TSB statement shows card payments, direct debits and SEPA transfers in the description, in euro, usually on a personal account. The converter reads each of those into its own column, so the Xero-ready CSV imports into Xero cleanly.
Where do I download the Permanent TSB statement?expand_more
From Open24 internet banking, under Statements. Save the PDF, then drop it into the converter above — multi-page and multi-month statements are read in one go.
Does it work on a scanned Permanent TSB statement?expand_more
Yes. Scanned or photographed PDFs are read with OCR into the same columns, and the balance check still runs, so a scan converts the same as a digital download.
Do I have to pay up front?expand_more
Converting is free to start. Excel, CSV and JSON download with no login; the Xero file needs a free sign-in.