Contents of the View Employee Earnings Screen

Use the fields and options to configure the View Employee Earnings screen.

Selection Criteria

Use this group box to select the parameters pertaining to the records you want to review. You can select records for review based on the types of transactions, the employee whose record was changed, the user who made the modifications, and/or the date of any modifications. After you make your selections, click to fill the table window with the records you selected.

Transaction Type

Use this group box to select which type of transactions to include when selecting records to be displayed in the retrieved records table.

Field Description
Add

Select this checkbox to include Add transactions.

Delete

Select this checkbox to include Delete transactions.

Update

Select this checkbox to include Update transactions.

Identification

Use this group box to select which employee's records to include in your review. You can also elect to review only the modifications made by a single user.

Field Description
Employee

Enter, or click to select, the ID of the employee for this payroll record. Upon entering the ID, the employee's taxable entity, pay cycle and name will default. Also, the employee's current federal tax setup from the Manage Employee Taxes screen will default into the Employee Tax Setup tab. The employee must have a Manage Employee Taxes record and the employee's pay cycle must have an open pay period before a payroll record can be entered for that person.

To view an existing record, click and select the employee's record.

User

Enter, or click to select, the user ID (Costpoint login ID) for the user who is responsible for the modifications you wish to include in the record selection process. This is an optional field; if this field is left blank, Costpoint includes records regardless of who made the modifications.

Date Modified

Enter, or click to select, the date of the transaction modifications to include in the displayed output. This is an optional field; if this field is left blank, Costpoint includes records regardless of when the modifications were made. The system format for date is MM/DD/YYYY.

Federal/State Wages and Taxes

Field Description
Transaction Type

This non-editable field displays the type of modification for the specific transaction displayed. The types are:

  • A: Add transaction
  • D: Delete transaction
  • U: Update transaction

Transaction Source

This field displays the application where the update to the audit record originated.

Modified By (User) This non-editable field displays the user ID (Costpoint login ID) for the user who made the modifications shown in this transaction.
Date Modified

This non-editable field displays the date on which the modification took place for this transaction.

Employee This non-editable field displays the ID of the employee whose record was modified.
Employee Name This non-editable field displays the name that corresponds to the employee ID for this transaction.
Taxable Entity This non-editable field displays the taxable entity to which the employee in this transaction is assigned.
Type

This non-editable field displays the check type for the employee referenced in this transaction. The types are:

  • R: Regular Paycheck
  • B: Bonus Paycheck
  • X/Y: Paycheck without Timesheet
  • Z: A check entered manually on the Manage Employee Earnings History screen
Pay Cycle This non-editable field displays the pay cycle assigned to the employee referenced in this transaction.
Pay Cycle End Date This non-editable field displays the pay cycle end date for this transaction.
Union Employee
This checkbox indicates whether the employee is a union employee. The value is based on the employee's Union Employee checkbox on the Manage Employee Information screen and is set through the following:
  • When the employee ID is entered for a manually entered payroll X or Y record
  • When the R-Regular or B-Bonus record is created by the Compute Payroll application
  • When a V or W record is created by the Void/Replace Posted Paychecks application
Note: This checkbox is not editable. You can view this checkbox if the Enable union functionality is selected on the Configure Labor Settings screen. If it is selected, the union fringe detail will be visible in the Deductions and Contributions subtasks.
Fiscal Year This non-editable field displays the fiscal year for this transaction.
Period This non-editable field displays the accounting period for this transaction.
Posting Seq No This non-editable field displays the posting sequence number for this transaction.
Check Number This non-editable field displays the paycheck number issued for this transaction.
Check Date

This non-editable field displays the date on which the paycheck was issued for the check referenced in this transaction.

Disbursement Type

This non-editable field displays the disbursement code, C (Check) or D (Direct deposit advice) for the employee referenced in this transaction.

Tax Service Group ID

This field displays the Tax Service Group ID to which the employee is assigned as of the check date. This field is used to group the employee for tax reporting purposes.

Reference Number

This field displays reference number that is used to identify this record. This is an optional field. If applicable, enter the number of the employee earnings check that is associated with this record.

Reference Date

This field displays the reference date that is used to identify this record. This is an optional field. If applicable, enter the date of the employee earnings check that is associated with this record.

Voided Check

This non-editable checkbox is selected if the Type field is V and the Void/Replace Posted Paychecks application is run for this check.

