BeyondERP.Newsletter
Menu

Setup step on the Resource hour utilization (billable rate) page · Project management and accounting

Run the Resource hour utilization (billable rate) report

Review the billable rate per resource (worker) or item.

Business process
Analyze project performance
Menu item
output:ProjBillUtilEmpl
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 isA report of the hour utilization billable rate, one row per worker: the share of included hours that are chargeable, with utilization hours, burden hours and included hours.
What you do hereIt answers how much of the recorded time is chargeable per worker. For workers the rate can use norm hours or included hours. Project managers, project supervisors, the CEO and the CFO can run it on this system.
ExampleBEAT runs Resource hour utilization (billable rate) for October 2026. Worker W-0042 recorded 168.00 hours, 126.00 of them chargeable, a billable rate of 75.00 percent against a target of 80.00.
Resource hour utilization (billable rate) page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

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 itAfter all timesheets for the period are posted.
How oftenMonthly, or once per timesheet period.
Batch settingsRun it from the dialog; schedule it monthly in the background for the resource review.
What the output showsUtilization hours, burden hours, included hours and the billable rate percentage, one row per worker.

Source: Microsoft Learn

Setup steps on this page

Run the Resource hour utilization (billable rate) report

Review the billable rate per resource (worker) or item.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Hour utilization reports > Resource hour utilization (billable rate).
  2. Choose a Worker period, or enter From date and To date for whole timesheet periods, for example 1 October 2026 to 31 October 2026.
  3. Leave Hide employee lines off to see each worker's rate, and turn on Skip zero to drop workers without hours.
  4. Read utilization hours (chargeable), burden hours (non-chargeable) and included hours per worker; the billable rate is utilization hours as a share of included hours.
  5. For a worker below target, check the worker's capacity in Resource availability and plan more chargeable work.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Hide employee linesHides the line for each worker so only the totals show.Checked in Dynamics 365No
Actual vs. budgetActual (the default) shows posted hours; Budget shows hours from the forecast.Checked in Dynamics 365Actual
Forecast modelNot on the 10.0.49 dialog of this report, which shows Period, Actual vs. budget and the row layout only.Checked in Dynamics 365
Skip zeroLeaves out workers with no hours.Checked in Dynamics 365Yes
(Period) From date / To dateThe dates of the hours to include. Use whole timesheet periods so every worker's time is complete.Checked in Dynamics 3651 October 2026 to 31 October 2026
Worker periodThe worker period whose dates fill the From date and To date. Norm billable and norm efficiency hours are kept per worker and period.Microsoft data model MONTH

Common errors and fixes

MessageWhat to do
The billable rate looks too high for a resource 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

Test checklist

  1. Post 30.00 chargeable and 10.00 non-chargeable hours for W-0042 on PRJ-0042 in one week for BEAT.
  2. Run Resource hour utilization (billable rate) for that week.
  3. Check that included hours are 40.00 and the billable rate is 75.00 percent.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Resource hour utilization (billable rate) reportChoose the Worker period first, so the dates match the norm hours of each worker.The rate is a share of hours; a partly posted or partial period changes the denominator and the rate with it.Should the billable rate use norm hours or included hours?Comparing a worker's rate on norm hours with a project's rate on included hours; they measure against different totals.Test: Resource hour utilization (billable rate) calculates the rate from posted hours

Feature management and licence

Licence or add-inOn 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 companyPer 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 undoneReversible: The report changes no data.
If you change it laterRerun 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 itemoutput:ProjBillUtilEmpl Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo 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
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:ProjBillUtilEmpl
Data migrationLoad order: Resource hour utilization (billable 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
Everyone

8Sources

To cite this step: PM-RB-370, Run the Resource hour utilization (billable rate) report. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RB-370