What is a collection aging report?

A collection aging report tracks the status of collection efforts on overdue invoices, showing which accounts have been contacted, when, and what responses have been received. For professional service firms, collection aging extends beyond simple AR aging to document the collection process, enabling systematic follow-up and identifying accounts that require escalation. The report supports disciplined collection activity and accountability.

Key characteristics

• Tracks collection activities on overdue accounts

• Documents contact dates, methods, and responses

• Identifies accounts requiring escalation

• Supports systematic collection and follow-up

• Creates accountability for collection efforts

• Should be reviewed weekly during collection meetings

Why it matters for professional service firms

AR aging shows how old invoices are; collection aging shows what you are doing about it. Without collection tracking, overdue accounts may sit without action, or different staff may duplicate efforts. Collection aging reports ensure that every overdue account has documented activity, that responses are noted, and that escalation occurs when needed. Professional service firms should review collection aging weekly, confirm activity on all significant overdue accounts, and decide on escalation for nonresponsive clients.

Real-world example

Brian's firm had AR aging but no collection tracking. Overdue accounts received sporadic attention depending on who remembered. Implementing collection aging: AR aging plus columns for last contact date, contact method, response summary, and next action date. The weekly collection meeting reviewed the report, assigned follow-up actions, and escalated accounts that received no response after multiple contacts. Results: no overdue accounts went more than 1 week without documented activity; collection improved (consistent follow-up worked); and problem accounts were identified earlier for partner involvement or write-off consideration. Average DSO improved by 8 days through systematic collection enabled by tracking.