Blog · Finance metrics and formulas · Finance and FP&A teams
Build a documented payable turnover comparison from dated US peer reports. See a worked retail comparison, the limits of cost-of-sales proxies and the balance averaging choices that affect an industry benchmark.
An accounts payable turnover ratio industry average is useful only when you can rebuild its peer group, dates, cost basis and average balances. A published number without that information cannot establish whether your company pays suppliers appropriately. Use a documented peer comparison as a screening measure, then test the explanation against your purchase records and agreed terms.
For your own ledger, net credit purchases divided by average trade payables is the relevant turnover basis. The accounts payable turnover formula explains that calculation and its export requirements. The question here is how to compare it with other companies without silently changing the measure.
Public financial statements often disclose cost of sales but do not identify net purchases made on credit. Cost of sales can therefore serve as a transparent proxy for a public-report comparison. It is not interchangeable with purchases: inventory movements and the types of costs included can create material differences.
Public-report comparison used below = Annual reported cost of sales / Average of opening and closing reported accounts payable.
Use that basis for every company in the comparison, including your own company. Keep the separate purchases-based operating ratio in another column. A change of label cannot make those two ratios directly comparable.
Also inspect the payables note. If the disclosed balance contains material capital expenditure obligations, financing arrangements or non-trade balances, either adjust all companies consistently with supported data or explain why the comparison remains preliminary.
The following two companies are US-headquartered retailers. Walmart's figures cover the fiscal year ended January 31, 2025, with opening balances at January 31, 2024. The source is Walmart's fiscal 2025 Form 10-K, filed March 14, 2025.
Target's fiscal 2024 ended February 1, 2025, with opening balances at February 3, 2024. Its figures come from Target's 2024 consolidated financial statements.
These are dated historical observations selected to demonstrate a reproducible method. They are consolidated company figures, not a US-only operating dataset, a current industry average or a representative sample of all retailers. Their fiscal calendars also differ; no calendar adjustment is applied.
| Input or step (USD millions unless stated) | Walmart FY2025 | Target FY2024 |
|---|---|---|
| Annual reported cost of sales | 511,753 | 76,502 |
| Opening reported accounts payable | 56,812 | 12,098 |
| Closing reported accounts payable | 58,666 | 13,053 |
| Sum of opening and closing payables | 115,478 | 25,151 |
| Average payables: sum / 2 | 57,739 | 12,575.5 |
| Cost-of-sales proxy turnover | 8.86 times | 6.08 times |
Walmart's average is (56,812 + 58,666) / 2 = 57,739, giving 511,753 / 57,739 = 8.86 times. Target's average is (12,098 + 13,053) / 2 = 12,575.5, giving 76,502 / 12,575.5 = 6.08 times. Calculate with unrounded inputs and show ratios to two decimal places.
The reconstruction check is straightforward: each unrounded ratio multiplied by its average payables must equal the reported annual cost of sales. Both balance endpoints must tie to the cited balance sheet, while the numerator must tie to the income statement for the matching year.
The shared reported-cost-of-sales basis and endpoint average make the arithmetic consistent. They do not fully normalize economic scope. Review each company's cost classifications and business mix before using the difference to set a target. This table does not claim to reveal either company's actual invoice payment behavior.
Even this small, deliberately limited peer set produces different summaries. Keep the following separate from any claim about a retail industry norm.
| Summary calculation from the two rows above | Amount (USD millions) | Turnover (times) |
|---|---|---|
| Equal-company mean of unrounded turnover ratios | — | 7.47 |
| Combined cost of sales: 511,753 + 76,502 | 588,255 | — |
| Combined average payables: 57,739 + 12,575.5 | 70,314.5 | — |
| Combined costs / combined average payables | — | 8.37 |
The equal-company mean gives each retailer the same influence. The combined ratio is 588,255 / 70,314.5 = 8.37 times, rounded to two decimals, and gives more influence to the company with more average payables. The guide to count and value weighting explains why ratio summaries need an explicit weighting choice.
For a larger peer set, retain exclusions and the number of usable observations. A median can reduce the influence of extreme ratios, but it cannot fix mismatched numerators, hidden financing balances or an inappropriate industry group.
Finance should own the calculation policy and reconcile the AP control account. Procurement should confirm supplier terms, purchase categories and the effect of negotiated discounts. The AP team should distinguish current balances from disputed or overdue invoices.
Build the comparison file with company or supplier, reporting period, cost basis, opening payables, closing payables, averaging method and source. Add a separate explanation field for acquisitions, seasonal purchases and classification adjustments. Preserve the original disclosed inputs alongside any adjusted figures.
If your own business is seasonal, inspect monthly balances before relying on endpoints. You can calculate a more representative internal ratio from frequent snapshots, but do not place it beside a peer's endpoint average as though the methods were identical. Maintain an endpoint version for the peer screen and a separately labeled operational version for management.
Interpret a gap as a question. Higher proxy turnover may reflect faster payment, different inventory movements or a different cost mix. Lower turnover may reflect longer agreed terms, purchases concentrated near year-end or overdue invoices. Only the invoice and purchase detail can separate those explanations.
Use accounts receivable turnover by industry when investigating customer credit cycles. It measures a different side of cash conversion and should not be substituted for the supplier comparison.
Bring your purchase export, payable balances and documented peer inputs in a file or Google Sheet; Covirage maps the columns, and its tools compute and check the comparison while the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.
See Covirage for finance teams for the supporting finance context.
No. Supplier terms, purchase mix and the timing of invoices change what is reasonable. Compare a consistently calculated ratio with documented peers, then review overdue balances and available discounts before deciding whether a change would help.
It can support a clearly labeled public-report comparison when credit purchases are unavailable. It does not measure the same thing: inventory changes, labor and other costs can separate cost of sales from supplier credit purchases.
State the method. A simple company average gives every company equal influence. Combined costs divided by combined average payables weights the company ratios by average payables, so large companies can dominate the reported result.