Global AR overview

This page provides a global view of organisation’s Accounts Receivable. This is the balance of money owed by clients, but not yet paid for.
AR report helps determine the effectiveness of credit and collection functions and identifies existing irregularities in the collection process.

AR aging report contains a list of:

  • Clients’ unpaid invoices
  • Showing the total Accounts Receivable balance split into several aging buckets

The first two columns are Balance (total outstanding balance) and* Current* (receivables not due for payment yet).

Balance is a sum of all aging buckets including the Current one:

The table below explains the columns in the matrix

Please note that the above mentioned buckets are just an example of how they can be defined. Users can set up and manage user-defined aging period definitions in evergreen using the form *‘Aging
period definitions’*.
The form can be found on this path: in Account payable > Setup or Credit and collections > Setup.

Note that any change in one of these forms will be reflected in the other, so there is no need to make adjustments on both sides.

To activate a different period, the following steps must be taken: BI Setup > Populate ageing period dimension table

For more details on how to enter unit and interval information on the Periods tab in the form, please refer to the Microsoft documentation.

The product itself is capable of enhancing the model and PBI reports based on the changes in evergreen, without any developer support. In this way, the users are able to change the aging period definitions independently based on their needs.

Each aging period that you set up for the aging period definition corresponds to a column in GlobalAging report:


By expanding more levels in the matrix, we can drill down from Company view to Client Group, Clientand Invoice of the specific client.

Three visuals at the bottom of the page are used to highlight:

  • Share of each bucket in the total AR Balance
  • Overdue AR per company (provided that more than one entity is selected in the Company slicer)
  • Top list of 5 clients with the highest total Overdue AR (sum of all buckets’ AR excluding the Current bucket)

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment