---
title: "Days Deduction Outstanding (DDO): Formula and Example"
description: "Days deduction outstanding explained: the DDO formula, the dollar-weighted age alternative, a worked example with resolution entries, and mistakes."
url: https://emptyspaces.ai/glossary/days-deduction-outstanding
language: en
---

[Home](https://emptyspaces.ai/) [Glossary](https://emptyspaces.ai/glossary) Days deduction outstanding (DDO)

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

Updated November 19, 2026[Accounts receivable, billing and collections](https://emptyspaces.ai/glossary#browse)

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, 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.

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](https://emptyspaces.ai/product/close) 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

## Related terms

Deductions Amounts a customer subtracts from a payment, such as for damage, shortages, promotions, or pricing disputes, which must be researched and resolved.

Short payment Customer payment that's less than the invoiced amount, often because of a deduction, dispute, or billing disagreement.

Dispute management Process of logging, investigating, and resolving customer disagreements over invoices, such as pricing, quantity, or damage, so payment can proceed.

Days sales outstanding (DSO) Average number of days it takes to collect payment after a credit sale: accounts receivable divided by credit sales, times days in the period.

Chargeback Reversal of a card payment forced by the customer's bank after a dispute; in B2B AR, also a deduction a retailer or distributor takes from its payment.

Full guides: [Retail and ecommerce month-end close](https://emptyspaces.ai/resources/blog/retail-ecommerce-month-end-close), [General ledger vs subledger: AP and AR reconciliation](https://emptyspaces.ai/resources/blog/ap-ar-reconciliation), and [Month-end close KPIs](https://emptyspaces.ai/resources/blog/month-end-close-kpis).

More terms: [Finance and accounting glossary](https://emptyspaces.ai/glossary)

Review Days deduction outstanding (DDO) at month end

Our Close Agent prepares reconciliations and journal entries for your team to review and approve.

[Book a working session](https://emptyspaces.ai/contact-us)

No implementation commitment.

[All 721 glossary terms](https://emptyspaces.ai/glossary)
