Days sales outstanding (DSO) calculator

DSO connects revenue on the income statement to cash still in receivables. When DSO drifts up, you can look profitable while waiting longer for cash — which hits payroll, inventory purchases, and growth plans. Healthy margins do not automatically mean fast collections; when you review performance, pair DSO with margin using our profit margin calculator.

Finance tracks DSO with receivables turnover and aging reports; operations uses it to catch billing delays or slow-paying segments. Lenders and treasury often view DSO next to liquidity measures such as the current ratio. With inventory and payables days, DSO completes the cash conversion cycle picture even when you calculate each piece on its own.

Use beginning and ending AR when you have balance-sheet points for the period, or average receivables when finance already computed the average. The DSO formula is the same either way.

• Beginning & ending — month-end, quarter-end, or year-end closes when you export the balance sheet twice for the same window as credit sales.
• Average receivables — rolling 12-month packs, ERP averages, or when a one-off write-off on a single balance-sheet date would distort the two-point average.

Receivables turnover is net credit sales ÷ average AR — how many times receivables recycle in the period. DSO expresses the same idea in days: DSO ≈ days in period ÷ receivables turnover (and turnover ≈ days in period ÷ DSO).

Example: turnover of 18× over a 365-day year is about 20.3 days of sales outstanding — near the Annual manufacturer (~20 days) preset. Lenders often want turnover; operators think in days. This calculator shows both, plus daily credit sales (net credit sales ÷ days in the period) when you bridge to cash forecasts.

Copy this layout into Excel or Google Sheets, then point each cell at your trial balance or ERP export. The turnover rows are an optional check that your DSO math matches.

Days inventory outstanding (DIO) is how long inventory sits before you sell it — try our DIO calculator for that leg. Days payable outstanding (DPO) is how long you take to pay suppliers. DSO is the receivables leg: how long you wait for customer cash after a credit sale.

Together they form the cash conversion cycle: CCC = DIO + DSO − DPO. A shorter cycle usually frees cash, but each metric has its own levers (buying, billing, collections, vendor terms). This calculator covers DSO only; pull DIO and payables days from your other systems when you need a full CCC.

Use credit sales (invoiced sales on account) in the denominator — not cash at the register and not customer deposits before you recognize revenue. Net out returns and allowances so the sales line reflects what you expect to collect.

If nearly everything is invoiced, net revenue can be a practical stand-in; say so in your close notes so reviewers know which GL line you used. In mixed cash-and-credit businesses, total revenue makes DSO look faster than reality because cash sales inflate the denominator while AR does not.

If you also track inventory, pair DSO with COGS and DIO using our cost of goods sold calculator and DIO calculator.

There is no single “good” DSO for every company. Many B2B sellers on net-30 terms land near 30–45 days when collections run well; net-60 contracts, government payers, or healthcare billing can run higher without a crisis. Third-party industry medians are useful context — not a scorecard.

Watch your trend, your contract terms, and customers that look like yours. DSO well above your terms often points to billing delays, disputes, or follow-up gaps, not just “how the industry is.”

Results include a short fast / moderate / slow label versus the period you chose (for example, 25 days means something different on a 90-day quarter than on a 30-day month). Use it as a sanity check, then confirm with aging buckets and invoice due dates.

Monthly DSO: use that month’s net credit sales and average AR (or beginning/ending AR for the month), and set days in period to actual calendar days (28–31) or a consistent 30-day convention — pick one method and keep it month over month.

Quarterly DSO: use credit sales and average AR for the same fiscal quarter and set days to 90 (or 91/92 for calendar quarters). Try the Quarterly snapshot (~23 days) preset for a worked layout.

The formula does not change; the usual mistake is mixing windows — e.g. quarterly sales with a full-year AR balance, or month-end AR with partial-month sales. Track month-over-month DSO so one slow month does not disappear inside an annual average.

For board or lender reporting, teams often compute rolling DSO with trailing-twelve-month credit sales and average AR over the same window: (Average AR over 12 months ÷ Credit sales over 12 months) × 365. Enter those totals here with 365 days — this calculator uses the standard average-AR method, not a month-by-month countback model.

Use rolling DSO when a single quarter is noisy (seasonal revenue, large deal timing) but you still need one KPI for covenants or investor updates. Pair it with quarterly point-in-time DSO so you see both the smoothed trend and the latest close.

For annual manufacturer or B2B examples on a fiscal year, use the Annual manufacturer or Annual B2B presets — they use full-year sales with beginning/ending AR, which is the same math with a 365-day period.

Start with an aging report by customer — a high company-wide DSO often hides a few slow accounts. Then work through operational levers finance and AR can own together:

• Invoice timing — bill on delivery or milestone, not only month-end batch runs.
• Clear terms — net days, due date, and remit-to on every invoice; match contracts in your billing system.
• Payment friction — ACH, card, or portal links where your margin allows; fewer mailed checks.
• Credit policy — limits and reviews for new accounts; pause shipment when accounts pass overdue thresholds.
• Disputes & credit memos — resolve quickly so AR is not inflated by contested balances.
• Cadence — reminders before due date, escalation paths, and weekly review of top overdue balances.

Track DSO monthly (or quarterly for low volume) so seasonal spikes do not look like a structural trend. If DSO improves but cash does not, check whether you are factoring receivables or accelerating collections with discounts — both change the story.

By default this calculator uses average accounts receivable from beginning and ending balances (or a direct average you enter). Other methods — simple DSO, monthly snapshots, rolling 12-month, and countback — behave differently; see the notes below before you compare to AR software or a lender template.

Mixed cash/credit revenue, contra-revenue, or AR factoring can distort the ratio until you normalize inputs.

On the balance sheet, accounts receivable (trade receivables) is usually a current asset — often shown net of an allowance for doubtful accounts. Use the same net AR your GL uses for the close; do not mix gross receivables with net sales without adjusting for the allowance.

On the income statement, use net sales or revenue net of returns and discounts — ideally from a credit-sales subledger when cash and credit are mixed. Beginning AR is the opening balance for your period; ending AR is the close — both should come from the same reporting entity and currency.

Notes receivable, unbilled revenue, or related-party balances may sit in separate lines; only include amounts that represent trade credit sales you are measuring. Match AR and sales to the same fiscal period. See the SEC investor.gov financial statements overview for how AR and revenue fit the statements.

Each row below matches a preset in the calculator — select the chip to load the inputs and compare your own numbers.

Annual manufacturer: average AR $275,000, net credit sales $5,000,000, 365 days → ($275,000 ÷ $5,000,000) × 365 = 20.08 days.

Annual B2B: average AR $432,500, sales $6,200,000, 365 days → DSO ≈ 25.46 days (in line with common net-30/net-45 B2B closes).

Quarterly snapshot: average AR $80,000, sales $320,000, 90 days → ($80,000 ÷ $320,000) × 90 = 22.50 days.