Online help
Overdue reporting »

What is the aging balance report?

The aging balanceLink 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.

late invoices report

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:

Late payments

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.

aging report

It is possible to « Group results » by collector and by any customer analytical field:

aging report

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:

Rapport BA

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!

Rapport BA
← Back : Online help » Various questions