Blog

Average Trade Receivables: Gross vs Net Debtors in Ratio Analysis

Learn when to use gross debtors and net debtors while calculating average trade receivables, with formulas, solved examples, and common mistakes.

  • 12th
  • Accounts
Invoice papers passing through a fine filter between two glass vessels to show gross and net trade receivables

Average trade receivables looks like a small part of ratio analysis, but it can quietly change the whole answer.

Most students know this formula:

FormulaMeaning
Trade Receivables Turnover Ratio = Net Credit Revenue from Operations / Average Trade ReceivablesShows how quickly credit sales are collected from customers

The confusion begins when the question gives debtors, provision for doubtful debts, further bad debts, bills receivable, or net debtors.

Then the real question becomes:

Should average trade receivables be calculated using gross debtors or net debtors?

The short answer is simple.

But let us understand this carefully, because once the logic is clear, the calculation becomes much easier.

First Understand the Purpose of the Ratio

Trade receivables turnover ratio is an activity ratio. It studies the speed of collection from credit customers.

It does not mainly ask:

How much will finally appear in the Balance Sheet after provisions?

It asks:

How fast is the business converting credit sales into cash?

So the ratio connects two related figures:

NumeratorDenominator
Net credit revenue from operationsAverage trade receivables from credit customers

That is why the denominator should represent the amount due from customers because of credit sales.

Provision for doubtful debts is not a sale. It is not a customer. It is not a bill. It is an estimate of possible non-payment. So it should not be deducted while measuring the speed of collection.

Gross Debtors and Net Debtors

Let us separate the two terms.

TermSimple meaning
Gross debtorsDebtors before deducting provision for doubtful debts
Net debtorsDebtors after deducting provision for doubtful debts

Suppose the question gives:

ParticularsAmount
DebtorsRs. 1,00,000
Less: Provision for doubtful debtsRs. 5,000
Net debtorsRs. 95,000

Here, Rs. 1,00,000 is gross debtors.

Rs. 95,000 is net debtors.

For trade receivables turnover ratio, use Rs. 1,00,000, not Rs. 95,000.

This is the heart of the topic.

What Is Included in Trade Receivables?

Trade receivables usually include:

  • debtors
  • bills receivable

If the question gives both, include both.

ItemInclude in trade receivables?Reason
DebtorsYesAmount due from credit customers
Bills receivableYesWritten promise to receive money from customers
Provision for doubtful debtsNo deduction for turnover ratioIt is only an estimate
Further bad debtsDeduct firstIt is an actual reduction in debtors
Provision for discount on debtorsNo deduction for turnover ratioIt is an estimate of future discount

The phrase “trade receivables” is broader than just debtors. If bills receivable are given, they must be added.

That one question prevents most mistakes.

Formula for Average Trade Receivables

The usual formula is:

FormulaMeaning
Average Trade Receivables = (Opening Trade Receivables + Closing Trade Receivables) / 2Finds the average customer amount tied up during the year

If debtors and bills receivable are given separately, calculate opening and closing trade receivables first.

ParticularsOpeningClosing
Gross debtorsRs. …Rs. …
Add: Bills receivableRs. …Rs. …
Trade receivables for turnover ratioRs. …Rs. …

Then calculate the average:

Average Trade Receivables
= (Opening Trade Receivables + Closing Trade Receivables) / 2

If only closing trade receivables are available and no opening figure is given, use the closing figure as the available figure. Do not invent an opening balance.

Why Provision Is Not Deducted for This Ratio

Provision for doubtful debts is created because some debtors may not pay in future.

It is a cautious accounting adjustment. It helps the business avoid showing receivables at an unrealistic amount in the Balance Sheet.

But trade receivables turnover ratio has a different purpose. It measures how credit sales move into cash.

Imagine a classroom collecting notebooks.

If 100 notebooks were issued to students and the teacher thinks 5 may not come back, the collection effort is still related to 100 notebooks. The estimate of 5 doubtful notebooks helps caution, but it does not change the fact that 100 were issued.

Similarly, debtors are taken before provision while calculating the turnover ratio.

This is why using net debtors can make the ratio look better than it really is.

Gross Debtors vs Net Debtors: Where Each Is Used

Here is a clean decision table.

SituationUse gross debtors or net debtors?
Trade receivables turnover ratioGross debtors, plus bills receivable
Average collection periodSame figure used in trade receivables turnover ratio
Showing debtors in Balance SheetNet debtors after provision
Current ratio or quick ratioUsually the net amount shown as current asset
Provision for doubtful debts adjustmentCalculate provision after deducting further bad debts

So there is no single answer for every chapter.

The correct figure depends on what the question is asking.

If the question is about collection speed, use gross debtors.

If the question is about asset value after caution, use net debtors.

Solved Example 1: Provision Is Given Separately

Calculate trade receivables turnover ratio from the following information:

