The AR Aging Report

AR is accounts receivable: the money clients owe you on invoices you’ve already sent but haven’t been paid for yet. The AR Aging report lines up every outstanding invoice by how overdue it is, so at a glance you can see who owes you, how much, and how long it’s been sitting. That’s the difference between a bill that’s a week late and one that’s been ignored for three months.

It answers the question every firm asks at the end of the month: who do I need to chase, and who first?

The Aging Buckets

Each unpaid invoice falls into a bucket based on days past its due date:

• Current is recently due, under 31 days.
• 31 to 60 days is slipping, and worth a reminder.
• 61 to 90 days is a real problem, and time for a call.
• 90+ days is seriously overdue. These are the invoices most at risk of never being paid.

Grouping receivables this way is the standard collections move: the older a balance gets, the less likely it is to be collected, so the 90+ column is where your attention earns its keep.

Reading the Report

The report lists each outstanding invoice with its client, invoice number, due date, balance, and days overdue, sorted by days overdue by default so the worst offenders are at the top. You can sort by any column, and filter down by client, by the attorney or biller responsible, or by a minimum balance to hide the small stuff and focus on the dollars that matter.

A chart across the top shows your top ten clients by total receivable, with each bar stacked by bucket, so a client whose bar is mostly dark (90+) jumps out before you even read the table.

Exporting

You can export the whole report to Excel or PDF, which is handy for a collections work list, a partner meeting, or handing your bookkeeper the month’s chase list.

Who Can See It

The AR Aging report is available to your bookkeeper, your attorneys, and your office manager: the people who actually work collections and watch cash flow. It reads from your finalized, unpaid invoices, so it always reflects what’s genuinely owed right now.