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. (default date range is Last 30 days) | (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 (default date range is Last 30 days) | Total Expenses / Total Revenuedate range? - last 30 days including currentremove MSPFinance? | ||
Debtor amount over 60 days as % of debt | Card Number | Ratio of significantly overdue invoices to all aged receivables (default date range is Last 30 days) | 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? yeschange name to "Debt >60 days as % of Total"? | |
MSPFinance Normalized EBITDA | Grid | Normalized earnings before interest, taxes, depreciation, and amortization. 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 MSPFinancechanged to "last 6 months" can remove title in chart? | |
% Billable Professional Utilization | Grid | Percentage of Billable Professional paid hours that are logged as billable hours | % Utilization = Total Billed hours / Total Worked hours | change name to "Billable Professional Utilization % - last 6 months" ? | |
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 rangeto Date range is also last 30 days? might be confusing to user if not matching with table | |
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,units, users? can we standardize naming used in dashboard? | |
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 edited 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