Service Titan Knowledge Base

Create bulk payroll adjustmentsLast updated on 03/22/2022

You can make bulk payroll adjustments to make wage corrections or to account for paid activities outside of ServiceTitan when calculating job costing. The Payroll Adjustment Template allows you to make adjustments for multiple employees and pay periods at once, saving you time.


Things to know

  • You can make payroll adjustments for technicians and office employees. Office Timesheets requires account configuration. Contact your success or implementation manager for details.

  • To make adjustments for hourly technicians, you can edit technician timesheets.


Download the Payroll Adjustment Template

  1. Go to the navigation bar and click Settings settings.png. In the side panel, go to Tools > Import / Export Data. Import or Export Data opens.

  2. From the Import tab, click the Data File Type dropdown and select Payroll Adjustment Template.

  3. Click Export Template.

  4. If you use earnings codes, the Payroll Adjustment Template includes a column to enter earnings code names. Use the PayrollActivityCodeNameReference tab for a list of earnings codes.

    Note: This feature requires account configuration. Please contact your success or implementation manager for details.

The template downloads as an XLSX file to your computer.


Add payroll adjustments

  1. Open the Payroll Adjustment Template in a spreadsheet application like Microsoft Excel or Google Sheets. Note: The spreadsheet includes two tabs: PayrollAdjustment and idNameReference. Enter all adjustments in the PayrollAdjustment tab. Use the idNameReference tab to find employee names and ID numbers.

  2. Enter the payroll adjustment details into the spreadsheet columns:

    • EmployeeId—Employee identification number Tip: Click the idNameReference tab in the spreadsheet for a list of employee IDs.

    • EmployeeName—Name of the technician or office employee receiving the adjustment

    • InvoiceNumber—If the adjustment is tied to an invoice, enter the invoice number

    • Type—Enter one of the following:

      • Direct—Adjustment is directly earned by the employee Note: This is the most common type of payroll adjustment. If you use Configurable Payroll, you can only add direct payroll adjustments.

      • Commission Base—Adjustment is based on the technician’s commission rate. For example, if the adjustment amount is $200 and the technician has a 10% commission rate in his payroll settings, the technician receives $20. Note: The commissionable base is reduced by the adjustment amount for other technicians on the invoice.

      • Labor—For contractors and laborers. Counts as a cost on the invoice, reducing the commissionable base.

      • Advance—When technician is paid before the job is added to payroll. Amount is deducted from the technician’s gross pay when the job is included in payroll reports.

      • Sold Advance—When technician receives Sold by credit and is paid before the job is added to payroll. The sold by percentage is applied to the adjustment amount. The total is deducted from the technician’s gross pay when the job is included in payroll reports.

    • PostedOn—Date you want the payroll adjustment to show as posted

    • Rate—Base amount of the payroll adjustment Tip: To make a payroll deduction, enter a negative value.

    • Quantity—Amount to multiply the Rate by Note: For typical payroll workflows, enter 1.

    • Memo—Details or notes about the adjustment

  3. Save the spreadsheet to your computer as an XLSX file.


Import payroll adjustments to ServiceTitan

After you download the XLSX file of your payroll adjustments, import it into ServiceTitan:

  1. Go to the navigation bar and click Settings settings.png. In the side panel, go to Tools > Import / Export Data. Import or Export Data opens.

  2. From the Import tab, click the Data File Type dropdown and select Payroll Adjustment Template.

  3. Click Upload.

  4. Upload the XLSX file from your computer.

  5. Click Import.

A notification appears indicating that the import was successful.


Want to learn more?



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