DSO Calculator

Last reviewed 13 August 2026

Work out days sales outstanding with the method that fits your business, then see how your result compares with your sector and what each day is costing you.

DSO measures the average number of days you wait to get paid after invoicing. Divide average accounts receivable by credit sales for the period, then multiply by the days in that period.

Example: $50,000 average receivables, $400,000 credit sales, 365 days. 50,000 / 400,000 = 0.125, and 0.125 x 365 = 46 days.

Calculate your DSO

Four figures give you the standard measure. Three other methods are below if your sales are seasonal or lumpy.

$
$
$

Enter credit sales above zero.

Use a different DSO method
net

Key takeaways

  • DSO is the average number of days between invoicing a customer and getting paid.
  • DSO = (average accounts receivable / credit sales) x days in the period.
  • Read your DSO against your own payment terms first, then against your sector.
  • Each day of DSO is worth one day of average daily credit sales in cash.
  • A rising DSO trend matters more than the absolute number.

Your DSO

46 days

030456090+

Average. 16 days beyond your net 30 terms.

Average receivables$50,000
Credit sales used$400,000
Period length365 days
Average daily credit sales$1,096
Receivables as a share of credit sales12.5%
Days beyond your terms16 days
Cash tied up in receivables$50,000
Cash released per day of DSO$1,096
If you cut DSO by 10 days$10,959
Closest benchmarkWholesale and distribution, 46 days (Paidnice customer data)

Every day of DSO is cash sitting in someone else's account

Paidnice chases your overdue invoices automatically in Xero and QuickBooks.

No card required.

What DSO actually tells you

DSO converts your receivables balance into a single number: the average number of days between raising an invoice and banking the cash.

That gap matters because a profitable business can still run out of money. Revenue is recognised when you invoice, but wages, stock and tax are paid in cash.

Every day in the gap is working capital you have lent to your customers, interest free. Three people read that number, for three reasons:

  • Finance uses it to forecast cash.
  • A lender uses it to judge how fast receivables convert, which sets your facility size and your rate.
  • An acquirer reads a rising DSO as revenue quality slipping.

The quick version. Take your receivables, divide by your daily credit sales, and you have DSO. If you sell $1,000 a day on credit and $46,000 is outstanding, you are waiting about 46 days to get paid.

The DSO formula

DSO = (Average Accounts Receivable / Credit Sales) x Days in Period

The formula has four inputs, and each one has a standard way of going wrong.

1
Average accounts receivable

Opening balance plus closing balance, divided by two. Use the average rather than the closing balance, otherwise a single large invoice raised on the last day of the period distorts the whole result.

2
Credit sales, not total sales

Only sales made on credit belong in the denominator. Including cash sales inflates the divisor and reports a DSO lower than reality. This is the single most common error, and it always flatters the result.

3
Days in the period

365 for a year, 90 or 91 for a quarter, 28 to 31 for a month. Use the real day count. Mixing a 90 day assumption with a 92 day quarter puts roughly 2 percent of error into the answer.

4
Be consistent between periods

Whatever you choose, keep it the same each period. A DSO trend built from mixed methods tells you nothing, and switching method is the easiest way to accidentally report an improvement that did not happen.

A worked example

A distribution business opens the year with $45,000 in receivables and closes with $55,000. Credit sales for the year are $400,000.

  • Average receivables: (45,000 + 55,000) / 2 = $50,000
  • Divide by credit sales: 50,000 / 400,000 = 0.125
  • Multiply by days in the period: 0.125 x 365 = 45.6, or 46 days

Daily credit sales are 400,000 / 365 = $1,096. So each day of DSO is worth about $1,096 in cash. Cutting DSO from 46 days to 36 releases roughly $10,960 permanently, and it stays released as long as the faster collection holds.

How to read your number

There is no universal good DSO. Read it against your own payment terms first, because terms set the floor. A business invoicing on net 30 that collects in 38 days is doing well. The same 38 days on net 7 terms means invoices are running a month past due.

These bands track the calculator above. Change your terms or your figures and the matching band is marked.

Strong

Within 10 days of terms

Normal payment run friction. Nothing to fix.

Your result

Acceptable

10 to 15 days over

Watch the trend. Tighten reminders before it drifts.

Your result

Collections gap

15 to 30 days over

Chasing is inconsistent. Put it on a fixed schedule.

Your result

Critical

More than 30 days over

Invoices are not being chased. Bad debt risk is rising.

Your result

Direction matters more than the absolute number. A DSO of 55 days falling steadily is a healthier signal than 40 days climbing three months in a row.

