A/R Days Calculator
This A/R days calculator finds your Days Sales Outstanding (DSO) — also called debtor days or average collection period — using your accounts receivable balance and net credit sales. Use this A/R days calculator to also return your accounts receivable turnover ratio, based on the same working-capital formulas finance teams and analysts use.
Also known as: A/R days calculator, accounts receivable days calculator, DSO calculator, days sales outstanding calculator, debtor days calculator, average collection period calculator.
(Avg A/R ÷ Credit Sales) × Days = DSOInteractive step-by-step proof
- Enter values above to see the calculation unfold step by step.
Why Use an A/R Days Calculator to Track Working Capital
Although accounts receivable is represented by a single dollar amount on the balance sheet, it doesn’t provide much insight into the health or decline of collections. Days Sales Outstanding (DSO) — also called A/R days, debtor days, days sales in accounts receivable, or the average collection period — converts that balance into a time-based figure that’s much simpler to track over time, compare against your own stated payment terms, or benchmark against peers. An A/R days calculator turns that comparison into the average number of days between a credit sale and the cash landing in the bank.
The A/R days calculator formula is straightforward: DSO = (Average A/R ÷ Credit Sales) × Days in Period. Averaging the beginning and ending A/R balances reduces distortion from a single snapshot when both are available; if just the ending balance is available, it still provides a useful point-in-time read. The same underlying collection speed, viewed from the opposite direction, is expressed by the accounts receivable turnover ratio, calculated by dividing credit sales by average A/R. It shows how frequently receivables are fully collected and replaced over the course of the period.
Finance teams, students, and small business owners can walk through a manual DSO calculation, see how a slower-paying quarter moves the ratio, or quickly build a collections benchmark without opening a spreadsheet using this A/R days calculator, which computes both figures as you type. This A/R days calculator pairs well with a break-even calculator when the goal is broader cash-flow planning rather than receivables alone.
How the A/R Days Calculator Works
This A/R days calculator converts your outstanding receivables into a time-based statistic that’s simple to compare over time or against your stated payment terms.
Step 1 — Average A/R
The beginning and ending balances are averaged if you supply both: (beginning + ending) ÷ 2. Otherwise, a snapshot is taken using just the ending balance.
Step 2 — Daily credit sales
total credit sales ÷ days in period — in practice, DSO wants to know “how many days’ worth of sales does my A/R balance represent?”
Step 3 — DSO (A/R days)
(average A/R ÷ credit sales) × days in period — the core calculation, expressing your receivables balance as a number of sales days.
Step 4 — A/R turnover ratio
credit sales ÷ average A/R — the inverse of DSO, showing how often receivables are collected and replaced over time.
A/R Days Calculator: Worked Examples
Three typical patterns worked end-to-end using the same formula as the A/R days calculator above.
Healthy collector on net-30 terms
A business bills net-30. The month has 30 days, ending A/R is $90,000, and credit sales were $270,000. Is collection performance keeping up with the terms?
Given inputs
- Ending A/R: $90,000
- Credit sales: $270,000
- Period: 30 days
Computed outputs
- Avg. daily credit sales: $9,000
- DSO: (90,000 ÷ 270,000) × 30 = 10 days
- A/R turnover: 270,000 ÷ 90,000 = 3.0× for the month
- A DSO of 10, well below the 30-day terms, indicates either the balance is skewed toward prompt payers or customers are paying faster than required.
Slow-collecting quarter against net-45 terms
The quarter’s credit sales totaled $900,000 over 91 days, with an ending A/R of $185,000 and a beginning A/R of $165,000. How does the resulting DSO compare with net-45 terms?
Given inputs
- Beginning / Ending A/R: $165,000 / $185,000
- Credit sales: $900,000
- Period: 91 days
Computed outputs
- Average A/R: (165,000 + 185,000) ÷ 2 = $175,000
- Avg. daily credit sales: 900,000 ÷ 91 ≈ $9,890
- DSO: (175,000 ÷ 900,000) × 91 ≈ 17.7 days
- A/R turnover: 900,000 ÷ 175,000 ≈ 5.1× for the quarter — well ahead of net-45 terms, indicating collections are outperforming stated policy.
Seasonal business using average A/R to smooth a swing
A retailer’s A/R fluctuates significantly during the quarter. A/R was $40,000 at the start, rose to $120,000 by the end due to a large wholesale order, and credit sales totaled $500,000 over 91 days. Is it appropriate to use the ending A/R alone?
Given inputs
- Beginning / Ending A/R: $40,000 / $120,000
- Credit sales: $500,000
- Period: 91 days
Computed outputs
- Ending A/R alone: DSO = (120,000 ÷ 500,000) × 91 ≈ 21.8 days — overstates the average collection period because it captures a one-time spike.
- Average A/R: (40,000 + 120,000) ÷ 2 = $80,000 → DSO = (80,000 ÷ 500,000) × 91 ≈ 14.6 days
- The averaged figure is more representative here — collections would look worse than the underlying trend if only the final snapshot were used.
A/R Days Calculator Mistakes to Avoid
Including cash sales in the sales figure
DSO measures how long credit sales remain as receivables before being collected. Folding cash sales into the total understates actual collection time, since cash is collected instantly and never shows up in A/R.
Using ending A/R when the balance fluctuates a lot
A seasonal spike or a large order right before period-end can distort a single snapshot. Averaging the beginning and ending balances gives a more representative DSO when receivables swing significantly during the period.
Comparing DSO across mismatched period lengths
A DSO of 15 over a 30-day month and a DSO of 15 over a 91-day quarter are not equivalent in terms of sales volume. Keep the period length constant, or convert to an annualized basis, before comparing across periods.
Skipping the net credit sales adjustment
Net credit sales are reduced by discounts, allowances, and returns. Using gross credit sales as the denominator overstates the sales figure and understates DSO, making collections look better than they actually are.
Comparing DSO to a fixed “good” benchmark
A company on net-60 terms with a DSO of 40 is performing well, while the same DSO on net-15 terms signals a serious collections problem. What counts as a healthy DSO depends entirely on your stated payment terms and industry norms — compare DSO to your own terms and trend, not a universal number.
A/R Days Calculator FAQ
Is A/R days the same as DSO, debtor days, or average collection period?+
What counts as a “good” DSO?+
Why aren’t cash sales included in the calculation?+
Should I use ending A/R or average A/R?+
How does rising DSO affect cash flow?+
What’s the difference between DSO and the A/R turnover ratio?+
How does DSO relate to the cash conversion cycle?+
More Calculators Like This A/R Days Calculator
A/R Days Calculator: Formula References
- Days Sales Outstanding (DSO). Corporate Finance Institute.
- Days Sales Outstanding (DSO): Formula + Calculator. Wall Street Prep.
- Accounts Receivable Turnover Ratio. Corporate Finance Institute.
- Accounts Receivable Turnover Ratio. Wall Street Prep.
- Days Sales Outstanding. Wikipedia.
- Days Sales Outstanding (DSO). Association for Financial Professionals.