Provides performance metrics on how your business is performing, such as how much WIP can be invoiced, the average number of days until invoices are paid, the value of write ons/offs, and revenue. The data shows the current month and the previous three months, plus the year-to-date total.
Use this report when your business invoices are based on actual time and cost.
The report can give you an overview of how well your business is performing this quarter and allow you to drill down into the metrics to group performance by job managers, partners, and clients.
The Write Offs/Write Ons, Average Revenue per Client, and Revenue metrics can be drilled down further to show the related job and client.
This report displays:
- WIP days
- Debtor days
- Lock up days
- Average hourly rate
- Write offs / Write ons
- Revenue per Director/Partner
- Revenue per fee earner
- Revenue per FTE
- Average revenue per client, and revenue.
Each figure is grouped monthly for the last four months and year-to-date (YTD).
The YTD is determined by the Financial Year End setting in Organisation Settings. Revenue per Director/Partner, Fee Earner, or FTE is set in the staff record under Staff Settings.
The KPI dashboard metrics are refreshed overnight, the report does not update in real time. Click on the tiles above the report to return to previously viewed metrics or click on 'KPI Headline' to return to the report.
WIP Days: The drilldown will show the WIP Days per [Client] Client Manager. WIP day is number of days from a WIP being created to be invoiced. We will apply formula as follows: WIP Days = ((Start of month WIP + end of month WIP) / 2 ) / Invoiced for month * Days in month. For Current Month: ((Start of month WIP + Current WIP) / 2 ) / Invoiced for the month * [No. of days from month start to current date]
Debtor Days: The drilldown will show the Debtor Days per [Client] Client Manager. Aged/Debtor Days = ((Start of month AR + end of month AR) / 2 ) / Paid for month * Days in month. For Current Month: ((Start of month AR + Current AR) / 2 ) / Paid for the month * [No. of days from month start to current date] AR: Account Receivables, i.e. Awaiting Payment, invoice outstanding
Lock up Days: WIP Days + Debtor Days
Average Hourly Rate: Amount Invoiced / Billables Hours worked. The drilldown will show the Average Hourly Rate per Client: Client Manager as well as for each client. Client Average Hourly Rate = Total Amount Invoiced per client per month / Total Hours worked per client per month
Write Offs / Write Ons: Amount Invoiced - Billable Amount. The drilldown will show the Write Offs / Write Ons per [Client]: Client Manager as well as per Job: Job Manager. The 2nd level drilldown will show the Write On/Off per job, with the hyperlink to the specific job.
Revenue per Director/Partner: Amount Invoiced / Number of Staff with the Director/Partner KPI flag
Revenue per Fee Earner: Amount Invoiced / Number of Staff with the Fee Earner KPI flag
Revenue per FTE: Amount Invoiced / Sum of the percentages of Full-time Equivalent (FTE) staff. Two staff at 50% FTE will be treated as 1 FTE for the purposes of the metric calculations. Employees not currently working will be counted as 0% regardless of the FTE values.
Average Revenue per Client: Amount Invoiced / Distinct number of Clients. The drilldown will show the revenue per client as well as the overall average for the practice. For each client amount you can drill down to show the actual invoices, with hyperlink to the exact invoice page.
Revenue: Total revenue for the practice. The drilldown will show the revenue per Client: Client Manager as well as per Job: Job Manager. For each amount you can drill down to show the actual invoices, with hyperlink to the exact invoice page.
The KPI Dashboard is only available to users on the Pro and Advanced tier.