“Internal vs Client Hours Ratio”
Autotask PSA Datto RMM Datto Backup Microsoft 365 SmileBack HubSpot IT Glue All reports
AI-GENERATED REPORT
You searched for:
How much time goes to internal work versus client work?

Internal vs Client Hours Ratio

A data-driven analysis of internal vs client hours ratio from your Power BI environment, with breakdowns and actionable findings.

Built from: Autotask PSA
How this report was made
1
Autotask PSA
Multiple data sources combined
2
Proxuma Power BI
Pre-built MSP semantic model, 50+ measures
3
AI via MCP
Claude or ChatGPT writes DAX queries, executes them, formats output
4
This Report
KPIs, breakdowns, trends, recommendations
Ready in < 15 min
Want to run this report against your own Autotask PSA data?
Get Proxuma Power BI

Internal vs Client Hours Ratio

This report analyzes internal vs client hours ratio using data from Autotask PSA.

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: Account managers, MSP owners, and service delivery leads

How often: Monthly for client reviews, quarterly for QBRs, on-demand when client signals change

Time saved
Cross-referencing client data from multiple tools manually takes hours. This report brings it together.
Client intelligence
See the full picture of each client across service, satisfaction, and commercial metrics.
Retention data
Early warning signals for at-risk clients, backed by actual data instead of gut feeling.
Report categoryClient Management
Data sourceAutotask PSA · Datto RMM · Datto Backup · Microsoft 365 · SmileBack · HubSpot · IT Glue
RefreshReal-time via Power BI
Generation timeUnder 15 minutes
AI requiredClaude, ChatGPT or Copilot
AudienceAccount managers, MSP owners
Where to find this in Proxuma
Power BI › Client Management › Internal vs Client Hours Ratio
What you can measure in this report
Summary Metrics
Hours by Resource
Hours by Company
Billable vs Non-Billable
Monthly Hours Trend
Analysis
Recommended Actions
Frequently Asked Questions
TOTAL HOURS
AI-Generated Power BI Report
Internal vs Client Hours Ratio

A data-driven analysis of internal vs client hours ratio from your Power BI environment, with breakdowns and actionable findings.

Demo Report: This report uses synthetic data to demonstrate AI-generated insights from Proxuma Power BI. The structure, DAX queries, and analysis reflect real MSP data patterns.
1.0 Summary Metrics
TOTAL HOURS
25,868
15 resources logged
View DAX Query — Summary query 
-- Combined summary metrics from Power BI dataset
What are these DAX queries? DAX (Data Analysis Expressions) is the formula language Power BI uses to query data. Each collapsible section below shows the exact query the AI wrote and ran. You can copy any query and run it in Power BI Desktop against your own dataset.
1.0 Hours by Resource

Hours logged per resource from the demo dataset

Brandon Lynn
1,343
Brandon Bishop
1,361
Daniel Daniels
1,418
Gregory Horn
1,504
Elizabeth Ortega
1,433
Jennifer King
1,584
Jeremy White
1,492
Dr. Amber Ayala DVM
2,399
Kevin Allen
2,060
James Li
2,135
ResourceHours
Paul Hoffman99261461.9%
Joshua Hernandez44625456.9%
Jane Stewart69633648.2%
Brian Cook35616345.8%
David Collins60326043.2%
Kevin Allen2,06081239.4%
Deborah Young62623737.9%
Becky Johnson1,23945536.7%
Gregory Horn1,50554035.9%
James Li2,13676535.8%
Chelsea Thomas1,78062234.9%
Paula Lewis MD1,29444234.2%
Rose Rose2617428.6%
Jeremy White1,49239026.1%
Ross Stephens58013222.7%
View DAX Query — Hours by Resource query 
EVALUATE
TOPN(
  15,
  FILTER(
    ADDCOLUMNS(
      SUMMARIZECOLUMNS(
        'BI_Autotask_Time_Entries'[resource_name],
        "Logged", [Total],
        "Internal", [Internal]
      ),
      "InternalPct", DIVIDE([Internal], [Logged])
    ),
    [Logged] >= 100
  ),
  [InternalPct], DESC
)
ORDER BY [InternalPct] DESC
2.0 Hours by Company

Total hours logged per company