DSO benchmarks by sector

Two sets of figures sit below, and they are kept apart because they describe different businesses. The first is published data on listed companies. The second is our own customer data, from small businesses running Xero and QuickBooks. Every row says which set it belongs to. Your bar moves with the calculator, and the figure closest to your result is picked out alongside it.

Your business 46 days

Paidnice customer data, small businesses

Construction and trades 62 days
Manufacturing 52 days
Wholesale and distribution 46 days
Professional services 42 days
Business services 38 days
Software and SaaS 34 days
Retail and ecommerce 18 days

NYU Stern, listed companies

Engineering and construction 100 days
Electronics (general) 70 days
Machinery 69 days
Business and consumer services 67 days
Software (system and application) 62 days
Retail (distributors) 47 days
Trucking 45 days
Food processing 28 days
Retail (general) 13 days

Paidnice customer figures, small businesses on Xero and QuickBooks

SectorDSOTypical rangeWhy
Construction and trades 62 days 48 to 79 days Retentions and progress claims stretch terms
Manufacturing 52 days 42 to 68 days Long supply agreements, larger invoice values
Wholesale and distribution 46 days 38 to 58 days Trade credit is part of the offer
Professional services 42 days 32 to 55 days Milestone billing, slow client approvals
Business services 38 days 30 to 49 days Mostly net 30, monthly billing cycles
Software and SaaS 34 days 26 to 45 days Card and direct debit shorten the tail
Retail and ecommerce 18 days 9 to 28 days Largely paid at point of sale

Source: Paidnice customer data, August 2026.

Published figures, US listed companies

IndustryDSOWhy
Engineering and construction 100 days Retentions, progress claims and long certification
Electronics (general) 70 days Large contract values, negotiated terms
Machinery 69 days Long supply agreements, larger invoice values
Business and consumer services 67 days Milestone billing, slow client approvals
Software (system and application) 62 days Enterprise contracts, annual billing on terms
Retail (distributors) 47 days Trade credit is part of the offer
Trucking 45 days High invoice volume, frequent short pays
Food processing 28 days Short terms, perishable goods move fast
Retail (general) 13 days Largely paid at the point of sale

Source. Every figure in this table is derived from Working Capital Requirements by Industry Sector, Aswath Damodaran, NYU Stern School of Business, data as of January 2026. That dataset publishes accounts receivable as a percent of revenue for each industry. DSO here is that percentage multiplied by 365, so you can reproduce any row from the source with one calculation. Industry names and sample sizes are his.

Read these as large company figures. The sample is listed companies, which sell to bigger buyers on longer terms than a typical small business ledger does. Two independent checks put the middle of the range around 40 to 45 days: the same calculation on Damodaran's whole market excluding financials gives 45 days, and the Credit Research Foundation National Summary of Domestic Trade Receivables reported DSO of 40.12 days and a best possible DSO of 31.59 days for the first quarter of 2026. Reviewed 15 August 2026.

Only the Paidnice table carries a typical range. The NYU dataset publishes one aggregate figure per industry rather than quartiles, so a range for those rows would have been invented.

The two sets disagree, and that is the useful part. Software reads 62 days on the listed company data and 34 days in ours. Listed companies sell to large buyers who dictate long terms and pay on their own schedule. Paidnice customers invoice smaller buyers on shorter terms, chase sooner, and get paid faster when they do. If you run a small business on Xero or QuickBooks, the Paidnice row is the closer comparison. If you file public accounts, the NYU row is.

The four methods, and when to use each

The methods answer slightly different questions. Mixing them between periods is the most common reporting mistake.

MethodBest forWeakness
StandardAnnual reporting and the default definition of DSOAverages hide uneven sales inside the period
Monthly or quarterlyTracking whether a change is workingOne large invoice can swing a single month
Rolling 12 monthBoard packs, lender reviews, seasonal businessesSlow to show a recent improvement
CountbackLumpy or seasonal revenue, month end credit reportingNeeds monthly sales history, harder to explain

Countback, explained

Countback ages your receivables balance against actual monthly sales, working backwards, instead of against an average.

It takes your closing balance, consumes it against the most recent month of sales, then the month before, counting the days as it goes.

Say you hold $150,000 in receivables and the last three months of credit sales were $42,000, $38,000 and $51,000. Countback uses all three months in full (90 days), then takes the remaining $19,000 from the fourth month at that month's daily rate. The answer reflects the sales that actually created the balance.

True DSO

