This report allows you to view revenue and cost incurred on a job, as well as profit and loss over a specific period of time. You can view profit and loss for all jobs, all open jobs, open and active jobs, open but inactive jobs, all inactive jobs, and closed jobs. This report includes information for both open and closed periods. The information on this report can be summarized by job or project (Master ID), Customer, Project Manager, or Division. Your selection in the Summarize By field enables the appropriate filter. You can also specify a date range by selecting a start year and period and an end year and period. By default, the report returns results from the first fiscal year and period set up in Job Cost to the last fiscal year and period set up in Job Cost.

The fields on the report are calculated as follows:

• Actual % Complete: Actual Cost / Total Forecasted Cost

• Expected Contract: For Fixed Amount jobs - based on the last day in the end period (end date) of the report. For Cost Plus jobs: Based on the range from the start date of the report to the end date of the report. 

  If you are viewing a Cost Plus job that began prior to the report start date, the Contract Earned amount is adjusted to reflect what was earned in the report range, rather than over the life of the job. For Cost Plus NTE jobs, the Contract Earned displays as zero if the NTE amount is exceeded prior to the report start date.

• Contract Earned: Actual % Complete x Expected Contract
• Profit Amount: Contract Earned - Actual Cost
• Markup Percent: (Expected Contract - Total Forecasted Cost) / Total Forecasted Cost
• Margin Percent: (Expected Contract - Total Forecasted Cost) / Expected Contract

Summarized by job

Summarized by customer