Debtor days calculator
Debtor days, also called receivable days or days sales outstanding, is the average number of days your customers take to pay. Compare it with the credit period on your invoices: if customers take much longer, cash is stuck with them.
The formula
Average debtors = (debtors at the start + debtors at the end) ÷ 2.
Debtor days = average debtors ÷ credit sales × days in the period. Debtor turnover = credit sales ÷ average debtors.
Worked example
A packaging supplier made credit sales of ₹48,00,000 in the year. Debtors were ₹5,50,000 at the start and ₹6,50,000 at the end, an average of ₹6,00,000. Debtor days are ₹6,00,000 ÷ ₹48,00,000 × 365 = 46 days, and debtors turn over 8 times a year. If its invoices say 30 days, customers are paying about 16 days late on average.
More business calculators
- Business and accounting calculators
- Break-even calculator
- Gross profit calculator
- EBITDA calculator
- ROI calculator
- NPV calculator
- IRR calculator
- Payback period calculator
- Working capital calculator
- Current ratio calculator
- Quick ratio calculator
- Debt to equity ratio
- Inventory turnover calculator
- Depreciation calculator
- Cash flow forecast
- Accounting basics
Questions people ask
Should I use total sales or credit sales?
Credit sales. Cash sales are collected on the day, so including them makes debtor days look shorter than they are. If you sell almost everything on credit, total sales is close enough.
Do debtors include GST?
Yes, the amount a customer owes includes the GST on your invoice. For a fair figure, use credit sales including GST too, or take GST out of both.
How can I collect faster?
Invoice on the day you deliver, state the due date clearly on the invoice, send reminders before the due date, offer a small discount for early payment, and stop further credit to customers who are badly overdue.
Is there a legal limit on how long buyers can take?
The Micro, Small and Medium Enterprises Development Act, 2006 has rules on payment to registered micro and small suppliers and on interest for late payment. Read the Act or ask your accountant how they apply to your customers before relying on them.
A tax professional can call you back. Asking is free.
Get helpMore calculators
Results are estimates for information only, not financial or tax advice. Rates, rules and limits change, so check with your bank, employer or a qualified adviser before you decide.