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

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]

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.

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]

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.

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.

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]