A report that compares the on-account amounts invoiced per project with the on-account forecast in a forecast model, as a deviation or as a sum of actuals up to a break date and forecast after it.
Project management and accountingInquiries and reportsOn account reports
output:ProjListProjOnAccountProj2Column
Business process
Analyze project performance
Menu item
output:ProjListProjOnAccountProj2Column
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 compares the on-account amounts invoiced per project with the on-account forecast in a forecast model, as a deviation or as a sum of actuals up to a break date and forecast after it.
What you do here
Use it in a billing review to see which projects bill on-account behind or ahead of plan.
Example
BEAT checks on-account billing against forecast model BUDGET26: PRJ-0057 has invoiced 55,000.00 against 85,000.00 planned by 2026-10-31, a deviation of -30,000.00 because milestone 3 slipped.
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
During a billing or budget review, when you check whether on-account invoicing per project is on plan.
How often
On demand, at each billing review or period close.
What the output shows
One row per project with actual and budgeted on-account amounts and the deviation or sum. A large negative deviation usually means planned milestones haven't been invoiced yet.
Set the selection for Project on-account (actual vs. budget)
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 (actual vs. budget).
Under Include project types, turn on Time and material or Fixed-price for the projects to check.
Under Data, set Actual vs. budget to Deviation or Sum and choose the Forecast model that holds the on-account budget.
Enter the From date, Break date and To date under Project date and Ledger date; with Sum, actuals stop and budget starts at the Break date.
Under Layout - rows, choose the Project view and Project level, run the report, and follow up on projects whose invoiced on-account amount lags the budget.
Pick the forecast model with the on-account forecast of the billing plan and set Actual vs. budget to Deviation.The budget column is read only from the chosen forecast model, and Deviation shows invoiced minus planned per project.
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 report only compares actual and budget figures; 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:ProjListProjOnAccountProj2ColumnChecked 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 (actual vs. budget) has no data entity in Data management: it is an SSRS report (design ProjOnAccProj2Column) 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