Question 1

Does ExtractPro work with Irish banks?

Accepted Answer

Yes. These are the steps and file formats of three Irish banks, each taken from the bank’s own help pages. For AIB in the app, the steps are “Log in to the app” and “Tap ‘Statements’”, then tap the statement you want to download using “the download icon in the top right hand corner of the screen”. For AIB on the web, in AIB Internet Banking, “Click on Accounts, select Statements and Fees, and click on Statements”. AIB says your statement will be presented “in Adobe PDF format”. For Bank of Ireland, log in on the Bank of Ireland App, then “Tap an account to enter transactions screen” and “Select ‘Statements’”. Bank of Ireland says you can “Choose a statement to open or save to your device”, and that its electronic version of your account statement is “in PDF format”. For PTSB in the app, the steps are “Log in to the PTSB App”, “Select eStatements”, “Select the account you want to view” and “Select the statement you wish to download and click the download icon”. PTSB says you will be able to view your statement “as a PDF on your mobile device”. For PTSB in Open24 Online Banking, the steps are “Log in to your Open24 Online Banking”, “Select View more transactions”, “Select the Statements tab” and “Select View eStatements”. If what you downloaded is a PDF or an Excel file (.xlsx, .xls), upload it to ExtractPro and you get back an Excel file with one transaction per row.

Question 2

How far back can I get old statements, and how long do I have to keep them?

Accepted Answer

Each bank sets its own limit. AIB says that statements issued since 30 November 2011 “will be available to view for up to 7 years”. AIB says that those issued “prior to 30th November 2011 will continue to be available for a maximum of two years”. Bank of Ireland says your electronic statements “will remain visible online for 7 years for open accounts”, and that your account statements “remain available for 7 years after you close your account which can be ordered as duplicate statements”. PTSB says that statements “dated after March 2021 are available to view for up to 7 years from the statement issue date”. Revenue (revenue.ie) says that “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”.

Question 3

If my bank offers an export, when does converting the statement help?

Accepted Answer

When the period you need sits outside the window of the file you can export, or when what you have is the statement itself. AIB says “Historical Transactions enables you to export your transactions to a CSV (Comma Separated Variable) file”. AIB also says “Historical Transactions can display transactions from two years ago up to the previous business day”. For business customers, AIB says “Statements will display the last 6 months or a maximum of 180 days of transactions on IBB”. AIB’s business help adds “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 “you can export your transaction history as a CSV file using 365 online”, and its page on exporting transactions does not say how far back the file goes. PTSB’s help pages on statements describe how to view and save a statement, and do not describe an export of transactions. Xero’s page for Ireland says that, when setting up an automated bank feed, “you’ll be given the option to pull historical transaction data from the past 90 days or up to 2 years, depending on the bank”. If you have the statement for an earlier period, or one a client sent you, upload it as it is.

Question 4

How do I use the Excel file for bank reconciliation?

Accepted Answer

The ExtractPro Excel file has one transaction per row, with date, description and amount in separate columns (and the balance, when the statement shows it) and amounts as numbers. With the custom format you split amounts into two columns, debit and credit, and choose the column order, the date format and whether to download Excel or CSV. With that file you match each bank transaction against your records, in a spreadsheet or in your accounting software. Revenue’s guide to Self-Assessment (Tax and Duty Manual Part 41-00-28) lists, among the supporting records to retain, “bank and building society statements, cheque stubs”, so keep the original statement as well.

Question 5

Is my banking data secure?

Accepted Answer

Yes. We process your statements in memory and keep a copy for a limited time, in private storage, for support and to improve conversion; it isn’t shared with anyone. Because our copy is not an archive, keep the original statement file yourself: Revenue (revenue.ie) says that 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”.

Question 6

How many conversions can I do for free?

Accepted Answer

The Free plan includes 2 conversions per month, no card required: sign up with your email or Google account and convert straight away. For more volume there are paid plans, with no commitment. Paid plans are priced in US$, not in euros.

Question 7

How do I cancel? Is there a commitment?

Accepted Answer

No commitment. You cancel yourself from your account in under a minute: go to Account and select “Cancel subscription”. You keep the plan until the end of the period you’ve already paid for, then move to the free plan. No paperwork, no penalty. Cancelling does not affect the Excel files you have already downloaded, or the statements at your bank, which Bank of Ireland, for one, says “will remain visible online for 7 years for open accounts”.

Convert your bank statement to Excel for bank reconciliation

Secure

Built for firms

Accurate

How it works

Upload your statement

We organise it

Download the Excel file

What your Excel file contains

One transaction per row

Amounts as numbers

Dates as dates

Your file is not shared

Simple pricing

Starter

Professional

Business

Frequently asked questions

Supported banks

Ireland guides