Build a 13-Week Cash Flow Forecast Fast

Profit does not pay your bills; cash does. A 13-week cash flow forecast tells you, week by week, whether you will have enough money in the bank to cover payroll, rent, and suppliers. By the end of this guide you will be able to build one in a spreadsheet, read the danger signals, and act before a shortfall becomes a crisis.

What a 13-week forecast is and why 13 weeks

A 13-week forecast lists your expected cash in and cash out for each of the next thirteen weeks, one column per week. Thirteen weeks is roughly a quarter. It is short enough that your estimates stay realistic, but long enough to see a problem coming while you still have time to fix it.

This is a cash tool, not an accounting report. It ignores accruals, depreciation, and non-cash items. It only asks one question: on any given Friday, is the bank balance positive?

Cash in vs cash out

Cash in is money actually landing in your account: customer payments, deposits, loan draws, tax refunds. Cash out is money actually leaving: payroll, rent, supplier invoices, loan repayments, taxes. Timing matters more than the amount. An invoice raised today may not become cash for 30 or 60 days.

How to build it, step by step

Start with a clean spreadsheet. Put weeks across the top and line items down the side.

Enter your current bank balance as the opening figure for week one.
List each expected receipt in the week you realistically expect the money, not the week you invoiced.
List each expected payment in the week it leaves the account, including recurring costs and one-offs like a tax bill or an annual insurance premium.
Calculate net movement per week (cash in minus cash out).
Roll the closing balance of each week into the opening balance of the next.

The closing-balance row is the one that matters. Any week it turns negative is a week you cannot pay everyone.

Base your numbers on evidence

Use your bank statements and aged receivables to estimate timing. If a customer historically pays in 45 days, forecast 45 days, not the 30 days on your terms. Optimism here is how forecasts fail.

A real scenario

A small print shop looked profitable on paper but kept feeling tight. The owner built a 13-week forecast and saw that week 7 dropped to minus 4,000 because a large annual software renewal and quarterly VAT landed in the same week, while a big customer paid on day 60. Seeing it five weeks early, the owner split the software payment to monthly billing and asked the customer for a 50% deposit. Week 7 stayed positive. Nothing about the profit changed; only the timing did.

Common mistakes and how to fix them

Forecasting invoices, not cash. Fix: move every receipt to the week money truly arrives, using past payment behaviour.
Forgetting irregular payments. Tax, insurance, and annual subscriptions wreck a forecast when missed. Fix: scan last year’s bank statements and add every one-off.
Never updating it. A forecast built once and ignored is fiction. Fix: update actuals every week and roll the window forward one week.
Being too optimistic on sales. Fix: forecast conservatively on cash in and fully on cash out. If reality is better, that is a pleasant surprise.
Ignoring the buffer. A balance of plus 200 is not safe. Fix: set a minimum cash floor and treat any week near it as a warning.

Action checklist

Open a spreadsheet with 13 weekly columns.
Enter today’s real bank balance.
Add expected receipts by realistic pay date.
Add every payment, including irregular and annual ones.
Build the closing-balance row and highlight any negative or near-zero week.
Decide one action for each risky week (deposit, deferral, payment plan).
Block 20 minutes every week to update actuals and extend the window.

Conclusion and next step

A 13-week forecast turns cash from a monthly surprise into something you steer. Your next step is small: build version one today with the numbers you already have, then update it next Friday. The habit, not the polish, is what protects the business.

FAQ

How often should I update the forecast?

Weekly. Replace each week’s estimates with what actually happened, then add a new week 13 at the end so you always look a full quarter ahead.

Do I need software for this?

No. A spreadsheet is enough for most small businesses. Dedicated tools help when you have many accounts or entities, but they are not required to get the benefit.

What is the difference between a cash flow forecast and a profit and loss statement?

A profit and loss statement measures earnings over a period and includes non-cash items. A cash flow forecast tracks only money moving in and out by date. A business can be profitable and still run out of cash.

What should I do if a week goes negative?

Act on timing first: request deposits, chase overdue invoices, or ask a supplier for a short deferral. Use borrowing as a planned backstop, not a surprise rescue.