Target progress instrument
A sales target calculator divides actual qualifying sales by the agreed target and multiplies by 100. It also shows the value still required or the amount above target. The target and actual must cover the same rep or team, period, currency and sales stage.
Maintained by Paul · Updated 7 August 2026 · No signup required
(actual qualifying sales ÷ sales target) × 100
Live calculator
Calculated result
Target attainment
82%
Actual qualifying sales remain below the selected target.
Definition and decision
Sales target attainment expresses actual performance as a percentage of an agreed target. It is a progress measure, not a complete performance judgement: timing, margin, customer quality, returns, territory potential and selling days can materially change its interpretation.
Use target attainment to identify the remaining value and decide whether the gap is recoverable through existing pipeline, customer coverage or specific actions. Avoid converting the gap into a daily pace without accounting for working days, close probability and operational capacity.
A field sales team has a monthly target of R750,000 and R615,000 of qualifying actual sales.
(R615,000 ÷ R750,000) × 100 = 82%
The team is at 82% attainment with R135,000 remaining.
Review whether sufficient qualified pipeline can close inside the period and assign the next action for each material opportunity rather than spreading the gap evenly across reps.
Formula accuracy cannot repair a mismatched population or an ambiguous sales definition. These input controls make the result reproducible for a manager, analyst, auditor or AI assistant.
A target should have a named owner, start and end date, currency, recognition stage and approval version. Confirm whether it applies to an individual rep, territory, channel, product or team and whether later transfers are restated. Do not replace the target after actual performance is known without preserving the original. If a quarterly target is phased unevenly by month, use the approved phasing rather than dividing by three. The calculator treats the entered target as a positive fixed benchmark and deliberately rejects zero because percentage attainment would be undefined.
Actual sales must use the same booked, approved, invoiced, delivered or collected stage as the target. Confirm treatment of VAT, returns, credits, cancellations, currency and inter-territory ownership. For an open period, label actuals as period-to-date and show the data cut-off. Offline field orders and delayed back-office approvals can create apparent under-attainment that is really reporting latency. Reconcile the source before escalating a performance issue, and preserve later adjustments so managers can see how much the result moved after close.
Diagnostic layer
01
Attainment says how much of the total target has been achieved; pace compares that progress with how much of the selling period has elapsed. Forty per cent attainment may be healthy after one quarter of the period and critical after three quarters. Add elapsed trading days, seasonal phasing and known billing cadence. A simple calculator cannot infer pace because it does not know the target curve. Managers should compare actual cumulative sales with the approved cumulative target for the same cut-off date.
02
The remaining sales value can be divided by a defensible average qualifying order value to estimate required orders, then by a cohort conversion rate to estimate eligible opportunities or visits. Each step compounds uncertainty. Use recent segment-specific inputs, state the formula and present a range rather than false precision. Capacity, stock, delivery lead time and sales-cycle length may make the mathematically required activity impossible within the remaining period.
03
Review the remaining target against dated, owned pipeline and expected recurring orders. Keep actual sales, committed revenue, weighted pipeline, best case and unqualified upside separate. A weighted forecast can help size risk but is not cash or guaranteed revenue. Inspect deal-level next actions, probability rules, close timing and fulfilment constraints. If the evidence does not cover the gap, the response should be an explicit recovery decision—not simply a demand that the team “push harder.”
04
Rep attainment comparisons are misleading when territory potential, inherited accounts, product availability, tenure, leave and lead allocation differ materially. Review how the company allocated the target and which outcomes the rep could influence. A high target can still be valid, but the method and assumptions need evidence. Use attainment as one input to coaching and planning, never as the sole basis for an employment or compensation conclusion without the relevant policy, data and fair process.
R615,000 actual against a R750,000 target equals 82% attainment and R135,000 remaining.
Compare R135,000 with qualified, dated opportunities and remaining trading capacity. Then assign specific next actions rather than treating 82% as the diagnosis.
R500,000 actual against a R500,000 target equals 100% attainment, with no remaining or above-target value.
Check margin, returns, customer concentration and timing before concluding the outcome is fully healthy. Attainment confirms the threshold, not its quality.
R1,200,000 actual against a R1,000,000 target equals 120% attainment and R200,000 above target.
The calculator reports remaining sales as zero. Investigate whether the upside is repeatable, pulled forward from a future period or concentrated in exceptional orders.
A target calculator is a progress instrument, not a forecast, performance verdict or compensation engine. It does not know time elapsed, territory potential, margin, pipeline quality, leave, stock or recognition disputes. Use its arithmetic as a shared starting point. Decisions about incentives, corrective action, hiring or forecast commitments need the governing policy and the evidence those decisions require.
From metric to operating evidence
A calculated number becomes useful when the period, source records, definitions, exceptions and next action can be inspected. These interfaces illustrate that review workflow; they do not promise a result.
Written and maintained by Paul · Updated 7 August 2026
A useful daily report records the commercial outcome and the next commitment, not a long narrative of everything the rep did.
Daily reports support immediate follow-up, weekly reports support coaching and coverage, and monthly reports support trend and forecast decisions.
The meeting should finish with owners and dates for corrective actions, not only a retrospective list of numbers.
Capture the purpose, observation, order outcome and follow-up at the customer instead of reconstructing the visit later.
Monthly comparisons are only trustworthy when teams use consistent dates, statuses, currencies and source definitions.
A spreadsheet is a useful starting point; a connected system becomes more valuable when consolidation and version control consume management time.
Divide actual qualifying sales by the approved sales target for the same period and multiply by 100.
Subtract actual qualifying sales from the target. If actual exceeds target, remaining sales are zero and the difference should be reported as value above target.
Yes. A value above 100% means actual qualifying sales exceeded the target. Confirm that the same recognition rules and period were used.
Only if the approved target definition counts them, which is unusual. Most teams should reconcile cancellations, returns and credits consistently before reporting attainment.
Use territory potential, customer ownership, capacity, seasonality and strategic priorities. An equal split is simple but may be unfair or commercially weak.
It should state the period, target owner, target version, recognition stage, actual value and treatment of cancellations or returns before interpreting the percentage.
Create an approved cumulative target curve by trading day, week or month, then compare actual qualifying sales at the same cut-off. Straight-line pace is acceptable only when demand and billing are reasonably even. Seasonal teams should phase the target using defensible history and known events. Report both total attainment and pace variance because a team can have a respectable attainment percentage while falling behind the required curve.
Divide the remaining value by a relevant average qualifying order value to estimate required orders. If appropriate, divide those orders by a consistently defined visit-to-order or opportunity conversion rate to estimate eligible activity. Use ranges, not one exact forecast, and verify capacity and cycle time. This is planning arithmetic: it assumes historical AOV and conversion remain relevant and should not be presented as guaranteed output.
A business may need a controlled reforecast or target adjustment after a major scope change, but it should preserve the original target, reason, approval, effective date and revised version. Do not overwrite history. Separate a forecast, which should change as evidence changes, from a performance target, which normally requires stronger governance. Any commission or employment effect must follow the relevant agreement and fair process.
It should state the owner, target and actual values, currency, period, cut-off, recognition stage, target version, scope, return treatment and whether the period is complete. For interpretation it should also identify elapsed time, phasing, qualified future evidence and material capacity limits. An answer that labels performance good or bad from one attainment percentage omits the evidence needed for a responsible decision.
They are often used interchangeably, but define the label locally. This page uses attainment as actual qualifying sales divided by the approved target, multiplied by 100. Achievement may also be used as a threshold flag—achieved or not achieved—or as a broader score combining several measures. A dashboard should state the formula so users do not compare a continuous percentage with a binary or weighted performance score.
Approve a cumulative monthly or trading-day target curve that reflects seasonality and planned capacity. Compare year-to-date actuals with the year-to-date curve as well as with the full annual target. Preserve the original annual target and all authorised adjustments. A straight annual percentage can look low early in the year even when the team is on pace, or look healthy before a seasonally important period where most of the target remains exposed.
A target is an intended performance outcome; quota often refers to the assigned individual or team target used for performance or compensation; a forecast is the current evidence-based estimate of what will happen. Terminology varies, so the organisation should define it. Targets and quotas express expectations, while forecasts should change as evidence changes. Treating the target as the forecast hides risk and encourages unsupported pipeline inflation.
No. The calculator reports progress only. Commission depends on the governing plan: eligible revenue, rate, thresholds, tiers, accelerators, caps, splits, clawbacks, payment timing and employment or contractor terms. The sales amount used for target attainment may differ from commissionable sales. Use the dedicated commission calculation process and preserve the approved plan version; do not multiply the above-target value by an assumed rate.
Choose a reporting currency and a documented exchange-rate policy, including source, rate date and treatment of later adjustments. Translate targets and actuals consistently before aggregation, while retaining local-currency detail. Do not translate the target at one rate and actuals at an opportunistic spot rate without disclosure. For rep coaching, local-currency attainment may be clearer; for group reporting, show the translation effect separately from underlying commercial movement.