Use this tab on the Manage Payroll Records screen to maintain the employee payroll table.
Use this group box to select an employee ID. This group box also displays information about the employee's pay cycle to which this record is applied. It identifies the type of record being processed.
Enter the ID of the employee you want to add to this table, or click to select the ID. To edit or view a record for an employee, click
and select the employee's record. The employee's name displays to the right of this field after you enter the employee ID.
Enter, or click to select, the company's taxable entity ID. Establish taxable entity IDs on the Configure Company Information screen.
Enter a check type of X or Y when you are adding a record to this table. If you are viewing an existing record that you have retrieved using , this field displays that record's check type and cannot be modified. Following is an explanation of paycheck types. This is a required field.
R — This represents regular paychecks. These types of paychecks can be generated only from a timesheet. Timesheet types of Regular and Correcting are combined to create regular paychecks.
B — This represents bonus paychecks. These types of paychecks can be generated only from a timesheet. The timesheet type is Bonus.
V — This represents the negative values of a voided check generated by the Void/Replace Posted Paychecks screen. This is a non-editable record.
W — This represents the positive values of a replacement check generated by the Void/Replace Posted Paychecks utility. This is an editable record, but can be generated only by the Void/Replace Posted Paychecks utility.
X — This paycheck type can be used any time you want to generate a paycheck without first entering a timesheet. In addition, an X type must be used to make correcting entries to the Employee Earnings table. You must enter a minimum of one line on the Pay Types subtask.
Y — This paycheck type can be used any time you want to generate a paycheck without first entering a timesheet. In addition, you must use a Y type to make correcting entries, if needed, in the Employee Earnings table. You must enter a minimum of one line on the Pay Types subtask.
There are no differences between X and Y records. There are two available record types so that two entries per person per Payroll Journal posting can be made.
The pay cycle for this record, which was assigned to the employee at the time payroll was processed, is displayed if you are in mode. Otherwise, the current open pay cycle is shown.
The pay cycle end date for this record is displayed in mode; otherwise, the current open pay cycle ending period is displayed.
As soon as the paychecks are printed from the Print Paychecks screen, the check numbers are automatically entered in this numeric field. You need not enter the check numbers manually for the payroll checks that are printed through Costpoint. The only time you must enter check data is when you issue a check that is manually written (that is, typed by hand) or when you have printed a computer check and you want to void the original check and re-issue a new one (before posting the Payroll Journal).
During initialization, if you are running Costpoint parallel with your former accounting system, you can enter timesheets, compute payroll, and then modify the withholdings to agree with the original checks before posting the Payroll Journal. Enter the original check numbers of the checks that were paid.
If you do print a check and want to void it before the Payroll Journal is posted to the General Ledger, enter this application, query the record (click ), and enter zeroes for the check number. You can then make changes to the paycheck, return to the Print Paychecks screen and print. As long as any record on the Manage Payroll Records screen has a "zero" check number and date, you can automatically print a check through the Print Paychecks screen.
As soon as you print the paychecks from the Print Paychecks screen, the check date is automatically entered in this date-formatted field. You do not need to enter the check date manually for the payroll checks that are printed in Costpoint. The only time you must enter a check date is when you issue a check that is manually written (that is, typed by hand) or when you have printed a computer check and you want to void the original check and re-issue a new one (before posting the Payroll Journal).
During initialization, if you are running Costpoint parallel with your former accounting system, you can enter timesheets, compute payroll, edit the withholdings to agree with the original checks before posting the Payroll Journal, and then enter the original check date of the checks that were paid.
If you do print a check and want to void it before the Payroll Journal is posted to the General Ledger, enter this application, query the record (use ), and enter zeroes for the check date. You can then modify the paycheck, return to the Print Paychecks application and print. As long as any record in the Manage Payroll Records screen has a "zero" check date and check number, you can automatically print a check through the Print Paychecks screen.
This field displays the disbursement code that identifies whether a paycheck or a direct deposit advice was issued. The disbursement code is set to spaces by the Compute Payroll program and whenever you add an X or Y record. The disbursement code is updated with the value of C for paychecks or D for direct deposit advices after a paycheck or direct deposit advice form is printed.
Enter, or click to select, the Tax Service Group ID to which the employee is assigned as of the check date. Use this field to group the employee for tax reporting purposes. When you use
, the results depend on the Tax Service Grouping Method that is set on the Configure Payroll Tax Export Settings screen.
Enter the 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.
Enter, or click to select, 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.
Click this button to recalculate all exempt wages, taxable wages, Federal, Social Security, Medicare, State, Local, FUTA and SUTA withholdings and accruals, based on the taxability of the pay types and deductions entered on the respective subtasks. If you have modified any of the exempt wages, taxable wages, Federal, Social Security, Medicare, State, Local, FUTA or SUTA withholding or accrual fields in this screen, these edits are lost if you recalculate.
This button is unavailable if you selected the Enable Union Functionality check box on the Configure Labor Settings screen. This button is also disabled if any of the following check boxes are selected on the Direct Charge Options subtask of the Configure Payroll Settings screen, even for a non-union employee:
Direct Charge Workers' Compensation
Direct Charge Employer Fringes
Direct Charge Union Fringe/Employer Contribution
These fields are calculated from the subtask fields and the Gross amount field.
The total of the federal 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.
The total of the federal exempt deductions is displayed here. The taxability of deductions is determined on the Manage Deductions screen. The deductions processed are detailed on the Deductions subtask of this screen.
The net of Gross less the Federal Exempt Pay Types and Federal Exempt Deductions is displayed.
This field displays the federal income taxes withheld.
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.
The total of the social security exempt deductions is displayed. The taxability of deductions is determined on the Manage Deductions screen. The deductions processed are detailed on the Deductions subtask of this screen.
The net of Gross less the Social Security Exempt Pay Types and Social Security Exempt Deductions is displayed.
This field displays the social security taxes withheld.
This field displays the employer expense accrued for social security.
The total of the Medicare 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.
The total of the Medicare exempt deductions is displayed. The taxability of deductions is determined on the Manage Deductions screen. The deductions processed are detailed on the Deductions subtask of this screen.
The net of Gross less the Medicare Exempt Pay Types and Medicare Exempt Deductions is displayed.
This numeric field displays the system-calculated amount for Medicare taxes withheld.
This field displays the employer expense accrued for Medicare.
Enter the Medicare taxable amount which exceeds the IRS threshold for additional Medicare taxation.
Enter the additional calculated Medicare tax withholding amount.
This group box contains information that is applicable to the employer's liability for federal unemployment taxes.
Enter 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.
Enter 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.
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.
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.
This field displays the system-calculated amount for FUTA Taxable wages. Costpoint calculates the taxable amount by subtracting the Exempt Wages displayed in this group box from the gross wages.
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.
This field displays the system-calculated amount for FUTA accrued expense. Costpoint derives this amount by multiplying the taxable wages by the percentage entered on the Manage Federal Taxes screen up to the taxable wage ceiling provided on the Manage Federal Taxes screen. You can edit this field.
This group box is comprised of a combination of editable and non-editable numeric fields and is applicable to the employer's liability for state unemployment taxes.
This field displays the two-character code for the SUTA state that defaults from the Manage Employee Taxes screen in Costpoint Employee. You can change the existing SUTA state or enter a new one in this field.
Enter 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.
Enter 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.
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.
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.
This field displays the system-calculated amount for SUTA taxable wages. Costpoint calculates the taxable amount by subtracting the Exempt Wages displayed in this group box from the gross wages.
This non-editable field displays the rate by which the taxable wages are multiplied, resulting in the accrued expense amount. This rate defaults from the Manage State Taxes screen for the indicated state.
This field displays the system-calculated amount for SUTA accrued expense. Costpoint calculates this amount by multiplying the taxable wages by the percentage entered in the Manage State Taxes screen up to the taxable wage ceiling provided in the Manage State Taxes screen. You can edit this field.
This group box summarizes the totals for each individual subtask in this application.
This field displays the regular, non-overtime labor hours.
This field displays the overtime hours.
This non-editable field displays the total hours that were charged from the timesheets that were processed. You can review how these hours were derived on the Pay Types subtask. If you need to enter or modify ( mode) the total hours for this record, enter the new value on the Pay Types subtask.
It is important to remember that changing the total hours in this table can cause an imbalance with the hours that were charged on the timesheet. To correct this imbalance, enter a "correcting timesheet" and run the Compute Payroll program to correct the total hours.
This field displays the total earnings amount of regular, non-overtime pay types.
This field displays the total earnings amount of overtime pay types.
This non-editable field displays the amount of gross pay that has been computed for the employee. If you need to enter or change the gross amount of the paycheck, enter the new value in the Earnings Amount field on the Pay Types subtask. This field is then updated.
It is important to remember that changing the gross pay in this table can cause an imbalance with the amount that was charged on the timesheet (a payroll variance). To correct this imbalance, enter a "correcting timesheet" and run the Compute Payroll program. It combines with the existing timesheet, which corrects the gross amount.
If you change the Gross Pay in this application, Costpoint automatically recomputes the Social Security, Medicare, Federal, State, Local, FUTA and SUTA withholding and accruals, when you click the Recalculate button.
This field displays the total FSA reimbursement amount for the payroll record. This total includes any Earnings Amount where the Pay Type matches the Dependent Care or Medical Care Reimbursement Pay Type on the Configure Benefit Settings screen. If the Reimbursement - Exclude from Gross Earnings check box is selected for the Pay Type on the Manage Pay Types screen, the earnings amount associated with this pay type is not included in the gross earnings amount, but rather in the total Reimbursements amount.
The total amount from the Earnings Amount column on the Pay Types subtask is displayed.
The total amount from the Earnings Amount column on the Worker's Comp subtask is displayed.
The total amount from the Amount column on the Contributions subtask is displayed.
The total amount from the Deduction Amount and Arrears Amount columns on the Deductions subtask is displayed.
The total amount for the Taxes Withholding Project Distribution subtask is displayed. This includes total income tax withholding at the federal, state, and local levels.
This non-editable field is automatically computed based on gross pay less the withholding and deductions amounts that are provided in this table.