ParticularsAmount
Net credit revenue from operationsRs. 6,00,000
Opening debtorsRs. 70,000
Opening bills receivableRs. 10,000
Opening provision for doubtful debtsRs. 4,000
Closing debtorsRs. 1,05,000
Closing bills receivableRs. 15,000
Closing provision for doubtful debtsRs. 6,000

Step 1: Calculate Opening Trade Receivables

Use debtors before deducting provision.

ParticularsAmount
Opening debtorsRs. 70,000
Add: Opening bills receivableRs. 10,000
Opening trade receivablesRs. 80,000

Opening provision is ignored for this ratio.

Step 2: Calculate Closing Trade Receivables

ParticularsAmount
Closing debtorsRs. 1,05,000
Add: Closing bills receivableRs. 15,000
Closing trade receivablesRs. 1,20,000

Closing provision is also ignored for this ratio.

Step 3: Calculate Average Trade Receivables

Average Trade Receivables
= (Rs. 80,000 + Rs. 1,20,000) / 2
= Rs. 1,00,000

Step 4: Calculate the Ratio

Trade Receivables Turnover Ratio
= Net Credit Revenue from Operations / Average Trade Receivables
= Rs. 6,00,000 / Rs. 1,00,000
= 6 times

So the ratio is 6 times.

This means average trade receivables were collected 6 times during the year.

What If You Used Net Debtors by Mistake?

Let us see why the wrong method changes the answer.

In the same example:

ParticularsOpeningClosing
Trade receivables before provisionRs. 80,000Rs. 1,20,000
Less: Provision for doubtful debtsRs. 4,000Rs. 6,000
Net trade receivablesRs. 76,000Rs. 1,14,000

Average net trade receivables:

(Rs. 76,000 + Rs. 1,14,000) / 2 = Rs. 95,000

Wrong turnover ratio:

Rs. 6,00,000 / Rs. 95,000 = 6.32 times

This answer looks better because the denominator became smaller. But it is not the correct school-level treatment for the turnover ratio.

That is why gross debtors are safer and more correct here.

Solved Example 2: Net Debtors Are Given in the Question

Sometimes the question does not give gross debtors directly. It may give net debtors and provision separately.

Calculate average trade receivables:

ParticularsOpeningClosing
Net debtorsRs. 70,000Rs. 92,000
Provision for doubtful debtsRs. 5,000Rs. 8,000
Bills receivableRs. 10,000Rs. 20,000

Step 1: Add Back Provision to Find Gross Debtors

ParticularsOpeningClosing
Net debtorsRs. 70,000Rs. 92,000
Add: Provision for doubtful debtsRs. 5,000Rs. 8,000
Gross debtorsRs. 75,000Rs. 1,00,000

Step 2: Add Bills Receivable

ParticularsOpeningClosing
Gross debtorsRs. 75,000Rs. 1,00,000
Add: Bills receivableRs. 10,000Rs. 20,000
Trade receivables for turnover ratioRs. 85,000Rs. 1,20,000

Step 3: Calculate the Average

Average Trade Receivables
= (Rs. 85,000 + Rs. 1,20,000) / 2
= Rs. 1,02,500

So average trade receivables are Rs. 1,02,500.

This is a common exam trap because the word “net” looks neat and final. But for this ratio, final presentation is not the main purpose.

Solved Example 3: Further Bad Debts Are Given

Further bad debts are different from provision.

Provision is an estimate.

Further bad debts are an actual amount that will not be received.

Suppose the question gives:

ParticularsAmount
DebtorsRs. 1,00,000
Further bad debtsRs. 4,000
Provision for doubtful debts5 percent
Bills receivableRs. 16,000

For trade receivables turnover ratio, first deduct further bad debts:

Adjusted debtors = Rs. 1,00,000 - Rs. 4,000
Adjusted debtors = Rs. 96,000

Now add bills receivable:

Trade receivables for turnover ratio
= Rs. 96,000 + Rs. 16,000
= Rs. 1,12,000

Do not deduct the 5 percent provision for the turnover ratio.

If you were preparing the Balance Sheet, the provision would be deducted from adjusted debtors. But for trade receivables turnover ratio, stop before deducting provision.

The Correct Order of Adjustments

Use this order whenever debtors, further bad debts, provision, and bills receivable appear together.

StepWhat to doWhy
1Start with debtorsThis is the customer amount given
2Deduct further bad debtsActual bad debts are no longer receivable
3Do not deduct provisionProvision is only an estimate for this ratio
4Add bills receivableBills receivable are part of trade receivables
5Average opening and closing figuresThe ratio uses average trade receivables

This sequence is simple, but it must be followed calmly.

Gross Debtors, Net Debtors, and the Balance Sheet

One reason students get confused is that the Balance Sheet often shows debtors after deducting provision.

That treatment is correct for presenting assets.

