Cash Flow Forecasting for Solo Businesses — See the Lean Weeks Coming
Profit is an opinion; cash is a fact. Solo businesses fail from timing, not from unprofitability: invoices land after the rent does. A 13-week rolling forecast makes the timing visible — which weeks get lean, which invoices must land, and when "busy" still means "broke" for six more weeks.
This guide builds the forecast in one sitting: the weekly grid, payment-timing assumptions based on your real collections, three scenarios, and the triggers that turn the forecast from spreadsheet to steering wheel.
The short answer
- A 13-week horizon is the working standard — long enough to see problems, short enough to stay accurate.
- Businesses that forecast weekly catch cash gaps six to ten weeks earlier than those watching bank balances.
- For service businesses, invoicing timing moves cash by 30-60 days — the forecast’s whole value is modeling that lag honestly.
Who this playbook is for
Built for profitable solo founders who still get surprised by weeks where the account balance and the P&L disagree.
Step 1: Build the 13-week grid in one sitting
Columns: week 1 to 13. Rows: opening balance, committed inflows (signed retainers, milestone invoices due), expected inflows (probable deals, weighted), committed outflows (rent, subscriptions, taxes, contractor pay), discretionary outflows, closing balance. One spreadsheet hour. The grid is the forecast; everything else is maintenance.
Step 2: Model inflows by collection reality, not invoice dates
Your invoices land when they land: pull your actual average days-to-payment (see the payment terms system) and offset each expected invoice accordingly. Retainers on the 1st, milestone payments 14 days after delivery — the grid uses your history, not your hopes. This single discipline is what makes forecasts true.
Step 3: Run three scenarios every update
Base: signed work per the grid. Downside: the two biggest probable deals slip a month, one retainer churns. Upside: pipeline closes at historical rates. If downside closing balance dips below your floor (one month of expenses is the solo standard), the forecast has done its job — you now know weeks in advance.
Step 4: Update weekly in fifteen minutes
Monday: actuals into week one, shift the window forward one week, adjust inflows for anything signed or slipped. Fifteen minutes. Forecasts die from monthly updates — too slow to catch changes — and from perfectionism. The rolling window with quick Monday updates is the sustainable form.
Step 5: Set the response triggers in advance
Trigger 1: downside scenario breaches floor within 13 weeks → accelerate collections, defer discretionary spend, pull sales forward. Trigger 2: base scenario dips under one month of expenses → same, sooner. Trigger 3: upside sustained for a quarter → deliberate reinvestment decisions, not drift. Pre-committed triggers convert forecasts into decisions instead of dashboards.
Your weekly operating rhythm
| Day | Action | Time |
|---|---|---|
| Monday | Update the grid: actuals, new inflows, roll forward | 15 min |
| Monthly | Scenario refresh + assumptions audit | 30 min |
| Quarterly | Forecast vs reality review: how wrong were you? | 30 min |
| Any trigger | Response per the pre-committed plan | as needed |
KPIs that tell you it is working
| Metric | Healthy target | Why it matters |
|---|---|---|
| Forecast accuracy (4-week out) | Within 15% | Improves automatically with collection history |
| Weeks of runway | Known at all times | The one number the grid exists to produce |
| Lowest projected balance | Above floor in base case | The early-warning line |
| Forecast update streak | Weekly, unbroken | The habit that makes the tool real |
Common mistakes to avoid
- Forecasting revenue by pipeline optimism. Probable deals get weighted probabilities (30-50%), and downside assumes they slip — hope is not a modeling assumption.
- Updating monthly or "when it feels tense". The 13-week tool needs weekly motion; a stale forecast is a photo of a moving river.
- Ignoring tax set-asides in outflows. The quarterlies are the largest predictable outflow a solo business has — leave them out and every forecast flatters you.
A tool stack that fits a one-person budget
| Tool | Where it fits |
|---|---|
| Google Sheets | The 13-week grid — a template, honestly |
| Your bookkeeping export | Actual collection timing history |
| Stripe / bank feeds | Weekly actuals for the Monday update |
| Calendar | The Monday 15-minute update block |
Keep going
Use these internal references while implementing this guide:
- One Person Company Hub
- How to Start a One Person Company
- Solopreneur Operating System
- Escrow and Milestone Protection
- Profit First for Solopreneurs
- Margin Over Volume
FAQ
Q: How is this different from just watching my balance?
The balance shows today; the forecast shows the next 13 weeks including invoices not yet paid, work not yet invoiced, and obligations not yet due. Founders watching balances get surprised by lag; founders forecasting see the lag coming and price, invoice or sell against it.
Q: What cash floor should a solo business hold?
One month of total expenses is the minimum floor; three is the real target (see the emergency fund guide). The forecast’s job is keeping the projected floor line visible so you act weeks before touching it.
Q: My revenue is lumpy project work — does this still work?
Especially then. Lumpy revenue is precisely where balance-watching fails, because lumps arrive late. Model each project’s milestones with your actual collection lag, and the lumpy pattern becomes a visible wave you can plan hiring, spending and pricing around.
Q: Can AI maintain this for me?
As the bookkeeper’s apprentice: AI pulls actuals, flags anomalies (invoices aging past assumption), drafts the Monday summary. The assumptions and scenarios stay yours — they encode your knowledge of which clients pay and which deals are real.
Get the weekly operating brief
Every Monday: 3 moves, 5 minutes. Actionable strategy for your one-person company — no fluff, no filler.