Summary

The General Wage Export is used to create a .csv export file that includes much of the information on the General Wage report. This export is designed to meet additional state-specific reporting requirements.

Step by Step

1     Open the General Wage Export window (PR> Reports> General Wage Export).

2     Configure the General tab.

• The Configuration field is used to specify the configuration for the export file.
  • Export file configurations are created and maintained on the Export Configuration Maintenance window (SS> Maintenance> Export Configuration). 
  • Once a configuration is selected, click the Display icon   to display the expected file layout.
  • By creating your own custom export configuration, you can include a wide variety of employee data in the export, such as position, salary, and hours per year.
• The Employee Number field is used to include a single employee in the export. Enter an employee number or click the Employee Number field to select one from a list.
• The Department field is used to include only employees of a single department in the export. Enter a department number or click the Department field label to select one from a list.
  • Departments are created and maintained using the Department Maintenance window (SS> Maintenance> Department).
  • Departments are attached to employees using the Employee Maintenance window (PR> Maintenance> Employee> General tab> Department field).
• The Reporting Group field is used to include the employees that are attached to a reporting group. Reporting groups are user-defined groupings of employee records that are created and maintained in the Reporting Groups Maintenance window (PR> Maintenance> Reporting Group). Enter a reporting group in the Reporting Group field to include only the employees attached to a reporting group on the report.
  • Employees are attached to a reporting group using the Reporting Groups Maintenance window (PR> Maintenance> Reporting Groups).
• Select the wage you would like to display in the export in the Subject Wages drop-down menu.
• The Maximum Wages field is used to cap the subject wages that display in the export. If the subject wages are greater than the value entered in the Maximum Wages field, the wages will be capped at the maximum amount.
• The Date to Use drop-down menu is used to select the type of date used to filter the paychecks that will be included in the export. The selection in this field will determine the functionality of the Start Date and End Date fields.
  • Select Check if you would like to use the check date to filter the wages that display in the export.
  • Select Period End if you would like to filter the checks that display in the export by the period end date of the Computer Checks batch used to generate the paychecks.
    • The period end date of a paycheck is set up during the Generate step (PR> Computer Checks> Generate).
• Enter a date in the Start Date and End Date fields to filter the checks that display in the export.
  • The Date to Use drop-down menu determines the functionality of the Start Date and End Date fields.
• Check the Include Deduction Reference toggle to include the contents of the deduction reference field in the export.
  • This data is pulled from Employee Maintenance> Deductions tab> Reference field.
• Check the Exclude employees with zero contributions toggle if you would like to exclude employees that did not make any contributions to the selected deductions/benefits during the specified date range.
• Check the Exclude employees without this deduction/benefit toggle to exclude employees from the export that do not have the deductions/benefits selected in the Deduction/Benefit field.
  • You can view the deductions attached to an employee on the Employee Maintenance window (PR> Maintenance> Employee Maintenance> Deductions tab).
• Check the Exclude uncommitted history toggle if you would like to exclude uncommitted transactions from the export. Payroll checks in an open Computer Checks batch will not be included in the export.
• Check the Exclude terminated employees toggle if you would like to exclude employees with a terminated status.
• The Benefit/Deduction Codes field is used to filter the benefits and deductions that are included in the export.
  • You can use the Select All and Deselect All   icons to select or deselect all of the benefit/deduction codes or types.
• The Benefit/Deduction Types field is used to filter the benefit and deduction types that are included in the export. All the benefits and deductions within the selected type will be rolled into a single field.

3     Generate the export.

• Click the Confirm icon to export the General Wage data.
• Once the export has finished processing, the Export Settings window will open. This window is used to specify the export path for the file.
  • Check the Open toggle if you would like to open the exported file after it is saved locally.
  • Enter the export path location and click the Save icon to export the file to the local path.