Convert PTSB eStatements to Excel or CSV
Your PTSB eStatements open as PDFs in Open24 or the app, and access to them ends when an account closes. That makes the copies you saved the record that counts. If you need them as a spreadsheet, for a tax return, a mortgage application or your own bookkeeping, upload them here and download Excel, CSV or a file ready for Xero or QuickBooks.
Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.
Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your PTSB statement into Excel
-
Download the PDF statement from PTSB online banking
- Log in to Open24 Online Banking or the PTSB App (you need to be registered for eStatements).
- In Open24, click the dropdown arrow next to the account, select View more transactions, then the Statements tab and View eStatements; in the app, select eStatements and the account.
- Input the verification code and select View; the eStatement opens as a PDF (in the app, select the statement and click the download icon).
- Save the statement for the period you need as a PDF.
-
Upload it here
Scans and phone photos work too.
-
Download Excel, CSV, or QuickBooks and Xero CSV
Check the rows against the statement, then export.
Sample result
Your PTSB statement in Excel
Made-up sample rows, not a real statement.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | Card payment - Fictional Coffee Co | 15.00 | 2,385.00 |
Statement notes
What to know about PTSB statements
Don't treat Open24 as the archive
How long an eStatement stays online depends on when it was issued, and PTSB's help pages give different periods for different statements. If you'll need long history later, for a mortgage or a Revenue query, download each eStatement as it arrives and keep the PDFs somewhere you control.
Save before you close an account
PTSB ends eStatement access when an account closes and recommends saving your statements. If you're switching banks, download the lot first. Uploading them together here also checks the set for missing or overlapping periods, so you know the archive is complete before access goes.
The app's CSV covers recent activity
The PTSB App can download recent transactions as a CSV, which is fine for recent activity. For earlier months, or when you need a full statement period to reconcile, the eStatement is the better source, and its balances are checked during conversion.
Euro amounts and wrapped details
The statements list debits and credits in separate columns. The output gives each transaction one signed amount as a plain number, without euro signs or thousands separators, and keeps card and SEPA details on one row even when the statement wraps them.
Output and review
From PTSB PDF to your books
Accounting tip
Sage Accounting asks which date format your file uses when you import a CSV statement, and it expects dates separated by slashes. Choose dd/mm/yyyy, the order the QuickBooks-ready file uses for these euro statements, then import its Date, Description and Amount columns, which match Sage's three-column format.
-
Checked before export
Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.
-
Export formats
Excel, CSV, JSON, or QuickBooks and Xero CSV.
-
Private workspace
HTTPS uploads, kept private until you ask support to delete them.
FAQ
PTSB statement questions
My PTSB account is closed. Can I still convert old statements?
Is the PTSB App's CSV download enough for my accountant?
Can I import converted PTSB rows into QuickBooks or Xero?
Convert your PTSB statement to Excel
Page 1 free, no sign-up to see it; just an email to download.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by PTSB.