Accounts Receivable DSO Calculator: Track Collections Efficiency

📄 Receivables Data

Total Accounts Receivable ($)

Total Credit Sales ($)

Exclude cash sales, as they do not generate receivables.

Reporting Period

Custom Days in Period

🎯 Performance Targets

Target DSO (Days)

Industry benchmark: 30 to 45 days for Net 30 terms

📊 Enter your accounts receivable and credit sales above to see your DSO analysis.

Key Terms Explained

Days Sales Outstanding (DSO)

The average number of days it takes a company to collect payment after a credit sale. Lower is better - a falling DSO means faster cash collection.

Accounts Receivable (AR)

Money owed to a business by its customers for goods or services delivered on credit. AR sits on the balance sheet as a current asset until collected.

Credit Sales

Sales made on account where payment is deferred to a future date - typically governed by terms like Net 30 or Net 60. Excludes cash and card transactions paid at the time of sale.

Average Daily Sales

Total credit sales divided by the number of days in the period. This figure represents how much revenue is generated each day and is the denominator of the DSO formula.

Liquidity

A company's ability to meet its short-term financial obligations. High DSO reduces liquidity because earned revenue is locked in receivables rather than available as cash.

Cash Conversion Cycle

The total number of days it takes to convert investments in inventory and other resources into cash flows from sales. DSO is one of three components alongside DIO and DPO.

Net 30 Terms

A common payment term requiring the invoice to be paid in full within 30 calendar days of the invoice date. Net 60 and Net 90 are common alternatives for longer payment windows.

DSO Variance

The difference between your actual DSO and your target DSO. A positive variance means you are collecting slower than your goal, and each extra day represents trapped cash equal to your average daily sales.

The Complete Guide to Days Sales Outstanding (DSO)

Days Sales Outstanding is one of the most important metrics in corporate treasury and accounts receivable management. It measures the average number of days between issuing an invoice and receiving payment. A company with tight DSO control collects its earned revenue quickly, keeps its working capital lean, and rarely needs to tap a line of credit to cover operational gaps. A company with a rising DSO is quietly bleeding cash - it has made the sales on paper but cannot use that money until the invoice is paid.

How to use this calculator

Start by selecting your reporting period - monthly, quarterly, or annual. Enter your total accounts receivable balance from your balance sheet and your total credit sales from your income statement for the same period. The calculator instantly computes your DSO, average daily sales, and compares the result against your target. If your actual DSO exceeds your target, the tool also shows you exactly how much cash is currently trapped in receivables above what it should be.

Set your Target DSO in the Performance Targets panel to match your standard payment terms. If you offer Net 30, try a target of 35 to 45 days. If you offer Net 60, set 65 to 75. The tool dynamically color-codes your DSO in green when you are at or below target, amber for a moderate overage, and red for a significant gap - so the health of your collections is immediately visible.

The DSO formula explained

DSO is calculated by dividing your accounts receivable balance by your total credit sales, then multiplying by the number of days in the period: DSO = (AR / Credit Sales) x Days. This tells you how many days of revenue is currently sitting uncollected. Average Daily Sales is simply Credit Sales divided by Days in the period, and represents the cash your business earns each day. Every day your DSO exceeds your target, you are forgoing one more day of that average daily sales figure.

DSO benchmarks by industry

Benchmark context matters as much as the raw number. Software and SaaS companies using monthly subscriptions often achieve DSO below 30 days because payments are automatic. Professional services firms with Net 30 terms typically run between 35 and 55 days. Manufacturing companies with Net 60 B2B terms often see 60 to 80 days as normal. Construction and government contracting can see DSO above 90 days due to lengthy approval cycles. The most meaningful benchmark is always your own standard payment terms - if your DSO is running 40 percent above your net terms, that signals a collections problem regardless of what industry peers do.

How trapped cash ties into working capital

Each day your DSO exceeds your target, additional cash is locked in receivables. If your average daily sales are $20,000 and you are running 10 days above your target DSO, that is $200,000 of earned revenue sitting uncollected. That money could eliminate a short-term borrowing need, fund a marketing campaign, or simply sit in a money market account earning interest. Reducing DSO is one of the fastest ways to improve free cash flow without changing the underlying business model at all.

Frequently Asked Questions

What is considered a healthy DSO ratio? ▼

A healthy DSO depends on your payment terms. As a general rule, your DSO should not exceed 1.5 times your standard net terms. If you offer Net 30, a DSO below 45 days is considered acceptable, while anything below 30 is excellent. B2B companies with Net 60 terms can reasonably operate with a DSO between 60 and 75 days. The critical benchmark is your own historical trend - a DSO that is rising quarter over quarter signals a worsening collections problem even if the absolute number still looks reasonable.

Why must I exclude cash sales from this calculation? ▼

Cash sales are collected at the point of transaction and never generate an accounts receivable balance. Including them in the denominator artificially inflates your credit sales figure, which makes your DSO look lower and healthier than it actually is. DSO is a measure of how quickly you collect on credit you have extended to customers. Blending cash transactions into the formula dilutes the signal and hides real collections problems. Always use only credit sales - invoiced amounts due at a future date - for an accurate result.

How does a high DSO affect corporate cash flow? ▼

Every extra day your DSO sits above your target represents cash that has been earned but not collected. That uncollected cash cannot pay suppliers, service debt, fund payroll, or be reinvested in growth. The effect compounds: a company with $50,000 in average daily sales and a DSO that is 10 days above target has $500,000 trapped in receivables. High DSO also increases the risk of bad debt write-offs, because the longer an invoice goes unpaid, the less likely it is to be collected in full.

What are the best strategies to lower my DSO? ▼

The most effective strategies are: invoice immediately upon delivery rather than batching invoices weekly or monthly; offer early-payment discounts such as 2/10 Net 30 to incentivize faster payment; implement automated payment reminders at 7, 3, and 1 day before the due date; require credit checks before extending terms to new customers; enforce late payment fees consistently; and review your payment terms - sometimes switching from Net 60 to Net 30 with a small discount is enough to substantially cut DSO. For chronic late payers, consider requiring partial prepayment or a deposit.