Service Titan Knowledge Base

Payroll (Detail) Report Guide- Primary Payroll SettingsLast updated on 03/22/2022


Purpose of the Payroll (Detail) Report - Primary Payroll Settings:

This report provides a detailed breakdown of a technician’s pay. Data is based on job invoice dates. Invoices must be batched and posted to appear in payroll reports.


Common uses for this report:

  • Use this report to view gross pay, net commission, splits on a job, bonuses, payroll adjustments, the total commissionable amount on invoices, and other payroll information.

  • Use this report for an in-depth explanation of all areas of the Payroll (Detail) Report.


How to find this report:

Click Reports > Search Payroll (Detail) > Click the report name. Then you will be able to set filters and run the report.


Report filters

Technician

Filter by technician. This report can be run by a single technician or all technicians.

Business Unit

Filter by business unit. This report can be run by a single business unit or all business units.

Date Range

Filter by date range. Use the From and To fields to set a custom date range.


View or download the report

Click Run to view the report.

The report can be downloaded in three different formats:

  • Export to Excel (*.xlsx) (click the dropdown arrow next to Download PDF)

  • Export to Comma separated (*.csv) (click the dropdown arrow next to Download PDF)


Explanation of report columns for Invoices

The report includes the following columns:

(Report columns)

Invoice: Number

Invoice number.

Invoice: Invoiced On

By default, the Payroll Date is set to match the Invoice Date. The Payroll (Detail) Report will include invoices dated within the report date range.

Invoices must be batched and posted to appear in payroll reports.

How to configure - Payroll date: To set an Invoice Date, navigate to Search > Invoice > Update invoice details > Invoice Date. If you would like your invoices to have a separate Payroll Date field in addition to the Invoice Date field, contact your implementation manager / Onboarder or Success Manager to configure your account. If your account is configured for the Payroll Date field, payroll reports will run by Payroll Date rather than Invoice Date.

Invoice: Customer

The name of the billing customer for the invoice.

Invoice: Total

The invoice total, including the invoice subtotal and applicable taxes.

Technician splits are not calculated in invoice total amounts.

Invoice: Split %

Technician split. This is the percentage of the job assigned to the technician.

Invoice: Subtotal

Invoice subtotal.

Calculation - Invoice: Subtotal: [Total of commissionable and non-commissionable items] x [Split %]

  • Technician splits are applied.

Invoice: Cost

Job costs associated with the invoice, including material costs (when material costs are configured as deductible), equipment costs (when the equipment item is configured to pay commission), and purchase orders. By using a cost markup, you may charge the technician an extra amount on top of actual job costs.

Purchase orders designated as No Charge are not included in job costs.

Calculation - Invoice: Cost: [ -1] x ([[Deductible Material costs] + [Equipment costs] + [Total amount for Purchase Orders on the invoice]] x [Split %]) + [Cost markup percentage]

  • Job costs display as a debit (negative amount). Technician splits are applied.

Invoice: Bonus

Invoice SKU bonuses. If any tasks or services (SKU invoice items) have a bonus configured, the sum of SKU bonus amounts will be shown here.

SKU bonuses may be configured as a flat amount, or as a percentage of the service price.

Calculation - Invoice: Bonus: ([Sum of flat SKU bonuses for all items on the invoice] x [Split %]) + ([Sum of percentage SKU bonuses for all items on the invoice] x [Split %])

  • The Bonus field does not include range bonuses (for information on how range bonuses are applied, see Range Bonuses above).

  • Technician splits are applied to flat and percentage SKU bonuses.

Invoice: Pay Adj.

Labor costs that count against the technician's commission. These labor costs come from commissionable payroll adjustments entered on the invoice, payable to other technicians. These labor costs are deducted from the invoice subtotal when calculating Net Service Volume (see Net Service Volume).

Invoice: NC Total

Non-commissionable total. Everything in this column gets deducted from invoice subtotal amounts when calculating Net Service Volume. This column displays two types of data, depending on whether or not there are commissionable or non-commissionable items on the invoice. If there are commissionable items on the invoice, this column displays any applicable business unit fees. If there are non-commissionable items on the invoice, this column displays the the full item price (since the item itself is non-commissionable).

Calculation - Invoice: NC Total:([-1] x [Business unit fees for commissionable invoice items]) + ([-1] x [Subtotal of non-commissionable invoice items])

  • Amounts in this column are displayed as a debit (negative amount).

Invoice: Net Service Volume (Unlabeled Column)

This unlabeled column displays two types of data, depending on the type of commission earned by the technician. If the technician earned a service commission for the invoice, this column will display Net Service Volume for the invoice (this is usually the case). However, If the technician earned a sales commission (sold by rate) for the invoice, this column will display the invoice subtotal.

When a technician is given sold by credit, the Split % displays as SB.

