Articles

How do you calculate best possible DSO and average days delinquent?

DSO mixes the terms you grant with how late customers pay. Best possible DSO isolates the first; average days delinquent is the second, the part a credit department owns.

Best possible DSO is current (not yet due) receivables divided by recent credit sales, times the days in the period. Average days delinquent is DSO minus best possible DSO. With receivables of $26,900,000, of which $17,200,000 current, and $42,200,000 of sales over the last 92 days, DSO is 58.6 days, best possible DSO 37.5 days and average days delinquent 21.1 days.

Worked in full in The Commercial Credit Manager by Julian R. Sterling, with every figure reproduced in a free workbook.Get the PDF, $19.99 →or the paperback

The assumptions

The case is Brennick Industrial Supply, a fictional distributor of maintenance, repair and operations products selling on net 30 terms. Credit sales were $168,000,000 in 2025, of which $14.6, $14.2 and $13.4 million in October, November and December. At 31 December, receivables stood at $26,900,000, aged by due date:

Aging at 31 December 2025
BucketAmountShare
Current17,200,00063.9%
1 to 30 days past due5,600,00020.8%
31 to 60 days past due2,300,0008.6%
61 to 90 days past due900,0003.3%
Over 90 days past due900,0003.3%
Total26,900,000100.0%

Step 1: DSO on the last three months

DSO = receivables / sales of the last three months x days in those months

= 26.9 / 42.2 x 92 = 58.6 days

The annual method (26.9 / 168.0 x 365) gives 58.4 days and the countback method 59.5 days. Pick one and keep it; changing methods between months moves the figure for reasons that have nothing to do with collection.

Step 2: best possible DSO

Best possible DSO = current receivables / sales of the last three months x days

= 17.2 / 42.2 x 92 = 37.5 days

Best possible DSO is what DSO would be if every customer paid exactly on its due date. It reflects the terms granted and the timing of invoicing. Collection effort cannot push DSO below it; only shorter terms can.

Step 3: average days delinquent

Average days delinquent = DSO - best possible DSO = 58.6 - 37.5 = 21.1 days

Those 21.1 days are the part of DSO caused by late payment. At $460,274 of credit sales a day and an 8% cost of funds, each day costs $36,822 a year. Bringing average days delinquent down to 12 days would release about $4,210,089 of cash and save about $336,807 a year in interest, which would put DSO at 49.5 days with the same terms.

The common mistake

Reading DSO alone. A company that moves good customers from net 30 to net 60 sees DSO rise although nobody pays late; one that cuts terms sees it fall without collecting faster. Splitting DSO separates the commercial decision (terms) from the collection result (delinquency), and it is the delinquency that a credit department should be measured on, alongside a flow measure such as the collection effectiveness index (59.2% for December in the case).

Takeaway

The same ledger is used to set credit limits in how to set a customer credit limit.

Free Excel template: Credit Manager Workbook (DSO, CEI, credit limits and reserve).

Questions readers ask

What is a good average days delinquent?

It depends on the industry and the customer base, but the measure is most useful as a trend and a target. In the case, a distributor at 21.1 days set a target of 12 days for the next year.

Why is best possible DSO not equal to the payment terms?

Because it measures the receivables that are not yet due, and those depend on every term the company grants and on how sales fall through the period. On pure net 30 terms with steady sales it sits close to 30 days. In the case it is 37.5 days because some larger accounts buy on longer negotiated terms, so part of November's invoices was still current at year-end. A best possible DSO above the standard term is a prompt to list the accounts on special terms and check that each was priced.

Should disputed invoices be excluded?

Keep them in the aging at their original due date and report them separately. Excluding them flatters average days delinquent and hides a problem that usually sits outside the credit department.

Read the whole case

This article is one calculation from The Commercial Credit Manager. The book follows one distributor's credit department through a year, from the first aging to a customer's Chapter 11 filing, and every figure it prints is a live formula in the free workbook.

Get the PDF edition, $19.99 Paperback · Free companion files