❤ Want to see our calculators more often in Google? Add us as a trusted source:
An accounts receivable calculator turns the messy work of tracking unpaid invoices into a clear, actionable number. It computes your receivables turnover ratio, days sales outstanding, and average collection period — the metrics that tell you how fast cash actually arrives after a sale. For any business that extends credit, these figures separate a healthy operation from one slowly suffocating under a growing pile of overdue invoices. This guide explains every formula, provides worked examples, and shows how to interpret the results against real industry benchmarks.
At its simplest, an AR calculator compares two figures: how much customers owe you, and how much you sold on credit. From those two numbers, it derives a series of ratios and day-counts that describe the speed and completeness of your collections process. The three most commonly computed outputs are the accounts receivable turnover ratio, days sales outstanding (DSO), and the average collection period. Each looks at the same underlying data from a slightly different angle.
The turnover ratio expresses collections as a multiple — how many times you converted your average receivables balance into cash during a period. DSO converts that ratio into days, which is more intuitive for most managers. The average collection period is effectively the same figure as DSO, and the two terms are used interchangeably in practice. What matters is not the label but the trend: a receivables calculator becomes genuinely useful when you run it monthly or quarterly and compare the results over time.
The complexity arises because "credit sales" and "average receivables" must be defined carefully. Net credit sales exclude cash sales, returns, and discounts. Average receivables take the opening and closing balances and split the difference. A calculator that ignores these refinements produces a misleading figure. The accounts receivable calculator on Calculator200 applies the standard definitions, so you can enter figures from your balance sheet and income statement directly.
The receivables turnover ratio is the foundational metric. It answers a single question: how many times did your business collect its average outstanding balance during the period?
Net credit sales are gross credit sales minus sales returns, sales allowances, and any discounts granted. Average accounts receivable is calculated as opening receivables plus closing receivables, divided by two. Using an average rather than a period-end figure smooths out seasonal swings that would otherwise distort the ratio.
Consider a company with gross credit sales of $2.3 million. After $100,000 in discounts, $125,000 in returns, and $75,000 in allowances, net credit sales come to $2 million. Opening receivables were $420,000 and closing receivables $380,000, giving an average of $400,000. The turnover ratio is $2,000,000 ÷ $400,000 = 5.0. That means the company collected its average receivables balance five times during the year[reference:0].
Interpretation is straightforward: a higher ratio indicates faster collection. But a very high ratio can also signal that credit terms are too restrictive, potentially driving away customers who need reasonable payment windows. The correct target is one that aligns with your industry norms and your own credit policy.
DSO converts the turnover ratio into the average number of days a sale remains unpaid. It is the single most-watched metric in receivables management because it translates directly into cash flow impact.
Use net credit sales for accuracy, and match the day count to your measurement period — 365 for a full year, 90 for a quarter, or approximately 30 for a month[reference:1]. If a SaaS company holds $500,000 in receivables against $3 million in annual credit sales, its DSO is ($500,000 ÷ $3,000,000) × 365 = 60.8 days. On average, it waits about 61 days after invoicing to get paid.
What counts as a good DSO depends entirely on your payment terms. A useful rule of thumb is that DSO should not exceed roughly 1.5 times your standard terms. If you bill on Net 30, a DSO under 45 days is healthy; consistently above that figure points to collection friction. B2B software and professional services firms typically run DSO between 40 and 70 days, while construction and manufacturing often operate in the 60-to-90-day range as a structural feature of their billing models[reference:2].
The trend matters more than the absolute number. A DSO creeping upward month after month is an early warning that collections are slipping, often before the aging report makes the problem obvious.
The average collection period is mathematically identical to DSO in most formulations, though some practitioners draw a subtle distinction based on which receivables balance is used. The direct formula is:
There is also a shortcut: divide the number of days in the period by the receivables turnover ratio. Both routes produce the same answer[reference:3]. A company with average receivables of $240,000 and annual net credit sales of $2.4 million has an average collection period of ($240,000 ÷ $2,400,000) × 365 = 36.5 days. The turnover ratio is 10, and 365 ÷ 10 gives the same 36.5 days.
For a business on Net 30 terms, a collection period of 36.5 days is a few days slow but not alarming. Above 45 days on Net 30 terms signals a collections problem worth investigating. The most revealing test is the gap between your actual collection period and your stated payment terms. That gap is the average lateness embedded in your receivables book.
For businesses operating in India, where credit-intensive B2B transactions are the norm, DSO and average collection period benchmarks tend to run longer than in Western markets. Manufacturing DSO in India typically falls between 45 and 60 days, SaaS between 30 and 45 days, and wholesale distribution between 30 and 50 days. A DSO consistently exceeding 75 to 90 days may indicate liquidity risk and the need to tighten credit management processes[reference:4].
DSO tells you how fast you collect. The Collection Effectiveness Index (CEI) tells you how completely you collect what was available to collect. It strips out the effect of changing sales volumes, which can distort DSO, and focuses purely on the collections function's performance.
The numerator is the amount collected during the period. The denominator is the amount that was theoretically collectible — beginning receivables plus new credit sales, minus receivables that were not yet due at period end. A CEI near 100% indicates a collections department operating at peak effectiveness. Scores above 90% are excellent; above 80% is strong[reference:5].
CEI does have limitations. It does not account for the age of outstanding receivables, so a high score can mask a growing problem in the 90-plus day bucket. It also treats write-offs as collections, which can inflate the figure artificially. For these reasons, CEI is best read alongside the aging report and DSO, not in isolation[reference:6].
Average Days Delinquent (ADD) measures the average number of days an invoice is paid past its due date. It isolates the lateness component from the total collection time.
Best Possible DSO is what DSO would be if every customer paid exactly on terms. It is calculated as current receivables divided by credit sales, multiplied by the number of days. The gap between actual DSO and that theoretical floor is the average lateness across your receivables book[reference:7]. A small and stable ADD means slippage is contained. A widening ADD means accounts are aging and the collections process is losing ground.
The aging schedule groups unpaid invoices by how long they are overdue. It is the operational backbone of collections: it tells you where to focus effort when you have more overdue accounts than time.
The standard buckets are current (not yet due), 1–30 days past due, 31–60 days, 61–90 days, and 90+ days. Some teams add a 120-plus bucket for high-risk accounts[reference:8]. Each bucket demands a different response. A 1–30 day invoice is usually an oversight and recovers with a friendly reminder. A 31–60 day invoice needs firmer follow-up that names consequences. A 61–90 day invoice is a genuine collection problem requiring direct contact and a clear ask for a payment date. Anything beyond 90 days carries sharply reduced collection odds and should be treated as a potential write-off.
A healthy receivables ledger keeps the vast majority of value in the current and 1–30 day buckets, with a thin 90-plus tail. When weight shifts rightward, cash is slowing and bad debt risk is building. The aging report is also the primary input for estimating the allowance for doubtful accounts, since age is the single best predictor of whether a debt will go bad.
For a more detailed breakdown of how aging schedules work, including how to build one from your invoice ledger, the accounts receivable calculator includes an aging module that sorts receivables into the standard buckets automatically.
The bad debt ratio measures the share of credit sales that a company ultimately writes off as uncollectible. It is the lagging measure of credit and collections risk — the receivables that aging and ADD warned about and that were never recovered.
A low ratio, typically well under 1% for most businesses, signals sound credit policy and disciplined follow-up. A rising ratio points back upstream to credit decisions that were too loose or accounts that were allowed to age past the point of recovery[reference:9]. Tracking the bad debt ratio alongside DSO and aging gives a complete picture: aging shows where the risk is accumulating, DSO shows how fast you are collecting, and bad debt ratio shows what ultimately slipped through.
Receivables performance varies enormously by industry. A SaaS business on Net 30 terms cannot be judged against a construction firm holding retainage on milestone-based projects. The table below summarises typical DSO ranges across major sectors, drawing on 2026 benchmark data.
| Industry | Typical DSO Range | Notes |
|---|---|---|
| Retail and e-commerce | 5–20 days | Card payments settle in 1–3 days; minimal credit terms |
| SaaS and subscription | 30–45 days | Recurring billing, Net 30–45 contracts |
| Wholesale distribution | 30–50 days | Standard trade terms |
| Professional services | 30–60 days | Mix of milestones, retainers, and hourly billing |
| Manufacturing | 45–60 days | Milestone invoicing on large orders |
| Healthcare | 45–70 days | Insurance claim processing and denials |
| Construction | 60–90+ days | Retainage and multi-tier approval chains |
These ranges are drawn from industry benchmark data compiled in 2025 and 2026[reference:10]. The cross-industry average DSO sits near 40 days, but the right target is your industry's range, not the global mean. For UK businesses, the Chartered Institute of Credit Management reports professional services turnover ratios of 10–14 times annually, IT and software at 9–12 times, and manufacturing at 7–10 times[reference:11].
In India, DSO benchmarks follow a similar pattern but with longer absolute figures. Manufacturing typically runs 45–60 days, SaaS 30–45 days, and wholesale distribution 30–50 days. A DSO consistently above 75–90 days is a red flag for Indian businesses regardless of sector[reference:12].
Spreadsheet users can compute all of these metrics with standard functions. The key is to use the correct references and to avoid the common error of dividing by 365 when a period-specific day count is required.
For the turnover ratio:
For DSO on an annual basis:
For the average collection period using the turnover shortcut:
The critical discipline is consistency. Always use net credit sales, not gross sales. Always use an average receivables figure for the turnover ratio, not a single period-end balance. If you use period-end balances for one period, use them for all periods so the comparison is meaningful. Mixing methods across periods makes trends impossible to read.
Improving AR metrics is less about aggressive chasing and more about removing the friction that causes late payment in the first place. The most effective levers are operational, not contractual.
For a full breakdown of how each of these levers affects the metrics described in this guide, the accounts receivable calculator allows you to model the impact of changes to credit terms, collection follow-up frequency, and payment incentives on your DSO and turnover ratio.
The accounts receivable turnover ratio is calculated by dividing net credit sales by average accounts receivable. Net credit sales are total credit sales minus returns and discounts. Average accounts receivable is the sum of the beginning and ending balances divided by two.
DSO equals accounts receivable divided by total credit sales, multiplied by the number of days in the period. For an annual figure, use 365 days. For a monthly measure, use 30 days. A lower DSO means you collect payments faster.
A good ratio depends on your industry. Higher is generally better because it means you collect payments more frequently. Compare your ratio against industry benchmarks to judge your performance accurately. In UK professional services, ratios of 10–14 times annually are typical, while manufacturing averages 7–10 times.
The average collection period equals average accounts receivable divided by net credit sales, multiplied by the number of days in the period. It tells you the average number of days it takes to collect payment on credit sales. It is mathematically equivalent to DSO.
Aging buckets group unpaid invoices by how long they are overdue. Standard buckets are current, 1–30 days, 31–60 days, 61–90 days, and 90+ days past due. These buckets help prioritize collection efforts and assess risk. The further an invoice drifts rightward through the buckets, the lower the probability of collection.
CEI is a percentage measuring how effectively a company collects its available receivables in a period. The formula is (Beginning AR + Credit Sales – Ending Total AR) divided by (Beginning AR + Credit Sales – Ending Current AR), multiplied by 100. A score above 90% is excellent. Unlike DSO, CEI is not distorted by changes in sales volume.
An AR calculator helps small businesses quickly compute turnover ratios, DSO, and average collection periods without manual errors. It provides real-time visibility into cash flow health and helps set smarter credit policies. For a small business without a dedicated credit team, an automated calculator is the difference between guessing and knowing.
Reducing DSO requires invoicing promptly, offering easy payment options, sending automated reminders, resolving disputes quickly, and segmenting customers by risk. Consistent follow-up and clean data are the most reliable levers. Offering early-payment incentives such as 2/10 Net 30 also encourages faster settlement when margins allow.
An accounts receivable calculator is not a magic wand, but it is a necessary instrument. It converts the vague anxiety of "are we collecting fast enough?" into a set of numbers you can compare against benchmarks, track over time, and act on with precision. Whether you are a small business owner checking your first DSO figure or a CFO presenting receivables performance to a board, the formulas in this guide provide the foundation. Use the accounts receivable calculator on Calculator200 to run the numbers, and treat the output as a living signal — not a historical record.