Service Titan Knowledge Base

Payroll Pro: Worker’s Comp Data File Report templateLast updated on 12/01/2022

Use the Worker’s Comp Data File report template to create reports that help your worker’s compensation insurance carrier calculate their premiums. This helps you show your worker’s compensation insurance company how much in wages you have paid your employees in a given time period.


Things to know

  • Each row on the report represents one check for each employee during the time period specified.


Create a Worker’s Comp report

Follow the steps to create a custom report based on the Payroll Pro: Worker’s Comp Data File template and select the columns to include in your report.

The template has the following columns selected by default:

  • Company ID—Your company ID

  • Company Name—Name of your company

  • State—State in which the wages were earned

  • Check Date—Date the payroll was paid

  • Employee ID—The employee’s ID

  • Employee Name—Name of the technician or office employee

  • All Hours—Total paid hours, including any paid time off

  • OT Hours—Total overtime and double overtime hours

  • Total Wages—All wages paid to the employee in the selected period. This includes regular, overtime, payroll adjustments and bonuses, and commissions

  • OT Wages—All overtime wages paid to the employee. (Excludes double overtime, if applicable)

  • Double Overtime Wages—All double overtime wages paid to the employee

  • Tip Wages—All tip wages paid to the employee


Run a report

  1. Click the From - To field to set date filters. You can

    • Use the calendar to select a specific date range and click Apply.

    • Use the left menu to select a preset date range:

      • Today—From 12:00 AM to the current time

      • Yesterday—Previous day, from 12:00 AM to 11:59 PM

      • Last 7 Days—Previous seven days, including the current date

      • Last 14 Days—Previous 14 days, including the current date

      • Last 30 Days—Previous 30 days, including the current date

      • Month to Date—From the first of the current month to the current day

      • Last Month—Entire month before the current month. For example, if the date is February 5, the entire month of January.

      • Last 90 Days—Previous 90 days, including the current date

      • This Quarter—Current quarter, including future dates. For example, if the date is April 25, from April 1 - June 30.

      • Last Quarter—Entire quarter before the current quarter. For example, if the date is April 25, from January 1 - March 31.

      • Quarter to Date—From the first day of the current quarter to the current day

      • Year to Date—From January 1 of the current year to the current day

      • Last 365 Days—Previous 365 days, including the current date

  2. When you’re done selecting the time period for the report, click Run Report




Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.