Bank of Ireland Statement to Excel Converter

What does a Bank of Ireland statement layout look like?

Bank of Ireland statements often use Date, Details, Withdrawn, Lodged, and Balance columns. The Withdrawn and Lodged labels need to be mapped into standard debit and credit fields before the file is useful for accounting import.

ClearlyLedger detects the BOI layout and exports rows into a consistent Excel or CSV structure while preserving transfer and counterparty details.

How are 365 Online transfers and stamp duty rows handled?

BOI 365 Online transfer descriptions, SEPA rows, card payments, maintenance fees, and annual debit-card stamp duty need to remain reviewable as separate transactions.

The Bank of Ireland profile keeps these details intact and handles date formats that cross a calendar-year boundary without assigning rows to the wrong year.

Which export should I use for Irish bookkeeping and lender review?

Use Excel when reviewing BOI statements for Revenue support, annual accounts, mortgage applications, property rental records, or bookkeeping cleanup. Use CSV when importing into Xero Ireland, Sage, QuickBooks Online, or another ledger.

ClearlyLedger verifies that extracted rows reconcile to the printed balance before export, reducing the risk of silent page-break or sign errors.

Bank of Ireland source profile used by this guide

Printed statement structure: PDF with Date, Details, Withdrawn, Lodged, Balance

Source conventions: DD MMM YY dates, € EUR amounts, and 3–10 pages.

BOI observations to sample during review

• Founded by royal charter in 1783, Ireland's oldest bank, and — unlike AIB and Permanent TSB — avoided majority Irish-government ownership during the 2008-11 financial crisis, repaying its state support without the state taking a controlling stake
• Uses 'Withdrawn' / 'Lodged' instead of Debit/Credit — column auto-mapped
• 365 Online transfers identified by '365' prefix in Details
• Stamp duty on debit cards appears as a yearly lump-sum line, not per-transaction
• Statement period straddles calendar year end — year must be inferred per row

These BOI details identify the rows most likely to need inspection after extraction. Review the first and final transaction, each PDF page boundary, and any row affected by the observations above before using the spreadsheet in an accounting import.

Related workflows

Continue from this guide into the matching converter, accounting import, security, or country hub pages so crawlers and readers can follow the full workflow.

• Ireland bank statement converter
• Bank of Ireland converter page
• AIB statement guide

Frequently asked questions

How do I convert a Bank of Ireland statement to Excel?

Upload the Bank of Ireland PDF to ClearlyLedger. The BOI format is detected automatically, Withdrawn and Lodged columns are normalized, the balance is verified, and the statement is exported to Excel.

Can I convert Bank of Ireland statements to CSV?

Yes. ClearlyLedger exports BOI transactions to CSV with date, description, reference, debit, credit, and balance columns for accounting imports and reconciliation.

Does it handle 365 Online transfer references?

Yes. BOI 365 Online, SEPA, card, and transfer narration are preserved where possible so references remain useful after conversion.

Does it keep Irish stamp duty rows separate?

Yes. Annual stamp duty and fee rows are preserved as their own transactions instead of being merged into unrelated activity.

Related ClearlyLedger resources

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

• Support
• Import statements into QuickBooks
• Import statements into Xero
• BankStatementConverter alternative
• ClearlyLedger vs DocuClipper
• ClearlyLedger vs MoneyThumb
• PDF bank statement to Xero
• PDF to CSV converter
• Batch statement conversion