Accounts Payable Turnover Calculator

Accounts payable turnover counts how many times a business clears its supplier balance over a period. It is total supplier purchases divided by the average payables balance, and its inverse, scaled to a year, is Days Payable Outstanding: the average gap between a purchase being made and being paid for. The calculator returns both, since the ratio is the easier figure to compare across businesses and the day count is the easier one to compare against a payment term.

The loaded figures show how they connect. Purchases of 6M against average payables of 500k give a turnover of 12.00 and a DPO of 30.4 days, which sits a fraction past standard net-30 terms rather than exactly on them. Raise average payables to 1.5M on the same purchases and turnover falls to 4.00 with a DPO of 91.3 days. Between those, 750k of payables gives 8.00 and 45.6 days, and 1M gives 6.00 and 60.8 days. The relationship is not linear in the ratio: each step down in turnover buys progressively more days.

What the ratio cannot tell you is whether a long DPO was agreed or taken. A business paying at 91 days under contractual net-90 terms and one paying at 91 days on net-30 terms produce an identical figure here, and they describe opposite situations: one has negotiated working capital, the other is in arrears with suppliers who know it. The comparison that resolves it is the DPO against the terms actually agreed, not against a generic band. Sector norms differ widely too, and payables sit at very different levels relative to revenue across industries.

Quick example

Purchases of 6,000,000 against average payables of 500,000 give a turnover ratio of 12.00 and Days Payable Outstanding of 30.4 days. The tool also bands the day count on fixed cut-offs at 30, 60 and 90 days.

Those cut-offs are scale markers on the day count rather than a judgement about the business. A DPO of 91.3 days falls in the last band whether it reflects agreed net-90 terms or a business three weeks behind on net-30, and the ratio alone does not distinguish them. The useful comparison is arithmetic: the turnover that corresponds to a given payment term is 365 divided by that term, so net-30 terms correspond to a turnover of 12.17, net-60 to 6.08, and net-90 to 4.06. Measuring against the figure for the terms actually in force says more than any band.

Which inputs matter most

Both inputs move the result, in opposite directions and by roughly equal amounts. Purchases scale it directly, so 1% more purchases takes turnover from 12.00 to 12.12. Average payables sit in the denominator, so 1% more payables takes it to 11.88. The day count moves inversely to the ratio in both cases.

The asymmetry appears in the days rather than in the ratio. Going from a turnover of 12 to 6 halves the ratio and adds about 30 days, but going from 6 to 4 is a smaller drop in the ratio and still adds another 30 days. That is why the ratio compresses at the slow end and why DPO is usually the figure quoted in discussions about payment terms, while the ratio is the one quoted in ratio analysis alongside receivables and inventory turnover.

What's happening under the hood

Turnover is purchases divided by average payables. Days Payable Outstanding is 365 divided by turnover. Average payables is normally the opening and closing balances halved, which is what makes the figure representative of the period rather than of one balance sheet date.

Two definitional points affect comparability. The numerator should be purchases on credit from suppliers, which is what the input asks for; where a business substitutes cost of goods sold, the ratio shifts because COGS excludes purchases that went into inventory rather than into sales. And the average is only as representative as the two dates behind it, so a seasonal business whose year-end falls at a low point in the cycle will report a higher turnover than its actual payment behaviour supports.