Launch offer — 25% off with code LAUNCH-25 See plans →
Microlesson · 5-min read

Monitoring of Receivables — Ageing Schedule and Debt Collection

## Monitoring of Receivables

Definition: Monitoring receivables means regularly tracking, evaluating, and managing the status of customer dues to ensure timely collection and minimize bad debts and delays.

Goal: Ensure the receivable system is effective, efficient, and timely.

---

### Key Steps in Monitoring Receivables

#### Step 1: Compute Average Age of Receivables (Average Collection Period)

$$\text{Average Collection Period (ACP)} = \frac{\text{Average Debtors} \times 365}{\text{Annual Credit Sales}}$$

  • Compare ACP with the firm's stated credit terms
  • Rising ACP signals deteriorating collection efficiency

#### Step 2: Ageing Schedule

Groups receivables by how long they have been outstanding.

Structure of an Ageing Schedule:

Age BracketAmount (₹)% of TotalRisk Level
0–30 daysXX,XXXXX%Low
31–60 daysXX,XXXXX%Medium
61–90 daysXX,XXXXX%High
91–180 daysXX,XXXXX%Very High
180+ daysXX,XXXXX%Critical

Purpose of Ageing Schedule:

  • Compare with past quarters → measure if collection has improved
  • Identify slow payers who need urgent follow-up
  • Compare with industry peers to assess relative liquidity strength
  • Flag accounts for potential write-off (180+ days)

#### Step 3: Debt Collection Programme

StageAction
(a)Ongoing monitoring of receivables status
(b)Notify customers as due date approaches
(c)Email and phone reminders on due date
(d)Remind of legal consequences for overdue amounts; escalate per escalation matrix
(e)Initiate legal action on significantly overdue accounts

---

### Collection Expenses vs Bad Debt Losses

  • Initially, increasing collection expenses has only a small impact on reducing bad debts.
  • Beyond a threshold, more spending on collections yields diminishing returns.
  • The firm must find the optimal balance — the point where the marginal cost of collection equals the marginal reduction in bad debts.

Worked example

### Example 1

Ageing Schedule Example:

ABC Ltd. has total debtors of ₹5,00,000. Analysis:

Age (Days)Amount (₹)% of TotalAction Required
0–302,00,00040%Routine monitoring
31–601,50,00030%Send reminder
61–9080,00016%Follow-up call
91–18050,00010%Legal notice
180+20,0004%Evaluate for write-off
Total5,00,000100%

Interpretation:

  • 14% of receivables (₹70,000) are over 90 days — high risk, requiring escalated action.
  • The 4% (₹20,000) in 180+ days should be evaluated for bad debt write-off.
  • If last quarter's 90+ days was only 8%, the situation is deteriorating and management must intervene.

⚠️ Common exam mistakes

  • Monitoring is not a one-time activity — it must be performed continuously and reviewed periodically (monthly/quarterly)
  • An ageing schedule is not just for identifying bad debts — it also measures overall collection efficiency and debtor behavior trends
  • Do not confuse ACP (actual average collection period) with credit period (the policy target) — ACP > credit period signals a collection problem
  • Increasing collection expenses does NOT always reduce bad debts proportionately — the relationship is non-linear with diminishing returns
  • The ageing schedule must be compared to prior periods AND industry benchmarks — a number in isolation is not meaningful
Reference:
Now that you've read this — what's next?
Move from understanding → mastery in 3 clicks. Each option below picks up from this lesson's topic.
Start 15-min diagnostic