Receivables Ageing and Expected Credit Loss Planner
Reviewed by Finin2min Editorial Desk · Last reviewed 11 August 2026
Summarise customer receivables by ageing bucket and estimate a provision using bucket-specific loss rates.
Ageing buckets
Total receivables
—
Expected credit loss
—
DSO
—
Receivables over 60 days
—
Calculation guidance will appear here.
How This Is Calculated
This calculator buckets outstanding receivables by age (current, 30, 60, 90+ days overdue), applies a loss rate to each bucket (older receivables generally carry higher expected loss rates, reflecting greater collection risk), and sums the expected credit loss across buckets — also computing Days Sales Outstanding (DSO) as an overall collection-efficiency metric.
Frequently Asked Questions
Why do older receivables get a higher expected loss rate?
▼
Because collection probability generally declines the longer an invoice remains unpaid — a receivable 90+ days overdue is statistically much less likely to be fully collected than one that's current, which is why ageing-bucket loss rates typically increase with age.
What does DSO measure and why does it matter?
▼
Days Sales Outstanding measures the average number of days it takes to collect payment after a sale — a rising DSO trend can signal deteriorating collection efficiency or looser credit terms, both of which tie up working capital that could otherwise be used elsewhere.
Evidence and verification checklist
Confirm the current, in-force text governing Receivables Ageing and Expected Credit Loss Planner on the official source linked above - the summary on this page is an implementation aid, not a substitute for it.
Record the exact event/transaction date, since the applicable version of the law, form or threshold can change between the date of the underlying event and today.
Preserve the primary documents (notices, applications, orders, acknowledgements) that would let a reviewer reconstruct how the facts were classified and what was actually done.
Check for a State-specific rule, later amendment or binding judicial decision that may modify how this applies on your facts.
Before relying on this page
This page is a structured implementation summary, not the operative legal text. Portal or process acceptance of a filing does not by itself establish legal compliance - the underlying classification, authority, evidence and timeline still have to be independently correct. Where the facts are contested, high-value, or time-barred if delayed, verify the current position with the official source and, where appropriate, a qualified professional before acting.
Scope: Buckets outstanding customer receivables by age (e.g., 0-30, 31-60, 61-90, 90+ days overdue) and estimates an Expected Credit Loss (ECL) provision using ageing-based default-rate assumptions, consistent with the simplified approach under Ind AS 109.
Calculation logic
Bucket each outstanding invoice into an age category based on (Calculation date − Invoice due date), using the age-band boundaries entered/selected by the user.
Apply the entered default-rate percentage for each age bucket (default rates typically increase with age, reflecting higher collection risk for older receivables) to that bucket's total outstanding value.
Sum the resulting expected-loss amounts across all buckets to arrive at the total Expected Credit Loss provision.
Inputs and assumptions
Default-rate percentages by age bucket are entered by the user, reflecting their own historical loss experience or industry benchmark — the calculator does not derive these rates automatically.
This follows the simplified ECL approach permitted under Ind AS 109 for trade receivables, which allows a provision matrix by ageing bucket rather than the full 12-month/lifetime expected-loss staging model used for other financial instruments.
Exclusions and edge cases
Does not incorporate forward-looking macroeconomic adjustments to the default rates (a requirement of a fully compliant Ind AS 109 ECL model) unless the user has already built such adjustments into the entered default-rate assumptions.
This is a planning/estimation tool; the actual ECL provision recognised in financial statements should be reviewed and approved by the entity's auditors as part of the statutory audit process.