Convert a OCBC Bank bank statement to Excel
Convert a OCBC Bank statement PDF to Excel or CSV in your browser. StatementSift detects date, description, amount and balance columns, then checks row-by-row balance continuity before export. 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.
- Choose PDF
- Review transactions
- Export your data
Choose a PDF with selectable text from online banking. Parsing runs locally; incomplete balance evidence is marked for review. Check the extracted rows against your statement before exporting.
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.
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.
Review target
Flagged rows, opening and closing balances.
Watch-outs for OCBC Bank statements
OCBC Bank separates money out and money in into debit and credit columns. If a row is flagged, first check whether the sign was assigned correctly.
Wrapped merchant descriptions can push the next line out of alignment; check long descriptions when the balance proof fails.
Opening balance, closing balance and page-break continuation rows are not ordinary transactions, so review the first and last rows on multi-page statements.
How to convert a OCBC Bank statement
- 1
Download your OCBC Bank statement as a text-based PDF from online banking.
- 2
Drop the PDF into the local converter on this page.
- 3
Review detected columns, opening and closing balances, and every flagged row.
- 4
Export to Excel, CSV, or QuickBooks/OFX only after the reconciliation looks right.
Frequently asked questions
No. Reading the PDF, detecting rows, checking balances and building the export all run locally in your browser. Your OCBC Bank statement is not uploaded or sent to an AI service.
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.
Treat the export as a format conversion, not financial, accounting, tax or legal advice. Verify key figures and consult a qualified professional before relying on the output.
Updated · StatementSift team