A report that totals the hour cost posted against the payroll allocation account per project category, with the hours behind it, for a project date and ledger date range.
Project management and accountingInquiries and reportsPayroll allocation reports
output:ProjListProjPayRollCategory
Business process
Analyze project performance
Menu item
output:ProjListProjPayRollCategory
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 that totals the hour cost posted against the payroll allocation account per project category, with the hours behind it, for a project date and ledger date range.
What you do here
Use it at period close to see how much payroll cost each project category absorbed and to explain the payroll allocation account.
Example
For October 2026 BEAT's controller sees category CONSULT carry 18,600.00 of payroll allocation for 465.00 hours and category TRAVELTIME only 320.00 for 8.00 hours, so most hours were booked to the right category.
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 period end, after hour postings are complete, when you want payroll cost split by project category instead of by project.
How often
On demand, at each period close or when category cost rates are reviewed.
What the output shows
One row per project category with the payroll allocation amount and hours. A category with an unexpected amount usually points to hours posted with the wrong category on the timesheet or hour journal.
Get payroll allocation per project category that can be checked against the ledger or the budget.
Steps from Microsoft
Go to Project management and accounting > Inquiries and reports > Payroll allocation reports > Category payroll allocation.
Under Include project types, turn on Time and material, Fixed-price, Investment or Internal and cost to choose which projects' hour categories are counted.
Enter the From date and To date under Project date and Ledger date for the period you want to analyze by category.
Under Data, set Actual vs. budget and, for budget figures, the Forecast model that holds the category budget.
Under Layout - columns, set Show amount (for example in thousands) and Show hour, turn on Skip zero to hide empty categories, then run the report and compare the category totals.
Choose how amounts are shown, such as with decimals, without decimals, or in thousands or millions.Microsoft Learn
Show hour
Choose whether to show the number of hours, the cost value of the hours, or both.Microsoft Learn
Common errors and fixes
Message
What to do
A project category with posted hours shows no payroll allocation amount.
Check the project cost and revenue profile of the project: with Post costs - hour set to No ledger or Never ledger the hour cost is not posted against the payroll allocation account. Microsoft Learn
Use the ledger date range of the closed period and keep Actual vs. budget on actual values.Posting an hour credits the payroll allocation account with its cost on the ledger date, so a ledger date range makes the report total comparable with the account.
On the live system, Project manager, Project supervisor, Chief executive officer and Chief financial officer can run this page.
Checked in Dynamics 365
Solution architect
5Design impact
Shared or per company
Per legal entity: the report reads only the project data of the company you are signed in to, so run it in each company you close. Checked in Dynamics 365
Can it be undone
Reversible: the report changes no data: The Category payroll allocation report only reads posted payroll allocation data; it changes nothing. Microsoft Learn
If you change it later
The report reads posted hour transactions and, for budgets, forecast lines. A change to cost prices or to the project cost and revenue profile affects only hours posted afterwards; past hours change only through Adjust transactions, after which you rerun the report. Microsoft Learn
Technical architect
6Technical
Menu item
output:ProjListProjPayRollCategoryChecked 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: Category payroll allocation has no data entity in Data management: the menu item ProjListProjPayRollCategory opens a report that only reads posted project data. There is nothing to migrate for the report itself; load the project data it reads, for example opening balances through Journals > Beginning balance, then run the report in the new system and compare its totals with the old one.Checked in Dynamics 365