Set the ledger dates and layout for Ledger reconciliation - WIP accounts
Project management and accountingInquiries and reportsGeneral ledger reconciliation reports
output:ProjListLedgerReconWIPAccount
Business process
Manage project financials
Menu item
output:ProjListLedgerReconWIPAccount
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 that reconciles the WIP main accounts themselves: for each WIP account it compares the project postings with the general ledger balance for a date range, optionally with the ledger updates behind it.
What you do here
Use it at month-end when you reconcile the balance sheet WIP accounts account by account rather than per project.
Example
For October 2026 BEAT's controller sees WIP account 132100 (WIP sales value) at 84,300.00 on both sides and 132200 (WIP invoiced on-account) differing by 1,250.00, so she turns on Specify ledger updates to find the voucher.
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 close, when you reconcile the WIP main accounts themselves rather than per project.
How often
At each month-end close.
What the output shows
WIP accounts receive cost (WIP cost value), accrued revenue (WIP sales value) and on-account invoices (WIP invoiced - on account) depending on the cost and revenue profile, so a difference points to one posting type on one account. The report changes nothing; it only lists amounts.
First date of the reconciliation range.Checked in Dynamics 365
2026-10-01
To date
Last date of the reconciliation range.Checked in Dynamics 365
2026-10-31
Specify ledger updates
Show the ledger updates behind each WIP account instead of totals only.Checked in Dynamics 365
Yes
Skip zero
Leave out accounts whose amounts are zero.Checked in Dynamics 365
Yes
Common errors and fixes
Message
What to do
The project side and the ledger side differ for a project.
Look for general journal postings on the same account, a change in ledger posting setup during the period, or postings with a ledger date outside the range; correct project postings with Adjust transactions. Microsoft Learn
Use exactly one closed fiscal period as the ledger date range, after all project postings and Post costs for it are done, with Skip zero on.The report sets the project side next to the ledger side; open postings or a range that cuts a period make timing differences look like errors.
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: Running or rerunning the report changes no data.
If you change it later
WIP accounts receive cost (WIP cost value), accrued revenue (WIP sales value) and on-account invoices (WIP invoiced - on account) depending on the cost and revenue profile, so a difference points to one posting type on one account. Microsoft Learn
Technical architect
6Technical
Menu item
output:ProjListLedgerReconWIPAccountChecked 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: Ledger reconciliation - WIP accounts has no data entity in Data management: it is an SSRS report (design ProjListLedgerReconWIPAccount) that 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.Microsoft Learn
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-RC-290, Set the ledger dates and layout for Ledger reconciliation - WIP accounts. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RC-290