N O T I C E
MSPbots WIKI is moving to a new home at support.mspbots.ai to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here
for more info!
Page History
Table of Contents
This package requires ConnectWise Manage and Xero integrations.
MSP Finance Team Financial Metrics Dashboard
The MSPFinance Dashboards Package is available to MSPBots users with ConnectWise Manage integration. This dashboard gives user a complete overview of the company's financial performance by providing reports on Expense and Revenue margins, Normalized EBITDA, Billable Professional Revenue and Utilization. These will give useful insights to enable Management in identifying financial problems quickly and implementing the necessary solutionsThis dashboard provides insights on a company's overall profitability and efficiency using data on Expenses, Revenue, Labor Hours, and Labor Costs. This aims to enable Business Owners and Service Managers to identify issues faster so that timely solutions can be implemented.
This dashboard can be filtered by Date Range. Users can drill through most widgets to view more details and/or breakdowns.
Widget Name | Type | Description | Calculations | Sources for Calculations | ||||
---|---|---|---|---|---|---|---|---|
Gross Margin | Card Number | A card number showing the overall Gross Margin for the last 6 months including current monthselected date range. Gross Margin is Revenue minus Cost of Goods Sold (COGS) which is expressed here as a percentage of Revenue. Data available is for the last 6 months including current month. | (Total Revenue - Total COGS) / Total Revenue |
| ||||
Expense Margin | Card Number | A card number showing the overall Expense Margin for the last 6 months including current monthselected date range. Expense Margin is the ratio of Expenses and Revenue. Data available is for the last 6 months including current month. | Total Expenses / Total Revenue |
| ||||
Debtor amount over 60 days as % of debt | Card Number | A card number showing the total amount of debts Debts ageing for more than 60 days. Uses Shows data for the last 9 months including current monthselected date range. Computed as the ratio of significantly overdue invoices and all aged receivablesOverdue Invoices and all Aged Receivables. Data available is for the last 9 months including current month. | Total of Invoices ageing over 60 days / Total Aged Receivables (Note: data used are values as of 1st day of the month) |
| ||||
Normalized EBITDA - Last 6 Months | Grid | A table showing Normalized Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) for each of the last 6 months.Normalized earnings before interest, taxes, depreciation, and amortization. Normalization method: Data available is for the last 6 months. | Revenue + ITDA - Expense - COGS - Contrib Contributions & Drawdown |
| ||||
Gross Margin - Last 6 MonthsTrend | Line ChartLine | Chart showing A line chart showing the trend of Gross Margin trend for the last 6 monthsUses Gross Margin data for last 6 months. | (Total Revenue - Total COGS) / Total Revenue |
| ||||
% Billable Professional Utilization - Last 6 Months | Grid | Percentage A table showing the percentage of Billable Professional paid hours Hours that are logged as billable hours% Utilization = Total Billed hours billable for each of the last 6 months. | Total Billable Hours / Total Worked hours |
| Utilization daily time entry billable hourTeams: Utilization-Daily Total Work
| |||
% Billable Professional Utilization | Progress Tracker | Shows % Utilization of billable professionals for period (in slicer) | Uses Gross Margin data A progress tracker showing the % Billable Professional Utilization for the selected perioddate range. |
| ||||
% Billable Professional Utilization Trend | Line Chart | A line chart showing the trend of % Billable Professional Utilization for the last 6 months. | ||||||
Total, Service, and Non-Service Revenue Trend | Column and Line Chart | A mixed chart displaying the Service and Non-Service Revenues through columns and the Total Revenue through a line graph. | Non-Service Revenue = Total Revenue - Service Revenue | Service Revenue per Billable Professional - Last 6 Months | Grid | Shows efficiency by computing for revenue generated per billable professional | Total Service Revenue / Count of Billable Professional |
|
Revenue per Seat - Last 6 Months | GridShows generated revenue per seat/unit | A table showing the ratio of Revenue and # of Seats. | Total Revenue / | (Number of units +Number of seats | )
| |||
Revenue per Seat Trend | Line Chart | A line graph showing the trend of Revenue per Seat for the last 6 months. | ||||||
Avg. Billable Professional Compensation - Last 6 Months | GridShows average compensation paid to billable professionals | A table showing the Average Compensation per Billable Professional for each of the last 6 months. | (Direct Wages + PAYE) / Count of Billable Professional *Uses Direct Wages | for in calculation | as since PAYE in | mapping dataset is 0 |
| (while PAYE data is still 0)
|
Avg. Billable Professional Compensation Trend | Line Chart | A line graph showing the trend of Average Billable Professional Compensation for the last 6 months. | ||||||
Service Revenue per Billable Professional | Grid | A table showing the average Service Revenue generated per Billable Professional for each of the last 6 months. | Total Service Revenue / Count of Billable Professional |
| ||||
Service Revenue per Billable Professional Trend | Line Chart | A line graph showing the trend of Service Revenue per Billable Professional for the last 6 months | ||||||
Service Revenue to Direct Labor Ratio - Last 6 MonthsWages | Grid | Ratio to determine A table showing the ratio of Service Revenue relative to cost of the compensation for Billable Professionals | Service Revenue / (Direct Wages + PAYE) *Uses Direct Wages | for in calculation | as since PAYE in | mapping dataset is 0 |
| (while PAYE data is still 0)
|
Service Revenue as % of Total | Bar Graph | Shows trend of total revenue and % of service revenue | Service Revenue / Total Revenue | to Direct Wages Trend | Column and Line Chart | A mixed chart showing the Service Revenue and Direct Wages through columns then their ratio through a line graph.Xero P&L (SLI-Mapped): MRR Revenue, Services One Time Revenue, Revenue |
MSP Finance Team Financial Benchmarks Dashboard
The MSPFinance Dashboards Package is available to MSPBots users with ConnectWise Manage integration. This dashboard gives user a complete overview of the company's financial performance by providing reports on Expense and Revenue margins, Normalized EBITDA, Billable Professional Revenue and Utilization. These will give useful insights to enable Management in identifying financial problems quickly and implementing the necessary solutions.
This dashboard can be filtered by Date Range. Users can drill through most widgets to view more details and/or breakdowns.
Widget Name | Type | Description | Calculations | Sources for Calculations |
---|---|---|---|---|
Gross Margin | Card Number | Gross Margin is Revenue minus Cost of Goods Sold (COGS) which is expressed here as a percentage of Revenue. (default date range is Last 30 days) | (Total Revenue - COGS) / Total Revenue |
|
Expense Margin | Card Number | Expense Margin is a ratio of Expenses and Revenue (default date range is Last 30 days) | Total Expenses / Total Revenue |
|
Debtor amount over 60 days as % of debt | Card Number | Ratio of significantly overdue invoices to all aged receivables (default date range is Last 30 days) | Total of Invoices over 60 days / Total Aged Receivables (Note: data as of 1st day of the month) |
|
Normalized EBITDA - Last 6 Months | Grid | Normalized earnings before interest, taxes, depreciation, and amortization. Normalization method: | Revenue + ITDA - Expense - COGS - Contrib & Drawdown |
|
Gross Margin - Last 6 Months | Line Chart | Line Chart showing Gross Margin trend for last 6 months | Uses Gross Margin data for last 6 months |
|
% Billable Professional Utilization - Last 6 Months | Grid | Percentage of Billable Professional paid hours that are logged as billable hours | % Utilization = Total Billed hours / Total Worked hours |
|
% Billable Professional Utilization | Progress Tracker | Shows % Utilization of billable professionals for period (in slicer) | Uses Gross Margin data for the selected period. |
|
Service Revenue per Billable Professional - Last 6 Months | Grid | Shows efficiency by computing for revenue generated per billable professional | Total Service Revenue / Count of Billable Professional |
|
Revenue per Seat - Last 6 Months | Grid | Shows generated revenue per seat/unit | Total Revenue / (Number of units + Number of seats) |
|
Avg. Billable Professional Compensation - Last 6 Months | Grid | Shows average compensation compensation paid to billable professionals | (Direct Wages + PAYE) / Count of Billable Professional *Direct Wages for calculation as PAYE in mapping is 0 |
|
Service Revenue to Direct Labor Ratio - Last 6 Months | Grid | Ratio to determine Service Revenue relative to cost of Billable Professionals | Service Revenue / (Direct Wages + PAYE) *Direct Wages for calculation as PAYE in mapping is 0 |
|
Service Revenue as % of Total | Bar Graph | Shows trend of total revenue and % of service revenue | Service Revenue / Total Revenue |
|
...