Accounts Receivable Turnover Calculator: AR & Sales

Is an accounts receivable turnover of 4.00x healthy?

On the defaults — $1,200,000.00 of net credit sales and $300,000.00 of average accounts receivable over 365 days — the accounts receivable turnover is 4.00x, the days to collect is 91.25 days, the average accounts receivable needed for a 5.00x turnover is $240,000.00, and the net credit sales needed for a 5.00x turnover is $1,500,000.00. The accounts receivable turnover — net credit sales divided by average accounts receivable — is the collections test: how many times per year you collect everything your customers owe you. A turnover of 5–10x a year is typical for many businesses (about 36–73 days to collect); retail businesses often run higher because most sales are cash; construction and manufacturing often run lower because invoices are large and payment terms are long. A turnover below about 3x — over 120 days to collect — usually signals a collections problem worth chasing. The same turnover can mean different things by industry — a retailer and a construction firm do not collect the same way — so compare within an industry, not across them.

Four things about the model are worth stating plainly. First, the accounts receivable turnover is the net credit sales divided by the average accounts receivable — $1,200,000.00 ÷ $300,000.00 = 4.00x. Second, the days to collect is the days in the period divided by the turnover — 365 ÷ 4.00 = 91.25 days. Third, the average accounts receivable needed at the target is the net credit sales divided by the target turnover — $1,200,000.00 ÷ 5 = $240,000.00. And fourth, the net credit sales needed at the target is the average accounts receivable times the target turnover — $300,000.00 × 5 = $1,500,000.00; all listed in Accuracy & limitations.

The worked example, line by line

Setup: $1,200,000.00 of net credit sales, $300,000.00 of average accounts receivable, 365 days in the period, target turnover 5.00x.

Line 1 — the accounts receivable turnover. The accounts receivable turnover is $1,200,000.00 ÷ $300,000.00 = 4.00x.

Line 2 — the days to collect. The days to collect is 365 ÷ 4.00 = 91.25 days.

Line 3 — the average accounts receivable needed. The average accounts receivable needed for a 5.00x turnover is $1,200,000.00 ÷ 5 = $240,000.00.

Line 4 — the net credit sales needed. The net credit sales needed for a 5.00x turnover is $300,000.00 × 5 = $1,500,000.00.

Line 5 — the check. $1,200,000.00 ÷ $300,000.00 = 4.00x, the turnover; and 365 ÷ 4.00 = 91.25 days, the days to collect.

Every branch, checked

Net credit sales $600,000: Accounts receivable turnover 2.00x; days to collect 182.50 days; average accounts receivable needed for the 2.00x target $300,000.00; net credit sales needed for the 2.00x target $600,000.00 — With net credit sales of $600,000.00 the turnover falls to 2.00x — customers take 182.50 days to pay, the slow band.

Average accounts receivable $150,000: Accounts receivable turnover 8.00x; days to collect 45.63 days; average accounts receivable needed for the 8.00x target $150,000.00; net credit sales needed for the 8.00x target $1,200,000.00 — With average accounts receivable of $150,000.00 the turnover rises to 8.00x — customers pay in 45.63 days, in the typical 5–10x band.

Net credit sales $1,800,000: Accounts receivable turnover 6.00x; days to collect 60.83 days; average accounts receivable needed for the 6.00x target $300,000.00; net credit sales needed for the 6.00x target $1,800,000.00 — With net credit sales of $1,800,000.00 the turnover rises to 6.00x — customers pay in 60.83 days.

Days in period 90: Accounts receivable turnover 4.00x; days to collect 22.50 days; average accounts receivable needed for the 4.00x target $300,000.00; net credit sales needed for the 4.00x target $1,200,000.00 — Over a 90-day quarter the same sales and receivables give a turnover of 4.00x and 22.50 days to collect — the same money, measured over a shorter window.

Average accounts receivable $100,000: Accounts receivable turnover 12.00x; days to collect 30.42 days; average accounts receivable needed for the 12.00x target $100,000.00; net credit sales needed for the 12.00x target $1,200,000.00 — With average accounts receivable of $100,000.00 the turnover rises to 12.00x — customers pay in 30.42 days, faster than the typical band.

Average accounts receivable $240,000: Accounts receivable turnover 5.00x; days to collect 73.00 days; average accounts receivable needed for the 5.00x target $240,000.00; net credit sales needed for the 5.00x target $1,200,000.00 — With average accounts receivable of $240,000.00 the turnover is 5.00x — the target itself, in 73.00 days.

Net credit sales $0: Accounts receivable turnover 0.00x; days to collect — (nothing sold on credit); average accounts receivable needed for the 5.00x target $0.00; net credit sales needed for the 5.00x target $1,500,000.00 — With no net credit sales the turnover is 0.00x — nothing sold on credit, so there is nothing to collect.

The reverses, worked backwards

