Deduction metrics

Deduction KPIs: Definitions and Formulas

This guide defines the KPIs finance and credit teams use to measure a deduction workload.

The KPIs cover size relative to sales, age, how much gets challenged, how much comes back, and what it costs to run.

Every formula here is a definition, not a target. No metric carries a benchmark or an industry average.

Looking for the underlying distinction between a deduction and a chargeback? Start at the glossary's chargeback-vs-deduction entry.

Balance and velocity metrics

A DEFINITION, NOT A TARGETOpen Deductions BalanceTaken, but not yet resolvedTotal Sales in the PeriodGross invoiced sales, same period×Number of Days in the PeriodLength of the sales period used=Days Deductions OutstandingSales-normalized, tracked over time
Every formula on this page is a definition, not a target.
A STARTING POINT, NOT A DEADLINE CALENDARNewerOlderZero to thirty daysOpen deductions aged from the posted dateThirty-one to sixty daysSame aging clock, next bucketSixty-one to ninety daysSame aging clock, third bucketNinety-plus daysPrioritizes review and dispute effort toward the oldest open dollarsSurfaces how much of the balance is old enough to be at risk ofa retailer's dispute deadline passing, rather than one undifferentiated figure
The buckets are a starting point, not a deadline calendar.
KPIFormulaWhat it tells youCommon pitfall
Days Deductions Outstanding (DDO)Divide Open Deductions Balance (taken but not yet resolved) by Total Sales in the Period. Multiply by Number of Days in the Period.How large the open-deduction balance is relative to sales, in days. The deduction-side counterpart of Days Sales Outstanding.Mixing a trailing sales figure with a point-in-time balance without stating the convention.
Deduction rateDivide Total Deductions Taken in the Period by Gross Sales in the Period. Multiply by One Hundred Percent.How large deductions were relative to sales. It measures scale, not validity.Mixing a count with a dollar figure, or an invoice-date period with a remittance-date period.
Aging bucketsAge equals Current Date minus Deduction Posted Date. Sum the dollars in each bucket. The buckets are zero to thirty, thirty-one to sixty, sixty-one to ninety, and ninety-plus days.How much of the open balance is old enough to risk a missed retailer dispute deadline. The buckets are a convention, not a deadline calendar.Using posted, discovered and dispute-filed dates as one clock.

Dispute and outcome metrics

WHERE EACH RATE'S TWO NUMBERS COME FROMDeductions receivedDispute rate (by count):number disputed ÷ number receivedDisputedNot disputedRecovery rate (by dollars):dollars reversed ÷dollars disputedReversedWritten offStill openClosed (reversed, written off, or otherwise settled)Write-off rate (by dollars):dollars written off ÷ dollars closedNot yet reached a final stateA SEPARATE QUESTION: VALID VERSUS INVALIDReviewed deductionsDetermined validDetermined invalidA deduction can be determined invalid and still be written offrather than recovered; validity and disposition are separate axesDispute rate is measured by count; recovery rate and write-off rate are measured by dollars
Dispute rate counts deductions; recovery and write-off rates use dollars. A deduction can be determined invalid and still be written off.
KPIFormulaWhat it tells youCommon pitfall
Dispute rateDivide Number of Deductions Disputed by Number of Deductions Received. Multiply by One Hundred Percent.How much of the incoming deduction volume is formally challenged with the retailer.Counting a deduction as disputed when it is queued, before it is submitted.
Recovery (reversal) rateDivide Dollar Amount of Deductions Reversed by Dollar Amount of Deductions Disputed. Multiply by One Hundred Percent.Of the deductions disputed, what share came back as a credit or reversal. No typical value is stated.Measuring against deductions received instead of deductions disputed.
Valid vs invalid shareDivide Dollar Amount Determined Valid, or Invalid, by Total Dollar Amount of Deductions Reviewed. Multiply by One Hundred Percent.How much of the reviewed deductions was correctly taken. It answers a validity question, not a volume question.Treating an internal assessment and a retailer's final ruling as the same category.
Time to resolutionResolution Date minus Deduction Received Date. Report it as a mean or a median across deductions closed in the period.How long the deduction-handling process takes to close items out.Not stating whether the figure is a mean or a median.
Write-off rateDivide Dollar Amount Written Off in the Period by Total Dollar Amount of Deductions Closed in the Period. Multiply by One Hundred Percent.How much of the closed workload ended as an accepted loss. Read it alongside the recovery rate.Pooling a deliberate write-off with a time-barred deduction.

Composition and cost metrics

KPIFormulaWhat it tells youCommon pitfall
Deductions by reason categoryFor each reason category, divide the dollar amount in the category by Total Deduction Dollars in the Period. Multiply by One Hundred Percent.Where deduction dollars concentrate, so effort can go to the categories driving the most volume.Adding categories across retailers before their reason codes are mapped to one set. See the category list.
Cost to processDivide Total Cost of the Deduction-Handling Function in the Period by Number of Deductions Processed in the Period.A per-deduction cost for the function, useful for staffing and process decisions.Not stating whether processed means touched or fully resolved.
Questions

Frequently confused metrics

Deduction rateVSDispute rateThe deduction rate expresses totaldeductions taken as a percentage ofsales. It says nothing about whathappens afterward. The dispute rateexpresses how much of the deductionsreceived get formally challenged.The two measure different things.Recovery rateVSWrite-off rateThe recovery rate measures, ofdisputed dollars, how much came backas a reversal. The write-off ratemeasures, of all closed dollarswhether disputed or not, how muchwas absorbed as a loss.Days Deductions OutstandingVSTime to resolutionDays Deductions Outstanding measuresthe size of the current open balancerelative to sales, at a point intime. Time to resolution measureshow long it takes an individualdeduction, once received, to reach afinal closed state.

What is the difference between the deduction rate and the dispute rate?

The deduction rate expresses total deductions taken as a percentage of sales. It says nothing about what happens afterward. The dispute rate expresses how much of the deductions received get formally challenged. The two measure different things.

What is the difference between the recovery rate and the write-off rate?

The recovery rate measures, of disputed dollars, how much came back as a reversal. The write-off rate measures, of all closed dollars whether disputed or not, how much was absorbed as a loss.

What is the difference between Days Deductions Outstanding and time to resolution?

Days Deductions Outstanding measures the size of the current open balance relative to sales, at a point in time. Time to resolution measures how long it takes an individual deduction, once received, to reach a final closed state.

See how your own deductions break down

Every KPI on this page depends on having deduction data in one place, mapped to a consistent reason-code taxonomy and time basis.

Chat with Roy