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
...
Widget Name | Description | Calculations | Sources for Calculations |
---|---|---|---|
Gross Margin | A card number showing the overall Gross Margin for the selected 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 | A card number showing the overall Expense Margin for the selected 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 | A card number showing the total amount of Debts ageing for more than 60 days. Shows data for the selected date range. Computed as the ratio of Overdue 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 | A table showing Normalized Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) for each of the last 6 months. Normalization method: Data available is for the last 6 months. | Revenue + ITDA - Expense - COGS - Contributions & Drawdown |
|
Gross Margin Trend | A line chart graph showing the trend of Gross Margin for the last 6 months. | (Total Revenue - Total COGS) / Total Revenue |
|
% Billable Professional Utilization | A table showing the percentage of Billable Professional Hours that are billable for each of the last 6 months. | Total Billable Hours / Total Worked hours |
|
Billable Professional Utilization | A progress tracker showing the % Billable Professional Utilization for the selected date range. | ||
% Billable Professional Utilization Trend | A line chart showing the trend of % Billable Professional Utilization for the last 6 months. | ||
Total, Service, and Non-Service Revenue Trend | A mixed chart displaying the Service and Non-Service Revenues through columns and the Total Revenue through a line graph. Data shown is for the last 6 months. | Non-Service Revenue = Total Revenue - Service Revenue |
|
Revenue per Seat | A table showing the ratio of Revenue and # of Seats of the last 6 months. | Total Revenue / Number of seats |
|
Revenue per Seat Trend | A line graph showing the trend of Revenue per Seat for the last 6 months. | ||
Avg. Billable Professional Compensation | 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 in calculation since PAYE in dataset is 0 |
|
Avg. Billable Professional Compensation Trend | A line graph showing the trend of Average Billable Professional Compensation for the last 6 months. | ||
Service Revenue per Billable Professional | 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 | A line graph showing the trend of Service Revenue per Billable Professional for the last 6 months | ||
Service Revenue to Direct Wages | A table showing the ratio of Service Revenue relative to the compensation for Billable Professionals for each of the last 6 months. | Service Revenue / (Direct Wages + PAYE) *Uses Direct Wages in calculation since PAYE in dataset is 0 |
|
Service Revenue to Direct Wages Trend | A mixed chart showing the Service Revenue and Direct Wages through columns then their ratio through a line graph. Data shown is for the last 6 months. |
MSP Finance Team Financial Benchmarks Dashboard
ThThis dashboard makes use of historical data of all MSPs to provide companies with a benchmark for their financial metrics. For each metric, a company's performance is shown side by side with the Bottom 1/4 Average, Median, and Best in Class (BIC) Average.
This dashboard can be filtered by Date Range. Users can drill through most widgets to view more details and/or breakdowns.
Widget Name | Description | Calculations | Sources for Calculations | |||||
---|---|---|---|---|---|---|---|---|
MSPF Benchmark - Gross Margin generated per $1 SalesGross 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 | Expense Margin is a ratio of Expenses and RevenueTotal Expenses / Total Revenue |
| Debtor amount over 60 days as % of debt
| Normalized EBITDA - Last 6 Months | Normalized earnings before interest, taxes, depreciation, and amortization.Revenue + ITDA - Expense - COGS - Contrib & Drawdown |
|
Gross Margin - Last 6 Months | Line Chart showing Gross Margin trend for last 6 months | Uses Gross Margin data for last 6 months |
| |||||
% Billable Professional Utilization - Last 6 Months | Percentage of Billable Professional paid hours that are logged as billable hours | % Utilization = Total Billed hours / Total Worked hours |
| |||||
% Billable Professional Utilization | 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 | Shows efficiency by computing for revenue generated per billable professional | Total Service Revenue / Count of Billable Professional |
| |||||
Revenue per Seat - Last 6 Months | Shows generated revenue per seat/unit | Total Revenue / (Number of units + Number of seats) |
| |||||
Avg. Billable Professional Compensation - Last 6 Months | Shows average 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 | 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 |
| |||||
A card number showing the overall Gross Margin generated per $1 of Sales/Marketing Cost for the selected date range. | ||||||||
MSPF Benchmark - Blended Gross Margin % | A bar graph providing a benchmark for Gross Margin. Data is shown per month for the selected date range. | [Revenue (Product + Services) - COGS] / Revenue | ||||||
MSPF Benchmark - Service Gross Margin % | A bar graph providing a benchmark for Service Gross Margin. Data is shown per month for the selected date range. | (Service Revenue - Services COGS)/ Service Revenue | ||||||
MSPF Benchmark - Product Gross Margin % | A bar graph providing a benchmark for Product Gross Margin. Data is shown per month for the selected date range. | (Product Revenue - Product COGS) / Product Revenue | ||||||
MSPF Benchmark SG&A % | A bar graph providing a benchmark for Selling, General and Administrative Expense (SG&A) as a % of Total Costs. Data is shown per month for the selected date range. | SG&A / Total Costs | ||||||
MSPF Benchmark - Sales Cost % | A bar graph providing a benchmark for Sales Costs as a % of Total Costs. Data is shown per month for the selected date range. | Sales Costs / Total Costs | ||||||
MSPF Benchmark G&A Cost% | A bar graph providing a benchmark for General and Admin Expenses as a % of Total Costs. Data is shown per month for the selected date range. | General and Admin Expenses / Total Costs | ||||||
MSPF Benchmark - EBITDA % | A bar graph providing a benchmark for Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) as a % of Total Revenue. Data is shown per month for the selected date range. | EBITDA / Total | Service Revenue as % of Total | Shows trend of total revenue and % of service revenue | Service Revenue / Total Revenue | Xero P&L (SLI-Mapped): MRR Revenue, Services One Time Revenue, Revenue |