Days Sales Outstanding Calculator: AR, Sales & Days

Is a days sales outstanding of 30.00 days healthy?

On the defaults — $180,000.00 of accounts receivable and $2,190,000.00 of credit sales over 365 days — the days sales outstanding is 30.00 days, the accounts receivable needed for a 25-day DSO is $150,000.00, and the credit sales needed for a 25-day DSO is $2,628,000.00. The days sales outstanding — accounts receivable divided by credit sales, times the days in the period — is the receivables test: how many days, on average, it takes customers to pay. A DSO under 30 days is generally strong; 30–45 days is typical for many businesses; over 60 days usually means collections are slow and cash is tied up in unpaid invoices. Retail businesses often run a DSO near 20 days because customers pay fast; manufacturers often run 40–50 days; construction and professional services can run 60 days or more because invoices are large and payment terms are long. The same DSO can mean different things by industry — a retailer and a construction firm do not collect the same way — so compare within an industry, not across them.

Four things about the model are worth stating plainly. First, the days sales outstanding is the accounts receivable divided by the total credit sales, times the days in the period — $180,000.00 ÷ $2,190,000.00 × 365 = 30.00 days. Second, the accounts receivable needed at the target is the total credit sales times the target DSO, divided by the days in the period — $2,190,000.00 × 25 ÷ 365 = $150,000.00. Third, the total credit sales needed at the target is the accounts receivable times the days in the period, divided by the target DSO — $180,000.00 × 365 ÷ 25 = $2,628,000.00. And fourth, the DSO is 365 divided by the accounts receivable turnover, and using average accounts receivable — (opening + closing) ÷ 2 — gives a steadier figure than a single end-of-period snapshot; all listed in Accuracy & limitations.

The worked example, line by line

Setup: $180,000.00 of accounts receivable, $2,190,000.00 of total credit sales, 365 days in the period, target DSO 25 days.

Line 1 — the days sales outstanding. The days sales outstanding is $180,000.00 ÷ $2,190,000.00 × 365 = 30.00 days.

Line 2 — the accounts receivable needed. The accounts receivable needed for a 25-day DSO is $2,190,000.00 × 25 ÷ 365 = $150,000.00.

Line 3 — the credit sales needed. The credit sales needed for a 25-day DSO is $180,000.00 × 365 ÷ 25 = $2,628,000.00.

Line 4 — the check. $150,000.00 ÷ $2,190,000.00 × 365 = 25.00 days, the target; and $180,000.00 ÷ $2,628,000.00 × 365 = 25.00 days, the target again.

Every branch, checked

Accounts receivable $90,000: Days sales outstanding 15.00 days; accounts receivable needed for the 15-day target $90,000.00; credit sales needed for the 15-day target $2,190,000.00 — With accounts receivable of $90,000.00 the DSO falls to 15.00 days — customers pay twice as fast, in the strong band.

Credit sales $1,095,000: Days sales outstanding 60.00 days; accounts receivable needed for the 60-day target $180,000.00; credit sales needed for the 60-day target $1,095,000.00 — With credit sales of $1,095,000.00 the DSO rises to 60.00 days — the slow band: collections are slow and cash is tied up in unpaid invoices.

Accounts receivable $270,000: Days sales outstanding 45.00 days; accounts receivable needed for the 45-day target $270,000.00; credit sales needed for the 45-day target $2,190,000.00 — With accounts receivable of $270,000.00 the DSO is 45.00 days — the top of the typical 30–45 day band.

Days in period 90: Days sales outstanding 7.40 days; accounts receivable needed for the 7.4-day target $180,066.67; credit sales needed for the 7.4-day target $2,189,189.19 — Over a 90-day quarter the same receivables and sales give a DSO of 7.40 days — the same money, measured over a shorter window.

Accounts receivable $45,000: Days sales outstanding 7.50 days; accounts receivable needed for the 7.5-day target $45,000.00; credit sales needed for the 7.5-day target $2,190,000.00 — With accounts receivable of $45,000.00 the DSO falls to 7.50 days — cash comes in fast.

Credit sales $3,650,000: Days sales outstanding 18.00 days; accounts receivable needed for the 18-day target $180,000.00; credit sales needed for the 18-day target $3,650,000.00 — With credit sales of $3,650,000.00 the DSO falls to 18.00 days — near the retail pace of about 20 days.

Accounts receivable $0: Days sales outstanding 0.00 days; accounts receivable needed for the 25-day target $150,000.00; credit sales needed for the 25-day target $0.00 — With no accounts receivable the DSO is 0.00 days — nothing outstanding.

The reverses, worked backwards

