Singapore bank statements to Excel

Singapore statements usually print dates without the year (05 Mar), separate Withdrawal and Deposit columns and a running balance from the Balance B/F. PayNow, FAST and GIRO details often run onto a second line. StatementEasy gives every date its year from the statement period, joins those lines to their transaction and checks every balance.

Banks

Four Singapore banks are tested on their statement layouts: DBS / POSB, OCBC, UOB, as well as Standard Chartered. Other banks are read by the generic reader; the balance check shows whether every line was read. If yours is not, tell us the bank.

Singapore statement formats, read correctly

Bank by bank

• DBS / POSB — Withdrawal (-) and Deposit (+) columns, descriptions such as Point-of-Sale Transaction or Advice FAST Payment over two lines, from the Balance Brought Forward.
• OCBC — transaction and value dates side by side (05 MAR), 360 Account statements included, from BALANCE B/F.
• UOB — Withdrawals and Deposits with dates like 05 Mar, One Account statements included.
• Standard Chartered — full dates like 05 Mar 2025 and a Withdrawal, Deposit and Balance layout.

What Singapore statements are used for

• Tax filing — convert the year of assessment and total income and expenses.
• Housing loans and rentals — Insights shows salary credits and the lowest balance.
• Small businesses — export CSV for Xero or QuickBooks.