Convert Bank of Ireland statements to Xero

About Bank of Ireland statements

Bank of Ireland is one of Ireland's oldest banks and you reach its statements through the 365 Online service. The file you want is the official statement PDF from 365 Online or the app, under Statements, not a printed mini-statement or a transaction search.

The part a copy-paste can't handle is the layout. Bank of Ireland writes each line as a short narrative — a 365 transfer, a direct debit, a card payment — with the amount 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. A scanned statement is no problem; it's read with OCR into the same layout, with the balance checked either way.

What lands in Xero is a clean, checked file — so the only thing left is the reconciling you'd do anyway.

Why people convert Bank of Ireland to Xero

Sometimes it's simplest to skip the Bank of Ireland 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 Bank of Ireland 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 Bank of Ireland 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

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