True DSO measures the actual age of each invoice, weighted by value, rather than blending anything.

It is the most accurate figure available, and the one to use when you are investigating a specific problem. It needs invoice level data, so most teams report standard DSO and reach for True DSO only when the headline number moves and nobody can explain why.

What pushes DSO up

Before you treat a rising DSO as a collections failure, check which of these is actually driving it. Two of the five are not collections problems at all.

  • Invoicing late. The clock starts when the invoice is sent, not when the work finishes. A week of admin delay is a week of DSO you created yourself.
  • No chasing schedule. If reminders go out when someone remembers, the oldest invoices are the ones most likely to be forgotten.
  • Disputes sitting unresolved. A disputed invoice ages silently. Most businesses find a handful of balances that have been stuck for months over a small query nobody owned.
  • A shift in customer mix. Winning larger enterprise customers usually means longer terms and slower payment runs. DSO rises for a good commercial reason.
  • Sales weighted to period end. If a lot of invoices land in the final weeks, receivables are high relative to the period's sales and DSO reads high without anything being wrong.
Want your DSO tracked for you?

Paidnice reads your Xero or QuickBooks ledger and keeps DSO current as invoices are paid, so you are not rebuilding this from an export every month.

See AR reporting

How to bring DSO down

DSO falls when the gap between issuing an invoice and chasing it shrinks, and it falls fastest when chasing stops depending on anyone remembering.

  1. Invoice the day the work completes. The cheapest days to remove are the ones before the invoice exists.
  2. Send a reminder before the due date. A short pre due nudge moves invoices into the next payment run instead of the one after it. This one change is usually worth several days.
  3. Make paying take one click. Put a pay now link on the invoice. Friction at the payment step quietly costs days.
  4. Escalate on a fixed schedule. Decide in advance what happens at 7, 14 and 30 days past due, then let it run without a judgement call each time.
  5. Apply late fees consistently. Fees work as leverage when they are predictable. Applied case by case, they are just an awkward conversation.
  6. Review the aging weekly. Catch the balances that are drifting while they are still collectable, rather than at year end.
  7. Check credit before extending terms. The cheapest overdue invoice is the one you never issue to a customer who was never going to pay.

Most of that list is repetitive, which is what makes it a good fit for automation. Automated email and SMS reminders fire on time regardless of workload, customer statements go out on a schedule, and AR reporting keeps the aging picture in front of you without a manual rebuild.

Calculating DSO in Excel

Put average accounts receivable in A1, credit sales in B1 and the day count in C1.

  • Basic DSO: =(A1/B1)*C1
  • Average from an opening and closing balance: =AVERAGE(A1:A2)
  • Rolling 12 month, with month end receivables in B2:B13 and monthly credit sales in C2:C13: =(AVERAGE(B2:B13)/SUM(C2:C13))*365
  • Days over terms, with your terms in D1: =((A1/B1)*C1)-D1

Watch the denominator. If your accounting export gives you total revenue rather than credit sales, the Excel result will look better than reality. Filter cash sales out before you divide.

DSO against the other receivables metrics

DSO answers how long. The related metrics answer how often, how much and how well, and they are most useful read together.

MetricQuestion it answersUnit
DSOHow many days until we get paidDays
AR turnoverHow many times receivables convert per yearRatio
Collection efficiencyHow much of what was collectable we collectedPercent
AR agingWhich balances are late, and by how farBuckets
Cash conversion cycleTotal days from paying suppliers to banking cashDays

DSO and AR turnover are two views of the same thing: average collection period equals 365 divided by the turnover ratio. If DSO is rising while collection efficiency holds steady, your terms changed. If both move against you, collections did.

Common mistakes

  • Using total revenue instead of credit sales. Always understates DSO. The larger your cash sales, the larger the error.
  • Using the closing balance instead of the average. Makes DSO jump whenever a big invoice lands near period end.
  • Comparing across different methods. A standard figure against a countback figure is not a trend.
  • Treating a benchmark as a target. Your terms and customer mix matter more than your industry, and the NYU figures are drawn from listed companies rather than businesses your size.
  • Reading one month in isolation. Monthly DSO is noisy by design. Three points make a trend, one does not.

