Trade Payables Turnover Ratio: Formula and Missing Figures

A pottery shop receives a delivery on Monday and pays the supplier a month later. During that month, the pots are already on its shelves, but the purchase bill is still unpaid.

That small gap between receiving goods and paying for them is the starting point for trade payables turnover ratio. Supplier credit gives a business time to sell goods before it has to part with cash. The ratio helps us examine the pace of that payment cycle.

The division is usually easy. The real work is choosing the right purchases figure and the right unpaid balance. Does cash buying belong? What happens to bills payable? How do you find opening creditors when only the closing balance is given?

Let’s work through those questions slowly, with examples you can check for yourself. All amounts and businesses in this lesson are invented for practice. Ignore taxes unless a question specifically introduces them.

Trade payables turnover ratio formula

Trade payables turnover ratio = Net credit purchases / Average trade payables.

It is an activity ratio, also called the creditors turnover ratio or accounts payable turnover ratio, and its answer is expressed in times.

For a question with opening and closing balances:

Opening payables =
Opening trade creditors
+ Opening trade bills payable

Closing payables =
Closing trade creditors
+ Closing trade bills payable

Average payables =
(Opening payables + Closing payables) / 2

These are the relationships used in NCERT’s Accounting Ratios chapter, section 5.8.3.

Suppose annual net credit purchases are Rs 9,80,000 and average trade payables are Rs 1,96,000. The ratio is 5 times because the year’s credit purchases are five times the average unpaid supplier balance.

It does not mean that the business wrote exactly five cheques or bought goods on only five occasions. Hundreds of invoices and payments could lie behind those totals.

How to calculate net credit purchases

Start by reading the label on the purchases figure. Total purchases, credit purchases, and net credit purchases are three different starting points.

If total purchases are before returns, and all stated returns relate to credit purchases:

Gross credit purchases =
Total purchases - Cash purchases

Net credit purchases =
Gross credit purchases
- Credit purchase returns

The worked approach in NIOS Accounting Ratios I, Illustration 11 separates cash buying and purchase returns before calculating turnover.

Imagine these figures for Clay Corner:

Purchase information	Amount
Total goods purchases before returns	Rs 12,60,000
Cash purchases, with no cash returns	Rs 2,40,000
Returns to credit suppliers	Rs 40,000

The shop bought Rs 10,20,000 on credit: Rs 12,60,000 less Rs 2,40,000. Returning Rs 40,000 of those goods leaves net credit purchases of Rs 9,80,000.

When returns have already been deducted

Suppose a different question says net purchases are Rs 12,20,000 and net cash purchases are Rs 2,40,000. Then net credit purchases are simply Rs 9,80,000. Deducting returns again would understate the numerator.

If returns include goods originally bought for cash, separate the cash returns from the credit returns. Only the credit portion reduces gross credit purchases.

For example, gross credit purchases of Rs 5,00,000 and total returns of Rs 30,000, including Rs 8,000 of cash-purchase returns, give:

Credit purchase returns = 30,000 - 8,000
                        = Rs 22,000

Net credit purchases = 5,00,000 - 22,000
                     = Rs 4,78,000

Cash purchases are not cash paid to creditors

A cash purchase is paid for when it is made. Paying an old supplier invoice today settles a purchase that originally happened on credit.

If Clay Corner buys pots worth Rs 20,000 in April and pays in May, April contains a credit purchase. The May payment does not change that purchase into a cash purchase. Subtracting payments to creditors from total purchases would mix two different events.

Watch the percentage base

Consider total purchases of Rs 12,00,000, with no returns.

Case A: Cash purchases are 25% of total purchases. Cash purchases are Rs 3,00,000, so credit purchases are Rs 9,00,000.

Case B: Cash purchases are 25% of credit purchases. Let credit purchases be C. Total purchases are C + 0.25C, or 1.25C. Therefore:

C = 12,00,000 / 1.25
  = Rs 9,60,000

Cash purchases = Rs 2,40,000

The same percentage produces different answers because it is applied to a different base. Underline the words after “of” before calculating.

Which balances belong in average trade payables?

For the goods-purchase questions here, include trade creditors and bills payable arising from those goods purchases. Keep the purchases and payables on a consistent basis.

Item in the question	Treatment in these examples
Amount owed for goods bought for resale	Include
Bill accepted for those goods	Include
Bank overdraft or bank loan	Exclude
Outstanding employee salaries or income tax	Exclude
Amount owed for equipment used by the shop	Exclude
Bills receivable from customers	Exclude