Federal Exempt Pay Type This non-editable field displays the total of the federal exempt pay types for the employee referenced in this transaction.
Federal Exempt Deductions This non-editable field displays the total of the federal exempt deductions for the employee referenced in this transaction.
Federal Taxable Wages This non-editable field displays the federal taxable wages for the employee referenced in this transaction.
Federal Taxable Withheld This non-editable field displays the amount of federal income taxes withheld for the employee referenced in this transaction.
Soc Sec Exempt Pay Types This field displays the amount for the employer portion of social security exempt pay types.
Soc Sec Exempt Deductions The field displays the total of the social security exempt deductions. This field is not editable.
Soc Sec Taxable Wages This field displays the amount for the employer portion of social security taxable wages.
Soc Sec Accrued Expense This field displays the employer expense accrued for social security.
Medicare Exempt Pay Types This field displays the amount for the employer portion of Medicare exempt pay types.
Medicare Exempt Deductions This field displays the total of the Medicare exempt deductions. This field is not editable.
Medicare Taxable Wages This field displays the amount for the employer portion of Medicare taxable wages.
Medicare Accrued Expense This field displays the employer expense accrued for Medicare.
Medicare Additional Wages This field displays the Medicare taxable amount which exceeds the IRS threshold for additional Medicare taxation.
Medicare Additional Withheld This field displays the additional calculated Medicare tax withholding amount.
FUTA Exempt Pay Types

This field displays the total of all earnings amounts that are linked to pay types which are exempt from FUTA Taxable Wages. The taxability of pay types is determined on the Manage Pay Type Taxability screen. The pay types processed are detailed on the Pay Types subtask.

FUTA Exempt Deductions

This field displays the total of all deduction amounts that are exempt from FUTA Taxable Wages. The taxability of deductions is determined on the Manage Deductions screen. The deductions processed are detailed on the Deductions subtask.

FUTA Subject Wages

This field displays wages that are subject to FUTA. This is not necessarily the FUTA taxable wages since the U.S. federal government imposes a limit on the amount of wages which can be FUTA taxable. This field is calculated by subtracting the FUTA Exempt Pay Types amount and the FUTA Exempt Deductions amount from the Gross Amount.

FUTA Excess Wages This field displays the portion of wages that are subject to FUTA, but are in excess of the FUTA Wage Limit. This field is calculated by subtracting the FUTA Wage Limit from the FUTA Subject Wages.
FUTA Taxable Wages

This non-editable field displays the amount of FUTA taxable wages for the employee referenced in this transaction.

FUTA Rate

This field displays the FUTA Employer Rate on the Manage Federal Taxes screen of the payroll year that equals the payroll year on the check date.

FUTA Accrued Expenses

This non-editable field displays the amount of FUTA accrued expense for the employee referenced in this transaction.

SUTA State

This non-editable field displays the two-character code for the SUTA state assigned to the employee referenced in this transaction.

SUTA Exempt Pay Types

This field displays the total of all earnings amounts that are linked to pay types which are exempt from SUTA Taxable Wages. The taxability of pay types is determined on the Manage Pay Type Taxability screen. The pay types processed are detailed on the Pay Types subtask.

SUTA Exempt Deductions

This field displays the total of all deduction amounts that are exempt from SUTA taxable wages. The taxability of deductions is determined on the Manage Deductions screen. The deductions processed are detailed on the Deductions subtask of this screen.

SUTA Subject Wages This field displays wages which are subject to SUTA. This is not necessarily the SUTA taxable wages since the U.S. federal government imposes a limit on the amount of wages which can be SUTA taxable. This field is calculated by subtracting the SUTA Exempt Pay Types amount and the SUTA Exempt Deductions amount from the Gross Amount.
SUTA Excess Wages This field displays the portion of wages which are subject to SUTA, but are in excess of the SUTA Wage Limit. This field is calculated by subtracting the SUTA Wage Limit from the SUTA Subject Wages.
SUTA Taxable Wages

This non-editable field displays the amount of SUTA taxable wages for the employee referenced in this transaction.

SUTA Rate

This field displays the SUTA rate.

SUTA Accrued Expense

This non-editable field displays the amount of SUTA accrued expense for the employee referenced in this transaction.

Total Hours This non-editable field displays the total hours that were charged from the timesheets that were processed for the employee referenced in this transaction.
Gross Amount This non-editable field displays the amount of gross pay for the employee and check referenced in this transaction.
Reimbursements This non-editable field displays the total reimbursement amount excluded from gross earnings for the payroll record. This total includes any earnings amount from the

Reimbursements

