Skip to main content
Back to BlogERP Automation

How to Reduce Debtor Days: A Receivables Playbook for SMBs

Fininvo Team
May 24, 20268 min read

If you want to reduce debtor days, start by accepting an uncomfortable fact: in most Indian SMBs, customers pay late partly because the business lets them. Invoices go out days after dispatch, nobody owns follow-up, credit limits exist on paper only, and disputes sit unresolved for months. Debtor days (also called days sales outstanding or DSO) measures how long, on average, it takes to collect payment after a sale. Every extra day costs interest on your cash credit limit and squeezes your ability to pay suppliers on time. This playbook explains how to calculate debtor days, read the ageing report, and reduce debtor days with practical steps that work for Indian B2B businesses.

How to calculate debtor days

The standard formula:

Debtor days = (Trade receivables / Credit sales for the period) x Number of days in the period

Use credit sales including GST, because receivables include GST. If you cannot separate cash and credit sales, use total sales, but be consistent.

Worked example

Suppose a hypothetical Faridabad auto components supplier has annual credit sales of ₹24 crore (including GST) and trade receivables of ₹5.4 crore at year end.

Debtor days = (5.4 / 24) x 365 = 82 days.

The company's standard terms are 60 days, so customers take 22 days longer than agreed on average. What is that worth? Each day of sales is ₹24 crore / 365 = about ₹6.6 lakh. Bringing debtor days down from 82 to 65 releases 17 x ₹6.6 lakh = about ₹1.12 crore of cash. At an illustrative 10 percent cash credit interest rate, that is roughly ₹11 lakh a year saved, and the freed limit can fund growth instead.

Use a monthly or rolling measure

Year-end debtor days can be distorted by a strong March. A more reliable measure is the countback method: start with current receivables and subtract each month's sales going backwards until receivables are exhausted, counting the days. Alternatively, calculate debtor days monthly on trailing three-month sales. Whatever you choose, track the same measure every month.

Read the receivables ageing report first

Debtor days is an average. The ageing report shows where the problem actually sits.

Ageing bucketAmount (₹ lakh)ShareTypical action
Not yet due26048%Pre-due reminders for large invoices
1 to 30 days overdue14026%Phone follow-up, confirm payment date
31 to 60 days overdue7514%Escalate to sales head; review credit
61 to 90 days overdue356%Hold further supplies; formal letter
Over 90 days overdue306%Legal notice, settlement, provision
Total540100%

Then sort by customer. Typically 10 to 15 customers account for most of the overdue amount. Those customers get individual attention; the long tail gets a systematic process.

Step 1: Set and enforce a credit policy

A written credit policy removes negotiation from every order. It should define:

  • Credit assessment for new customers: GST registration and filing status, trade references, bank statements or financials for larger limits.
  • Credit limits and credit days by customer category, approved by someone other than the salesperson.
  • What happens on breach: soft block (approval needed) at the limit, hard block on orders when invoices are more than, say, 30 days overdue.
  • Review frequency: limits reviewed every six months against payment behaviour.
  • Security: advance payment, post-dated cheques, bank guarantees or letters of credit for higher-risk customers.

The policy only works if the system enforces it. In an ERP, credit limits and overdue checks can block a sales order or delivery automatically, with an override routed to an approver.

Step 2: Invoice faster and cleaner

The credit period starts from the invoice date, and many customers start counting from the date they receive a correct invoice. Common delays:

  • Invoices raised days after dispatch because billing is done in batches.
  • Invoices rejected by the customer for a wrong PO number, wrong GSTIN, wrong rate or missing delivery proof.
  • Invoices sent to a generic address instead of the customer's accounts payable contact.

Fixes: generate the invoice at dispatch from the delivery note, carry the customer's PO number and line references automatically, email the invoice to the AP contact on the same day, and attach signed delivery proof where the customer requires it. If a customer runs a vendor portal, upload on the day of dispatch.

Step 3: Build a structured follow-up calendar

WhenActionOwner
7 days before dueEmail statement and invoice copy; confirm no issuesAccounts receivable
On due datePayment reminder with bank details and UPI or payment linkAccounts receivable
7 days overduePhone call, get a committed payment dateAccounts receivable
15 days overdueSales manager call to customer's purchase headSales
30 days overdueOrder hold; formal letterFinance head
60 days overdueFinal notice; consider legal or MSME routeFinance head and owner

