Convert Public Bank Bank Statement to Excel
Public Bank has a reputation for conservatism and a customer base to match: family-run SMEs, property investors servicing loans, retirees on fixed deposits. Accounting firms see a disproportionate share of Public Bank statements at tax time, and often not as clean PDFs — clients photograph pages with a phone or hand over photocopies, because plenty of Public Bank customers still keep paper. The statement itself is orthodox: DD/MM/YYYY dates, description, debit and credit columns, running balance. Orthodox doesn’t mean quick to retype. A year of a client’s current account can run past a thousand rows, and manually keying debits and credits into the right columns — then re-adding the balance column to check your own work — is exactly the kind of task that eats the margin on a small engagement.
Customers who bank online download statements through PBe, Public Bank’s internet banking: after logging in, open the account and look for the e-statement or download-statement option to save a monthly PDF. E-statements Public Bank sends by email are commonly password-protected, with the convention — typically tied to your NRIC — spelled out in the message. Whether you have that clean PDF, a scan, or a phone photo of a paper statement, SheetMyBank handles it the same way: built-in OCR reads scanned pages, and all processing runs inside your browser, so a client’s statement never leaves the machine — it even works offline once the page has loaded. Every transaction is re-verified against the running balance, which matters most with OCR, where a smudged digit is otherwise invisible; suspect rows are flagged in the preview and exported to a Warnings sheet. The first five pages each month are free, enough to trial it on a real client file.
Drop your Public Bank statements here (PDF or photo)
One file or many — 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
Public Bank statement FAQ
Where do I download my statement in PBe?
Log in to PBe, open the account, and use the e-statement or statement download option to save the month you need as a PDF. If you only have a paper statement, a phone photo or scan works too — the built-in OCR reads those directly.
I’m an accountant handling client statements — is a web converter appropriate?
SheetMyBank never uploads the file: parsing runs as code inside your browser, the statement never reaches a server, and the tool keeps working offline once the page is loaded. That makes it materially different from converters that process files server-side, and easier to defend under client-confidentiality obligations.
Can I get the output into QuickBooks or my Malaysian accounting software?
Export as QBO for QuickBooks, QFX for Quicken, or OFX for anything that accepts the open format. For local packages such as AutoCount or SQL Account, the CSV and Excel exports import through their standard bank-transaction import screens.