A profitable small business can still run out of money. Profit is what's left after costs over a period; cash is what's in the account on the day the payroll goes out. When a big customer pays sixty days late and the tax bill lands the same week, the profit on paper doesn't help. A cash flow forecast is the simple tool that shows those weeks coming while there's still time to do something about them.
This guide explains how to build a cash flow forecast for a small business without accounting software or a finance background: what goes in it, how far ahead to look, how to handle uncertainty honestly, and how to turn the forecast into decisions rather than a spreadsheet nobody opens.
Why profit and cash are different
Three things create the gap. Timing: you record a sale when you invoice it, but the cash arrives when the customer pays, which may be weeks or months later, while your own suppliers and staff expect payment on schedule. Non-profit outflows: loan repayments, equipment purchases, owner drawings and tax payments all take cash without showing up as expenses in the way a profit statement counts them. Seasonality: a business that earns most of its revenue in three months has nine months of costs to cover in between.
A cash flow forecast is simply a week-by-week or month-by-month map of money in and money out, so those gaps become visible before they arrive.
What you need to start
- Your current bank balance (the real one, after any cheques or pending payments).
- A list of who owes you money and when they are likely to pay, based on their actual habits rather than your terms.
- Your regular outgoings: rent, salaries, subscriptions, loan repayments, insurance, utilities.
- Irregular but known costs: tax deadlines, annual renewals, planned equipment purchases.
- A realistic view of upcoming sales.
A spreadsheet is enough. Dedicated tools help once the business is more complex, but the discipline matters more than the software.
Building the forecast step by step
1. Choose the period and the granularity
Weekly columns for the next thirteen weeks (one quarter) is the standard small-business format, because most cash crises develop over weeks, not months. Beyond the quarter, monthly columns out to twelve months are useful for planning without pretending to precision you don't have.
2. Start with opening cash
The first column begins with today's real bank balance. Each subsequent column starts with the previous column's closing balance.
3. List cash in
Not sales: receipts. Put each expected customer payment in the week you genuinely expect it to arrive. If a customer habitually pays fifteen days late, forecast them fifteen days late. Add any other inflows: loan drawdowns, grants, tax refunds, owner investment.
4. List cash out
Every payment in the week it leaves the account. Group them: people (salaries, contractors, payroll taxes), premises, suppliers, loan repayments, taxes, subscriptions, one-off purchases, owner drawings. Be complete. The forgotten annual insurance renewal is exactly the sort of thing that turns a tight week into an overdraft.
5. Calculate closing cash
Opening balance plus cash in minus cash out. That's the number you're watching. Any week where it dips below zero, or below the minimum buffer you're comfortable with, is a problem you now know about in advance.
Handling uncertainty without fooling yourself
A forecast is a set of assumptions, and optimism is the most common way it goes wrong. A few habits keep it honest:
- Separate confirmed from expected. Invoices already issued are more certain than deals in the pipeline. Some businesses shade pipeline receipts by a percentage or exclude them entirely from the near-term weeks.
- Run a downside version. Copy the sheet and ask: what if the two biggest customers pay a month late and one expected deal doesn't close? If that version stays above zero, you're resilient. If not, you know what to prepare for.
- Update weekly against actuals. Replace each week's forecast with what really happened. Over a few months you'll learn your own biases (most people under-forecast small outgoings) and the forecast gets sharper.
Late-paying customers are usually the largest source of error. Chasing invoices consistently is worth more to cash flow than almost any cost cut. A short, documented follow-up sequence — reminder before the due date, a call on the day it's late, escalation after two weeks — is a good candidate for a written procedure; our article on writing standard operating procedures covers how to document routines like that so they run without you.
Turning the forecast into decisions
The forecast earns its keep when a future week looks thin. With weeks of warning rather than days, the options are far better:
- Pull receipts forward: invoice on completion rather than at month end, ask for deposits on larger jobs, offer a small early-payment discount where the margin allows.
- Push payments back, honestly: ask a supplier for extended terms before you miss a payment, not after. Most will agree to a conversation held in advance.
- Smooth the lumps: spread annual costs monthly where the provider allows, set aside tax in a separate account each month so the deadline is a transfer rather than a shock.
- Arrange facilities before you need them: an overdraft or credit line is easier to secure when the forecast shows you don't need it yet.
- Delay discretionary spend: equipment, hires and marketing pushes can often move by a few weeks without harm if you know in advance.
The same tool works in the other direction. When the forecast shows a comfortable surplus building, you can commit to a hire or an investment with confidence instead of guesswork.
Buffers and reserves
Decide on a minimum cash balance the business should never plan to go below, and treat that line, not zero, as the danger threshold. What that buffer should be depends on how lumpy your receipts are and how quickly you could cut costs; businesses with a few large clients need more cushion than those with many small ones. The logic is the same as a personal emergency fund: the reserve buys time to respond calmly rather than under pressure.
Common cash flow forecasting mistakes
- Forecasting sales instead of receipts.
- Using payment terms rather than actual customer behaviour.
- Leaving out taxes, loan repayments and owner drawings because they "aren't expenses".
- Building the forecast once and never updating it.
- Only ever running the optimistic case.
- Keeping it in your head. If it isn't written down, it can't be checked.
FAQ
How far ahead should a small business forecast cash flow?
Thirteen weeks in weekly detail is the practical standard, because it covers the horizon where you can still act. Extend to twelve months in monthly columns for planning, accepting that the later months are estimates.
How often should I update the forecast?
Weekly. Replace the past week's forecast with actual figures, roll a new week onto the end, and adjust any expected receipts that have changed. It takes fifteen to thirty minutes once the sheet exists.
Do I need an accountant to build a cash flow forecast?
No. The forecast is arithmetic on money in and money out, and the owner usually knows the timing better than anyone. An accountant or adviser can help sanity-check assumptions and tax timings, and is worth consulting for decisions about financing, but the weekly forecast itself is something you can and should own.
Conclusion
A cash flow forecast turns the most common cause of small business failure into a visible, manageable problem. Start from real cash, forecast receipts rather than sales, include every outflow, and look thirteen weeks ahead in weekly detail. Update it against actuals, run a downside case, and use the warning it gives you to act early. It is one spreadsheet, half an hour a week, and it is the difference between steering the business and being surprised by it.
