How to Export Your Bank Statement as CSV from DBS, OCBC, and UOB

Why Export Your Bank Statement?

Manually keying in transactions is the number-one reason people abandon expense trackers. Every Singapore bank lets you download your transaction history as a CSV or Excel file — a process that takes under two minutes and works with DayByDay's any-bank importing.

Here's exactly how to do it for DBS, OCBC, and UOB.

---

DBS / POSB (digibank Online)

1. Log in to DBS digibank Online at internet-banking.dbs.com.sg.
2. From the left menu, select My Accounts → View Transactions.
3. Choose the account (savings, current, or credit card) from the drop-down.
4. Set the date range offered by the current interface.
5. Click Download (top right of the transaction table).
6. Select CSV from the format options, then click Download.

DBS Credit Card:

Go to Cards → View Card Transactions → choose the card → set the statement period → Download → CSV.

Tip: DBS exports include the transaction date, description, debit/credit amount, and running balance. Most trackers import this without any column mapping needed.

---

OCBC (internet banking & OCBC app)

Via internet banking (onebanker.ocbc.com):

1. Log in and go to Accounts → select your account.
2. Click the Download icon above the transaction list.
3. Choose an available date range.
4. Select CSV and click Download.

For credit cards:

Go to Cards → Credit Cards → select the card → Download Statements → choose the period → Excel/CSV.

OCBC app (iOS/Android):

Download options can differ between the app and internet banking. If CSV is unavailable in the app, use the desktop internet banking portal.

Note: OCBC CSV files label amounts in a single column with negative values for debits. When importing, confirm your tracker is handling sign conventions correctly.

---

UOB (UOB Personal Internet Banking)

1. Log in at pib.uob.com.sg.
2. Select Accounts → Transaction History.
3. Pick the account and set an available date range.
4. Click Export → choose CSV → click Export again.

UOB Credit Card:

Go to Cards → Credit Card → Transaction Details → select the card and period → Export → CSV.

Tip: UOB CSV files include a "Transaction Ref" column that's useful for identifying duplicate imports. If your tracker flags duplicates, this column is usually the key.

---

What to Do After Downloading

1. Don't rename the file yet. Import it first — some trackers read the filename to detect the bank automatically.
2. Check the date range. Bank CSV exports are often inclusive of the start date but exclusive of the end date. Verify the first and last transactions match your expectations.
3. Look for pending transactions. Pending items may not appear in CSV exports — only settled transactions are included.
4. Import monthly. A monthly rhythm keeps your data current without creating large files that are hard to review.

Once you've imported, run a quick sanity check: does the total debit amount in your tracker match the statement total? If yes, you're done. Create a DayByDay account when you are ready to import your first statement.