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
...
A table showing Normalized Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) for each of the last 6 months.
Computed as the ratio of Overdue Invoices and all Aged Receivables: Revenue + ITDA - Expense - COGS - Contributions & Drawdown
...
% Billable Professional Utilization
A table and a line graph showing the percentage of Billable Professional Hours that are billable for each of the last 6 months.
Formula: Total Billable Hours / Total Worked hours
...
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.
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
A table and a bar graph showing the ratio of Revenue and # of Endpoints of for the last 6 months.
Formula: Total Revenue / Total Count of Endpoints
...
Avg. Billable Professional Compensation
A table and a line graph showing the Average Compensation per Billable Professional for each of the last 6 months.
Formula: (Direct Wages + PAYE) / Count of Billable Professionals
*NOTE: Uses Direct Wages in calculation since PAYE in dataset is 0
...
Service Revenue per Billable Professional
A table and a line graph showing the average Service Revenue generated per Billable Professional for each of the last 6 months.
Formula: Total Service Revenue / Count of Billable Professional
...
Service Revenue to Direct Wages
A table and a mixed chart showing the Service Revenue and , Direct Wages through columns then , and 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.
Gross Margin is Revenue minus Cost of Goods Sold (COGS) which is expressed here as a percentage of Revenue.
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
...
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.
...
- Xero P&L (SLI-Mapped): Services One Time Revenue, Monthly Recurring
...
- 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)
...
-
...
- Xero P&L (SLI-Mapped): Services One Time Revenue, Monthly Recurring
- Teams: Utilization-Daily Total Work Hours
...
for
...
Service Revenue / (Direct Wages + PAYE)
*Uses Direct Wages in calculation since PAYE in dataset is 0
...
MRR Revenue, Services One Time Revenue, Direct Wages, PAYE
...
MSP Finance Team Financial Benchmarking Dashboard
...
Overview
Content Tools