Versions Compared

Key

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

...

  1. Log in to the MSPbots app and go to Marketplace > Apps. 
  2. Locate and click on the N-able Benchmarking package and click on it to install it

  N-able banchmarking

Step 3. Set up your Accounting Mapping using the N-able template

...

  1. On the MSPbots app, click Settings > Accounting Mapping. 
  2. On the Accounting Mapping tab, go to the Accounting Dashboard section.
  3. Select your Accounting Software integration, e.g. Quickbooks Online,and click the Profit & Loss Statement option.
  4. Go to the Map to section, and select N-able Benchmark from the templates.
    Image RemovedImage Added

  5. Next, categorize by dragging and dropping the accounts from the left to the correct mapping on the right.
     
  6. Click the Save button to save the mapping.

...

Expand
titleClick to see the list of Benchmark Qs definitions.

Definitions of Benchmark Qs 


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. It includes: 

  • Revenue related to agreements where you provide proactive and reactive remediation labor that is not limited or billed by the hour
  • Revenue for products that are bundled into your managed services offerings such as backup, antivirus, etc. 

This excludes 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. It includes time and materials labor, project labor, or any hourly block agreements.
[Q4] All Other Nonrecurring RevenueRevenue generated by any other nonrecurring sale nonrecurring sale not included in the other revenue categories. It includes non-IT-related professional services dollars, like application development work, and product sales revenue.
[Q5] All Other Recurring RevenueRevenue generated by any other recurring sales not included in the other revenue categories. It includes 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].  It includes all bundled services costs like RMM, antivirus, backup, etc. If products are purchased annually, costs should be spread out across four 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 the revenue in question [Q2]. 

This would include

It includes:

  • PSA costs and documentation tools costs related to the employees included in labor costs on [Q8-Q9]
.  Additionally, this would include tools
  • Tools costs for software/platforms that you use to service your IT-managed services customers. 

If products are purchased annually, costs should be spread out across

4

four 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

It can be fractional if you are sharing employees

between

among various business units

(ie., tech

. Example: A technician provides both IT MSP support and billable labor

). 

Calculate the split based on hours spent

in

on 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 the management of service delivery of the revenue reported in [Q2].

  This

It can be fractional if you are sharing employees

between

among various business units

(ie

. Example: A manager manages both IT MSP support and billable labor

resources). 

resources 

Calculate the split based on hours spent

in

on each business unit as a fraction of their total compensation costs.

[Q10] IT Managed Services Resources Taxes and Related Nonvoluntary Non-voluntary Costs (For all staff included in Direct Labor and Service Management Costs)All taxes and other nonvoluntary non-voluntary 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 It includes 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 You may not have any hard costs depending on your business model. 
[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 the revenue in question [Q3].

  This would include

It includes: 

  • PSA costs and documentation tools costs related to the employees included in labor costs on [Q14-Q15]. 
Additionally, this would include tools
  • 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

four 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

service the revenue reported in [Q3].

  This

It can be fractional if you are sharing employees

between

among various business units

(ie., tech

. Example: A technician provides both IT MSP support and billable

labor). 

labor 

Calculate the split based on hours spent

in

on 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 the management of service delivery of the revenue reported in [Q3].

  This

It can be fractional if you are sharing employees

between

among various business units

(ie

. Example: A manager manages both IT MSP support and billable labor resources

). 

Calculate the split based on hours spent

in

on each business unit as a fraction of their total compensation costs.

[Q16] IT Professional Services Resources Taxes and Related Nonvoluntary Non-voluntary 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 It includes 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 , except compensation. It includes hardware and software product costs.
[Q18b] Compensation Costs for All Other Nonrecurring RevenueCompensation costs related to the revenue reported in [Q4].   This It can be fractional if you are sharing employees between among various business units.  Calculate the split based on hours spent in on each business unit as a fraction of their total compensation costs.
[Q18c] All Other Nonrecurring Revenue Resources Taxes and Related Nonvoluntary Non-voluntary Costs All taxes and other nonvoluntary non-voluntary 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 It includes expenses like health care, retirement plans, etc.
[Q19] Cost of Goods for All Other Recurring Revenue

All costs

, except compensation,

required to provide the services providing the [Q5] revenue

.  This would include

, except compensation. It includes recurring product costs.

 

If products are purchased annually, costs should be spread out across

4

four quarters.

[Q19b] Compensation Costs for All Other Recurring RevenueCompensation costs are related to the revenue reported in [Q5].   This It can be fractional if you are sharing employees between among various business units.   Calculate the split based on hours spent in on each business unit as a fraction of their total compensation costs.
[Q19c] All Other Recurring Revenue Resources Taxes and Related Nonvoluntary Non-voluntary Costs All taxes and other nonvoluntary non-voluntary 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 It includes 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 It includes 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 non-voluntary 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 It includes 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 the market rate.
[Q24] Admin and Management Resources Related Taxes and Related Nonvoluntary CostsAll taxes and other nonvoluntary non-voluntary 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 It includes expenses like health care, retirement plans, etc.   Limit owner-related to contributions to what you would pay if it you 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 Non-voluntary Costs All taxes and other nonvoluntary non-voluntary 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 It includes 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 The average number of active IT-managed services agreements in place across all customers. 
[Q37] Average Number of Managed UsersAverage The average number of users covered by active IT managed services agreements. 
[Q38] Average Number of Managed DevicesAverage The average 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 The total number of responses (positive or negative) you collected during the period


Ticket CountsDescription
[Q40] IT Managed Services Reactive Tickets Generated (Customer requests)Total The total number of reactive tickets (requests received from the covered customers) received during the period
[Q41] IT Managed Services RMM Tickets GeneratedTotal The total 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 The total number of proactive tickets (issues generated internally to proactively support a covered customers customer 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 The total number of hours spent against the tickets in [Q40]
[Q44] IT Managed Services RMM Hours SpentTotal The total number of hours spent against the tickets in [Q41]
[Q45] IT Managed Services Proactive Hours SpentTotal The total number of hours spent against the tickets in [Q42]
[Q46] IT Professional Services Billable Hours SpentTotal The total number of billable hours that yields revenue in [Q3]


Automation Description 
[Q47] Tickets remediated with automation (self-healed)Total The 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 technician on a resolved ticket)Total The 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 on the issue.
[Q49] Mean Time to Resolution (MTTR) for IT Managed Services Reactive TicketsAverage The average number of minutes required to resolve tickets reported in [Q40]


Top 3 Clients StatsDescription
[Q50] Total IT Managed Services Revenue from 3 the three 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

It includes: 

  • 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
  • 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

individuals 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 The total revenue generated by IT professional services for your top 3 clients, in terms of total revenue generated.  This would include It includes 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 The 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 It includes 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 The 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 The 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)The 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 The 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 The total number of proactive tickets (issues generated internally to proactively support a covered customers customer 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 The 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 The 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 The 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 The total number of billable hours that yield revenue in [Q51]
[Q62] Total number of ACTIVE active clients (clients billed for any IT service during the period)Total The total number of individual clients that you billed for any IT service.   For related clients, consider them as an individual if you treat them as separate clients.   If you treat them as one client with multiple branches, count them as one client.