DDO
Days Deductions Outstanding (DDO) is the average number of days open deductions remain unresolved on the AR ledger. It is the deductions-specific counterpart to DSO and a direct measure of deduction resolution efficiency, with high DDO indicating either capacity constraints or process bottlenecks in deduction management.
Deduction management has its own operational dynamics distinct from the broader AR cycle. Deductions require investigation, classification, dispute filing, and resolution, all of which take time. Days Deductions Outstanding captures this in a single metric: on average, how long do deductions sit unresolved? For finance teams managing significant deduction volume (CPG, consumer goods, distribution), DDO is the operational quality measure of deduction management capacity and process maturity.
The standard formula:
DDO = (Average Open Deductions Balance / Total Deduction Volume) x Number of Days
Total Deduction Volume is the total deduction dollars created over the measurement period (typically annual). Average Open Deductions Balance is calculated similarly to AR: (Beginning Balance + Ending Balance) / 2.
A worked example: a CPG supplier creates 50 million euros in annual deductions and carries an average open deduction balance of 4 million euros. DDO = (4,000,000 / 50,000,000) x 365 = 29 days. The team takes about a month on average to resolve deductions.
DDO benchmarks vary by deduction mix and team maturity:
The trend matters more than the absolute level. Rising DDO typically signals one of three issues: deduction volume growing faster than team capacity, retailer programme changes creating new investigation requirements, or process degradation in an existing workflow.
DSO covers all open AR including deductions; DDO isolates the deduction portion. Two scenarios illustrate why the distinction matters:
Reporting both metrics monthly provides much richer operational signal than DSO alone.
Deductions that age past 90 days have much lower recovery rates because retailer dispute filing windows close, supporting documentation becomes harder to assemble, and customer engagement on stale issues drops. A deduction worth 50,000 euros at day 30 may be worth 5,000 euros recoverable at day 120. High DDO directly translates to higher bad debt write-offs on the deduction portion of AR.
For finance teams, DDO trends predict bad debt 6 to 12 months forward. Rising DDO is an early warning that bad debt provisions will need to increase.
Mistake 1: Reporting only DSO. DSO without DDO hides deduction-specific process issues until they materialise as bad debt.
Mistake 2: Treating all deductions the same. Authorised deductions should close immediately; unauthorised ones need investigation. Mixed workflows generate uniformly slow resolution.
Mistake 3: No aging on deductions. Deduction aging buckets (0-30, 31-60, 61-90, 90+) reveal where the resolution bottleneck sits. Without aging, the DDO metric is opaque.
Mistake 4: Underinvesting in retailer-specific knowledge. Each major retailer has distinct deduction programmes, codes, portals, and dispute requirements. Generic process applied across retailers slows resolution on every retailer.
AI-native deduction platforms attack the investigation bottleneck that drives high DDO:
Mid-market CPG deduction teams typically reduce DDO from 30 to 60 day baseline to 15 to 25 days within 12 months of agentic deployment, with corresponding improvements in deduction recovery rates and reductions in bad debt provision requirements.
Days Deductions Outstanding (DDO) is the average number of days open deductions remain unresolved on the AR ledger. It is the deductions-specific counterpart to DSO and a direct measure of deduction resolution efficiency. High DDO indicates either capacity constraints or process bottlenecks in deduction management.
Best-in-class deduction teams operate at 10 to 20 days DDO. Industry average is 20 to 40 days. Over 60 days indicates significant capacity constraints, fragmented process, or unresolved retailer-specific programme issues. The trend matters more than the absolute level.
DSO covers all open AR including deductions; DDO isolates the deduction portion specifically. Reporting both provides richer operational signal: stable DSO with rising DDO points to deduction management issues; rising DSO with stable DDO points to collections or cash application issues. Together they diagnose where AR process improvement is needed.
Deductions aging past 90 days have much lower recovery rates because retailer dispute filing windows close, supporting documentation becomes harder to assemble, and customer engagement on stale issues drops. A deduction recoverable at 30 days may be 80 percent unrecoverable at 120 days. High DDO directly translates to higher bad debt write-offs.
Yes through process and technology investment. AI-native deduction platforms automate classification, surface investigation context in seconds via graph-based retrieval, and accelerate resolution cycles by 40 to 60 percent within 12 months. Mid-market teams typically move from 30 to 60 day baseline to 15 to 25 days DDO.
No, the two metrics serve different purposes. DSO is the headline AR cycle metric and is required for working capital and CCC analysis. DDO is a complementary metric specific to deduction management. Mature operations track both monthly to diagnose where AR improvement is needed.
