Free Balance Sheet Template (Singapore)
Free Excel balance sheet template for Singapore companies — assets, liabilities and equity with GST and CPF payable lines, plus a built-in balancing check.
Tired of editing spreadsheets by hand every month? ArcPay generates GST-compliant invoices and tracks payment automatically. Try it free →
What this template is
A balance sheet in Excel: what the company owns (assets), what it owes (liabilities), and what’s left for shareholders (equity) as at a single date. The line items reflect a Singapore SME’s reality — GST payable to IRAS, CPF payable, and income tax payable are first-class rows.
A built-in check row computes assets minus (liabilities + equity) and should read S$0.00 — if it doesn’t, something is missing or double-counted.
How to use it
- Set the "as at" date — a balance sheet is a snapshot, not a period.
- Enter current assets (cash, trade receivables, GST receivable, inventory, prepayments) and non-current assets (equipment at cost, less accumulated depreciation as a negative).
- Enter what you owe: trade payables, GST payable, CPF payable, accruals, tax payable, and loan balances split current vs non-current.
- Enter share capital and retained earnings, then confirm the check row reads S$0.00.
Made for Singapore
- GST appears on the balance sheet, not the P&L: GST you’ve collected but not yet paid to IRAS sits in "GST payable" (or "GST receivable" when a refund is due).
- CPF payable captures contributions deducted and accrued but not yet paid — CPF for a month is due by the 14th of the next month, so there’s almost always a balance.
- Retained earnings should equal last year’s retained earnings plus this year’s net profit minus dividends — if the check row isn’t zero, this is the first place to look.
Frequently asked questions
Why doesn’t my balance sheet balance?
The usual suspects: retained earnings not rolled forward correctly, depreciation entered as a positive instead of a negative, or a loan recorded in cash but not in liabilities. The template’s check row makes the gap visible so you can hunt it down.
Does a small Pte Ltd need a balance sheet?
Yes — Singapore companies must prepare financial statements (including a balance sheet) under the Companies Act, and most file them with the ACRA annual return. Even exempt companies need them for directors to approve.
What’s the difference between current and non-current?
Current items convert to cash (or fall due) within 12 months of the balance-sheet date; non-current items are longer-term. Splitting loans into the portion due within a year and the rest gives a truthful picture of near-term obligations.
More free templates
- Free Cash Flow Forecast Template (Singapore) — GST payments to IRAS, CPF contributions, and PayNow receipts as first-class line items
- Free Profit & Loss Template (Singapore) — SG-relevant expense lines like CPF and SDL, percent-of-revenue column, and a 17% tax note
- Free Invoice Template (Singapore) — IRAS-compliant tax invoice layout with GST at 9%, UEN and GST registration fields, and PayNow payment details
Last reviewed 3 July 2026. Tax rates and thresholds change — verify against IRAS before relying on them.