Receivables aging: what the unpaid total leaves out

Two businesses can each be owed $100,000 by customers without expecting to collect the same amount. A receivables aging report separates the unpaid balance into dated groups. An estimate of noncollection then asks how much of that gross balance might not become a receipt.

The age profile, the estimate and the cash already collected are different records. Keep all three visible.

Which date starts the clock?

For this invented report, age means calendar days past the contractual payment due date. The first group contains balances whose due dates have not passed, including those due today. The other groups are 1–30, 31–60 and more than 60 days overdue.

That is not the same as days since the invoice was issued. At an August 31, 2027 report date, an invoice issued July 2 and due August 1 is 60 days old but 30 days overdue. It belongs in the 1–30 days overdue group under these definitions.

Every balance below is still unpaid at the report date, after recorded payments and credits. Each is counted once. The figures and noncollection percentages are supplied for this illustration; they are not industry rates or estimates for a real business.

From gross balance to net estimate

The first invented business has this $100,000 profile. Apply each group's percentage to its balance, then add the estimated amounts.

Business A: invented balances and noncollection assumptions

Scroll across to see every column. Use the arrow keys when the table is focused.

Estimated noncollection totals $11,500: $500 plus $1,000 plus $2,000 plus $8,000. Subtracting it from the $100,000 gross receivables gives an estimated net balance of $88,500.

OpenStax's aging explanation follows this grouping-and-estimation method. Its allowance account reduces gross receivables to a net estimate; it does not identify a payment received or cancel a particular customer's invoice.

The $11,500 is an estimated reduction at this report date, not automatically the new expense for the period. An existing allowance balance would also matter when calculating an adjustment. The walkthrough here stops at the gross-to-net estimate.

The same total, with a different profile

Try a second invented business with the same $100,000 gross balance. It has $80,000 not past due, $10,000 overdue by 1–30 days, $5,000 by 31–60 days and $5,000 by more than 60 days. Use exactly the same supplied percentages. What changes?

The category estimates become $800, $500, $1,000 and $2,000. Their sum is $4,300, leaving an estimated net balance of $95,700. Business B's estimate is $7,200 higher than A's even though both begin with the same unpaid total.

The same assumed rates produce a lower noncollection estimate because B has less in the older groups. Different rates or customer-specific information could change that comparison. Applying the percentages to actual balances would require evidence for them.

What the estimate cannot schedule

Neither $88,500 nor $95,700 supplies a payment date. A business could eventually collect its estimated balance and still miss payroll before the money arrives. The working-capital calendar follows that separate timing question.

An old invoice does not settle an individual customer's circumstances. A disputed delivery, an unrecorded payment, an agreed change in terms or a credit awaiting entry can change what the balance means. An actual review needs the underlying account and current information, not just the bucket label.

The receivables explanation in OpenStax separates a customer amount owed from its later collection. Aging adds another question about that unpaid amount; it does not create a second sale or a bank deposit.

When reading an aging report, identify its reporting date, the date used to measure age, the remaining balances and the basis for its estimates. Then recover the expected collection dates separately. For the book's business stories, read the opening of Infinite Upside: Building Wealth With Room to Live.