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!
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!
MSPFinance Benchmarks Dashboard
Widget Name | Type | Description | Calculations | clarifications |
---|---|---|---|---|
Gross Margin - MSPFinance | Card Number | Gross Margin is Revenue minus Cost of Goods Sold (COGS) which is expressed here as a percentage of Revenue. | (Total Revenue - COGS) / Total Revenue | date range? remove MSPFinance? |
Expense Margin - MSPFinance | Card Number | Expense Margin is a ratio of Expenses and Revenue | Total Expenses / Total Revenue | date range? remove MSPFinance? |
Debtor amount over 60 days as % of debt | Card Number | Ratio of significantly overdue invoices to all aged receivables | Total of Invoices over 60 days / Total Aged Receivables (Note: data as of 1st day of the month) | overdue invoices meaning debt of customers to company? |
MSPFinance Normalized EBITDA | Grid | Earnings before interest, taxes, depreciation, and amortization. Additional contributions such as dividends and pensions are also added back. | Normalized EBITDA is the sum of the following:
| owner PAYE means taxes of owners only not employees? PAYE is only taxes or with salary? remove MSPFinance? |
Gross Margin - MSPF | Line Chart | Line Chart showing Gross Margin trend for last 6 months | Uses Goss Margin data for last 6 months | remove MSPFinance? |
% Billable Professional Utilization | Grid | Shows total billed hours, total worked hours and the resulting utilization | % Utilization = Total Worked hours / Total Billed hours | should be hours/billed? date range? |
Billable Professional Utilization % | Progress Tracker | Shows % Utilization of billable professionals for last x months | Uses Goss Margin data for last x months | Change name? add date range |
Total Service Revenue per Billable Professional | Grid | Shows efficiency by computing for revenue generated per billable professional | Total Service Revenue / Count of Billable Professional | revenue =/ service revenue? |
Revenue per Seat | Grid | Shows generated revenue per seat/unit | Total Revenue / (Number of units + Number of seats) | clarify meaning and diff of seats and units |
Avg Billable Professional Compensation | Grid | Shows average compensation paid to billable professionals | (Direct Wages + PAYE) / Count of Billable Professional | no direct wages in excel file for calculations edit Avg to Average |
Service Revenue\Direct Labour Ratio | Grid | Ratio to determine Service Revenue relative to cost of Billable Professionals | Service Revenue / (Direct Wages + PAYE) | change name? Labor cost? |
Service Revenue as % of Total | Bar Graph | Shows trend of total revenue and % of service revenue | Service Revenue / Total Revenue | can be stacked column instead? |
Overview
Content Tools