Average days delinquent calculator
- DSO
- 41 days
- Best possible DSO
- 28 days
- Average days delinquent
- 13 days
Formula: ADD = DSO − best possible DSO; best possible DSO = current (not yet due) receivables / credit sales × days in period
Example
- Receivables not yet due ($)
- $560,000
- Total receivables ($)
- $820,000
- Credit sales for the period ($)
- $7,300,000
- Days in period
- 365
- DSO
- 41 days
- Best possible DSO
- 28 days
- Average days delinquent
- 13 days
What the calculator works out
The calculator takes two numbers you can build from your aging report and turns them into one lateness figure. Days sales outstanding, or DSO, measures how long receivables sit before they get collected. Best possible DSO measures the same span but counts only the money that isn't due yet. The gap between the two is average days delinquent.
Both measures share a denominator: credit sales for the period and days in the period. Best possible DSO is current, not yet due receivables divided by credit sales, multiplied by days in the period. DSO puts total receivables in that same spot. Change only the numerator and the distance between the two answers is the number of days customers spend past terms.
Where the inputs come from. Receivables not yet due sits in the current column of the AR aging as of the close date. Total receivables is the AR ledger total, or the receivables line on the balance sheet, pulled at the same close. Credit sales comes from the sales journal, net of cash sales and net of credit memos you issued, since a return isn't a collection. Days in the period is 365 for a year, 90 for a quarter, or the actual day count for a month.
Run the aging on the same date as the sales figure. A full year of credit sales paired with a receivables balance from mid-year gives you a number that looks precise and means nothing.
A worked example
A company has $560,000 in receivables not yet due and $820,000 in total receivables. Credit sales for the period were $7,300,000, and the period is 365 days.
Total receivables against credit sales over 365 days gives DSO of 41 days. The current slice, $560,000, against the same credit sales and the same 365 days gives best possible DSO of 28 days.
Subtract and the average days delinquent is 13 days. That answers the question a controller actually asks: how far past the due date does the money land? Here the answer is 13 days, and it's the collection pattern rather than the terms doing the stretching.
The example doesn't say every customer is 13 days late. It's a dollar-weighted average, so a few large slow payers can carry it. The difference between the $820,000 in total receivables and the $560,000 that isn't due yet is the pool where that lateness lives, and it's worth aging by customer and by invoice.
Reading the result
ADD holds terms still, which is the point. Two business units on different terms can post very different DSO and identical ADD, and the unit with the tighter terms isn't automatically collecting worse. Watch ADD across months, entities or your own history rather than comparing your DSO to someone else's.
A reading near zero says customers are paying roughly inside their terms. A reading that climbs while terms stay put points at collections or billing: invoices leaving late, reminder letters that stopped going out, a billing error repeated every month. If terms changed recently, expect ADD to drift while customers adjust.
Disputed invoices push ADD up and are worth tracking on their own. When a customer withholds an invoice over a pricing disagreement, that money sits in total receivables and drags the measure until someone settles it. Pull the disputes out, look at what's left, and decide which number your team should be managed on.
Overdue receivables have a funding cost. Compare the rate you'd pay to carry that gap with your own cost of funds before choosing between a discount and a borrowing line. That's a comparison, not a recommendation.
Where the inputs go wrong
Unapplied cash is the most common distortion. Cash that arrived and wasn't matched sits in the ledger and keeps the receivables balance high, so ADD overstates lateness. Apply unapplied cash before you pull the numbers, then reconcile what's left in the account.
The denominator has its own traps. Credit sales that quietly include card or over-the-counter takings are too big, which pushes DSO and ADD down and makes the team look faster than it is. Credit memos left in sales have the same effect. Matching a 12-month sales figure to a quarter-end receivables balance is another mismatch, and so is a 90-day period run against 365 days in the formula.
Check what the current column actually holds. Some agings put past-due but not yet bucketed items there, or intercompany balances, or retainage and unbilled work that isn't really collectible yet. Any of those flatters best possible DSO and shrinks ADD. Read the aging definition once, write it down, and check it again after any system change or staff handover.
Questions
What is average days delinquent in accounts receivable?
It's DSO minus best possible DSO, expressed in days. It tells you how far past their due dates customers pay on average, once the terms you granted are taken out of the picture. A steady ADD with a steady DSO is a stable collection pattern. A rising one is a signal to look at billing and follow-up.
How is best possible DSO different from DSO?
Best possible DSO counts only receivables that aren't due yet, so it shows what DSO would be if every customer paid exactly on time. DSO counts the whole receivables balance. The gap between the two is the lateness.
Where do I find receivables not yet due?
In the current column of the AR aging as of your close date, after unapplied cash is applied. Check the aging's definition first, because some versions include past-due items or intercompany balances in that column. Whatever definition you use, use it the same way every month.
Can an AP team use average days delinquent?
The measure is built for receivables, but the idea carries over: compare the days you actually take to pay against the terms your vendors gave you. If your timing drifts past terms, suppliers will notice, and early-payment discounts you're missing show up as a cost. Track it month to month the same way.
Updated Nov 9, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.