Days sales outstanding (DSO) formula: the simple ratio and the count-back method

The DSO formula

DSO = accounts receivable ÷ credit sales × number of days

• Accounts receivable: the open customer invoices at the end of the period, before the allowance for doubtful accounts in most internal reports.
• Credit sales: sales made on account. Cash sales are never in receivables, so including them makes DSO look better than it is.
• Number of days: the length of the sales period, 91 for this quarter, 365 for a year or 30 for one month.

In the example: 690,000 ÷ 1,385,000 × 91 = 45.3 days. The sales period and the day count must match: a year of sales with 365 days, a quarter with the days in that quarter.

Worked example: DSO of a distributor at 30 June

Rows 2 to 4 are the last three months of credit sales, newest first, with the count-back in columns D and E. Rows 6 to 17 calculate the simple DSO and the related measures. The company is fictional.

Worked example: DSO of a distributor at 30 June

	A	B	C	D	E
1	Month (newest first)	Credit sales	Days	AR left to cover	Days counted
2	June	520,000	30	690,000	30.00
3	May	455,000	31	170,000	11.58
4	April	410,000	30	0	0.00
5
6	Accounts receivable at 30 June				690,000
7	Of which not yet due				410,000
8	Credit sales of the quarter				1,385,000
9	Days in the quarter				91
10	Simple DSO = AR ÷ credit sales × days				45.3
11	Count-back DSO				41.6
12	Payment terms (days)				30
13	Days beyond terms (count-back)				11.6
14	Best possible DSO (not-yet-due AR only)				26.9
15	Average days delinquent (simple − best)				18.4
16	Credit sales per day				15,220
17	Cash freed if simple DSO falls to 35 days				157,308

All amounts in USD and fictional.

Reading DSO against the payment terms

DSO on its own says little. Compare it with the payment terms you give customers. With net-30 terms, a DSO of 45 means customers take about two weeks longer than agreed on average. The gap is called days beyond terms. Track it month by month: a rising DSO is usually the first sign of a customer in trouble, a dispute that blocks payment, or invoices that went out late.

DSO is one part of the cash conversion cycle, together with days inventory outstanding and days payables outstanding. Of the three, DSO is often the one a finance team can move fastest.

The count-back method

The simple formula averages the sales of the whole period. When sales grow or move with the seasons, that distorts the result: a strong last month inflates receivables and makes DSO look worse, a weak one makes it look better. The count-back method follows the calendar backwards instead:

• Start with the receivables of $690,000 and cover the newest month first. June's sales of $520,000 are fully covered: 30 days.
• $170,000 is left. It covers only part of May's $455,000: 170,000 ÷ 455,000 × 31 = 11.6 days.
• Nothing is left for April. Count-back DSO = 30 + 11.6 = 41.6 days.

In a sheet, the receivables still to cover are =MAX(0,D2-B2) from row to row, and the days counted are =IF(D2>=B2,C2,D2/B2*C2). Because sales grew every month, the simple DSO overstates the collection time by almost four days here. Whichever method you use, use it every month and say which one it is.

Best possible DSO and average days delinquent

Part of the receivables is not even due yet. Best possible DSO uses only those current invoices: 410,000 ÷ 1,385,000 × 91 = 26.9 days. It is the DSO you would have if every customer paid exactly on the due date, and it is driven by your terms and the timing of sales, not by collections.

The gap between the actual and the best possible DSO is the average days delinquent: 45.3 − 26.9 = 18.4 days. That is the part a collections team can work on. A high best possible DSO, on the other hand, is a question for sales and credit policy, because it comes from the terms you agreed.

What a lower DSO is worth in cash

Credit sales per day are 1,385,000 ÷ 91 = $15,220. Every day of DSO you remove turns that much receivable into cash. Bringing DSO from 45.3 to 35 days would free about $157,300, money the company would otherwise have to borrow or keep as a cushion.

The usual levers are invoicing on time and without errors, clear reminders before and after the due date, firm credit limits for slow payers, electronic payment options, and early-payment discounts where the discount costs less than the financing it saves.

Year-end or average receivables, 365 or 360 days

Textbooks and analysts often calculate annual DSO with average receivables (opening plus closing, divided by 2) and 365 days, which smooths out a single unusual month end. Internal credit teams usually use the month-end balance and the latest one to three months of sales, because they want to see today's position. Some use 360 days. None of these is wrong, but a DSO is only comparable with another DSO built the same way.

A "good" DSO depends on the industry and its normal terms. Retailers that sell for cash have almost no receivables, while distributors and B2B service firms with net-30 to net-60 terms commonly report DSOs of 30 to 60 days. Compare your DSO with your own terms and your own trend first.

Common mistakes

• Using total sales instead of credit sales. Cash sales never become receivables, so including them makes DSO look shorter than it is.
• Mismatched periods. A quarter of sales with 365 days, or a year of sales with 90 days, gives a meaningless number. Use the days of the same period.
• Comparing DSOs built differently. Simple and count-back, year-end and average receivables, 360 and 365 days all give different results. Use one method consistently.
• Ignoring the payment terms. A DSO of 40 is excellent on net-45 terms and poor on net-14 terms. Report days beyond terms alongside DSO.
• Reading a growth effect as a collection problem. When sales rise, the simple DSO rises even if customers pay just as fast. The count-back method shows the real picture.
• Netting credit notes and unapplied cash late. Unposted credits and payments not matched to invoices inflate receivables. Clean the ledger before measuring.