Most teams discover a revenue miss when the quarter-end number lands. By then the cause is two months old and the fix is no longer possible. Tracking plan vs actual on a weekly rhythm moves that discovery to week three, when there is still time to act. This guide shows how to track plan vs actual revenue so that a small gap gets fixed before it becomes a missed quarter.
Quick answer: To track plan vs actual revenue, start from a locked plan broken into weekly targets for each funnel stage (leads, qualified leads, opportunities, closed deals). Each week, compare cumulative actuals to cumulative plan, flag any stage more than 10 to 20% behind, and find out whether the gap is volume, conversion or deal value. Track pipeline first and revenue second, because pipeline moves weeks before revenue does.
Plan vs actual: a short explainer
Plan vs actual is a comparison between what you said would happen and what did happen, measured on the same definitions over the same period. The difference between the two is called variance.
The idea is simple. The value comes from where and when you measure it. Comparing closed revenue to target at the end of the month tells you that you missed. Comparing pipeline created, conversion rates and sales activity to plan in week three tells you why you are about to miss, while you can still change the result.
It differs from forecasting in one way. A forecast predicts the outcome from current data. Plan vs actual measures your distance from the intended path and shows which part of the path you are drifting from.
Why week 3 beats month 3
Revenue is a lagging number. A deal that closes in week twelve was a lead in week one or two. If leads are short in week three, the shortfall will not appear in closed revenue until much later, and it will arrive as a surprise.
Time to correct is the other factor. If your sales cycle averages 60 days, any pipeline created in the last month of a quarter will not close in that quarter. A team that spots a lead shortage in week three has about ten weeks to rebuild pipeline. A team that spots it at the end of month three has none. The gap is the same size. The ability to close it is not.
Step 1: Lock the plan before the period starts
You cannot measure drift without a fixed starting line. Before the quarter begins, write the plan down and freeze it.
- One revenue definition. New revenue, total revenue or recurring revenue. Pick one.
- A funnel built backward from the target. Take the target, divide by average deal size, then apply your win rate and stage conversion rates to find the volume needed at each stage.
- Weekly targets per stage. Spread each volume across the weeks, adjusting for ramp time, seasonality and campaign launches rather than dividing evenly.
Keep the original plan untouched. If you rebuild the plan every time results slip, you will never see how far off the original was. Record revisions separately as a new version with a date and a reason.
Step 2: Choose indicators for every funnel stage
Tracking only closed revenue is the most common way teams end up late. Track one measure for each stage so you can see where the flow slows.
- Top of funnel: marketing leads created, by source.
- Middle: sales-qualified leads and sales opportunities created, with pipeline value.
- Bottom: closed-won deals, average deal size and sales cycle length.
- Activity: meetings booked, outreach sent, campaigns launched on schedule.
Split the early stages by lead source. A blended lead count can look on plan while one channel collapses and another hides it. For help with channel-level numbers, see our guide on how to calculate CAC by lead source.
Step 3: Compare cumulative actuals to cumulative plan
Weekly numbers are noisy. A single slow week proves little. Compare running totals from the start of the period to the same point in the plan. Below is a worked example for a quarter with a $1,200,000 new-revenue target, a $30,000 average deal and a 25% win rate. At the end of week three, the funnel looks like this.
| Stage (cumulative to week 3) | Plan | Actual | Variance |
|---|---|---|---|
| Marketing leads | 462 | 330 | -29% |
| Sales-qualified leads | 92 | 66 | -28% |
| Sales opportunities | 37 | 27 | -27% |
| Pipeline value created | $1,110,000 | $810,000 | -27% |
| Closed-won deals | 9 | 0 | Too early to judge |
Closed revenue shows nothing wrong yet. It is the stage that lags. Everything upstream is roughly 27 to 29% behind, which would be invisible in a month-end revenue report and obvious in a week-three review.
Step 4: Diagnose where the variance sits
A gap is only useful if you know its cause. Check four things in order.
- Volume. Are enough people entering the stage? In the example, lead volume is 29% short.
- Conversion. Are they moving to the next stage at the planned rate? Lead-to-qualified is 20% in plan and 20% in actuals (66 of 330), and qualified-to-opportunity is 41% against 40% planned. Conversion is healthy.
- Value. Are deals the planned size? Check average deal value and discounting.
- Timing. Are deals slipping to later periods, or is the sales cycle stretching?
In this example the problem is volume alone. The team does not need new sales training. It needs more top-of-funnel activity, from a stronger source mix, more spend, or a delayed campaign that should have launched. Fixing the wrong problem is expensive, which is why diagnosis comes before action.
Step 5: Set thresholds and pre-agreed responses
Decide in advance how big a variance must be before it triggers action. A simple traffic-light system works well as a starting point.
- Green: within 10% of plan. Keep going.
- Amber: 10 to 20% behind. Find the cause and prepare a response.
- Red: more than 20% behind. Act this week.
Attach an action to each trigger ahead of time, for example: “if qualified leads are amber for two consecutive weeks, we shift budget to the best-performing source.” Pre-agreed responses turn the review into a decision meeting instead of a debate about whether the number is real. Adjust the percentages to suit your sales cycle and volume. Low-volume teams should expect wider swings.
Step 6: Run a weekly 30-minute review
The review is where tracking becomes control. Keep it short and structured.
- Show cumulative plan vs actual for each stage.
- Name the stages that are amber or red.
- State the cause: volume, conversion, value or timing.
- Agree one action, one owner and a date.
Revisit the full plan at the end of each month and re-forecast the quarter. If the variance cannot be recovered, say so early and reset expectations with the board while the conversation is still manageable.
Common plan vs actual mistakes
- Rewriting the plan to match results. This erases the evidence of drift. Version the plan instead.
- Tracking revenue only. By the time revenue misses, the cause is old.
- Using different definitions. If sales counts a qualified lead one way and marketing another, variance means nothing.
- Reacting to one week. Use cumulative totals so normal noise does not trigger false alarms.
- Reporting without owners. Every stage needs a named person responsible for the number.
- Keeping the numbers in separate spreadsheets. Teams that hold their own versions spend the review arguing over data.
What to do next
Pick the next quarter and build the weekly plan before it starts. Assign an owner to each stage, schedule the weekly review now, and agree the red-line triggers. Then compare your first three weeks of actuals to plan. You will learn more from that comparison than from any month-end report.
Frequently asked questions
How do I track plan vs actual revenue?
Start with a frozen plan broken into weekly targets for each funnel stage. Each week, compare cumulative actuals to cumulative plan, flag stages that are more than 10 to 20% behind, and identify whether the cause is volume, conversion, deal value or timing. Track pipeline before revenue, since pipeline moves first.
What is plan vs actual in revenue planning?
It is a comparison of planned results to real results, using the same definitions and time period. The difference is the variance, and it shows where execution is drifting from the plan.
How often should I review plan vs actual?
Weekly for leading indicators such as leads, opportunities and pipeline value, and monthly for the full plan and re-forecast. Teams with short sales cycles may want to look more often.
What is a good variance threshold?
Many teams use within 10% as healthy, 10 to 20% as a warning and more than 20% as needing immediate action. Treat these as a starting point and tune them to your own volume and sales cycle.
What is the difference between plan vs actual and forecasting?
Forecasting predicts the likely outcome from current data. Plan vs actual measures how far you are from your intended path and where the gap is. Used together, they show both where you are heading and why.
See plan vs actual in real time
Premonio’s Digital Revenue Twin keeps a live plan-vs-actual view of your go-to-market, with early warnings and recommended corrective actions, so you can see the gap in week three instead of month three.
[CTA: Get Free Demo / Book a call with Premonio]
