Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Widget NameTypeDescription CalculationsSources for Calculations
Gross MarginCard NumberGross 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 MarginCard NumberExpense 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 NumberRatio 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)
  • Xero: Debt > 60 days, Total Aged Receivables
Normalized EBITDA - Last 6 MonthsGridNormalized 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 - Last 6 MonthsLine ChartLine Chart showing Gross Margin trend for last 6 monthsUses Goss Margin data for last 6 months
  • Xero P&L (SLI-Mapped): Revenue, COGS
% Billable Professional Utilization - Last 6 MonthsGridPercentage of Billable Professional paid hours that are logged as billable hours% Utilization = Total Billed hours / Total Worked hours
  • ConnectWise Manage: Utilization daily time entry billable hour
  • Teams: Utilization-Daily Total Work Hours
% Billable Professional UtilizationProgress TrackerShows % Utilization of billable professionals for last x monthsUses Goss Margin data for last x months
  • ConnectWise Manage: Utilization daily time entry billable hour
  • Teams: Utilization-Daily Total Work Hours
Service Revenue per Billable Professional - Last 6 MonthsGridShows efficiency by computing for revenue generated per billable professionalTotal Service Revenue / Count of Billable Professional
  • Xero P&L (SLI-Mapped): Services One Time Revenue, Monthly Recurring
  • Teams: Utilization-Daily Total Work Hours
Revenue per Seat - Last 6 MonthsGridShows generated revenue per seat/unitTotal Revenue / (Number of units + Number of seats)
  • Xero P&L (SLI-Mapped): Revenue
  • Teams: Utilization-Daily Total Work Hours
Avg. Billable Professional Compensation - Last 6 MonthsGridShows average compensation paid to billable professionals(Direct Wages + PAYE) / Count of Billable Professional
  • Xero P&L (SLI-Mapped): Direct Wages+PAYE
  • Teams: Utilization-Daily Total Work Hours
Service Revenue to Direct Labor Ratio - Last 6 MonthsGridRatio to determine Service Revenue relative to cost of Billable ProfessionalsService Revenue / (Direct Wages + PAYE)
  • Xero P&L (SLI-Mapped): MRR Revenue, Services One Time Revenue, Direct Wages+PAYE
Service Revenue as % of TotalBar GraphShows trend of total revenue and % of service revenueService Revenue / Total Revenue
  • Xero P&L (SLI-Mapped): MRR Revenue, Services One Time Revenue, Revenue

...