The Project P&L builds upon a traditional profit and loss report for projects. As in the Client P&L, the report then goes beyond the profit, loss, and contribution calculations to provide additional calculations that show a more in-depth view of key indicators for projects.

The report can be set to look at Open Projects only, Closed Projects only or both for a given time span.

For time period, you can select projects that have an open date within the selected date range or a close date within the selected date range (1). To set the date range customize the dates in the Date Range fields (2) or use Quick Select for a predefined date range (3).

From the pull down menu under Client, you can select any individual client, or all clients (4).

The Project Manager filter allows the selection of individual Project Managers (5).

The Staus filter allows the report to look at only opened projects, closed projects or both (6).

Note: This report can be downloaded into PDF, Excel or CSV files for use outside of the MSPCFO system.  In Excel or CSV files, there is a choice of viewing the whole report, only group totals, or only individual records.   When using the '+' the report is stored in a Download Basket to be downloaded with other reports at a later time. A report profite can be saved to be used in recurring deliveries.

The Projects are grouped into Project Types which have been set up in your PSA.  To view each individual project, click on the '+' under the Project Type (highlighted).

The report can be sorted on each of the columns. Click in the column header box to sort the report on a specific column. The  data can be sorted in  ascending or descending order for the individual metric.  In the example below, the sort is done in descending order on the Revenue Labor.

The top line Project Type is the aggregate of all the Client Projects that belong to this project type. The report in the example below is sorted on Efficiency Rate, high to low (highlighted).

For each project, the metrics are broken down into:

Client

Billing Method - F for fixed fee and A for actual rate

Revenue - Labor, Product, Expenses and Total (Note: For labor revenue, when the project is still opened, the value represents the lesser of the shadow billable or the invoiced labor. When the project closes, the value represents the invoiced labor. )

COGS - Labor and Product, Expenses and Total

Contribution - Labor ($ and %), Product ($ and %), and  Total ($ and %)

Hours - Total hours for the project to date,

Effective Rate

Contribution per Hour

Invoiced Labor - The labor portion of the revenue invoiced

Shadow billable - FFA labor had it been billed on an hourly basis

Efficiencies - FFA labor revenue / FFA shadow billable

Labor Balance - Invoiced labor less shadow billable which is only used when a project is not closed. This shows for an active project if at the point of time you are under or over the revenue which has been invoiced. When the project closes, this value goes back to zero.

In the example below the Project Type 7 is opened up to list all projects within that project type.