Profit & cash flow · Calculator
Receivables & payables ageing
Review five invoice-age buckets and prioritise collection or payment follow-up.
EXAMPLE
Your results and working
| Invoice-age bucket | Balance | Share of invoices |
|---|---|---|
| 0–30 days | ₹5,00,000.00 | 40.00% |
| 31–60 days | ₹3,00,000.00 | 24.00% |
| 61–90 days | ₹2,00,000.00 | 16.00% |
| 91–180 days | ₹1,50,000.00 | 12.00% |
| Above 180 days | ₹1,00,000.00 | 8.00% |
What this result includes
Enter unpaid invoice balances after allocating supported receipts, payments and credit notes. Buckets are based on invoice age; contractual due dates must be checked to identify overdue amounts.
Unallocated advances are displayed separately and are not subtracted from the bucket total. Allocate them to the correct invoices first if legally and commercially appropriate, then rerun the analysis.
Balance days = invoice outstanding ÷ average monthly credit sales / purchases × 30. This is a closing-balance approximation, not an invoice-level collection forecast.
Prioritise collection follow-up using due dates, disputes, customer confirmations and recoverability.