Turn Receivables Aging into a Cash Forecast

An aging report groups unpaid invoices by how long they have been outstanding or overdue. A cash forecast needs another dimension: when each amount is expected to arrive. An old invoice is not automatically uncollectible, and a current invoice is not automatically cash next week. Use the aging report as an investigation list and a starting balance, then add receipt assumptions.

Make the collection assumptions explicit

Suppose a hypothetical aging report contains $20,000 current, $10,000 one to 30 days overdue, and $5,000 more than 30 days overdue. For the next month's forecast, the business assumes collection of 80%, 60%, and 20% of those respective bucket balances. Expected receipts are $16,000, $6,000, and $1,000, totaling $23,000.

These percentages describe expected timing within the selected month. They are hypothetical, not default recovery rates. The remaining $12,000 has not automatically become a loss: it may arrive later, remain disputed, or require a separate collectibility assessment. Do not treat the complement of a one-month collection share as a permanent write-off rate.

Override buckets for important invoices

A confirmed $8,000 payment promise inside the current bucket may deserve its own dated row. Remove that invoice from the bucket before applying the general percentage to the remaining balance. Otherwise the forecast can include both the specific receipt and a proportional share of the same invoice.

Separate credits, returns, disputed service amounts, and partial payments. A customer who agrees to pay $2,000 now and $3,000 later should appear in both periods with the original invoice balance reconciled. A single expected date for the entire invoice would overstate near-term cash or delay cash that is already agreed.

Learn from the prior forecast

Compare actual collections with the earlier assumptions by bucket and customer. Distinguish a receipt that moved into the next month from an invoice whose expected collectible amount changed. Track the reason for large misses so the next forecast improves through evidence rather than arbitrary percentage changes.

The final schedule should reconcile opening receivables, new invoices, collections, credits, and closing receivables. Probabilistic receipts are planning estimates, not guaranteed deposits. For a near-term payment decision, inspect the actual invoices and settlement dates behind the total. Accounting allowances and collection rights require their own treatment; this worksheet only organizes the business's cash expectations.

Method references: OpenStax: Prepare Financial Budgets. Accessed October 22, 2026. All dollar figures are hypothetical worked examples.