Creating Supplemental Pay for Multiple Employees

The Payroll Adjustments utility allows you to manage supplemental earnings, deductions and/or employer contribution adjustments in the Time Clock system for multiple employees. When employees view their time using the Time Clock Reporting Tool, all earning and deduction items added to employee paychecks will appear as a bottom line addition to pay in the Misc Adjustment section.

You have received the sales commission payments from the Sales Manager and need to enter the appropriate amounts for each employee that is due commission. By using the Payroll Adjustments feature in ExponentHR, you can easily add commission pay for a group of employees.
 

 

To create a batch of supplemental pay items:

1.   On the Management Navigation Menu, click Wage & Tax > Payroll Management > Payroll AdjustmentsWage & Tax > Payroll Management > Payroll Adjustments.

 

The Payroll AdjustmentsPayroll Adjustments page displays.

 

2.   Manually enter payroll adjustments for employees (Grid Input Method) or import adjustments from a file (File Import Method).

Using Grid Input MethodUsing Grid Input Method

You may manually enter payroll adjustments for each employee on the list, if necessary.

1.   Select the Grid Input MethodGrid Input Method option to create the payroll adjustment batch.

2.   Select the pay group to which you would like to add a supplemental pay item from the Pay Group drop-down box.

3.   Select the pay period in which you want to apply the supplemental pay item from the Pay Period drop-down box.

4.   Enter a description of the supplemental pay item in the Default Desc text box.

      Note: This description is used strictly as a descriptive reference in the Time Clock Reporting tool.

5.   Select the payroll code (overtime, holiday pay, bonus pay, commission, tips, etc.) that best matches the supplemental pay item from the Payroll Code(s) drop-down box.

      Notes:

    • You can also select one of the Multiple Types options (Dollars, Hours, Pieces, Tips/Receipts, Deductions, ER contributions, or Contractor) under the "Standard File Import" section of the drop-down list if you want to include more than one code of the same payroll code type in the same batch.

    • You cannot mix pay types for contractors with those for employees.

    • The Sales Receipt code options are only applicable for those designated as a Tipped Employees.

6.   If you want this supplemental item to apply to employees even if they are terminated during the pay period, enter a date in the Terminations as of text box.

      If an employee is terminated during the pay period, the employee will still receive the supplemental item as long as their termination date falls on or after the date you selected.

7.   If you want to hide this supplemental item from employees until their pay date, check the Employee Visibility: HideEmployee Visibility: Hide check box.

      The pay adjustment will still be applied to employee paychecks, but will not be displayed when the employee reviews their hours in ExponentHR. Employees will instead see the payroll adjustment on their check stubs when they are paid.

8.   If you selected a dollar-based pay type, the Overtime Applicability area displays, allowing you to apply the supplemental pay to past overtimeapply the supplemental pay to past overtime.

Mark the radio button beside Date Range and enter a date range to which the supplemental pay applies in the Overtime Applicability start and end date boxes.

Note: If you do not want to apply the supplemental pay to past overtime, select the None option.

Result: Based on the amount of supplemental pay you enter, ExponentHR recalculates the OT rate for the specified date range and issues retroactive overtime pay. The OT adjustment appears in the Time Clock report and as a misc. adjustment on the employee's paycheck.

9.   Select the Create BatchCreate Batch button.

      The Payroll AdjustmentsPayroll Adjustments page displays a list of employees in the pay group.

Manually Entering Payroll AdjustmentsManually Entering Payroll Adjustments

1.   If you selected multiple codes for the Payroll Code, select the pay type or sales receipt type from the Type drop-down list.

2.   Enter the amount of the adjustment to be applied to each employee's paycheck in the Hours/Dollar Amount text box of the row associated with the employee.

Note: Whether the text box is labeled Hours or Dollar Amount depends on the pay type you selected -- you will either enter a number of hours to be adjusted or a set monetary amount. You may specify a unique amount for each employee, if necessary.

3.   If desired, enter an Alternate Description to appear on the Time Clock Reporting tool for an employee instead of the previously entered Default Description.

4.   To enter an additional adjustment for an employee included in the payroll group you selected, click the Add EmployeeAdd Employee button and select the employee.

A new row for the employee appears in the Payroll Adjustments table -- complete the Hours/Dollar Amount and Alternate Description text boxes, as necessary.

Notes:

      • You may add a new row for an employee already listed in the table, if necessary, to itemize multiple payroll itemsmultiple payroll items for a single employee. Click the Insert Additional Employee Row button () next to the employee's name, and then enter one earning type (ex. commission) on each row. These earning items will be itemized and reported separately for the employee.

      • If you selected a contractor Payroll Code, the Add Employee button appears as Add Contractor instead.

5.   If you want to change an employee's default allocations to specific classifications, you can override the cost allocations.

Override cost allocationsOverride cost allocations

