lamp.
ResourcesPricingAbout

Collection effectiveness index

The collection effectiveness index measures, as a percentage, how much of the money that could have been collected in a period you actually collected.

What it means

It is built from opening receivables, credit sales in the period, closing receivables and closing overdue amounts. A score near 100 per cent means almost everything collectable was collected. Because it compares your result with what was available to collect, it is fairer than just counting rupees received. Formulas vary slightly between books, so use one version consistently.

Example

A cable maker starts the month with ₹10 lakh receivable and adds ₹20 lakh of credit sales. Out of ₹30 lakh collectable, it ends with ₹8 lakh unpaid but not yet due, and ₹2 lakh overdue. Collecting ₹22 lakh against ₹28 lakh that was due gives roughly 79 per cent.

Records and checks

  • Record: opening balance, credit sales, closing balance and overdue closing balance for the period.
  • Verify: that the figures come from the ledger and match the ageing report.
  • Checked by: the finance head calculates monthly; the owner compares it month on month.

Common mistakes

  • Comparing the index across months that use different formulas.
  • Reading one month in isolation, when a few large invoices can swing it.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →