Job Profit and Loss
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 in 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.
If the Job Status is set to one of the following options for the Job Profit and Loss report, jobs that were closed before the Start/End Period date range are included in the report:
- All - All Jobs
- Closed - Closed Jobs
- All Active - Closed jobs and inactive open jobs.
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 before 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 before 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
