BeyondERP.Newsletter
Menu

Report page · Project management and accounting

Ledger reconciliation - WIP accounts

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.

Business process
Manage project financials
Menu item
output:ProjListLedgerReconWIPAccount
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 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 hereUse it at month-end when you reconcile the balance sheet WIP accounts account by account rather than per project.
ExampleFor 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.
Ledger reconciliation - WIP accounts 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 processManage project financials
Menu pathProject management and accounting › Inquiries and reports › General ledger reconciliation reports › Ledger reconciliation - WIP accounts
Set up firstAccrue revenue Microsoft Learn
Used next byAdjust transactions Microsoft Learn
Related pagesLedger reconciliation - WIP Microsoft Learn Ledger updates - WIP 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 itAt month-end close, when you reconcile the WIP main accounts themselves rather than per project.
How oftenAt each month-end close.
What the output showsWIP 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.

Source: Microsoft Learn

Setup steps on this page

Set the ledger dates and layout for Ledger reconciliation - WIP accounts

Get a result that can be matched with the general ledger for one period.

Steps from Microsoft

  1. Go to Project management and accounting > Inquiries and reports > General ledger reconciliation reports > Ledger reconciliation - WIP accounts.
  2. Under Reconciliation, enter the From date and To date of the month to reconcile.
  3. Turn Skip zero on and run the report once with Specify ledger updates off to see one total per WIP account.
  4. For an account with a difference, run it again with Specify ledger updates on to list the updates behind that account.
  5. Match the updates with Ledger updates - WIP and post corrections through project adjustments, not general journals.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
From dateFirst date of the reconciliation range.Checked in Dynamics 3652026-10-01
To dateLast date of the reconciliation range.Checked in Dynamics 3652026-10-31
Specify ledger updatesShow the ledger updates behind each WIP account instead of totals only.Checked in Dynamics 365Yes
Skip zeroLeave out accounts whose amounts are zero.Checked in Dynamics 365Yes

Common errors and fixes

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

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set the ledger dates and layout for Ledger reconciliation - WIP accountsUse 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.When do you run the reconciliation?Treating every difference as a project error: postings made directly to the same account by general journals appear only on the ledger side.Test: Ledger reconciliation - WIP accounts matches a known posting

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 report reads WIP account balances only; it changes nothing. Microsoft Learn
If you change it laterWIP 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 itemoutput:ProjListLedgerReconWIPAccount 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:ProjListLedgerReconWIPAccount
Data migrationLoad 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
Everyone

8Sources