Accounts Payable Turnover Calculator
Work out how many times a business pays off its supplier balances in a period, plus the equivalent days payable outstanding. Useful for cash-flow analysis, vendor relations, and lender ratio checks.
AP turnover ratio
6.67
- Average accounts payable
- £600,000.00
- Days payable outstanding (DPO)
- 54.75
- Interpretation
- Moderate — typical mid-range
AP turnover divides total credit purchases by the average accounts-payable balance across the period. The result is the number of times the business cleared its payables. Days Payable Outstanding (DPO) restates the same idea as a payment cycle in days: days-in-period ÷ turnover. A ratio of 6 means the business turned over payables six times — paying suppliers roughly every 61 days on a 365-day year. Compare against the industry benchmark; manufacturing typically runs 8–12, retail higher, services lower.
How to use this calculator
Enter the total value of inventory and supplier invoices bought on credit during the period — pull this from the purchasing ledger, or use Cost of Goods Sold (COGS) from the income statement as the conventional proxy when separate credit-purchase figures are not disclosed. Enter accounts payable from the start of the period (last year-end balance sheet) and the end of the period (current balance sheet). Leave the days-in-period field at 365 for a full year, or set it to 90 for a quarter, 30 for a month, and so on. The calculator returns the AP turnover ratio, days payable outstanding (DPO), and a directional read against typical industry ranges.
How the calculation works
Two formulas. Accounts Payable Turnover = Total Credit Purchases ÷ Average Accounts Payable, where Average AP = (Beginning AP + Ending AP) ÷ 2. The result is dimensionless — the number of times the business cleared its payables during the period. Days Payable Outstanding (DPO) restates the same idea on a calendar basis: Days In Period ÷ AP Turnover. A turnover of 6 on a 365-day year means roughly 61 DPO — the business is paying suppliers about every two months. The "right" ratio is industry-specific; manufacturing typically lands between 8 and 12, retail higher because of fast inventory cycles, professional services lower because of project-based billing.
Worked example
A wholesaler has $4,000,000 of credit purchases for the year. Beginning AP was $500,000, ending AP was $700,000. Average AP = ($500,000 + $700,000) ÷ 2 = $600,000. AP Turnover = $4,000,000 ÷ $600,000 = 6.67. DPO = 365 ÷ 6.67 ≈ 54.75 days. The business is paying suppliers roughly every 55 days — typical for a mid-range wholesale operation.
Frequently asked questions
What does a high AP turnover ratio mean?
A higher ratio means the business is paying its suppliers faster — payables clear more times per period. That can signal strong cash flow and disciplined vendor management, and it can earn early-payment discounts (2/10 net 30 saves around 36% APR equivalent if you take the discount). It can also mean the business is leaving free trade credit on the table. Many large corporates deliberately run a low turnover (high DPO) to use suppliers as a free working-capital line. There is no universally "good" number — interpret against the industry benchmark and the trend over time.
What does a low AP turnover ratio mean?
A lower ratio means the business is stretching payables — taking longer to pay suppliers. That can be deliberate working-capital management (preserving cash, especially common in retail and large manufacturing), or it can be a warning sign of liquidity stress. The tell is the trend: a falling ratio combined with rising days sales outstanding (DSO) and shrinking cash means the business is funding its operations by squeezing suppliers, which is unsustainable. Suppliers eventually tighten credit terms, demand cash-on-delivery, or stop shipping.
Should I use total credit purchases or COGS?
Use credit purchases if you have the figure — that is the conceptually correct numerator because AP only tracks unpaid invoices, not cash purchases. Most companies do not separately disclose credit purchases in published statements, so analysts use Cost of Goods Sold as the proxy. COGS overstates the numerator slightly because it includes labour, depreciation, and other non-payable costs, which inflates the apparent turnover. The proxy is acceptable for comparison across companies in the same industry (everyone uses the same proxy), but a company-internal analyst with access to the AP sub-ledger should always use actual credit purchases.
How is AP turnover related to days payable outstanding (DPO)?
They are the same information expressed differently. DPO = Days In Period ÷ AP Turnover, so a turnover of 12 means DPO of about 30 days, a turnover of 6 means about 61 days, a turnover of 4 means about 91 days. Investors and lenders quote both because DPO is more intuitive for cash-flow timing (you can think in terms of payment cycles) while the ratio is easier to compare across companies with different reporting calendars. The cash conversion cycle equation combines DPO with days sales outstanding (DSO) and days inventory outstanding (DIO): CCC = DIO + DSO − DPO.
What is a good AP turnover ratio by industry?
Rough benchmarks: manufacturing 8–12 (about 30–45 days DPO), wholesale 6–10, retail 10–15 (fast inventory cycles), construction 4–8 (long project cycles), professional services 4–6 (project billing), large public companies often run below 5 (deliberate working-capital optimisation — Apple and Walmart both have DPO over 100 days). Always compare against direct peers in the same industry and look at the trend over time; a number is only meaningful in context. The Risk Management Association (RMA) Annual Statement Studies and CSIMarket publish detailed industry comps if you need a precise benchmark.
Can a small business calculate AP turnover from QuickBooks or Xero?
Yes. In QuickBooks Online, run the Profit & Loss for the period to get COGS, then run the Balance Sheet at the start and end of the period to get the Accounts Payable figures. In Xero, the same numbers live in the same standard reports. Plug all three into this calculator. For a more accurate result, run a Vendor Detail report instead and sum the credit-side debits to get true credit purchases — that excludes the non-payable components baked into COGS. Most small businesses calculate this quarterly to track vendor relationships and cash-flow timing.