BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Category payroll allocation (actual vs. budget)

A report that compares actual payroll allocation per project category 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.

Business process
Analyze project performance
Menu item
output:ProjListProjPayRollCategory2Column
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 isA report that compares actual payroll allocation per project category 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 hereUse it in a project or budget review to see which project category runs over or under its planned payroll cost.
ExampleBEAT checks categories against forecast model BUDGET26: category CONSULT is at 41,200.00 against 38,000.00 budgeted, a deviation of 3,200.00 that the controller follows up.
Category payroll allocation (actual vs. budget) 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

Business processAnalyze project performance
Menu pathProject management and accounting › Inquiries and reports › Payroll allocation reports › Category payroll allocation (actual vs. budget)
Set up firstAll project forecasts Microsoft Learn
Used next byCategory payroll allocation (2 periods) Microsoft Learn
Related pagesProject payroll allocation (actual vs. budget) Microsoft Learn Resource payroll allocation (actual vs. budget) Microsoft Learn Forecast models Microsoft Learn
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 itDuring a budget review, after the period's hours are posted, when you want to see which project categories are over or under their payroll budget.
How oftenOn demand, at each budget review or period close.
What the output showsOne row per project category with actual, budget and deviation (or sum) amounts. Many categories with only budget and no actuals usually means hours were posted to other categories than were budgeted.

Source: Microsoft Learn

Setup steps on this page

Set the selection for Category payroll allocation (actual vs. budget)

Get payroll allocation per project category that can be checked against the ledger or the budget.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > Payroll allocation reports > Category payroll allocation (actual vs. budget).
  2. Under Include project types, turn on Time and material, Fixed-price, Investment or Internal and cost for the projects whose category budgets you check.
  3. Under Data, choose Deviation or Sum in Actual vs. budget and pick the Forecast model with the category budget.
  4. Enter the From date, Break date and To date under Project date and Ledger date; the Break date only matters when you use Sum.
  5. Under Layout - columns, set Show amount, run the report, and look at the categories with the largest deviation from budget.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Include project typesChoose which project types the report covers.Microsoft Learn
Actual vs. budgetChoose Deviation to see the difference between actual and budgeted values, or Sum to see them added together.Microsoft Learn
Break dateWhen Sum is selected, this date marks where actual values stop and budgeted values start.Microsoft Learn
Forecast modelChoose the forecast model that supplies the budget figures; with project budget control, use the project's budget forecast model.Microsoft Learn
Skip zeroLeave out rows where the amounts are zero.Microsoft Learn
Show amountChoose how amounts are shown, such as with decimals, without decimals, or in thousands or millions.Microsoft Learn
Show hourChoose whether to show the number of hours, the cost value of the hours, or both.Microsoft Learn

Common errors and fixes

MessageWhat 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
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set the selection for Category payroll allocation (actual vs. budget)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.How are actuals and budget combined?Picking a forecast model with no hour forecasts: every row then shows the full actual amount as deviation.Test: Category payroll allocation (actual vs. budget) shows posted hour cost

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 page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer 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 undoneReversible: the report changes no data: The Category payroll allocation (actual vs. budget) report only reads posted payroll allocation data; it changes nothing. Microsoft Learn
If you change it laterThe 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 itemoutput:ProjListProjPayRollCategory2Column 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:ProjListProjPayRollCategory2Column
Data migrationLoad order: Category payroll allocation (actual vs. budget) has no data entity in Data management: the menu item ProjListProjPayRollCategory2Column 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
Everyone

8Sources