Calculation - Net Service Volume: ([Subtotal of commissionable invoice items] x [Split %]) - ([Business unit fees for all invoice items] x [Split %]) - [Sum of commissionable payroll adjustments entered for other technicians]

  • Business unit fees apply both to commissionable and non-commissionable invoice items.

  • Technician splits are applied.

Invoice: GP

Gross Pay for the invoice. Sum of service commission, designated range bonus, SKU bonuses, and sales commission (sold by rate).

Calculation - Gross pay for individual invoices: [Service commission] + [Range bonus] + [Invoice SKU bonuses] + [Sales commission]

  • Technician splits are applied to service commission, range bonus, and invoice SKU bonuses. Technician splits are not applied to sales commission (sold by rate).

Calculation - Service commission for individual invoices: ([Invoices: Net Service Volume] - [Invoices: Cost]) x [Technician commission rate]

  • Technician splits are applied.

Calculation - Invoice SKU Bonuses: See Invoices: Bonus.

  • Technician splits are applied.

Calculation - Range Bonus: ([Invoices: Net Service Volume] - [Invoices: Cost]) x [Range bonus rate].

  • Technician splits are applied.

Calculation - Sales commission for invoices where the technician earned sold by credit (sold by rate is applied): [Subtotal of invoices designated as SB in the Invoices: Split % column] x [Technician sold by rate]


Explanation of Totals for All Invoices

(Report Tools)

All Invoices: Inv. Total

Sum of totals for all invoices, including invoice subtotals and applicable taxes.

Calculation - All Invoices: Inv. Total: [Sum of Invoices: Total]

  • Technician splits are not applied to invoice total amounts

All Invoices: Subtotal

Sum of subtotals for all invoices.

Calculation - All Invoices: Subtotal: [Sum of Invoices: Subtotal]

  • Technician splits are applied.

All Invoices: Cost

Sum of job costs for all invoices, including material costs (when material costs are configured as deductible), equipment costs (when the equipment item is configured to pay commission), and purchase orders. By using a cost markup, you may charge the technician an extra amount on top of actual job costs.

Purchase orders designated as No Charge are not included in job costs.

Calculation - All Invoices: Cost: [Sum of Invoices: Cost]. If there are splits, the split is accounted for in job costs and the cost markup.

  • Job costs display as a debit (negative amount).

  • Technician splits are applied.

All Invoices: Bonuses

Sum of SKU bonuses for all invoices. If any tasks or services (SKU invoice items) have a bonus configured, total SKU bonus amounts for all invoice items will be shown here.

SKU bonuses may be configured as a flat amount, or as a percentage of the service price.

Calculation - All Invoices: Bonuses: [Sum of flat SKU bonuses for all invoices] + [Sum of percentage SKU bonuses all invoices]

  • The Bonus field does not include range bonuses (for information on how range bonuses are applied, see Range Bonuses above).

All Invoices: Comm. Pay. Adj.

Total amount of labor costs that count against the technician's commission. These labor costs come from commissionable payroll adjustments entered on invoices, payable to other technicians. These labor costs are deducted from invoice subtotals when calculating Net Service Volume (see Net Service Volume).

All Invoices: Non-Comm. Total

Non-commissionable total for all invoices. For commissionable invoice items, any applicable business unit fees are included. For non-commissionable invoice items, the full item price is included.

Non-commissionable totals are displayed as a debit (negative amount).

Calculation - All Invoices: Non-Comm. Total: ([-1] x [Subtotal amounts for non-commissionable invoice items]) + ([-1] x [Sum of business unit fees for commissionable invoice items])

All Invoices: Net Service Volume

Sum of Net Service Volume for all invoices. Net Service Volume is the sum of all commissionable invoice items, minus business unit fees and labor costs that count against the technician’s commission (commissionable payroll adjustments paid to other technicians).

Calculation - All Invoices: Net Service Volume: [Sum of Net Service Volume for all invoices]

  • If the technician earned sales commission (the Split % is designated as SB), the invoice is not included in Net Service Volume.

  • Business unit fees apply both to commissionable and non-commissionable invoice items.

  • Technician splits are applied.

All Invoices: GP

Gross Pay based on invoices only. Sum of service commission, designated range bonus, SKU bonuses, and sales commission (sold by rate) for all invoices.

Calculation: All Invoices: GP: [Sum of Invoices: GP]. For more information on how gross pay is calculated for individual invoices, see Invoices: GP.


Explanation of Direct Payroll Adjustments

This section displays all direct payroll adjustments, whether the adjustment was created on an invoice or added directly to the Payroll (Detail) Report.

How to add a direct payroll adjustment to an invoice?

Navigate to Search > Invoice > Add a payroll adjustment. When you enter the adjustment, select Direct from the Type dropdown.

How to add a direct payroll adjustment directly to the Payroll (Detail) Report?

