Christmas Special Start with $0 on Starter, Core or Growth. Sign up by 25 Dec 2026, 23:59 SGT.

See the Christmas offer
Free template · Bookkeeping

Free Bank Reconciliation Template for Singapore Businesses

Rates and rules checked against official pages on 29 Oct 2026

Short answer: Type the balance on your bank statement and the balance in your cash book. Add the deposits in transit and take off the outstanding payments on the bank side. Add and take off the items on the statement that are not in your books yet. If the two adjusted balances agree, the account is reconciled. If not, the page shows the difference.

Bank reconciliation

General information only, not tax, legal or accounting advice. Rates and rules were checked against the official pages listed under Sources on 29 Oct 2026. They can change, so confirm with IRAS, CPF Board, MOM or ACRA before you rely on a result.

Why the two balances differ

ItemWhere it sitsWhat to do
Deposit in transitIn your books, not yet on the statementAdd to the bank balance
Outstanding paymentIn your books, not yet cleared by the bankTake off the bank balance
Interest or a direct creditOn the statement, not in your booksAdd to the book balance, then record it
Bank charge or direct debitOn the statement, not in your booksTake off the book balance, then record it

After these items, the adjusted bank balance and the adjusted book balance should be the same number.

If it still does not agree

  • Check each amount for a typing error, and for two digits swapped, such as 54 and 45. A difference divisible by 9 often points to this.
  • Look for a payment or receipt recorded twice, or not at all.
  • Make sure the opening balances agree with last month's reconciliation.
  • Tick every line on the statement against your books, one by one.

Record the items that are not yet in your books

The lines that you added or took off the book side are real transactions. Post them to your cash book or accounting software so that next month starts from a correct balance. Bank charges are an expense. If you are GST-registered, your bank may charge GST on its fees, so keep the bank's invoice or advice for your GST return.

Why this matters at year end

IRAS says a company must keep its bank statements and its accounting records, and be able to explain its transactions. A monthly reconciliation is how you find the unexplained ones while they are still easy to trace.

IRAS says a company must keep its source documents, accounting records and bank statements for at least 5 years from the relevant Year of Assessment, and must be able to explain every transaction. A file saved from this page is not a substitute for the receipts and invoices behind it, so keep those too.

Frequently asked questions

Is this bank reconciliation template free?

Yes. It runs in your browser, there is no sign-up, and nothing you type is sent to us.

How often should I reconcile?

Monthly, when the bank statement arrives. Businesses with many transactions often do it weekly.

What is a deposit in transit?

Money you have recorded as received and banked, which has not yet appeared on the bank statement.

What is an outstanding payment?

A payment or cheque you have recorded, which the bank has not yet paid out.

What if I find a difference I cannot explain?

Do not hide it in an expense. Keep looking, and ask your bookkeeper or accountant if it remains.

Sources

Each source was opened and read on 29 Oct 2026.