Employee Totals Master Maintenance - Overview

Use Employee Totals Master Maintenance to view totals for time worked, withholding amounts, earnings, vacation time accruals, and sick time accruals.  The fields are updated by the system, so you normally do not need to edit them.

Tips:

Directions:

To open click Employee Totals in the Employee File Maintenance - Menu Tree.
Keyboard shortcut:  [ALT + l]

Or, click the following sequence:
Payroll
from the Menu, Employee File Maintenance, and Employee Totals Maintenance.
Keyboard shortcut
:  [ALT] [p] [e] [t]

 

Employee Totals Maintenance Window Example:

 

  

 

Employee Totals Maintenance by Section

Tip:  You can see the following areas in the main Employee Totals Master Maintenance window.

Menu Tree

Open Employee File Maintenance programs.

Year-to-date Earnings

View the totals for time worked, earnings, and withholding amounts for the current year.

Reg Hrs/Days

Displays the accumulated regular time number of hours or days worked so far this year.  (4.3 numeric)

OT Hrs/Days

Displays the accumulated overtime time number of hours or days worked so far this year.  (4.3 numeric)

Reg Earnings

Displays the total for Regular Earnings accumulated so far this year.  (7.2 numeric)

Note:  The Regular Earnings total includes shift differential earnings, which are identified by the Other Pay Type (7 - Shift Differential) for an Other Pay Code.

OT Earnings

Displays the total for Overtime Earnings accumulated so far this year.  (7.2 numeric)

OP Earnings

Displays the current total for Other Pay Earnings accumulated so far this year.

Notes:

  • You can not maintain this value because it is calculated directly from posted transactions.

  • The Other Pay Earnings total excludes shift differential earnings, which are identified by the Other Pay Type (7 - Shift Differential) for an Other Pay Code.

Federal W/H

Displays the total amount withheld for federal taxes so far this year.  (5.2 numeric)

Reg FICA W/H

Displays the total amount withheld for regular FICA taxes so far this year.  (5.2 numeric)

Med FICA W/H

Displays the total amount withheld for Medicare FICA taxes so far this year.  (5.2 numeric)

State W/H

Displays the total amount withheld for state taxes so far this year.  (5.2 numeric)

Local W/H

Displays the total amount withheld for local taxes so far this year.  (5.2 numeric)

Employee Earnings Totals Area

View the earnings totals for the current month, quarter, and year and the current year-to-date time worked, earnings, and withholding amounts.

These fields are automatically updated, so you do not normally need to edit them.

Contract

Note:  The Period End Clear process clears the following fields when you specify contract.

  • Contract MTD - Displays the accumulated earnings for the current month in the contract year.  (6.2 numeric)

  • Contract QTD - Displays the accumulated earnings for the current quarter in the contract year.  (6.2 numeric)

  • Contract YTD - Displays the accumulated earnings for the current contract year.  (7.2 numeric)

Calendar

Note:  The Period End Clear process clears the following fields when you specify calendar.

  • Calendar MTD - Displays the accumulated earnings for the current month in the calendar year.  (6.2 numeric)

  • Calendar QTD - Displays the accumulated earnings for the current quarter in the calendar year.  (6.2 numeric)

  • Calendar YTD - Displays the accumulated earnings for the current calendar year.  (7.2 numeric)

Fiscal

Note:  The Period End Clear process clears the following fields when you specify fiscal.

  • Fiscal MTD - Displays the accumulated gross earnings for the current fiscal month.  (6.2 numeric)

  • Fiscal QTD - Displays the accumulated gross earnings for the current fiscal quarter.  (6.2 numeric)

  • Fiscal YTD - Displays the accumulated gross earnings for the current fiscal year.  (7.2 numeric)

Med FICA QTD

Displays the gross earnings for the current quarter for Medicare-Only FICA.

Note:  This applies only to earnings for employees whose FICA Code is 2 - Medicare Only.

Med FICA YTD

Displays the gross earnings for the current year for Medicare-Only FICA.

Note:  This applies only to earnings for employees whose FICA Code is 2 - Medicare Only.

Vacation/Sick Detail Area

Displays accrual totals for vacation and sick time.

Miscellaneous Area

Displays the totals for retirement-related fields.

Tip:  To display the following areas in Employee Totals Master Maintenance, you must click the appropriate option in the Menu Tree.

Employee Scheduled Deductions Totals Window

Displays the totals for scheduled deductions.

Employee Other Pays Totals Window

Displays the totals for other pay.

Editing Employee Totals

CAUTION:  To avoid losing data, you must save changed employee totals.

1.  Enter the Employee Number and click Retrieve or press [ENTER].
Keyboard shortcut
:  [ALT + t]
Tip
:  If you do not know the Employee Number, you can click Search to see a list of employees.

2.  Position the pointer to the information that you want to change.

3.  Enter the changes.

4.  To complete the edit process, click Save or press [ENTER].
Keyboard shortcut:  [ALT + s]

Deleting Employee Total

Notes:  

  • Employee Maintenance automatically deletes the totals when you delete an employee, so you can not delete totals using this program.

  • To delete an employee, the totals must be zero.

Other File Maintenance