Deduction Register Report

The Deduction Register Report lists all payroll deductions and the amount the employer contributes. This report is a deduction detail report that only displays deduction codes that are set up with a Rebate Bill Code on the Deduction Code form. Use the Deduction Register Report form to determine what information prints on the report and in what order. This report can be run using payrolls in progress and calculated payrolls that are either initialized or posted. If you use a date range, only posted payroll vouchers display in the output.

Note:

•

This form uses Client Access Group security as well as Data Entity security.

•

Worksite Managers, Worksite Trusted Advisors, and Service Providers can access the form.

To access the form, click Reports menu. Under Payroll|Report, click Deduction Register Report. You can also easily access this report when processing payroll from the SuperBatch and the Process Payroll screen to help you review the payrolls better.

Note: You can also access the Deduction Register Report for a selected payroll in the Approval Payroll Reports form. To do this, select Approval Payroll Reports in the View Report/Analytic field on the Payroll Approval form, then select Deduction Register in the Report Title column.

To generate the Deduction Register Report:

Complete the following fields:

Under the Report Period section:

Field Name

Description

Payroll Number

The payroll number for which you want to run this report or click the Payroll Number link to select one from the Select Payroll Batches window.

Only the first 100 payroll numbers are displayed in the window. To see more payroll numbers, scroll down and click More.

Note:

•

When you click the Payroll Number hyperlink, you see a list of all available payrolls posted by the client.

•

When you run the report selecting a Payroll Number in initialized status, it returns data from the initialized payroll.

•

When you run the report selecting a Payroll Number in posted status, it returns data from the posted payroll.

•

When you run the report selecting a Date Range, it returns data only from the posted payroll and not initialized payroll.

Pay Date Range

Select this option if you want to run this report for a payroll batch in a specific Pay Date Range. Fill in the following fields:

•

Start Date - Enter the start date for the pay date range for which you want to run this report.

•

End Date - Enter the end date for the pay date range for which you want to run this report.

Under the Sort Options section:

Field Name

Description

Primary Sort

Select the primary sort option from the following:

•

Department

•

Division

•

Location

•

Project

•

Shift

Note: You have to select the primary sort option.

Secondary Sort

If you want, select a secondary sort option from the following:

•

Department

•

Division

•

Location

•

Project

•

Shift

Tertiary Sort

If you want, select a tertiary sort option from the following:

•

Department

•

Division

•

Location

•

Project

•

Shift

Under the Report Parameters section:

Field Name

Description

Detail Sort

Select the detail sort parameter for your report from the following options:

•

Employee Name - This is the default option. If used as the Detail Sort, the report groups and sub-totals all deductions by employee.

•

Deduction Code - Sorts and sub-totals the details in the report by deduction code.

•

Deduction Description - Sorts and sub-totals the details in the report by deduction description.

•

Deduction Code, Benefit Plan (Sub-Totaled Separately) - Sorts and sub-totals the details in the report first by benefit plan (as a sub-total within the deduction), then by deduction code.

•

Deduction Description, Benefit Plan Description (Sub-Totaled Separately) - Sorts and sub-totals the details in the report first by benefit plan description (as a sub-total within the deduction), then by deduction description.

•

Benefit Plan, Deduction Code (Sub-Totaled Separately) - Sorts and sub-totals the details in the report first by deduction code (as a sub-total within the benefit plan), then by benefit plan.

•

Benefit Plan Description, Deduction Description (Sub-Totaled Separately) - Sorts and sub-totals the details in the report first by deduction description (as a sub-total within the benefit plan), then by benefit plan description.

•

Deduction Code and Benefit Plan (Sub-Totaled Combined) - Sorts and sub-totals the details in the report by the combination of the deduction code and the benefit plan.

•

Deduction Description and Benefit Plan Description (Sub-Totaled Combined) - Sorts and sub-totals the details in the report by the combination of the deduction description and the benefit plan description.

•