Record every commitment ("will pay ₹12 lakh on 18th") against the customer and follow up the day after if it does not arrive. Broken promises are the single best predictor of a bad debt.

Step 4: Resolve disputes quickly

A meaningful share of overdue balances in B2B are not about the customer's cash but about a dispute: short supply, quality rejection, price difference, a missing credit note for a scheme, or TDS deducted at the wrong rate. Each one blocks the entire invoice in the customer's system.

  • Log disputes against the invoice with a reason code and owner.
  • Set a target to resolve within 7 to 15 days.
  • Issue credit notes promptly when the customer is right; insisting on full payment for a genuinely short supply only delays the undisputed portion.
  • Review dispute reasons monthly. If "rate difference" is the top reason, the problem is in your price master, not in collections.

Step 5: Make paying easy

  • Print bank details, UPI ID or a QR code on invoices and statements.
  • Send payment links for smaller customers.
  • Ask customers to send remittance advice with invoice numbers so receipts can be matched quickly. Unmatched receipts in the bank make your ageing look worse than reality.
  • Offer early payment discounts only where the maths works: a 1 percent discount for payment in 10 days instead of 60 equals an annualised cost of about 7.3 percent, which may be cheaper than your borrowing rate.

Step 6: Use your rights as an MSME supplier

If your business is registered as a micro or small enterprise under the MSMED Act, buyers must pay within the agreed period, which cannot exceed 45 days, and delayed payment attracts compound interest at three times the bank rate notified by the RBI. You can file a reference with the MSME Facilitation Council through the MSME Samadhaan portal. Medium and larger buyers are also required to report MSME dues outstanding beyond 45 days in their filings. Separately, income-tax law restricts the buyer's deduction for such dues until payment is made, which gives large customers a strong reason to pay MSME suppliers on time. Mention your Udyam registration on invoices and in your vendor registration with customers.

MSME sellers can also discount invoices from large buyers on TReDS platforms, which converts receivables into cash without adding to bank borrowing.

Step 7: Measure and incentivise

  • Track debtor days, overdue percentage and collection effectiveness monthly, by customer and by salesperson.
  • Link part of sales incentives to collections, not just bookings. Salespeople who know they are paid on collection sell to better customers.
  • Review the top 20 overdue accounts in a weekly 30-minute meeting with sales and finance.

Reduced debtor days show up immediately in your cash position. Pair this playbook with a 13-week cash flow forecast so collection commitments flow directly into your cash plan.

Common mistakes that keep debtor days high

  • Treating collections as an accounts problem only. Sales owns the customer relationship and must be part of the process.
  • Ignoring small overdue amounts. Habits form early; a customer who is allowed to pay 20 days late on small invoices will do the same on large ones.
  • Not provisioning old debts. Carrying three-year-old receivables at full value distorts debtor days and the balance sheet.
  • Unapplied receipts: money received but not matched to invoices keeps them "overdue" in reports.

Frequently Asked Questions

What is a good debtor days figure?

It depends on your industry and agreed terms. A useful target is debtor days close to your standard credit period. If terms are 45 days and debtor days are 70, there is room to improve.

What is the difference between debtor days and the receivables turnover ratio?

Receivables turnover is credit sales divided by average receivables, telling you how many times receivables are collected in a year. Debtor days is 365 divided by that ratio, expressed in days.

Should GST be included when calculating debtor days?

Receivables include GST, so using sales including GST gives a consistent ratio. If you use net sales, debtor days will appear higher. Pick one method and stick to it.

Can an MSME charge interest on late payments?

Under the MSMED Act, micro and small suppliers are entitled to compound interest at three times the RBI bank rate on payments delayed beyond the agreed period or 45 days. Many suppliers use this as leverage in negotiation and through the MSME Facilitation Council.

When should I write off a bad debt?

When recovery is unlikely after reasonable efforts. Provide for doubtful debts based on ageing and specific knowledge, and write off with documented approval. Discuss tax treatment with your CA.

How Fininvo Helps

Fininvo ERP connects sales orders, invoices, receipts and bank reconciliation, with accounts receivable and AR ageing reports in the same system. See accounting, invoicing and pricing.

#debtor-days#accounts-receivable#collections#working-capital#msme

Share this article

Ready to automate your business?

Start your 14-day free trial and experience the power of unified ERP, HR, and Payroll.

Start Free Trial