Skip to content

What is days deduction outstanding (DDO)? Definition, formula, and example

Accounts receivable, billing and collections

Definition

Days deduction outstanding (DDO) is the average number of days customer deductions stay open before they're resolved. The most common formula divides open deductions by the average deductions customers take per day. It's used mostly by consumer goods manufacturers and distributors, where retailers routinely short-pay for promotions, shortages, and damage.

Measures
Open deductions
Unit
Days
Companion view
Dollar-weighted age
Valid deductions
Reduce revenue

DDO formula

DDO = Open deductions ÷ (Deductions taken in the period ÷ Days in the period)

It's built like DSO, with deductions in place of receivables and sales, and it rises when deductions are taken faster than they're resolved. No standard-setter defines DDO, so versions vary: some teams count items instead of dollars, and some divide by deductions resolved. State which one you use.

Many teams also track the dollar-weighted average age of open deductions: each deduction's age times its amount, summed, divided by total open deductions. It answers a different question: how old is the backlog?

DDO example

Example: A food manufacturer's customers take $150,000 of deductions in September 2026, and $180,000 of deductions are open on September 30. All amounts are illustrative.

DDO = $180,000 ÷ ($150,000 ÷ 30) = $180,000 ÷ $5,000 = 36.0 days
Open deductions, Sep 30, 2026AmountAge (days)Amount × age
Promotion deductions$60,00012720,000
Shortage claims75,000352,625,000
Pricing disputes45,000703,150,000
Total$180,0006,495,000

The dollar-weighted age is 36.1 days (6,495,000 ÷ 180,000), close to DDO here, but the table shows where the time sits: pricing disputes average 70 days, nearly twice the overall figure.

In October, the team approves the $60,000 of promotion deductions as valid and proves $15,000 of shortage claims invalid, which the retailer repays.

DateAccountDebitCredit
Oct 9, 2026Trade promotion allowances60,000
Deductions receivable60,000
Oct 23, 2026Cash15,000
Deductions receivable15,000
Total75,00075,000

Valid deductions reduce net revenue; they aren't bad debt.

How do you lower DDO?

DDO falls when deductions are prevented or resolved faster.

  • Prevent: Clean pricing and promotion data at order entry, and proof of delivery on every shipment
  • Code at cash application: Every deduction gets a reason code and owner on the day it's taken
  • Set time limits: Agree claim windows with customers and reject late claims
  • Recover invalid ones: Rebill or dispute within the retailer's deadline

What is DDO confused with?

DDO is most often confused with DSO and with the age of deductions.

TermWhat it isHow it differs from DDO
Days sales outstanding (DSO)Average days to collect after a credit saleCovers all receivables, not deductions
DeductionsAmounts a customer subtracts from a paymentThe items DDO measures
Short paymentCustomer payment less than the invoiced amountThe event that creates a deduction

DDO at month end

At month end, open deductions need a reason, an owner, and a reserve view.

  1. Age open deductions: By reason code and customer
  2. Book resolved items: Credit memos or allowances for valid ones, rebills for invalid ones
  3. Reserve: Estimate how much of the open balance won't be recovered, and accrue expected promotion costs
  4. Tie out: AR subledger and deductions to the general ledger

For FP&A, valid deductions are a reduction of net revenue, so trend them by customer and promotion. Our Close Agent ties the AR subledger to the general ledger at close and prepares the entry, and nothing posts until a named approver signs off.

Common DDO mistakes

The most common DDO mistakes hide the true backlog.

  • Writing off small deductions by default: They add up, and many are invalid
  • Tracking DDO without age: A low DDO can hide very old items
  • Booking valid deductions to bad debt: They reduce revenue
  • Changing the formula from month to month: Keep the denominator consistent