Click Add Payroll Adjustment. The resulting adjustment will not be tied to any invoice.

How remove a direct payroll adjustment?

Click x next to the payroll adjustment you wish to remove / delete. If prompted with Are you sure you want to remove payroll adjustments?, click OK. You may use this feature to remove a direct payroll adjustment attached to an invoice, or a direct payroll adjustment added directly to the Payroll (Detail) Report.

Direct Payroll Adjustments: Invoice

The invoice where the direct payroll adjustment was created. If this field is blank, the direct payroll adjustment was created directly from the Payroll (Detail) Report.

Direct Payroll Adjustments: Posted On

Date the direct payroll adjustment was posted to the invoice, or to the Payroll (Detail) Report.

This date is inputted manually and is unrelated to the posting date of an invoice.

Direct Payroll Adjustments: Memo

The memo/note entered for the direct payroll adjustment.

Direct Payroll Adjustments: Amount

Gross amount of the direct payroll adjustment. You may enter either a negative amount (to make a deduction from the technician’s payroll) or a positive amount (to add an amount to the technician’s payroll). A direct payroll adjustment is equal to the gross amount of the payroll adjustment (the payroll adjustment rate multiplied by the payroll adjustment quantity).

Calculation - Direct Payroll Adjustments: Amount: [Payroll adjustment rate] x [Payroll adjustment quantity]

  • The technician’s commission percentage is not applied to direct payroll adjustments. Range bonuses are not applied to direct payroll adjustments.

Direct Payroll Adjustments: Add Payroll Adjustment

This button allows you to add a direct payroll adjustment directly to the Payroll (Detail) Report.

The resulting adjustment will not be tied to an invoice.

Direct Payroll Adjustments: Remove / Delete

You may remove any payroll adjustment by clicking x.

Direct Payroll Adjustments: Total Adjustments

Sum of all direct payroll adjustments.

Calculation - Direct Payroll Adjustments: Total Adjustments: [Sum of Direct Payroll Adjustments: Amount]


Explanation of Commissionable Payroll Adjustments

This section displays all commissionable payroll adjustments. Commissionable payroll adjustments are created on invoices only.

How to add a commissionable payroll adjustment to an invoice?

Navigate to Search > Invoice > Add a payroll adjustment. When you enter the adjustment, select CommissionBased from the Type dropdown.

How remove a commissionable payroll adjustment?

Click x next to the payroll adjustment you wish to remove / delete. If prompted with Are you sure you want to remove payroll adjustments?, click OK.

Commissionable Payroll Adjustments: Invoice

The invoice where the commissionable payroll adjustment was made.

Commissionable Payroll Adjustments: Posted On

Date the commissionable payroll adjustment was posted to the invoice.

This date is inputted manually and is unrelated to the posting date of an invoice.

Commissionable Payroll Adjustments: Memo

The memo/note entered for the commissionable payroll adjustment.

Commissionable Payroll Adjustments: Amount

Gross amount of the commissionable payroll adjustment. You may enter either a negative amount (to make a deduction from the technician’s payroll) or a positive amount (to add an amount to the technician’s payroll).

This is not the amount applied to the technician’s payroll. With commissionable payroll adjustments, only the net amount is applied to the technician’s payroll (see below for Commissionable Payroll Adjustments: Net $).

Calculation - Commissionable Payroll Adjustments: Amount:[Payroll Adjustment Rate] x [Payroll Adjustment Quantity]

  • This is not the amount applied to the technician’s payroll (see below for Commissionable Payroll Adjustments: Net $).

Commissionable Payroll Adjustments: Net $

Net amount of the commissionable payroll adjustment. The net amount of a commissionable payroll adjustment is calculated by multiplying the technician’s commission rate by the gross amount of the payroll adjustment.

Calculation - Commissionable Payroll Adjustments: Net $:([Technician commission rate] x [Payroll Adjustment Rate] x [Payroll Adjustment Quantity]) + ([Range bonus rate] x [Payroll Adjustment Rate] x [Payroll Adjustment Quantity])

  • If the technician earned a range bonus for the pay period, the range bonus percentage is applied to commissionable payroll adjustments (see Range Bonuses above).

Commissionable Payroll Adjustments: Remove / Delete

You may remove any payroll adjustment by clicking x.


Explanation of Non-Job Purchase Orders

This section displays all non-job purchase orders, which will be accounted for in total job costs (Totals: Total Costs).

How to add a non-job purchase order directly to the Payroll (Detail) Report?

Click Add Purchase Order. Note: The resulting purchase order will not be tied to any invoice.

How to remove a non-job purchase order?

Click x next to the payroll adjustment you wish to remove / delete. If prompted with Are you sure you want to remove purchase order?, click OK.

(Non-job Purchase Orders)

Non-Job Purchase Orders: Date

Date entered for the non-job purchase order.

