Average Days Delinquent (ADD): How to Calculate It and Use It on an AR Team

DSO tells you how long it takes to turn a sale into cash. It does not tell you whether that time comes from the payment terms you agreed or from customers paying late. A 45-day DSO on net-45 terms is a healthy book. The same 45 days on net-30 terms is a collections problem.

Average days delinquent, or ADD, is the number that separates the two. It takes your terms out of the picture and shows how many days, on average, your receivables run past due. For an AR team, it is the closest single number to "how well are we collecting?"

This guide is for controllers and AR managers running a 3 to 5 person collections team. It covers what ADD measures, how to calculate it from your own aging report, how to read it next to DSO, and what moves it.

What Is Average Days Delinquent?

Average days delinquent is the average number of days your receivables are past due. It is calculated as your actual DSO minus your best possible DSO, where best possible DSO counts only receivables that are still current.

ADD is the part of DSO your collections process controls. Best possible DSO is set by your terms and billing speed. Everything above it is late payment, and late payment is what your team works on every day.

Why DSO alone can mislead

DSO moves for reasons that have nothing to do with collecting. Offer longer terms to a big new customer and DSO rises even if every invoice is paid on time. Have a strong sales month at period end and DSO can jump simply because the receivables are new. ADD filters out both effects, so a change in ADD points at payment behavior.

What a typical ADD looks like

In the Credit Research Foundation's National Summary of Domestic Trade Receivables for the second quarter of 2026, the median reported DSO was 37.50 days, the median best possible DSO was 34.00 days and the median average days delinquent was 3.70 days. Each figure is a separate median across reporting companies, so the three do not subtract exactly. The point stands: for the median company in that survey, most of DSO came from terms, and only a few days came from late payment.

How Do You Calculate Average Days Delinquent?

You need three inputs for the same period: total credit sales, ending accounts receivable, and the part of ending receivables that is not yet past due. If you already know how to calculate DSO, you are two steps away.

Step 1: Calculate DSO

DSO = (ending accounts receivable / credit sales for the period) x days in the period.

Step 2: Calculate best possible DSO

Best possible DSO = (current receivables / credit sales for the period) x days in the period. "Current" means invoices that are not yet due. Leave every past-due bucket out.

Step 3: Subtract

ADD = DSO - best possible DSO. The result is in days.

A worked example

Take a distributor closing a 90-day quarter with these figures:

• Credit sales for the quarter: $3,600,000

• Ending accounts receivable: $1,500,000

• Current (not yet due) receivables: $1,050,000

DSO = (1,500,000 / 3,600,000) x 90 = 37.5 days. Best possible DSO = (1,050,000 / 3,600,000) x 90 = 26.25 days. ADD = 37.5 - 26.25 = 11.25 days.

On net-30 terms, that says the company's terms and billing account for about 26 days of its DSO, and late payment adds about 11 more. The 11 days are the collections team's number.

How Do You Read ADD Next to DSO?

Read ADD and DSO together every month, and look at the direction of each. The pair tells you whether a change in DSO came from terms and sales timing or from customers paying later. When DSO and ADD move in different directions, the explanation is almost always terms or sales mix, not collections.

Watch the trend, not one month

A single month of ADD can swing on one large late payment or one big invoice that landed early. Track a rolling three-month view, and only act on a move that holds for two or more months. This is the same discipline that keeps accounts receivable KPIs worth tracking useful rather than noisy.

Pair ADD with CEI

ADD tells you how late customers pay. The collection effectiveness index tells you how much of what was collectable you actually collected. A team can improve ADD by collecting quickly on the easy accounts while the hard balances keep aging, and CEI is the check on that.

How Do You Pull the Inputs From Your ERP?

The inputs come from two standard reports: the AR aging summary as of the period end, and your sales figures for the period. Most of the work is pulling them the same way every month.

Ending receivables and current receivables

Run the aging summary dated the last day of the period. The total column is your ending receivables. The Current column, before the 1 to 30 days bucket, is your current receivables. Our guides show how to export the aging report from NetSuite, QuickBooks and Business Central.

Credit sales

Use invoiced sales on terms for the period. Leave out cash sales and payments taken at the time of sale, because they never enter receivables. If your ERP does not split them, take total sales and subtract the cash and card receipts recorded at sale.

Clean the aging before you trust it

Credits and unapplied cash sit in the aging as negative amounts and can make both DSO and ADD look better than the real position. Apply open payments and credit memos first; our guide to unapplied cash covers the clean-up. Use one aging basis, due date, every month, because an aging by invoice date mixes terms into the past-due buckets and breaks the calculation.

How Should a 3 to 5 Person AR Team Use ADD?