Sources

  • Paidnice customer data, reviewed 15 August 2026. The sector table headed "Paidnice customer figures" only. Drawn from our own customers' Xero and QuickBooks ledgers. It is not a survey and carries no published sample size.
  • Aswath Damodaran, NYU Stern School of Business, Working Capital Requirements by Industry Sector, data as of January 2026. Every figure in the listed company table is this dataset's accounts receivable to revenue ratio, multiplied by 365.
  • Credit Research Foundation, National Summary of Domestic Trade Receivables, first quarter 2026. DSO 40.12 days, best possible DSO 31.59 days, 87.38 percent of balances current.
  • The Hackett Group, 2025 Working Capital Survey, covering the 1,000 largest US listed non financial companies.
  • APQC, accounts receivable and collections key benchmarks.
  • US Census Bureau, Quarterly Financial Report, receivables and sales by industry sector.

Sources are cited for the benchmark figures only. Everything else on this page is computed from the figures you enter. Reviewed 15 August 2026.

Frequently asked questions

How do you calculate DSO?

Divide your average accounts receivable by your total credit sales for the period, then multiply by the number of days in that period. The formula is DSO = (Average Accounts Receivable / Total Credit Sales) x Days in Period. Average accounts receivable is your opening balance plus your closing balance, divided by two. Use credit sales only, not cash sales, or the result will be understated.

How do you calculate DSO for 3 months (quarterly)?

Use the same formula with 90 days as the period. Quarterly DSO = (Average Accounts Receivable for the quarter / Credit Sales for the quarter) x 90. Take the receivables balance at the start and end of the quarter, average the two, divide by the quarter credit sales, then multiply by 90. Use the exact day count if you need precision, because quarters run from 90 to 92 days.

What is the formula for monthly DSO?

Monthly DSO = (Average Accounts Receivable for the month / Credit Sales for the month) x 30. Monthly DSO reacts quickly to a single large invoice, so read it as a trend across several months rather than as one reading. If your sales are seasonal, the countback method or rolling 12 month DSO will give you a steadier signal.

What is rolling 12 month DSO?

Rolling 12 month DSO uses the last twelve months of credit sales and the average receivables across those twelve months, so seasonality cancels out. Rolling DSO = (Average Accounts Receivable over 12 months / Credit Sales over 12 months) x 365. It is the standard measure for board reporting and lender reviews because a single strong collection month cannot flatter it.

How is True DSO calculated?

True DSO measures the actual age of each invoice rather than an average. For every invoice you take the days between the invoice date and the payment date, weight each by its value, then divide by total sales. True DSO = Sum of (invoice value x days to pay) / Total credit sales. It is the most accurate measure because it never blends invoices together, but it needs invoice level data, which is why most teams use the standard formula for reporting and True DSO for investigation.

What is the DSO formula in Excel?

Put average accounts receivable in cell A1, credit sales in B1 and the day count in C1, then enter =(A1/B1)*C1 in D1. To average an opening and closing balance, use =AVERAGE(A1:A2). For rolling 12 month DSO with month end receivables in column B and monthly credit sales in column C, use =(AVERAGE(B2:B13)/SUM(C2:C13))*365.

What is a good DSO?

Compare DSO against your own payment terms first, then against your sector. As a working rule, DSO within about 10 days of your stated terms is healthy, 15 to 30 days beyond terms signals a collections gap, and more than 30 days beyond terms usually means invoices are not being chased on a schedule. A business on net 30 terms should expect DSO in the 30 to 45 day band.

Does a high DSO always mean a collections problem?

No. DSO rises when you extend longer terms deliberately, when your sales mix shifts toward slower paying enterprise customers, or when a lot of sales land at the end of a period. Check the aging profile before acting. If DSO is high but most balances sit inside terms, the cause is your terms. If the overdue buckets are growing, the cause is collections.

What is the difference between DSO and average collection period?

They are the same measure. Average collection period is the accounting textbook name and DSO is the name used by credit and finance teams. Both answer how many days it takes on average to convert a credit sale into cash. You will also see it derived from receivables turnover, where average collection period equals 365 divided by the AR turnover ratio.

Can DSO be higher than your payment terms and still be fine?

Yes, within a margin. Almost every business runs a DSO above its stated terms, because terms start at the invoice date but customers pay in weekly or monthly payment runs. A gap of up to about 10 days is normal friction. A gap that keeps widening month on month is the signal worth acting on, not the gap itself.

How often should you measure DSO?

Monthly for operational tracking, and rolling 12 month for reporting. Monthly shows you whether a change you made is working. Rolling 12 month strips out seasonality and is what a lender or board will ask for. Measuring only once a year hides the trend, which is the part that actually matters.

Related calculators

Stop chasing invoices.
Start getting paid.

Paidnice takes the pain out of getting paid for thousands of businesses using Xero and QuickBooks.