Build a 13-Week Cash Flow Forecast Step by Step

A profitable business can still run out of cash. That gap is where most small businesses get caught. A 13-week cash flow forecast fixes it by showing, week by week, when money actually arrives and leaves your bank account. Read this and you will be able to build one in a spreadsheet, read the warning signs early, and make decisions before a shortfall becomes a crisis.

Why 13 weeks, and why cash instead of profit

Thirteen weeks is one quarter. It is long enough to see a big supplier bill or a slow-paying client coming, but short enough that your estimates stay realistic. Beyond a quarter, guesses drift and the forecast loses value.

Cash and profit are not the same thing. Profit records a sale when you invoice it. Cash records it when the client pays, which might be 30 or 60 days later. Your profit and loss statement can look healthy while your account is empty because the money is stuck in receivables. A cash forecast tracks the timing, not the accounting.

What you need before you start

• Your current bank balance (the real cleared figure, not the pending one).
• A list of expected customer payments and their likely dates.
• Known outgoings: payroll, rent, tax, loan repayments, supplier bills, subscriptions.

Building the forecast

Set up a spreadsheet with 13 columns, one per week. Down the left side, create three blocks: opening balance, cash in, and cash out.

1. Opening balance

Week 1 opens with today’s cleared bank balance. Every following week opens with the previous week’s closing balance. This chaining is the whole engine of the forecast.

2. Cash in

List expected receipts by the week you realistically expect payment, not the invoice date. If a client always pays late, forecast them late. Be honest here; optimism is what breaks forecasts.

3. Cash out

List every payment by its due week: payroll, rent, tax, suppliers, software, loan payments. Put fixed costs in first because they are certain, then variable ones.

4. Closing balance

Closing balance = opening + cash in – cash out. Carry it into the next week. Any week that turns negative is a shortfall you now have weeks to solve.

A real scenario

A small agency had a healthy profit on paper. Building the forecast showed week 6 dropping to minus 4,000 because two big invoices were due to be paid in week 8, but payroll and quarterly tax both landed in week 6. Nothing was wrong with the business; the timing was wrong. Seeing it four weeks out, the owner asked one client to pay early and moved a supplier payment by a week. The shortfall disappeared without a loan or a panicked phone call.

Common mistakes and how to fix them

• Forecasting invoices, not payments. Entering cash on the invoice date makes every week look good until reality hits. Fix: use expected payment dates based on each client’s actual habits.
• Forgetting irregular costs. Quarterly tax, annual insurance, and equipment purchases wreck forecasts because they are easy to overlook. Fix: keep a separate list of lumpy, non-monthly costs and slot them in.
• Building it once and abandoning it. A forecast is only useful if it is current. Fix: update it every week by replacing forecast figures with what actually happened, then roll a new week 13 onto the end.
• Being optimistic to feel better. A rosy forecast hides the exact risk you built it to catch. Fix: when unsure, use the more cautious number.

Action steps

• Open a spreadsheet and enter your cleared bank balance in week 1.
• List all expected payments by realistic receipt week.
• List all known outgoings by due week, including irregular costs.
• Calculate closing balances down all 13 weeks.
• Mark any negative week and plan a fix now, not later.
• Book a recurring 30-minute slot each week to update it.

Conclusion

A cash flow forecast turns your bank balance from a source of anxiety into a planning tool. Start with a rough version this week; an imperfect forecast you actually update beats a perfect one you build once. Your next step: block 30 minutes now and fill in the first draft.

Frequently asked questions

How often should I update the forecast?

Weekly is the standard. Replace each week’s estimates with actual figures, then add a fresh week to the end so you always look 13 weeks ahead.

What is the difference between this and a budget?

A budget sets targets for a period, usually a year. A cash flow forecast tracks the timing of money in and out over the near term. They answer different questions: the budget asks whether the plan is sound, the forecast asks whether you can pay the bills next Tuesday.

Do I need accounting software for this?

No. A simple spreadsheet works well and forces you to understand the numbers. Software can automate parts of it later, but the discipline of updating it matters more than the tool.

What if my income is unpredictable?

Forecast a conservative version and, if useful, a second column for a worst case. Unpredictable income is exactly the situation a forecast helps with, because it shows how long your cash lasts if payments slip.

References

• U.S. Small Business Administration (SBA) – guidance on managing business finances and cash flow.