BENEFIT / DEDUCTIONS MAINTENANCE

Table of Contents

DESCRIPTION

This module allows the user to maintain the Benefit and Deduction records. Note: These are referred to as Ben/Deds throughout this manual.

Ben/Ded records allow for multiple rates per pay code. Every Ben/Ded code must be tied to a master Pay code.

Each employee will have his/her own list of ben/ded records per payroll year. Ben/deds can be added to employees either via the employe maintenance module or via the 'Update Employee' option described below.

The rates entered for each ben/ded are only used as a default for adding or updating employee records. When a ben/ded record is added to an employee's ben/ded list it is a copy of the original and the rates can then be modified if neccesary for each employee. When a pay record is generated the rates in the employees' records are used.

OPENING SCREEN



FIELD DESCRIPTIONS

The following must be entered when adding or updating a ben/ded record:

BD Reference: Unique number to identify Ben/Ded record. You may want to use the convention of using the ben/deds master pay code and adding 0-9 at the end of it.

Description: Descriptive title of the Ben/Ded.

Master Pay Code Number: Enter the pay code that this ben/ded is related to.

Coverage Level: Used for adding records to employee's where this coverage level matches the employee's medical level. (primarily for medical/insurance-type codes). Options include Single, Married, Family and Not Applicable.

Year End Options: This field should be completed dependent upon the action required for the ben/ded codes at year-end. Options include Leave as is, Zero YTD totals, Zero Target and YTD totals, and Delete if Target total is reached.

New Employee Default: Check if you want the ben/ded to be automatically added to the employee's Ben/Ded list when entering a new employee in Employee Maintenance. You need only to verify the employee ben/ded table as the system will automatically set up all options for you.

Ben/Ded Calculation types:

  1. Flat Amount: used for ben/deds that require a flat rate. Enter a default rate in the attached field.
  2. Rate Per Worked Hour: used for ben/deds which are calculated based on worked hours. Enter a default rate in the attached field.
  3. Percentage of Before Tax Earnings: used for ben/deds which are calculated as a percentage of before tax earnings. Enter a default percentage in the attached field.
  4. Percentage of After Tax Earnings: used for ben/ded which are a calculated as a percentage of after tax earnings. Enter a default percentage in the attached field.
  5. Percentage of Other Pay Code: used when the calculation is based on a percentage of another pay code. Enter a default percentage in the attached field.
  6. Table Look Up Only
  7. Employee's Hourly Rate: used when the benefit/deduction is calculated on the employee's hourly rate. ie; some unions charge 1.5 times the employee's hourly rate for union dues.

TABLE SET-UPS

For the benefit/deduction codes that require more than one basic calculation, the adjoining 'Table' fields may be set up. To achieve this, click the 'Edit Tables' button on the right side of the window. This area will allow you to set up variables needed to produce the correct calculation of your benefit/deduction code. The screen is divided into two sections. The top section lists the name and title of the benefit/deduction variable, and the lower section lists the detail. You may set up numerous calculation variables, depending on what is required.



BULK ADD TO or UPDATE EMPLOYEES' RECORDS

When a ben/ded amount/rate/percentage changes the appropriate field must be updated in the employees' records.

To accomplish this:

  1. Find the required ben/ded(s) and upate the rate/amount/percent field.
  2. When all required records are updated select the 'Update Employee' option on the menu to display the following window.

  3. Ensure that the correct payroll year is displayed.
  4. Highlight the ben/ded record in the list at the bottom of the window that you want to add or update.
  5. If Adding ben/deds records to employees then set the options in the top left quadrant of the window and click on the 'Add to Employees' button.
  6. If Updating employees' existing ben/deds then set the options in the top right quadrant of the window and click on the 'Update Existing Records' button.



BENEFIT/DEDUCTIONS LIST REPORT

Click the report option on the menu bar to generate a report of the ben/ded records.



EMPLOYEES BEN/DEDS REPORT

This report lists the employees' ben/ded records. For a report listing benefit/deductions generated from each pay run, please see Benefit/Deductions Report in the Payroll Section.

The user may choose a listing by ben/ded code(s) (all, 1 only or tagged list), by specific employee(s), by payroll year(s) and/or by the ben/ded records status (All, Active, Inactive). This report is also available from the main payroll's employee menu.



Sample Report

Table of Contents Top