Calculators

Days sales outstanding (DSO) calculator

Days sales outstanding, or DSO, is the average number of days customers take to pay credit sales, calculated from accounts receivable, credit sales and the days in the period.

DSO calculator

Days sales outstanding
41 days
Days beyond standard terms
11 days

Formula: DSO = accounts receivable / credit sales × days in period

Example

Accounts receivable ($)
$820,000
Credit sales for the period ($)
$7,300,000
Days in period
365
Standard terms (days)
30
Days sales outstanding
41 days
Days beyond standard terms
11 days

What the calculator works out

The DSO calculator turns accounts receivable, credit sales for the period and days in the period into the average number of days customers take to pay. It uses the formula DSO = accounts receivable / credit sales × days in period. A fourth input, standard terms, puts the result next to the terms you granted, so you see days beyond standard terms rather than only a raw average.

Accounts receivable is the open customer balance at the end of the same period as the sales figure. Find it in the AR aging summary, the customer subledger or the receivables line of the trial balance. Credit sales are sales made on credit terms during the period, not total sales; pull them from the sales journal or invoice register and exclude cash sales. Days in period is the number of calendar days covered by the sales figure, such as 365 for a full year. Standard terms are the payment days on the customer invoice or in the customer master record.

AP staff often meet DSO from the other side. A supplier's DSO is the mirror of the customer's DPO: the supplier measures how long it waits for cash, while the customer's AP team measures how long it takes to release cash. When AP compares its own DPO with a vendor's DSO, use the same period and treatment of unapplied cash and credits.

A worked example

Take a period with accounts receivable of $820,000, credit sales for the period of $7,300,000, 365 days in the period and standard terms of 30 days. Enter those four figures. The calculator returns days sales outstanding: 41 days. It also returns days beyond standard terms: 11 days.

Read the result as an average. Customers are taking 41 days to pay, on average, against terms of 30 days. The gap is 11 days beyond standard terms. That does not tell you which customers are late or whether one large account is distorting the average; the AR aging does that. It does tell you that the collection cycle is longer than the terms you set, so the next step is to look at the aging buckets and the largest open invoices.

The input sources matter. The $820,000 comes from the AR aging or subledger at period end. The $7,300,000 comes from the credit sales register for the same period, with cash sales excluded. The 365 is the day count for that period. The 30 days comes from the invoice terms or the customer master. An AP team reviewing a supplier's DSO would use the supplier's receivable balance and credit sales, not its own payable balance. The mirror is useful, but the inputs are not interchangeable.

Reading the result

A DSO of 41 days is not good or bad by itself. Put it next to standard terms of 30 days and the 11 days beyond standard terms becomes the practical signal. If customers routinely pay after terms, cash arrives later than the sales plan assumed, and the AR team has to chase. If DSO is close to terms, the collection process is keeping up, at least on average.

Look at the trend before you act on one period. Monthly DSO swings with sales: a strong sales month can change the ratio even when customer payment behavior has not changed. Compare several months on the same basis. If the direction is consistently upward, customers are paying more slowly or the AR balance is growing faster than credit sales. If the direction is flat, a single high DSO month may be a denominator effect rather than a collection problem.

Use the result with the aging, not instead of it. The aging shows which invoices are past due and by how much; DSO compresses that into a single average. For finance operations, the useful pair is DSO plus the proportion of receivables past terms. If you are weighing financing against receivables, compare the financing rate with your own cost of funds; DSO tells you how long cash is tied up, not what the money should cost.

AP teams can use a vendor's DSO as a conversation input. If a supplier's DSO is 41 days and its terms are 30 days, it is waiting 11 days beyond its own terms on average. That does not prove the supplier will tighten terms, but it explains why a vendor may press for earlier payment. Keep the discussion on the same period and definition.

Where the inputs go wrong

The most common error is using total sales instead of credit sales. Cash sales make DSO look better than it is because they enlarge the denominator without creating receivables. If the $7,300,000 includes cash sales, the calculator is no longer measuring collection of credit sales. Pull credit sales from the invoice register and confirm that every invoice in the figure was issued on credit terms.

Unapplied cash is the second error. Cash that has arrived but has not been applied to an invoice sits in accounts receivable and inflates the $820,000 balance. Apply the cash before measuring, or the DSO will show a collection delay that has already been resolved. The same logic applies to credits that belong against open invoices: if they are not applied, the receivable looks larger and the average collection period looks longer.

Period mismatch is the third error. Do not pair a period-end AR balance with a full-year sales figure and a 30-day day count, or a monthly AR balance with a 365-day count. The days in period must match the sales period. The standard terms must match the invoices; if terms vary by customer, a single 30-day figure is a simplification. For AP teams comparing DSO with DPO, use the same period and gross or net basis on both sides.

Questions

What does a DSO of 41 days mean?

It means customers take 41 days on average to pay credit sales. Against standard terms of 30 days, that is 11 days beyond standard terms. The average does not show which invoices are late; use the AR aging for that.

Should I use total sales or credit sales in DSO?

Use credit sales only. Cash sales make DSO look better than it is because they add to the denominator without adding receivables. The sales journal or invoice register should let you isolate invoices issued on credit terms.

How does unapplied cash affect DSO?

Unapplied cash stays in accounts receivable and inflates the balance, so DSO looks worse than the collection record supports. Apply cash to invoices before you run the calculator. The same applies to credits that should be matched to open invoices.

How is DSO related to DPO?

DSO is the receivables mirror of a customer's DPO. One measures days to collect from customers; the other measures days taken to pay suppliers. AP teams comparing the two should use the same period and consistent treatment of unapplied cash and credits.

Updated Nov 8, 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.