---
title: "Master Pay File By Pay Period report template"
slug: "master-pay-file-by-pay-period-report-template"
updated: 2026-10-15T01:05:03Z
published: 2026-10-15T01:05:03Z
canonical: "help.servicetitan.com/master-pay-file-by-pay-period-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.

# Master Pay File By Pay Period report template

## Overview

Use the Master Pay File by Pay Period report template to create reports on all paid and unpaid activities, including hourly pay, performance pay, and payroll adjustments, filtered by payroll frequency and payroll period. Each line in the report represents an employee's gross pay item.

> [!NOTE]
> **Note:** This report functions similarly to the [Master Pay File report](/construction/docs/master-pay-file-report-template) but includes unpaid timesheet activities such as meal breaks and idle time.

Example report findings:

- How many total hours did an employee spend on a specific activity over a given payroll period
- How much time did all my employees spend driving over a given payroll period
- How many hours were spent working on a specific job during a given payroll period

---

### 

#### Who uses this feature

- Administrators and accountants
- Applies to all 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](/construction/docs/built-in-reports-home).

## Things to know

- Bonus and commission items appear in reports only if the job invoice is in *Posted* or *Exported* status.
- Master Pay File By Pay Period reports include paid and unpaid activities for all employees including technicians and office employees.

> [!NOTE]
> **Note:** The Office Timesheets feature requires account configuration. Please contact [Technical Support](http://go.servicetitan.com/ask) for details.
- Paid non-job events are assigned business units (BUs) based on the BU of the technician.
- If you're unsure which columns you want to include in your report, use the [Reporting Dictionary](/construction/docs/learn-about-report-data-fields-in-the-reporting-dictionary-2) 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 Master Pay File By Pay Period report

Follow the steps to [create a custom report](/construction/docs/create-custom-reports#create-a-report) based on the Master Pay File By Pay Period template and select the columns to include in your report.

The template has the following columns selected by default:

- **Employee Name**: Name of the technician or office employee
- **Activity**: Type of paid activity
- **Date**: Date of the paid activity
- **Paid Duration**: Duration of the activity
- **Reg Hours**: Number of regular paid hours
- **OT Hours**: Number of overtime hours
- **DT Hours**: Number of double overtime hours
- **Gross Pay**: Dollar amount of the paid activity
- **Customer Name**: If the activity is tied to a job, the name of the customer
- **Project Number**: If the activity is tied to a job that is part of a project, the project number
- **Zone**: If the activity is tied to a job, the [zone](/construction/docs/set-up-and-use-zones-1) of the job
- **Tax Zone**: If the activity is tied to a job, the [tax zone](/construction/docs/set-up-sales-tax-in-servicetitan) of the job
- **Location Zip**: If the activity is tied to a job, the ZIP code of the service location
- **Location Name**: If the activity is tied to a job, the name of the contact at the service location
- **Location Address**: If the activity is tied to a job, the service location address
- **Labor Type:** The labor type associated to the employee or technician

You can customize the report by selecting and deselecting columns.

> [!TIP]
> **Tip:** Hover over the name of the column to see a short description.

## Run the report

Before you run your report, set filters to focus your results:

1. From the **Payroll Frequency** dropdown, select the payroll frequency you want to report on. ![Dropdown menu showing payroll frequency options with selection highlighted.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-ijcrza5q.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)

> [!NOTE]
> **Note:** Payroll frequencies require account configuration. Please contact [Technical Support](http://go.servicetitan.com/ask) for more information.
2. From the **Payroll Period** dropdown, select the specific payroll period you want to report on. You can select more than one. ![User selects payroll periods from a dropdown menu for processing.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-upgqvnds.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)
3. (Optional) From the **Technicians** dropdown, select the technicians you want to report on. You can select more than one. ![Dropdown menu showing selected technicians with checkboxes for selection.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-l95se178.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)

> [!NOTE]
> **Note:** If you add BU filters, make sure the technicians you select are assigned to those BUs.
4. (Optional) From the **Technician Business Unit** dropdown, select the technician BUs you want to report on. By default, the report runs for all BUs. You can filter your report by business units or business unit categories:
  1. Click the dropdown to select individual BUs. ![Dropdown menu showing options for selecting a Technician Business Unit in HVAC.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-vdlnm4qs.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)
  2. To report on BU categories, click **Filter** ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/icon-filter-alt.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D) , select the BU categories you want to include, and click **Filter**. ![Filter options for selecting business unit, trade, and division in a dropdown menu.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-lvt0ioc4.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)
5. (Optional) From the **Employee Business Unit** dropdown, select the office employee BUs you want to report on. You can also report on BU categories by clicking **Filter**, selecting the BU categories you want to include, and clicking **Filter**. ![User selects 'Plumbing - Sales' from the Employee Business Unit dropdown menu.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-pf8myxz1.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)
6. (Optional) Use the **Filter for only** dropdown if you want to report on only technicians or only office employees. ![Dropdown menu showing filter options for Employees and Technicians selection.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-pqspwkwp.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)
7. When you're done setting filters, click **Run Report**.

> [!TIP]
> **Tip:** Click **Edit Columns** to add and remove columns. For further customization, you can [arrange and filter your results](/construction/docs/edit-custom-reports#arrange-and-filter-a-report).

## Read report results

Each line of the Master Pay File By Pay Period report represents a gross pay item based on the filters you set.

#### Understand paid activities

The *Activity* column of the Master Pay File report details the type of pay the employee is receiving:

- **Labor pay activities**: Activities paid by the hour, including driving, working, paid idle time, and paid non-job events

> [!NOTE]
> **Note:** Non-job events are identified by their timesheet code.
- **Performance pay activities**: Bonus pay and commissions, including invoice specific bonuses
- **Payroll adjustments**: Direct adjustments or commission base adjustments

![Table displaying activities, dates, and paid durations for work and bonuses.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-fs3hucd0.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)

#### Group pay items by employee

To more easily review payroll, you can group pay items by employee and date:

1. Click and drag the **Employee Name** column header to the bar above the report results. The report automatically groups pay items by employee. ![group columns](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-d1ebmix0.gif?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)
2. Click and drag the **Date** column header to the same bar. ![Table displaying employee activity, grouped by name with date and activity details.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-r7oz1l7n.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)The report automatically groups pay items for each employee by date.

#### Update payroll data

If you have Persistent Payroll enabled, you can manually refresh Master Pay File by Pay Period reports for the most up-to-date data by clicking **Refresh Payroll Data**.

> [!NOTE]
> **Note:** Persistent Payroll requires account configuration. Please contact [Technical Support](https://go.servicetitan.com/#/ask) for details.

![Payroll management interface showing options for frequency, period, and technicians selection.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-h8mgw2jn.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)

#### Export Master Pay File reports

You can export Master Pay File by Pay Period reports that you can use with a third party payroll processor. After you run a report, click **Export**.

![Export button for weekly payroll frequency in the Master Pay File interface.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-j188oe7o.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)

The *Export Report* window opens, where you can select the export format (XLSX or PDF) and exporting options (Export only aggregated data). When you're done, click **Export**.

![Export report options with XLSX and PDF formats highlighted for selection.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-by-pay-period-report-template-image-rq1obgqe.png?sv=2026-02-06&spr=https&st=2026-10-31T01%3A48%3A58Z&se=2026-10-31T02%3A48%3A58Z&sr=c&sp=r&sig=nxfHNmT7pc0cFNc%2FJn7mUC456O8uNNMZ8g8ULhIavqM%3D)

The report downloads in your selected format to your computer.

## Want to learn more?

- See [Run, filter, and export reports](/construction/docs/run-filter-and-export-reports)
- See [Invoices report template](/construction/docs/invoices-report-template-1)