Vendor payment terms analysis

Vendor payment terms analysis is the practice of measuring and comparing the credit terms a business secures from its suppliers, expressed as the weighted average number of days it is allowed to pay. If a supplier offers net 60, the business can hold the cash for 60 days after the invoice date before payment is due. Weighting each vendor by spend turns a list of contract terms into a single number that describes how the whole supplier base affects cash.

The analysis matters because payment terms are working capital. Every extra day of terms across the supplier base is a day the business keeps its own cash rather than the supplier holding it. A company spending 12 million pounds a year that moves its weighted average terms from 30 days to 45 days frees up roughly 500,000 pounds of cash that no longer sits in payables. That cash can fund growth, reduce borrowing, or sit as a buffer.

The number cuts both ways. Terms that are too short drain cash. Terms that are extended without regard to early-payment discounts can cost more than they save, because a 2 percent discount for paying in 10 days is often worth more than the cash freed by waiting 60. Good analysis weighs the cost of capital against the value of each discount, vendor by vendor.

The headline figure is a spend-weighted average of every vendor payment window. A vendor you spend 2 million pounds with at net 30 should pull the average harder than a vendor you spend 20,000 pounds with at net 90. Once you have the weighted average, the analysis decomposes it into the inputs that move it.

1. 1

   Vendor spend

   Total annual spend with each supplier. This is the weight in the calculation and determines which vendors actually matter to the cash position. A handful of large vendors usually account for most of the spend, so they dominate the weighted average.

2. 2

   Contracted payment window

   The agreed net terms for each vendor, in days. Net 30, net 45, and net 60 are common. This is the figure you negotiate, and it is the primary lever for extending the weighted average.

3. 3

   Early-payment discount terms

   Many vendors offer a discount, such as 2 percent off for paying within 10 days. Each discount has an implied annualised return that should be compared against your cost of capital before deciding whether to take it or hold the cash.

4. 4

   Actual days payable

   When invoices are settled in practice. Comparing this against the contracted window shows whether accounts payable is paying early, on time, or late. This input feeds days sales outstanding thinking applied to the payables side.

With these inputs in place, the analysis produces three readings: the weighted average contracted terms, the weighted average actual days payable, and the value of discounts taken versus forgone. The gap between contracted and actual terms is where the easiest cash improvement usually hides, because closing it requires a process change rather than a renegotiation.

A metric tree decomposes weighted average payment terms into the drivers that move it, then traces each driver back to the team that owns it. This turns a finance report into a working list of interventions.

The first level splits the weighted average into contracted terms, payment timing behaviour, and discount economics. Contracted terms decompose into the share of spend on long terms, the share on short terms, and the terms held by your largest vendors. Payment timing decomposes into early payments, on-time payments, and late payments, each of which has a different cause and a different fix. Discount economics decomposes into discounts captured and discounts forgone.

Reading the tree top down tells you exactly where the cash is. If the weighted average is short, the tree shows whether the cause is unfavourable contracts with big vendors or accounts payable paying ahead of terms. Each answer points to a different owner and a different action.

Benchmarks vary by industry, company size, and buyer leverage. Large buyers command longer terms because their volume matters to suppliers, while small businesses often accept shorter terms to secure supply. The figures below are typical weighted average ranges rather than hard rules.

Longer is not automatically better. A weighted average that climbs because a business is stretching payments past contracted terms damages supplier relationships and can trigger price increases or supply risk. Healthy extension comes from negotiated terms and from declining discounts that are worth less than your cost of capital, not from paying late.

Improving the weighted average is a balance between extending terms where it helps and capturing discounts where they beat the cost of capital. The biggest gains come from focusing on the vendors that carry the most spend, because they move the weighted average the most.

The metric tree approach starts by finding the branch with the largest gap between current and potential performance. If most spend already sits on long terms but discounts are being forgone, the discount branch is the priority. If terms are short with the largest vendors, renegotiation comes first.

KPI Tree lets you model these scenarios by connecting each branch of the weighted average to the team that controls it. Procurement owns the contracted terms with major vendors. Accounts payable owns the payment timing that determines whether you pay early or on terms. Finance owns the cost-of-capital threshold that decides which discounts to take. With RACI ownership on each node, the accountable owner is pushed an alert when their branch moves, so a slip in payment timing or a forgone discount reaches the person who can act on it rather than waiting for the next month-end review.

1. 1

   Using a simple average instead of a spend-weighted one

   A simple average across vendors treats a 20,000 pound supplier the same as a 2 million pound one. The weighted average is the only figure that reflects the real effect on cash, so always weight by spend.

2. 2

   Extending terms while ignoring discounts

   Chasing a longer weighted average can lead a team to decline discounts that were worth far more than the cash freed by waiting. Always compare the discount return against the cost of capital before holding payment.

3. 3

   Confusing contracted terms with actual payment days

   Reporting contracted terms while quietly paying early overstates how well working capital is being managed. Track both, and treat the gap between them as a separate opportunity.

4. 4

   Stretching past terms to inflate the number

   Paying late lengthens the average on paper but damages supplier relationships, invites price rises, and creates supply risk. Healthy extension comes from negotiation, not from breaching agreed terms.