A forecast you will actually use
Elaborate financial models are rarely maintained by a person running a small business alone. A simpler tool, kept up to date, beats a sophisticated one that lies abandoned. A three-column forecast, with income, spending and balance for each coming month, is enough to show what the next quarter is likely to look like.
The aim is to see problems while they can still be avoided.
The three columns
The first column holds expected money in for the month. Include only what you have good reason to expect: confirmed invoices due, retainers, and a conservative estimate for new work. The second holds money out: fixed bills, known commitments, business costs and your planned salary. The third shows the resulting balance, starting from the current figure.
| Month | In | Out | Balance |
|---|---|---|---|
| This month | 48,000 | 42,000 | +6,000 |
| Next month | 30,000 | 42,000 | -6,000 |
| Month after | 55,000 | 42,000 | +7,000 |
Seeing a negative figure in the middle row, with positives either side, tells you something precise: next month needs attention.
Be cautious on the income side
Optimism is the main enemy of forecasting. Count an invoice at its likely payment date, not its due date, if the client is usually late. Count hoped-for work at a fraction, or not at all. A forecast that errs on the side of caution is more useful than one that flatters.
Be thorough on the spending side
Many forecasts fail through forgotten costs. Include annual items that fall within the horizon: insurance, subscriptions that renew, school fees, festival spending. A quick scan of last year’s records for the months ahead brings these to mind.
- Fixed monthly bills and instalments
- Annual and quarterly payments falling in the period
- Business costs and set-aside amounts
- Your planned salary or household withdrawals
Respond to what the forecast shows
A projected shortfall is a prompt to act early. Options include chasing an overdue invoice, bringing forward a billing date, delaying a purchase or drawing from the buffer by a planned amount. Each is easier a month before the problem than during it.
Update, don’t rebuild
Revisit the forecast once a week or at least once a fortnight. Replace estimates with actuals as months pass and add a new month at the end. The forecast always looks three or four months ahead, and the upkeep takes minutes.
Common mistakes to avoid
The first is counting income that has not yet been confirmed. The second is forgetting costs that recur annually. The third is never updating the sheet, so that it becomes a fantasy. A modest forecast that is true to life beats a detailed one that is out of date.
Scenario thinking in two lines
Add two rows beneath the forecast: a cautious case and a hopeful case. The cautious one assumes late payments and no new work. The hopeful one assumes the best. If you can survive the cautious case, you are safe; if you need the hopeful case, you are gambling.
Look at the gap between the two cases. A narrow gap means a predictable business. A wide gap means you should hold a larger buffer.
Colour or mark any month where the balance turns negative. A quick visual cue makes the weak points obvious at a glance, and it is a useful prompt for the weekly update.
What it gives you
Beyond warning of problems, a forecast gives confidence. When the numbers show a comfortable stretch, you can invest in learning or rest without anxiety. When they show a tight one, you can respond calmly. In both cases, you are steering rather than drifting.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


