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
Go to the navigation bar and click Settings
. In the side panel, go to Tools > Import / Export Data. Import or Export Data opens.
From the Import tab, click the Data File Type dropdown and select Payroll Adjustment Template.
Click Export Template.
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
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.
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
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:
Go to the navigation bar and click Settings
. In the side panel, go to Tools > Import / Export Data. Import or Export Data opens.
From the Import tab, click the Data File Type dropdown and select Payroll Adjustment Template.
Click Upload.
Upload the XLSX file from your computer.
Click Import.
A notification appears indicating that the import was successful.
Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.
Disclaimer: Information provided in this article is for informational purposes only and it should not be construed to be legal advice. Information provided in this article may also not constitute the most up-to-date legal or other information. You should not act or refrain from acting on the basis of any information in this article to meet any compliance requirements without seeking independent legal or other professional advice.