...
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 |
---|
Source Calculation | clarificationsSources for Calculations |
---|
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 |
- MSPFinanceMSPFinance | Card Number | Expense Margin is a ratio of Expenses and Revenue
(default date range is Last 30 days)
| Total Expenses / Total Revenue | - Xero P&L (SLI-Mapped): Revenue, Expense
|
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"? | - Xero: Debt > 60 days, Total Aged Receivables
|
Normalized EBITDA | Grid | Normalized earnings before interest, taxes, depreciation, and amortization.
Normalization method: Net Income + dividends, pensions & other contributions - reasonable owner draw downs | Revenue + ITDA - Expense - COGS - Contrib & Drawdown | - Xero P&L (SLI-Mapped): COGS, Expenses, Revenue, Interest, Taxes, Depreciation, Amortization
- Xero: Contributions & Drawdowns
|
Gross Margin - |
MSPFLast 6 Months | 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? | - Xero P&L (SLI-Mapped): Revenue, COGS
|
% Billable Professional Utilization - Last 6 Months | 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" ? | | - ConnectWise Manage: Utilization daily time entry billable hour
- Teams: Utilization-Daily Total Work 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? to Date range is also last 30 days? might be confusing to user if not matching with table- ConnectWise Manage: Utilization daily time entry billable hour
- Teams: Utilization-Daily Total Work Hours
|
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? | - Xero P&L (SLI-Mapped): Services One Time Revenue, Monthly Recurring
- Teams: Utilization-Daily Total Work Hours
|
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? | - Xero P&L (SLI-Mapped): Revenue
- Teams: Utilization-Daily Total Work Hours
|
Average |
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 | - Xero P&L (SLI-Mapped): Direct Wages+PAYE
- Teams: Utilization-Daily Total Work Hours
|
Service Revenue to Direct Labor |
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?- Xero P&L (SLI-Mapped): MRR Revenue, Services One Time Revenue, Direct Wages+PAYE
|
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 nowshows all months available?- Xero P&L (SLI-Mapped): MRR Revenue, Services One Time Revenue, Revenue
|