A report that compares actual payroll allocation per resource with the budget held in a forecast model, as a deviation or as a sum of actuals up to a break date and budget after it.
Project management and accountingInquiries and reportsPayroll allocation reports
output:ProjListProjPayRollEmplItem2Column
Business process
Analyze project performance
Menu item
output:ProjListProjPayRollEmplItem2Column
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 compares actual payroll allocation per resource with the budget held in a forecast model, as a deviation or as a sum of actuals up to a break date and budget after it.
What you do here
Use it in a project or budget review to see which resource and item runs over or under its planned payroll cost.
Example
BEAT checks resource 000123 against forecast model BUDGET26: 6,080.00 actual against 6,400.00 forecast for October 2026, a deviation of -320.00.
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
During a resource or budget review, after timesheets are posted, when you compare each resource's actual payroll allocation with the forecast.
How often
On demand, at each budget review or period close.
What the output shows
One row per resource with actual and budgeted payroll allocation and the deviation or sum. A resource with budget but no actuals usually has no posted timesheets in the range.
Set the selection for Resource payroll allocation (actual vs. budget)
Get payroll allocation per resource 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 > Resource payroll allocation (actual vs. budget).
Under Include project types, turn on Time and material, Fixed-price, Investment or Internal and cost for the projects whose resource budgets you check.
Under Data, set Actual vs. budget to Deviation or Sum and choose the Forecast model that holds the resource forecast.
Enter the From date, Break date and To date under Project date and Ledger date to set the actual and budget ranges.
Under Layout - columns, set Show amount, run the report, and check resources whose actual payroll cost is far from their forecast.
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
The deviation equals the whole actual amount on every row.
The chosen forecast model holds no hour forecasts for these rows. Pick the model with the budget, or enter the hour forecasts under All project forecasts. Microsoft Learn
Choose the forecast model that holds the approved budget and set Actual vs. budget to Deviation.The budget column comes only from the forecast model you pick; Deviation shows actual minus budget per row, which is the number the review acts on.
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 Resource payroll allocation (actual vs. budget) 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:ProjListProjPayRollEmplItem2ColumnChecked 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: Resource payroll allocation (actual vs. budget) has no data entity in Data management: the menu item ProjListProjPayRollEmplItem2Column 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