BeyondERP.Newsletter
Menu

Setup step on the Ledger reconciliation - profit and loss page · Project management and accounting

Set the ledger dates and layout for Ledger reconciliation - profit and loss

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

Business process
Manage project financials
Menu item
output:ProjListLedgerReconProfitLoss
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 isA report that compares, per project, the cost and revenue that projects posted to profit and loss accounts with the balances of those accounts in the general ledger, for a ledger date range.
What you do hereUse it at period close to tie project profit and loss to the general ledger before you report margins.
ExampleFor October 2026 BEAT's project accountant finds the project side at 312,880.00 revenue and 198,410.00 cost; the ledger shows 199,010.00 cost, and the 600.00 gap is a manual journal on the project cost account.
Ledger reconciliation - profit and loss 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 - profit and loss
Set up firstPost costs Microsoft Learn
Used next byAdjust transactions Microsoft Learn
Related pagesLedger updates - profit and loss Microsoft Learn Project profit and loss Microsoft Learn
In this process Set the ledger dates and layout for Ledger reconciliation - payroll allocation · Set the ledger dates and layout for Ledger reconciliation - WIP
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 period close, after project postings and invoices are complete, to reconcile project profit and loss amounts with the general ledger.
How oftenAt each period close.
What the output showsCosts reach profit and loss either directly (profile set to Profit and loss) or later through Post costs (profile set to Balance), and invoiced revenue at invoicing; run Post costs before the reconciliation or the project side and ledger side differ in timing. 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 - profit and loss

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 - profit and loss.
  2. Under Ledger date, enter the From date and To date of the closed period, after Post costs has run for it.
  3. Under Layout, set Project view and Project level the way you report margins, and turn Skip zero on.
  4. Run the report and check projects where the project profit and loss differs from the ledger.
  5. Use Ledger updates - profit and loss for the same dates to find the vouchers behind a difference.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
From dateFirst ledger date of the postings to include.Checked in Dynamics 3652026-10-01
To dateLast ledger date of the postings to include.Checked in Dynamics 3652026-10-31
Project viewGroups the rows of the report, for example by project.Checked in Dynamics 365Project
Project levelHow many levels of subprojects are shown; 0 shows the project level as grouped.Checked in Dynamics 3650
Skip zeroLeave out rows 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 - profit and lossUse 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 - profit and loss 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: Running or rerunning the report changes no data.
If you change it laterCosts reach profit and loss either directly (profile set to Profit and loss) or later through Post costs (profile set to Balance), and invoiced revenue at invoicing; run Post costs before the reconciliation or the project side and ledger side differ in timing. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:ProjListLedgerReconProfitLoss 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:ProjListLedgerReconProfitLoss
Data migrationLoad order: Ledger reconciliation - profit and loss has no data entity in Data management: it is an SSRS report (design ProjListLedgerRecon) 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

To cite this step: PM-RC-270, Set the ledger dates and layout for Ledger reconciliation - profit and loss. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/PM-RC-270