Plenty of profitable businesses close because they run out of cash. It sounds contradictory, but it happens constantly: a company wins orders, buys materials, hires help and waits for customers to pay, and in the gap between spending and collecting, the bank balance hits zero. Profit is an opinion about the future. Cash is what pays this week’s rent. A cash flow forecast is how you see the gap coming before you fall into it.
Cash flow is not the same as profit
Profit measures what you earned after costs. Cash flow measures when money actually enters and leaves your accounts. The two can diverge sharply.
- You deliver a large order in March, so it counts as March revenue, but the customer pays in May. Profit looks healthy while cash is thin.
- You buy three months of stock in one go. Cash drops immediately, but the cost only reduces profit gradually as items sell.
- You pay an annual insurance bill, a tax payment or a seasonal supplier in a single lump.
A forecast shows these timing gaps, so you can plan for them instead of being surprised.
Why thirteen weeks works so well
A thirteen-week forecast covers one quarter, week by week. It is long enough to see upcoming problems and short enough that your estimates stay realistic. Many finance teams use it because it is detailed where it matters most: the near future.
A yearly budget tells you roughly where you are heading. A weekly view tells you whether you can make payroll in week seven. Small businesses benefit most from the weekly view, since a single late payment can matter a lot.
What you need to build one
A spreadsheet is enough. Set up a simple grid with the thirteen weeks across the top and these rows down the side:
- Opening cash: the balance at the start of the week.
- Cash in: all money you expect to receive.
- Cash out: all money you expect to pay.
- Net cash flow: cash in minus cash out.
- Closing cash: opening cash plus net cash flow. This becomes next week’s opening cash.
Your closing balance for each week is the number to watch. If it falls near zero or below, that is the warning sign.
Step one: forecast cash coming in
Be realistic and slightly cautious. List each source of income and, crucially, the week you expect to be paid, not the week you deliver.
- Customer invoices already issued: use the due date, then adjust for how late your customers usually pay.
- Expected sales: base them on recent weeks and any known seasonal patterns, and consider a conservative estimate.
- Cash sales and card payments: remember that card payments may arrive a few days after the sale.
- Other income: deposits, grants or one-off receipts.
If a customer always pays three weeks after the due date, forecast the money three weeks late. Optimism is the main enemy of a good forecast.
Step two: forecast cash going out
Next, list everything you will pay, and when. Include both predictable and irregular items.
- Rent, utilities, wages and regular subscriptions
- Supplier invoices and planned stock purchases
- Taxes and government fees on their due dates
- Insurance, licenses and annual renewals
- Loan or installment repayments, if you have any
- Owner withdrawals, if you take them regularly
- A small allowance for repairs and surprises
Spread annual costs across the weeks they actually fall due, rather than hiding them. The goal is to spot a heavy week early.
Step three: read the result
Once the grid is filled in, look at the closing cash row. Ask three questions.
- Does the balance ever go negative, or drop below a minimum safety level you set?
- Which weeks are the tightest, and what causes them?
- If my biggest customer pays a month late, what happens?
The third question is a stress test. Try changing one assumption, such as a delayed payment or a drop in sales of twenty percent, and see how the forecast reacts. It takes a minute in a spreadsheet and can reveal how fragile or comfortable your position really is.
What to do when the forecast looks tight
Seeing a problem weeks ahead gives you many options. You can often fix a shortfall without borrowing at all.
- Speed up money coming in. Invoice immediately after delivery, ask for deposits on larger orders, offer a small discount for early payment, and follow up politely on overdue invoices.
- Slow down money going out. Negotiate longer payment terms with suppliers, schedule non-urgent purchases for later and avoid buying more stock than you need.
- Reduce or time costs. Delay a purchase of equipment or reduce discretionary spending until the gap passes.
- Use customer prepayment. Some businesses can collect payment in advance for subscriptions, courses or custom orders.
- Build a buffer. Aim for a reserve covering several weeks of essential costs, even if you build it slowly.
If you do consider outside financing, read the terms carefully, understand the total cost and make sure you can meet repayments comfortably. Relying on expensive short-term borrowing to cover recurring gaps is a sign the underlying cash cycle needs fixing.
Keep it current
A forecast is only useful if it stays fresh. Each week, spend ten to fifteen minutes on this routine:
- Replace last week’s forecast numbers with the actual amounts.
- Check where you were wrong, and by how much.
- Add a new week at the end, so you always look thirteen weeks ahead.
- Adjust upcoming estimates based on what you learned.
Over time your estimates improve, because you see patterns in who pays late and which costs are consistently higher than expected.
Common mistakes
- Using sale dates instead of payment dates for income.
- Forgetting irregular costs such as tax payments, renewals and repairs.
- Making the forecast too complicated. A simple one you update beats an elaborate one you abandon.
- Never comparing forecast to actuals. Without comparison, the forecast cannot improve.
- Looking only at the bank balance. It shows where you are, not where you are heading.
A note on general information
This article is general educational guidance, not accounting or financial advice. Tax deadlines, payment practices and financing options differ between countries and change over time. For decisions about your own business, consult a qualified accountant.
Frequently asked questions
What is the difference between a cash flow forecast and a budget?
A budget plans how you intend to earn and spend over a period, often a year. A cash flow forecast tracks when money actually moves, usually week by week, so you can see whether you will have enough cash at each point.
How accurate does a forecast need to be?
It does not need to be perfect. The aim is to spot trouble early and make better decisions. Accuracy improves as you compare forecasts with actual results.
How much cash buffer should a small business keep?
Many advisors suggest enough to cover several weeks to a few months of essential expenses, depending on how stable your income is. Seasonal businesses may need more.
Can I make a forecast without accounting software?
Yes. A simple spreadsheet with weekly columns is enough for most small businesses, and many owners prefer it because they can see every assumption.
What if my income is very unpredictable?
Use cautious estimates, build a larger buffer and update the forecast more often. Running a best-case and worst-case version side by side can also help.
The takeaway
Cash flow forecasting is not complicated, but it is powerful. A simple weekly grid, updated each week and tested against a few bad scenarios, can turn nasty surprises into manageable problems. Open a spreadsheet this week, fill in the next thirteen weeks as honestly as you can, and look at the lowest number. That number is your early warning.



