Founder & CEO, Helcyon · Author, Before the Flatline · 25+ years operating across five continents
TAKEAWAYS
Shows how old your receivables are-30, 60, 90+ days
Older receivables are harder to collect and may become bad debt
Review aging weekly; act quickly on accounts sliding past 30 days
Definition
An aging report categorizes receivables or payables by how long they've been outstanding-typically in buckets like current (0-30 days), 31-60 days, 61-90 days, and over 90 days. It reveals the age distribution of balances, highlighting items that need attention. For receivables, aging shows collection patterns and identifies problem accounts. Older receivables are less likely to collect and more likely to require write-off. The aging distribution is a leading indicator of bad debt. For payables, aging shows payment patterns and identifies overdue obligations. Concentrated aging in older buckets may indicate cash problems or signal relationship strain with suppliers.
Formulas & Calculations
Aging Buckets: Current | 31-60 | 61-90 | 90+
Collection Probability decreases with age
Bad Debt Allowance often tied to aging percentages
$500K receivables aging: $350K current (70%), $80K 31-60 days (16%), $40K 61-90 days (8%), $30K 90+ (6%). The $70K over 60 days requires attention.
Real-World Scenario
Aging Deterioration
January aging: 85% current, 10% 31-60 days, 4% 61-90 days, 1% over 90 days. Healthy distribution.
June aging: 65% current, 15% 31-60 days, 12% 61-90 days, 8% over 90 days. Distribution shifted older.
What happened? Either customers started paying slower (market conditions? customer quality?), or collection efforts weakened (staff changes? process breakdown?). The aging report revealed the shift months before write-offs would force attention.
Why It Matters
Aging reports reveal collection and payment patterns. They show whether balances are fresh or stale, current or problematic.
Aging predicts bad debt. Receivables over 90 days old have much higher write-off rates than current balances. Aging informs reserve calculations.
Aging focuses collection efforts. Old receivables need more attention than current ones. Aging reports prioritize collection activity.
Aging trends are diagnostic. Deteriorating aging often precedes cash flow problems. The trend is often more important than the snapshot.
Business Application
Review aging reports weekly for receivables. Don't wait until month-end. Fresh aging enables timely collection action.
Investigate aging distribution changes. If aging shifts older, understand why. Customer problems? Process failures? Economic conditions?
Use aging to set bad debt reserves. Historical collection rates by aging bucket inform appropriate reserve levels.
Track aging trends over time. Compare distributions across periods. Gradual deterioration may not be obvious in any single report.
Reviewing aging only at month-end. By then, another month has passed. Weekly review enables earlier intervention.
About the author
Lukas Swid
Founder and CEO, Helcyon
Lukas Swid is the founder and CEO of Helcyon, author of Before the Flatline, and an operator with 25 years of business diagnostic experience across five continents.
He writes from the moment when the numbers stop behaving and owners need to know what is changing beneath the surface before the damage becomes obvious.
See Aging Report in action
Helcyon monitors your Business Vital Signs™ and shows how concepts like aging report affect your business in real time.
In practice, this rarely shows up cleanly in reports. Owners see tension between numbers that should align but do not. Cash moves differently than expected, and timing gaps start to widen. The pattern repeats across industries and revenue levels.
Why this creates risk
This condition introduces structural risk. It limits flexibility, compresses margins, and increases dependency on timing rather than control. Businesses that ignore this signal often face compounding pressure over 3 to 6 months.
Before it becomes obvious
Six months before this becomes a visible problem, the signals are subtle. Small delays. Slight shifts in ratios. Vendor behavior changes. These are easy to dismiss, but they are the early pattern Helcyon focuses on.
What to do this week
1. Review the last 60 days of financial activity.
2. Identify timing mismatches between inflows and outflows.
3. Establish a simple monitoring cadence tied to your Business Vital Signs.
Frequently asked questions
What does this metric actually tell me?
This depends on your business, but patterns over time matter more than single data points.
How often should I check this?
This depends on your business, but patterns over time matter more than single data points.
What is a warning sign?
This depends on your business, but patterns over time matter more than single data points.
