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.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your PTSB statement into Excel

  1. 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.
    Go to PTSB Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. 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.

sample-statement-2026-01.xlsx Jan 2026 · EUR
Sample bank statement rows with made-up data, amounts in EUR
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 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.

    Files for QuickBooks Online

    Files for Xero

  • 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?
If you saved the eStatements before the account closed, yes: upload them here. Online access ends at closure, so without saved copies you would need paper duplicates from the bank. Scanned paper statements convert too, and the balance check shows whether every row was read.
Is the PTSB App's CSV download enough for my accountant?
For recent transactions it may be. Accountants often want full statement periods with opening and closing balances, though, and the app download covers recent activity. Converting the eStatements gives complete periods, checked against those balances, as Excel or CSV.
Can I import converted PTSB rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your PTSB statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by PTSB.