The formula
How to calculate receivable turnover
Receivable turnover counts how many times a year a business collects its outstanding invoices. It is a direct measure of how effectively credit control is working.
Use credit sales rather than total revenue. Including cash sales inflates the numerator and makes collections look faster than they are — significant for any business with a mixed sales model.
What to enter:
- Credit sales — exclude cash sales, which are collected immediately
- Average receivables
The result updates on every keystroke. The URL updates too, which makes the filled-in version easy to bookmark or send to someone else.
Where a figure is not immediately to hand — a precise interest rate, an exact balance — a reasonable estimate is a perfectly good starting point. Because every result updates instantly, refining a rough guess into the real figure once you have it takes a moment, and nothing about the calculation depends on getting it exactly right on the first attempt.
Why receivable turnover matters
The formula behind receivable turnover is standard and has not changed in decades; what changes is the situation it gets applied to. Two households can run the identical calculation and land on very different conclusions once their own numbers — income, rate, term, balance — are dropped in, which is why a generic textbook example is less useful than a calculator you can adjust to match your own circumstances.
This tends to come up when comparing two concrete alternatives — two lenders, two savings products, two ways of structuring the same decision — rather than in the abstract. Run both scenarios through the same calculator with the same assumptions and the comparison becomes fair, because the only thing changing between the two results is the number you are actually trying to test.
This kind of calculation rarely stands entirely alone. A receivable turnover figure usually feeds into a wider decision — how it compares with a competing offer, whether it fits inside a monthly budget, what it does to a longer-term plan — and the value of having it as an exact number rather than a rough guess is that those follow-on comparisons stop being guesswork too. Once one figure in a decision is precise, it is worth making the effort to get the others precise as well, rather than mixing an exact calculation with several estimates and treating the result as equally reliable.
In practice, most people arrive at a page like this one having already tried a version of the calculation by hand or in a spreadsheet, and use the calculator here to confirm it rather than replace it. That is a reasonable way to use it — the two should agree to the last decimal place if the same inputs and the same formula are used, and if they do not, the formula shown above is the one to check your own working against first.
Worked example
Here is the calculation with the starting values:
- Credit sales: 2,400,000
- Average receivables: 270,000
That gives:
- Receivable turnover: 8.89 × per year
- Average collection period: 41.06 days
- Average receivables as months of sales: 1.35 months
These figures are only the calculator's own starting values, included so the working is visible rather than hidden inside the tool above. Replace them with your own numbers and the same arithmetic applies — nothing about the method changes, only the inputs feeding it.
Reading the result
Compare the collection period against your stated payment terms. Invoicing on 30 days and collecting in 41 means the average customer is eleven days late, and that gap is a permanent loan you are making for free.
Where this goes wrong. An average hides concentration. One large customer 90 days overdue can sit inside a respectable average while representing most of the actual risk — read the ageing report, not just the ratio.
A useful check on any unfamiliar result is to compare it against a rough mental estimate first — round the inputs to convenient numbers and see whether the calculator's answer lands in roughly the same territory. A wildly different figure usually means one of the fields was entered in the wrong unit, most often a percentage typed as a whole number where a decimal was expected, or the reverse.
Enough that the collection period is close to your terms. On 30-day terms that means a turnover around 12; on 60-day terms, around 6.
Invoice immediately, confirm receipt, chase a few days before the due date rather than after, and make paying easy. Late-payment interest under the Late Payment of Commercial Debts Act is available, though it is rarely charged.
The answer it gives you is receivable turnover. With 2,400,000 credit sales and 270,000 average receivables, that comes to 8.89 × per year. Change any field and the figure moves with it.
Whenever one of the underlying figures changes — a new interest rate, a different balance, an updated term — since the result only reflects what is currently in the fields. There is no need to keep a separate record of past results; the web address for a filled-in version already carries the figures used to produce it.
Not unless a tax rate or a fee is explicitly one of the inputs above. Where it is not, the figure shown is a gross calculation, and any tax due depends on your personal circumstances and current tax rules, which are worth checking separately.
The arithmetic itself is exact — the calculator applies the formula shown above precisely, with no rounding until the final figure is displayed. The uncertainty, where it exists, is entirely in the inputs: an estimated rate or an approximate balance carries that same approximation through to the result.