Sales by Customer: This report shows how much each customer has spent with your business over time. This can be helpful in understanding which customers are your most valuable and loyal customers.
DSO Report: DSO is a measure of the number of days it takes your company to collect payments from its customers. This metric is important because it can impact your company’s cash flow. A high DSO means that it takes your company longer to collect payments, which can put strain on your cash flow. Additionally, a high DSO can indicate that your customers are not paying their invoices on time, which could lead to financial problems for your company.
Top Debtors List: This provides the list of top 20 delinquent customers by balance.
Invoice Disputes: This provides the list of outstanding invoices for which a dispute has been raised by a client.
CEI: The Collections Effectiveness Index is a popular metric across industries that gives Order to Cash leaders a better understanding of how their A/R teams perform. The CEI is calculated by taking the number of days an invoice is outstanding and dividing it by the total number of days in the billing period. This metric is used to measure the performance of Accounts Receivable teams and to benchmark their performance against other companies in their industry. The CEI is a valuable metric for Accounts Receivable leaders because it provides insight into team productivity and trends over time. Additionally, the CEI can be used to benchmark the performance of Accounts Receivable teams against other companies in their industry. This metric is helpful for identifying areas of improvement for Accounts Receivable teams and for setting goals and targets.
INVOICE COHORT: In essence, an Invoice cohort tracks groups of invoices that were issued in the same month. This allows you to see which invoices are being paid on time and which ones are not. By tracking this information, you can make adjustments to your process to improve your cash collection. Receivables cohorts show you how quickly customers are paying their invoices. There are a few different ways to set up billing cohorts. The most common is to group invoices by the month they were issued. So, all invoices issued in January would be tracked together, all invoices issued in February would be tracked together, and so on.