Do not replace trade payables with total current liabilities. Nor should you add bills payable a second time if the question explicitly says they are already included in the trade payables total.

There is a useful distinction between these exercises and reading a company’s full accounts. Payables for services received in the ordinary course of business can also be trade payables. An ICAI Expert Advisory Committee opinion on service-related payables explains that classification depends on the business and the nature of the expense. “Trade” does not always mean only goods bought for resale. Here, the examples deliberately use a goods-purchase basis so the numerator and denominator remain comparable.

Why accepting a bill does not remove the obligation

Suppose Rs 30,000 owed to a pottery supplier is converted into a bill payable. The supplier’s personal account decreases by Rs 30,000, while Bills Payable increases by Rs 30,000.

The total of creditors plus bills payable is unchanged. The promise now has a different form, but the shop still owes Rs 30,000. This is why leaving out bills payable can make turnover look faster than it is.

Solved example 1: The full ratio and payment period

Return to Clay Corner’s net credit purchases of Rs 9,80,000. Its balances are:

Balance	Opening	Closing
Trade creditors	Rs 1,40,000	Rs 1,80,000
Trade bills payable	Rs 30,000	Rs 42,000
Total trade payables	Rs 1,70,000	Rs 2,22,000

First average the two dates:

Average payables =
(1,70,000 + 2,22,000) / 2
= Rs 1,96,000

Turnover = 9,80,000 / 1,96,000
         = 5 times

There are four component amounts in the table, but only two dates. Dividing their total by 4 would incorrectly average the components instead of the opening and closing totals.

For a full year, using 365 days:

Average payment period = 365 / Turnover
                       = 365 / 5
                       = 73 days

The interpretation is that the figures imply an average supplier-payment period of 73 days. It is an estimate from aggregate balances, not a record of how long each individual invoice remained unpaid.

If the question specifies a 360-day year, the answer is 360 / 5 = 72 days. If it asks for months, 12 / 5 = 2.4 months. Keep the period convention consistent throughout the answer.

Why turnover and payment days move in opposite directions

Using 365 days, turnover of 5 times gives 73 days. Turnover of 10 times gives 36.5 days. The higher turnover corresponds to a shorter estimated payment period.

For a six-month question, use the number of days stated for those six months with the six-month purchases. For example, Rs 3,60,000 of net credit purchases, Rs 60,000 average payables, and a stated 180-day period give turnover of 6 times during that period, and payment days of 180 / 6 = 30 days. Using 365 with that unannualised turnover would mix periods.

Solved example 2: Recover purchases from sales and stock

Sometimes the question gives sales, gross profit, and inventory instead of purchases. Build a short trading calculation before touching the turnover formula.

Suppose Riverbank Traders provides:

Information	Amount or condition
Net sales	Rs 18,00,000
Gross profit	25% of cost of goods sold
Opening inventory	Rs 1,80,000
Closing inventory	Rs 2,40,000
Direct expenses included in cost of goods sold	Rs 60,000
Net cash purchases	Rs 2,40,000
Average trade payables	Rs 1,50,000

Assume there are no other stock adjustments. The separately stated direct expenses are paid in cash, and the trade payables relate to goods purchases.

Step 1: Find cost of goods sold

Gross profit is 25% of cost, so selling price is 125% of cost:

Cost of goods sold = 18,00,000 x 100 / 125
                   = Rs 14,40,000

Do not take 25% off sales here. That would apply a profit margin on sales, whereas the question gives a markup on cost.

Step 2: Reconstruct net purchases

For this trader:

Cost of goods sold = Opening inventory
                    + Net purchases
                    + Direct expenses
                    - Closing inventory

Moving the other items across gives:

Net purchases = 14,40,000 + 2,40,000
                - 1,80,000 - 60,000
              = Rs 14,40,000

Notice the direction of each adjustment. Closing stock is added back because those goods were purchased but are not included in the cost of goods sold. Opening stock is deducted because it was already available before this year’s purchases.

The Rs 60,000 of direct expenses must also be removed to isolate goods purchases. For more practice with this part, see adjusted purchases and cost of goods sold.

Step 3: Remove net cash purchases

Net credit purchases = 14,40,000 - 2,40,000
                     = Rs 12,00,000

Turnover = 12,00,000 / 1,50,000
         = 8 times

