---
title: "Master Pay File built-in report"
slug: "master-pay-file-built-in-report"
updated: 2026-10-16T01:48:55Z
published: 2026-10-16T01:48:55Z
canonical: "help.servicetitan.com/master-pay-file-built-in-report"
---

> ## 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 built-in report

## Overview

The Master Pay File built-in report shows all paid activities including hourly pay, performance pay, and payroll adjustments. Each line in the report represents an employee's gross pay item.

Example Master Pay File reports:

- See how many hours each employee worked per month
- Schedule email delivery of total payroll for each pay period
- Compare gross pay by business unit (BU)

[Master Pay File Built-in Report Video](https://fast.wistia.net/embed/iframe/vhr4y1nm6r?web_component=true&seo=true&videoFoam=false)

---

### 

#### Who uses this feature

- Administrators and accountants

## Things to know

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

> [!NOTE]
> **Note:** The Office Timesheets feature requires account configuration. Please contact [Technical Support](https://go.servicetitan.com/#/ask) for details.
- Paid non-job events are assigned business units (BUs) based on the BU of the technician unless a BU is set on that Timesheet Code's Setting.
- Depending on your account configuration, the Master Pay File may hide $0 items. This affects office-side reports only, technicians will still see every item in [View Payroll](/v1/docs/sign-off-on-payroll-in-servicetitan-mobile#review-and-sign-off-on-payroll) on mobile. If you're unsure about your setup, contact your Customer Success Manager (CSM).

## Run the report

A built-in Master Pay File report is available on the *Reports* home screen. You can also [create a custom report](/roofing/docs/create-custom-reports) based on the Master Pay File report template.

To run the built-in report:

1. Go to the navigation bar and click **Reports**.
2. Click the **Master Pay File** report.

> [!TIP]
> **Tip:** In the search field, enter a few letters from the report title for quick access.

![User searches for the Master Pay File report in ServiceTitan dashboard interface.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-built-in-report-image-ce6b5p4h.png?sv=2026-02-06&spr=https&st=2026-11-01T19%3A50%3A14Z&se=2026-11-01T20%3A50%3A14Z&sr=c&sp=r&sig=BKWy732XcGTpd6psOT7KtKpeqiRWghIvhBc3Gvz94tE%3D)
3. Click the **From - To** field to select a date range to report on. You can:
4. Use the calendar to select a specific date range and then click **Apply**. ![Date range selection from July 7 to July 14, 2023, with calendar view.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-built-in-report-image-zzxbzlko.png?sv=2026-02-06&spr=https&st=2026-11-01T19%3A50%3A14Z&se=2026-11-01T20%3A50%3A14Z&sr=c&sp=r&sig=BKWy732XcGTpd6psOT7KtKpeqiRWghIvhBc3Gvz94tE%3D)
  1. 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.
5. 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-built-in-report-image-2qv6kn92.png?sv=2026-02-06&spr=https&st=2026-11-01T19%3A50%3A14Z&se=2026-11-01T20%3A50%3A14Z&sr=c&sp=r&sig=BKWy732XcGTpd6psOT7KtKpeqiRWghIvhBc3Gvz94tE%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-11-01T19%3A50%3A14Z&se=2026-11-01T20%3A50%3A14Z&sr=c&sp=r&sig=BKWy732XcGTpd6psOT7KtKpeqiRWghIvhBc3Gvz94tE%3D) , select the BU categories you want to include, and click **Filter**. ![Filter options for Technician Business Unit including Trade and Division selections.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-built-in-report-image-znt65iqg.png?sv=2026-02-06&spr=https&st=2026-11-01T19%3A50%3A14Z&se=2026-11-01T20%3A50%3A14Z&sr=c&sp=r&sig=BKWy732XcGTpd6psOT7KtKpeqiRWghIvhBc3Gvz94tE%3D)
6. Use the **Technicians** dropdown to filter by individual technicians. ![Dropdown menu showing selected technicians with Frank highlighted among others.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-built-in-report-image-91q83hmg.png?sv=2026-02-06&spr=https&st=2026-11-01T19%3A50%3A14Z&se=2026-11-01T20%3A50%3A14Z&sr=c&sp=r&sig=BKWy732XcGTpd6psOT7KtKpeqiRWghIvhBc3Gvz94tE%3D)

> [!NOTE]
> **Note:** If you add BU filters, make sure the technicians you select are assigned to those BUs.
7. From the **Employee Business Unit** dropdown, select the office employee BUs you want to report on.
8. Use the **Employees** dropdown to filter by individual office employees.

> [!NOTE]
> **Note:** If you add BU filters, make sure the office employees you select are assigned to those BUs.
9. 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-built-in-report-image-fih7aj7a.png?sv=2026-02-06&spr=https&st=2026-11-01T19%3A50%3A14Z&se=2026-11-01T20%3A50%3A14Z&sr=c&sp=r&sig=BKWy732XcGTpd6psOT7KtKpeqiRWghIvhBc3Gvz94tE%3D)
10. When you're done setting filters, click **Run Report**.

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

## Read report results

Each line of the Master Pay File report represents a gross pay item based on the filters you set. The report includes the following columns:

- **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](/roofing/docs/set-up-and-use-zones) of the job
- **Tax Zone**: If the activity is tied to a job, the [tax zone](/roofing/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

## 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-built-in-report-image-m0qsivpx.png?sv=2026-02-06&spr=https&st=2026-11-01T19%3A50%3A14Z&se=2026-11-01T20%3A50%3A14Z&sr=c&sp=r&sig=BKWy732XcGTpd6psOT7KtKpeqiRWghIvhBc3Gvz94tE%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. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/master-pay-file-built-in-report-image-387llly1.gif?sv=2026-02-06&spr=https&st=2026-11-01T19%3A50%3A14Z&se=2026-11-01T20%3A50%3A14Z&sr=c&sp=r&sig=BKWy732XcGTpd6psOT7KtKpeqiRWghIvhBc3Gvz94tE%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-built-in-report-image-aj3fnd87.png?sv=2026-02-06&spr=https&st=2026-11-01T19%3A50%3A14Z&se=2026-11-01T20%3A50%3A14Z&sr=c&sp=r&sig=BKWy732XcGTpd6psOT7KtKpeqiRWghIvhBc3Gvz94tE%3D)The report automatically groups pay items for each employee by date.

## Want to learn more?

- See [Export a report](/roofing/docs/run-filter-and-export-reports#export-a-report)
- See [Invoices report template](/roofing/docs/invoices-report-template-1)