A report of the work in progress (WIP) balances held on balance sheet accounts, one row per project, comparing actual figures with the budget held in a forecast model. The report design is ProjWIPProj2Column.
Project management and accountingInquiries and reportsWIP reports
output:ProjListProjWIPProj2Column
Business process
Analyze project performance
Menu item
output:ProjListProjWIPProj2Column
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 of the work in progress (WIP) balances held on balance sheet accounts, one row per project, comparing actual figures with the budget held in a forecast model. The report design is ProjWIPProj2Column.
What you do here
It answers how much cost, revenue or on-account billing is still held in WIP for each of the projects, as an actual-against-budget check, so the controller knows what still has to be recognized or eliminated. The Project manager, Project supervisor, CEO and CFO roles can run it on this system.
Example
BEAT runs Project WIP (actual vs. budget) against forecast model BUD-ORIG for 2026, with a break date at 30 June. PRJ-0042 shows actual WIP 2,887.50 above the budget, which the controller raises at the project 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 revenue recognition is calculated and before it is posted, 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
WIP balances, one row per project, actual against the budget in the forecast model. The report design is ProjWIPProj2Column.
Review work in progress (WIP) balances per project comparing actual figures with the budget held in a forecast model.
Steps from Microsoft
Go to Project management and accounting > Inquiries and reports > WIP reports > Project WIP (actual vs. budget).
Turn on Fixed-price and Investment projects, whose costs and on-account amounts are held in WIP accounts until revenue is recognized or the project is eliminated, and the transaction types that build each project's WIP.
Enter From date, Break date and To date, keep Actual vs. budget on Deviation and pick the Forecast model that holds the WIP budget, for example BUD-ORIG.
Set Project view to Project (the default) or to a grouping such as customer, and set Project level to 1 to see parent projects with their subprojects summed into them.
Read the WIP balance on each project row; a balance that keeps growing on a finished project means revenue recognition or elimination has not been posted.
Tie the WIP total to Ledger reconciliation - WIP, then calculate and post revenue recognition for the projects whose WIP should be released.
Turn on each project type to include; at least one must be on. Fixed-price and Investment projects are the ones that typically hold costs in WIP.Microsoft Learn
Fixed-price and Investment on
Include transaction types
Turn on each transaction type to include, such as Hour, Expense, Item, Fee and On-account.Microsoft Learn
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
Break date
A date between From date and To date. With Actual vs. budget set to Sum, actual WIP is taken up to this date and budgeted WIP after it.Checked in Dynamics 365
30 June 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
Project view
How the first column is grouped: Project by default, or a grouping such as project group or customer.Checked in Dynamics 365
Project
Project level
How many subproject levels the rows show; 1 sums subprojects into their parent project.Checked in Dynamics 365
1
Skip blank ID
Leaves out lines that have no project 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 Project WIP (actual vs. budget) for BEAT for October 2026 with PRJ-0042 in the data.
Open the WIP ledger account balance for the same date in the trial balance.
Check that the report's WIP total equals the ledger balance; a difference goes to Ledger reconciliation - WIP.
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: Reversible: the report changes no data. Checked in Dynamics 365
If you change it later
Rerun after revenue recognition is calculated, posted or eliminated; those steps move amounts out of WIP. The report itself changes nothing downstream. Microsoft Learn
Technical architect
6Technical
Menu item
output:ProjListProjWIPProj2ColumnChecked 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: Project WIP (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