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 | 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? -last 30 days including current remove MSPFinance? yes, add html | |||
Expense Margin - MSPFinance | Card Number | Expense Margin is a ratio of Expenses and Revenue | Total Expenses / Total Revenue | date range? - last 30 days including current 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? yes | |||
MSPFinance Normalized EBITDA | Grid | Earnings Normalized 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? | Normalization method: | Revenue + ITDA - Expense - COGS - Contrib & Drawdown | |
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 | GridShows | total billed hours, total worked hours and the resulting utilizationPercentage of Billable Professional paid hours that are logged as billable hours | % Utilization = Total Worked Billed hours / Total Billed hoursshould be hours/billed? date range?Worked hours | ||||
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