Here's a scenario that sinks more solo businesses than a bad quarter ever does: you look at your profit and loss statement, see a healthy number, and feel fine. Then three weeks later you're staring at your bank balance wondering how you're going to cover payroll for your one contractor.
Profit and cash are not the same thing. Your P&L counts an invoice as revenue the day you send it. Your bank account doesn't see that money until the client actually pays — which, if you've been in business more than a month, you know can be anywhere from net-15 to "I'll get to it eventually." A 13-week cash flow forecast closes that gap. It's the tool that tells you not whether your business is working, but whether you can make rent in week 7.
Thirteen weeks is one fiscal quarter, broken into weekly buckets instead of monthly ones. Monthly is too coarse — a lot of damage can happen inside a 30-day gap between when you see a problem and when you can react to it. Weekly is granular enough to catch a cash crunch while you still have three or four weeks to do something about it: follow up on a late invoice, push back a purchase, or draw on a line of credit before you're forced into a worse option.
You don't need software for this — a spreadsheet with these columns does the job:
The discipline that makes this work is separating invoiced from expected to be paid. If a client owes you $4,000 net-30 and they've never once paid on time, don't put that $4,000 in the week it's due — put it in the week they'll actually pay, based on their track record. Optimistic forecasts are worse than no forecast at all, because they tell you everything's fine right up until it isn't.
Say you're starting week 1 with $8,400 in the bank. Here's how a rough patch shows up before it becomes a crisis:
| Week | Starting | Cash In | Cash Out | Ending |
|---|---|---|---|---|
| 1 | $8,400 | $3,200 (client A invoice) | $2,100 (subscriptions, contractor) | $9,500 |
| 2 | $9,500 | $0 | $2,600 (rent) | $6,900 |
| 3 | $6,900 | $1,800 (client B, partial) | $2,100 | $6,600 |
| 4 | $6,600 | $0 | $3,400 (quarterly software renewals + contractor) | $3,200 |
| 5 | $3,200 | $0 | $2,100 | $1,100 |
| 6 | $1,100 | $5,500 (client C, net-30 finally due) | $2,600 (rent) | $4,000 |
Nothing here looks alarming week to week. But look at week 5: you're sitting at $1,100 with $2,100 in fixed costs due and nothing scheduled to come in. If client C's payment in week 6 slips even a week — which, given it's the first time you've worked with them, is entirely plausible — you're negative before rent clears.
Without the forecast, you find this out on the day the rent payment bounces. With it, you found out in week 1, with five weeks to do something: send client C a deposit request, move up a smaller invoice, or delay the software renewals in week 4 until week 7.
Cash out is the easy half — it's mostly fixed and recurring, so build it once and adjust quarterly. Cash in is where the forecast lives or dies, and it should be pulled from real data, not hope. If you're using invoicing software, most platforms show you not just what's outstanding but the average days-to-pay per client, which is exactly what you need to place expected payments in the right week instead of the week they were technically due. Pair that with whatever accounting software you use for the expense side, and you can build most of a 13-week forecast in well under an hour the first time, and about 15 minutes a week after that to keep it current.
Set a recurring 15-minute block, ideally Monday morning before you start anything else. Three things:
Finding the gap is only useful if you have a short list of levers ready to pull:
The forecast doesn't fix cash flow problems. What it does is turn a surprise into a decision you get to make three or four weeks ahead of time, instead of a decision the bank makes for you.