---
title: "DSO Calculator: Days Sales Outstanding, 4 Methods + Benchmarks"
description: "Free DSO calculator with monthly, quarterly, rolling 12 month and countback methods. See your result against sector benchmarks and what each day of DSO costs you."
url: https://www.paidnice.com/calculators/days-sales-outstanding
---

# 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.

Opening receivables
$

Closing receivables
$

Credit sales for the periodExclude cash sales, or DSO comes out too low.
$

Enter credit sales above zero.

Days in period

Use a different DSO method

Receivables at start
$

Receivables at end
$

Credit sales in the period
$

Enter credit sales above zero.

Exact days in the periodUse the real day count. Quarters run 90 to 92 days, months 28 to 31.

Twelve months of figures removes seasonality. This is the version to take to a board or a lender.

Average receivables, 12 months
$

Credit sales, last 12 months
$

Enter credit sales above zero.

Countback consumes your receivables balance against actual monthly sales, working backwards. Use it when revenue is lumpy or seasonal.

Closing receivables balance
$

| Month | Credit sales | Days |
| --- | --- | --- |

Your standard payment termsUsed to score your DSO against your own terms, not just against the sector.
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.

Try it Now - It's Free

Book a demo

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 recognized 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

| Sector | DSO | Typical range | Why |
| --- | --- | --- | --- |
| 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

| Industry | DSO | Why |
| --- | --- | --- |
| 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](https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/wcdata.html), 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](https://www.crfonline.org/tools/national-summary-of-domestic-trade-receivables-results-summary/) 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.

| Method | Best for | Weakness |
| --- | --- | --- |
| **Standard** | Annual reporting and the default definition of DSO | Averages hide uneven sales inside the period |
| **Monthly or quarterly** | Tracking whether a change is working | One large invoice can swing a single month |
| **Rolling 12 month** | Board packs, lender reviews, seasonal businesses | Slow to show a recent improvement |
| **Countback** | Lumpy or seasonal revenue, month end credit reporting | Needs 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 judgment 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](https://www.paidnice.com/email-sms-reminders) fire on time regardless of workload, [customer statements](https://www.paidnice.com/automated-customer-statements) go out on a schedule, and [AR reporting](https://www.paidnice.com/accounts-receivable-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.

| Metric | Question it answers | Unit |
| --- | --- | --- |
| [DSO](https://www.paidnice.com/calculators/days-sales-outstanding) | How many days until we get paid | Days |
| [AR turnover](https://www.paidnice.com/calculators/accounts-receivable-turnover) | How many times receivables convert per year | Ratio |
| [Collection efficiency](https://www.paidnice.com/calculators/collection-efficiency-formula-calculator) | How much of what was collectable we collected | Percent |
| [AR aging](https://www.paidnice.com/calculators/accounts-receivable-aging-analysis) | Which balances are late, and by how far | Buckets |
| [Cash conversion cycle](https://www.paidnice.com/calculators/cash-conversion-cycle-calculator) | Total days from paying suppliers to banking cash | Days |

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](https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/wcdata.html), 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](https://www.crfonline.org/tools/national-summary-of-domestic-trade-receivables-results-summary/), 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](https://www.thehackettgroup.com/2025-working-capital-survey-payables-rebound-receivables-inventory-lag/), 2025 Working Capital Survey, covering the 1,000 largest US listed non financial companies.
- [APQC](https://www.apqc.org/resource-library/resource-collection/accounts-receivable-and-collections-key-benchmarks), accounts receivable and collections key benchmarks.
- [US Census Bureau](https://www.census.gov/econ/qfr/index.html), 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

AR Turnover CalculatorCollection speed as a ratio rather than days.AR Aging AnalysisSee which balances are driving your DSO.Collection Efficiency (CEI)How much of what was collectable you actually collected.Bad Debt Expense CalculatorAllowance for doubtful accounts and the journal entry.

## Start getting paid on time with Paidnice

Connect Xero or QuickBooks and Paidnice prepares draft policies for you. Nothing runs until you approve them.

Try it FreeBook a Demo

[Rated 5 stars, 160+ reviews](https://www.paidnice.com/reviews) · [App of the Year](https://www.paidnice.com/blog/winner-xero-global-app-awards-2026)
