The TruMethods BI Package provides a centralized, visual representation of your company's data and performance indicators. Business owners, service managers, and other stakeholders can refer to the TruMethods dashboards and widgets to gain real-time insights for informed decision-making, a thorough evaluation of performance, and timely action-taking.
The TruMethods BI Package is designed for TruMethods users and works on the following Professional Services Automation (PSA) and software:
PSA | RMM | Accounting |
|
|
|
Why should I use the TruMethods BI Package?
The TruMethods BI Package helps you formulate data-driven decisions and level up toward business goals with the following features:
- Dashboards with real-time insights on leadership, service delivery, and your MSP's financial health
- Accounting mapping feature that automatically feeds data like net profit, net MRR, and service revenue into the dashboard for easy monitoring
- Customizable settings that allow for including or excluding data from the reports automatically
- Adjustable settings like the number of associates and owner's drawdowns monthly
Prerequisites
- The TruMethods BI Package is available to TruMethods users with ConnectWise PSA, Autotask, and Kaseya BMS.
- You need the admin and financial roles and permissions to be able to modify the dashboard settings.
- Your accounting software must be mapped to MSPbots before you can use the financial dashboard. Refer to the article How to Access and Use the Accounting Mapping Feature for instructions on how to map your software.
What are the dashboards available in the TruMethods BI Package?
You can open the TruMethods BI Package on the MSPbots app by going to Apps on the menu and selecting TruMethods BI Package on the Apps tab.
These are the dashboards available in the app:
TruMethods Leadership Dashboard
The TruMethods Leadership Dashboard contains Support, Centralized Services, Technical Alignment, and Projects data useful to leadership in the MSP business. The Support section shows weekly and monthly data for response and resolution times, and support tickets created, closed, and open for more than 5 days.
The Centralized Services section lets you monitor centralized services tickets created in the previous month, managed endpoints, monthly alarms, and patch management data for servers and workstations.
The widgets under Technical Alignment show the number of clients with active managed service agreements, managed endpoints from the PSA or RMM device, and technical alignment tickets created and worked on during the previous month.
The Projects widgets, on the other hand, show the estimated profit from the categorized projects completed in the previous month, the number of open projects that are not past due, and the projects past their due dates.
The image below shows a section of the TruMethods Leadership Dashboard.
To access the Leadership Dashboard from the TruMethods Welcome Page, navigate to Dashboards and select TruMethods Leadership Dashboard.
TruMethods Service Delivery Dashboard
The TruMethods Service Delivery Dashboard contains Support, Centralized Services, and Technical Alignment data useful for improving service delivery in MSPs. The widgets in the Support section show support tickets created and closed during the previous week, and tickets responded to and resolved on the same day.
The section Centralized Services shows widgets for the number of centralized services created in the previous week, the count of endpoints managed by the PSA or RMM, and the number of alarms created in the previous week. It also shows the average patch compliance of servers and workstations.
The Technical Alignment section shows the counts of technical alignment tickets created and completed in the previous month, the total hours spent on these tickers per endpoint, and the total number of managed clients with agreements and endpoints managed from PSA configurations and RMM devices.
The image below shows a section of the TruMethods Service Delivery Dashboard.
To access the Service Delivery Dashboard from the TruMethods Welcome Page, navigate to Dashboards and select TruMethods Service Delivery Dashboard.
TruMethods Smart Numbers - Financial Dashboard
The TruMethods Smart Numbers - Financial Dashboard provides data for net Profit, percent of Revenue, and Leverage data on average MRR and ORR, service revenue, and all-in-seat price for the previous quarter.
On the same dashboard are key Sales data like new and lost MRR with ORR contracts, net MRR gained contracts, and percentage of sales calls closed. This section includes Revenue and Expenses by Account Category and financial details from the mapped account.
To access the TruMethods Smart Numbers - Financial Dashboard from the TruMethods Welcome Page, navigate to Dashboards and select TruMethods Smart Numbers - Financial Dashboard.
These are the financial widgets with descriptions and information on their calculations.
Dashboard Section | Widget | Description | Computation |
---|---|---|---|
Profit | Net Profit % | This card widget shows the Net Profit percentage to Total Revenue for the selected date range. | |
Net Profit % Before Owner's Comp | This card widget is calculated as the percentage of Revenue less Expenses plus Drawdowns divided by the Total Revenue for the selected date range. | ||
Revenue | % of Revenue from Services | This card widget shows the percentage of the sum of the Revenue from Services over the Total Revenue for the selected date range. | |
% of Services from MRR + ORR | This card widget shows the percentage of the sum of the Services from MRR and ORR over the Total Revenue for the selected date range. | ||
Leverage | Service Revenue / Associate - Annualized | This card widget shows the average Service Revenue per Associate for the selected date range. | |
Service Revenue / Tech - Annualized | This card widget shows the average Service Revenue per Tech Associate for the selected date range. | ||
All-In Seat Price | This widget displays the average MRR and NRR per seat for the selected date range. | ||
Average MRR per Agreement | This widget displays the average Monthly Recurring Revenue per Agreement for the selected date range. | ||
Average ORR Per Agreement | This widget displays the average of Other Recurring Revenue per Agreement for the selected date range. | ||
MRR All-In Seat Price | This widget displays the average Monthly Recurring Revenue per Seat for the selected date range. | ||
Annualized Service Revenue / Associate | This card widget displays the Total Revenue From Services previous month divided by the number of Associates over 12 months. This value is not affected by the slicer in the report. |
||
Annualized Service Revenue / Tech | This card widget displays the Previous Month Service Revenue divided by the number of Tech Associates over 12 months. This value is not affected by the slicer in the report. | ||
Average All In Seat Price | This widget displays the Average All In Seat Place value on a yearly basis. | ||
Average MRR All In Seat Price | This widget displays the Average MRR All In Seat Place value on a yearly basis. | ||
Sales | New MRR + ORR | This card widget shows the total Monthly Recurring Revenue (MRR) and Other Recurring Revenue (ORR) during the selected date range. |
Total New MRR + ORR |
Lost MRR + ORR | Churn | This card widget displays the total Monthly Recurring Revenue (MRR) and Other Recurring Revenue (ORR) lost during the selected date range. |
Total Lost MRR + ORR |
|
Net MRR Gain | This card widget calculates the net difference in the sum of the Monthly Recurring Revenue (MRR) and Other Recurring Revenue (ORR) from the sum of revenue during the selected date range. |
|
|
Dials / Appointments | This card widget shows the ratio of the total dials to the total appointments made during the selected date range. |
Total Dials / Total Appointments |
|
First Appointments | This card widget displays the total count of initial appointments scheduled during the selected date range. | ||
Sales Call Close % | This card widget calculates the percentage of new agreements closed successfully with the total count of first appointments made during the selected date range. |
How to start using the TruMethods BI Package
The TruMethods BI Package comes with your MSPbots app. After connecting your PSA and software to MSPbots, configure your TruMethods settings, validate the dashboard data, and you are ready to start your TruMethods experience!
1. Connect your PSAs and software to MSPbots
The TruMethods BI Package works on the following PSAs and software. Select your PSAs and software from the table for a guide on connecting these to MSPbots.
PSA | RMM | Accounting | |
ConnectWise PSA | Auvik | Kaseya VSA | Quickbooks On-Premise |
Autotask | ConnectWise Automate | N-able N-Central |
Quickbooks Online |
Kaseya BMS | Datto RMM | NinjaOne | Xero |
2. Configure the settings.
After successfully connecting your PSAs, open the TruMethods BI Package and configure the following settings:
A. TruMethods Smart Number Settings
These settings affect the values in the Leadership and Service Delivery dashboards.
- Hover over Settings and select TruMethods Smart Number Settings.
- When the TruMethods Smart Number Settings tab opens, select options for each setting based on your requirements.
- Support Settings
- Board | Queue - Select the boards you want to include in the dashboard data.
- Excluded Ticket Status - Select the Ticket Status that should be excluded.
-
Include All Agreement Types / Contract Categories - Enable this option and select the Agreement Type for inclusion from the dashboard.
Modifying these settings affects the widgets in the Support sections of the Leadership and Service Delivery dashboards.
- Centralized Services Settings
- Board | Queue - Select the boards you want to include in the dashboard data.
- Excluded Ticket Status - Select the Ticket Status that should be excluded.
- Include All Agreement Types / Contract Categories - Enable this option and select the Agreement Type for inclusion from the dashboard.
-
Include All Company Types / Classifications - Enable this option and select the Company Type for inclusion from the dashboard.
Modifying these settings affects the widgets in the Centralized Services sections of the Leadership and Service Delivery dashboards.
- Technical Alignment Settings
- Board | Queue - Select the boards you want to include in the dashboard data.
- Excluded Ticket Status - Select the Ticket Status that should be excluded.
- Include All Agreement Types / Contract Categories - Enable this option and select the Agreement Type for inclusion from the dashboard.
- Include All Company Types / Classifications - Enable this option and select the Company Type for inclusion from the dashboard.
-
Include All Issue Types and Subtypes - Enable this option and select the Issue Type and Sub-type for inclusion from the dashboard.
Modifying these settings affects widgets in the Technical Alignment sections of the Leadership and Service Delivery dashboards.
- Technician Settings
- Support Title / Work Role - Select the titles and roles for inclusion in the dashboard's data.
-
Holiday / PTO Work Type - Select the work types that should be factored into the data.
Modifying these settings affects the Service Delivery Dashboard widgets containing the word "technician" in the widget name.
- Alerts / Alarms - Select options for the following areas to include in the dashboard data. These settings affect the data in the Service Delivery dashboard.
-
Source
-
Include All Boards / Queues
-
Include All Ticket Types
-
Include All Company Types / Classifications
Modifying these settings affects the Service Delivery and Leadership Dashboard widgets having the word "alarm" in the widget name.
-
- Endpoints
- Source - Select the data source for your dashboard.
-
Asset Type - Enable this option to include a specific Device Name or Seat Name.
Modifying these settings affects the Service Delivery and Leadership Dashboard widgets having the word "endpoints" in the widget name.
- Managed Service Clients - Select specific types for the following:
- Company Type / Company Classification
-
Agreement Type / Contract Type
Modifying these settings affects the Managed Service clients widgets in the Technical Alignment sections of the Service Delivery and Leadership dashboards.
- Support Settings
- Click Submit to save.
B. TruMethods Drawdowns Settings
The Drawdowns Settings allow you to factor the business owner's drawdowns into the dashboard's data. These affect the value in the Net Profit % - Before Owners Comp widget on the Financial dashboard.
To set and modify these settings:
- Map TruMethods WC to MSPbots.
- Navigate to Settings > Accounting Mapping in the MSPbots app.
- In the Accounting Dashboard, select your accounting software in the first dropdown menu, and select Profit & Loss Statement or Balance Sheet in the next menu.
- Go to the Map to section and select TruMethods WC to map it to MSPbots.
Refer to the article How to Access and Use the Accounting Mapping Feature for more information on mapping accounts.
- Navigate to Settings > Accounting Mapping in the MSPbots app.
- Once the mapping is set, go to Settings on the TruMethods page and select TruMethods Drawdowns Settings.
- Select a month and manually input the total amount of drawdowns for it.
- Click Submit.
C. TruMethods Sales and Associates Entry Form
The TruMethods Sales and Associates Entry Form factors the following into the financial dashboard.
- Year and month
- Dials
- First appointments
- New arrangements / contracts
- Associates
- Technical associates
How to add new sales and associates data
- Click the +New button, enter values in the fields, and click Add.
- To edit or delete entries, click the Edit or Delete link under the Operations column.
3. Validate your TruMethods data
After configuring the settings, validate the data on your reports with the following steps:
-
Open the TruMethods BI Package.
-
Hover over Dashboards and select the dashboard for checking.
-
Review the data on the report and verify if the values are correct and presented according to your needs. If not, review and adjust your configurations in Settings using the procedure in Step 2 above.
Do these steps for the Leadership, Service Delivery, and Financial dashboards. - To validate account mapping, scroll down the sections on financial details in the Financial Dashboard. The data from accounting mapping should be shown in these widgets.
For more information on MSPbots and how it has been a game changer for many MSP businesses, view the MSPbots Demos, Trainings, and Webinars.
For more information on TruMethods, read the Who We Are - TruMethods page or visit the TruMethods website.