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 sourcessource: Xero P&L (SLI-Mapped) - for Revenue, COGS
...
Expense Margin is the ratio of Expenses and Revenue: Total Expenses / Total Revenue
Data sourcessource: 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 sourcessource: 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:
- Xero P&L (SLI-Mapped) - for COGS, Expenses, Revenue, Interest, Taxes, Depreciation, Amortization
- Teams - for Contributions & Drawdowns
% Billable Professional Utilization
...
Formula: Total Billable Hours / Total Worked hours
Data source: ConnectWise Manage Time Entries - for Billable Hours, Worked Hours
Total, Service, and Non-Service Revenue Trend
...
Formula: Non-Service Revenue + Service Service Revenue = Total Revenue Revenue
Data source: Xero P&L (SLI-Mapped) - for Services One Time Revenue, Monthly Recurring
Revenue per Endpoint
A table showing the ratio of Revenue and # of Endpoints of the last 6 months.
...