Ask a room of solo consultants how much cash they have and most can answer to the nearest hundred. Ask them how much cash they'll have in ten weeks and the room goes quiet. Not because the question is hard — because nobody taught us to ask it, and the answer requires a habit, not a talent.
This article is the whole method: why thirteen weeks is the right window, how to structure the forecaster, and the fifteen-minute Friday ritual that keeps it alive. You can build the spreadsheet yourself in an afternoon from what's below. The structure matters more than the tool.
Why thirteen weeks and not twelve months
Annual budgets are fiction for a one-person business. Your revenue next November depends on clients you haven't met and projects that haven't been scoped. A twelve-month forecast is really a wish with a column layout, and the further right you scroll, the more it lies.
Thirteen weeks is different for three reasons.
First, it's a quarter. It lines up with estimated tax payments and the natural cadence of client work, so the forecast intersects with obligations you actually owe on dates you actually know.
Second, it's the visibility horizon of a pipeline. Most solo operators can see their next four to eight weeks with real confidence — signed work, sent invoices, active retainers. Weeks nine through thirteen are fuzzier but anchored by renewal dates and historical averages. Past week thirteen, you're inventing numbers, and invented numbers are worse than no numbers because they feel like information.
Third, it's short enough to keep current. A forecast you update in fifteen minutes survives. A forecast that takes an hour becomes a monthly chore, then a quarterly one, then a spreadsheet from last year that you feel guilty about.
The goal isn't to predict the future. It's to see the present clearly enough that the future stops ambushing you.
The structure: three blocks and a running balance
The forecaster is one sheet. Columns are weeks — Week 1 through Week 13, each labeled with its Monday date. Rows fall into three blocks.
Block 1: Inflows
One row per expected source of cash, by the week it lands — not the week you invoice, the week you reasonably expect money in the account. Typical rows:
- Retainers — the reliable floor. Enter the actual amount and week of collection.
- Project milestones — deposits and milestone payments from signed work.
- Outstanding invoices — anything already sent, placed in the week you expect payment based on that client's history, not their payment terms. A client who always pays net-45 pays net-45 even on a net-30 invoice.
- Probable work — proposals out, verbal yeses. I enter these at half value. It feels pessimistic; it's usually accurate.
Sum the block into a total-inflows row.
Block 2: Outflows
Same idea, money leaving. Rows worth their own line:
- Your draw or salary — first, not last. A forecast that treats your pay as "whatever's left" produces months where nothing is left.
- Tax set-aside — a formula, not a guess: a fixed percentage of that week's inflows, moved to a separate account mentally or literally.
- Fixed costs — hosting, tools, insurance, coworking. These are small but they never miss a week.
- Known one-offs — quarterly taxes, the laptop you're replacing in week 7, the annual domain renewal. Each gets its week.
- A buffer line — a standing five or ten percent of average weekly outflow, because every month contains one expense you didn't see coming.
Sum into total-outflows.
Block 3: The running balance
Three rows do all the work:
Net this week = total inflows − total outflows Opening cash = last week's closing cash (Week 1 opens with today's bank balance) Closing cash = opening cash + net this week
That closing row is the whole point. Read it left to right and it tells you the two things every solo operator needs to know: does the balance ever dip toward zero, and in which week? A dip in week 9 you can see in week 2 is a scheduling problem. The same dip discovered in week 9 is a crisis.
The fifteen-minute Friday habit
The spreadsheet is the easy half. The habit is the business half. Mine runs Friday at 3 PM, timer enforced, and it has exactly five steps:
- Reconcile (5 min). Open the bank and card accounts. Delete forecast rows for money that arrived, enter what actually happened. The forecast is a guess; last week is now a fact.
- Roll the window (1 min). Week 1 is done — delete the column, add a new Week 13 on the right. The window always stays thirteen weeks wide.
- Update expectations (5 min). Anything new signed? Any invoice sent? Any client gone quiet on a payment? Move rows to their honest weeks. This is where the discipline lives: the probable-work row gets edited with your head, not your hopes.
- Read the closing row (2 min). Find the lowest point of the thirteen weeks. If it dips below one month of outflow, that week has a name and a date. Write both down.
- One action (2 min). Exactly one: chase the late invoice, send the proposal follow-up, move an expense, raise the price on the thing you're quoting Monday. One action, then close the laptop. The habit survives because it's small.
Fifteen minutes a week, and you will never again be surprised by your own bank account. That sentence sounds too simple. It's been true for me for years.
The mistakes that kill the habit
Forecasting revenue instead of cash. A signed contract is not cash. An invoice is not cash. Cash is cash. The forecaster only counts money when it moves, and confusing the two is how profitable people overdraw.
Being optimistic in the probable row. Every consultant's forecast fails the same way: pipeline deals entered at full value in the best-case week. Halve the value, push it out two weeks, and the forecast starts telling the truth.
Letting the update ritual grow. The moment the Friday check-in takes an hour, it's dead. Keep it at fifteen minutes even when you have more to say — write the extra thoughts somewhere else.
Skipping the bad weeks. The habit is most valuable precisely when you don't want to look. A dip you watch approaching for six weeks is a problem you manage. A dip you refused to look at is an emergency you pay for.
Reading the trend, not just the number
After about six weeks of keeping the forecast, a second skill develops: you stop reading the closing balance and start reading its shape. A balance that declines steadily and recovers on retainer day is a healthy cycle — the low point is just the rhythm of your billing. A balance whose peaks get lower each month is a business quietly shrinking, even if every individual week looks fine. And a balance that depends on one large inflow in week 11 is telling you something important about concentration: that one client is your single point of failure, and the forecast just quantified exactly how much of one.
This is also where the forecast starts paying for itself in decisions. A prospective project that lands its payment in your week-9 dip is worth more than a bigger one that pays in week 14. A tool subscription that renews annually looks different when you see it land in the same week as your tax payment. None of this requires finance training — it's the same closing row, read with six weeks of context behind it.
Start smaller than you think
If thirteen weeks feels like a lot, start with four rows: money in, money out, net, running balance. You can add texture later. The operators who stick with this are the ones who started ugly and simple, not the ones who built a cathedral in week one and abandoned it in week four.
If you want a quick answer before you build anything, the free runway calculator on this site will tell you your months of runway from three numbers in about a minute, entirely in your browser. And if you'd rather skip the afternoon of spreadsheet work, the Cash Flow Command Center ($39) is this exact 13-week structure — forecaster, P&L dashboard, invoice tracker with aging, runway calculator — already built, formula-live, and tested in both Excel and LibreOffice. It's the workbook I run this studio on. Either way, build the Friday habit. The tool is replaceable; the fifteen minutes are not.