TL;DR
Subscription revenue and one-off project or product sales have different risk profiles and need separate forecasting logic. Blending them into a single revenue line hides churn risk, obscures pipeline problems, and produces a forecast with false precision.
If your business generates both subscription revenue and one-off project or product sales, lumping them together in a single revenue forecast is a mistake. They behave differently, they have different risk profiles, and blending them in one line produces a forecast that is misleading in both directions.
What Owners Get Wrong
The most common error is adding contracted recurring revenue and projected one-off sales into a single "total revenue" line and then forecasting the combined number forward based on recent trends. The problem is that the two types of revenue are not equally predictable. Treating them the same inflates your confidence in the forecast.
Subscription revenue is relatively certain. If you have 50 customers paying $200 per month and your historical churn is 2 percent per month, you can project forward with reasonable confidence. That is a math exercise. The risk variable is churn, and you can estimate it from history.
One-off revenue is a pipeline problem. It depends on deals closing, projects being scoped, and customers making purchase decisions. It is much less predictable and needs to be built from a pipeline with probabilities attached, not extrapolated from last quarter's total.
Blending the two hides this distinction. When the one-off pipeline comes in light, the stable recurring base masks the shortfall. You hit your revenue number but for the wrong reasons. Or the reverse: a strong project quarter inflates the apparent baseline, making next quarter's budget unrealistic.
The CFO Perspective
I treat recurring and one-off revenue as two separate forecasting models that feed into a combined view. They have different inputs, different confidence levels, and different leading indicators.
For recurring revenue, the model starts with the current subscriber or retainer count, applies a monthly churn rate based on historical data, and then adds expected new customer additions based on conversion trends. The output is a monthly recurring revenue projection with a confidence range. This part of the forecast is relatively tight. You can be within 5 to 10 percent in a well-run business.
For one-off revenue, I build from the current pipeline. Each deal or project gets a probability and an expected close date. Multiply the value by the probability and sum across the pipeline. That gives you an expected value for one-off revenue, not a guaranteed number. The confidence range here is much wider, sometimes 30 to 50 percent in either direction depending on deal stage.
Combining them into a single forecast with a single variance band understates the risk on the one-off side and creates false precision overall. The right output is two lines with their own confidence notes, then a combined total.
What to Do About It
- Separate recurring and one-off revenue in your accounting system. This means assigning revenue to different categories or income accounts based on the type of sale. If they are mixed in one account, you cannot analyze them separately. Fix the bookkeeping first.
- Build a monthly recurring revenue (MRR) tracker. Track starting MRR, new MRR added, churned MRR, and ending MRR each month. This gives you a churn rate and a growth rate. Both feed the subscription forecast. Tools like QuickBooks do not do this automatically. You will likely need a simple spreadsheet.
- Maintain a live pipeline for one-off revenue. Every open opportunity should have an estimated value, a probability, and an expected close month. Update it weekly or after every client conversation. Your one-off revenue forecast is only as good as the pipeline behind it.
- Present the two revenue streams separately in your monthly review. Show recurring revenue versus plan and one-off revenue versus pipeline expectation. This tells a cleaner story and surfaces the right questions: is churn accelerating, or is the pipeline drying up?
- Set separate growth targets for each stream. A blended revenue target obscures which lever needs attention. If recurring revenue is growing but one-off revenue is falling, those require completely different responses. Separate targets make that visible.
Why It Matters for Planning
Recurring revenue is the foundation. One-off revenue is the accelerant. A business that knows exactly where its recurring base stands can make confident decisions about hiring, overhead, and investment. The one-off upside funds growth. But you need to see both clearly to make those calls. A blended forecast gives you a number without giving you a picture.
If you are adding subscription revenue to your business and want to build a forecast model that handles both streams properly, book a free call at peterxiacpa.com/book.
Next step: see it in your free Instant CFO Snapshot.
Frequently Asked Questions
- What is monthly recurring revenue (MRR) and how do you track it?
- MRR is the total contracted recurring revenue you expect to collect each month. Track it by recording starting MRR, adding new subscription revenue, subtracting churned revenue, and calculating ending MRR each month. This gives you a churn rate and a growth rate that form the basis of your subscription revenue forecast.
- How do you forecast one-off or project revenue?
- One-off revenue is forecasted from a pipeline. List each open opportunity with an estimated value, a probability of closing, and an expected close month. Multiply value by probability and sum the results to get an expected revenue figure. This is a probabilistic estimate, not a guarantee, so it should carry a wider confidence range than your recurring revenue forecast.
- At what point should a business start tracking MRR separately?
- As soon as you have more than a handful of recurring revenue clients or subscribers. Even at 10 to 15 subscribers, having a monthly MRR reconciliation takes 30 minutes and gives you a churn rate you can act on. Waiting until you have hundreds of subscribers means you have been flying blind during the most critical growth phase.
Get weekly CFO insights
No fluff. Real finance strategy for Canadian business owners. Unsubscribe any time.
Related Articles
How Much Detail Does a Budget Actually Need? Avoiding Over-Engineering
Over-engineered budgets with dozens of line items feel rigorous but rarely survive past the first quarter. The right level of detail is enough to surface the decisions that matter, which for most small businesses means 15 to 20 lines, not 80.
4 min readWhy Your Receivables Spike at Month-End and How to Smooth Out Invoicing
Batching all your invoices at month-end is the most common reason receivables spike and cash flow feels unpredictable. Spreading invoicing across the month flattens your AR, speeds up perceived collections, and makes cash flow much easier to forecast.
4 min readPricing a Software Subscription: How to Set a Price That Covers Your Costs
Pricing a software subscription on instinct or by copying competitors is how founders end up selling at a loss. The right approach starts with a cost-per-customer model, a gross margin target, and a clear view of how unit economics change as you scale.
4 min readNeed financial strategy for your business? Explore our CFO services or book a call.