field on the Manage Payroll Records screen (where the Pay Type's Reimbursement Exclude from Gross checkbox is selected on the Pay Types subtask of the Manage Payroll Records screen).
Net This non-editable field displays the net pay for the employee and check referenced in this transaction.
Federal Filing Status

This field displays the employee's federal filing status, such as S (Single) or M (Married).

Federal Exemptions

This field displays the number of federal tax exemptions claimed on Form W-4 by the employee.

Federal Override Amount

This field displays the employee’s federal withholding override amount (in lieu of the Costpoint-calculated amount withheld).

Federal Override Percent

This field displays the employee’s federal withholding override percentage (not the percentage from the Federal Tax tables).

No of Federal Dependents This field displays the number of qualifying children under 17 (Step 3 of Form W-4).
No of Other Federal Dependents This field displays the number of other dependents (Step 3 of Form W-4).
Federal Other Tax Credit Amount This field displays the employee's other tax credit amount (Step 3 of Form W-4).
Federal Other Income Amount This field displays the employee's other income amount (Step 4a of Form W-4).
Federal Deductions Amount This field displays the employee's total deductions amount (Step 4b of Form W-4).
Federal Additional Amount

This field displays any additional federal tax amount the employee elected to withhold, above the Costpoint-calculated amount.

Subject to Social Security

This field displays if the employee is subject to Social Security Payroll Tax.

Subject to Medicare

This field displays if the employee is subject to Medicare Payroll Tax

Subject to FUTA

This field displays if the employee is exempt from federal unemployment tax.

Subject to SUTA

This field displays if the employee has unemployment insurance coverage for the specified SUTA State.

Federal Step 2 of W-4 This checkbox indicates if the table for Step 2 of W-4 will be used for this employee's filing status (W-4 Step 2).
Form W-4 Version

This field displays the version of Form W-4 used by the employee, 2019 or 2020 or greater.

If 2019 is selected, it means the most recent W-4 form submitted by the employee is 2019 or its earlier versions. If 2020 or greater is selected, it means the employee has submitted the 2020 W-4 form or its succeeding versions.

Name This field displays the name that was used on the employee's paycheck or advice. Changing the employee's name after the paycheck/advice has been printed will not update this value. The field is only populated when the paycheck/advice is printed. Upon posting payroll, this value will be stored in the Manage Employee Earnings History table.
Social Security Number

This field displays the Social Security Number assigned to the employee when the check/advice was printed. Changing the employee's Social Security Number after the paycheck/advice has been printed will not update this value. The field is only populated when the paycheck/advice is printed. Upon posting payroll, this value will be stored in the Manage Employee Earnings History table.

Employee Type This field displays the employee type. Valid values are:
  • Hourly
  • Salaried Fixed Hours
  • Salaried Fluctuating Hours
Rate Type

This field displays the rate type (Hourly/Salaried) assigned to the employee when the check/advice was printed. Changing the employee's rate type after the paycheck/advice has been printed will not update this value. The field is only populated when the paycheck/advice is printed. Upon posting payroll, this value will be stored in the Manage Employee Earnings History table.

FLSA Classification

This field displays the FLSA Classification (Exempt/Non-Exempt) assigned to the employee when the check/advice was printed. Changing the employee's FLSA Classification after the paycheck/advice has been printed will not update this value. The field is only populated when the paycheck/advice is printed. Upon posting payroll, this value will be stored in the Manage Employee Earnings History table.

Pay Frequency

This field displays the pay frequency (weekly/bi-weekly/semi-monthly/monthly) assigned to the employee's pay cycle.

Pay Period Salary (Exempt Employees)

If the employee's FLSA Classification is Exempt, this field displays the salary amount assigned to the employee when the check/advice was printed. Changing the employee's salary amount after the paycheck/advice has been printed will not update this value. The field is only populated when the paycheck/advice is printed. Upon posting payroll, this value will be stored in the Manage Employee Earnings History table.

Employee Mailing Address

This group box displays the mailing address assigned to the employee when the check/advice was printed. Changing the employee's Mailing Address after the paycheck/advice has been printed will not update this value. The field is only populated when the paycheck/advice is printed. Upon posting payroll, this value will be stored in the Manage Employee Earnings History table.

Field Description
Paystub Address Line 1 This field displays the first line of the employee's home address.
Paystub Address Line 2 This field displays the second line of the employee's home address.
Paystub Address Line 3 This field displays the third line of the employee's home address.
Paystub City This field displays the city of the employee's home address.
Paystub State/Province This field displays the state or province of the employee's home address.
Paystub Postal Code This field displays the postal code of the employee's home address.
Employer Medicare Exempt Pay Types This field displays the total of the federal exempt pay types. The taxability of pay types is determined on the Configure Pay Type Taxability screen. The pay types processed are detailed on the Pay Types subtask of this screen.
Employer Medicare Taxable Wages

This field displays the net of gross less the federal exempt pay types and federal Exempt Deductions.

Employer Soc Sec Exempt Pay Types The total of the social security exempt pay types is displayed. The taxability of pay types is determined on the Configure Pay Type Taxability screen. The pay types processed are detailed on the Pay Types subtask of this screen.
Employer Soc Sec Taxable Wages The net of gross less the Social Security Exempt Pay Types and Social Security Exempt Deductions is displayed.

Subtasks

Subtask Description
State Pay Types Click this link to open the State Pay Types subtask.
Pay Types Click this link to open the Pay Types subtask.
State Taxes Click this link to open the State Taxes subtask.
Local Taxes Click this link to open the Local Taxes subtask.
Deductions Click this link to open the Deductions subtask.
Contributions Click this link to open the Contributions subtask.
Workers' Comp Click this link to open the Workers' Comp subtask.
Paystub Hourly Rate Detail Click this link to view information that was included on the paystub or was in effect when it was printed.