Company Dashboard reports

Last updated
Save as PDF

Learn about the reports you find in the company dashboard. This dynamic dashboard shows the distribution of overdue invoices across aging buckets on an account level. You can use this information to understand the financial health of individual accounts and to identify and mitigate potential risks.

While the AR Aging screen offers insights at the account level, the company dashboard provides a comprehensive view of the entire accounts receivable portfolio. By segmenting overdue invoices into aging buckets, ranging from current to severely delinquent, businesses gain insights into payment trends and can prioritize collection efforts accordingly.

You can filter the information presented in the dashboard by your company, your customers, or your team.

Report	Description	Actions
Overdue invoices by aging buckets	Shows the distribution of overdue invoices across aging buckets from a customer account level. Aging buckets range from current to severely delinquent. This breakdown helps you gain insight into payment trends of individual accounts so that you can prioritize appropriate collection efforts and mitigate financial risks.	Click into a bucket to see a list of the customers who fall into that aging category.
Receivables by invoice status	Shows the distribution of customers according to their invoice status as a pie chart.	Click into a pie slice to see a list of customers who fall into that invoice status. Click a status in the legend to filter it from the chart; click again to add it back.
Receivables by collection status	Shows the distribution of customers according to their collection status as a pie chart.	Click into a pie slice to see a list of customers who fall into that collection status. Click a status in the legend to filter it from the chart; click again to add it back.
Disputed invoices by type	Shows the distribution of invoices according to the reason for dispute.	Click into a pie slice to see a list of invoices that fall into that type of dispute. Click a dispute type in the legend to filter it from the chart; click again to add it back.
Receivables by follow up status	Shows the distribution of collection activities conducted for all customers as a percentage of the total customer base, allowing you to gauge the extent of engagement across different follow-up statuses. The graph incorporates outstanding balances against customers targeted by these activities and the total open invoices at the account level. This breakdown helps you understand which actions were taken for a specific group of customers and the corresponding outstanding balances pursued through these actions.	Click into a follow-up status to see a list of the customers engaged with using that follow-up activity.
Email follow-up drill down	Shows your total debtors compared with the status of follow-up activities, with a focus on email interactions. The funnel graph aggregates data from various sources to visualize the total number of debtors in the system, segmented by factors such as overdue amounts, payment history, and customer profiles.	Hover over an activity in the funnel to view more information, for example, the total of customers and invoices that fall within that activity category. Click an activity in the funnel to filter it from the chart; click again to add it back.
List of pending issues	Shows a list of open and unresolved activities for various customers. Each pending issue in the list provides an overview for you to take action.	Click View Thread to drill into the details of the issue, including the collections activities that have been completed.
Flagged invoices	Shows a list of flagged invoices that require action.
Top debtors	Shows the top debtors based on outstanding or overdue amounts, indicating key accounts that require attention. The report also includes the last payment amount received from each debtor, providing additional context for prioritization.	Click any debtor to navigate to the customer details page for comprehensive insights into their account history, payment patterns, and any relevant notes.
Cash flow trends and forecast	Access from the Analysis sub-tab of the company dashboard, the graph provides a comprehensive overview of various cashflow components, facilitating informed decision-making and strategic planning.
Days sales outstanding (DSO) trend	Access from the Analysis sub-tab of the company dashboard, the graph shows a trend of DSO.There are two methods used to calculate this: The Countback Method provides high accuracy by relying on recent monthly sales figures, directly linked to the outstanding balance. Each month’s sales figures are sequentially deducted from the total balance, ensuring that every sale aligns closely with the account balance. The Simple Method calculates DSO by evaluating the relationship between total sales and total receivables over a specific time period, providing a straightforward overview of how efficiently a company is collecting its receivables. In this case, DSO = (Total Sales/Total Receivables) × No. of Days.	To select a DSO calculation method, navigate to Settings -> Collection Management -> DSO Config.
Collectors' performance	Use this information to examine individual collectors' performance metrics. Access from the Collector's Performance sub-tab of the company dashboard, the graph compares several key metrics, including Other Charges (such as bank charges, tax withholdings, and foreign exchange fees), Expected Cashflow (based on agreed payment terms), Predicted Cashflow, and Best Possible Cashflow (assuming prompt payments on all invoice due dates).