A 13 week cash flow forecast exists because profitable businesses fail by running out of cash, not profit. Profitable businesses fail because they run out of cash, not because they run out of profit. Those are different numbers, and your P&L will not warn you about the second one.
A P&L records revenue when you invoice. Cash flow is about when the money actually lands. A business can post a strong quarter and still miss payroll, because the invoices went out in March and the cash arrives in May.
The 13-week cash flow forecast is the tool that closes that gap. Restructuring firms use it when a company is in trouble. There is no reason to wait until then.
Why 13 weeks
One quarter. Long enough to see a problem coming while you still have options — you can chase a receivable, delay an order, or line up capital. Short enough that you can actually forecast it with reasonable accuracy.
Anything past 13 weeks is a guess. Anything shorter than 13 weeks is a warning you get too late to act on.
Build Your 13 Week Cash Flow Forecast in an Hour
Open a spreadsheet. Thirteen columns, one per week, starting with the current week. Then four blocks of rows.
1. Starting cash. What is actually in the bank on Monday morning. Not your accounting balance — the bank balance, minus anything you have written that has not cleared.
2. Cash in. Not sales. Collections. Go through your open invoices and put each one in the week you realistically expect the money, not the week it is technically due. If a customer has paid you 15 days late for two years, forecast them 15 days late. Add any other real inflows separately.
3. Cash out. Everything, in the week it actually leaves:
- Payroll and payroll taxes (get the dates exactly right — this is the one that kills people)
- Rent, insurance, utilities, software
- Vendor payments, by due date
- Loan and financing payments — including daily or weekly ACH debits, which people constantly forget to model
- Quarterly and annual items: taxes, insurance renewals, equipment registrations
4. Ending cash. Starting cash, plus in, minus out. That number becomes next week’s starting cash.
That is the whole model. It fits on one screen.
Read it for the one thing that matters
Scan the ending-cash row across all 13 weeks and find the lowest number.
If it is comfortably positive, you are fine — spend your energy elsewhere.
If it dips negative in week 6, you now know something enormously valuable: you have five weeks to fix a problem that has not happened yet. Five weeks is enough time to collect a receivable, push a vendor payment, defer a hire, or arrange financing on your terms rather than in a panic.
That is the entire point of the exercise. Not precision. Lead time.
Update it every Monday
The forecast is only useful if it is current. Every Monday: enter last week’s actual bank balance, correct anything you got wrong, and roll a new week 13 onto the end.
Fifteen minutes. Over a couple of months you will get noticeably better at predicting when your customers actually pay — which is a skill worth more than the spreadsheet.
What the forecast usually reveals
Run it honestly and one of a few patterns tends to show up.
A collections problem. The money is not late arriving — it is late being asked for. Check whether invoices are going out the day the work is done, and whether anyone is calling on day 31.
A timing mismatch. Cash comes in monthly, but a daily-pay financing product is taking money out every business day. That is a structural squeeze, and it usually means the financing was matched badly to the business.
A seasonal trough you already knew about. Every year, and every year it is a surprise. Once it is on paper, it stops being a surprise and starts being a plan — which is exactly when it is cheapest to finance.
A pricing problem. If the trough never recovers, no financing fixes it. Borrowing against a business that does not generate cash just moves the failure out a few months and adds a payment to it. That is the hardest read on the page, and the most important.
Financing looks different from the other side of this spreadsheet
Owners who bring a 13-week forecast to a funding conversation get taken more seriously, for a straightforward reason: they can say exactly how much they need, exactly when, and exactly how it gets repaid.
“I need $75,000 in week 5, and my collections in weeks 9 through 11 repay it” is a fundable request.
“I need money, how much can I get?” is a much harder conversation — for both sides.
Build the forecast first. It will tell you whether you need capital at all, and if you do, how much and for how long. That is the difference between borrowing on purpose and borrowing under pressure.
