Convert PTSB Bank Statement to Excel
PTSB eStatements group information into an account details block, a transaction summary showing opening balance, total credits, total debits and closing balance, then the individual transactions — with debits shown as negatives and credits as positives — followed by a Fees and Charges section. Those signed amounts are exactly what trips up manual copying: paste a column into Excel and minus signs get dropped or misaligned, while the fees section quietly gets forgotten altogether. SheetMyBank interprets PTSB’s sign convention correctly, splits money in from money out, carries the fees entries into the output, and checks that the transaction totals reproduce the printed summary figures. The result is a spreadsheet that agrees with PTSB to the cent.
To download, log in to Open24 online banking, click the dropdown arrow beside the account, choose View more transactions, open the Statements tab and select View eStatements — you’ll confirm with a push notification or SMS code before the PDF opens in a new tab. In the PTSB app, choose eStatements, select the account and tap the download icon. eStatements dated after March 2021 remain viewable for up to seven years. Conversion happens on your machine alone, and the summary reconciliation — opening balance plus credits minus debits equals closing balance — runs on every file.
Drop your PTSB statement here (PDF or photo)
Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).
Free for your first 5 pages each month · Processed on your device · Balance-verified output
PTSB statement FAQ
Debits show as negative numbers on my PTSB statement — will Excel display them correctly?
Yes. The converter preserves PTSB’s signed-amount convention, and you can optionally split the single amount column into separate debit and credit columns if your bookkeeping software expects that shape instead.
I can’t see any eStatements for my account in Open24 — what’s missing?
The account has to be registered for eStatements before any appear. Once registration is active, new statements accumulate under the Statements tab and each becomes downloadable as a PDF.
Can I combine four quarterly PTSB statements into one yearly spreadsheet?
Absolutely — feed all four PDFs in together and SheetMyBank merges them in date order, additionally checking that each quarter’s closing balance matches the next quarter’s opening balance so the joined year is seamless.