Convert Permanent TSB (Open24) Statements to Excel

Permanent TSB is an Irish retail bank, and its online banking service is Open24. It is not the same institution as the UK's TSB Bank, despite the shared letters in the name. This matters from the first click: search for a way to convert a TSB statement and most of the results point at UK TSB Bank, so Irish customers end up following guidance written for a different country's online banking. If you hold a Permanent TSB account and need the figures in a spreadsheet, you are in the right place.

Getting a Permanent TSB statement to Excel comes down to which transactions you need. On desktop Open24 you can export up to about 12 months of transactions directly to CSV or Excel. Anything older than that is available only as a PDF eStatement. The Permanent TSB mobile app provides statements as PDF as well, with no native spreadsheet export at all. So the practical answer splits in two: recent activity exports cleanly from desktop Open24, while older history, or anything a mobile-only customer can reach, arrives as a PDF that has to be converted into spreadsheet rows.

That fork is worth settling before you start, because it decides your whole route. If the period you need sits inside the last year and you can get to a desktop browser, Open24's own export will do the job. If you need older transactions, can only reach your statements on a phone, or you are a bookkeeper working from a client's PDF, the native export is not an option and you are converting a PDF instead. The rest of this guide walks both routes, including the limits of each.

Permanent TSB is one of Ireland's three main retail banks, and the pattern for getting statement data into a spreadsheet is similar across all of them. If you also keep accounts elsewhere, the same approach applies when you need to convert AIB statements to Excel or convert Bank of Ireland statements to Excel; only the export paths and the layout of the statements differ.

Exporting Recent Transactions from Open24 on Desktop

The native spreadsheet export lives in desktop Open24, not the mobile app. Sign in to Open24 through a desktop browser, open the account you want, and you can download its recent transactions as a CSV or spreadsheet file ready to open in Excel. This is the correct route for recent activity, and for that purpose it works well: the data comes straight from the bank, already itemised, with no conversion step in between.

The limit to know about is the window. Open24's web export covers up to about 12 months of transaction history. Inside that period you can pull the data yourself in a few clicks and have a usable file; this is the straightforward case, and there is no reason to reach for anything else when the transactions you need are recent.

Where people get stuck is the older guidance. The legacy Open24 transaction download relied on Adobe Flash, and browsers no longer run Flash, so the steps in older forum answers and how-to posts simply fail. That is the source of a common conclusion, repeated across Irish banking threads, that Open24 has no export at all. It does; the modern export is the route described above. The Flash version is gone, not the feature.

What the desktop export does not reach is anything beyond roughly the last 12 months, and anything a mobile-only customer needs. Those transactions are not exportable to a spreadsheet from Open24. They exist as PDF eStatements, which is where the next section picks up.

Older History and eStatements: Why You End Up With a PDF

To reach statements older than the export window, you use eStatements inside Open24. On desktop, open the relevant account, use the account dropdown and select "View more transactions", then go to the "Statements" tab and choose "View eStatements". The statements you find there are delivered as PDF files, not spreadsheets.

eStatements are retained for up to about 24 months from the statement issue date for open accounts, and they are now delivered under Permanent TSB's "Digital Correspondence". Treat those figures as the present position rather than a fixed guarantee, but they set the practical boundary: roughly two years of statements are available to download as PDFs, and older issues may already have rolled off.

The mobile app does not change this. It provides statements as PDF only, so a customer who banks entirely on their phone has no native way to produce spreadsheet data; the PDF is all they can retrieve.

Whether the history predates the export window, lives only on mobile, or arrived as a client's PDF, the figures you need are locked inside a document you cannot sum or filter. Turning that PDF into rows you can actually work with is the problem the next section solves.

---

Converting a PTSB PDF eStatement Into Clean Excel or CSV

Before converting anything, it helps to know what a clean Permanent TSB statement PDF to Excel result actually looks like, because the format decides whether the data is usable in your books. Clean output means a single typed amount column rather than separate debit and credit text, so you can sum and filter it directly. Dates should be typed as real dates, not text that looks like a date, so they sort and feed into period filters. You want a running balance, a transaction description, and, on every row, a reference back to the source file and page so any figure can be traced to the original statement during a review.

PTSB statements carry detail worth preserving beyond the basic columns. The IBAN and BIC identify the account, and SEPA payment references on individual transactions are often what lets you match a payment to an invoice or a payee. A conversion that flattens the statement into a date-and-amount summary throws that away; for reconciliation you want the description and reference fields intact.

This is where copy-paste and generic converters tend to fail. Pasting from a PDF usually splits or merges the amount column, turns dates into plain text, and drops the per-row source reference entirely. For figures that have to stand up to an audit trail, the conversion method is not a detail. A reliable PTSB bank statement converter needs to read the statement's structure, not just lift its characters.

The practical way to close the gap is to convert the PDF directly into structured rows. Our tool lets you convert bank statement PDFs to Excel automatically: upload one or many PTSB PDF eStatements, describe the columns you need in a natural-language prompt, such as date, description, amount, balance and SEPA reference, and download the result as Excel, CSV or JSON. Every row includes a reference to its source file and page number, which is the verification mechanism that makes the output safe to reconcile against, and dates and amounts come back as native Excel types ready for formulas and pivot tables. Because it handles large batches in a single job, a bookkeeper sitting on several months or several clients' statements can convert Permanent TSB statement to Excel for all of them at once rather than one file at a time. It does not replace Open24's native export for recent data, which already works; it solves the older-history and mobile-only PDF that the native export cannot reach. If you want to compare approaches first, see the general methods for converting a bank statement to Excel.

From Spreadsheet to Reconciliation and Irish VAT and Form 11 Prep

Once a Permanent TSB business statement is a spreadsheet, it slots into the work it was always for. The first job is usually to reconcile the statement against your books, matching each line of bank activity to a recorded invoice, payment or receipt so the closing balance agrees. From there the same figures feed the periodic compliance returns: the VAT3, the annual Return of Trading Details (RTD), and, for sole traders, Form 11 filed through ROS. Clean, typed rows with IBAN, BIC and SEPA references intact are what make those steps quick rather than a manual re-keying exercise, and the SEPA references in particular help you tie a bank payment back to the supplier invoice behind it when you prepare your Irish VAT3 return from the figures.

This is also the reason converting older eStatements is worth doing rather than leaving them as PDFs. In Ireland, a business must retain its VAT and accounting records, including bank statements, for six years, under Revenue's six-year record-retention rule. Permanent TSB only keeps eStatements available for around 24 months, so the bank's retention window is far shorter than your own obligation. Converting each eStatement to a spreadsheet as you go, while it is still downloadable, gives you a durable, searchable record that outlasts the bank's archive and is ready for Revenue if it is ever asked for.