Bank of Ireland Statement to Excel Converter

Converting Bank of Ireland Statements to Excel

A Bank of Ireland statement gives you a clear record of an account, but it is a document, not a dataset. To total a year of rent, check what a direct debit cost over twelve months or hand transactions to an accountant, you need each line in a spreadsheet with the amounts in proper columns. Finlyzers converts the PDF into Excel or CSV and checks the result against the statement's own running balance.

How a Bank of Ireland Statement Is Usually Laid Out

Layouts change from time to time, but a typical current account statement in the Republic of Ireland has:

• Header: account name and address, statement period, IBAN and BIC, and the National Sort Code (NSC) and account number.
• Transaction table: columns typically labelled Date, Transaction details, Payments out, Payments in and Balance, in euro.
• Opening and closing balances: the balance brought forward appears at the start and the closing balance at the end. These are balances, not transactions, and are left out of the transaction list.
• Descriptions: direct debits and standing orders are commonly marked with D/D and S/O, and card payments usually show the merchant name, sometimes with a short prefix and date.

The converter keeps the description text as printed, so you can still search or filter by payee or payment type once it is in Excel.

Why Copy and Paste Goes Wrong

Selecting the table in a PDF viewer and pasting it into Excel usually puts each line into a single cell, or splits it at every space. Amounts in the payments out and payments in columns lose their position, so it is no longer clear which are debits. Excel may also read 03/10 as 10 March if your computer uses US settings. Converting the PDF avoids all of this and gives you numbers, not text.

Three Situations Where a Spreadsheet Helps

Year-end for a sole trader or small company. Accountants preparing a Form 11 or company accounts often receive a year of statements as PDFs. Converting them gives one sortable list that can be categorised, or imported into Xero, Sage or QuickBooks to fill gaps where the bank feed does not reach.

Managing a rental property. If rent from tenants is paid into a Bank of Ireland account, a spreadsheet makes it easy to total rent received and pull out repairs, insurance, management fees and mortgage interest for your rental income figures. A tenant's statement can also be converted if they share it as proof of rent paid.

Applying for a mortgage or loan. Irish lenders commonly ask for several months of current account statements. Reviewing them in Excel first lets you see regular outgoings, spot anything a lender might ask about and confirm your savings pattern.

Choosing an Output Format

• Excel for review, categorising and pivot tables.
• CSV for Sage, Google Sheets or any software where you map the columns yourself.
• QBO for QuickBooks Online or Desktop.
• OFX for Xero and other tools that import bank statement files.

When importing, set the date format to day-month if your software asks, so dates such as 03/10 are read as 3 October.

Northern Ireland Accounts

Bank of Ireland also operates in Northern Ireland, where accounts are held in sterling with UK sort codes. Those statements can be converted the same way. For context on how a large UK bank lays out its statements, see the Barclays statement converter.

If you have accounts with more than one Irish bank, the AIB statement converter handles AIB's layout, and the two downloads can be combined in one workbook.

Converting a Bank of Ireland credit card statement? Use the credit card converter. For paper statements you have scanned or photographed, try the scanned statement converter.