A team-level ADD is a scoreboard. The useful version for a small team is ADD broken down by portfolio, segment and customer, because that shows where the late days come from.

Calculate ADD per collector

Give each collector their own ADD from the accounts they own, using the same formula on their portfolio. Compare each collector against their own trend, not against each other, since portfolios differ in size and customer mix.

Use the invoice-level method for customers

For a single customer, the DSO-based formula gets noisy. An easier view is the invoice-level average: for each invoice paid in the period, count the days between the due date and the payment date, then weight by invoice amount. A customer averaging 18 days late on paid invoices is a different conversation from one averaging 3. Use this view in AR aging report analysis to rank accounts.

Segment by customer tier

Split ADD by customer size or tier. Late days on your ten largest accounts move cash far more than late days on small accounts. If ADD is concentrated in the top tier, that is where the team's calls should go first, the same logic used to prioritize collections accounts by dollars at risk.

Review it in the monthly meeting

Put team ADD, ADD by collector and the ten accounts adding the most late days on one page. Spend the meeting on the accounts, not the metric.

What Makes Average Days Delinquent Rise?

ADD rises when invoices that should have been paid sit past due longer. On most small teams, the causes are operational and fixable.

Accounts nobody touched

When three people cover hundreds of open invoices, mid-size and small accounts often get no contact until they are 30 or 60 days late. Those quiet days add straight to ADD.

Promises that were never followed up

A customer says payment is coming Friday. Friday passes, and the next touch is two weeks later. Every broken promise that is not chased the next business day adds late days. Promise-to-pay tracking closes that gap.

Disputes that sit

An invoice in dispute ages while the question bounces between AP, sales and operations. Disputed balances often carry the highest days late in the book. A clear process to resolve invoice disputes, with an owner and a deadline, brings them back.

Wrong contacts and missing documents

Invoices sent to someone who left, or missing a PO number, wait until somebody notices. Fixing the billing contact and the paperwork is usually faster than any number of reminders.

How Do You Bring Average Days Delinquent Down?

You bring ADD down by contacting every past-due account on a schedule, following up every promise, and moving disputes to resolution faster. None of it requires changing your terms. The broader levers to lower DSO without hiring work on the rest of DSO; these work on ADD.

Touch every past-due account every week

Set a cadence that reaches every past-due invoice, starting before the due date for large balances. Coverage matters more than intensity: one contact a week on every account beats daily calls on a few.

Act on a broken promise the next business day

Log every promise with a date and an amount, and check the list every morning. A same-week follow-up keeps a one-week slip from becoming a one-month slip.

Separate disputes from slow payers

Tag disputed invoices so they get a resolution owner, not more reminders. The rest of the past-due book then reflects true slow payment, and your ADD by customer becomes a cleaner signal.

Revisit terms only after collection is steady

If ADD is low but DSO is still high, the remaining lever is terms, covered in our guide to net 30, 60 and 90 terms. Change terms after collection is under control, not before, so you can see the effect of each change.

Where Does Abivo Fit?

Abivo's AI collections agent, Kate, handles routine follow-up across every account: reminders before and after the due date, payment-status calls, and next-day follow-up on promises, with every touch logged back to the account. That coverage is what keeps late days from building on the accounts a small team cannot reach each week, and it leaves collectors more time for disputes and key accounts. You can see how Kate works on the product page.

Practical Takeaways for Controllers and AR Managers

• Calculate ADD every month as DSO minus best possible DSO, from an aging by due date

• Clean credits and unapplied cash out of the aging before you calculate

• Read ADD next to DSO: if they move in different directions, look at terms and sales mix first

• Break ADD down by collector, customer tier and customer to find where late days come from

• Pair ADD with CEI so quick wins on easy accounts do not hide aging balances

• Bring ADD down with weekly coverage of every past-due account, next-day promise follow-up and faster dispute resolution

Frequently Asked Questions

What is average days delinquent?

Average days delinquent is the average number of days receivables run past their due date. It is calculated as DSO minus best possible DSO.

What is the formula for best possible DSO?

Best possible DSO = (current receivables / credit sales for the period) x days in the period, where current receivables are invoices not yet due.

What is a good average days delinquent?

Lower is better, and many companies run in single digits. In the Credit Research Foundation's Q2 2026 national summary, the median reported ADD was 3.70 days. Compare against your own trend and your industry.

What is the difference between DSO and ADD?

DSO measures total days to collect, including the terms you offer. ADD measures only the days past due, so it isolates late payment from the effect of terms and sales timing.

How often should an AR team calculate ADD?

Calculate it monthly at period end and review a rolling three-month trend. Look at ADD by customer weekly when ranking accounts for follow-up.

If you want every past-due account covered each week so late days stop building, Get Started with Abivo.