What is days deduction outstanding (DDO)? Definition, formula, and example
Accounts receivable, billing and collections
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
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.
| Open deductions, Sep 30, 2026 | Amount | Age (days) | Amount × age |
|---|---|---|---|
| Promotion deductions | $60,000 | 12 | 720,000 |
| Shortage claims | 75,000 | 35 | 2,625,000 |
| Pricing disputes | 45,000 | 70 | 3,150,000 |
| Total | $180,000 | 6,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.
| Date | Account | Debit | Credit |
|---|---|---|---|
| Oct 9, 2026 | Trade promotion allowances | 60,000 | |
| Deductions receivable | 60,000 | ||
| Oct 23, 2026 | Cash | 15,000 | |
| Deductions receivable | 15,000 | ||
| Total | 75,000 | 75,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.
| Term | What it is | How it differs from DDO |
|---|---|---|
| Days sales outstanding (DSO) | Average days to collect after a credit sale | Covers all receivables, not deductions |
| Deductions | Amounts a customer subtracts from a payment | The items DDO measures |
| Short payment | Customer payment less than the invoiced amount | The event that creates a deduction |
DDO at month end
At month end, open deductions need a reason, an owner, and a reserve view.
- Age open deductions: By reason code and customer
- Book resolved items: Credit memos or allowances for valid ones, rebills for invalid ones
- Reserve: Estimate how much of the open balance won't be recovered, and accrue expected promotion costs
- 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