AR Days Calculator - Calculate Accounts Receivable Days Outstanding
Quickly compute your DSO (Days Sales Outstanding) and compare against industry benchmarks.
Calculator
What Are AR Days (Accounts Receivable Days)?
An accurate ar days calculation is essential for understanding your company's financial health. This metric, also known as Days Sales Outstanding (DSO) or Collection Period, measures the average number of days it takes your company to collect payments from customers after a credit sale. This critical financial metric indicates how efficiently your business manages cash flow and collects outstanding invoices. AR Days directly impacts your working capital and cash flow. A lower AR Days figure means faster collection times, improved cash flow, and reduced risk of bad debt. Companies with efficient collection processes typically maintain AR Days between 30-45 days, though this varies significantly by industry.
How to Calculate AR Days - Step by Step Guide
AR Days Formula
Primary Formula (Recommended): AR Days = (Average Accounts Receivable ÷ Net Credit Sales) × Number of Days
Alternative Formula: AR Days = (Ending Accounts Receivable ÷ Net Credit Sales) × Number of Days
Calculation Steps
- Determine Average Accounts Receivable: Add beginning period AR balance + ending period AR balance, then divide by 2.
- Calculate Net Credit Sales: Total credit sales minus returns, allowances, and discounts.
- Choose Time Period: Typically 365 days (annual), 90 days (quarterly), or 30 days (monthly).
- Apply Formula: Divide average AR by daily sales, or use the complete formula above.
Example AR Days Calculation
If your company has Beginning AR: $150,000; Ending AR: $200,000; Annual Net Credit Sales: $1,200,000 — then AR Days = (($150,000 + $200,000) ÷ 2) ÷ ($1,200,000 ÷ 365) = $175,000 ÷ $3,287.67 ≈ 53.2 days.
Industry Benchmarks and Performance Standards
Performance Ratings
Excellent (Under 30 days): Outstanding collection efficiency. Good (30-45 days): Above-average performance, healthy cash flow. Average (45-60 days): Standard performance, room for improvement. Poor (Over 60 days): Collection issues, potential cash flow problems.
Industry-Specific Benchmarks
- Retail: 15-30 days
- Manufacturing: 45-60 days
- Professional Services: 30-45 days
- Healthcare: 35-50 days
- Technology/Software: 25-40 days
- Construction: 60-90 days
How to Improve Your AR Days
Best Practices for Faster Collection
- Implement Clear Credit Policies: Establish customer credit limits and payment terms.
- Automate Invoice Processing: Use accounting software for immediate invoice generation.
- Offer Multiple Payment Options: Accept credit cards, ACH, and online payments.
- Send Prompt Reminders: Automated follow-ups for overdue accounts.
- Provide Early Payment Discounts: 2/10 net 30 terms encourage faster payment.
- Regular AR Aging Analysis: Monitor and manage overdue accounts actively.
Frequently Asked Questions (FAQ)
What is a good AR Days ratio?
A good AR Days ratio typically ranges from 30-45 days for most industries. However, this varies significantly by business type. Retail businesses should target under 30 days, while manufacturing companies may accept 45-60 days due to longer payment cycles.
How often should I calculate AR Days?
Calculate AR Days monthly to monitor trends and identify collection issues early. Quarterly calculations work for annual planning, but monthly tracking provides better cash flow management insights.
What's the difference between AR Days and DSO?
AR Days and Days Sales Outstanding (DSO) are identical metrics with different names. Both measure the average collection period for accounts receivable.
Should I use average or ending balance for calculations?
The average balance method provides more accurate results by accounting for seasonal fluctuations and business cycle variations. Use ending balance only for quick estimates or when historical data is unavailable.
How do AR Days affect cash flow?
Higher AR Days tie up more working capital in unpaid invoices, reducing available cash for operations, investments, and growth opportunities. Reducing AR Days by just 5-10 days can significantly improve cash flow.
What causes high AR Days?
Common causes include lenient credit policies, inefficient collection processes, poor customer screening, inadequate follow-up procedures, and economic downturns affecting customer payment ability.
Can AR Days be too low?
While faster collection is generally better, extremely low AR Days (under 15 days) might indicate overly restrictive credit policies that could limit sales growth and customer relationships.
Related Financial Metrics
Understanding AR Days works best alongside other key performance indicators: AR Turnover Ratio, Collection Effectiveness Index (CEI), Bad Debt Ratio, and Cash Conversion Cycle.