Convert OCBC Bank Statement to Excel
OCBC statement layouts differ depending on the account type: some print separate Credit and Debit columns, others use a single Amount column where withdrawals carry a minus sign, and a line can show more than one date when the transaction date differs from the processing date. The currency typically appears only in the page header rather than on each row. Copy-pasting from the PDF therefore produces jumbled columns that need manual untangling before any spreadsheet will accept them, and one misplaced minus sign quietly wrecks the totals. SheetMyBank detects which OCBC variant it is looking at, normalises signed amounts and split columns into a consistent pair of money columns, and keeps the running balance attached to the correct transaction throughout.
Fetch statements from internet banking under View accounts → Documents → View documents, or in the OCBC app via More → Documents – Statements & Letters → View documents. There is good news on history: OCBC is extending free online retention from three years in 2026 to four in 2027 and five in 2028. Requesting an old paper copy instead costs S$20 to S$100 depending on age. Conversion happens locally on your own machine — no file upload, no account numbers leaving your device — and every extracted row is checked against the printed balance so a misread digit cannot pass silently.
Drop your OCBC 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
OCBC statement FAQ
Why does my OCBC statement look different from someone else’s?
The format varies with the account or product. SheetMyBank auto-detects both the two-column Credit/Debit style and the signed single-Amount style, so either version converts to the same clean spreadsheet structure.
A transaction shows two dates on my OCBC statement — which one is used?
Both are kept. When a line carries two dates they are exported as separate columns, so you can decide whether the transaction date or the processing date drives your bookkeeping.
How far back can I download OCBC eStatements online?
Free retention is being expanded in stages — three years in 2026, four in 2027 and five in 2028. Anything older requires a paid reissue, with fees ranging from S$20 up to S$100 for documents over six years old.