Project management and accountingInquiries and reportsPayroll allocation reports
output:ProjListProjPayRollCategory2ColumnPeriod
Business process
Analyze project performance
Menu item
output:ProjListProjPayRollCategory2ColumnPeriod
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 shows payroll allocation per project category for two ledger date ranges side by side, so you can compare two periods.
What you do here
Use it to see how payroll cost per project category moved between two periods, for example month against month or quarter against quarter.
Example
BEAT compares Q3 with Q4 2026 per category: category CONSULT falls from 54,300.00 to 41,200.00 of payroll allocation, matching the end of two consulting projects.
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 a period is closed, when you want to see how payroll cost per project category moved compared with another period.
How often
On demand, at period close or when category cost trends are reviewed.
What the output shows
One row per project category with one column per period. Unlike Category payroll allocation, it compares two ledger periods; a category that appears in only one column usually had no hours posted in the other period.
Set the selection for Category payroll allocation (2 periods)
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 (2 periods).
Under Include project types, turn on Time and material, Fixed-price, Investment or Internal and cost to choose the projects whose categories you compare.
Enter the From date and To date under Ledger date - Period 1 and Ledger date - Period 2 for the two periods to compare by category.
Under Data, set Actual vs. budget and the Forecast model if you compare budget figures.
Under Layout - columns, set Show amount and Show hour, turn on Skip zero under Layout - rows, then run the report and compare each category's two columns.
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
One column is much smaller than expected.
Hours of that period are probably not posted yet or carry a ledger date in the other period; post the remaining timesheets and check the ledger dates of late hour journals. Microsoft Learn
Enter two periods of the same length, for example two full months, under Ledger date - Period 1 and Period 2.The two columns are plain totals for each range, so periods of different length or overlapping dates distort the comparison.
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 (2 periods) 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:ProjListProjPayRollCategory2ColumnPeriodChecked 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 (2 periods) has no data entity in Data management: the menu item ProjListProjPayRollCategory2ColumnPeriod 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