Should I use COGS or Credit Purchases for Accounts Payable Turnover?

Use Credit purchases if you can isolate purchases made on supplier credit (most accurate for trade payables). Use COGS when credit-purchase data isn’t available or is messy—it's a common proxy, especially for inventory-heavy businesses, but it can distort results if inventory levels change a lot.

My Accounts Payable Turnover is high—am I managing payables well or paying too fast?

High turnover usually means you’re paying suppliers quickly. That can be good for discounts and supplier trust, but it can also mean you’re giving up free financing. Compare your DPO to your vendor terms and decide if speed is intentional (discounts/priority supply) or accidental (weak AP process control).

How do I translate Accounts Payable Turnover into Days Payables Outstanding (DPO), and why can it differ from my stated payment terms?

DPO formula: DPO = Days in period / AP Turnover (equivalently: (Average AP / Expense basis) × Days).

I only have one Accounts Payable number (or my AP swings a lot). Can I still use this calculator?

Yes, but use Average A/P whenever possible (beginning + ending) because a single balance can be misleading. If AP is volatile/seasonal, calculate with a shorter period (monthly/quarterly) or use a multi-point average outside the tool and input a representative single A/P.

Accounts Payable Turnover Calculator (AP Turnover & DPO)

Accounts Payable Turnover Calculator

Calculate how often you pay suppliers using COGS or credit purchases, with clear defaults, scenarios, and an interpretive What This Means section.

Period

Custom Days

Expense basis

Turnover = Cost of Goods Sold / Average Accounts Payable.

A/P basis

(Beginning + Ending) / 2 smooths swings.

Cost of Goods Sold (COGS)

Credit purchases

Beginning A/P

Ending A/P

A/P (period end)

Results

Accounts Payable Turnover x
Approx. Days Payables Outstanding days
Average Accounts Payable $
Avg daily spend (basis) $/day
Expense basis used
Payment pace

What is Accounts Payable Turnover?

Accounts Payable Turnover measures how many times a company pays off its supplier invoices during a period.

It matters because payables are a core working-capital lever: paying too fast can drain cash, paying too slow can strain suppliers, pricing, and reliability.

Together with DSO and DIO, it influences the Cash Conversion Cycle and short-term liquidity.

Formula

Example

Assume an annual period (365 days) and Average A/P basis.

Scenario A (COGS basis):

COGS = 2,400,000; Beginning A/P = 180,000; Ending A/P = 220,000
Average A/P = (180,000 + 220,000) / 2 = 200,000
A/P Turnover = 2,400,000 / 200,000 = 12.0x
DPO = 365 / 12.0 = 30.4 days
Avg Daily Spend = 2,400,000 / 365 = 6,575.34 per day

Scenario B (Credit purchases basis):

Credit Purchases = 2,200,000; Average A/P = 200,000
A/P Turnover = 2,200,000 / 200,000 = 11.0x
DPO = 365 / 11.0 = 33.2 days
Avg Daily Spend = 2,200,000 / 365 = 6,027.40 per day

How to Use the Accounts Payable Turnover Calculator

Select your time period, choose the expense basis ([[cost-of-goods-sold-calculator|COGS]] or Credit purchases), enter your A/P balances, and the tool will calculate AP Turnover and the implied payment speed (DPO).

Set the period
- Choose the period length (e.g., Annual 365 days). This drives the days-based outputs like DPO and daily spend.
Pick the expense basis
- - Choose COGS (standard) if you’re using cost of sales as the spend proxy.
- Choose Credit purchases if you can estimate purchases made on supplier credit.
Choose the A/P basis
- - Select Average A/P (recommended) to use Beginning + Ending A/P (better accuracy).
- Select Single A/P only if you have one reliable A/P balance for the period.
Enter your inputs
- - Input COGS (or Credit purchases) for the selected period.
- Input Beginning A/P and Ending A/P (or a single A/P if you chose Single A/P).
formula (plain text):
Average A/P = (Beginning A/P + Ending A/P) / 2
Accounts Payable Turnover = Expense basis / Average A/P
DPO = Days in period / Accounts Payable Turnover
Avg daily spend = Expense basis / Days in period
Read and use the results
- - Review AP Turnover (x) and Approx. DPO (days) to understand how fast you’re paying suppliers.
- Use Expense basis used to confirm you’re measuring what you intended.
- Use Payment pace as a quick label, but base decisions on DPO vs vendor terms and cash strategy.

Frequently Asked Questions

Use Credit purchases if you can isolate purchases made on supplier credit (most accurate for trade payables). Use COGS when credit-purchase data isn’t available or is messy—it's a common proxy, especially for inventory-heavy businesses, but it can distort results if inventory levels change a lot.
High turnover usually means you’re paying suppliers quickly. That can be good for discounts and supplier trust, but it can also mean you’re giving up free financing. Compare your DPO to your vendor terms and decide if speed is intentional (discounts/priority supply) or accidental (weak AP process control).
DPO formula: DPO = Days in period / AP Turnover (equivalently: (Average AP / Expense basis) × Days).
Yes, but use Average A/P whenever possible (beginning + ending) because a single balance can be misleading. If AP is volatile/seasonal, calculate with a shorter period (monthly/quarterly) or use a multi-point average outside the tool and input a representative single A/P.

Methodology & Sources

Bibliography

S. P. Kothari (2004). Financial Statement Analysis (lec8.pdf) — 15.511 Financial Accounting (Summer 2004) — MIT OpenCourseWare, Massachusetts Institute of Technology (MIT Sloan School of Management) https://ocw.mit.edu/courses/15-511-financial-accounting-summer-2004/resources/lec8/
Accessed 2025-12-23
Peter Wysocki (2003). Class #12: “Risk Assessment” — Do Financial Statements Capture Risk? (class12.pdf) — 15.535 Business Analysis Using Financial Statements (Spring 2003) — MIT OpenCourseWare, Massachusetts Institute of Technology (MIT Sloan School of Management) https://ocw.mit.edu/courses/15-535-business-analysis-using-financial-statements-spring-2003/resources/class12/
Accessed 2025-12-23
Lisa Schwarz (2023). Accounts Payable Turnover Ratio Defined: Formula & Examples — NetSuite https://www.netsuite.com/portal/resource/articles/accounting/accounts-payable-turnover-ratio.shtml
Accessed 2025-12-23

Accounts Payable Turnover Calculator

Results

What This Means

What is Accounts Payable Turnover?

Formula

Example

How to Use the Accounts Payable Turnover Calculator

Set the period

Pick the expense basis

Choose the A/P basis

Enter your inputs

Read and use the results

Frequently Asked Questions

Methodology & Sources

Bibliography

Other Calculators in Corporate Finance & Analysis

Cost of Debt Calculator

Interest Rate Parity Calculator

Cap Table Calculator

Weighted Average Cost of Capital (WACC) Calculator

Net Operating Profit After Tax (NOPAT) Calculator

Return on Capital Employed Calculator (ROCE) Calculator