← All posts

The 13-Week Cash Flow Forecast Every Solo Founder Needs

7/16/2026 · by Mykel Franklin

Why "profitable" doesn't mean "safe"

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.

Why 13 weeks specifically

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.

Building it: five columns, one spreadsheet

You don't need software for this — a spreadsheet with these columns does the job:

  1. Week ending date — 13 rows, one per week
  2. Starting balance — your actual bank balance for week 1, then it carries forward
  3. Cash in — every dollar you actually expect to land in the account that week (not invoiced, received)
  4. Cash out — every dollar leaving the account that week: payroll, contractors, software subscriptions, rent, loan payments, taxes
  5. Ending balance — starting balance + cash in − cash out, which becomes next week's starting balance

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.

A worked example

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.

Where the numbers actually come from

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.

The weekly ritual

Set a recurring 15-minute block, ideally Monday morning before you start anything else. Three things:

What to actually do when you spot a gap

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.

Related

Client Onboarding on Autopilot: A Solo Founder's ChecklistAutomating Client Onboarding as a Solo Founder (No Losing the Personal Touch)5 AI Automations That Save Solo Founders 10+ Hours a Week