Project Financial Details report template

Overview

The Project Financial Details report gives you a budget-code-level view of costing metrics across your commercial construction projects. Use it to track actual costs against budgeted amounts, identify overbilling and underbilling, and forecast project profitability. Reviewing this report weekly helps you catch cost overruns while there's still time to act.

Who uses this feature

Administrators, accountants, bookkeepers, and managers
Primarily benefits Commercial Construction business types
Applies to all trades

Feature configuration

This feature is currently in Private Preview and available for specific accounts. It is subject to change. To update your account, contact Technical Support for details.
To use this report, you must have Budget Codes and GL Based Job Costing enabled.
Account configuration is required to use this feature. Please contact Technical Support for details.
The ability to create custom reports depends on the ServiceTitan package your company is subscribed to. If you don't have the option to create a custom report, it may not be included in your package. Contact Technical Support for details.

Things to know

If you're unsure which columns you want to include in your report, use the 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.
Budget codes must be configured in Settings > Operations > Work Breakdown Structure before data appears in this report. For more, see Budget Codes overview.

Use cases and best practices

Role	Use case	Best practice	Data fields involved
Project manager	Identify which budget codes are trending over budget before the project closes.	Catch cost overruns while there's still time to act: Filter by Project and sort by Variance to quickly identify cost codes where actuals are approaching or exceeding the budget. Follow up with field leads on flagged codes to understand the cause before overruns widen. Escalate or adjust scope if variance trends are consistent across multiple codes.	Budgeted Cost Actual Cost Variance Cost Code Cost Type
Project manager	Forecast project profitability at the budget-code level on a weekly basis.	Run a weekly profitability check to avoid surprises at closeout: Filter for active projects and run the report on the same day each week to maintain a consistent baseline. Review Percent Complete alongside Earned Value to assess whether billing is keeping pace with work performed. Adjust future billing schedules or initiate scope discussions if earned value lags behind actual cost.	Percent Complete Earned Value Actual Cost Budgeted Revenue
Project accountant or bookkeeper	Reconcile billed amounts against work completed to identify underbilling or overbilling risks.	Review billing alignment by cost category to protect cash flow and reduce liability: Filter by Cost Type—for example, Labor, Material, or Subcontractor—to compare billing against actual spend by category. Flag project phases where billed amounts significantly diverge from cost progress. Prioritize follow-up on phases with the largest gaps to reduce billing risk before period close.	Billed Amount Actual Cost Cost Type Project Status
Project manager	Monitor labor cost performance across project phases to control field spending.	Track labor spend by phase before small overruns compound across the job: Filter by Cost Type = Labor and group by Cost Code or Project Status. Compare actual labor hours and costs to budgeted labor to identify phases with higher-than-expected crew costs. Connect with foremen or supers on phases where labor is trending over to align on corrective actions.	Actual Labor Hours Budgeted Labor Cost Actual Labor Cost Cost Code Project Status

Create a Project Financial Details report

Follow the steps to create a custom report based on the Project Financial Detail template and select the columns to include in your report. You only need to create the report once. After it's created, you can share it with others who may need to access the information in the report, edit report columns, and more.

Report data fields

This template has the following data field sections:

Project Details: Identifies the project and its organizational context. Examples: Project Name, Project ID, Business Unit, Project Manager.
Budget Code Breakdown: Classifies costs by the work breakdown structure defined for the project. Examples: Cost Code, Cost Type.
Budget vs. Actuals: Compares planned financial targets against real spend and billing. Examples: Budgeted Cost, Actual Cost, Total Contract Value, Actual Billed.
Labor Metrics: Tracks field labor costs and hours at the budget-code level. Examples: Actual Labor Hours, Budgeted Labor Cost, Actual Labor Cost.
Progress and Forecasting: Measures completion and projects financial outcomes. Examples: Percent Complete, Earned Value, Cost to Complete.
Material and Subcontractor Costs: Breaks out non-labor spending by category. Examples: Actual Material Cost, Budgeted Material Cost, Actual Subcontractor Cost.

For detailed descriptions of the data fields, see the Reporting Dictionary.

Report filters

Set the following filters before running the report to make sure results are relevant to the project or time period you want to review:

Project: Select one or more active or completed projects to scope the report.
Date Range: Define the period for which cost and billing data is displayed.
Cost Code: (Optional) Filter to a specific cost code or group of codes.
Cost Type: (Optional) Filter by expense type, such as Labor, Material, Equipment, Subcontractor, or Overhead.
Project Status: (Optional) Filter to a specific project phase.

When you're finished setting filters, click Run Report.

Form fields for project details including dates, manager, status, and cost types.

Tip: Click Edit Columns to add and remove columns from the report. For further customization, you can also arrange report columns and apply filters to columns.

Note: Hover over the name of a column to see a short description.

Documentation Index