DSO Calculator

Measure how long your customers take to pay you, and how much cash you would free by collecting on terms.

$
Balance at period end
$
days
365 for a year, 90 for a quarter
days
Optional, e.g. net 30

Results

Days sales outstanding—
Days beyond terms—
Cash freed by collecting on terms—
Average credit sales per day—

How it's calculated

DSO = Accounts receivable ÷ credit sales × days in period Cash freed = (DSO − terms) × credit sales per day

Want the full worksheet? The AR Aging + DSO Dashboard template does this and more in Excel or Google Sheets, with room for your real numbers.

See the template

What DSO measures

Days sales outstanding is the average number of days it takes to collect payment after a sale on credit. If your terms are net 30 and your DSO is 52, customers are paying, on average, about three weeks late. That gap is cash you have earned but can't use.

The "cash freed" figure above estimates how much money would come in if your DSO matched your terms. For many small businesses it is the single largest source of cash available without borrowing.

Calculating it correctly

  • Use credit sales, not total sales. Cash and card sales collected at the point of sale never become receivables and make DSO look better than it is.
  • Match the period. Quarterly sales with 90 days, or annual sales with 365.
  • Watch seasonality. A big sales month at period end raises receivables and DSO even if customers pay on time. Compare the same month across years, or use average receivables.

DSO and the aging report together

DSO is an average, so it can hide problems. One large customer 120 days late can sit inside a DSO that looks acceptable. Pair DSO with an aging report that shows balances in current, 1-30, 31-60, 61-90 and over-90 buckets. Lenders do the same: receivables over 90 days are usually excluded from a borrowing base.

How to bring DSO down

  1. Invoice immediately. Every day between shipping and invoicing adds a day to DSO.
  2. Make paying easy. Accept ACH and cards, and put a payment link on every invoice.
  3. Follow up on a schedule. A friendly reminder before the due date, a call on day one past due, and escalation at 30 days past due.
  4. Set terms per customer. Give new or slow customers shorter terms, or ask for deposits.
  5. Stop shipping to chronic late payers until their balance is current.

If your DSO stays high because your customers are large companies that pay slowly by policy, factoring or an asset-based line can bridge the gap, at a cost.

Frequently asked questions

What is a good DSO?

Close to your payment terms. A DSO within about 10 to 15 days of your terms is generally healthy; much higher means collections need attention.

Should DSO use total sales or credit sales?

Credit sales. Including cash sales understates how long credit customers take to pay.

How is DSO different from the cash conversion cycle?

DSO measures only collections. The cash conversion cycle adds inventory days and subtracts the days you take to pay suppliers.

Why did my DSO jump at month end?

A large amount of sales at the end of the period raises receivables before customers have had time to pay. Compare to the same period last year or use average receivables.

This calculator gives estimates for education and planning. It is not financial, legal or tax advice, and it is not an offer of credit. Actual terms come from your lender or provider. Last reviewed 2026-11-16.