Accounts receivable turnover, days sales outstanding (DSO), and the Collection Effectiveness Index (CEI) are complementary management measures: turnover shows how often receivables are collected, DSO estimates time to cash, and CEI compares collections with the receivables available to collect. They are most useful when the organization uses the same definitions, period, and aging rules each time; none replaces invoice-level review or entity-specific accounting analysis.
Begin with a consistent receivables dataset
Before calculating a KPI, document which balances and sales are included. A comparison is meaningful only when the underlying population and cut-off are consistent. In particular, distinguish trade receivables from other amounts due, and exclude cash sales when the formula calls for credit sales.
| Input | Practical definition to document | Why it matters |
|---|---|---|
| Receivables balance | Beginning, ending, or average trade AR; whether credit memos and disputed items are included | The choice changes the numerator or denominator of several measures. |
| Sales base | Net credit sales for the same period, excluding cash sales if applicable | Using total sales can make a credit-collection measure look stronger or weaker than it is. |
| Period and cut-off | Monthly, quarterly, or annual period; closed-ledger date | The day count and sales period must match the AR balance. |
| Current AR | The aging buckets treated as not past due under the organization’s stated terms | CEI and best-possible DSO depend on this definition. |
AR turnover: collections velocity
Formula: AR turnover = Net credit sales ÷ Average accounts receivable.
Average accounts receivable is commonly calculated as beginning AR plus ending AR, divided by two. J.P. Morgan’s treasury guide to AR turnover and DSO uses this form and describes turnover as the number of times outstanding receivables are collected during the period. A higher result can reflect faster payment and collection, but it can also reflect a changed sales mix, shorter payment terms, a smaller receivables base, or a different credit policy. Compare it with the same season, customer mix, and credit-sales definition rather than treating one ratio as a universal benchmark.
DSO: an estimate of time to cash
Formula: DSO = (Ending accounts receivable ÷ Net credit sales) × Number of days in the period.
DSO converts the relationship between ending AR and credit sales into days. The same J.P. Morgan guide presents this ending-balance convention and notes that it measures how quickly credit sales convert to cash. Some teams instead use average AR to create an average collection-period measure. Either approach can be useful, but the report should name the convention and should not compare a period-end DSO directly with an average-balance measure.
Best possible DSO and average days delinquent
DSO alone can move because sales or terms changed, not only because past-due invoices changed. The Credit Research Foundation’s performance-measures guide defines best possible DSO as current receivables × days in the period ÷ credit sales. It defines average days delinquent as DSO minus best possible DSO. These measures can focus attention on the gap between current and overdue AR, provided that the organization applies its aging and payment-term rules consistently.
CEI: collection effectiveness within a period
Formula: CEI (%) = [(Beginning receivables + (Credit sales ÷ N) − Ending total receivables) ÷ (Beginning receivables + (Credit sales ÷ N) − Ending current receivables)] × 100, where N is the number of months in the reporting period.
CEI is designed to show the share of collectible receivables that was collected during the period. The Credit Research Foundation formula uses the monthly-sales convention above and explains that a result closer to 100 percent represents more effective collection under that method. It is not a universal pass-or-fail target. A change in the definition of “current,” a large credit memo, unusual sales timing, or an aging reclassification can alter CEI, so report those events alongside the percentage.
Net receivables and portfolio value are separate questions
A management bridge can begin with gross trade AR less an allowance for expected credit losses to show a net receivables amount. That bridge should not automatically be treated as a purchase price or as a complete financial-reporting conclusion. In a receivables sale or financing analysis, returns, discounts, credit memos, disputes, setoffs, eligibility rules, and repurchase obligations may be defined separately in the agreement. The relevant contract, accounting policy, asset type, and cut-off determine how those items are handled.
For U.S. SEC registrants, 17 CFR 210.5-02 requires separate disclosure of trade receivables and requires the allowance for doubtful accounts and notes receivable to be shown separately in the balance sheet or a note. In addition, FASB’s July 2025 announcement of ASU 2025-05 describes optional guidance for estimating expected credit losses on certain current accounts receivable and current contract assets. These are U.S. financial-reporting sources; they do not determine the valuation or contractual remedies for every private transaction.
Use the measures as a diagnostic set
- Close the reporting period and reconcile the AR population to the ledger before calculating ratios.
- Calculate turnover and DSO using the documented sales and balance conventions.
- Review CEI, current AR, and the aging schedule together to identify whether change is concentrated in past-due, disputed, or newly billed invoices.
- Investigate material movement at the customer and invoice level, then record whether the driver was sales timing, terms, cash application, billing accuracy, disputes, credit quality, or another defined cause.
- Keep the metric definitions with the dashboard so later users can compare periods on the same basis.
A rising DSO or a falling CEI is a prompt for investigation, not proof of a collection-team failure. A disciplined review also protects against the opposite error: celebrating a better ratio that came from lower credit sales, a changed reporting cut-off, or an altered aging policy. For related working-capital context, see this site’s article on the cash conversion cycle and liquidity optimization.
Frequently asked questions
What is the accounts receivable collection period?
The accounts receivable collection period estimates how many days, on average, it takes to collect credit sales. One common approach is to divide average receivables by net credit sales and multiply by the number of days; an ending-balance DSO uses ending receivables instead. Label the method and use it consistently.
Which measure can improve accounts receivable management?
No measure improves receivables by itself. AR turnover and DSO help track speed, while CEI and the aging schedule help show collection performance and where overdue balances are concentrated. The useful practice is to review the measures together, investigate the driver, and then assess the operational change.
Limitations and review point
These formulas are operational measures, not legal advice, a required valuation method, or a substitute for financial statements prepared under the accounting framework that applies to the entity. Organizations should have a qualified accounting professional review allowance methodology, presentation, and any transaction-specific dilution or purchase-price calculation; counsel should review contract and jurisdiction-specific rights or remedies.