Irish bank statements to Excel

Below, the statement help of AIB, Bank of Ireland and PTSB sits side by side, in the banks’ own words, followed by links to the 3 Irish banks that have a page on ExtractPro. Save a statement as a PDF, upload it, and an .xlsx workbook comes back with one row for each transaction: date, description and amount in separate columns, a balance as well when the statement shows it, and every amount stored as a number that Excel can total.

What each bank says about its statements

• AIB: “eStatements are in PDF format so you have the option of saving them locally on your PC, if you would like to maintain a file of your banking records at home” and “With effect from 30th November 2011, all newly issued bank account eStatements on AIB Internet Banking will be available to view for up to 7 years”. For earlier ones it says “Bank account eStatements issued prior to 30th November 2011 will continue to be available for a maximum of two years”.
• Bank of Ireland: “An eStatement is an electronic version of your account statement in PDF format. This means you can view, print and download it whenever you like.” and “Your eStatements will remain visible online for 7 years for open accounts. Your account statements remain available for 7 years after you close your account which can be ordered as duplicate statements.”
• PTSB: “You will be able to view your eStatement as a PDF on your mobile device or save to another app or location.” and “eStatements dated after March 2021 are available to view for up to 7 years from the statement issue date.”

Source: AIB, guide to online statements, www.aib.ie/ways-to-bank/estatements-persil-guide; Bank of Ireland, online statements, personalbanking.bankofireland.com/ways-to-bank/online-banking/e-statements/, and viewing statements, www.bankofireland.com/help-centre/faq/estatements-can-view/; PTSB help, how do I view statements, www.ptsb.ie/help-and-support/help-with-banking/estatements/how-do-i-view-estatements/, and how to read your statements, www.ptsb.ie/help-and-support/help-with-banking/estatements/how-to-read-your-estatements/. All accessed 10 October 2026.

Every bank quoted here names the PDF. AIB, Bank of Ireland and PTSB each have their own guide to the download, step by step.

Where a bank’s export ends and a statement carries on

AIB says “Historical Transactions enables you to export your transactions to a CSV (Comma Separated Variable) file.” and “Historical Transactions can display transactions from two years ago up to the previous business day.” For its business customers in iBusiness Banking, AIB gives “Statements will display the last 6 months or a maximum of 180 days of transactions on IBB.” and, for the export, “NB: While there will be six months of information available to export, you can only export a maximum three months at a time.” Bank of Ireland says “Alternatively you can export your transaction history as a CSV file using 365 online.”, and the page on that export gives no period for the file. For PTSB, the help pages that deal with statements stop at viewing and saving them, and they leave an export of transactions out. Past the ranges above, or when a statement is all a client sent, the statement is the document to convert. Source: AIB, Historical Transactions FAQs, www.aib.ie/help-and-guidance/historical-transactions-faqs; AIB Business help centre, viewing statements, www.aib.ie/business/help-centre/manage-my-accounts/how-do-i-view-my-statements, and exporting statements or transaction history, www.aib.ie/business/help-centre/manage-my-accounts/how-do-i-export-my-statements-transactions; Bank of Ireland help centre, exporting transactions, www.bankofireland.com/help-centre/faq/can-i-make-changes-to-transactions-on-my-estatements/. All accessed 10 October 2026.

Why six years matters

Revenue tells businesses: “If you run a business, you must keep certain records for tax purposes.” and “You must keep the original of these documents for six years.” Its guide to self-assessment names among the supporting records “invoices, bank and building society statements, cheque stubs, receipts, rent books, etc.” Set that against the banks above: AIB quotes 7 years for statements issued from 30 November 2011 and a maximum of two years for earlier ones, Bank of Ireland quotes 7 years for an open account and 7 years after it is closed, and PTSB quotes 7 years for statements dated after March 2021. Source: Revenue, Keeping records, www.revenue.ie/en/starting-a-business/starting-a-business/keeping-records.aspx, and A Guide to Self-Assessment (Tax and Duty Manual Part 41-00-28), www.revenue.ie/en/tax-professionals/tdm/income-tax-capital-gains-tax-corporation-tax/part-41/41-00-28.pdf, accessed 10 October 2026.

The 3 Irish banks on ExtractPro

Follow a name to the page that bank has on ExtractPro, which answers the common questions about its statements.

• AIB
• Bank of Ireland
• PTSB

From the statement to a spreadsheet

Whichever bank issued it, and however it reached you (an app, online banking, an email or a client), the statement goes through these three steps:

1. 1Upload the PDF exactly as you saved it from the bank. If it is password-protected, enter the password at the upload step; the file is unlocked in your browser.
2. 2ExtractPro reads the transactions in the statement and gives each one a row.
3. 3Download the .xlsx: date, description and amount in separate columns, every amount stored as a number, and the balance as well when the statement shows it. The custom format writes a CSV instead.

Should the file go on to Xero, the Xero guide lists the custom format options to choose. Rely on a conversion only when the last balance in the workbook matches the closing balance on the statement and the rows add up to the transactions that the statement lists.

Frequently asked questions

The questions that come up most: