Finance, business & the decisions that matter
Ideas. Evidence. Perspective.The financial journal
LOADMOREMONEY · MARKETS · ANALYSIS
Menu

Business financial analysis

Receivables Aging: Finding Collection Risk Behind the Sales Total

Use invoice aging and a hypothetical loss matrix to distinguish sales growth from collection quality, while respecting the limits of aggregate balances.

3 supporting sourcesWorked example
Business Team

Photo: Startup Stock Photos / StockSnap / CC0 1.0. Illustrative photograph; no endorsement implied.

Hypothetical worked example and primary educational references; not observed market data.

Age invoices against their due dates

An aging schedule groups outstanding invoices by time overdue or by time since issuance. Those conventions are not equivalent. A 60-day-old invoice under 90-day payment terms is different from one due after 15 days. Establish the convention before comparing schedules. Aging helps identify where collection uncertainty is concentrated, but delay is not the same as permanent loss. Administrative disputes, customer distress, and normal payment practice can all create older balances. The analytical objective is to understand which explanation fits each material group, rather than assigning a single meaning to every invoice that crosses a day boundary.

Supporting references: 1. IFRS Foundation: IFRS 9 impairment review

Build a hypothetical loss matrix

Suppose a supplier has USD 500 of current invoices and 100 more than 60 days overdue. Applying illustrative loss assumptions of 1% and 15% gives estimated losses of 5 and 15, totaling 20. This is a teaching matrix, not an observed default model. The IFRS 9 review document discusses provision matrices in its explanation of expected credit-loss concepts. Actual measurement requires the applicable framework, relevant history, and forward-looking information. The example merely shows why the distribution of invoices can matter more than the total balance: a small overdue bucket can contribute most of a modeled loss amount.

Supporting references: 1. IFRS Foundation: IFRS 9 impairment review

Hypothetical worked example

Hypothetical aging mix with constant receivables

Model setup

Read these assumptions before comparing the scenarios.

  • All monetary amounts in this example are hypothetical U.S. dollars (USD), not current prices, quoted account terms or observed market data. Percentages, counts, time periods and index levels retain their stated units.
  • Total gross receivables remain USD 600.
  • Illustrative loss assumptions are 1% for current invoices and 15% for invoices more than 60 days overdue.
Figure 01The numbers, visualizedHypothetical aging mix with constant receivables

Modeled net receivables (USD)

  1. Initial mix580
  2. Older mix566

Expanded scale, not zero-based; dots show small differences.

Lowest displayed value
566.00
Highest displayed value
580.00

Hypothetical cases from the table below, in the stated units. Not market observations, a forecast or a recommended choice. Read the scenario assumptions before comparing.

Scenario data · hypothetical cases
CaseCurrent (USD)Overdue (USD)Modeled loss (USD)Modeled net receivables (USD)
Initial mix50010020580
Older mix40020034566
Calculation details
Initial loss
20.00 USD((500 * 0.01) + (100 * 0.14999999999999999))
Older-mix loss
34.00 USD((400 * 0.01) + (200 * 0.14999999999999999))

Hold the total constant and change the mix

In a second case, total receivables stay 600 but current invoices fall to 400 and overdue invoices rise to 200. With the same illustrative rates, modeled losses become 4 plus 30, or 34. The 14 increase comes entirely from aging mix. An analyst reading only the unchanged 600 balance would miss that change. Yet even the 34 result is not a definitive accounting allowance. If the overdue bucket contains a well-supported administrative dispute that resolves after year-end, the appropriate estimate may differ. Separate arithmetic sensitivity from the evidence needed to assign the underlying loss assumptions.

Supporting references: 2. SEC: How to Read a 10-K

Investigate customer concentration

An average loss rate can conceal a single large customer whose failure would dominate the result. Grouping by industry, geography, credit characteristics, or payment behavior may produce a more meaningful analysis than grouping by days alone. Collateral, credit insurance, and contractual rights can also affect loss exposure, though their value depends on enforceability and counterparty quality. Public disclosures may not provide invoice-level information, so avoid inventing detail. Identify what is known, what is inferred, and what remains unavailable. A concentrated receivable deserves attention even when it is current, because aging measures timing rather than the full distribution of credit risk.

Supporting references: 2. SEC: How to Read a 10-K

Watch movement and subsequent cash

Compare opening overdue balances, newly overdue amounts, collections, write-offs, and transfers between buckets when information permits. A lower overdue balance can result from successful collection or from writing invoices off; those outcomes have different implications. Subsequent receipts provide useful evidence but must be matched to the correct invoices. A customer paying a new order while leaving an old invoice unresolved does not necessarily improve the older balance's prospects. Likewise, selling receivables can reduce reported balances without showing that customers paid the original seller. The commercial and accounting terms of such arrangements affect how the movement should be interpreted.

Supporting references: 2. SEC: How to Read a 10-K

Connect collection quality to reported revenue

Revenue can expand while cash collection weakens. That pattern does not by itself invalidate the revenue, but it makes payment terms and recognition judgments more important. Read the accounting notes and management explanation before concluding that growth is durable. Aging analysis is strongest when combined with customer economics: why customers bought, whether returns or disputes are increasing, and whether terms changed to encourage orders. The hypothetical matrix teaches distributional risk, not a universal provisioning rule. US credit-loss requirements and IFRS requirements can differ. Use the relevant framework and the company's own disclosure when assessing any actual allowance.

Supporting references: 2. SEC: How to Read a 10-K

Test another situationModel a concentrated current invoice

A separate hypothetical case. Its inputs differ from the main worked example above.

Model a concentrated current invoice

Imagine a hypothetical USD 1,000 receivable portfolio. A single current customer owes USD 600, while smaller current customers owe USD 400. Assign independent illustrative loss assumptions of 10% to the concentrated customer and 1% to the remainder. The modeled loss is USD 64 even though nothing is overdue. This is not an observed default estimate or a required allowance. It demonstrates how a current aging bucket can conceal concentrated exposure. Offering the large customer longer terms may support sales while increasing the amount at risk before any overdue signal appears. No collateral, recoveries, insurance, or subsequent receipts are assumed.

Supporting references: 3. IFRS Foundation: IFRS 9 overview

Distinguish customer weakness from an aging migration

The IFRS 9 overview identifies the credit-loss framework. Operationally, link a customer's different invoices before applying an undifferentiated current-bucket assumption: a new invoice should not erase unresolved collection problems on an old one. Inspect whether the customer has disputed the product, sought extensions, or simply experienced an administrative delay. Separate that evidence from the invoice clock. A matrix built only on lateness can react after exposure has already accumulated. The implementation check is a customer-level reconciliation of gross balances, known disputes, subsequent receipts, and loss assumptions, with the aggregate aging table used as a summary rather than the full risk model.

Supporting references: 3. IFRS Foundation: IFRS 9 overview

Check this case’s calculations
Concentration-sensitive modeled loss
64.00 USD((600 * 0.10000000000000001) + (400 * 0.01))

Limits of this additional case

  • The assigned loss assumptions are sensitivities; customer-specific evidence and the applicable impairment framework determine actual measurement.

Limits of this analysis

  • Illustrative loss rates are not observed default statistics or a required allowance.
  • Days overdue differ from days since invoice issuance.
  • Concentration, recoveries, and forward-looking evidence can outweigh aging alone.

Sources and scope

  1. IFRS Foundation: IFRS 9 impairment review

    Expected credit losses and provision matrices for trade receivables.

    Scope: 2023 IASB review document explaining existing concepts, not a new rule or US CECL guidance.. Reference accessed 2026-10-06.

  2. SEC: How to Read a 10-K

    Notes and management discussion provide context for reported results.

    Scope: Historical US educational bulletin; used for reading principles, not current filing requirements.. Reference accessed 2026-10-06.

  3. IFRS Foundation: IFRS 9 overview

    Financial instruments and credit-loss framework.

    Scope: IFRS educational context; application and US GAAP can differ. The scenario and its USD inputs are independent hypothetical analysis, not source data or personalized advice.. Reference accessed 2026-10-26.

Illustrative calculations are not forecasts or personal recommendations. Editorial standards

From the library

Related analysis

All articles →