User Personas: Project Manager
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. The Job Cost report is part of a broader reporting suite in eSUB Fusion that also includes Cost to Complete, Revenue, and Purchase Order reporting. See More Reports in the Suite below for an index.
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, you must have the Analytics - Job Cost Reports - View permission. Some reports in the suite have their own permissions. See the linked articles for each report.
Use the links below to jump to a topic:
The Reporting Menu
eSUB Fusion includes a top-level Reporting menu on the global navigation, giving you a single place to access reports without first opening a project. The Reporting menu is organized into two groups:
- Global Reports: company-wide roll-ups (such as the global Cost to Complete and Revenue reports) that aggregate data across all of the projects you can access.
- Project Reports: reports scoped to a single project. Choose a project from the project picker to open the report for that project.
Project-level reports, including the Job Cost report described in this article, also remain available from within each project under Reporting in the project slide-out menu.
View Job Cost Report
- 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.
Export the Job Cost Report
Export the Job Cost report to keep records or to continue your analysis in a spreadsheet.
- Select the Action button on the report, then choose your export option.
Option |
Result |
Export to Excel |
A native .xlsx workbook of the report data (including Summary and Details), with values currency-formatted. |
Export to CSV |
A .csv file of the report data. Because a single .csv file holds one data set, export the Summary and Details tabs separately. |
| Set up the report the way you want it before exporting. The export reflects the data currently shown. |
See the Document Downloads and Exports article for more information.
Job Cost Report
Job Cost Summary Tab
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.
Revenue
Feature |
Explanation |
Budget |
The original agreed-upon contract value for the job. This value consists of 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. |
| The Job Cost report reads Budget from the Contract Value field under Project Info not from your Schedule of Values. If you create or revise an SOV, update the Contract Value on Project Info to match your SOV total. If the two do not match, your Job Cost revenue and gross margin figures will reflect the Contract Value, not the SOV. |
Cost of Sales
Feature (All Categories) |
Explanation |
Budget |
The original job cost estimates are grouped by cost category. All values under the Budget column in this section pull from the Budgets page in Project Info. |
Approved Change Orders |
The cumulative value of the Cost column for each respective cost category on the Worksheet tab for all CORs on the project in Approved status. |
Total Budget |
The sum of the original job cost estimates and the approved change order Cost values for each cost category. |
Committed |
The costs committed against each cost type as you document the purchases and labor performed for the project. Purchase orders and labor accumulate here as committed costs. See Manage Budget Adjustments and Track Cost Commitments |
Uncommitted |
he portion of the Total Budget for each cost type that has not yet been committed. It is calculated as Total Budget minus Committed and shows the budget still available for each cost type. |
Total Cost of Sales
Feature |
Explanation |
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 Gross Margins and the original Gross Margins for each column. |
Total Budget |
The sum of the original job cost estimates and the approved change order Cost values for each cost category. |
Committed |
The sum of the committed costs across all cost categories in the section. |
Uncommitted |
The sum of the uncommitted values across all cost categories (Total Budget minus Committed). |
Labor Hours and Rate/Hours
Feature |
Explanation |
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. |
Committed Labor Hours |
The labor hours documented against the project that make up the committed labor cost. |
Uncommitted Labor Hours |
The budgeted labor hours not yet committed (Total Budget hours minus Committed hours). |
Committed Labor Rate/Hour |
The average committed labor cost per hour, calculated by dividing the committed labor cost by the committed labor hours. |
Uncommitted Labor Rate/Hour |
The average uncommitted labor cost per hour, calculated by dividing the uncommitted labor cost by the uncommitted labor hours. |
| Labor rates used in job cost calculations come from the rate templates assigned to the project. |
|
Missing labor commitments or labor dollars after entering a Daily Report with timecards?
The usual cause is a missing Labor Class or Rate Template. Blank values in the Labor Class field on the Crew tab of a Daily Report, or in the Timecard Management log, are the first tell. If no Labor Class or Rate Template was assigned when the Daily Reports were entered, the Job Cost Report will not show any committed labor dollars. To correct it:
The Job Cost Report may take a few minutes to reflect the change. |
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 Tab
The Details tab of the Job Cost report gives you a more granular view of your project's budget, grouped by cost category and broken out by cost code. 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 categories.
See the sections below for additional information on the various features of the Job Cost Details report.
Feature |
Explanation |
Cost Code No. & Description |
The cost code number and description 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. |
Budget |
he 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 |
The value of costs from change orders in Approved status that are associated with the cost code. |
Total Budget |
The sum of the original job cost estimates and the approved change order Cost values for each cost code. |
Committed |
The costs committed to each cost code as you document purchases and labor for the project |
Uncommitted |
he portion of the cost code's Total Budget that has not yet been committed (Total Budget minus Committed), showing the budget remaining for that 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.
More Reports
The Job Cost report works alongside several other reports that use the same budget, commitment, and change order data. Use the table below to find the right report for your question.
| Report | Purpose | Level |
| Cost to Complete Report |
Project - Forecasts what the project will
cost at completion and your projected gross profit. Combines
budget, approved CORs, committed costs, and an editable adjustment
column into a forward-looking forecast, with KPI cards and
Excel export. Global - Tracks how all of your projects are performing against forecast. Company-wide roll-up with filters (Project Manager, Market Area, Status), grouping, drill-through to the project-level report, and Excel/CSV export. Available from the top-level Reporting menu. |
Project & Global |
Permissions
Permission |
What it allows |
| Job Cost - Reports | View Job Cost Reports: Cost Summary and Cost Details as well as the Project Summary job cost widget. |
Administrators can adjust permissions; see Set Up User Permissions.
FAQ
Do time records have to be approved to pull into the Job Cost Reports?
No. A time record only needs an associated Labor Class with a known pay rate in order to calculate. Approval is a separate payroll step. See Time Management.
Why aren’t my Change Orders showing in the Approved Change Orders column?
The change order must be in Approved status. Anything short of approved does not affect the project budget. See Change Order Requests.
Why isn’t my Purchase Order showing as a committed cost?
A Purchase Order counts as a committed cost only while it is in a final status, meaning Open, Partial Shipment, Received in Full, or Complete. Preparatory and void statuses are excluded. The line item also has to be tied to a cost code. See Purchase Orders.
What is the difference between the Summary and Details tabs?
Summary is the high-level view of the project’s overall budget, commitments, and revenue margins. Details breaks the same data out by cost category and cost code, and shows only the cost codes that carry budgeted or committed values. See Job Cost Summary Tab and Job Cost Details Tab.
This report does not answer my question. Which report should I use?
Several reports run off the same budget, commitment, and change order data and are aimed at different questions. The comparison table at More Reports points you to the right one.