Public Bank statement to Excel
Turn your Public Bank statement into a spreadsheet with a full date on every row and every balance checked.
- Checked every row against your balance
- Private read on your device first
- Excel & CSV plus QuickBooks, Xero and Quicken files
- Free no sign-up, no page limits
Public Bank statements list Date, Transaction, Debit, Credit and Balance, from a Balance B/F line, with dates printed short — 05/03, without the year. StatementEasy takes the year from the statement date, reads debits and credits as money out and in, and checks every balance.
Download your Public Bank statement
- Log in to PBe online banking or the PB engage app.
- Open the account, then e-Statements.
- Save the Public Bank statement as a PDF.
- Drop the Public Bank PDF into the converter above.
Public Bank columns in your sheet
| On the Public Bank statement | In your sheet |
|---|---|
| 05/03 | 2025-03-05 (year from the statement) |
| Debit / Credit | Money out / money in |
| Balance | Checked on every row |
| Balance B/F | Opening balance, not a row |
| Transaction | Description |
Savings and current accounts
Public Bank savings and current account statements share these columns. Convert both and drop them together to follow transfers between them.
For LHDN
Convert the year and use the Categories sheet to total income and expenses for your return.
Household budget
Recurring lists bills and subscriptions with their usual amount and day.
Last tested October 2026. StatementEasy is not affiliated with Public Bank Berhad.
Questions
My dates have no year. Is that a problem?
No. The year comes from the statement date, also across a new year.
Does it work with Public Islamic Bank?
Statements with the same columns are read the same way; the balance check confirms the result.
Is my statement uploaded?
Your browser reads the PDF first. Only if it cannot is the file read on our server, and deleted after reading.
Is StatementEasy made by Public Bank?
No. StatementEasy is an independent tool and is not affiliated with Public Bank Berhad.
Your next statement, in a spreadsheet
Free, no limits. No sign-up.