Notes:

          • The employee must be authorized for the classifications in Cost Allocation Setup.

          • The allocation options in Payroll Adjustments use the same classification fields that are enabled for the employee in Time Clock.

          • The allocation override is 100% to the specified classification(s). To split the allocation, you must post the adjustment in multiple records or use the percentage allocation option available in Time Clock Review.

1.   To create an allocation override, click the Edit Cost AllocationEdit Cost Allocation button.

The Edit Cost AllocationsEdit Cost Allocations page displays.

2.   Select the correct values in the classification field(s).

3.   Click OK.

Result: A running total of all entered adjustments displays at the bottom of the screen.

Using File Import MethodUsing File Import Method

You may import a previously created file of employee payroll adjustments, if necessary.

1.   Select the File Import MethodFile Import Method tab to create the payroll adjustment batch.

2.   Select the pay group to which you would like to add a supplemental pay item from the Pay Group drop-down box.

      Note: Supplemental items can be imported for any employee who is associated with the selected pay group, regardless of current employment status.

3.   Select the pay period in which you want to apply the supplemental pay item from the Pay Period drop-down box.

4.   Enter a description of the supplemental pay item in the Default Desc text box.

      Note: This description is used strictly as a descriptive reference in the Time Clock Reporting tool.

5.   Select the payroll code (overtime, holiday pay, bonus pay, commission, tips, etc.) that best matches the supplemental pay item from the Payroll Code(s) drop-down box.

      Notes:

    • By selecting Multiple Types, you can upload a file using a custom file import template.

    • By selecting one of the options in the Multiple (Standard File Import) section of the available drop-down list, you may upload a file with multiple payroll codes of the same type (dollars, hours, deductions, contributions, or other options) using the Standard ExponentHR Import TemplateStandard ExponentHR Import Template.

    • You cannot mix pay types for contractors with those for employees.

    • The Sales Receipt code options are only applicable for those designated as a Tipped Employees.

6.   If Multiple Types has been selected in the Payroll Codes(s) drop-down box, select the appropriate custom template in the Import File Template drop-down box.     

Note: To learn how to create a custom or standard payroll adjustment file, see Related Help Topics at the bottom of this page.

7.   If you want to hide this supplemental item from employees until their pay date, check the Employee Visibility: HideEmployee Visibility: Hide check box.

      The pay adjustment will still be applied to employee paychecks, but will not be displayed when the employee reviews their hours in ExponentHR. Employees will instead see the payroll adjustment on their check stubs when they are paid.

8.   If you selected a dollar-based pay type, the Overtime Applicability area displays, allowing you to apply the supplemental pay to past overtimeapply the supplemental pay to past overtime.

Mark the radio button beside Date Range and enter a date range to which the supplemental pay applies in the Overtime Applicability start and end date boxes.

Note: If you do not want to apply the supplemental pay to past overtime, select the None option.

Result: Based on the amount of supplemental pay you enter, ExponentHR recalculates the OT rate for the specified date range and issues retroactive overtime pay. The OT adjustment appears in the Time Clock report and as a misc. adjustment on the employee's paycheck.

9.   Select the Upload FileUpload File button.

      The Upload Payroll Import FileUpload Payroll Import File page displays.

10.  Click the Select FileSelect File button to open a list of folders on your computer.

11.  Navigate through the folders and select the appropriate payroll adjustment file from the list.

12.  Click the Open button.

13.  Click the Upload FileUpload File button.

Result: As a Payroll Adjustment ReviewPayroll Adjustment Review,  the payroll adjustment amounts in the file will automatically be reflected for the applicable employees in the pay group. A total of all adjustments will display at the bottom of the screen.

Notes:

    • If you import multiple payroll adjustment entries for the same employee (for example, an employee with multiple commissions), these entries will be imported as separate line items.

    • If the file is not a valid payroll adjustment list or if other errors exist for particular line items, you will receive an error message.

    • You cannot edit the records imported form a file. To edit the dollar amounts or hours, update import file as needed and select the Re-ImportRe-Import button to have the updated file replace the old file's information before posting the adjustments.

3.   Once all the adjustments are entered, click the Post AdjustmentsPost Adjustments button.

 

A summary of all employee payroll adjustments you have made displays.

4.   When satisfied with the summary, click the Confirm PostConfirm Post button to have the adjustments applied to the selected pay period.  

 

      If you want to change adjustments, click the Edit DataEdit Data button to return to the list of employees in the pay group.  

 

Result: A pop up message displays 'Post Complete,' and the Payroll Adjustments page displays.  The adjustments will immediately be displayed on each employee's Time Clock Reporting page.

 

Related Help Topics:

Creating Payroll Adjustment Files

Creating One-Time Deductions for Multiple Employees

Recording Employer Contributions for Multiple Employees

Setting up Recurring Earning Adjustments