--- title: "Project Job Costing report template" slug: "project-job-costing-report-template" tags: ["Area - Jobs, Appts, Projects", "Focus - Construction", "Role - Accountant", "Role - Admin", "Type - Commercial", "Type - Residential"] updated: 2026-07-11T16:59:25Z published: 2026-07-11T16:59:25Z canonical: "help.servicetitan.com/project-job-costing-report-template" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.servicetitan.com/llms.txt > Use this file to discover all available pages before exploring further. # Project Job Costing report template ## Overview The Project Job Costing template calculates job costs for an entire project. Compare total costs to revenue to determine gross margins. Each line in the report represents a project. Example Project Job Costing reports: - Compare material and equipment costs to project revenue - Schedule weekly delivery of project labor cost reports --- ### #### Who uses this feature - Administrators and office employees - Primarily for Residential Construction and Commercial Construction business types #### Feature configuration - Creating custom reports is available only to contractors on the Works package or Legacy/Non-Packaged contractors. Contractors on the Starter and Essentials packages have access to [built-in reports](/v1/docs/built-in-reports). ## Things to know - Including payroll costs in job costing requires account configuration. Please contact [Technical Support](/v1/docs/contact-servicetitan-technical-support) for details. - If your account is configured to include payroll costs, [set technician burden rates without payroll costs](/v1/docs/calculate-technician-burden-rates) to avoid double counting payroll. - If a report item is underlined, select it and click the Caret to drill down and view additional details. ![A gif showing the PO costs of the report being drilled into.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/project-job-costing-report-template-image-nguybwc3.gif) - If you're unsure which columns you want to include in your report, use the [Reporting Dictionary](/v1/docs/reporting-dictionary) to search for appropriate data fields. - You can use this template to create as many custom reports as you need. Each report created from the template is independent and can be run or scheduled without needing to recreate it from the original template. ## Create a Project Job Costing report Follow the steps to [create a custom report](/v1/docs/create-custom-reports) based on the Project Job Costing template and select the columns to include in your report. The Project Job Costing template has these columns selected by default: - **Percent Completed:** Percent of jobs on the project that are complete - **Completed Jobs:** Count of completed jobs on the project You can customize the report by selecting additional columns from these sections: - **Basic Details:** Fields from the project record - **Customer Details:** Common fields from the Customer Record - **Jobs:** Status of jobs on the project - **Totals and Discounts:** Dollar amounts related to invoices, estimates, and discounts - **Summary:** Total revenue and gross margin details - **Job Time:** Payroll activities related to the project - **Cost Totals:** See below the *Cost Totals report columns* section - **Project Name:** Any name given to the project - **Project Business Unit:** Business unit attached to the project - **Project Status:** The current status of the project - **Project Manager:** Name of the project manager - **Start Date:** Date the project began - **Target Completion Date:** Date the project is targeted to finish - **Actual Completion Date:** Date the project was completed ### Cost Totals report columns The *Cost Totals* section includes these job costing-related columns: - **Material Costs:** Sum of cost of material items on invoices, including adjustment invoices, if selected in the report filters - **Material Costs As % of Sales:** Calculated as (Material Costs) / (Estimate Sales Subtotal) * 100% > [!NOTE] > **Note:** Estimate Sales Subtotal is the sum of subtotals of all Sold estimates on the job. - **Equipment Costs:** Sum of cost of equipment items on the job invoice, including adjustment invoices, if selected in the report filters - **Equip. Costs As % of Sales:** Calculated as (Equipment Costs) / (Estimate Sales Subtotal) * 100% - **PO Costs:** Sum of cost of POs on invoices, including adjustment invoices, if selected in the report filters - **PO Costs As % of Sales:** Calculated as (PO Costs) / (Estimate Sales Subtotal) * 100% - **Materials + Equip. + PO Costs:** Sum of costs of material items, equipment items, and POs on invoices - **Materials + Equip. + POs As % of Sales:** Calculated as (Material Costs + Equipment Costs + PO Costs) / (Estimate Sales Subtotal) * 100% - **Payroll Adjustments:** Sum of active payroll adjustments tied to the job invoice - **Payroll Adjustments as % of Sales:** Calculated as (Payroll Adjustments) / (Estimate Sales Subtotal) * 100% - **Total Costs:** Sum of costs of material items, equipment items, POs, payroll adjustments, performance pay, labor pay, and labor burden - **Total Cost As % of Sales:** Calculated as (Total Costs) / (Estimate Sales Subtotal) * 100% - **Performance Pay:** Total of bonus and commission pay awarded on the job > [!NOTE] > **Note:** Including performance pay requires account configuration. Please contact your success or implementation manager for details. - **Performance Pay as % of Sales:** Calculated as (Performance Pay) / (Estimate Sales Subtotal) * 100% - **Labor Pay:** Sum of hourly labor pay including any overtime pay for all technicians on the job invoice > [!NOTE] > **Note:** Including labor pay requires account configuration. Please contact your success or implementation manager for details. - **Labor Pay as % of Sales:** Calculated as (Labor Pay) / (Estimate Sales Subtotal) * 100% - **Labor Burden:** Sum of overhead costs for technicians on the job invoice > [!NOTE] > **Note:** If your account is configured to include payroll costs, [set technician burden rates without payroll costs](/v1/docs/calculate-technician-burden-rates) to avoid double counting payroll. - **Labor Burden as % of Sales:** Calculated as (Labor Burden) / (Estimate Sales Subtotal) * 100% - **Returns:** Sum of all PO and non-PO returns added to invoices - **Returns as % of Sales:** Sum of all PO and non-PO returns divided by Project Estimate Sales ## Run a report Before running your report, set filters for date ranges and job BUs: 1. Click the **Date Type** dropdown and select how you want to filter date ranges: - **Job Start/Completed:** Filter for projects with jobs with start or completion dates within the date range - **Estimate Sold On:** Filter for projects whose first sold estimate was sold within the date range 2. Click the **From - To** field to set date filters. You can: - Use the calendar to select a specific date range and then click **Apply**. ![Calendar view showing selected date range from July 7 to July 14, 2023.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/project-job-costing-report-template-image-mf7xh6g9.png) - Use the left menu to select a preset date range: 1. Today: From 12:00 AM to the current time. 2. **Yesterday:** Previous day, from 12:00 AM to 11:59 PM. 3. **This Week:** From Monday through Sunday of the current week. 4. **Week to Date:** From Monday through the current date of the current week. 5. **Last 7 Days:** Previous seven days, including today. 6. **Last 14 Days:** Previous 14 days, including today. 7. **Last 30 Days:** Previous 30 days, including today. 8. **Month to Date:** From the first of the current month to the current day. 9. **Last Month:** Entire month before the current month. For example, if the date is February 5, the entire month of January. 10. **Last 90 Days:** Previous 90 days, including today. 11. **This Quarter:** Current quarter, including future dates. For example, if the date is April 25, from April 1 - June 30. 12. **Last Quarter:** Entire quarter before the current quarter. For example, if the date is April 25, from January 1 - March 31. 13. **Quarter to Date:** From the first day of the current quarter to the current day. 14. **Year to Date:** From January 1 of the current year to the current day. 15. **Last 365 Days:** Previous 365 days, including today. 16. **Last Year:** From January 1 of the previous year to December 31. 3. From the **Business Unit** dropdown, select the invoice item BUs you want to filter for. If the job has no invoice items, then the filter is applied to job BU. > [!NOTE] > **Note:** Only jobs whose BUs are filtered for are used in calculations. For example, if you filter for the Install BU and the project includes four Install jobs and two Sales BU jobs, the Total Jobs column only displays 4. By default, the report runs for all BUs. You can filter your report by business units or business unit categories: - Click the dropdown to select individual BUs. ![Dropdown menu showing selected business units including HVAC options and plumbing services.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/project-job-costing-report-template-image-rzcit76e.png) - To report on BU categories such as trade or division, click **Filter** ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/icon-filter-alt.png), select the BU categories you want to include, and click **Filter**.![Filter options for business units including trade and division selections.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/project-job-costing-report-template-image-ri3jv3wu.png) 4. When you're done setting filters, click **Run Report**. > [!TIP] > **Tip:** You can [arrange report columns and apply filters](/v1/docs/run-report#filter-and-arrange-a-report) for further customization. ## Want to learn more? - Visit ServiceTitan Academy and enroll in [Project Management Basics](https://servicetitan.docebosaas.com/academy/learn/courses/253/project-tracking-basics) - See [Create and edit custom reports](/v1/docs/edit-custom-reports) - See [Export a report](/v1/docs/run-report#export-a-report) - See [Schedule custom reports](/v1/docs/schedule-reports) The calculation of actual costs (labor, materials, overhead) against revenue for each job to determine true profitability. **What it does:** Shows which job types, technicians, or BUs are truly profitable after accounting for all costs, not just top-line revenue. **Also called:** Job profitability, Cost tracking **Tags:** Core [See the full glossary →](https://help.servicetitan.com/docs/glossary-overview) The top-level account in ServiceTitan representing a property owner or account holder, containing all locations, jobs, and history. **What it does:** Serves as the single source of truth for all customer interactions, history, and financial data. **Also called:** Customer account, Client record **Tags:** Core [See the full glossary →](https://help.servicetitan.com/docs/glossary-overview) A sales tech sells an estimate. -or- A service, maintenance, or install tech sells an estimate. -or- A CSR sells an estimate over the phone. Let's say the estimate total is below the sold threshold (the customer wants to schedule the work, but hasn't fully decided). [Learn more →](https://help.servicetitan.com/docs/understanding-estimates-vocab) · [See the full glossary →](https://help.servicetitan.com/docs/glossary-overview)