Management Reporting | AR Aging
Aging, with the customer to call today.
Current, 1 to 30, 31 to 60, 61 to 90 and over 90, with the DSO trend behind it, customer concentration by exposure and by age, and collection performance per owner. Every number drills to the open invoice and that customer’s payment history, so the call is informed before it is made.
What the system does
Capability, input, output.
| Capability | Input | Output |
|---|---|---|
| Aging buckets | Open invoices with their due dates | The standard buckets, per customer and in total |
| DSO and trend | Invoices and receipts over time | Where days sales outstanding is going, not just where it is |
| Priority list | Exposure, age and payment behaviour | Who to call today, rather than an alphabetical ledger |
| Concentration | Balances by customer | Where one customer is the receivable risk |
| Collector performance | Activity and outcomes per owner | What is being worked and what is being collected |
| Drill-through | Any bucket or figure | The open invoices, the disputes and the payment history behind it |
| Provision view | Aged balances and history | The expected credit loss position, computed rather than estimated |
-
Aging buckets
- Input
- Open invoices with their due dates
- Output
- The standard buckets, per customer and in total
-
DSO and trend
- Input
- Invoices and receipts over time
- Output
- Where days sales outstanding is going, not just where it is
-
Priority list
- Input
- Exposure, age and payment behaviour
- Output
- Who to call today, rather than an alphabetical ledger
-
Concentration
- Input
- Balances by customer
- Output
- Where one customer is the receivable risk
-
Collector performance
- Input
- Activity and outcomes per owner
- Output
- What is being worked and what is being collected
-
Drill-through
- Input
- Any bucket or figure
- Output
- The open invoices, the disputes and the payment history behind it
-
Provision view
- Input
- Aged balances and history
- Output
- The expected credit loss position, computed rather than estimated
AR Aging and Collections FAQ
What buyers ask.
We already get an aging report from our accounting system. What is different?
Most of them tell you what is owed and stop. The useful question is who to call today, which needs exposure, age, payment behaviour and whether the invoice is in dispute considered together. That is a ranking, not a listing.
Can we see it by region or by owner rather than by customer?
Yes, and those are the cuts US teams usually want. Entity, region, sales owner and collector are all available on the same data.
How are disputed invoices handled?
Separated, because an invoice in dispute is not a collections problem and chasing it wastes the call. They are visible as their own population with the reason and the owner.
Does it help with the provision?
It computes the expected credit loss position from actual aging and payment history rather than a flat percentage by bucket, and shows the workings. Your auditor will ask for those.
Can collectors work directly in it?
Yes, with activity and promises recorded against the customer, so the history that informs the next call is built as a by-product rather than kept in someone’s notes.
More in Management Reporting
Related features
See who to call today.
Connect your books, free. Aging, exposure and payment behaviour resolve into a priority list from your real invoices.