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
The MSP Finance Team Financial Metrics and Benchmarks Suite Dashboards feature reports for each identified Key Performance Indicator (KPI) and benchmarking widgets to compare your company's metrics against industry standards over a selected period. These highlight how your company's performance compares with the MSP industry's benchmarking categories. You can filter values in the dashboards and drill through most widgets for breakdowns and to show more details.
The MSP Finance Team Financial Metrics and Benchmarks Suite requires ConnectWise Manage, Quickbooks, This package requires ConnectWise Manage and Xero integrations.
What's in this article:
| Table of Contents |
|---|
MSPF Aggregated and Monthly Dashboards
...
The MSP Finance Team Financial Metrics and Benchmarks Suite dashboards use the Service Leadership Index (SLI) to calculate metrics and benchmarks. Data are presented in aggregated and monthly reports so you can get insights from different levels of detail according to the specific needs and goals of your organization.
MSPF SLI Mapping Aggregate Dashboard
The MSPF aggregated dashboards put together data across a longer time period, such as a quarter or a year, to show a general overview of performance. Aggregated dashboards are useful in identifying overall trends in performance over time and show if your company's performance has been improving or declining during this period.
Below are examples of MSPF Aggregated Dashboards
MSPF SLI Mapping by Month Dashboard
The MSPF monthly dashboards present data over months to identify and analyze trends and patterns in SLI performance during shorter time periods. These dashboards are useful for identifying seasonal or cyclical patterns in your company's performance. It highlights if performance is consistently better or worse during certain months of the year.
MSP Finance Team Financial Metrics Dashboard
...
This dashboard provides insights on a into your company's overall profitability and efficiency using data on Expenses, Revenue, Labor Hours, and Labor Costs, Enabling Business Owners and Service Managers . As a business owner or service manager, you have a bird's eye view of the company's financial performance to . You can identify trends and issues for a more timely, informed, and effective decision making.This dashboard can be filtered by Date Range. Users can that are important in making informed and timely decisions. You can filter this dashboard by date range and drill through most widgets to view more details and the breakdown of calculations and more details.
Below are the available widgets in this dashboard.
Gross Margin
A The Gross Margin card number showing widget shows the overall Gross Margin gross margin for the selected date range and has a corresponding line graph showing that shows the trend of Gross Margin for the last 6 months.
Gross Margin is Revenue minus Cost of Goods Sold (COGS) expressed as a percentage of Revenue: (Total Revenue - Total COGS) / Total Revenue.
Data source: Xero P&L (SLI-Mapped) - for Revenue, COGS
Expense Margin
A The Expense Margin card number showing shows the overall Expense Margin expense margin for the selected date range. Expense Margin It is the ratio of Expenses and Revenue: Total Expenses / Total Revenue.
Data source: Xero P&L (SLI-Mapped) - for Revenue, Expenses
Debtor amount over 60 days as % of
...
Receivables
The Debtor amount over 60 days as % of Receivables
...
A card number showing shows the total amount of Debts ageing debts aging for more than 60 days. Shows data for The data shown on this widget adjusts according to the selected date range. Computed The value is computed as the ratio of Overdue Invoices and all Aged Receivables: Total of Invoices ageing aging over 60 days / Total Aged Receivables.
Data source: Xero Invoices - for Debt > 60 days, Total Aged Receivables
Normalized EBITDA
A The Normalized EBITDA table showing shows Normalized Earnings Before before Interest, Taxes, Depreciation, and Amortization (EBITDA) for each of the last 6 months. Computed It is computed as the ratio of Overdue Invoices and all Aged Receivables: Revenue + ITDA - Expense - COGS - Contributions & Drawdown
Data sources:
- Xero P&L (SLI-Mapped) - for COGS, Expenses, Revenue, Interest, Taxes, Depreciation, Amortization
- Teams - for Contributions & Drawdowns
% Billable Professional Utilization
A table The % Billable Professional Utilization is a table and a line graph showing the percentage of Billable Professional Hours that are billable for each of the last 6 months. Formula: Its formula is Total Billable Hours / Total Worked Hours. Total Worked Hours is the total logged hours.
Data source: ConnectWise Manage Time Entries - for Billable Hours, Worked Hours
Total, Service, and Non-Service Revenue Trend
A Total, Service, and Non-Service Revenue Trend is a mixed chart displaying the a column chart for Service and Non-Service Revenues through columns and the and a line chart for Total Revenue through a line graph. Data shown . The data shown in this chart is for the last 6 months.
Formula: Non-Service Revenue + Service Revenue = Total Revenue
Data source: Xero P&L (SLI-Mapped) - for Services One Time Revenue, Monthly Recurring
Revenue per Endpoint
...
Trend
Revenue per Endpoint Trend is a bar graph and a table that shows A table showing the ratio of Revenue and # number of Endpoints of for the last 6 months. Formula: It uses the formula Total Revenue / Total Count of Endpoints.
Data sources:
- Xero P&L (SLI-Mapped) - for Revenue
- MSP Finance Endpoints Form (MSPbots App) - for Count of Endpoints
Avg. Billable Professional Compensation
A table Avg. Billable Professional Compensation is a table and a line graph showing the Average Compensation per Billable Professional for each of the last 6 months. Formula: It uses the formula (Direct Wages + PAYE) / Count of Billable Professionals
*NOTE: Uses This chart uses Direct Wages in the calculation since because PAYE in the dataset is 0.
Data sources:
- Xero P&L (SLI-Mapped) - for Direct Wages, PAYE
- Teams - for Count of Billable Professionals
Service Revenue per Billable Professional
A table The Service Revenue per Billable Professional widget is a table and a line graph showing the average Service Revenue generated per Billable Professional for each of the last 6 months. Formula: It uses the formula Total Service Revenue / Count of Billable Professional.
Data sources:
- Xero P&L (SLI-Mapped) - for Services One Time Revenue, Monthly Recurring
- Teams - for Count of Billable Professionals
Service Revenue to Direct Wages
A mixed chart showing the Service Revenue and to Direct Wages through columns then their ratio through a line graph. Data shown is for the last 6 months.
Formula: Service Revenue / (Direct Wages + PAYE)
Data source: Xero P&L (SLI-Mapped) - for MRR Revenue, Services One Time Revenue, Direct Wages, PAYE
...
A card number showing the overall Gross Margin for the selected date range.
...
a
...
data displayed is for the last 6 months including current month.
...
(Total Revenue - Total COGS) / Total Revenue
...
- Xero P&L (SLI-Mapped): Revenue, COGS
...
A card number showing the overall Expense Margin for the selected date range.
Expense Margin is the ratio of Expenses and Revenue.
data displayed is for the last 6 months including current month.
...
- Xero P&L (SLI-Mapped): Revenue, Expense
...
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 displayed is for the last 9 months including current month.
...
- Xero: Debt > 60 days, Total Aged Receivables
...
Normalization method:
(Net Income + Dividends + Pensions + Other Contributions) - Owner Drawdowns
data displayed is for the last 6 months.
...
- Xero P&L (SLI-Mapped): COGS, Expenses, Revenue, Interest, Taxes, Depreciation, Amortization
- Xero: Contributions & Drawdowns
...
- Xero P&L (SLI-Mapped): Revenue, COGS
...
- ConnectWise Manage: Billable Hours, Worked Hours
...
mixed chart
...
and
...
a
...
- Xero P&L (SLI-Mapped): Services One Time Revenue, Monthly Recurring
...
table showing the
...
- Xero P&L (SLI-Mapped): Revenue
- MSP Finance Endpoints Form: Count of Endpoints
...
(Direct Wages + PAYE) / Count of Billable Professional
*Uses Direct Wages in calculation since PAYE in dataset is 0
...
- Xero P&L (SLI-Mapped): Direct Wages, PAYE
- Teams: Utilization-Daily Total Work Hours
...
Service Revenue
...
,
...
Direct Wages, and their ratio for the last 6 months.
...
It uses the formula Service Revenue / (Direct Wages + PAYE)
...
*Uses Direct Wages in calculation since PAYE in dataset is 0
.
Data source: Xero
...
P&L (SLI-Mapped)
...
- for MRR Revenue, Services One Time Revenue, Direct Wages, PAYE
...
...
MSP Finance Team Financial Benchmarking
...
Dashboards
...
The Dashboard overlays the company metric on MSP Finance Team Financial Benchmarking Dashboards measure your company's metric up to a set of SLI-based benchmark values to see where the metric compares over a certain period(s). For each metric, a your company's performance is shown side by side with alongside the MSP industry's benchmarking categories Bottom 1/4, Average , or Median, and Best in Class (BIC) Average. This dashboard can be filtered by Date Range. Users can You can filter these dashboards by date range and drill through most widgets to view more details and /or breakdowns.
...
breakdowns.
Read more about SLI and MSP Finance Team Financial Benchmarking in How are the metrics and benchmarks calculated?
...
MSPF Benchmark - Gross Margin generated per $1 Sales
...
This card number
...
shows the overall Gross Margin generated per $1 of Sales & Marketing Expenses for the selected date range.
...
It uses the formula (Total Revenue - Total COGS) / Total Sales & Marketing Expenses.
Data source: Xero P&L (SLI-Mapped)
...
- for Revenue, COGS, Sales & Marketing Expenses
MSPF Benchmark - Blended Gross Margin %
...
This bar graph
...
provides a benchmark for Gross Margin
...
and shows monthly data for the selected date range.
...
It uses the formula (Total Revenue - Total COGS) / Total Revenue.
Data source: Xero P&L (SLI-Mapped)
...
- for Revenue, COGS
MSPF Benchmark - Service Gross Margin %
...
This bar graph
...
provides a benchmark for
...
Gross Margin
...
and shows monthly data for the selected date range.
...
It uses the formula (Service Revenue - Services COGS) / Service Revenue.
Data source: Xero P&L (SLI-Mapped)
...
- for Service Revenue, Service COGS
MSPF Benchmark - Product Gross Margin %
...
This bar graph
...
provides a benchmark for Product Gross Margin
...
and shows monthly data for the selected date range.
...
It uses the formula (Product Revenue - Product COGS) / Product Revenue.
Data source: Xero P&L (SLI-Mapped)
...
- for Product Revenue, Product COGS
MSPF Benchmark - SG&A %
...
This bar graph
...
provides a benchmark for Selling, General, and Administrative
...
Expenses (SG&A) as a % of Total Expenses
...
and shows monthly data for the selected date range.
...
It uses the formula SG&A Expenses/ Total Expenses.
Data source: Xero P&L (SLI-Mapped)
...
- for SG&A Expenses, Total Expenses
MSPF Benchmark - Sales Cost %
...
This bar graph
...
provides a benchmark for Sales Expenses as a % of Total Expenses
...
and shows monthly data for the selected date range.
...
It uses the formula Sales Expenses / Total Expenses.
Data source: Xero P&L (SLI-Mapped)
...
- for Sales Expenses, Total Expenses
MSPF Benchmark - G&A Cost%
...
This bar graph
...
provides a benchmark for General and Admin Expenses as a % of Total Expenses
...
and shows monthly data for the selected date range.
...
It uses the formula General and Admin Expenses / Total Expenses.
Data source: Xero P&L (SLI-Mapped)
...
- for General and Admin Expenses, Total Expenses
MSPF Benchmark - EBITDA %
...
This bar graph
...
provides a benchmark for Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) as a % of Total Revenue.
...
It shows monthly data for the selected date range
...
and uses the formula (Revenue - Expense) / Total Revenue.
Data source: Xero P&L (SLI-Mapped)
...
- for Expenses, Revenue
Content by Label showLabels false max 5 showSpace false title Related Topics excludeCurrent true cql label = "MSPF"
Overview
Content Tools