Balance Sheet

Description

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

1. Settings: enter your business details and opening cash.
2. Balance Sheet: fill in the blue opening and current figures until the Balance Check reads 0.
3. 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.