A report that lists the general ledger updates made by posted on-account invoices, such as milestones and prepayments, per project for a ledger date range.
Project management and accountingInquiries and reportsGeneral ledger reconciliation reports
output:ProjListLedgerUpdatesOnAccount
Business process
Manage project financials
Menu item
output:ProjListLedgerUpdatesOnAccount
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 that lists the general ledger updates made by posted on-account invoices, such as milestones and prepayments, per project for a ledger date range.
What you do here
Use it after on-account billing to see on which accounts and dates the on-account invoices were posted.
Example
For October 2026 BEAT's project accountant sees PRJ-0057 with a 30,000.00 credit to WIP Invoiced - on account for milestone 3 and PRJ-0061 with 10,000.00 to Invoiced revenue - on account.
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
After on-account invoices for the period are posted, to review the ledger updates they created.
How often
On demand, at period close or after on-account billing.
What the output shows
An on-account invoice is credited to WIP Invoiced - on account when the profile uses Balance and to Invoiced revenue - on account when it uses Profit and loss; a profile change affects only later invoices. The report changes nothing; it only lists amounts.
Set the ledger dates and layout for Ledger updates - on-account
Get a result that can be matched with the general ledger for one period.
Steps from Microsoft
Go to Project management and accounting > Inquiries and reports > General ledger reconciliation reports > Ledger updates - on-account.
Under Ledger date, enter the From date and To date of the on-account invoices to review.
Under Layout, choose the Project view and Project level to group the on-account updates per project.
Turn on Skip zero, run the report, and check for each project whether the update went to WIP Invoiced - on account or to Invoiced revenue - on account.
Compare the totals with the Project on-account report for the same dates.
First ledger date of the postings to include.Checked in Dynamics 365
2026-10-01
To date
Last ledger date of the postings to include.Checked in Dynamics 365
2026-10-31
Project view
Groups the rows of the report, for example by project.Checked in Dynamics 365
Project
Project level
How many levels of subprojects are shown; 0 shows the project level as grouped.Checked in Dynamics 365
0
Skip zero
Leave out rows whose amounts are zero.Checked in Dynamics 365
Yes
Common errors and fixes
Message
What to do
A posted transaction has no on-account ledger update.
Check its ledger date against the range and the cost and revenue profile of the project: with No ledger the cost is posted later by Post costs, with Never ledger never. Microsoft Learn
Use the ledger date range of the period and group by Project so that each voucher can be traced to one project.The report lists the ledger updates of on-account postings; grouping by project lets you match them with the project reports of the same family.
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: the report changes no data: The on-account ledger updates report only reads data; it changes nothing. Microsoft Learn
If you change it later
An on-account invoice is credited to WIP Invoiced - on account when the profile uses Balance and to Invoiced revenue - on account when it uses Profit and loss; a profile change affects only later invoices. Microsoft Learn
Technical architect
6Technical
Menu item
output:ProjListLedgerUpdatesOnAccountChecked 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 updates - on-account has no data entity in Data management: the menu item ProjListLedgerUpdatesOnAccount opens a report that only 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.Checked in Dynamics 365