Run the Resource/item profit and loss (actual vs. budget) report
Project management and accountingInquiries and reportsProfit and loss reports
output:ProjListProjProfitLossEmplItem2Column
Business process
Analyze project performance
Menu item
output:ProjListProjProfitLossEmplItem2Column
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone
1What it is and why
What it is
A report of revenue, cost and gross margin, one row per resource (worker) or item, comparing actual figures with the budget held in a forecast model, built from posted project transactions. The report design is ProjProfitLossEmpl2Column.
What you do here
It answers which resources and items make or lose money, as an actual-against-budget check. On this system the Project manager, Project supervisor, CEO and CFO roles can run it; use it at month end to decide where to act on price, cost or scope.
Example
BEAT checks Resource/item profit and loss (actual vs. budget) against forecast model BUD-ORIG for 1 July to 31 December 2026, with the break date at 30 September. W-0042 shows a deviation of 3,924.50 on cost, which the project supervisor explains at the budget review.
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 costs are posted and revenue is accrued or invoiced, at the budget review.
How often
Monthly
Batch settings
Run it from the dialog for one review, or run it in the background on a monthly recurrence for the close pack.
What the output shows
Revenue, cost and gross margin, one row per resource (worker) or item, actual against the budget in the forecast model. The report design is ProjProfitLossEmpl2Column.
Run the Resource/item profit and loss (actual vs. budget) report
Review revenue, cost and gross margin per resource (worker) or item comparing actual figures with the budget held in a forecast model.
Steps from Microsoft
Go to Project management and accounting > Inquiries and reports > Profit and loss reports > Resource/item profit and loss (actual vs. budget).
Turn on the project types and transaction types the resource or item figures should cover; for revenue and margin keep Time and material and Fixed-price on with all transaction types, because Time projects carry no ledger amounts.
Enter From date, Break date and To date, keep Actual vs. budget on Deviation and pick the Forecast model that holds the profit and loss budget, for example BUD-ORIG.
Turn on Skip zero to hide resources and items with no amounts, and Skip blank ID to leave out lines that carry no resource or item ID.
Read revenue, cost and gross margin on each resource or item row; a row with cost but no revenue usually means hours are posted but not yet accrued or invoiced.
Tie the total to Ledger reconciliation - profit and loss for the same dates, then follow up the resource or item with the weakest margin with its project manager.
Turn on each project type to include; at least one must be on. Time projects post no ledger transactions, so they add hours but no amounts to financial totals.Microsoft Learn
Time and material and Fixed-price on
Include transaction types
Turn on each transaction type to include, such as Hour, Expense, Item, Fee and On-account.Microsoft Learn
(Project date) From date / Break date / To date
The date range, with a break date inside it. With Actual vs. budget set to Sum, actual figures are taken up to the break date and budget figures after it.Checked in Dynamics 365
1 July 2026 / 30 September 2026 / 31 December 2026
(Ledger date) From date / Break date / To date
The date range, with a break date inside it. With Actual vs. budget set to Sum, actual figures are taken up to the break date and budget figures after it.Checked in Dynamics 365
1 July 2026 / 30 September 2026 / 31 December 2026
Forecast model
The forecast model that holds the budget figures. With project budget control, pick the original or remaining budget forecast model that the project's budget uses.Microsoft Learn
BUD-ORIG
Actual vs. budget
Deviation (the default on this dialog) shows actual against budget; Sum adds actual and budget together, split at the break date.Checked in Dynamics 365
Deviation
Skip blank ID
Leaves out lines that have no resource or item ID.Checked in Dynamics 365
Skip zero
Leaves out rows where every amount is zero.Checked in Dynamics 365
Yes
Show amount
How amounts are printed: With decimals (the default), without decimals, or in thousands or millions.Checked in Dynamics 365
With decimals
Common errors and fixes
Message
What to do
The budget side of every row is zero.
The Forecast model is empty or not the one the budget lives in; with project budget control pick the original or remaining budget forecast model. Microsoft Learn
Test checklist
Run Resource/item profit and loss (actual vs. budget) for BEAT for October 2026 with W-0042 in the data.
Open the project's statement for the same dates and project types.
Check that revenue and cost on the W-0042 row match the statement to the cent.
Pick the Forecast model that holds the approved budget first, then the date range and break date; keep Actual vs. budget on Deviation.The deviation is only as good as the model behind it; a wrong or empty model makes every row look over or under budget.
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: The report changes no data.
If you change it later
Rerun after Post costs, Accrue revenue, invoice posting or adjustments; the figures change as soon as new transactions are posted for the dates. The report itself changes nothing downstream. Microsoft Learn
Technical architect
6Technical
Menu item
output:ProjListProjProfitLossEmplItem2ColumnChecked 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/item profit and loss (actual vs. budget) 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
Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.
To cite this step: PM-RB-090, Run the Resource/item profit and loss (actual vs. budget) report. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RB-090