Fill in one column a month. It takes about 30 minutes once you have the profit and loss and the balance sheet for two dates.
How to use it. Enter amounts that used cash as positive numbers. If the unexplained line isn't close to zero, something is moving through the business that the books don't show: personal spending, an unrecorded loan, or unreconciled accounts. Find it before reading anything else.
| Line | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 |
|---|---|---|---|---|---|---|
| Profit for the month | ||||||
| Change in bank balance | ||||||
| Gap to explain (profit − change in bank) | ||||||
| Increase in money owed to you | ||||||
| Increase in stock or unbilled work | ||||||
| Increase in what you owe suppliers | ||||||
| Depreciation | ||||||
| Equipment paid in cash | ||||||
| Loan principal repaid (less any new borrowing) | ||||||
| Money taken out by owners | ||||||
| Income tax paid | ||||||
| Explained (owed to you + stock − suppliers − depreciation + equipment + loans + owners + tax) | ||||||
| Unexplained (gap − explained) | ||||||
| Biggest address this month | ||||||
| Type: lag, drain, withdrawal, not real, not yours or too small | ||||||
| The one fix I'll make this month | ||||||
| Cash conversion cycle (days) | ||||||
| Free cash at month-end |
Shaded lines are calculated. The spreadsheet version fills them in for you. Work on one address a month. Re-run the profit-size test from the guide every quarter.
CFOSurge Australia · General information only. It isn't financial, tax or legal advice for your circumstances.