A report that lists posted project transactions grouped first by project, with amounts per transaction type, for the project and ledger dates you choose.
Project management and accountingInquiries and reportsActual transactions reports
output:ProjListTransProj
Business process
Analyze project performance
Menu item
output:ProjListTransProj
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 posted project transactions grouped first by project, with amounts per transaction type, for the project and ledger dates you choose.
What you do here
Use it to answer 'what did each project actually cost and earn in this period?' at period end, before reviews with project managers.
Example
At October close the BEAT controller runs the report for Time and material and Fixed-price with Hour, Expense and Item on, ledger dates 1 to 31 October, and sees PRJ-0042 with 18,450.00 EUR cost against 24,600.00 EUR revenue.
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, after hours, expenses and items for the period are posted.
How often
Monthly at period end.
What the output shows
Posted amounts per project, broken down by the levels you choose.
Which project types to include; the dialog toggles Time and material, Fixed-price, Investment, Internal and cost (Internal and Cost project types) and Time. Time projects post nothing to the ledger.Microsoft Learn
Time and material, Fixed-price
Include transaction types
Hour, Expense, Item, Fee and On-account; turn on what the review covers.Checked in Dynamics 365
Hour, Expense, Item
(Project date) From date / To date
The range of project dates: when the work was done.Microsoft Learn
1 October to 31 October
(Ledger date) From date / To date
The range of ledger dates: when the transactions were posted to the ledger.Microsoft Learn
Project statement
The statement the amounts follow; the dialog suggests Profit and loss.Checked in Dynamics 365
Profit and loss
Skip zero
Leaves out rows whose amounts are zero.Checked in Dynamics 365
Yes
Show amount
Choose how amounts appear, such as with or without decimals, or in thousands.Microsoft Learn
Show hour
Choose whether to show hour quantities, hour cost values, or both.Microsoft Learn
PL ratio
Choose whether to add a profit and loss ratio column, such as gross margin.Microsoft Learn
Layout - rows
Level 1 to 3 set the row grouping; Level 1 is Project on this report.Checked in Dynamics 365
Level 1 Project, Level 2 Category
Common errors and fixes
Message
What to do
Totals are lower than on Project statements.
A transaction type or project type is turned off, or both date ranges were filled and filter twice. Microsoft Learn
Test checklist
Post 10.00 hours and a 500.00 EUR expense on PRJ-0042 in October.
Run the report with Hour and Expense on, ledger dates in October.
Check that PRJ-0042 shows both amounts.
Compare the total with Project statements for October.
Use the Ledger date range of the closed period, leave Project date empty, and keep Level 1 on Project.Ledger dates match the general ledger period; project dates show when work happened and can fall in another period.
The report reflects postings and adjustments at the moment it runs, so totals for a closed period change if transactions are adjusted later. Microsoft Learn
Technical architect
6Technical
Menu item
output:ProjListTransProjChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To use itProject manager ProjProjectManagerProject supervisor ProjProjectSupervisorProject accountant ProjProjectAccountantChief executive officer CompanyChiefExecutiveOfficerProject assistant ProjProjectClerkGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Load order: The Project actual transactions report has no data entity in Data management: it reads posted project transactions. Open balances from a former system are loaded as beginning balance journals, which update only the project subledger, so compare their totals with this report after cutover.Microsoft Learn