Non-Job Purchase Orders: Amount

Amount entered for the non-job purchase order.

Non-Job Purchase Orders: Vendor

Vendor entered for the non-job purchase order.

How to configure - Vendors:To add or edit a vendor, navigate to Settings > Vendors.

Non-Job Purchase Orders: Summary

The summary (memo or note) entered for the non-job purchase order.

Non-Job Purchase Orders: Edit

You may edit any non-job purchase order by clicking the blue Edit pencil.

Non-Job Purchase Orders: Remove / Delete

You may remove any non-job purchase order by clicking x.

Non-Job Purchase Orders: Add Purchase Order

This button allows you to add a purchase order directly to the Payroll (Detail) Report.

  • The purchase order will not be tied to an invoice.

  • To designate a purchase order as No Charge, click the No Charge checkbox.


Explanation of Payroll Totals for the Technician

Totals: Net Service Volume

Sum of Net Service Volume for all invoices. Net Service Volume is the sum of all commissionable invoice items, minus business unit fees and labor costs that count against the technician’s commission (commissionable payroll adjustments paid to other technicians).

Calculation - Totals: Net Service Volume:[All Invoices: Net Service Volume]

  • If the technician earned sales commission (the Split % is designated as SB), the invoice is not included in Net Service Volume.

  • Business unit fees apply both to commissionable and non-commissionable invoice items.

  • Technician splits are applied.

Totals: Total Costs

Sum of job costs for all invoices, including material costs (when material costs are configured as deductible), equipment costs (when the equipment item is configured to pay commission), purchase orders, and non-job purchase orders.

Purchase orders designated as No Charge are not included in job costs.

Calculation - Totals: Total Costs:[All Invoices: Cost] + [Sum of Non-Job Purchase Orders: Amount]

  • Job costs are displayed as a debit (negative amount) on the Payroll (Detail) Report.

  • Technician splits are applied to job costs.

Totals: Commission Base

The technician’s Commission Base is calculated by deducting total job costs (materials, purchase orders, and non-job purchase orders) from the total Net Service Volume (the sum of all commissionable invoice items, minus business unit fees).

Calculation - Totals: Commission Base:[Totals: Net Service Volume] - [Totals: Total Costs]

Totals: Commission Base Totals: Net Commission

Sum of service commission (commission rate multiplied by commission base), designated range bonus (range bonus rate multiplied by commission base), and sales commission (sold by rate multiplied by invoice subtotal).

Calculation - Totals: Commission Base Totals: Net Commission: (([Sum of commissionable invoice items] - [Business unit fees]) - [Total Costs]) x [Commission rate]) + (([Sum of commissionable invoice items] - [Business unit fees]) - [Total Costs]) x [Range bonus rate]) + ([Sum of invoice subtotals where the technician earned sold by credit] x [Sold by rate])

Totals: Bonuses

Sum of SKU bonuses for all invoices. If any tasks or services (SKU invoice items) have a bonus configured, total SKU bonus amounts for all invoice items will be shown here. SKU bonuses may be configured as a flat amount, or as a percentage of the service price.

Calculation - Totals: Bonuses:[Sum of flat SKU bonuses for all invoices] + [Sum of percentage SKU bonuses all invoices]

  • The Bonus field does not include range bonuses (for information on how range bonuses are applied, see Range Bonuses above).

Totals: Adjustments

Sum of all direct payroll adjustments and net amount of commissionable payroll adjustments.

Calculation - Totals: Adjustments:[Sum of Direct Payroll Adjustments: Amount] + [Sum of Commissionable Payroll Adjustments: Net $]

  • Technician splits are not applied to payroll adjustments.

Totals: Gross Pay

The technician’s total gross pay. The technician’s total gross pay is the sum of net commission, bonuses, and adjustments.

Calculation - Totals: Gross Pay:[Totals: Net Commission] + [Totals: Bonuses] + [Totals: Adjustments]


Breakdown of Gross Pay

Gross Pay = Net Commission + Bonuses + Adjustments

Gross Pay =

Net Commision

(([Sum of commissionable invoice items] - [Business unit fees] - [Sum of commissionable payroll adjustments paid to other technicians]) - [Total Costs]) x [Commission rate])

+

(([Sum of commissionable invoice items] - [Business unit fees] - [Sum of commissionable payroll adjustments paid to other technicians]) - [Total Costs]) x [Range bonus rate])

+

([Sum of invoice subtotals where the technician earned sold by credit] x [Sold by rate])

+

Bonuses

[Sum of flat SKU bonuses for all items on the invoice]

+

[Sum of percentage SKU bonuses for all items on the invoice]

+

Adjustments

[Sum of direct payroll adjustment amounts]

+

[Sum of net amounts of commissionable payroll adjustments]

+

([Sum of net amounts of commissionable payroll adjustments] x [Range bonus rate])



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