Payment period = 365 / 8
               = 45.625 days
               = About 45.6 days

Purchases and cost of goods sold happen to be equal in this example because the inventory increase exactly offsets the direct expenses. That is a result of these numbers, not a general rule.

Professional analysis sometimes uses cost of sales when credit purchases cannot be obtained, as ACCA’s performance appraisal guidance explains. Treat that as an approximation. If the question gives enough information to calculate credit purchases, calculate them.

Solved example 3: Find opening trade payables

Annual net credit purchases are Rs 14,40,000, turnover is 8 times, and closing trade payables are Rs 2,20,000. Find opening trade payables.

The ratio first gives the average:

Average payables = 14,40,000 / 8
                 = Rs 1,80,000

Let opening payables be O:

(O + 2,20,000) / 2 = 1,80,000

O + 2,20,000 = 3,60,000

O = Rs 1,40,000

Check: Rs 1,40,000 and Rs 2,20,000 average to Rs 1,80,000. Dividing purchases by that average reproduces the given 8 times.

The shortcut is opening balance = twice the average minus closing balance. Keep the word “average” visible in your working so you do not accidentally treat Rs 1,80,000 as an opening figure.

Solved example 4: Find closing bills payable

Suppose net credit purchases are Rs 12,60,000 and turnover is 7 times. Opening trade payables total Rs 1,60,000. Closing trade creditors, excluding bills, are Rs 1,55,000. Find closing trade bills payable.

Average payables = 12,60,000 / 7
                 = Rs 1,80,000

Closing total = 2 x 1,80,000 - 1,60,000
              = Rs 2,00,000

Closing bills payable =
2,00,000 - 1,55,000
= Rs 45,000

This question has two layers. Find the closing total first, then remove the known creditors component. Jumping directly from the average to bills payable skips a necessary step.

Solved example 5: Find credit purchases from creditors’ records

This is a slightly longer question, but the logic is reassuring: what was owed at the start, plus new credit buying, must explain what was settled and what remains owed.

Assume all balances below relate to goods suppliers. There are no dishonoured bills, endorsed bills, interest charges, or other adjustments. Discount received is recorded separately as income under the convention used in this exercise.

Information	Amount
Opening trade creditors, excluding bills	Rs 90,000
Closing trade creditors, excluding bills	Rs 1,10,000
Opening trade bills payable	Rs 20,000
Closing trade bills payable	Rs 30,000
Cash paid directly to trade creditors	Rs 6,75,000
Cash paid to honour trade bills	Rs 1,60,000
Discount received from creditors	Rs 10,000
Returns to credit suppliers	Rs 20,000

Step 1: Work out bills accepted during the year

Bills accepted = Bills paid + Closing bills
                 - Opening bills

               = 1,60,000 + 30,000 - 20,000
               = Rs 1,70,000

Accepting those bills transfers Rs 1,70,000 out of the creditors’ personal balances into Bills Payable.

Step 2: Balance the trade creditors account

The following compact reconciliation represents that account. A plus sign increases the amount owed in creditors; a minus sign reduces it.

Movement	Amount
Opening creditors	Rs 90,000
Add: gross credit purchases, to be found	?
Less: cash paid directly to creditors	Rs 6,75,000
Less: bills accepted	Rs 1,70,000
Less: discount received	Rs 10,000
Less: purchase returns	Rs 20,000
Equals: closing creditors	Rs 1,10,000

Therefore:

Gross credit purchases =
1,10,000 + 6,75,000 + 1,70,000
+ 10,000 + 20,000 - 90,000
= Rs 8,95,000

Net credit purchases = 8,95,000 - 20,000
                     = Rs 8,75,000

The separate creditors and bills payable accounts in the University of Calicut’s Financial Accounting study material, printed page 14 show the underlying account structure.

Why does discount appear in the reconstruction? It settled part of the creditor balance without a cash payment. Adding it back helps recover the original purchases. Under the stated convention, it is not then deducted as a purchase return in the turnover numerator.

Step 3: Calculate the ratio

Opening total = 90,000 + 20,000
              = Rs 1,10,000

Closing total = 1,10,000 + 30,000
              = Rs 1,40,000

Average payables =
(1,10,000 + 1,40,000) / 2
= Rs 1,25,000

Turnover = 8,75,000 / 1,25,000
         = 7 times

Payment period = 365 / 7
               = About 52.1 days

