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
MSPFinance Benchmarks Dashboard
The MSPFinance Dashboards Package is available to MSPBots users with ConnectWise Manage integration. This package gives user a complete overview of the company's financial performance by providing reports on Expense and Revenue margins, Normalized EBITDA, Billable Professional Revenue and Utilization.
These will give useful insights to enable Management in identifying financial problems quickly and implementing the necessary solutions.
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