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!


You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 17 Next »

Objectives:


N-able Benchmarking Process Flow






How to Sync your Software to MSPBots


Visit the following wiki Link:   https://wiki.mspbots.ai/display/MKB/Integrations


How to install the N-able Benchmarking package


1.  Login to MSPBots

2. Go to Marketplace > App page

3. Search N-able Benchmarking package. Then, click and install. 


How to setup your Accounting Mapping using N-able template


Pre: Accounting software already integrated with MSPBots

1.  Login to MSPBots

2.  Go Settings menu > Click Accounting Mapping

3. Select your Accounting Software integration e.g. Quickbooks Online.  And then, select only the Profit & Loss Statement option


4.  Select N-able Benchmark Template.

5.  Click Save button.


How to configure your N-able benchmark setup


Pre: Installed N-able Benchmarking Package

1.  Login to MSPBots

2.  Go to Apps page

3.  Under My Application page, Search N-able Benchmarking

4. Click to open.

5.  Hover to Settings menu. Then, click N-able Benchmarking Client Info and Configuration Form


     

        (Click image to view complete form)

       

N-Able Client and Benchmark Configuration Form

Description: The dashboard contains form to set up the N-Able configuration for Client benchmark input reference.


NoForm NameDescription Category Section FieldsSteps
1

N-able Client Info and Demographics Form:

  • This is where you input and submit your company details, demographics and accounting period setup.
  • Client Info Fields
  • Demographics
  • Accounting period



1.  Update the ff:

  • Company
  • Address
  • Owner/CEO/Contract
  • Geography - In what geography do you primarily operate?
  • Primary Market - Describe the primary market which you operate
  • Currency - Please select the currency to which your answers are entered
  • Accounting Period
  • Fiscal Month Start


2.  Click Submit.

2

N-able Benchmark Configuration Form

  • This is where you setup your configuration for your benchmarking Qs.
  • The Include and Exclude Lists radio box provides you the option to include or exclude certain category types you wish to.
  • Managed Services
  • Managed Services Reactive Work
  • Managed Services RMM Work
  • Managed Services Proactive Work
  • Managed Services Automation Tickets
  • Professional Services
  • RMM Devices


3

N-able Configuration Supplementary Form

  • For Product or Service Addition
  • Product or Service Addition






How to 


N-able Benchmark Qs and Headcount Information

Dashboard Link: MSPbots

Description:

This Dashboard contains the form for the initial setup for the benchmarking processes:


NoForm Description Category Fields
1N-able Benchmark Qs Form:
  • This contains the per Quarter data for your Q values results.
  • At the end of each Quarter, you can create a new Q Benchmark record.  
  • The form automatically pulls in the various Q values of the quarter and has the ability to save manually inputted data. 

2N-able Headcount
  • Add your name and job title



Benchmark Qs Definition