A second check using the combined obligation

Total cash paid to settle supplier obligations is Rs 6,75,000 + Rs 1,60,000 = Rs 8,35,000. Start with combined opening payables and trace the year:

Opening total + Gross credit purchases
- Cash settlements - Discount - Returns

= 1,10,000 + 8,95,000 - 8,35,000
  - 10,000 - 20,000
= Rs 1,40,000 closing total

Bills accepted do not appear in this combined check because they only move an obligation between two included accounts. Bills paid do appear because payment reduces the combined amount owed. Keeping those two actions separate is the key to this question.

What if information is missing?

Only a closing payables balance is supplied: in a standard school exercise with no way to find the opening figure, use the closing total as the available substitute. Do not divide it by 2. Both NCERT’s Illustration 17 and NIOS’s Illustration 12 demonstrate this convention.

Purchases are given without a cash-credit split: follow the question’s instructions. The usual elementary assumption is to treat the stated net purchases as credit purchases when there is no contrary information. State that assumption briefly. It is a solving convention, not proof that a real business bought everything on credit.

An opening balance is explicitly nil: zero is information. Average zero and the closing balance normally. A missing balance and a known zero balance are different situations.

The denominator is zero: do not report an ordinary finite turnover or automatically write zero payment days. Check whether there was no supplier credit, whether the two dates miss activity within the year, or whether information is incomplete.

Is a higher trade payables turnover ratio better?

A higher ratio implies a shorter payment period on a comparable basis. Whether that is desirable depends on credit terms, discounts, cash availability, and supplier relationships. Longer payment can preserve cash, but overdue balances can also signal difficulty. These competing explanations are discussed in the Open University’s payables payment period lesson.

Try this original comparison. Each shop has annual net credit purchases of Rs 18,00,000. Use a 360-day year.

Measure	Shop A	Shop B
Average trade payables	Rs 1,50,000	Rs 3,00,000
Turnover	12 times	6 times
Estimated payment period	30 days	60 days

Shop A pays faster on this measure. But suppose A’s suppliers allow 30 days and B has negotiated 60 days. Both appear consistent with their agreed terms. Calling B inefficient just because its turnover is lower would miss the context.

Now change one fact: B’s suppliers allow only 30 days. Its estimated 60-day period becomes a reason to investigate overdue invoices or cash pressure. The number is unchanged; the interpretation changes with the evidence.

A useful written answer is: “The ratio fell from 12 times to 6 times, increasing estimated payment days from 30 to 60 on a 360-day basis. This may reflect longer negotiated credit or slower settlement. Compare the result with supplier terms before judging payment performance.”

Quick practice: Eight questions with answers

Try the questions first, then use the workings to locate any mistake.

1. Remove cash purchases and returns

Total purchases before returns are Rs 6,00,000, cash purchases are Rs 1,00,000, and returns to credit suppliers are Rs 20,000. Average trade payables are Rs 80,000. Find turnover.

Answer: Net credit purchases = Rs 6,00,000 - Rs 1,00,000 - Rs 20,000 = Rs 4,80,000. Turnover = Rs 4,80,000 / Rs 80,000 = 6 times.

2. Include both components at both dates

Net credit purchases are Rs 9,00,000. Opening creditors and bills payable are Rs 90,000 and Rs 10,000. Closing creditors and bills payable are Rs 1,10,000 and Rs 30,000.

Answer: Opening total = Rs 1,00,000; closing total = Rs 1,40,000. Average = Rs 1,20,000. Turnover = 7.5 times.

3. Find the closing balance

Net credit purchases are Rs 15,00,000, turnover is 10 times, and opening trade payables are Rs 1,20,000.

Answer: Average payables = Rs 1,50,000. Closing payables = 2 x Rs 1,50,000 - Rs 1,20,000 = Rs 1,80,000.

4. Read the percentage base

Total purchases are Rs 5,00,000. Cash purchases are one-quarter of credit purchases. There are no returns. Find credit purchases.

Answer: Total purchases are 1.25 times credit purchases. Credit purchases = Rs 5,00,000 / 1.25 = Rs 4,00,000.

5. Work backwards from payment days

The payment period is 45 days on a 360-day basis. Average trade payables are Rs 75,000. Find annual net credit purchases.

Answer: Turnover = 360 / 45 = 8 times. Purchases = 8 x Rs 75,000 = Rs 6,00,000.

6. Avoid deducting returns twice

