Bank of Ireland Statement to Excel Converter

ClearlyLedger converts Bank of Ireland (Ireland) PDF statements into clean Excel and CSV files. This guide covers the common BOI pdf layout, DD MMM YY dates and EUR amounts. Exports are released only when verification checks pass. Most BOI statements (3–10 pages) finish in under 60 seconds with no signup required for your first file.

Last updated 2026-09-03

What does a BOI statement PDF look like?

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

Date notation: DD MMM YY. Money notation: € EUR. Observed statement size: 3–10 pages.

Depending on the country, amounts may use a comma decimal and period thousands separator (1.234,56); the locale is detected before parsing so credits and debits are never swapped.

What fields does Bank of Ireland print on each transaction row?

The profile uses the bank-specific observations below as review checkpoints. They describe the source document rather than making a generic promise about every PDF:

  • BOI checkpoint 1: 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
  • BOI checkpoint 2: Uses 'Withdrawn' / 'Lodged' instead of Debit/Credit — column auto-mapped
  • BOI checkpoint 3: 365 Online transfers identified by '365' prefix in Details
  • BOI checkpoint 4: Stamp duty on debit cards appears as a yearly lump-sum line, not per-transaction
  • BOI checkpoint 5: Statement period straddles calendar year end — year must be inferred per row

How do I check a BOI conversion before using it?

A typical Bank of Ireland file runs 3–10 pages. Confirm its DD MMM YY dates, EUR signs, first and final transactions, and page boundaries. Balance review is especially important on this layout. 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. The PDF remains the source; the spreadsheet is the reviewable working copy.

  1. Upload the Bank of Ireland PDF.
  2. Inspect the documented BOI row patterns.
  3. Reconcile the EUR transaction math.
  4. Download verified BOI Excel or CSV data.

Which accounting tools accept BOI Excel or CSV files?

Excel suits source-document review and coding. CSV suits mapped imports into Xero, QuickBooks, Sage or Surf Accounts. Those routes preserve the DD MMM YY interpretation and EUR values established from the Bank of Ireland source.

Is my BOI statement data kept private?

The BOI PDF is processed in memory and deleted after conversion. The BOI transaction data is not used to train AI models. TLS protects the upload in transit, while the workflow is designed around the EU GDPR for Ireland account holders.

BOI conversion FAQ

Which BOI statement layouts can ClearlyLedger convert?

Bank of Ireland statements typically arrive as PDF with Date, Details, Withdrawn, Lodged, Balance. ClearlyLedger's BOI profile reads that layout, plus scanned and password-protected exports, and reconstructs Date, Description, Debit, Credit and Balance columns.

How does ClearlyLedger handle BOI-specific quirks?

This guide highlights common BOI statement characteristics — for example: 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. The conversion is released only after its verification checks pass.

Can I import a converted BOI statement into Xero?

Yes. Export to CSV and import into Xero, QuickBooks, Sage or any tool that accepts a transaction file. The DD MMM YY dates and EUR amounts are normalised so the import maps cleanly.

Related ClearlyLedger resources

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

Loading interactive converter… Try ClearlyLedger free