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
Average trade receivables looks like a small part of ratio analysis, but it can quietly change the whole answer.
Most students know this formula:
| Formula | Meaning |
|---|---|
| Trade Receivables Turnover Ratio = Net Credit Revenue from Operations / Average Trade Receivables | Shows 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:
| Numerator | Denominator |
|---|---|
| Net credit revenue from operations | Average 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.
| Term | Simple meaning |
|---|---|
| Gross debtors | Debtors before deducting provision for doubtful debts |
| Net debtors | Debtors after deducting provision for doubtful debts |
Suppose the question gives:
| Particulars | Amount |
|---|---|
| Debtors | Rs. 1,00,000 |
| Less: Provision for doubtful debts | Rs. 5,000 |
| Net debtors | Rs. 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.
| Item | Include in trade receivables? | Reason |
|---|---|---|
| Debtors | Yes | Amount due from credit customers |
| Bills receivable | Yes | Written promise to receive money from customers |
| Provision for doubtful debts | No deduction for turnover ratio | It is only an estimate |
| Further bad debts | Deduct first | It is an actual reduction in debtors |
| Provision for discount on debtors | No deduction for turnover ratio | It 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:
| Formula | Meaning |
|---|---|
| Average Trade Receivables = (Opening Trade Receivables + Closing Trade Receivables) / 2 | Finds the average customer amount tied up during the year |
If debtors and bills receivable are given separately, calculate opening and closing trade receivables first.
| Particulars | Opening | Closing |
|---|---|---|
| Gross debtors | Rs. … | Rs. … |
| Add: Bills receivable | Rs. … | Rs. … |
| Trade receivables for turnover ratio | Rs. … | 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.
| Situation | Use gross debtors or net debtors? |
|---|---|
| Trade receivables turnover ratio | Gross debtors, plus bills receivable |
| Average collection period | Same figure used in trade receivables turnover ratio |
| Showing debtors in Balance Sheet | Net debtors after provision |
| Current ratio or quick ratio | Usually the net amount shown as current asset |
| Provision for doubtful debts adjustment | Calculate 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:
| Particulars | Amount |
|---|---|
| Net credit revenue from operations | Rs. 6,00,000 |
| Opening debtors | Rs. 70,000 |
| Opening bills receivable | Rs. 10,000 |
| Opening provision for doubtful debts | Rs. 4,000 |
| Closing debtors | Rs. 1,05,000 |
| Closing bills receivable | Rs. 15,000 |
| Closing provision for doubtful debts | Rs. 6,000 |
Step 1: Calculate Opening Trade Receivables
Use debtors before deducting provision.
| Particulars | Amount |
|---|---|
| Opening debtors | Rs. 70,000 |
| Add: Opening bills receivable | Rs. 10,000 |
| Opening trade receivables | Rs. 80,000 |
Opening provision is ignored for this ratio.
Step 2: Calculate Closing Trade Receivables
| Particulars | Amount |
|---|---|
| Closing debtors | Rs. 1,05,000 |
| Add: Closing bills receivable | Rs. 15,000 |
| Closing trade receivables | Rs. 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:
| Particulars | Opening | Closing |
|---|---|---|
| Trade receivables before provision | Rs. 80,000 | Rs. 1,20,000 |
| Less: Provision for doubtful debts | Rs. 4,000 | Rs. 6,000 |
| Net trade receivables | Rs. 76,000 | Rs. 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:
| Particulars | Opening | Closing |
|---|---|---|
| Net debtors | Rs. 70,000 | Rs. 92,000 |
| Provision for doubtful debts | Rs. 5,000 | Rs. 8,000 |
| Bills receivable | Rs. 10,000 | Rs. 20,000 |
Step 1: Add Back Provision to Find Gross Debtors
| Particulars | Opening | Closing |
|---|---|---|
| Net debtors | Rs. 70,000 | Rs. 92,000 |
| Add: Provision for doubtful debts | Rs. 5,000 | Rs. 8,000 |
| Gross debtors | Rs. 75,000 | Rs. 1,00,000 |
Step 2: Add Bills Receivable
| Particulars | Opening | Closing |
|---|---|---|
| Gross debtors | Rs. 75,000 | Rs. 1,00,000 |
| Add: Bills receivable | Rs. 10,000 | Rs. 20,000 |
| Trade receivables for turnover ratio | Rs. 85,000 | Rs. 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:
| Particulars | Amount |
|---|---|
| Debtors | Rs. 1,00,000 |
| Further bad debts | Rs. 4,000 |
| Provision for doubtful debts | 5 percent |
| Bills receivable | Rs. 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.
| Step | What to do | Why |
|---|---|---|
| 1 | Start with debtors | This is the customer amount given |
| 2 | Deduct further bad debts | Actual bad debts are no longer receivable |
| 3 | Do not deduct provision | Provision is only an estimate for this ratio |
| 4 | Add bills receivable | Bills receivable are part of trade receivables |
| 5 | Average opening and closing figures | The 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:
| Assets | Amount |
|---|---|
| Debtors | Rs. 1,00,000 |
| Less: Provision for doubtful debts | Rs. 5,000 |
| Net debtors | Rs. 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.
| Situation | Numerator to use |
|---|---|
| Credit revenue is given | Use credit revenue |
| Credit sales and sales returns are given | Credit sales minus sales returns |
| Total revenue and cash revenue are given | Total revenue minus cash revenue |
| Only revenue from operations is given | Use 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 clue | Correct treatment |
|---|---|
| Debtors before provision given | Use them for turnover ratio |
| Net debtors and provision given | Add back provision |
| Bills receivable given | Add to debtors |
| Further bad debts given | Deduct from debtors first |
| Provision for doubtful debts given | Do not deduct for turnover ratio |
| Opening and closing figures given | Calculate average |
| Only closing figure given | Use closing figure |
| Average collection period asked | Use 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 note | Amount |
|---|---|
| Opening debtors before provision | Rs. … |
| Add: Opening bills receivable | Rs. … |
| Opening trade receivables | Rs. … |
| Closing debtors before provision | Rs. … |
| Add: Closing bills receivable | Rs. … |
| Closing trade receivables | Rs. … |
| Average trade receivables | Rs. … |
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.