Net purchases are Rs 8,40,000, including net cash purchases of Rs 1,40,000. Purchase returns of Rs 30,000 have already been deducted. Average payables are Rs 1,00,000.

Answer: Net credit purchases = Rs 7,00,000. Turnover = 7 times. The Rs 30,000 needs no further adjustment.

7. Use a single available balance correctly

Net credit purchases are Rs 7,20,000. Only closing balances are supplied: creditors Rs 80,000 and bills payable Rs 40,000. Use those balances as the substitute for average payables.

Answer: Denominator = Rs 1,20,000, without halving it. Turnover = 6 times.

8. Distinguish acceptance from payment

A business converts Rs 25,000 of trade creditors into bills payable. What is the immediate change in combined trade payables?

Answer: No change. Creditors decrease by Rs 25,000 and bills payable increase by Rs 25,000. There is no new purchase or cash settlement in this conversion.

A final check before you submit

Read your calculation from top to bottom once. The numerator should represent the correct credit purchases for the period. The denominator should contain matching trade obligations, averaged across the dates available. The final turnover needs “times”, while the payment period needs “days” or “months”.

Keep unrounded working figures until the last step. If you recovered a missing balance, put it back into the original formula. That one substitution often catches an error faster than repeating the whole solution.

Sources for further reading

• NCERT, Accountancy: Company Accounts and Analysis of Financial Statements, 2026-27 reprint: Accounting Ratios, section 5.8.3 and Illustrations 16-17, for the main formula and school-question conventions.
• NIOS, Accountancy Lesson 28: Accounting Ratios I, printed pages 33-36, for cash purchases, returns, bills payable, and payment periods.
• University of Calicut, School of Distance Education: Financial Accounting, 2019 admission study material, printed page 14, for creditors and bills payable account structures.
• ICAI, Expert Advisory Committee: Opinion finalised 7 November 2014 on classification of service-related payables, for the distinction between a goods-purchase exercise and broader trade payable classification.
• ACCA: How to approach performance appraisal questions, for formula approximations and interpretation.
• The Open University, OpenLearn: Payables payment period, for payment terms, cash use, and the limits of a simple high-or-low judgement.

Frequently asked questions

What is the formula for trade payables turnover ratio?

Divide net credit purchases by average trade payables. Where opening and closing figures are available, add the two trade payables totals and divide by 2 to obtain the average.

Is creditors turnover the same as trade payables turnover?

Yes, the names commonly describe the same ratio in these questions. Check the components: the payable balance should include relevant trade bills payable as well as trade creditors.

Why are cash purchases excluded?

Cash purchases do not create unpaid supplier credit. The ratio compares purchases made on credit with the corresponding outstanding obligations.

Should bills payable be added to creditors?

Add bills arising from the relevant trade purchases when they are supplied separately. If the given trade payables figure already includes them, do not add them again.

Do I deduct purchase returns?

Deduct returns relating to credit purchases from gross credit purchases. If the amount is already net of returns, leave it unchanged. Separate returns of cash purchases if the question identifies them.

What should I do when opening creditors are missing?

First check whether the opening amount can be recovered from other information. If not, and the question uses the standard closing-balance convention, use closing trade payables without dividing by 2. State the basis.

How do I find the average payment period?

Divide the number of days in the relevant period by its turnover ratio. For annual data, use 365 days unless the question specifies another basis, such as 360 days.

Does a higher turnover ratio always mean better performance?

No. It implies faster settlement on the measure used, but you still need supplier terms and the reason for early payment. A shop using agreed longer credit can have a lower ratio without paying late.

Can I use sales instead of credit purchases?

No. Sales relate to the customer side of the business. In this ratio, identify credit purchases; do not substitute sales merely because the sales figure is available.

Can cost of goods sold replace credit purchases?

Some financial analysis uses it as an approximation when purchase information is unavailable. In a numerical that provides inventory, purchase, or cash-credit details, first use those details to obtain the required credit purchases.

How do I calculate missing opening or closing payables?

Find average payables by dividing net credit purchases by turnover. Double that average, then subtract the known endpoint. If the missing item is only bills payable, remove the known creditors component from the endpoint total as well.

Does accepting a bill payable count as a cash payment?

No. Acceptance transfers the amount from a creditor’s account to Bills Payable. The combined obligation remains until it is settled. Keep bills accepted separate from bills actually paid when reconstructing purchases.