Build a Cash Flow Forecast That Prevents Surprises

Profitable businesses still run out of money. The reason is timing: you earn revenue on paper before the cash actually lands, while rent, payroll, and suppliers demand payment now. A cash flow forecast fixes this by showing you, week by week, whether you will have enough money in the bank. This guide shows you how to build a practical 13-week forecast, read it, and act on it before a shortfall becomes a crisis.

What a cash flow forecast actually is

It is a forward-looking schedule of cash in and cash out, ordered by the date money moves – not the date you invoice or receive a bill. That distinction is the whole point. Your profit and loss statement tells you if the business model works. A cash flow forecast tells you if you can pay Friday’s payroll.

Thirteen weeks is the standard horizon because it covers a full quarter, long enough to see seasonal dips and tax payments, short enough to estimate with reasonable accuracy.

The three building blocks

1. Opening cash balance

Start with the real number in your bank account today, not the balance in your accounting software, which may include uncleared items. This is your anchor.

2. Cash inflows by week

List money you expect to receive, dated when it will clear. If a customer’s terms are net-30 and you invoiced on the 5th, the cash arrives around the 5th of next month – not this week. Be honest about which customers pay late; use their real behavior, not their stated terms.

3. Cash outflows by week

List every payment: payroll and payroll taxes, rent, loan repayments, supplier invoices, software subscriptions, and quarterly tax estimates. Fixed costs are easy. The ones people forget are the lumpy, irregular payments – annual insurance, tax deadlines, equipment – that wreck an otherwise healthy month.

Reading the forecast

Each week, closing balance = opening balance + inflows – outflows. That closing balance becomes next week’s opening balance. The single most important column is the running closing balance. Scan it for any week that dips near zero or below. That is your warning signal, often visible six or eight weeks in advance – enough time to act calmly.

A real scenario

A small design studio was consistently profitable but felt tight every month. Building a forecast revealed the pattern: their three largest clients all paid net-45, but payroll ran every two weeks and a big software renewal hit in week 6. Weeks 5 and 6 showed a projected balance of minus 4,000. Because they saw it a month out, they did two things: asked one client for a deposit on the next project, and moved the software to monthly billing. No emergency loan, no missed payroll. The shortfall never happened because they saw it coming.

Common mistakes and how to fix them

Forecasting on invoice dates, not payment dates. This is the number one error. Fix it by shifting every inflow to the week the cash realistically clears, based on each customer’s history.
Being optimistic about collections. Assuming everyone pays on time hides the exact risk you are trying to see. Fix it by using each customer’s average actual payment delay.
Omitting irregular payments. Tax deadlines and annual renewals cause most surprise shortfalls. Fix it by mapping the full year of lumpy costs once, then dropping them into the right weeks.
Building it once and never updating. A stale forecast is worse than none because it breeds false confidence. Fix it with a 20-minute weekly update.
Confusing profit with cash. A great sales month can still produce a cash crunch if the money arrives 45 days later. Keep the two reports separate in your mind.

Action steps to build yours this week

Open a spreadsheet with 13 week-columns and rows for opening balance, each inflow, each outflow, and closing balance.
Enter today’s real bank balance as week 1 opening.
List expected customer payments on their realistic clearing dates.
List every outflow, including irregular annual and tax payments.
Calculate the running closing balance across all 13 weeks.
Flag any week that drops below your minimum comfortable buffer.
Set a recurring 20-minute weekly slot to update actuals and roll the window forward.

Conclusion and next step

A cash flow forecast turns money management from reactive panic into calm planning. Your next step is concrete: block 45 minutes this week to build the first version with real numbers. Even a rough forecast beats none – the goal is to see problems while you still have time to solve them.

FAQ

How often should I update the forecast?

Weekly is ideal. Replace last week’s estimates with actual figures and add a new week at the end so you always look 13 weeks ahead. Slower-moving businesses can update every two weeks.

Do I need special software?

No. A spreadsheet is enough for most small businesses and is often clearer because you control every assumption. Dedicated tools help once you have many bank accounts or entities.

What buffer should I keep?

There is no universal number, but many owners aim to keep enough cash to cover several weeks of fixed costs. Set your own minimum line and treat any forecast dip below it as a signal to act.

What if my income is unpredictable?

Forecast conservatively on inflows and fully on outflows. When income varies, it is safer to understate what you will receive and plan around a lean scenario.

Is a forecast different from a budget?

Yes. A budget sets targets for a period; a cash flow forecast predicts the actual timing of money moving in and out. They complement each other but answer different questions.