Get a clear picture of your business’s financial position. The balance sheet pulls cash, loans and tax from linked trackers, shows opening vs current figures and checks that everything balances.

What it does

Assets, liabilities and equity at the start of the year and now
Cash, loans, GST and retained profit linked from the trackers inside
Balance check that tells you if anything is missing
Key ratios: working capital, current ratio, quick ratio and debt-to-equity
Dashboard covering P&L, cash, loans and balance sheet health

How it works

Settings: enter your business details and opening cash.
Balance Sheet: fill in the blue opening and current figures until the Balance Check reads 0.
Linked trackers: keep Transactions, Loans, GST and Petty Cash up to date and the balance sheet follows.

What’s inside

Start Here guide, Dashboard (36 headline numbers and 18 charts), Transactions, P&L, Cash Flow, Balance Sheet, Loans, GST, Petty Cash, Analysis and Settings sheets.

Good to know

Excel and Google Sheets: open it in Microsoft Excel, or upload it to Google Drive and choose Open with → Google Sheets. Formulas, dropdowns and charts carry over.
Colour-coded: blue cells are for your entries, grey cells calculate automatically, so you can’t break a formula by accident.
Sample data included: a demo business fills every sheet so the dashboard works from day one. Clear the blue cells when you start.
Any currency: amounts show without a symbol, and you set your currency once in Settings.

Want every template?

This template is part of the Small Business Complete Bundle: all 38 templates in six workbooks, each with its own dashboard.

Delivery

Instant download right after payment. The download link is also emailed to you and works up to 5 times within 30 days. One-time payment, no subscription. As a digital product, it is non-refundable once downloaded, but if a file is faulty we fix it, replace it or refund you. See our refund policy.

Balance Sheet Excel Template

Balance Sheet