Job Cost Reports

User Personas: Project Management

Job cost reports enable you to keep track of the project’s budgeted costs versus committed costs in order to stay on top of the project’s fiscal health and maximize profit margins.

To get the most out of job cost reports, read the related articles Set Up Your Project for Job Cost Reporting and Manage Budget Adjustments and Track Cost Commitments.

To perform the actions described in this article, a user must have the Analytics - Job Cost Reports - View permission.

Use the links below to quickly jump to a topic:

• View Job Cost Reports
• Job Cost Summary
  • Job Cost Summary Features
• Job Cost Details
  • Job Cost Details Features

View Job Cost Reports

1. Select a project from the project list, then select Job Cost under Reporting from the slide out menu
   • Select the Summary tab or the Details tab depending on the data you wish to view

Job Cost Summary

The Summary tab of the Job Cost report gives you a high-level view of your project’s overall budget, commitments, and revenue margins.

See the sections below for additional information on the various features of the Job Cost Summary report.

Job Cost Summary Features

Revenue Section

• Budget: The original agreed-upon contract value for the job. This value is pulled from the Contract Value field under Project Info.
• Approved Change Orders: The cumulative value of the Approved Amount for all CORs on the project in Approved status.
• Total Budget: The sum of the original contract budget and approved change order totals.

Cost of Sales Section

• Budget (All cost types): The original job cost estimates are grouped by cost type. All values under the Budget column in this section pull from the Budgets page in Project Info.
• Approved Change Orders (All cost types): The cumulative value of the Cost column for each respective cost type on the Worksheet tab for all CORs on the project in Approved status.
• Total Budget (All cost types): The sum of the original job cost estimates and the approved change order Cost values for each cost type.

Total Cost of Sales Section

• Budget: The sum of values for each column in the section.
• Gross Margins: The margin of revenue for the job as a percentage and a dollar value. It is the difference between the Total Cost of Sales and the original Contract budget for each column.

Labor Hours and Rate/Hours

• Labor Hours: The allotted quantity of labor hours from the original job cost estimates, approved change orders, and the total budget respectively.
• Labor Rate/Hour: An average labor rate cost per hour that is calculated by dividing the labor cost by allotted labor hours for each column respectively.

Download the PDF at the bottom of this article for a visual representation of how the Job Cost Summary data is calculated. 

Job Cost Details

The Details tab of the Job Cost report gives you a more granular view of your project’s budget, grouped by cost type and broken out by the system*, phase*, and cost code (if applicable). Only cost codes with budgeted or committed values will appear in the report. A cost code may appear multiple times if it is used on multiple cost types.

See the sections below for additional information on the various features of the Job Cost Details report.

Job Cost Details Features

Report Columns

• Cost codes column: The cost code number and name as it appears on the project cost code list. An Unallocated cost code means that a cost code was not selected when committing the cost. See the Manage Budget Adjustments and Track Cost Commitments article for more guidance.
• Budget column: The original job cost estimate associated with the cost code. All values under the Budget column pull from the Budgets page in Project Info.
• Approved COR column: The value of costs from change orders in Approved status that are associated with the cost code.
• Total budget column: The sum of the original job cost estimates and the approved change order Cost values for each cost code.
• Total row: The sum of values for each column in the section.

Download the PDF at the bottom of this article for a visual representation of how the Job Cost Details data is calculated. 

*Available in a future release