Accounts Payable & Receivable › Aging Analysis
How can you forecast cash collections from an aging report?
AdvancedAnswer
Apply historical collection-probability curves to each bucket (e.g., current pays ~95% next month, 31-60 ~70%) to project when outstanding balances will convert to cash. Layering these roll-rates over the aging produces a weekly/monthly cash-inflow forecast that treasury uses for liquidity planning.
Expected next-period cash = sum(bucket balance x expected pay rate).
E.g., 100k current x 95% + 30k (31-60) x 70% = 95k + 21k = 116k.Real-world example Applying roll-rates to the aging gives treasury a reliable projection of next month's receipts for cash planning.