Financial/Profitability CategoryDescription
[Q1] Total RevenueTotal sales revenue for the organization. 
[Q2] IT Managed Services Revenue (Agreements that include proactive and reactive services, not restricted to hours)Revenue generated by IT managed services agreements.  This would include revenue related to agreements where you provide proactive and reactive remediation labor that is not limited or billed by the hour.  It would also include revenue for products that are bundled into your managed services offering such as backup, antivirus, etc.  Don't include unmanaged products sold as add-ons to your managed services agreements.
[Q3]IT Professional Services Revenue (Project work, T&M Work, Block time revenue distributed across entire block)Revenue generated by IT professional services.  This would include time and materials labor or project labor, or any hourly block agreements.
[Q4] All Other Nonrecurring RevenueRevenue generated by any other nonrecurring sale not included in other revenue categories.  This would include non-IT related professional services dollars (such as application development work, etc.) and product sales revenue.
[Q5] All Other Recurring RevenueRevenue generated by any other recurring sales not included in other revenue categories.  This would include Cloud services revenue, recurring non-managed services sales, and non-IT related recurring revenue.
[Q6] IT Managed Services Hard Cost of Goods (all bundled product costs such as antivirus, backup, RMM costs, etc.)All hard costs related to revenue in question [Q2].  This would include all bundled services costs like RMM, antivirus, backup, etc. If products are purchased annually, costs should be spread out across 4 quarters.
[Q7] IT Managed Services Tools Costs (Tools related to the delivery of managed services like fractional PSA costs, fractional documentation tools costs, etc.)All tools' costs related to revenue in question [Q2].  This would include PSA costs and documentation tools costs related to the employees included in labor costs on [Q8-Q9].  Additionally, this would include tools costs for software/platforms you use to service your IT managed services customers.  If products are purchased annually, costs should be spread out across 4 quarters.
[Q8] IT Managed Services Direct Labor Compensation Costs (Direct labor costs for resources or fractional resources delivering managed services, not including service management compensation)Compensation costs related to techs and engineers directly service the revenue reported in [Q2].  This can be fractional if you are sharing employees between various business units (ie., tech provides both IT MSP support and billable labor).  Calculate the split based on hours spent in each business unit as a fraction of their total compensation costs.
[Q9] IT Managed Services Service Management Compensation Costs (Full or fractional costs for service management resources)Compensation costs related to management of service delivery of the revenue reported in [Q2].  This can be fractional if you are sharing employees between various business units (ie. manager manages both IT MSP support and billable labor resources).  Calculate the split based on hours spent in each business unit as a fraction of their total compensation costs.
[Q10] IT Managed Services Resources Taxes and Related Nonvoluntary Costs (For all staff included in Direct Labor and Service Management Costs)All taxes and other nonvoluntary expenses related to the compensation included in [Q8] and [Q9]
[Q11] IT Managed Services Resources Voluntary Benefits (Company paid benefits such as health care, retirement plans, etc.)All voluntary expenses related to the compensation included in [Q8] and [Q9].  This would include expenses like health care, retirement plans, etc.
[Q12] IT Professional Services Hard Cost of GoodsAll hard costs related to revenue in question [Q3].  Depending on your business model, you may not have any hard costs
[Q13] IT Professional Services Tools Costs (Tools related to the delivery of Professional Services like fractional PSA costs, fractional documentation tools costs, etc.)All tools' costs related to revenue in question [Q3].  This would include PSA costs and documentation tools costs related to the employees included in labor costs on [Q14-Q15].  Additionally, this would include tools costs for software/platforms you use to service your IT managed services customers.  If products are purchased annually, costs should be spread out across 4 quarters.
[Q14] IT Professional Services Direct Labor Compensation Costs (Direct labor costs for resources or fractional resources delivering Professional Services, not including service management compensation)Compensation costs related to techs and engineers directly services the revenue reported in [Q3].  This can be fractional if you are sharing employees between various business units (ie., tech provides both IT MSP support and billable labor).  Calculate the split based on hours spent in each business unit as a fraction of their total compensation costs.
[Q15] IT Professional Services Service Management Compensation Costs (Full or fractional costs for service management resources)Compensation costs related to management of service delivery of the revenue reported in [Q3].  This can be fractional if you are sharing employees between various business units (ie. manager manages both IT MSP support and billable labor resources).  Calculate the split based on hours spent in each business unit as a fraction of their total compensation costs.
[Q16] IT Professional Services Resources Taxes and Related Nonvoluntary Costs (For all staff included in Direct Labor and Service Management Costs)All taxes and other nonvoluntary expenses related to the compensation included in [Q14] and [Q15]
[Q17] IT Professional Services Resources Voluntary Benefits (Company paid benefits such as health care, retirement plans, etc.)All voluntary expenses related to the compensation included in [Q14] and [Q15].  This would include expenses like health care, retirement plans, etc.
[Q18] Cost of Goods for All Other Nonrecurring RevenueAll costs, except compensation, required to provide the services providing the [Q4] revenue.  This would include hardware and software product costs.
[Q18b] Compensation Costs for All Other Nonrecurring RevenueCompensation costs related to the revenue reported in [Q4].  This can be fractional if you are sharing employees between various business units.  Calculate the split based on hours spent in each business unit as a fraction of their total compensation costs.
[Q18c] All Other Nonrecurring Revenue Resources Taxes and Related Nonvoluntary Costs All taxes and other nonvoluntary expenses related to the compensation included in [Q18b]
[Q18d] All Other Nonrecurring Revenue Resources Voluntary Benefits (Company paid benefits such as health care, retirement plans, etc.)All voluntary expenses related to the compensation included in [Q18b].  This would include expenses like health care, retirement plans, etc.
[Q19] Cost of Goods for All Other Recurring RevenueAll costs, except compensation, required to provide the services providing the [Q5] revenue.  This would include recurring product costs.  If products are purchased annually, costs should be spread out across 4 quarters.
[Q19b] Compensation Costs for All Other Recurring RevenueCompensation costs related to the revenue reported in [Q5].  This can be fractional if you are sharing employees between various business units.  Calculate the split based on hours spent in each business unit as a fraction of their total compensation costs.
[Q19c] All Other Recurring Revenue Resources Taxes and Related Nonvoluntary Costs All taxes and other nonvoluntary expenses related to the compensation included in [Q19b]
[Q19d] All Other Recurring Revenue Resources Voluntary Benefits (Company paid benefits such as health care, retirement plans, etc.)All voluntary expenses related to the compensation included in [Q19b].  This would include expenses like health care, retirement plans, etc.
[Q20b] Sales and Marketing Related Costs other than CompensationTotal sales and marketing related costs other than compensation.  This would include promotional costs, campaigns, agencies, online and paid search, list purchases, dedicated CRM software costs, promotional website costs, etc.
[Q20] Sales and Marketing Related Compensation CostsCompensation for sales and marketing employees.
[Q21] Sales and Marketing Resources Related Taxes and Related Nonvoluntary CostsAll taxes and other nonvoluntary expenses related to the compensation included in [Q20]
[Q22] Sales and Marketing Resources Related Voluntary BenefitsAll voluntary expenses related to the compensation included in [Q20].  This would include expenses like health care, retirement plans, etc.
[Q23] Admin and Management Related Compensation Costs (Not included elsewhere, not including excess owner compensation)Compensation for admin and management employees not already included in other compensation questions.  Limit owner related compensation to the compensation required to replace that individual with an employee at market rate.
[Q24] Admin and Management Resources Related Taxes and Related Nonvoluntary CostsAll taxes and other nonvoluntary expenses related to the compensation included in [Q23]
[Q25] Admin and Management Resources Related Voluntary BenefitsAll voluntary expenses related to the compensation included in [Q23].  This would include expenses like health care, retirement plans, etc.  Limit owner related to contributions to what you would pay if it were an employee.  
[Q26] Total Expenses Not Included ElsewhereAll expenses not reported in other questions, except unreported compensation costs.
[Q26b] Total Compensation Costs Not Included ElsewhereCompensation costs not included elsewhere.  These FTE are reported in [Q35].
[Q26c] Compensation Costs Not Included Elsewhere Taxes and Related Nonvoluntary Costs All taxes and other nonvoluntary expenses related to the compensation included in [Q26b]
[Q26d] Compensation Costs Not Included Elsewhere Voluntary Benefits (Company paid benefits such as health care, retirement plans, etc.)All voluntary expenses related to the compensation included in [Q26b].  This would include expenses like health care, retirement plans, etc.


