A report of the hour rates, one row per project: the revenue and cost per hour for hours posted to revenue and cost accounts. The report design is ProjHourRateProj.
Project management and accountingInquiries and reportsHour rate reports
output:ProjListProjHourRateProj
Business process
Analyze project performance
Menu item
output:ProjListProjHourRateProj
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone
1What it is and why
What it is
A report of the hour rates, one row per project: the revenue and cost per hour for hours posted to revenue and cost accounts. The report design is ProjHourRateProj.
What you do here
It answers what each hour really earns and costs per project, so pricing and staffing can be checked against the price lists. Project managers, project supervisors, the CEO and the CFO can run it on this system.
Example
BEAT runs Project hour rate for October 2026. PRJ-0042 earns 96.40 per hour against a cost of 61.25 per hour, while PRJ-0057 earns only 70.10, so the project manager checks the sales price (hour) used on PRJ-0057.
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
At month end, after timesheets are posted and revenue is accrued or invoiced.
How often
Monthly, or at each price review.
Batch settings
Run it from the dialog; schedule it monthly in the background if it feeds the pricing review.
What the output shows
Hours with the sales rate and cost rate per hour, one row per project. The report design is ProjHourRateProj.
Go to Project management and accounting > Inquiries and reports > Hour rate reports > Project hour rate.
Keep Hour turned on under Include transaction types and turn on the project types whose projects you price, normally Time and material and Fixed-price.
Enter the Ledger date range of a closed period so only hours already posted to revenue and cost accounts count.
Set Project view to Project (the default) or to a grouping such as customer, and set Project level to 1 to see parent projects with their subprojects summed into them.
Read the sales rate and cost rate per hour on each project row; a sales rate far below the price list points to non-chargeable line properties or old prices.
Open Sales price (hour) for the project with the lowest rate and check which price applied to its hours.
Turn on each project type to include. On this dialog the toggles are Time and material, Fixed-price, Investment, Internal and cost, and Time.Checked in Dynamics 365
Time and material on
Include transaction types
Hour is on by default on this dialog; the report is about hours, so other types add little.Checked in Dynamics 365
Hour on
Actual vs. budget
Actual (the default) shows posted hour rates; Budget shows the rates in the chosen forecast model.Checked in Dynamics 365
Actual
Forecast model
The forecast model that holds the budgeted hours and prices when Actual vs. budget is Budget.Microsoft Learn
BUD-ORIG
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.Checked in Dynamics 365
1
Skip blank ID
Leaves out lines that have no project ID.Checked in Dynamics 365
Skip zero
Leaves out rows where every amount is zero.Checked in Dynamics 365
Yes
(Project date) From date / To date
Limits the report to hours by the date the work was done.Checked in Dynamics 365
1 October 2026 to 31 October 2026
(Ledger date) From date / To date
Limits the report to hours by ledger posting date.Checked in Dynamics 365
1 October 2026 to 31 October 2026
Common errors and fixes
Message
What to do
The sales rate per hour of a project is zero.
The hours are not on revenue accounts yet (not accrued or invoiced) or sit on Internal or Time projects; accrue or invoice them, then rerun. Microsoft Learn
Test checklist
Post a timesheet of 8.00 hours on PRJ-0042 at a sales price of 95.00 and a cost price of 60.00 for BEAT.
Accrue revenue or invoice the hours.
Run Project hour rate for that date and check that the row shows 95.00 sales and 60.00 cost per hour.
Keep Hour as the only transaction type and filter on the ledger date of a closed period first.Hour rates are hours posted to revenue and cost accounts; open periods and other transaction types dilute the rate.
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: Reversible: the report changes no data. Checked in Dynamics 365
If you change it later
Rerun after timesheets are posted and revenue is accrued or invoiced; hour rates use hours posted to revenue and cost accounts. The report itself changes nothing downstream. Microsoft Learn
Technical architect
6Technical
Menu item
output:ProjListProjHourRateProjChecked 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 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