Largest whole-dollar accounts receivable for the DSO to STAY at or below 30 days: At the displayed $180,000 the figures are Days sales outstanding 30.00 days; accounts receivable needed for the 30-day target $180,000.00; credit sales needed for the 30-day target $2,190,000.00. At the displayed $180,000 the days sales outstanding is 30.00 days. At $180,001 the receivables are $1 over the $180,000 allowed — and the unrounded DSO is 30.000167 days, which displays as 30.00 days after rounding, so $180,000 is the largest whole-dollar accounts receivable for the DSO to stay at or below 30 days.

Smallest whole-dollar credit sales for the DSO to stay at or below 25 days: At the displayed $2,628,000 the figures are Days sales outstanding 25.00 days; accounts receivable needed for the 25-day target $180,000.00; credit sales needed for the 25-day target $2,628,000.00. At the displayed $2,628,000 the days sales outstanding is 25.00 days. At $2,627,999 the sales are $1 short of the $2,628,000 needed — and the unrounded DSO is 25.000010 days, which displays as 25.00 days after rounding, so $2,628,000 is the smallest whole-dollar credit sales for the DSO to stay at or below 25 days.

Largest whole-dollar accounts receivable for the DSO to STAY at or below 45 days: At the displayed $270,000 the figures are Days sales outstanding 45.00 days; accounts receivable needed for the 45-day target $270,000.00; credit sales needed for the 45-day target $2,190,000.00. At the displayed $270,000 the days sales outstanding is 45.00 days. At $270,001 the receivables are $1 over the $270,000 allowed — and the unrounded DSO is 45.000167 days, which displays as 45.00 days after rounding, so $270,000 is the largest whole-dollar accounts receivable for the DSO to stay at or below 45 days.

Smallest whole-dollar credit sales for the DSO to stay at or below 20 days: At the displayed $3,285,000 the figures are Days sales outstanding 20.00 days; accounts receivable needed for the 20-day target $180,000.00; credit sales needed for the 20-day target $3,285,000.00. At the displayed $3,285,000 the days sales outstanding is 20.00 days. At $3,284,999 the sales are $1 short of the $3,285,000 needed — and the unrounded DSO is 20.000006 days, which displays as 20.00 days after rounding, so $3,285,000 is the smallest whole-dollar credit sales for the DSO to stay at or below 20 days.

Smallest whole-dollar accounts receivable for the DSO to reach 40 days: At the displayed $240,000 the figures are Days sales outstanding 40.00 days; accounts receivable needed for the 40-day target $240,000.00; credit sales needed for the 40-day target $2,190,000.00. At the displayed $240,000 the days sales outstanding is 40.00 days. At $239,999 the receivables are $1 short of the $240,000 needed — and the unrounded DSO is 39.999833 days, which displays as 40.00 days after rounding, so $240,000 is the smallest whole-dollar accounts receivable for the DSO to reach 40 days.

Largest whole-dollar accounts receivable for the DSO to STAY at or below 15 days: At the displayed $90,000 the figures are Days sales outstanding 15.00 days; accounts receivable needed for the 15-day target $90,000.00; credit sales needed for the 15-day target $2,190,000.00. At the displayed $90,000 the days sales outstanding is 15.00 days. At $90,001 the receivables are $1 over the $90,000 allowed — and the unrounded DSO is 15.000167 days, which displays as 15.00 days after rounding, so $90,000 is the largest whole-dollar accounts receivable for the DSO to stay at or below 15 days.

A warning about the neighbours: every neighbour above shows as the target when rounded to two decimals, but its unrounded DSO is a hair above or below the target. A lender underwriting on the unrounded DSO would still say no where the unrounded figure misses the line. The page prints the unrounded neighbour value in full so the rounding does not mislead you: 30.000167, 25.000010, 45.000167, 20.000006, 39.999833 and 15.000167 days.

What the defaults assume

