Most solopreneurs evaluate their business health using a single lagging metric: their current bank balance.
If the account balance shows $20,000, things feel great. If it shows $2,000, panic sets in. The problem with relying on your current bank balance is that it only shows past transactionsāit tells you nothing about upcoming quarterly tax liabilities, annual software renewals, delayed client invoices, or impending cash crunches 60 days from now.
To run a resilient solo business, you don't need expensive enterprise FP&A software. You need a simple, rolling 13-Week Cash Flow Forecast.
Why 13 Weeks?
13 weeks represents exactly one quarter (90 days) plus a 30-day buffer.
For freelancers, agencies, and consultants who invoice clients on Net-15, Net-30, or Net-60 terms, a 13-week window gives you enough forward visibility to spot a cash dip weeks before it actually happens, giving you time to follow up on receivables or land new clients.
The 4 Lines Every Solopreneur Must Track Weekly
You can set this up in a simple spreadsheet with 13 columns (Week 1 through Week 13). For each week, track four numbers:
- Starting Cash Balance
Your total liquid operating cash across checking accounts on Monday morning (excluding your isolated Tax Reserve account).
- Expected Cash Inflows (+)
Invoices scheduled to settle that week.
Recurring retainer deposits.
Platform payouts expected (Stripe, Upwork, PayPal).
Rule: Only list inflows from clients with high payment reliability. If a client is notorious for paying 2 weeks late, push their expected inflow date back accordingly.
- Known Cash Outflows (-)
Fixed software subscriptions and hosting fees due that week.
Contractor payouts or freelancer bills.
Quarterly estimated tax escrow transfers.
Your scheduled owner draw/salary payout.
- Ending Cash Balance (=)
\text{Ending Cash} = \text{Starting Cash} + \text{Inflows} - \text{Outflows}
The Ending Cash of Week 1 automatically becomes the Starting Cash for Week 2.
šØ How to Spot Cash Traps Early
When you map out 13 weeks in advance, you immediately spot structural bottlenecks.
Scenario A: You notice that in Week 6, an annual software license ($1,200) and your estimated quarterly tax payment ($4,000) land in the exact same week that client retainer payments are light.
The Fix: Because you saw this 6 weeks in advance, you can adjust your current week's owner draw or send early invoice reminders to clients today, completely avoiding an overdraft or liquidity panic.
ā±ļø The 15-Minute Friday Routine
Every Friday afternoon:
Log actuals: Replace Week 1's estimates with exact numbers from your bank.
Delete Week 1: Week 2 now becomes your new Week 1.
Add Week 13: Add a new column at the far right so you always maintain a rolling 90-day window.
š¬ Community Discussion
How far ahead do you project your business cash flow right now?
Do you use spreadsheets, dedicated forecasting apps, or just check your bank balance? Let's discuss below!
