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
...
Gross Margin is Revenue minus Cost of Goods Sold (COGS) expressed as a percentage of Revenue: (Total Revenue - Total COGS) / Total Revenue
Data source: Xero P&L (SLI-Mapped) - for Revenue, COGS
...
Expense Margin is the ratio of Expenses and Revenue: Total Expenses / Total Revenue
Data source: Xero P&L (SLI-Mapped) - for Revenue, Expenses
...
Computed as the ratio of Overdue Invoices and all Aged Receivables: Total of Invoices ageing over 60 days / Total Aged Receivables
Data source: Xero Invoices - for Debt > 60 days, Total Aged Receivables
...
Computed as the ratio of Overdue Invoices and all Aged Receivables: Revenue + ITDA - Expense - COGS - Contributions & Drawdown
Data sources:
...
Formula: Total Billable Hours / Total Worked hours
Data source: ConnectWise Manage Time Entries - for Billable Hours, Worked Hours
...
Formula: Non-Service Revenue + Service Revenue = Total Revenue
Data source: Xero P&L (SLI-Mapped) - for Services One Time Revenue, Monthly Recurring
...
Formula: Total Revenue / Total Count of Endpoints
Data sources:
...
Formula: (Direct Wages + PAYE) / Count of Billable Professionals
*NOTE: Uses Direct Wages in calculation since PAYE in dataset is 0
Data sources:
...
Formula: Total Service Revenue / Count of Billable Professional
Data sources:
...
Formula: Service Revenue / (Direct Wages + PAYE)
Data source: Xero P&L (SLI-Mapped) - for MRR Revenue, Services One Time Revenue, Direct Wages, PAYE
...