Accounts Payable Key Performance Indicators: What Payment Timing Tells You

Paying suppliers later and paying them late are different things. A business that negotiates longer credit terms can retain cash for longer while honouring its commitments.

Accounts payable key performance indicators should distinguish payment punctuality, the relationship between payables and purchasing activity, and early-payment discount capture. Read together, these measures help separate cash-policy decisions from failures to pay as agreed.

Start with agreed terms and payment evidence

For every invoice, retain the contractual due date, any agreed changes to terms and evidence of settlement. Approval records show when a bill was authorised; payment-run schedules show when it was planned for payment. Settlement is a separate event.

Before Automating your Netsuite Accounts Payable, agree how these records will be maintained. Kefron describes invoice capture and configurable approval routing; payment-performance reporting also requires a defined source for settlement evidence.

Use the same payment-date definition across departments, so comparisons consistently measure settlement rather than mixing it with authorisation or scheduling.

On-time payment rate: keep unpaid invoices in view

For an internal scorecard, calculate punctuality against invoices due during the reporting period:

On-time payment rate = invoices due in the period and fully settled by their due dates ÷ all valid invoices due in the period × 100.

Include invoices settled early, paid late or still unpaid after becoming due. Selecting only paid invoices can hide the overdue bills awaiting settlement.

Show outstanding balances overdue from earlier periods separately, because they fall outside the current period’s due-date group. Disclose exclusions and identify disputed invoices rather than silently removing them.

An invoice-count percentage gives a small bill the same weight as a large one. Put the value of late and unpaid items beside it to show the financial exposure.

Days payable outstanding: look behind the movement

Days payable outstanding (DPO) relates the trade payables balance to purchasing activity. For a purchase-based calculation:

DPO = average trade payables ÷ credit purchases for the period × days in the period.

Keep the payables and purchases populations aligned, including their VAT treatment. Averaging opening and closing balances provides a simple approximation; more frequent balances can better capture movements within the period.

Cost of sales is sometimes used as a proxy for purchases. Stock movements, however, can separate purchasing activity from costs recognised in the accounts, so check the calculation basis before comparing results.

DPO summarises balances and purchasing activity rather than timing individual invoices. A rise can reflect longer agreed terms, a different supplier mix or overdue payments. Punctuality figures and the underlying terms help distinguish those explanations.

Discount capture: separate missed savings from policy choices

Calculate value-based discount capture using eligible invoices whose discount deadlines fall within the reporting period. Divide discounts actually realised by the discount value available, then multiply by 100.

Both figures should represent discount amounts, rather than the total value of eligible invoices. Measuring capture by invoice count answers a different question and can obscure larger missed savings. Where no discounts were available, report the result as not applicable rather than zero.

Early payment brings the cash outflow forward. Assess the saving against financing costs and near-term cash requirements before treating a higher capture rate as an improvement.

Separate discounts lost through processing delays from those deliberately declined under an agreed cash policy. One calls for a workflow investigation; the other calls for a review of the financial decision.

Read the three measures together

Consider a hypothetical business across two comparable 30-day periods. Credit purchases remain £600,000, while average trade payables rise from £600,000 to £900,000.

Using the purchase-based formula, DPO rises from 30 to 45 days. In each period, however, 190 of the 200 invoices due are settled punctually, leaving the on-time payment rate unchanged at 95%.

Suppose available discounts total £2,000 in each period. Realised discounts fall from £2,000 to £1,500, reducing capture from 100% to 75%.

Check the supplier agreements and cash-policy records to establish whether longer terms and deliberate discount decisions explain these movements. Then investigate the ten invoices that missed their due dates and establish why £500 of discounts went uncaptured.

Review the measures together each month, recording reasons for material movements beside the figures. Use that evidence to decide whether a payment failure needs correcting, a cash-policy choice needs revisiting or a change reflects agreed terms.