For example:

AssetsAmount
DebtorsRs. 1,00,000
Less: Provision for doubtful debtsRs. 5,000
Net debtorsRs. 95,000

This shows a cautious receivable value.

But a turnover ratio is not just presenting the asset. It is measuring the movement of credit sales into cash.

So the Balance Sheet value and the turnover-ratio denominator can differ.

Purpose decides treatment.

How to Handle Sales Information

Average trade receivables is only the denominator. The numerator also needs care.

Use net credit revenue from operations.

SituationNumerator to use
Credit revenue is givenUse credit revenue
Credit sales and sales returns are givenCredit sales minus sales returns
Total revenue and cash revenue are givenTotal revenue minus cash revenue
Only revenue from operations is givenUse the given revenue unless the question gives a cash-credit split

Do not spend time creating assumptions that are not in the question.

Common Mistakes to Avoid

Mistake 1: Deducting Provision for Doubtful Debts

Provision should not be deducted from debtors for trade receivables turnover ratio.

Use debtors before provision.

Mistake 2: Forgetting Bills Receivable

Bills receivable are part of trade receivables.

If the question gives debtors and bills receivable, add both.

Mistake 3: Adding Back Actual Bad Debts

Do not add back bad debts that are already written off.

Actual bad debts reduce debtors. Provision does not reduce the debtor figure for this ratio.

Mistake 4: Treating Further Bad Debts Like Provision

Further bad debts must be deducted first because they are no longer receivable.

Provision is ignored for the turnover denominator.

Mistake 5: Using Closing Trade Receivables When Opening Is Given

If both opening and closing figures are available, calculate the average.

Use only closing trade receivables when opening information is not available.

Mistake 6: Writing the Answer Without “Times”

Trade receivables turnover ratio is written in times.

Write:

6 times

Do not write only:

6

Quick Revision Table

Question clueCorrect treatment
Debtors before provision givenUse them for turnover ratio
Net debtors and provision givenAdd back provision
Bills receivable givenAdd to debtors
Further bad debts givenDeduct from debtors first
Provision for doubtful debts givenDo not deduct for turnover ratio
Opening and closing figures givenCalculate average
Only closing figure givenUse closing figure
Average collection period askedUse 365 divided by turnover ratio

This table is worth revising before any ratio-analysis test.

A Simple Memory Rule

Use this sentence:

For collection speed, count what customers owed before provision.

The phrase “collection speed” points to trade receivables turnover ratio.

The phrase “before provision” points to gross debtors.

If you remember this, the gross-vs-net confusion becomes much lighter.

How to Present the Working

A neat answer should show the working note clearly.

Use this format:

Working noteAmount
Opening debtors before provisionRs. …
Add: Opening bills receivableRs. …
Opening trade receivablesRs. …
Closing debtors before provisionRs. …
Add: Closing bills receivableRs. …
Closing trade receivablesRs. …
Average trade receivablesRs. …

Then write the ratio:

Trade Receivables Turnover Ratio
= Net Credit Revenue from Operations / Average Trade Receivables

Finally, write the answer in times.

This is especially important when the question includes provision or net debtors.

Frequently Asked Questions

1. Should average trade receivables use gross debtors or net debtors?

For trade receivables turnover ratio, use gross debtors. This means debtors before deducting provision for doubtful debts.

2. Why are debtors taken before provision for doubtful debts?

Because the ratio measures collection speed from credit customers. Provision is only an estimate of possible loss, so it should not reduce the debtor figure used for this turnover ratio.

3. Are bills receivable included in average trade receivables?

Yes. Trade receivables include debtors and bills receivable. If both are given, add both before calculating the average.

4. What if net debtors are given instead of gross debtors?

If net debtors and provision are both given, add back the provision to find gross debtors. Then add bills receivable, if any.

5. Are further bad debts deducted before calculating trade receivables?

Yes. Further bad debts are actual bad debts, so they reduce debtors first. After that, do not deduct provision for doubtful debts for the turnover ratio.

6. Is net debtors wrong everywhere?

No. Net debtors are used when presenting debtors as an asset after provision. The point is that trade receivables turnover ratio has a different purpose, so it uses debtors before provision.

7. What is the formula for average trade receivables?

The formula is opening trade receivables plus closing trade receivables, divided by 2. Trade receivables usually mean debtors plus bills receivable.

8. What if opening trade receivables are not given?

If opening trade receivables are not available, use the closing figure provided in the question. Do not create an opening amount by assumption.

9. Can provision for discount on debtors be deducted for this ratio?

No. Provision for discount on debtors is also an estimate. For trade receivables turnover ratio, focus on the customer amount before such provisions.

Looking for commerce tuitions?

Prachi is a gold-medalist commerce teacher with experience at Deloitte and KPMG. She focuses on fundamentals to build a strong foundation.

Start classes