A report that totals the on-account amounts invoiced per project, such as milestone billings and prepayments, for a project date and ledger date range.
Project management and accountingInquiries and reportsOn account reports
output:ProjListProjOnAccountProj
Business process
Analyze project performance
Menu item
output:ProjListProjOnAccountProj
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 totals the on-account amounts invoiced per project, such as milestone billings and prepayments, for a project date and ledger date range.
What you do here
Use it at period end to see how much each project has billed on-account and to explain the WIP invoiced on-account or on-account revenue accounts.
Example
At the October 2026 close BEAT's controller sees PRJ-0057 with 55,000.00 invoiced on-account (milestones 1 and 2) and PRJ-0061 with a 10,000.00 prepayment less a 4,000.00 deduction, so 6,000.00 net.
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 period end or before a customer review, when you want the on-account amounts invoiced per project for a date range.
How often
On demand, at period close or before customer billing reviews.
What the output shows
One row per project (grouped by Project view) with the on-account amount for the period. A project with zero usually has no posted on-account invoice in the ledger date range.
Get on-account billing per project that can be checked against the ledger or the plan.
Steps from Microsoft
Go to Project management and accounting > Inquiries and reports > On account reports > Project on-account.
Under Include project types, turn on Time and material or Fixed-price to choose the projects with on-account invoicing.
Enter the From date and To date under Project date and Ledger date for the on-account transactions to analyze.
Under Data, set Actual vs. budget and, for budget figures, the Forecast model.
Under Layout - rows, choose the Project view and Project level, turn on Skip blank ID or Skip zero to shorten the list, then run the report and check the on-account total per project.
Choose how amounts are shown, such as with decimals, without decimals, or in thousands or millions.Microsoft Learn
Common errors and fixes
Message
What to do
A project shows zero although a milestone was billed.
The on-account invoice probably has a ledger date outside the range or the project type is not turned on; check the posted invoice and the Include project types options. Microsoft Learn
Use the ledger date range of the closed period, actual values, and Project view by project.On-account invoices post on their ledger date to WIP Invoiced - on account or Invoiced revenue - on account, so ledger dates make the totals comparable with those accounts.
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 Project on-account report only reads posted data; it changes nothing. Microsoft Learn
If you change it later
The report reads posted on-account invoices and, for budgets, forecast lines. Whether an on-account invoice hit WIP Invoiced - on account or Invoiced revenue - on account depends on the project cost and revenue profile at posting; a profile change affects only later invoices. Microsoft Learn
Technical architect
6Technical
Menu item
output:ProjListProjOnAccountProjChecked 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 on-account has no data entity in Data management: it is an SSRS report (design ProjOnAccProj) 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