Sales performance analysis: compare results with targets

Sales performance analysis compares actual sales with targets and prior results, then uses conversion and customer changes to explain the gap. Begin with totals that reconcile to finance, calculate each comparison on a consistent basis, and finish with actions tied to specific accounts or opportunities.

Start with the question and the exports

A useful monthly review answers: did the team meet its target, where did the shortfall arise, and what should change next month? The measure must match the target. A net invoiced sales target needs net invoiced sales actuals, rather than an opportunity amount labeled revenue.

Bring these files for the same reporting scope:

Keep credits negative and remove duplicate document-line combinations. Account names help people read the result; account identifiers keep two similarly named customers separate. Use the sales export preparation guide for the detailed column checks.

Retain targets in their own schedule. Attaching a rep's monthly target to every invoice and then summing that column multiplies the target by the number of invoice lines.

Build the rep comparison in Excel

Assume a US distributor is reviewing September 2026 against August. Its targets use net invoiced sales. The following table is the reconciled summary of its sales register and closed opportunity file; opportunities have one final outcome each.

Name the source tables Sales, Targets and Deals. Give each a Month column containing the first day of its reporting month as a real date, and put September 1, 2026 in a named cell ReviewMonth. In the summary, column A contains the rep. September actuals in D2 are:

=SUMIFS(Sales[NetSales],Sales[Rep],$A2,Sales[Month],ReviewMonth)

Target in E2 uses the same criteria against the separate schedule:

=SUMIFS(Targets[Target],Targets[Rep],$A2,Targets[Month],ReviewMonth)

Microsoft's SUMIFS documentation explains how the function adds values meeting multiple conditions. Check that the target schedule has exactly one approved row per rep and month before using it.

Count wins in F2 from the opportunity file:

=COUNTIFS(Deals[Rep],$A2,Deals[Month],ReviewMonth,Deals[Outcome],"Won")

Use "Lost" for G2. COUNTIFS counts records meeting all specified criteria; it does not remove duplicate opportunity IDs. Deduplicate the outcome export before counting. Covirage is not affiliated with Microsoft.

Calculate the gap and interpret it

Add the following calculations beside the summary and fill down:

Variance: =D2-E2
Attainment: =IF(E2=0,"",D2/E2)
Growth: =IF(C2=0,"",(D2-C2)/C2)
Win rate: =IF(F2+G2=0,"",F2/(F2+G2))

Percentages below are rounded to one decimal place. Keep the underlying formulas unrounded.

The team grew by $60,000 but missed its target by $20,000. Those statements can both be true. Team attainment is 660,000 / 680,000; team win rate is 29 / (29 + 27). Do not average rep percentages. The sales KPI definitions explain the other denominators a manager may need.

Ben's shortfall deserves investigation, but the table does not prove its cause. Read his lost opportunity reasons and changes in assigned customers. Cora's surplus offsets part of the other reps' gaps; it should not conceal them. Compare product groups within each region before deciding whether coaching, pricing or account coverage needs attention.

Prove the totals and explain customer movement

The actuals must satisfy this identity:

Net sales register = rep totals = region totals = finance's net sales total for the same scope.

East contributes 198,000 + 126,000 = $324,000 and West contributes 192,000 + 144,000 = $336,000. Together they equal $660,000. Unassigned revenue belongs in an explicit exception row until ownership is resolved.

Next, regroup the same invoices by account ID across both months:

The bridge proves 600,000 + 40,000 - 40,000 + 60,000 = $660,000. A customer absent this month is not automatically lost permanently. Check normal order frequency and open orders before labeling churn. Then review product changes within the continuing group so that expansion does not hide a shrinking line.

Use sales dashboard examples when choosing the presentation. The review itself should retain account and opportunity detail behind every conclusion.

Where it goes wrong

• Changing the target after the outcome. Keep the approved version and show later revisions separately.
• Mixing opportunity cohorts. Closed-deal win rate uses wins and losses decided in the same period, not wins divided by all open deals.
• Ignoring reassignment. Current ownership and historical sales credit answer different questions; label which one the comparison uses.
• Treating zero denominators as zero performance. Blank attainment means no valid target. It needs investigation, rather than a misleading percentage.

Do this on your own file in Covirage

Upload your sales workbook, target schedule and opportunity outcomes; Covirage maps the columns, and its tools compute and check the rep, region and customer comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring a sample of your own export.

See sales insights for the supporting workflow.