AP turnover calculator
- Average accounts payable
- $1,200,000
- AP turnover
- 7.50 times
- Average days to pay
- 48.7 days
Formula: AP turnover = purchases on credit / ((opening AP + closing AP) / 2); days to pay = 365 / AP turnover
Example
- Purchases on credit for the year ($)
- $9,000,000
- Opening accounts payable ($)
- $1,100,000
- Closing accounts payable ($)
- $1,300,000
- Average accounts payable
- $1,200,000
- AP turnover
- 7.50 times
- Average days to pay
- 48.7 days
What the calculator works out
The calculator takes three inputs: purchases on credit for the year, opening accounts payable and closing accounts payable. It averages the two AP balances, divides purchases on credit by that average, and reports AP turnover. It then divides 365 by the turnover rate to show average days to pay. The formula is AP turnover = purchases on credit / ((opening AP + closing AP) / 2); days to pay = 365 / AP turnover.
Purchases on credit are the value of invoices and other supplier obligations you incurred on payment terms during the period, not cash paid. Find them in the purchase ledger or AP subledger for the period, or in a purchases report from your ERP. If purchases are not reported separately, cost of goods sold is often used as a practical substitute; if you do that, use it consistently from period to period so the ratio stays comparable.
Opening accounts payable is the AP balance at the start of the period, normally the prior period close from the balance sheet or the AP subledger total. Closing accounts payable is the same balance at the end of the period. Pull both from the same source and the same scope: trade payables only, not accrued expenses, taxes or other liabilities that happen to sit near AP on the balance sheet.
A worked example
Take a year in which purchases on credit are $9,000,000. Opening accounts payable is $1,100,000 and closing accounts payable is $1,300,000. The calculator reports average accounts payable of $1,200,000, AP turnover of 7.50 times and average days to pay of 48.7 days.
The $9,000,000 typically comes from a purchases on credit report for the year, not from the cash disbursements report. The opening and closing balances come from the AP subledger or the balance sheet at the prior and current close. If your ERP reports purchases and AP in different modules, tie the two reports to the same period and entity before entering them.
In this example, the average AP balance is the midpoint between the opening and closing balances, and the turnover rate expresses how many times that average balance was paid off during the year. The days-to-pay result converts that rate into a timeline. Do not add other adjustments to the three inputs unless you also restate the comparison periods on the same basis.
Reading the result
AP turnover is a pace measure. A higher turnover means suppliers are paid faster; a lower turnover means payables remain open longer. Neither result is good or bad by itself. Faster payment can support early-payment discounts and supplier relationships, while slower payment can preserve cash but may strain terms.
Compare the days-to-pay result with the terms recorded on the vendor record. If the result is longer than your terms, invoices are being paid after terms; if it is shorter, they are being paid early. A single blended result hides vendor-level differences, so review the largest vendors separately when the average looks out of line.
Seasonal businesses should compare the same periods year on year. A peak buying season can raise purchases on credit and closing AP at the same time, which changes the ratio without any change in payment discipline. A trailing twelve-month view or a same-month comparison is more informative than a single peak month.
If you are weighing early payment to capture a discount, compare the discount rate with your own cost of funds. That comparison is a financing decision, not a conclusion the calculator makes for you.
Where the inputs go wrong
The most common error is using total purchases instead of purchases on credit. Cash purchases, expense reimbursements and intercompany charges inflate the numerator and make turnover look higher than the AP process warrants. Pull the purchases figure from the same ledger and period as the AP balances, and check whether the report includes cash transactions or only credit transactions.
A second error is mixing scopes. Closing AP may include accrued expenses, goods received not invoiced, retainage or unapplied vendor credits that are not pure trade payables. If closing AP includes a large one-time invoice or excludes a credit, the average is skewed. Reconcile the AP subledger to the general ledger at both opening and closing, and review manual journals that hit AP.
Timing and cut-off create false movement. A close that cuts off invoices early or late changes closing AP without changing the underlying payment pattern. The same applies when a large payment run falls just before or after period end. Use a consistent cut-off rule and compare the same period year on year.
Currency and vendor master issues also distort the result. Foreign currency balances should be translated on a consistent basis at both opening and closing. Duplicate vendor records and unapplied credits can make the AP balance look larger or smaller than the real obligation. Clean the vendor master and apply credits before pulling the balances.
Questions
What is a good AP turnover ratio?
There is no universal good number. A higher ratio means you pay suppliers faster, but the right level depends on your vendor terms, cash position and whether you are capturing early-payment discounts. Compare your result with your own prior periods and with the terms on the vendor record rather than a generic benchmark.
How do I calculate average days to pay from AP turnover?
Divide 365 by the AP turnover rate. With an AP turnover of 7.50 times, average days to pay is 48.7 days. Use the same period length and scope as the turnover calculation.
Can I use cost of goods sold instead of purchases on credit?
Yes, cost of goods sold is often used when purchases are not reported separately. Apply it consistently across periods and note the substitution, because cost of goods sold includes items that may not flow through AP in the same period. The ratio remains useful for trend comparison even when the numerator is not pure credit purchases.
Why is my AP turnover higher than last year?
Check whether purchases on credit now include cash purchases or whether closing AP fell because of a large payment run, a cut-off change or a vendor credit. A higher ratio can also reflect genuinely faster payment terms. Reconcile the subledger to the general ledger and compare the same period year on year before drawing a conclusion.
Updated Nov 8, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.