What Is Accounts Payable Turnover?
Accounts payable turnover measures how many times a company pays off its average accounts payable during a period. It compares purchases, usually approximated by the cost of goods sold, to the average payables balance, showing how quickly the business settles with suppliers. A high turnover means the company pays suppliers quickly; a low turnover means it takes longer, holding onto cash. As with days payable outstanding, neither extreme is automatically good: it reflects how the company balances cash conservation against supplier relationships.
How to Calculate Accounts Payable Turnover
Accounts Payable Turnover = Cost of Goods Sold / Average Accounts Payable
Worked example:
- Cost of goods sold: $6,000,000
- Average accounts payable: $500,000
- AP turnover: 6,000,000 / 500,000 = 12
The company pays off its payables about twelve times a year.
AP Turnover in Power BI (DAX)
Replace the measures with the ones in your model; purchases are often approximated by the cost of goods sold:
Average AP = DIVIDE ( [Beginning AP] + [Ending AP], 2 )
AP Turnover = DIVIDE ( [Total COGS], [Average AP] )AP Turnover and Days Payable Outstanding
Accounts payable turnover and days payable outstanding are two views of the same behavior. Turnover counts how many times payables are paid off in a period; days payable outstanding converts that into the average days taken to pay, roughly 365 divided by turnover. A turnover of 12 corresponds to a DPO of about 30 days.
What Is a Good AP Turnover?
There is no single right level. A higher turnover means paying suppliers quickly, which can earn early-payment discounts and goodwill but uses cash sooner. A lower turnover conserves cash but can strain supplier relationships if stretched too far. The healthy level balances the two, and a sudden change in either direction is worth understanding.
Reporting AP Turnover From Your ERP Data
AP turnover depends on payables and cost of goods sold drawn consistently from the ERP, which is harder across entities. A governed data foundation brings payables and cost data onto one model so turnover is consistent and traceable. QuickLaunch ships pre-built models for JD Edwards, Vista, NetSuite, and OneStream that surface payables data for cash and working-capital reporting.
Frequently Asked Questions
How is accounts payable turnover calculated?
Divide the cost of goods sold (a common proxy for purchases) by average accounts payable. A company with $6M in COGS and $500K average payables has an AP turnover of about 12.
What is the difference between AP turnover and DPO?
They describe the same behavior from opposite directions. AP turnover counts how many times payables are paid off in a period; days payable outstanding converts that into the average days taken to pay, roughly 365 divided by turnover.
Is a higher accounts payable turnover better?
Not automatically. A higher turnover means paying suppliers quickly, earning discounts and goodwill but using cash sooner. A lower turnover conserves cash but can strain suppliers if stretched too far. The healthy level balances the two.
