Accounts Receivable Turnover Calculator

Accounts receivable turnover counts how many times a business collects its average receivables balance over a period. It is net credit sales divided by average receivables, and its inverse scaled to a year is Days Sales Outstanding: the average gap between raising an invoice and being paid. The calculator returns both, plus a band for the day count, because the ratio is the figure used in ratio analysis while the day count is what gets compared against payment terms.

The loaded figures connect the two. Credit sales of 8M against average receivables of 1M give a turnover of 8.00 and a DSO of 45.6 days, which is about two weeks past net-30 terms. Double the receivables to 2M on the same sales and turnover halves to 4.00 with a DSO of 91.3 days, which against those same net-30 terms is roughly two months late rather than one. Move the other way and 500k of receivables gives 16.00 and 22.8 days.

The reason DSO carries more weight than the ratio is that it converts directly into cash. Every day of DSO on 8M of annual credit sales ties up 8,000,000 divided by 365, or 21,918. Cutting DSO from 60 days to 45 therefore releases about 328,767, and the same fifteen days is worth the same amount whether the starting point is 60 days or 120. That linearity is what makes DSO the operational number and the turnover ratio the comparative one, alongside the rest of the working capital cycle.

Run it with sensible defaults

Net credit sales of 8,000,000 against average receivables of 1,000,000 give a turnover ratio of 8.00 and Days Sales Outstanding of 45.6 days. The tool also bands the day count on fixed cut-offs at 30, 60 and 90 days.

Those cut-offs are scale markers rather than an assessment, since the same day count can mean opposite things. A DSO of 91 days under agreed net-90 terms is collection working as intended; the same 91 days on net-30 terms is two months of arrears. The comparison that separates them is arithmetic: the turnover implied by a payment term is 365 divided by that term, so net-30 corresponds to 12.17, net-45 to 8.11, net-60 to 6.08 and net-90 to 4.06. The loaded 8.00 sits just under the net-45 figure.

The levers in this calculation

Both inputs move the ratio by the same magnitude but in opposite directions, which the phrase "same proportion" obscures. Credit sales scale it directly, so 1% more sales takes turnover from 8.00 to 8.08. Average receivables sit in the denominator, so 1% more receivables takes it to 7.92. Days Sales Outstanding moves the other way in each case, from 45.6 to 45.2 and to 46.1 respectively.

Which of the two moved matters more than the ratio itself. A turnover that improves because sales grew while receivables stayed flat means collection kept pace with growth. The same improvement produced by receivables falling on flat sales means cash came in faster. And a turnover that improves because sales fell faster than receivables looks identical in the ratio while describing a shrinking business, which is why the tool reports both inputs as their own rows alongside the result.

How the math works

Turnover is net credit sales divided by average receivables. Days Sales Outstanding is 365 divided by turnover. Average receivables is normally the opening and closing balances halved, so the figure represents the period rather than a single balance sheet date.

Two definitional points affect whether a figure compares with anything. The numerator should exclude cash sales, because those have no collection cycle and including them inflates the ratio without any change in collection performance. And published receivables-to-sales ratios are usually computed on total sales rather than credit sales, so a sector with mostly cash or card transactions shows a very short implied DSO that reflects the sales mix rather than fast collection.