คู่มือโดยละเอียดเร็วๆ นี้
เรากำลังจัดทำคู่มือการศึกษาที่ครอบคลุมสำหรับ Accounts Receivable Turnover กลับมาเร็วๆ นี้เพื่อดูคำอธิบายทีละขั้นตอน สูตร ตัวอย่างจริง และเคล็ดลับจากผู้เชี่ยวชาญ
Accounts receivable (AR) turnover is a financial efficiency ratio that measures how many times a company collects its average accounts receivable balance during a period — typically a year. It is a key indicator of the effectiveness of a company's credit and collection policies and directly impacts cash flow and working capital requirements. A higher turnover ratio means the company collects receivables quickly and efficiently; a lower ratio suggests slow collections, potential credit quality issues, or overly lenient payment terms. The ratio is calculated by dividing net credit sales (or net revenue) by average accounts receivable. The result tells you how many collection cycles occurred in the period. More practically useful is the inverse: Days Sales Outstanding (DSO), which converts the turnover ratio into the average number of days it takes to collect payment after a sale. DSO = 365 / AR Turnover Ratio. For example, a DSO of 45 days means it takes 45 days on average to collect from customers. DSO must be interpreted in context. A company offering 30-day payment terms but with DSO of 60 days has a collection problem. A company offering 45-day terms with DSO of 48 days is performing well. The best comparison is the company's own stated credit terms, industry benchmarks, and historical trends. Rising DSO over time is a red flag: it may indicate customers are struggling to pay (credit risk), sales force is offering extended terms to close deals, or collections staff is understaffed. AR management directly affects the cash conversion cycle. Every additional day of DSO represents one more day's worth of revenue tied up in uncollected receivables. For a company with $100M in annual revenue, each additional day of DSO is approximately $274,000 in additional working capital tied up — a real financing cost. This is why aggressive AR management and DSO reduction are common priorities in corporate treasury and working capital optimization programs. Accounts receivable quality is also critical: an AR balance that includes many aged or doubtful accounts is worth less than a current AR balance, even if the total dollar amount is the same. Analysts should examine the AR aging schedule alongside the turnover ratio to get a complete picture.
AR Turnover = Net Credit Sales / Average Accounts Receivable DSO = 365 / AR Turnover (or: Average AR / (Net Credit Sales / 365))
- 1Obtain net credit sales for the period (typically from the income statement; use total revenue if credit/cash split is unavailable).
- 2Calculate average accounts receivable: (AR at start of period + AR at end of period) / 2.
- 3Calculate AR turnover: Net Credit Sales / Average AR.
- 4Convert to DSO: 365 / AR Turnover, or Average AR / (Net Credit Sales / 365).
- 5Compare DSO to the company's stated payment terms (net 30, net 45, etc.) to assess collection effectiveness.
- 6Analyze the AR aging schedule: what percentage is current, 30–60 days, 60–90 days, 90+ days?
- 7Benchmark against industry peers and track the trend over multiple periods to identify improving or deteriorating collection performance.
Excellent — collecting on net 30 terms almost perfectly
Average AR = ($180,000 + $220,000) / 2 = $200,000. AR Turnover = $2,400,000 / $200,000 = 12.0 times per year. DSO = 365 / 12 = 30.4 days. With net 30 terms, collecting in 30.4 days is essentially perfect performance. This indicates strong credit policies, an effective collections team, and a creditworthy customer base. Maintaining this level of efficiency on $2.4M in sales means approximately $200,000 in working capital is needed to support the AR balance.
Slow if net 30 terms; acceptable for net 45–60 terms
Average AR = $700,000. Turnover = $5,000,000 / $700,000 = 7.14x. DSO = 365 / 7.14 = 51.1 days. If this company offers net 30 terms, DSO of 51 days means customers are paying 21 days late on average — a significant collection problem. Each day of DSO reduction saves $13,699 in tied-up working capital ($5M / 365 = $13,699/day). Reducing DSO from 51 to 35 days would free $219,178 in cash — significant for a mid-size business.
Fast collection; mostly credit card receipts settled in 2–3 days
Net credit sales = $10,000,000 × 80% = $8,000,000. Turnover = $8,000,000 / $300,000 = 26.7x. DSO = 13.7 days. The very low DSO reflects that 'credit' sales for retailers are largely credit card transactions settled by card processors within 2–3 business days, rather than open account trade credit. This illustrates why industry context matters — retail DSO benchmarks are very different from B2B industrial company benchmarks.
Healthcare DSOs are high due to insurance billing cycles
Turnover = $15,000,000 / $4,500,000 = 3.33x. DSO = 109.6 days — far higher than most industries. This is typical for healthcare providers because insurance reimbursement involves claim submission, adjudication, appeals, and patient balance billing, which can take 60–120+ days. The bad debt allowance of $900,000 (20% of AR) reflects that some claims will be denied or uncollectable. Healthcare finance teams track DSO by payer class (Medicare, Medicaid, commercial insurance, self-pay) to identify problem areas.
Credit and collections department performance measurement — This application is commonly used by professionals who need precise quantitative analysis to support decision-making, budgeting, and strategic planning in their respective fields
Working capital optimization programs in large corporations — Industry practitioners rely on this calculation to benchmark performance, compare alternatives, and ensure compliance with established standards and regulatory requirements, helping analysts produce accurate results that support strategic planning, resource allocation, and performance benchmarking across organizations
Bank credit line sizing (revolving credit facilities based on eligible AR). Academic researchers and students use this computation to validate theoretical models, complete coursework assignments, and develop deeper understanding of the underlying mathematical principles
Accounts receivable factoring and asset-based lending eligibility — Financial analysts and planners incorporate this calculation into their workflow to produce accurate forecasts, evaluate risk scenarios, and present data-driven recommendations to stakeholders
M&A due diligence on customer payment quality and credit risk. This application is commonly used by professionals who need precise quantitative analysis to support decision-making, budgeting, and strategic planning in their respective fields
{'case': 'Factoring Receivables', 'explanation': 'When a company sells its AR to a factor at a discount for immediate cash, the AR balance drops dramatically, making DSO look artificially low. Analysts should check notes to financial statements for factoring arrangements.'} When encountering this scenario in accounts receivable calc calculations, users should verify that their input values fall within the expected range for the formula to produce meaningful results. Out-of-range inputs can lead to mathematically valid but practically meaningless outputs that do not reflect real-world conditions.
{'case': 'Seasonal Businesses', 'explanation': 'Companies with seasonal revenue patterns show AR balances that peak after high-season and trough in slow periods. Using year-end AR rather than average AR can significantly distort the ratio — always use average AR for seasonal businesses.'} This edge case frequently arises in professional applications of accounts receivable calc where boundary conditions or extreme values are involved. Practitioners should document when this situation occurs and consider whether alternative calculation methods or adjustment factors are more appropriate for their specific use case.
{'case': 'Concentration Risk', 'explanation': 'A low DSO average may mask a single large customer paying quickly while other customers are chronically slow. Review the top-10 customer AR aging to identify concentration and risk.'} In the context of accounts receivable calc, this special case requires careful interpretation because standard assumptions may not hold. Users should cross-reference results with domain expertise and consider consulting additional references or tools to validate the output under these atypical conditions.
| Industry | Typical DSO | Credit Terms | Notes |
|---|---|---|---|
| Technology/Software | 40–60 days | Net 30–45 | Complex enterprise deals extend billing |
| Healthcare | 60–120 days | Insurance-dependent | Insurance adjudication cycle drives delay |
| Manufacturing | 30–50 days | Net 30–45 | Varies by customer size and product |
| Construction | 45–75 days | Net 30–60 | Retainage and milestone billing common |
| Retail | 5–15 days | Credit card settlement | Most 'credit' is card-based |
| Government Contracting | 60–90 days | Net 45–60 | Slow government payment cycles |
| Professional Services | 35–60 days | Net 30–45 | Depends on milestone vs. monthly billing |
Should I use gross revenue or net credit sales to calculate AR turnover?
For the most accurate AR turnover calculation, use net credit sales — revenue from credit transactions only, after deducting sales returns and allowances. If you include cash sales in the numerator but the AR balance only reflects credit sales (which it should), you overstate the turnover ratio and understate DSO. In practice, many analysts use total net revenue when the credit/cash split is not readily available, which slightly distorts the ratio but is acceptable for trend and peer comparison purposes. Always note which revenue figure you used when presenting the analysis.
What DSO is considered good?
A good DSO depends heavily on industry and credit terms. As a general rule, DSO should not exceed payment terms by more than one-third. If terms are net 30, DSO above 40 days warrants investigation. For B2B companies, DSO between 30 and 45 days is typically healthy. For industries like healthcare (60–120 days), construction (45–75 days), or government contracting (60–90 days), higher DSOs are structural and expected. The most meaningful benchmark is the company's own historical trend and explicit payment terms, not a generic industry number.
What causes DSO to rise over time?
Rising DSO can result from many factors: the sales team offering extended payment terms to close deals (common near quarter-end), growth into new customer segments with slower payment habits, economic downturns causing customer cash flow stress, understaffed or inefficient collections processes, billing errors that delay invoice approval, disputes or quality issues causing payment holds, or deliberate strategic decisions to offer extended terms to large customers. Distinguishing between these causes is critical — some are concerning (customer financial distress) and others are manageable (process improvements needed).
How does DSO reduction improve cash flow?
Every day of DSO reduction converts one day's worth of revenue from receivables to cash. The cash improvement from DSO reduction = Daily Revenue × Days Reduced. For a company with $50M in annual revenue, each day of DSO reduction frees $136,986 in cash ($50M / 365). Reducing DSO from 45 to 35 days releases $1.37M in cash — cash that was previously sitting in customer accounts. This is 'free' cash flow generated purely from operational improvement, with no need for asset sales or borrowing.
What is the difference between DSO and the best possible DSO?
Best Possible DSO (BPDSO) = Current (non-past-due) AR / (Annual Revenue / 365). It represents the minimum achievable DSO if all past-due accounts were collected — the theoretical floor assuming only current invoices remain open. The gap between actual DSO and BPDSO is called the 'delinquent DSO' — days tied up in overdue accounts. A large gap signals a collections effectiveness problem. Tracking both metrics helps separate the structural delay (from normal billing cycles) from the avoidable delay (from late-paying customers).
What is an AR aging schedule and why is it important?
An AR aging schedule categorizes outstanding receivables by how long they have been outstanding: current (not yet due), 1–30 days past due, 31–60 days past due, 61–90 days past due, and 90+ days past due. This schedule is critical because the probability of collection decreases dramatically with age — accounts over 90 days past due may have only a 50% collection probability, while current accounts are nearly 100% collectible. The aging schedule helps identify specific problem accounts, estimate the allowance for doubtful accounts, and prioritize collection efforts.
Can a very high AR turnover ratio be a bad thing?
Yes, in some cases. An extremely high AR turnover (very low DSO) may indicate that credit terms are too tight, which could be causing the company to lose sales to competitors offering more flexible payment terms. If a company's credit policy is so strict that only the best credit risks are approved, it may be forgoing profitable sales from creditworthy-but-not-pristine customers. The optimal DSO balances the cost of capital tied up in receivables against the sales revenue generated by offering credit terms that match customer needs.
เคล็ดลับโปร
Calculate DSO monthly and plot it over time. A trend line tells you far more than any single period's ratio. Set a DSO target based on your payment terms (e.g., target DSO = terms + 7 days) and build collections KPIs around that goal.
คุณรู้ไหม?
Accounts receivable factoring — selling invoices for immediate cash — dates back to ancient Mesopotamia and Babylon, where merchants sold their trade claims to financiers at a discount. The practice was common in colonial American trade financing long before modern banking systems developed.