CFOSurge Australia/Profitable but no cash/Worksheet

Monthly profit-to-cash worksheet

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.

LineMonth 1Month 2Month 3Month 4Month 5Month 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.