◆ Free Tool

AR Aging Health Check

Enter your receivables by customer and aging bucket. Get instant analysis — weighted average days outstanding, concentration risk, and actionable flags.

Enter your AR aging data

Add each customer and their outstanding balances by aging bucket. Leave cells blank or zero for buckets with no balance.

Customer Current 31–60 61–90 91–120 120+
AR Health Score
Total AR
Weighted Avg Days
outstanding
Over 90 Days

Aging distribution

Customer concentration & risk

Customer Total AR % of Total Wtd Avg Days Risk

Analysis flags

Turn this into a 13-week collection forecast

This health check shows you where you stand. Our AR Collection Forecaster shows you where you're headed — with customer-level projections, slow-payer detection, and a board-ready dashboard.

Get the AR Forecaster — $149
One-time purchase. No macros. Works in Excel, Google Sheets & Excel Online.