Convert OCBC Bank Statement PDF to Excel or CSV

OCBC gives you the same statement in a few places. Any of them works, as long as you upload the PDF file OCBC produced and not a photo or a scan of a printout.

Personal accounts and credit cards

Log in to the OCBC app or OCBC Internet Banking and go to Documents. Your statements are listed there by month. Open the one you need and save the PDF.

Business accounts

Log in to OCBC Velocity and open Accounts > e-Statements. In the OCBC Business app, tap the menu at the top left and choose e-Statements. The file is headed STATEMENT OF ACCOUNT and normally covers the 1st to the last day of the month.

Only have paper?

Scan it at 300 dpi or higher and keep the pages straight. A clean scan can work, but the PDF you download from OCBC will always convert more accurately, because its text is real text rather than a picture of text.

Menu names change from time to time. If you can't find the option, search the OCBC app for "e-Statements" or "Documents".

Account statements

• Transaction Date and Value Date: OCBC prints both as day and month, like 01 JUN. The year comes from the statement period at the top, so every row gets a full date. Smart Data uses the transaction date; Raw Data keeps both.
• Description: the transaction type plus the lines under it, such as the payer or payee name, the reference and the memo, joined into one cell.
• Cheque: the cheque number wherever OCBC printed one, kept in Raw Data.
• Withdrawal and Deposit: taken from the column the amount was printed in, so a deposit can't turn into a withdrawal.
• Balance: the balance printed on each row. BALANCE B/F and BALANCE C/F become your opening and closing balance.

Credit card statements

• One row per transaction with the date, description and amount in Singapore dollars.
• Charges go in Withdrawal. Payments, refunds and other credits, which OCBC prints in brackets, go in Deposit.
• Foreign currency details printed under a charge stay in that charge's description.
• Last month's balance becomes the opening balance and the total amount due becomes the closing balance.
• Raw Data shows the statement as printed, card headers and subtotals included.

The transaction code legend and the promotional pages aren't transactions, so they're left out of both tabs.

Most people who end up on this page have the same problem. The PDF from OCBC is fine for reading, but no help when you need to add things up. These are the people we hear from most.

Small business owners in Singapore

If your company banks with an OCBC Business Growth Account, you probably need your transactions in a spreadsheet at least once a quarter, usually for GST or for whoever keeps your books. Typing them out from the PDF is slow, and it's easy to skip a row without noticing.

Bookkeepers and accounting firms

Firms that look after many clients get statements in every format you can think of. Turning a stack of OCBC PDFs into files they can import into Xero or QuickBooks saves hours at year end and during audits.

Freelancers and the self-employed

When it's time to file your income tax with IRAS, you have to separate business income and expenses from personal spending. With a year of transactions in a spreadsheet, that becomes a sorting job instead of a reading job.

Credit card holders keeping track of spending

Some people just want to see where last month's money went. Others need to pick out work expenses to claim back, or split shared costs with a partner or flatmates. Both are much easier with the card statement in Excel.

People preparing for a loan, an audit or a legal matter

Mortgage brokers, auditors, lawyers and financial advisers often want totals across several months, not a folder of PDFs. Converting the statements lets you add up income, find regular payments and answer their questions quickly.

Anyone leaving Singapore or closing an account

Before you move abroad or shut an account, it's worth keeping your history in a format you can still search years from now.