KKPI Formulas
KPI calculator

Accounts Payable Turnover Calculator

Enter your values to calculate Accounts Payable Turnover. Use the formula and examples below for Excel, Google Sheets, Power BI, and dashboards.

Affiliate resources

Ideas for You

Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.

Accounts Payable Turnover books Books that help you understand Accounts Payable Turnover and related business metrics more deeply. Explore resources → Accounts Payable Turnover audiobooks Audiobook searches for learning Accounts Payable Turnover while commuting, walking, or working. Explore resources → Accounting Excel resources Excel-focused resources for building KPI trackers and dashboard workflows. Explore resources → Financial statement analysis Practical resources for turning Accounts Payable Turnover into reports, dashboards, and business decisions. Explore resources →

Calculate Accounts Payable Turnover

Result—

Formula

Net Credit Purchases / Average Accounts Payable

Excel formula

=IFERROR(B2/C2,0)

Power BI DAX measure

Accounts Payable Turnover =
DIVIDE(
    [Net Credit Purchases],
    [Average Accounts Payable]
)

Read the complete Accounts Payable Turnover formula guide →