If you run a productized service—content writing packages, design retainers, SEO audits sold monthly—you’ve probably built a revenue forecast that looked great in January and fell apart by March.
The culprit: most operators model new bookings but treat churn as an afterthought. You add projected monthly recurring revenue from new clients, assume everyone renews, and wonder why actual cash is 20% lower than the spreadsheet promised.
Retainer businesses don’t grow linearly. They grow in steps, then lose a piece, then step again. Forecasting both movements—accurately—requires separating the two flows and tracking them with different assumptions.
Why churn breaks simple revenue models
A typical productized service forecast starts with current MRR, adds expected new clients at your average package price, multiplies by twelve months, and calls it done.
But retainer churn isn’t binary. Clients don’t all leave at once—they trickle out. A $2,000/month design retainer might churn in month four. A $500 content package might renew for eight months, then pause for two, then restart at $300.
If you’re forecasting new bookings at $10,000 MRR per month and losing $3,000 to churn every month, your net growth is $7,000—but most forecasts show $10,000 because churn is invisible until it happens.
The fix: track gross new MRR and gross churn MRR separately, then calculate net monthly change. This gives you three numbers instead of one, and it exposes whether you’re growing because you’re selling well or just because churn hasn’t caught up yet.
Model churn as a monthly percentage, not a yearly average
Annual churn rate—say, 25%—sounds manageable. But if you apply it evenly across twelve months, you’re assuming the same clients leave every period. That’s not how retainers work.
Clients churn in clusters: budget resets in January, mid-year strategy shifts in June, end-of-contract renewals in December. If you sell a six-month retainer, churn spikes in month seven. If you sell annual packages, churn concentrates around renewal month.
Instead of spreading 25% annually, model churn month-by-month based on contract length. If 40% of your clients are on six-month retainers, expect churn to spike every six months. If 30% are month-to-month, expect steady 5–8% monthly churn from that cohort.
Build a simple table: cohort start month, contract length, expected churn month. Then sum churn by month. It’s more work than a single percentage, but it prevents the surprise of losing $8,000 MRR in one week because five contracts ended simultaneously.
Forecast new bookings with a confidence tier
New bookings aren’t certain until the invoice is paid. But most revenue forecasts treat pipeline conversations the same as signed contracts.
Separate your bookings forecast into three tiers: signed and started (100% confidence), contract sent and verbally agreed (60–70%), active proposal or discovery call scheduled (20–30%). Multiply expected MRR by the confidence weight, then sum across tiers.
This gives you a weighted pipeline value instead of a binary “we’re closing five clients this month” guess. If you have $15,000 in signed MRR, $8,000 in sent contracts, and $12,000 in proposals, your weighted new MRR is $15,000 + ($8,000 × 0.65) + ($12,000 × 0.25) = $23,200, not $35,000.
Update the weights weekly. If your “sent contract” close rate is actually 80%, raise the multiplier. If proposals convert at 15%, lower it. The model gets more accurate the longer you run it.
Track the gap between bookings and cash received
Retainer invoices don’t always pay on time. A $3,000/month client might sign in August, start work in September, and pay the first invoice in October. Your MRR went up in August, but cash flow didn’t move until October.
Separate your forecast into two views: MRR booked (when the contract starts) and cash received (when payment clears). The gap between them is your working capital need.
If you’re booking $10,000 new MRR per month but cash lags 30 days behind, you need $10,000 in the bank to cover the gap. If half your clients pay net-30 and the other half pay upfront, the gap shrinks to $5,000—but it’s still there.
Most productized service operators don’t track this until they can’t make payroll. Build it into the forecast from the start: MRR booked this month, expected cash next month, any overdue invoices dragging into month three.
One spreadsheet, three tabs
You don’t need expensive forecasting software. A Google Sheet with three tabs works: one for new bookings (weighted pipeline), one for churn by cohort and contract length, one for net MRR and cash flow.
Update bookings weekly. Update churn monthly when contracts renew or cancel. Compare forecast vs. actual every month and adjust your confidence multipliers and churn rates based on what actually happened.
The forecast won’t be perfect. But it’ll be close enough to catch a cash crunch two months out instead of two weeks out—and that’s the difference between scaling smoothly and scrambling to replace a lost retainer overnight.
Want more operator-focused breakdowns like this? Subscribe to One Two Three Send—we publish daily guides on tools, workflows, and monetisation for people running online businesses.