The Average Settlement Period for Trade Receivables: Formula and Use

The average settlement period for trade receivables measures how long, on average, a business takes to collect cash from its credit customers. It is expressed in days, it is one of the four working capital ratios, and it is the one that most directly reflects a management decision and not a market condition.

The ratio matters because a sale is not a sale until it is collected. A business can grow revenue, report a profit and run out of cash simultaneously, and the settlement period is the figure that shows it happening before the bank balance does.

The formula

The calculation divides the amount owed by the amount owed per day:

Average settlement period = (trade receivables ÷ credit sales) × 365

Trade receivables comes from the statement of financial position, before any allowance for irrecoverable debts is deducted if the analysis is about collection speed rather than credit quality. Credit sales comes from the income statement.

The result is a number of days. A figure of 45 means that, on average, the business is waiting forty-five days between raising an invoice and receiving the money.

Where an average of the opening and closing receivables balance is available, using it produces a more representative figure than the closing balance alone, because a single year-end number reflects whatever was happening in the final weeks of the year.

A worked example

A company reports credit sales of £2,920,000 and trade receivables of £480,000.

Sales per day are £2,920,000 ÷ 365 = £8,000. Receivables of £480,000 therefore represent £480,000 ÷ £8,000 = 60 days.

If stated terms are thirty days, the business is being paid, on average, a month late. The overdue element is £8,000 × 30 = £240,000 of cash sitting in customers' bank accounts rather than its own. At an overdraft rate of 8% that costs roughly £19,200 a year, which is the number worth putting in front of a board, because it converts a ratio into a figure that competes with other uses of management attention.

Reading the result

Three comparisons make the number mean something, and a figure quoted without at least one of them says very little.

Against the stated credit terms. This is the only internal benchmark available, and it separates a policy problem from an enforcement problem. Sixty days against sixty-day terms is a policy the business chose; sixty days against thirty-day terms is a collection failure.

Against the trend. A settlement period lengthening steadily over three years is the single most useful signal in the ratio, because it usually precedes a cash problem by several quarters. The trend is also harder to distort than a single figure.

Against the sector. Credit terms vary enormously between industries, and a comparison with a business in a different sector is meaningless. Retailers selling for cash have almost no receivables; construction and professional services routinely run beyond ninety days because of certification and billing cycles.

What a rising figure actually means

The obvious reading is that collection has deteriorated. There are at least four other explanations, and distinguishing them is what analysis consists of.

Deliberate relaxation to win business. Extending credit is a competitive weapon, and a rising settlement period accompanied by rising sales may be a strategy working as intended. The question is then whether the additional margin covers the financing cost and the additional bad debt risk.

A change in customer mix. Winning a large public sector or major corporate customer frequently lengthens the average, because such customers pay on their own terms and cannot be pressed. The ratio worsens while the receivable itself becomes safer.

Seasonality and year-end timing. A business whose busiest quarter ends in the final month of its financial year will show a high closing receivables balance against a full year of sales, inflating the figure. This is an artefact of the measurement date, not a change in behaviour.

Deteriorating credit quality. The genuinely worrying case, where customers are slow because they are themselves short of cash. An ageing analysis distinguishes this immediately: an average of sixty days made up of most invoices at thirty and a few at two hundred is a different problem from one where every invoice is at sixty.

That last point is the main limitation of the ratio. It is an average, and an average conceals distribution. Two businesses with identical settlement periods can have completely different exposures, and the ageing profile is what separates them.

Further traps in the calculation

Several mechanical issues make published comparisons unreliable, and a careful answer names them.

Credit sales are frequently not disclosed. External analysts usually have only total revenue, which includes cash sales. Using total revenue for a business with a significant cash element understates the settlement period, sometimes severely. The substitution is often unavoidable; it should be stated and not hidden.

Sales tax. Receivables include recoverable sales tax; revenue does not. The two figures are therefore not on the same basis, and in a jurisdiction with a twenty per cent rate the distortion adds roughly a fifth to the apparent settlement period. Where the analysis is internal and the data is available, grossing up sales or netting down receivables removes it.

Factoring and invoice discounting. A business that sells its receivables shows a low settlement period without collecting any faster. The balance sheet note is the only way to see it, and ignoring it produces a flattering figure that means nothing about the underlying collection process.

Netting and contract assets. Where amounts recoverable on contracts are classified separately from trade receivables, a business can appear to collect promptly while the money sits in a different line.

The irrecoverable debt question, which is separate

Speed of collection and probability of collection are different exposures, and the ratio addresses only the first.

A business can collect quickly from the customers who pay and carry a growing balance of invoices that will never be settled at all. If the allowance for irrecoverable debts is deducted before the ratio is calculated, the settlement period improves each time the position worsens, because the slowest balances are the ones being written down. Calculating on the gross figure avoids that perverse movement, and the allowance is then examined on its own as a percentage of receivables and as a percentage of revenue.

The two measures answer to different remedies as well. A collection problem is solved by process — invoicing, chasing, escalation. A recoverability problem is solved before the sale, by credit assessment and limits, because once the goods have gone the decision has already been taken.

The ratio in the cash operating cycle

The settlement period is one component of a larger measure, and its usefulness increases considerably when read alongside the other two.

The cash operating cycle is the inventory holding period plus the receivables settlement period less the payables settlement period. It expresses the number of days between paying a supplier and being paid by a customer, and that gap is the period the business must fund from its own resources.

Read together, the three ratios show where working capital pressure is being generated and where it is being passed on. A business whose receivables period has risen by twenty days and whose payables period has risen by the same amount has not solved the problem; it has moved it onto its suppliers, and the supplier relationship will eventually price it back in. A business whose receivables period rises while its payables period is fixed by contract is absorbing the whole movement in cash.

The payables comparison also supplies the honest test of a collection policy. Pressing customers to pay in thirty days while taking seventy-five from suppliers is a position with limited stability, particularly where the same firms appear on both sides of the ledger.

What management can actually change

The ratio is more responsive to intervention than most, which is why it is a standard target.

Invoicing promptly and accurately removes the single largest avoidable delay: an invoice queried for a wrong reference or a missing order number restarts the payment cycle from the date of resolution, not the date of supply. Agreeing terms explicitly in writing at the point of sale prevents the customer's own standard terms from governing by default. Settlement discounts accelerate cash at a known cost, which should be compared with the cost of borrowing before they are offered, because a two per cent discount for payment twenty days early is an expensive source of funds when annualised. Credit checking at onboarding, and credit limits enforced by the order system, not by goodwill, prevent the exposure from arising. Systematic follow-up, starting before the due date and not after it, remains the intervention with the best return.

What management cannot change quickly is the sector norm and the payment behaviour of customers large enough to dictate terms. A target that ignores both produces a plan nobody can deliver.

How it is examined

The typical question supplies two years of figures and asks for calculation, interpretation and recommendation.

Calculate carefully and show the basis. State whether you have used credit sales or total revenue, and whether receivables are opening, closing or averaged, because the marks are for a defensible figure rather than a particular one.

Interpret against terms, trend and sector, and resist the reflex that a longer period is automatically worse. Say what else would explain the movement and what evidence would distinguish the explanations, with the ageing analysis named specifically.

Then link it to cash. The point of the ratio is not the ratio; it is the amount of money tied up and what it costs. Converting the days into a sum, as in the example above, and comparing that with the financing cost is what turns a calculation into analysis, and it is usually where the higher marks sit.