What is backlog aging analysis?

Backlog aging analysis examines contracted but undelivered work by the length of time contracts have been in backlog, identifying stale contracts that may not convert to revenue. For professional service firms, backlog represents future revenue, but aged backlog may indicate projects stuck in client limbo, scope issues, or contracts that will eventually be canceled. Regular aging review ensures backlog quality and realistic revenue expectations.

Key characteristics

• Categorizes backlog by contract age

• Identifies stale or at-risk contracts

• Reveals conversion timing patterns

• Should trigger a review of aged items

• Affects the reliability of revenue forecasts

• Distinguishes healthy from problematic backlog

Why it matters for professional service firms

Not all backlog converts to revenue. A contract signed 18 months ago is still sitting in backlog, likely has issues: client priorities changed, scope needs renegotiation, or the project is effectively dead. Backlog aging surfaces these problems. Professional service firms should review backlog aging monthly, investigate contracts over 6 months old, and update revenue forecasts to reflect realistic conversion expectations rather than treating all backlog as guaranteed future revenue.

Real-world example

Marcus's firm reported $1.8M backlog without aging analysis. Review revealed: 0 to 3 months: $650K (healthy, actively scheduling); 3 to 6 months: $480K (mostly normal, some delays); 6 to 12 months: $420K (concerning, needs investigation); over 12 months: $250K (likely problematic). Investigation of aged backlog: $180K had client changes making projects unlikely; $85K had unresolved scope disputes; $45K were zombie contracts with no activity, adjusted realistic backlog: $1.3M. Revenue forecasts updated accordingly, preventing disappointment from counting uncollectible backlog.