Online help
Overdue reporting »
What is the aging balance report?
The aging balance
is an key tool for collection management and performance evaluation. It shows what is the breakdown of receivable according to their age relative to their due date.
It highlights if the situation of accounts receivable is healthy (few late payments and especially no old overdue) or bad (high overdue with some of them very old).
It represents the aging brackets [Current | 0-30D | 31-60D | 61-90D | More 90D] for all your customers.
The aging balance can be filtered by:
It's possible to set the overdue %, in order to concentrate your efforts from a certain bracket:
The change done here is valid on the whole platform (global view, customer file indicators, etc.).
The Aging balance can be displayed at an earlier date with the « Situation on ... » button. This approach is particularly relevant to review the evolution of overdue from one day to the next and to observe developments on previous dates (for example, at the end of each month, or from one year to the next).
By default this list highlights the aging balance per customer that can be sorted and filtered in many ways to target clients on which you want to act.
For example, a descending sort on overdue more than 90 days will show customers who have unpaid bills for a long time with as consequences a high risk for the cash and the profitability of your business.
It is possible to « Group results » by collector and by any customer analytical field:
For a more dynamic, more precise reading, and to go even further in analyzing the depth of arrears, you can zoom onto the slice of your choice in the Aging Balance Report.
To proceed, go to the report's dedicated page, then click on the slice you wish to focus on:
On the graph, the selected slice is highlighted.
At the lower level, the table, the display of is delimited on the selected slice, allowing you to obtain the list of customers with outstandings on the targeted depth!
is an key tool for collection management and performance evaluation. It shows what is the breakdown of receivable according to their age relative to their due date.It highlights if the situation of accounts receivable is healthy (few late payments and especially no old overdue) or bad (high overdue with some of them very old).
The collection probability decreases rapidly with seniority of invoices. For example, invoices 90 days late are paid in only 70% of cases. And only 50% after 6 months.
The graph
It represents the aging brackets [Current | 0-30D | 31-60D | 61-90D | More 90D] for all your customers.
The aging balance bracket can be customized: up to 7 brackets and time slot can be changed. Contact-us for more information
The aging balance can be filtered by:
- Clients groups
- Internal actor (collector for example)
- Items status
- Item type
- Any custom field set as analytical
It's possible to set the overdue %, in order to concentrate your efforts from a certain bracket:
The change done here is valid on the whole platform (global view, customer file indicators, etc.).
The Aging balance can be displayed at an earlier date with the « Situation on ... » button. This approach is particularly relevant to review the evolution of overdue from one day to the next and to observe developments on previous dates (for example, at the end of each month, or from one year to the next).
The table
By default this list highlights the aging balance per customer that can be sorted and filtered in many ways to target clients on which you want to act.
For example, a descending sort on overdue more than 90 days will show customers who have unpaid bills for a long time with as consequences a high risk for the cash and the profitability of your business.
It is possible to « Group results » by collector and by any customer analytical field:
For a more dynamic, more precise reading, and to go even further in analyzing the depth of arrears, you can zoom onto the slice of your choice in the Aging Balance Report.
To proceed, go to the report's dedicated page, then click on the slice you wish to focus on:
On the graph, the selected slice is highlighted.
At the lower level, the table, the display of is delimited on the selected slice, allowing you to obtain the list of customers with outstandings on the targeted depth!
← Back : Online help » Various questions