This report provides a detailed breakdown of revenue by contract type: managed, t&m, block hours & fixed price for managed service providers.
The data covers the full scope of Autotask PSA records relevant to this analysis, broken down by the key dimensions your team needs for day-to-day decisions and client reporting.
Who should use this: MSP owners, finance leads, and operations managers tracking profitability
How often: Monthly for financial reviews, quarterly for strategic planning, on-demand for pricing decisions
EVALUATE
SUMMARIZECOLUMNS(
'BI_Autotask_Billing_Items'[sub_type],
"Revenue", SUM('BI_Autotask_Billing_Items'[extended_price]),
"Item_Count", COUNTROWS('BI_Autotask_Billing_Items')
)
ORDER BY [Revenue] DESCRecurring contract services (sub_type 12) generate the largest share of revenue at €9.6M. This covers your managed service agreements where clients pay a fixed monthly amount for bundled services. It is the most predictable revenue stream in your portfolio. Labor billing for time & materials engagements comes in second at €4.1M, followed by product and hardware charges at €3.8M.
EVALUATE SUMMARIZECOLUMNS('BI_Autotask_Contracts'[contract_type_name], "Count", COUNTROWS('BI_Autotask_Contracts'))Recurring Service contracts make up 63.9% of your contract portfolio at 1,207 contracts. Time & Materials agreements account for 504 contracts (26.7%). Block Hours contracts sit at 173 (9.2%), while Fixed Price contracts are rare at just 5. This distribution reflects a healthy MSP contract mix weighted toward predictable recurring revenue.
| Contract Type | Contracts | Share of Portfolio | Revenue Characteristic |
|---|---|---|---|
| Recurring Service | 1,207 | 63.9% | Predictable monthly revenue |
| Time & Materials | 504 | 26.7% | Variable, hours-based billing |
| Block Hours | 173 | 9.2% | Pre-purchased hour bundles |
| Fixed Price | 5 | 0.3% | Milestone or project-based |
EVALUATE
SUMMARIZECOLUMNS(
'BI_Autotask_Contracts'[contract_type_name],
"Contract_Count", COUNTROWS('BI_Autotask_Contracts')
)
ORDER BY [Contract_Count] DESCAt 44.7% of total billing, contract service bundles provide the most predictable revenue base. This is the revenue that shows up every month regardless of ticket volume.
Labor (19.2%) and product revenue (17.9%) together represent 37.1% of billing. This variable revenue is harder to forecast and worth monitoring monthly to catch dips early.
Only 5 Fixed Price contracts exist in the dataset. These carry the highest margin risk if estimates are off. Scope changes on fixed-price work erode profit quickly without a change-order process.
Industry benchmarks suggest 60–70% recurring revenue as a healthy target for managed service providers. The demo data shows 44.7% from recurring service bundles, with a further 12.3% from fixed items, bringing predictable revenue closer to 57%. The remaining 43% from labor and products is normal but warrants forecasting attention.
The Revenue – Total measure sums all billing items. In Power BI, filtering it by contract type requires a bidirectional relationship between BI_Autotask_Contracts and BI_Autotask_Billing_Items. This report uses the billing item sub_type field to show the natural distribution of revenue by billing structure, which maps directly to contract types in Autotask.
A Block Hours contract sells a fixed bundle of hours upfront (for example, 10 hours per month). The client pays whether they use those hours or not. T&M bills for actual hours worked, so revenue varies month to month. Block Hours contracts carry lower revenue risk but can result in unused capacity if the client underutilizes their bundle.
Start with T&M clients who generate consistent monthly billing. If a client spends €800–€1,200 every month on T&M tickets, that is a prime candidate for a Recurring Service contract at a similar rate. Use the hours vs revenue report to identify which clients have predictable patterns and pitch the contract as budget certainty for them, not just revenue certainty for you.
Yes. In the live Power BI dashboard you can apply slicer filters for company name, date range, and contract status. The interactive dashboard linked at the top of this page lets you drill into any specific client's contract type mix and revenue contribution.
Connect Proxuma Power BI to your PSA, RMM, and M365 environment, use an MCP-compatible AI to ask questions, and generate custom reports - in minutes, not days.
See more reports Get started