Run the Project hour utilization (efficiency rate) report
Project management and accountingInquiries and reportsHour utilization reports
output:ProjEfficiencyUtilProject
Business process
Analyze project performance
Menu item
output:ProjEfficiencyUtilProject
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone
1What it is and why
What it is
A report of the hour utilization efficiency rate, one row per project: the share of included hours that are productive, with utilization hours, burden hours and included hours.
What you do here
It answers how much of the recorded time is productive per project. For projects and categories the rate must use included hours. Project managers, project supervisors, the CEO and the CFO can run it on this system.
Example
BEAT runs Project hour utilization (efficiency rate) for October 2026. PRJ-0042 has 412.00 included hours, 398.00 productive, an efficiency rate of 96.60 percent, even though only 90.05 percent are billable.
The page in Dynamics 365. page title tab to open what to set or check
About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.
When to run it
When to run it
After all timesheets for the period are posted.
How often
Monthly, or once per timesheet period.
Batch settings
Run it from the dialog; schedule it monthly in the background for the resource review.
What the output shows
Utilization hours, burden hours, included hours and the efficiency rate percentage, one row per project.
Run the Project hour utilization (efficiency rate) report
Review the efficiency rate per project.
Steps from Microsoft
Go to Project management and accounting > Inquiries and reports > Hour utilization reports > Project hour utilization (efficiency rate).
Enter From date and To date for whole timesheet periods, for example 1 October 2026 to 31 October 2026, after all timesheets for them are posted.
Set Project view and Project level for the rows, and turn on Skip zero so projects without hours drop out.
Read utilization hours (productive), burden hours (non-productive) and included hours per project; the efficiency rate is utilization hours as a share of included hours.
For a project with a low efficiency rate, open its posted hour transactions and check the line properties of the non-productive hours.
Actual (the default) shows posted hours; Budget shows hours from the forecast.Checked in Dynamics 365
Actual
Forecast model
Not on the 10.0.49 dialog of this report, which shows Period, Actual vs. budget and the row layout only.Checked in Dynamics 365
Project view
How the first column is grouped: Project by default, or a grouping such as customer.Checked in Dynamics 365
Project
Project level
How many subproject levels the rows show; 1 by default.Checked in Dynamics 365
1
Skip blank ID
Leaves out lines that have no project ID.Checked in Dynamics 365
Skip zero
Leaves out projects with no hours.Checked in Dynamics 365
Yes
(Period) From date / To date
The dates of the hours to include. Use whole timesheet periods so every worker's time is complete.Checked in Dynamics 365
1 October 2026 to 31 October 2026
Common errors and fixes
Message
What to do
The efficiency rate looks too high for a project that had idle time.
Rates on included hours count only the hours entered; make sure workers record all their working time, including non-chargeable time, then rerun. Microsoft Learn
Hours of some project types are missing from the included hours.
Project types set to Not included are left out; check whether each type is set to Utilization, Burden or According to line property. Microsoft Learn
Test checklist
Post 30.00 chargeable and 10.00 non-chargeable hours for W-0042 on PRJ-0042 in one week for BEAT.
Run Project hour utilization (efficiency rate) for that week.
Check that included hours are 40.00 and that the efficiency rate follows the productive hours, not the chargeable ones.
Set From date and To date to whole, fully posted timesheet periods first.The rate is a share of hours; a partly posted or partial period changes the denominator and the rate with it.
On the live system, Project manager, Project supervisor, Chief executive officer and Chief financial officer can run this report.
Checked in Dynamics 365
Solution architect
5Design impact
Shared or per company
Per legal entity: the report reads the projects, transactions and setup of the company you run it in. Run it in each company to compare them. Checked in Dynamics 365
Can it be undone
Reversible: The report changes no data.
If you change it later
Rerun after timesheets are posted or the Utilization or Burden setting of a project type changes; both change the rate. The report itself changes nothing downstream. Microsoft Learn
Technical architect
6Technical
Menu item
output:ProjEfficiencyUtilProjectChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Load order: Project hour utilization (efficiency rate) has no data entity in Data management: it is a report. Move the project transactions, timesheets and forecasts it reads, and the report shows them when it runs.Checked in Dynamics 365
Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.
To cite this step: PM-RB-380, Run the Project hour utilization (efficiency rate) report. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RB-380