Largest whole-dollar average accounts receivable for the turnover to STAY at or above 4.00x: At the displayed $300,000 the figures are Accounts receivable turnover 4.00x; days to collect 91.25 days; average accounts receivable needed for the 4.00x target $300,000.00; net credit sales needed for the 4.00x target $1,200,000.00. At the displayed $300,000 the accounts receivable turnover is 4.00x. At $300,001 the receivables are $1 over the $300,000 allowed — and the unrounded turnover is 3.999987, which displays as 4.00x after rounding, so $300,000 is the largest whole-dollar average accounts receivable for the turnover to stay at or above 4.00x.

Smallest whole-dollar net credit sales for the turnover to reach 5.00x: At the displayed $1,500,000 the figures are Accounts receivable turnover 5.00x; days to collect 73.00 days; average accounts receivable needed for the 5.00x target $300,000.00; net credit sales needed for the 5.00x target $1,500,000.00. At the displayed $1,500,000 the accounts receivable turnover is 5.00x. At $1,499,999 the sales are $1 short of the $1,500,000 needed — and the unrounded turnover is 4.999997, which displays as 5.00x after rounding, so $1,500,000 is the smallest whole-dollar net credit sales for the turnover to reach 5.00x.

Largest whole-dollar average accounts receivable for the turnover to STAY at or above 6.00x: At the displayed $200,000 the figures are Accounts receivable turnover 6.00x; days to collect 60.83 days; average accounts receivable needed for the 6.00x target $200,000.00; net credit sales needed for the 6.00x target $1,200,000.00. At the displayed $200,000 the accounts receivable turnover is 6.00x. At $200,001 the receivables are $1 over the $200,000 allowed — and the unrounded turnover is 5.999970, which displays as 6.00x after rounding, so $200,000 is the largest whole-dollar average accounts receivable for the turnover to stay at or above 6.00x.

Smallest whole-dollar net credit sales for the turnover to reach 3.00x: At the displayed $900,000 the figures are Accounts receivable turnover 3.00x; days to collect 121.67 days; average accounts receivable needed for the 3.00x target $300,000.00; net credit sales needed for the 3.00x target $900,000.00. At the displayed $900,000 the accounts receivable turnover is 3.00x. At $899,999 the sales are $1 short of the $900,000 needed — and the unrounded turnover is 2.999997, which displays as 3.00x after rounding, so $900,000 is the smallest whole-dollar net credit sales for the turnover to reach 3.00x.

Largest whole-dollar average accounts receivable for the turnover to STAY at or above 8.00x: At the displayed $150,000 the figures are Accounts receivable turnover 8.00x; days to collect 45.63 days; average accounts receivable needed for the 8.00x target $150,000.00; net credit sales needed for the 8.00x target $1,200,000.00. At the displayed $150,000 the accounts receivable turnover is 8.00x. At $150,001 the receivables are $1 over the $150,000 allowed — and the unrounded turnover is 7.999947, which displays as 8.00x after rounding, so $150,000 is the largest whole-dollar average accounts receivable for the turnover to stay at or above 8.00x.

Smallest whole-dollar net credit sales for the turnover to reach 10.00x: At the displayed $3,000,000 the figures are Accounts receivable turnover 10.00x; days to collect 36.50 days; average accounts receivable needed for the 10.00x target $300,000.00; net credit sales needed for the 10.00x target $3,000,000.00. At the displayed $3,000,000 the accounts receivable turnover is 10.00x. At $2,999,999 the sales are $1 short of the $3,000,000 needed — and the unrounded turnover is 9.999997, which displays as 10.00x after rounding, so $3,000,000 is the smallest whole-dollar net credit sales for the turnover to reach 10.00x.

A warning about the neighbours: every neighbour above shows as the target when rounded to two decimals, but its unrounded turnover is a hair below the target. A lender underwriting on the unrounded turnover would still say no where the unrounded figure misses the line. The page prints the unrounded neighbour value in full so the rounding does not mislead you: 3.999987, 4.999997, 5.999970, 2.999997, 7.999947 and 9.999997.

What the defaults assume