Benefit Plan and Deduction Code (Sub-Totaled Combined) - Sort and sub-totals the details in the report by the combination of the benefit plan and the deduction code.

•

Benefit Plan Description and Deduction Description (Sub-Totaled Combined) - Sort and sub-totals the details in the report by the combination of the benefit plan description and the deduction description.

Report Type

Select the report type that you need from the following options:

•

Detail w/Break Totals - This is the default option. The report will include a break and sub-total for each of the sort options entered as well as a report total.

•

Detail Only - Shows only a report total; no sub-totals will be listed.

•

Summary Only - There is no detailed information, only sub-totals for each of the sort options entered, as well as a report total.

Under the Parameters section:

Field Name	Description
Sort on Sort Parameters Description	By Default this is unchecked. Check this option to use the sort parameters descriptions instead of the codes for the options entered in Primary Sort, Secondary Sort and Tertiary Sort.
Page Break on Primary Sort	By Default this is unchecked. Check this option to start a new page for a new Primary Sort.
Suppress Pay Group in Header	By Default this is unchecked. Check this option to exclude the Pay Group, Pay Period Start, and End Dates in the report header.
Suppress Zero Deductions	By Default this is unchecked. Check this option to exclude zero deductions. The default is to show all deductions, even zero balance ones.
Benefits Only	By Default this is unchecked. Check this option to show only deductions that are associated with a Benefit Plan.
Include Return and Retain Amounts	By Default this is unchecked. Check this option to give Service Providers the ability to include the Retained Amount and Returned Amount columns on the report.
Only Show deductions that are Returned to the Client	By Default this is unchecked. Check this option to give Service Providers the ability to show deductions that are returned to the client.

Under the Report Filters section:

Field Name	Description
Division	If you want to run this report for specific divisions, enter the divisions here or click the Division link and select them from the window. The corresponding Division Names will populate automatically.
Department	If you want to run this report for specific departments, enter the departments here or click the Department link and select them from the window. The corresponding Department Names will populate automatically.
Location	If you want to run this report for specific locations, enter the locations here or click the Location link and select them from the window. The corresponding Location Names will populate automatically.
Project	If you want to run this report for specific projects, enter the projects here or click the Project link and select them from the window. The corresponding Project Description will populate automatically.
Shift	If you want to run this report for specific shifts, enter the shifts here or click the Shift link and select them from the Select Employee window. The corresponding Shift Description will populate automatically.
Employee ID	If you want to run this report for specific employees, enter their employee IDs here or click the Employee ID link and select them from the Select Employee window. The corresponding Employee Names will populate automatically. Leave this field blank to select all employees associated with the users selected client.

Under the Detail Filters section:

Field Name

Description

Deduction Code

If you want to run this report for specific deduction codes, enter them here or click the Deduction Code link and select them from the Deduction Codes window. The corresponding Deduction Code Description will populate automatically.

Deduction Types

If you want to run this report for specific deduction types, select them from the following drop-down:

•

Voluntary

•

Section 125 Plan

•

Post Tax Benefit

•

Flexible Spending Account

•

Wage Garnishment

•

Employee Loan Payment

•

Pre-Tax Retirement Contribution

•

Catch-Up Retirement Contribution

•

Post-Tax Retirement Contribution

•

Retirement Plan Loan Payment

•

Roth 401(k) Contribution

•

Roth 104(k) Catch-Up Contribution

Benefit Plan ID

If you want to run this report for specific benefit plans, enter the benefit plans here or click the Benefit Plan ID link and select them from the Select Benefit Plan window. The corresponding Benefit Plan Description will populate automatically. Leave this field blank to select all benefit plans associated with the users selected client.

Insurance Classes

If you want to run this report for specific insurance classes, select them from the following drop-down:

•

Medical

•

Dental

•

Vision

•

Life Insurance

•

Short-Term Disability

•

Long-Term Disability

•

Bond

•

Other

Click Run. The report shows up on the screen.

Click XLS to download the report.

Click Close to close the screen at anytime.