How to Generate Consolidated Project Profit & Loss

Overview:

A Consolidated Project Profit and Loss (P&L) Report combines the financial data of multiple projects into one report, giving a clear view of overall project performance. It shows total revenue, expenses, and profits across all projects, helping teams understand the financial health of their entire portfolio.

This article will walk you through the process of creating a consolidated P&L report, from gathering data to generating the final report. You’ll learn how to group financials from different projects and use the report to make informed decisions.

Scenario:

Generate a Consolidated Project Profit & Loss Report. 

Solution:

1. Create a transaction with a tagging of Project.

E.g. Bill Voucher was created with a Project: PROJ A

2. On the Navigation Pane, go to Reporting > Report Center.

3. In the Report Center screen, select the Project Reports tab. 

4. Click on the plus sign beside the Project Profit and Loss Accounts to expand the selection and click the Consolidated Project Profit and Loss Accounts.

5. Set the desired filter in the Consolidated Project Profit and Loss Accounts screen.

Filter

• Date: Only the projects within the selected date range will be included in the project notes to accounts report.

• Show Level: Specify the number of levels to display sub-accounts.

• Project: Categorized into four options.

  • All Projects: displays all projects.

  • No Projects:  displays documents with no projects assigned.

  • Main Projects: displays only parent projects with child projects.

  • Sub Projects: display only child projects and projects without child projects.
    E.g. Once Sub Project is selected, it will show a dropdown selection of the available child projects. The same approach in the Main Project, if there is a main project.

Options: 

• Include Zero: Include Profit and Loss accounts with a zero balance.

6.  Once done, click Preview to view the generated Consolidated Project Profit & Loss.

Application: 

You can now view the generated Consolidated Project Profit & Loss Report.