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 | Source Calculation | 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 | Xero P&L (SLI-Mapped): Revenue, COGS | |
Expense Margin - MSPFinance | Card Number | Expense Margin is a ratio of Expenses and Revenue (default date range is Last 30 days) | Total Expenses / Total Revenue | ||
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) | change name to "Invoices Receivables >60 days as % of Total Receivables"? | |
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 | changed 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? to 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,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 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? if not possible, can change to column/line chart? not easily readable right now shows all months available? |
...
Overview
Content Tools