Convert a OCBC Bank bank statement to Excel
Convert a OCBC Bank statement PDF to Excel or CSV right in your browser — date, description, amount and balance are detected automatically, with a row-by-row balance check, and your statement is never uploaded. OCBC Bank statements use this layout: An OCBC consolidated statement is grouped by account with one row per transaction in the order Date (Value Date), Description, Withdrawal, Deposit and Balance — debits and credits in separate columns, dates typically as 'DD MMM' (e.g. 15 Mar) with the year in the statement-period header, amounts in SGD. Text-based PDFs downloaded from OCBC Bank online banking convert most accurately.
Drop your bank statement PDFs (multiple allowed) and StatementSift detects the date/description/amount/balance columns locally and reconciles row by row. Financial data is never uploaded or sent to any external AI. Text-based PDFs (from online banking) work best.
How we read a OCBC Bank statement
- Columns：An OCBC consolidated statement is grouped by account with one row per transaction in the order Date (Value Date), Description, Withdrawal, Deposit and Balance — debits and credits in separate columns, dates typically as 'DD MMM' (e.g. 15 Mar) with the year in the statement-period header, amounts in SGD.
- Date format：DD MMM
- Best source：Log in to the OCBC Digital app or OCBC Internet Banking, open e-Statements / Statements, select the account and month and download the official text-based PDF — don't use screenshots or photographed scans, since OCR misreads the Withdrawal, Deposit and Balance columns on scanned statements.
Watch-outs for OCBC Bank statements
- OCBC Bank splits money in and out into two separate columns (withdrawals/debits and deposits/credits). The converter merges them into one signed amount so the balance check can run; double-check that a credit didn't get the wrong sign on any flagged row.
- Multi-line descriptions (a long merchant name wrapped onto two lines) are the most common cause of a shifted row — if a row doesn't reconcile, that's the first thing to check.
- Transactions that carry over a page break, and the opening/closing balance lines, are handled separately from regular rows; verify the first and last rows of each page after a multi-page statement.
How to convert a OCBC Bank statement
- 1Download your OCBC Bank statement as a PDF from online banking.
- 2Drop the PDF into the converter below — it parses locally.
- 3Review the detected columns and the balance check; verify any flagged rows.
- 4Export to Excel, CSV, or QuickBooks/OFX.
Frequently asked questions
No. The entire conversion — reading the PDF, detecting columns, the balance check and building the Excel file — runs locally in your browser. Your OCBC Bank statement is never uploaded or sent to any AI.
Log in to the OCBC Digital app or OCBC Internet Banking, open e-Statements / Statements, select the account and month and download the official text-based PDF — don't use screenshots or photographed scans, since OCR misreads the Withdrawal, Deposit and Balance columns on scanned statements.
OCBC Bank text-based PDFs are in the sweet spot and convert accurately at the row level. Either way, verify key figures before use — the row-by-row balance reconciliation flags suspect rows for you.
Updated · StatementSift team