Days Sales Outstanding (DSO) & AR Calculator
Calculate how many days it takes your business to collect payment after a sale. Discover cash trapped in slow accounts receivable and compare against Net 30/60 industry benchmarks.
AR & Revenue Inputs
$
Total revenue invoiced on credit terms during these 90 days.
$
Total unpaid invoices owed by customers at the end of the period.
Days Sales Outstanding (DSO)
36.8Days
It takes an average of 36.8 days to turn invoiced sales into cash.
Optimal Collection Health
Your customers pay within or near agreed terms. Working capital velocity is healthy.
Average Daily Sales
$2,667
Per calendar day
Cash Trapped Beyond Terms
$18,000
6.8 days late vs Net 30
DSO Benchmark ComparisonB2B Standard Terms
Under 35 Days:High Liquidity / Fast Payers
35 – 45 Days:Typical B2B Net 30 Window
46 – 60 Days:Slow Payment Risk (15+ Days Past Due)
Over 60 Days:Severe Bad Debt Risk
Official Excel System
$7.20$9-20%
Accounts Receivable Aging (30/60/90+), DSO & Collections CRM
Age invoices into 1-30, 31-60, 61-90 and 90+ day buckets, estimate late fees, calculate DSO and CEI, and log collection follow-ups in Excel.
100% Macro-Free (.xlsx) • Native dynamic formulas
Single-user perpetual license • Zero monthly SaaS
Pre-filled demo workbook + Clean blank sheet
Instant .xlsx Download • Verified IT Safe • Polar Secured