Accounts payable turnover ratio: formula and meaning

The accounts payable turnover ratio is net credit purchases divided by average trade payables for the same period. It shows how large a period's purchases are relative to the supplier credit carried on the balance sheet. A change needs an explanation in purchasing, terms, or payment behavior before it becomes a management conclusion.

The accounts payable turnover formula

Accounts payable turnover = Net credit purchases / Average trade payables

Average trade payables = (Opening trade payables + Closing trade payables) / 2

Net credit purchases = Credit purchase invoices − Related purchase credits

The unit is times per stated period. An annual ratio and a quarterly ratio cover different purchase flows and cannot be compared as if they use the same window. CFA Institute classifies payables turnover as an activity ratio, alongside inventory and receivables turnover.

Trade payables means the supplier liabilities represented by the purchase population. Do not mix a merchandise-only numerator with a denominator that also includes equipment suppliers and outside services. Either include their corresponding credit purchases or define and reconcile a narrower payable population. Exclude bank borrowing, payroll liabilities, and taxes payable from a supplier turnover calculation.

The two-date average is a practical starting point. If purchases or balances vary sharply during the year, use consistently spaced balance snapshots instead, disclose the method, and keep that method across suppliers and comparison periods.

Start with the purchase and payable exports

Bring the invoice register for the full reporting period and the AP aging reports at its opening and closing dates. Keep supplier ID, invoice ID, accounting date, document type, reporting currency amount, credit or cash status, due date, and settlement date where available. Keep the opening and closing supplier balances in a separate table so joining them to invoices does not repeat each balance.

The IRS recordkeeping guide identifies invoices and other supporting documents as evidence for purchases and expenses. Retain those references when grouping the register; a summarized supplier total should still lead back to its documents.

Use posted credit purchases. A purchase order is a commitment, not automatically a booked purchase or liability. Cash purchases never enter trade payables and should not enter this numerator. Supplier credit memos reduce the related purchases once, using the same accounting cutoff as the ledger.

Apply one currency and tax policy to both sides. The treatment of credits, tax, and currency in procurement spend explains why an invoice total may differ from its comparable reporting amount. Document exclusions rather than silently forcing the figures to agree.

A worked example by supplier

An illustrative US distributor measures the year ended December 31, 2025. All invoices below are credit purchases, and the purchase population matches the trade payables population. The amounts are in USD; turnover is rounded to two decimal places after calculation.

Each step follows from the same row. Packaging net purchases are 900,000 − 30,000 = $870,000; average AP is (75,000 + 105,000) / 2 = $90,000. Dividing 870,000 by 90,000 gives 9.67 times, rounded.

If the columns above occupy A through H, the accounts payable turnover calculator in a spreadsheet needs these formulas on the first supplier row:

=B2-C2
=(E2+F2)/2
=IF(G2=0,NA(),D2/G2)

For the total, divide total purchases by total average AP:

=SUM(D2:D4)/SUM(G2:G4)

That gives 1,870,000 / 240,000 = 7.79 times, rounded. Do not average supplier turnover ratios: their payable balances differ. The receivables turnover ratio measures the customer side of trade credit and uses a different numerator and balance.

Prove the purchase and balance totals

First, tie opening and closing AP to the supplier subledger and general ledger. Then reconcile the year's movement. Assume this example has no foreign exchange movement, write-offs, or reclassifications:

Closing AP = Opening AP + Net credit purchases − Payments applied

The company check is 200,000 + 1,870,000 − 1,790,000 = $280,000, matching closing AP. In a real export, include separate rows for every other movement. An unexplained difference is a data problem to resolve before interpreting turnover.

Interpret changes with the AP owner

The controller owns the calculation and ledger tie. AP explains payment runs and disputed invoices; procurement explains changes in negotiated terms, supplier mix, and discount arrangements. Treasury assesses whether payment timing fits the cash plan.

A falling ratio might follow longer agreed terms or a concentration of purchases late in the period. It might also accompany overdue invoices. A rising ratio might follow faster payment, a shift toward short-term suppliers, or an unusually low closing balance. Inspect supplier groups and due-date compliance before changing policy.

Use days payable outstanding when the question is payment days. For a peer comparison, the separate accounts payable turnover ratio by industry discussion covers matching benchmark definitions; no universal turnover target fits every purchasing model.

Where it goes wrong

• Substituting COGS without a label. COGS describes goods sold, while purchases describe goods acquired. The Census Bureau's wholesale definitions explicitly connect COGS with beginning inventory, purchases, and ending inventory. Cash purchases and service invoices create further differences.
• Joining balances onto invoice rows. Summing a repeated supplier balance inflates the denominator. Aggregate invoices and balance snapshots separately before combining them.
• Using unmatched dates or populations. A partial purchase register cannot support a full-year ratio. Include the same entities, suppliers, currencies, and account scope on both sides.
• Treating zero or debit AP as ordinary credit. Investigate prepayments, supplier debit balances, and missing snapshots. Report an exception instead of an apparently impressive ratio.

Compare your own supplier records in Covirage

Bring a sample of your own purchase register and payable balance exports to Covirage: it maps the columns, and its tools compute and check turnover on the agreed basis. The external AI model explains the comparisons with every figure traced to its rows. Create a free Covirage account and set up your business before bringing your records.

See how Covirage supports finance teams.