Richards, Bell and Christ
782
Wu-Jackson
962
Price-Gomez
864
Martin Group
2,217
Thompson, Contreras and R
1,006
Doyle-Contreras
961
Clements, Pham and Garcia
866
None
7,264
Lewis LLC
2,801
Little Group
3,791
CompanyHours
Richards, Bell and Christensen782.4
Wu-Jackson962.0
Price-Gomez864.9
Martin Group2,217.0
Thompson, Contreras and Rios1,006.1
Doyle-Contreras961.9
Clements, Pham and Garcia866.3
-7,264.2
Lewis LLC2,801.1
Little Group3,791.4
Craig-Huynh4,370.4
Rivers, Rogers and Mitchell1,661.8
Burke, Armstrong and Morgan1,312.3
Wall PLC1,696.9
Ramos Group1,170.6
View DAX Query — Hours by Company query 
EVALUATE TOPN(15, SUMMARIZECOLUMNS('BI_Autotask_Companies'[company_name], "Hours", SUM('BI_Autotask_Time_Entries'[hours_worked])), [Hours], DESC)
3.0 Billable vs Non-Billable

Split between billable and non-billable hours

75.6%
Billable (38,363h)
24.4%
Non-Billable (12,387h)
Non-BillableHours
-38,363.8
True12,387.8
View DAX Query — Billable vs Non-Billable query 
EVALUATE SUMMARIZECOLUMNS('BI_Autotask_Time_Entries'[is_non_billable], "Hours", SUM('BI_Autotask_Time_Entries'[hours_worked]))
4.0 Monthly Hours Trend

Monthly hours trend over the observed period

4,1923,6493,1062,5632,021 2,5344,0032,115 202502202504202506202508202510202512202601
MonthHours
2025022,534.3
2025033,330.5
2025043,588.0
2025053,314.9
2025063,198.0
2025073,536.6
2025082,686.4
2025093,864.6
2025104,003.3
2025113,314.2
2025123,247.4
2026012,115.7
View DAX Query — Monthly Hours Trend query 
EVALUATE TOPN(12, SUMMARIZECOLUMNS('BI_Common_Dim_Date'[year_month], "Hours", SUM('BI_Autotask_Time_Entries'[hours_worked])), 'BI_Common_Dim_Date'[year_month], DESC)
6.0 Analysis

What the data is telling us

The team logged 25,868 hours across 15 resources, averaging 1,724 hours per person. Look for outliers on both ends: engineers logging significantly more may be overloaded, while those with low hours may have logging compliance issues.

7.0 Recommended Actions
✓

1. Schedule Recurring Review

Set up a weekly or monthly review of internal vs client hours ratio metrics. Trends matter more than snapshots. Use the DAX queries in this report as your starting point.

✓

2. Connect Your Own Data

This report uses demo data. Connect Proxuma Power BI to your own Autotask PSA to generate this analysis from your real numbers.

8.0 Frequently Asked Questions
What data sources does the Internal vs Client Hours Ratio report use?

This report pulls data from PSA through the Proxuma Power BI integration, using DAX queries against the live data model.

How often is this data refreshed?

The underlying Power BI dataset refreshes daily. Reports can be regenerated at any time for the latest figures.

Can I customize this internal vs client hours ratio report?

Yes. Proxuma reports are fully customizable. You can modify the DAX queries, add new sections, or adjust the analysis to match your specific MSP needs.

Proxuma Power BI · AI-Generated Report · proxuma.io/powerbi Generated in < 15 minutes via MCP · March 2026
Related Reports
Client Management
Internal vs Client Hours: Where Your Team Really Spends Time
Resource-level breakdown of billable and non-billable hours from Autotask PSA. Generated by AI via Proxuma Power BI MCP
Read report Client Management
N-able RMM Customer Hierarchy
Analysis and reporting on customer hierarchy - parent-child accounts for managed service providers.
Read report Client Management
Client Coverage per Technician
Read report Client Management
Hoe Ziet Onze Capaciteitsvariantie Eruit (Gepland vs Actueel)?
Read report Client Management
Client Count Over Time
Growth trajectory, churn analysis, and portfolio health for your MSP client base.
Read report Financial
True Cost of Service: What Each Client Actually Costs You
A breakdown of cost, hours, revenue, and profit margin per client. Identifies loss-making accounts, cost-per-hour outlie
Read report

Generate this report from your own data

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