The defaults are $180,000.00 of accounts receivable, $2,190,000.00 of total credit sales, 365 days in the period and a target DSO of 25 days — Days sales outstanding 30.00 days; accounts receivable needed for the 25-day target $150,000.00; credit sales needed for the 25-day target $2,628,000.00. With Accounts receivable $90,000, Days sales outstanding 15.00 days; accounts receivable needed for the 15-day target $90,000.00; credit sales needed for the 15-day target $2,190,000.00. With Credit sales $1,095,000, Days sales outstanding 60.00 days; accounts receivable needed for the 60-day target $180,000.00; credit sales needed for the 60-day target $1,095,000.00. With Accounts receivable $270,000, Days sales outstanding 45.00 days; accounts receivable needed for the 45-day target $270,000.00; credit sales needed for the 45-day target $2,190,000.00. With Days in period 90, Days sales outstanding 7.40 days; accounts receivable needed for the 7.4-day target $180,066.67; credit sales needed for the 7.4-day target $2,189,189.19. With Accounts receivable $45,000, Days sales outstanding 7.50 days; accounts receivable needed for the 7.5-day target $45,000.00; credit sales needed for the 7.5-day target $2,190,000.00. With Credit sales $3,650,000, Days sales outstanding 18.00 days; accounts receivable needed for the 18-day target $180,000.00; credit sales needed for the 18-day target $3,650,000.00. With Accounts receivable $0, Days sales outstanding 0.00 days; accounts receivable needed for the 25-day target $150,000.00; credit sales needed for the 25-day target $0.00. With Credit sales $0, Days sales outstanding — (undefined: no credit sales to divide by); accounts receivable needed for the 25-day target $0.00; credit sales needed for the 25-day target $2,628,000.00. With Accounts receivable $0, Days sales outstanding 0.00 days; accounts receivable needed for the 25-day target $150,000.00; credit sales needed for the 25-day target $0.00. With Accounts receivable $123,456, credit sales $987,654, Days sales outstanding 45.62 days; accounts receivable needed for the 25-day target $67,647.53; credit sales needed for the 25-day target $1,802,457.60. With Accounts receivable $500,000, Days sales outstanding 83.33 days; accounts receivable needed for the 25-day target $150,000.00; credit sales needed for the 25-day target $7,300,000.00. With Credit sales $1,000,000, Days sales outstanding 65.70 days; accounts receivable needed for the 25-day target $68,493.15; credit sales needed for the 25-day target $2,628,000.00. With Accounts receivable $180,001, Days sales outstanding 30.00 days; accounts receivable needed for the 25-day target $150,000.00; credit sales needed for the 25-day target $2,628,014.60. With Target bars — accounts receivable $180,000, credit sales $2,190,000, accounts receivable needed at the 20-day target $120,000.00; at the 45-day target $270,000.00; credit sales needed at the 20-day target $3,285,000.00; at the 45-day target $1,460,000.00.

A note on the rounding: with accounts receivable of $123,456 and credit sales of $987,654 the unrounded days sales outstanding is 45.624723 days, which rounds half-up to 45.62 days — the page prints the unrounded value so the rounding does not mislead you. With accounts receivable of $180,001 and credit sales of $2,190,000 the unrounded days sales outstanding is 30.000167 days, which rounds to 30.00 days. With accounts receivable of $500,000 the DSO is 83.33 days, and with credit sales of $1,000,000 the DSO is 65.70 days.

Output · formula · meaning

Who uses this

• The small-business owner checking the year: they learn $180,000.00 of accounts receivable on $2,190,000.00 of credit sales gives a DSO of 30.00 days — and they check the $180,000 reverse to see the largest receivables that still stay at or below 30 days.
• The credit manager tightening terms: they learn a DSO under 30 days is generally strong and over 60 days is usually slow — and they check the $2,628,000 reverse to see the smallest credit sales that stay at or below a 25-day DSO.
• The manufacturer whose DSO slipped to 45.00 days: they learn the business sits at the top of the typical 30–45 day band — and they check the $270,000 reverse to see the largest receivables that stay at or below 45 days.
• The retailer collecting in about 20 days: they learn a DSO near 20 days is normal for retail — and they check the $3,285,000 reverse to see the smallest credit sales that stay at or below a 20-day DSO.

Accuracy & limitations

The math is first-principles: the days sales outstanding is the accounts receivable divided by the total credit sales, times the days in the period, rounded to two decimals half-up; the accounts receivable needed at the target is the total credit sales times the target DSO, divided by the days in the period; the credit sales needed at the target is the accounts receivable times the days in the period, divided by the target DSO. The reverses are judged on the UNROUNDED DSO: a neighbour one dollar short or over shows as the target when rounded to two decimals, but its unrounded DSO is above or below the target, so it does not meet the bar — the page prints the unrounded neighbour value in full. What the model cannot do is judge the business: only CREDIT sales count — cash sales are excluded, because cash is already collected; the average accounts receivable is (opening + closing) ÷ 2, a simple average that hides swings inside the period; with credit sales of $0 the DSO is undefined — the calculator shows “—” with a note, never Infinity or NaN; with accounts receivable of $0 the DSO is 0.00 days — nothing outstanding; a low DSO means cash comes in fast but can also mean credit terms are too strict and scare off customers; a high DSO means more sales on credit but slower cash; and the same DSO means different things by industry, so compare within an industry, not across them. DSO differs from days payable outstanding, which tests how fast you pay suppliers, and from the cash conversion cycle, which combines receivables, inventory and payables. Use it to see how fast your customers pay — then read the rest of the statements.

Frequently asked questions