How to Create Financial Projections for Your Freelance Business
I was blindsided by a slow quarter in year 2 because I wasn’t looking ahead. Q3 hit and I had no projects in the pipeline beyond my retainers. Two months of reduced income, scrambling for work, and a nasty dip in my business checking balance.
Since then, I’ve maintained a rolling 3-month projection. It’s not complicated — a Google Sheet that takes 15 minutes to update monthly. But it’s prevented every subsequent surprise.
Here’s the exact framework I use, along with the templates, formulas, and decision triggers that make projections actually useful instead of just numbers on a spreadsheet.
Why Freelancers Need Financial Projections
Most freelancers operate reactively — they notice income dropped when the bank balance gets low. By then, it’s too late. You’re already in a cash crunch, scrambling for work, and making desperate decisions.
Financial projections flip this dynamic. Instead of reacting to problems, you see them coming 6-8 weeks ahead. That’s enough time to:
- Increase marketing and outreach before the slow period hits
- Follow up on outstanding proposals more aggressively
- Adjust spending if revenue is trending down
- Line up short-term projects to fill gaps
- Avoid overcommitting during artificially busy periods
The projection doesn’t need to be accurate to the dollar. It needs to be directionally correct — telling you whether next quarter looks strong, average, or concerning. Even a rough projection is infinitely better than no projection.
The Simple Projection Framework
Confirmed Income (High Confidence — 90%+ likely)
- Retainer contracts: $7,500/month (predictable, contracted)
- Signed project milestones: varies (payment dates known, contracts signed)
- Recurring revenue: Digital products, affiliate income, other predictable sources
Rule: Only confirmed income has a signed contract or established pattern (12+ months of history).
Probable Income (Medium Confidence — 40-60% likely)
- Proposals sent, awaiting acceptance: 50% probability
- Verbal agreements, not yet signed: 60% probability
- Repeat clients who historically return: 30% probability
- Leads in active conversation: 20% probability
Rule: Weight probable income by its likelihood. A $5,000 proposal at 50% probability counts as $2,500 in your projection. This prevents both overoptimism and excessive pessimism.
Expected Expenses (Known — 95%+ accurate)
- Fixed monthly expenses: $664 (software, services, insurance)
- Tax savings: 28% of income (set aside, not negotiable)
- Personal salary: $4,500/month (what you pay yourself)
- Quarterly tax payments: $3,600/quarter (four times per year)
- Variable business expenses: ~$200/month (estimated based on 6-month average)
Rule: Track expenses for 3+ months before projecting. Use averages for variable expenses and exact amounts for fixed ones.
My Q2 2026 Projection Example
| April | May | June | |
|---|---|---|---|
| Retainers (confirmed) | $7,500 | $7,500 | $7,500 |
| Project A milestone (confirmed) | $2,500 | — | — |
| Project B proposal (50% prob) | — | $2,000 | $2,000 |
| Repeat client inquiry (30% prob) | — | — | $1,500 |
| Expected income | $10,000 | $8,500 | $8,950 |
| Tax savings (28%) | -$2,800 | -$2,380 | -$2,506 |
| Business expenses | -$664 | -$664 | -$664 |
| Personal salary | -$4,500 | -$4,500 | -$4,500 |
| Quarterly tax payment | -$3,600 | — | — |
| Net cash flow | -$1,564 | $956 | $1,280 |
This projection tells me: April will be tight (quarterly payment + normal expenses). May and June look fine. If the probable income doesn’t materialize, I’ll need to lean on the business buffer.
Action items from this projection:
- Increase outreach in March to fill May-June pipeline
- Ensure business buffer can cover April’s negative cash flow
- Follow up on Project B proposal aggressively
- Consider offering a retainer conversion to the repeat client inquiry
Building the Projection Spreadsheet
Here’s how to set up your own projection in Google Sheets:
Tab 1: Income Tracker
| Client/Source | Type | Monthly Amount | Status | Probability | Weighted Amount |
|---|---|---|---|---|---|
| Client A | Retainer | $3,000 | Active contract | 95% | $2,850 |
| Client B | Retainer | $2,500 | Active contract | 95% | $2,375 |
| Client C | Retainer | $2,000 | Active contract | 95% | $1,900 |
| Project D | Project | $4,000 | Signed | 90% | $3,600 |
| Project E | Project | $3,500 | Proposal sent | 50% | $1,750 |
| Lead F | Project | $2,000 | In conversation | 20% | $400 |
Tab 2: Expense Tracker
List every recurring expense with its monthly cost. Include annual expenses divided by 12 (insurance, domain renewals, annual subscriptions). Add a line for variable expenses using your 6-month average.
Tab 3: Monthly Projection
Use formulas to pull from your income and expense tabs. The key formula: =SUMPRODUCT(income_amounts, probabilities) - total_expenses. This gives you projected net cash flow for each month.
Tab 4: Actual vs. Projected
After each month ends, record what actually happened next to what you projected. This variance tracking improves your future projections dramatically.
The Scenario Planning Approach
I run three scenarios for each quarter:
Best case: All probable income materializes + I land one new project I haven’t seen yet. Probability: 15%
Base case: Confirmed income + 50% of probable income. Probability: 60%
Worst case: Only confirmed income, no new projects, one retainer pauses. Probability: 25%
| Scenario | Q2 Income | Q2 Expenses | Q2 Net |
|---|---|---|---|
| Best | $32,000 | $23,500 | +$8,500 |
| Base | $27,450 | $23,500 | +$3,950 |
| Worst | $20,000 | $23,500 | -$3,500 |
The worst-case scenario is the one that drives decisions. If worst case means I can’t cover expenses, I need to take action now — not when it happens.
Decision triggers:
- Worst case negative by more than one month’s buffer → Increase marketing immediately
- Base case barely positive → Start reaching out to past clients
- Best case lower than target → Evaluate pricing and service offerings
Seasonal Patterns: Your Secret Weapon
After 2-3 years of freelancing, you’ll notice seasonal patterns. For most B2B freelancers:
- January-February: Slow (clients recovering from Q4 spending freezes)
- March-May: Strong (new budgets, new projects)
- June-July: Moderate (summer slowdowns)
- August-September: Strong (Q3/Q4 project pushes)
- October-November: Moderate to strong (year-end projects)
- December: Slow (holiday season, budget freezes)
Track your monthly revenue for 2+ years and you’ll see YOUR specific patterns. Overlay these patterns on your projections for more accurate forecasting.
For example, if June is historically 25% below your average month, adjust your June projection downward even if the pipeline looks good. Some of those deals will push to August.
When to Update
Monthly: Update confirmed income for the next 3 months. Add new proposals, remove expired ones, adjust probabilities based on client communication.
After every proposal/contract: Add it to the projection immediately. A proposal sent today affects your 30-60 day income outlook.
Quarterly: Do a full 12-month rough projection for annual planning. This is less about monthly accuracy and more about identifying seasonal gaps and planning for taxes.
When something changes: Lost a retainer? Add it to the projection immediately and see the impact. Landed a big project? Same thing. Real-time updates keep the projection useful.
Common Projection Mistakes
Overweighting probable income. New freelancers treat proposals as confirmed income. They’re not. Until the contract is signed and the deposit is paid, a proposal is a probability, not a certainty. Be conservative with your weights.
Ignoring expenses. Projecting income without expenses gives you a false picture. A $10,000 income month with $9,500 in expenses isn’t a good month — it’s barely breaking even.
Not tracking variance. If you never compare projected vs. actual, your projections don’t improve. Spend 5 minutes each month recording what actually happened.
Projecting too far ahead. Beyond 3 months, freelance projections are largely fiction. Use 12-month rough projections for annual planning, but make decisions based on the 3-month window.
The Bottom Line
Financial projections for freelancers aren’t about predicting the future perfectly. They’re about seeing problems early enough to prevent them. A 15-minute monthly spreadsheet update gives you weeks of advance warning — enough time to market, follow up on proposals, or adjust spending before a cash flow crunch hits. If you’re exploring this area, our The 12 Financial Mistakes That Almost Killed My guide covers it in detail.
Start simple: confirmed income + weighted probable income - known expenses = projected cash flow. Update monthly. Track variance. Adjust. That’s the entire system. It’s not complicated, but the freelancers who do it consistently are the ones who never get blindsided.