The defaults are $1,200,000.00 of net credit sales, $300,000.00 of average accounts receivable, 365 days in the period and a target turnover of 5.00x — Accounts receivable turnover 4.00x; days to collect 91.25 days; average accounts receivable needed for the 5.00x target $240,000.00; net credit sales needed for the 5.00x target $1,500,000.00. With Net credit sales $600,000, Accounts receivable turnover 2.00x; days to collect 182.50 days; average accounts receivable needed for the 2.00x target $300,000.00; net credit sales needed for the 2.00x target $600,000.00. With Average accounts receivable $150,000, Accounts receivable turnover 8.00x; days to collect 45.63 days; average accounts receivable needed for the 8.00x target $150,000.00; net credit sales needed for the 8.00x target $1,200,000.00. With Net credit sales $1,800,000, Accounts receivable turnover 6.00x; days to collect 60.83 days; average accounts receivable needed for the 6.00x target $300,000.00; net credit sales needed for the 6.00x target $1,800,000.00. With Days in period 90, Accounts receivable turnover 4.00x; days to collect 22.50 days; average accounts receivable needed for the 4.00x target $300,000.00; net credit sales needed for the 4.00x target $1,200,000.00. With Average accounts receivable $100,000, Accounts receivable turnover 12.00x; days to collect 30.42 days; average accounts receivable needed for the 12.00x target $100,000.00; net credit sales needed for the 12.00x target $1,200,000.00. With Average accounts receivable $240,000, Accounts receivable turnover 5.00x; days to collect 73.00 days; average accounts receivable needed for the 5.00x target $240,000.00; net credit sales needed for the 5.00x target $1,200,000.00. With Net credit sales $0, Accounts receivable turnover 0.00x; days to collect — (nothing sold on credit); average accounts receivable needed for the 5.00x target $0.00; net credit sales needed for the 5.00x target $1,500,000.00. With Average accounts receivable $0, Accounts receivable turnover — (undefined: no accounts receivable to divide by); average accounts receivable needed for the 5.00x target $240,000.00; net credit sales needed for the 5.00x target $0.00. With Net credit sales $0, Accounts receivable turnover 0.00x; days to collect — (nothing sold on credit); average accounts receivable needed for the 5.00x target $0.00; net credit sales needed for the 5.00x target $1,500,000.00. With Net credit sales $987,654, average accounts receivable $123,456, Accounts receivable turnover 8.00x; days to collect 45.62 days; average accounts receivable needed for the 5.00x target $197,530.80; net credit sales needed for the 5.00x target $617,280.00. With Average accounts receivable $600,000, Accounts receivable turnover 2.00x; days to collect 182.50 days; average accounts receivable needed for the 5.00x target $240,000.00; net credit sales needed for the 5.00x target $3,000,000.00. With Net credit sales $2,400,000, Accounts receivable turnover 8.00x; days to collect 45.63 days; average accounts receivable needed for the 5.00x target $480,000.00; net credit sales needed for the 5.00x target $1,500,000.00. With Net credit sales $1,200,001, Accounts receivable turnover 4.00x; days to collect 91.25 days; average accounts receivable needed for the 5.00x target $240,000.20; net credit sales needed for the 5.00x target $1,500,000.00. With Target bars — net credit sales $1,200,000, average accounts receivable $300,000, average accounts receivable needed at the 3.00x target $400,000.00; at the 6.00x target $200,000.00; net credit sales needed at the 3.00x target $900,000.00; at the 6.00x target $1,800,000.00.

A note on the rounding: with net credit sales of $987,654 and average accounts receivable of $123,456 the unrounded turnover is 8.000049, which rounds half-up to 8.00x — the page prints the unrounded value so the rounding does not mislead you. With net credit sales of $1,200,001 and average accounts receivable of $300,000 the unrounded turnover is 4.000003, which rounds to 4.00x. With average accounts receivable of $600,000 the turnover is 2.00x, and with net credit sales of $2,400,000 the turnover is 8.00x.

Output · formula · meaning

Who uses this

• The small-business owner checking the year: they learn $1,200,000.00 of net credit sales on $300,000.00 of average accounts receivable gives a turnover of 4.00x — and they check the $300,000 reverse to see the largest receivables that still stay at or above 4.00x.
• The finance manager chasing slow payers: they learn a turnover below about 3x — over 120 days to collect — usually signals a collections problem worth chasing — and they check the $1,500,000 reverse to see the smallest net credit sales that reach a 5.00x turnover.
• The manufacturer whose turnover slipped to 6.00x: they learn the business sits in the typical 5–10x band — and they check the $200,000 reverse to see the largest receivables that stay at or above 6.00x.
• The retailer collecting in about 30 days: they learn a high turnover is normal for retail because most sales are cash — and they check the $3,000,000 reverse to see the smallest net credit sales that reach a 10.00x turnover.

Accuracy & limitations

The math is first-principles: the accounts receivable turnover is the net credit sales divided by the average accounts receivable, rounded to two decimals half-up; the days to collect is the days in the period divided by the turnover; the average accounts receivable needed at the target is the net credit sales divided by the target turnover; the net credit sales needed at the target is the average accounts receivable times the target turnover. The reverses are judged on the UNROUNDED turnover: a neighbour one dollar short or over shows as the target when rounded to two decimals, but its unrounded turnover is below the target, so it does not meet the bar — the page prints the unrounded neighbour value in full. What the model cannot do is judge the business: only CREDIT sales count — cash sales are excluded, because cash is already collected; the average accounts receivable is (opening + closing) ÷ 2, a simple average that hides swings inside the period; with average accounts receivable of $0 the turnover is undefined — the calculator shows “—” with a note, never Infinity or NaN; with net credit sales of $0 the turnover is 0.00x and the days to collect is “—” — nothing sold on credit; a high turnover means customers pay fast and little cash is tied up in unpaid invoices; a low turnover means slow payers, more cash stuck in receivables, and a higher risk of bad debts; and the same turnover means different things by industry, so compare within an industry, not across them. The days to collect is the same number as days sales outstanding (DSO) — the two are the same idea in different units. Use it to see how fast customers pay you — then read the rest of the statements.

Frequently asked questions