Module 6: Payroll Reporting
Module 7: Quarterly & Year-End Processing
3 of 4

Lesson 6.6: Employee Deduction Summary

While the Employee Contribution Summary tracks the amounts your organization pays on behalf of staff, the Employee Deduction Summary report provides an itemized list of all the deductions withheld directly from your employees’ gross pay. This includes items such as employee-paid health insurance premiums, union dues, and employee retirement contributions.

What is Included in the Report? For the selected date range, the report details the following data for each employee:

  • Employee Number
  • Employee Name
  • Department
  • Deduction Amount

Reconciliation Tip: The total amount of deductions on this report should perfectly agree with the “Total Deductions” column found on the Employee Payroll Summary Report for the exact same time period.

Navigating to the Report Just like the contribution report, deductions are generated from adjustment rules rather than standard payroll taxes. Therefore, to access this report, you must navigate to the horizontal Main Menu, select Reports, click on Master Adjustments, and then choose Employee Deduction Summary.

Setting Report Parameters Before generating the report, use the parameter window to filter exactly what data you want to extract:

  1. Dates: Enter a specific start and end date. You can also click the Arrow drop-down icon next to the calendar to select preset date ranges like Last Month or Fiscal YTD.
  2. Employees: By default, the report is set to print “All” employees with activity in the selected period. You can restrict this by clicking the radial buttons for Active Only or Inactive Only.
  3. Specific Selection: To run the report for specific individuals, click the Employees drop-down to manually check or uncheck names. You can also use the Select All or Deselect All links, or use the Filter search bar to find a specific employee.
  4. Sorting: The default sort key for this report is by Employee Name in Ascending order. Use the Sort By drop-down list if you prefer to organize the data by Employee Number or Department, or switch the order to Descending.
  5. Departments: To run a summary for a specific department, select the department from the Departments drop-down list.

Generating and Exporting the Report Choose your desired output format using the radial buttons:

  • HTML: For quick on-screen viewing.
  • PDF: For printing an official, formatted document.
  • XLS (Excel): If you need to manipulate the data or use it in custom spreadsheets.
  • CSV (Comma Delimited): For importing raw data into another software system.

Once you select your format, click Generate Report. A preview window will appear indicating the time required to generate the report. From there, you can view, physically print, or save the document directly to your computer.

Lesson Content
0% Complete 0/1 Steps