Headcount CategoryDescription
[Q27] IT Managed Services Resources Direct Labor FTE Count (Can be fractional)Full time equivalent headcount included in [Q8]
[Q28] IT Managed Services Service Management Resources Direct Labor FTE Count (Can be fractional)Full time equivalent headcount included in [Q9]
[Q29] IT Professional Services Resources Direct Labor FTE Count (Can be fractional)Full time equivalent headcount included in [Q14]
[Q30] IT Professional Services Service Management Resources Direct Labor FTE Count (Can be fractional)Full time equivalent headcount included in [Q15]
[Q31] Sales and Marketing Resources Direct Labor FTE Count (Can be fractional)Full time equivalent headcount included in [Q20]
[Q32] Admin Resources Direct Labor FTE Count (Not included in other counts, Can be fractional)Full time equivalent headcount for the admin employees included in [Q23]
[Q33] Management Resources Direct Labor FTE Count (Not included in other counts, Can be fractional)Full time equivalent headcount for the management/owner employees included in [Q23]
[Q34] All Other Cost of Goods Resources Direct Labor FTE Count (Can be fractional)Full time equivalent headcount included in [Q18] and [Q19]
[Q35] Resources Not Included Elsewhere FTE Count (Can be fractional)Full time equivalent headcount not included in any other question. 


Service CountsDescription
[Q36] Average Number of Managed Services AgreementsAverage number of active IT managed services agreements in place across all customers. 
[Q37] Average Number of Managed UsersAverage number of users covered by active IT managed services agreements. 
[Q38] Average Number of Managed DevicesAverage number of devices (workstations, servers, network devices, etc.) covered by active IT managed services agreements. 
[Q39] If you measured customer satisfaction (CSAT), how many responses did you get from managed clients?Total number of responses (positive or negative) you collected during the period
Ticket CountsDescription
[Q40] IT Managed Services Reactive Tickets Generated (Customer requests)Total number of reactive tickets (requests received from the covered customers) received during the period
[Q41] IT Managed Services RMM Tickets GeneratedTotal number of reactive tickets generated by your RMM platform during the period.  Do not double count tickets between [Q41] and [Q42].
[Q42] IT Managed Services Proactive Tickets Generated (environment checkups, proactive onsite visits, etc.)Total number of proactive tickets (issues generated internally to proactively support a covered customers environment) received during the period.  Do not double count tickets already included in [Q41] and [Q42].


