Accessing the Analytics Page
To access the Analytics page, navigate to the Cash Collect module and select Analytics from the sidebar.
Understanding Key Figures
The Analytics page displays several key figures to keep track of your invoices:
Outstanding Amount
The Outstanding Amount graph shows the proportion of your invoices that are Not Due versus those that are Due:
Not Due: Invoices with a payment date in the future.
Due: Invoices with a payment date today or in the past.
This visualization helps you quickly identify the total amount expected in the future and the amount that requires immediate attention.
Aging Balance
The Aging Balance histogram categorizes your due invoices based on how long they have been outstanding. The categories are:
Not Due: Payment date is in the future.
0-30 days: Invoices due within the last 30 days.
31-60 days: Invoices due between 31 and 60 days ago.
61-90 days: Invoices due between 61 and 90 days ago.
91+ days: Invoices due more than 91 days ago.
Each segment of the graph is clickable, allowing you to view the specific invoices in that category. ✔️
Main Debtors
The Main Debtors table ranks your clients based on the amount they owe you. This helps you identify the clients with the highest outstanding amounts so you can prioritize your follow-ups.
Days Sales Outstanding (DSO)
The Days Sales Outstanding (DSO) represents the average number of days it takes for your company to receive payment after a sale. It is calculated over time and can help you assess the efficiency of your collections process.
💡 Note: The DSO table will appear after at least one month of usage for the first element and after three months for the complete table. You also need an amount of paid invoices greater than the current outstanding amount.
💡 Tips
Interactive Graphs: Click on any part of the graphs to navigate directly to the list of relevant invoices. ✔️
Prioritize Collections: Use the Aging Balance and Main Debtors to focus on overdue invoices and key clients.
Monitor DSO: Regular tracking of your DSO can help identify trends and improve your cash flow management.
Q&A ❓
How is the DSO Calculated?
The DSO is calculated using the following formula:
This represents the average number of days it takes to collect payment after a sale. Regular monitoring can help you improve cash flow management.
Why Can't I See the DSO Table?
The DSO table becomes available after at least one month of usage and requires that the amount of paid invoices is greater than the current outstanding amount. If you have just started using Agicap, the DSO data will populate over time.