Metrics By Month

Overview

The Metrics By Month report tracks critical financial & operational KPIs over tme. The report allows MSPs to monitor essential business metrics month-by-month, including:

  • Contribution Total - Overall profitability
  • Contribution per Hour - Labor efficiency and pricing effectiveness
  • Effective Rate - Actual billing rates achieved
  • Efficiency - Resource utilization and productivity
  • Labor Gross Margin - Service delivery profitability
  • Billable Agreement Hours - Contracted capacity management

Certain reports allow the user to customize performance thresholds. Users set their own "good" and "bad" ranges for each metric, and the report automatically aplies red/yellow/green color-coding. This means MSPs can:

  • Align thresholds with their specific business goals and industry benchmarks
  • Instantly spot underperforming months (red) vs. target-meeting months (green)
  • Identify trends before they become problems (yellow warning zones)

The report is available for Admin and Manager level users.

Note: If you would like to add more metrics to the reporting filters, please put a request in the form of a ticket to MSPCFO.

The report is under the Efficiency tab:

Report - Metrics by Month

Key Benefits

The Metrics by Month report distills complex financial and operational data into:

  • Easy-to-read monthly comparisons
  • Actionable metrics tied directly to MSP performance
  • A format that supports leadership conversations, not just analysis
  • This makes it ideal for monthly reviews, QBR prep, and internal planning.

Filters

All of the reports allow you to filter on:

1. Client - The report will show one client or all clients.

2. Date Range - Select a specific date range in the Quick Select, or customize a start and end date range.

3. Metric - Pick one of the six key performance metrics available.

4. Account Manager - Select companies that belong to a Certain Account Manager.

5. Client Type - Filter on one or multiple Client Types.

 

Report - Metrics by Month

For certain metric reports,  customized performance thresholds uses shading to show the normal range of values (green), outside the range (yellow), and greatly outside the range (red).

For example - For the Efficiency metric, being between .8 and 1.5 is generally a good normal range for efficiency. Outside this range, the client is either over utilizing for the amount they are paying or not using enough time for the amount they are paying. So for .5 to .8 and for 1.2 to 1.5, the values are shaded in yellow. Further than these values on other side, the severity of the results are more dramatic and thus they are shaded in red. You can adjust the values to have a more custom approach.

The metrics that use the shading filter are:

Efficiency (based around an efficiency of 1).

Contribution per Hour (based around a Contribution per Hour of $150.)

Effective Rate (based around an effective rate of $187.50).

Labor Gross Margin (based around a % gross margin of 65%).

 

Customizing Performance Thresholds

A default set of thresholds is provided for the appropriate reports. For example, the settings below show the defaults for Effective Rate.

Report - Metrics by Month

To customize. Use the settings under the bars to change. The MSP has a average E/R of $100. The settings below the bars are modified to reflect the  E/R thresholds. In this example, Client 3320 is not being serviced enough within their labor agreement(s) and have a very high E/R. Whereas Client 2899 stays mor within a safe E/R range.

Report - Metrics by Month

Tables

One table can be filtered at a time. Each table can be selected for all clients, a single client or a range of clients selected in the filter. The averages for the time span is shown in the last column. The average for all clients in the filter for a month is shown at the bottom of each column.

CONTRIBUTION TOTAL

Report - Metrics by Month

CONTRIBUTION PER HOUR

Report - Metrics by Month

EFFECTIVE RATE

Report - Metrics by Month

EFFICIENCY

Report - Metrics by Month

LABOR GROSS MARGIN

Report - Metrics by Month

BILLABLE AGREEMENT HOURS

Report - Metrics by Month

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.