Hours Used by AreaDescription
[Q43] IT Managed Services Reactive Hours SpentTotal number of hours spent against the tickets in [Q40]
[Q44] IT Managed Services RMM Hours SpentTotal number of hours spent against the tickets in [Q41]
[Q45] IT Managed Services Proactive Hours SpentTotal number of hours spent against the tickets in [Q42]
[Q46] IT Professional Services Billable Hours SpentTotal number of billable hours that yields revenue in [Q3]


Automation Description 
[Q47] Tickets remediated with automation (self-healed)Total number of tickets/incidents that were remediated by automation and did not require technician intervention.
Efficiency of ResolutionDescription
[Q48] IT Managed Services Reactive Tickets with One Touch Resolution By An Engineer (Only one time entry by a tech on a resolved ticket)Total number of tickets that were resolved with only one contiguous time entry by an engineer.  If you have someone triage or dispatch the ticket, that will not count as an engineer working the issue.
[Q49] Mean Time to Resolution (MTTR) for IT Managed Services Reactive TicketsAverage number of minutes required to resolve tickets reported in [Q40]


Top 3 Clients StatsDescription
[Q50] Total IT Managed Services Revenue from 3 Largest Clients (largest in terms of total revenue)Total revenue generated by IT managed services agreements for your top 3 clients, in terms of total revenue generated.  This would include revenue related to agreements where you provide proactive and reactive remediation labor that is not limited or billed by the hour.  It would also include revenue for products that are bundled into your managed services offering such as backup, antivirus, etc.  Don't include unmanaged products sold as add-ons to your managed services agreements.  For related clients, consider them individual if you treat them as separate clients.  If you treat them as one client with multiple branches, count them as one client. 
[Q51] Total IT Professional Services Revenue from 3 Largest Clients (largest in terms of total revenue)Total revenue generated by IT professional services for your top 3 clients, in terms of total revenue generated.  This would include time and materials labor or project labor, or any hourly block agreements.
[Q52] Total Other Revenue from 3 Largest Clients (largest in terms of total revenue)Total revenue generated by any other sale not included in [Q50] and [Q51] for your top 3 clients, in terms of total revenue generated.  This would include non-IT related professional services dollars (such as application development work, etc.) and product sales revenue.
[Q53] Average Number of Managed Users from 3 Largest Clients (largest in terms of total revenue)Average number of users covered by active IT managed services agreements for your top 3 clients. 
[Q54] Average Number of Managed Devices from 3 Largest Clients (largest in terms of total revenue)Average number of devices (workstations, servers, network devices, etc.) covered by active IT managed services agreements for your top 3 clients.
[Q55] IT Managed Services Reactive Tickets Generated (Customer requests) from 3 Largest Clients (largest in terms of total revenue)Total number of reactive tickets (requests received from the covered customers) received during the period from your top 3 clients
[Q56] IT Managed Services RMM Tickets Generated from 3 Largest Clients (largest in terms of total revenue)Total number of reactive tickets generated by your RMM platform during the period for your top 3 clients.  Do not double count tickets between [Q55] and [Q56].
[Q57] IT Managed Services Proactive Tickets Generated (environment checkups, proactive onsite visits, etc) from 3 Largest Clients (largest in terms of total revenue)Total number of proactive tickets (issues generated internally to proactively support a covered customers environment) received during the period for your top 3 clients.  Do not double count tickets already included in [Q55] and [Q56].
[Q58] IT Managed Services Reactive Hours Spent from 3 Largest Clients (largest in terms of total revenue)Total number of hours spent against the tickets in [Q55]
[Q59] IT Managed Services RMM Hours Spent from 3 Largest Clients (largest in terms of total revenue)Total number of hours spent against the tickets in [Q56]
[Q60] IT Managed Services Proactive Hours Spent from 3 Largest Clients (largest in terms of total revenue)Total number of hours spent against the tickets in [Q57]
[Q61] IT Professional Services Billable Hours Spent from 3 Largest Clients (largest in terms of total revenue)Total number of billable hours that yield revenue in [Q51]
[Q62] Total number of ACTIVE clients (clients billed for any IT service during the period)Total number of individual clients that you billed for any IT service.  For related clients, consider them individual if you treat them as separate clients.  If you treat them as one client with multiple branches, count them as one client. 












N-Able Benchmarking Dashboards:

NoDashboard DescriptionLink
1N-able Benchmarking - Financial DashboardA dashboard displaying the account categories (Qs) amount by monthly and quarter in a given year.MSPbots


           

           



NoDashboard DescriptionLink
2N-Able Benchmarking - Previous Quarter
MSPbots

         




  • No labels