Costpoint Online Help

Details Tab

Use this tab to add more details about the deduction such as Deduction Type and Computation Method.

Settings

The Employee Government Mandated Orders functionality has been de-supported starting Costpoint 7.0. You must update the Deduction Types currently assigned to your garnishment deductions. The valid Deduction Types for the Employee Government Mandated Orders functionality were:

  • Garnishment of Wages
  • Child Support Payments
  • Tax Levy
These three Deduction Types are not valid for use with the Costpoint. You must query each of the existing garnishment deductions and change the Deduction Type to one of the new garnishment Deduction Types:
  • Student Loan Garnishment
  • Creditor Debt Garnishment
  • Federal Admin Garnishment
  • Child Medical Support
  • Child Support Garnishment
  • Federal Tax Levy
  • State Tax Levy
Field Description
Deduction Type

Enter, or click to select, the deduction type that corresponds to the deduction. The deduction type is used when computing W-2s to determine the appropriate field of the W-2 in which to include the deduction. This is defined each year in accordance with IRS requirements. Valid options are as follows:

401(k) Deferred Compensation* Employer Contribution to a HSA
401(k) linked ESA Employer Medical Savings Acct
403(b) Deferred Compensation* Excess Life Insurance
403(b) linked ESA Federal Admin Wage Garnishment
408(k)(6) Deferred Compen.* Federal Tax Levy
409A Deferred Compensation Golden Parachute
457 Deferred Compensation* Health Care Benefit
457(b) linked ESA Life Insurance Benefit
501(c)(18)(d) Deferred Compen.* Massachusetts Paid Fam&Med Lv
529 Savings Plan Medical FSA
Admin Fee Garnishments Misc. Employee Loan
Admin. Fee Court Orders Miscellaneous
Arrears Non Qualified Deferred Compen.
Bankruptcy Deduction Non-Taxable Moving Expenses
Benefit Package Paid Leave Oregon
Cafeteria Plan Personal Accident Insurance
Child Medical Support Qualified Profit Sharing
Child/Spouse Support Garnishment Retirement Plan (Non-deferred)
Colorado FAMLI Roth 401(k) Deferred Comp.
Creditor Debt Garnishment Roth 403(b) Deferred Comp.
Dental Plan Benefit Roth 457(b) Deferred Comp
Dependent Care Benefit State Disability Insurance
Dependent Care FSA State Tax Levy
Disability Plan Benefit Student Loan Garnishment
Emergency Savings Account Transportation Benefit
Empl HSA Contr (Non Caf Plan) U.S. Savings Bond
Employee Advance UI/Hlth Care/Workforce Dev
Employee Deferred Comp. Loan Union Deduction
Employee Group-Term Life Ins Union Dues
Empl HSA Contr (Caf Plan) Vision Plan Benefit
Employee Stock Ownership Plan Washington Cares Fund
Employee Stock Purchase Plan Washington Paid Fam and Med Lv
Note: In Costpoint Deferred Compensation Admin, set up deferred compensation plan information on the Manage Deferred Compensation Plans screen and then link the Deduction code (that has a deferred compensation Deduction Type on this screen) to the deferred compensation plan on the Manage Deferred Compensation Deductions screen.
Employer-Sponsored Health Coverage

Select this checkbox if this deduction will be tracked under the employer-sponsored health plan.

Deduction

Select this checkbox to indicate that the code is to be used to withhold amounts from employees' paychecks. You can use a deduction code as a deduction, contribution, or both.

If you do not select this checkbox, which indicates that you are setting up a code as a contribution only, all fields related to deductions are disabled. Clear this checkbox to clear all values if a deduction code has been established, but is no longer valid. You can also stop a deduction by setting the Through date to the date this deduction becomes invalid.

Computation Method

Enter, or click to select, how the deduction is computed. Valid options are:

  • ADDGRS: Add to Gross. Use this method for deductions such as excess life insurance, relocation, or car allowance, where the deduction amount is added to gross salary. The amount added to gross is strictly for adding the amount to gross salary in the Earnings Table. This method adds this amount to the Employee Earnings Pay Type table as well as the Employee Earnings Workers' Comp table. You must associate a Pay Type code and a Workers' Comp code with this deduction method.

    This method creates a payroll variance when you post the Payroll Journal for the total of all ADDGRS deductions. After printing checks and posting the Payroll Journal, make a journal entry debiting the payroll variance account and crediting the accrued salaries account. If you have not set up a Payroll Variance Account on the Configure Payroll Settings screen, no journal entry is needed, since the Accrued Salaries account is charged for both sides of the Payroll Journal entry.

    In the Pay Type field, indicate the pay type to be used for the amount added to gross when this method is chosen.

    In the Workers' Comp field, indicate the Workers' Comp Code.

Note: If you use the ADDGRS method in this deduction table, you must also use the same method in the Manage Employee Deductions screen when assigning this deduction code to an employee.
  • FIXAMT: Fixed Amount. Use this method when a particular dollar amount must be deducted each pay period (for example, an employee loan payback).
  • GHRSPD: Gross Hours Paid. Use this method when the deduction is based on total hours paid for the period.
  • GRSHRF: Gross Hours. Use this method when the deduction amount is based on total hours worked for the period. The deduction amount is calculated by adding all hours for the payroll period multiplied by the deduction amount.
  • GRSHRP: Gross Hours: Use this method when the deduction amount is based on total hours worked for the period. The deduction amount is calculated by adding all hours for the payroll period multiplied by the deduction percent.
  • NO DED: No Deduction: This method turns off a deduction. Use it when you need to temporarily disable a deduction for all employees using it.
  • PCTANN: Percent of Annual Salary. This method multiplies the Rate % by the employee's annual salary amount to come up with the deduction amount.
  • PCTCOD: Percent of Court Order. This method is used only when the Deduction Type is Admin. Fee Court Orders. This method takes the percentage entered to use for administrative fees.
  • PCTDPI: Percent of Disposable Income. This method is used for garnishments or tax levies to determine the portion of wages that is allocated to the courts.
  • PCTGRS: Percent of Gross Wages. This method multiplies the Rate % by the total wages for the pay period. The total wages will not exclude any deduction types.
  • PCTNET: Percent of Net. Use this method for state tax levies where the state requires that the levy amount be based on a percentage of the employee’s net pay.
  • PCTREG: Percent of Regular Wages. This method multiplies the Rate % by the total of all non-overtime pay type wages for the pay period.
  • PCTGRQ: Percent of Gross Wages excluding any 457 plan deductions and non-qualified deferred compensation (NQDC) deductions. This method multiplies the Rate % by the total wages for the pay period.
  • REGHRF: Regular Hours. Use this method when the deduction amount is based on all hours not designated as overtime hours. The application calculates the deduction amount by adding all non-overtime hours for the payroll period and multiplying that figure by the deduction amount.
  • REGHRP: Regular Hours. Use this method when the deduction amount is based on all hours not designated as overtime hours. The application calculates the deduction amount by adding all non-overtime hours for the payroll period and multiplying that figure by the deduction percent.
Rate %

Enter the rate, up to four decimal places, that is used to compute the deduction. This is a required field if you have chosen any Method other than FIXAMT (Fixed Amount), GRSHRP (Gross Hours), NO DED (No Deduction), or REGHRF (Regular Hours). This number is multiplied by the wages to compute the deduction amount.

Amount

If you chose the FIXAMT (Fixed Amount) Method, enter the amount that must be deducted from each paycheck. If you chose the GRSHRF (Gross Hours) or REGHRF (Regular Hours) Method, enter the amount that is multiplied by the hours worked. This is a required field when you select FIXAMT, GRSHRF, or REGHRF.

Modify Code

Enter, or click to select, a modify code that you have already set up on the Manage Deduction Modify Codes screen. Each modify code contains a grouping of pay types, and information on whether each pay type is added or subtracted. You typically set up modify codes for each deduction in which the formula for eligible wages differs.

The purpose of a modify code is to add or subtract amounts, identified by pay type, to or from the basis for a deduction (examples of a deduction basis include gross pay and regular wages). For example, some companies may include overtime, excess life, and uniform allowance in 401(k) eligible wages, and some companies may not.

This code applies only to the GRSHRF, GRSHRP, REGHRF, REGHRP, PCTREG, and PCTGRS methods.

Priority

When the Enable Deduction Priority Functionality checkbox is selected on the Configure Payroll Settings screen, enter a value between 1 and 99. This establishes priority when deductions are taken on a company-wide basis when computing payroll. 1 represents the highest priority and 99 represents the lowest priority. This can be changed on an employee basis on the Manage Employee Deductions screen.

Ceiling Method

If there is a calendar year ceiling on the amount that can be withheld, use this drop-down list to select the method that is used to determine the ceiling amount. The valid values are:

  • No Ceiling: If you select this option, deductions continue without limits.
  • Payroll Year: If you select this option, deductions start over at the beginning of the payroll year.
  • One-Time: If you select this option, the balance of the ceiling changes during the Close Payroll Year process. This option is usually used for garnishments or loan repayments. If you select this ceiling method, the Close Payroll Year program reduces the deduction limit by the year-to-date deduction total and enters the balance (the "unpaid balance") as the next year's deduction limit in the Employee Deductions table's Limit field. When the deduction limit is reduced to zero, the method is changed to NO DED in the Manage Employee Deductions screen.
  • Coverage Dates: You can use this option for FSA and HSA deductions. You should only use this new method for HSAs if you enter plan year information on the Manage HSA Plan Year screen and enter HSA elections on the Manage HSA Elections screen. Costpoint will use the information that you enter in the Manage HSA Plan Year screen and Manage HSA Elections screen to determine the plan year’s start and end dates. These dates will be used for the ceiling dates.
Ceiling Amount

If there is a calendar year ceiling on the amount that can be withheld, enter that amount in this numeric field. This is typical for 401(k) type deductions, where there is a cap on the amount that is eligible each year.

Eligible for Arrears

Select this checkbox if this deduction is eligible for arrears. This group box is unavailable if you did not select the Deduction checkbox on this screen.

Arrears Deduction

Enter, or click to select, an arrears deduction code that applies.

Pay Type

Enter, or click to select, the pay type code that must be used for the additional amount that is added to gross. This field is available only if the Method is ADDGRS (Add to Gross) and is validated when the screen is saved. This must be a cost-only pay type.

Workers' Comp

Enter, or click to select, the workers' compensation code that must be used for the additional amount that is added to gross. This field is available only if the Method is ADDGRS (Add to Gross) and is validated when the screen is saved.

Union Rate
Enter the amount for the union rate that must be deducted from each paycheck, if applicable.
Note: You can view this field if:
  • The Enable Union Functionality checkbox is selected on the Configure Labor Settings screen.
  • The deduction type is UDED.
Start Date

Leave this field blank to indicate that the deduction starts immediately. If the deduction must not begin until a particular pay period, enter, or click to select, the start date of that pay period.

Through Date

Leave this field blank to indicate that the deduction continues indefinitely. If the deduction must stop after a particular pay period, enter, or click to select, that pay period's end date.

Contribution

Select this checkbox to indicate that the code is to be used to accrue contributions as employer expense. You can use a deduction code as a deduction, contribution, or both.

If you do not select this checkbox, indicating a code is being set up as a deduction only, all fields related to contributions are disabled. Clear this checkbox to clear all values if a deduction code has been established, but is no longer valid. You can also stop a contribution by setting the Through date to the date this contribution became invalid.

This group box contains parameters that apply only to contribution codes that are flagged as contributions per the Contribution checkbox. To establish matching percentages for the selected Computation Method, use the Contribution Matching subtask.

Computation Method

From the drop-down list, select the method used to compute the contribution. Valid options are:

  • FIXAMT: Fixed Amount. Use this method when a particular dollar amount is contributed each pay period.
  • GRSHRF: Gross Hours. Use this method when the contribution amount is based on total hours worked for the period. The contribution amount is calculated by adding all hours for the payroll period multiplied by the contribution amount.
  • GRSHRP: Gross Hours. Use this method when the contribution amount is based on total hours worked for the period. The contribution amount is calculated by adding all hours for the payroll period multiplied by the contribution percent.
  • NO DED: No Deduction. This method "turns off" a contribution. Use it when you need to temporarily disable a contribution for all employees using it.
  • PCTANN: Percent of Annual Salary. This method multiplies the Rate % by the employee's annual salary amount to come up with the contribution amount.
  • PCTDED: Percent of Deduction. This method multiplies the Rate % by the amount of the deduction to derive the contribution amount.
  • PCTGRS: Percent of Gross Wages. This method multiplies the Rate % by the total wages for the pay period. The total wages will not exclude any deduction types.
  • PCTREG: Percent of Regular Wages. This method multiplies the Rate % by the total of all non-overtime pay type wages for the pay period.
  • PCTGRQ: Percent of Gross Wages excluding any 457 plan deductions and non-qualified deferred compensation (NQDC) deductions. This method multiplies the Rate % by the total wages for the pay period.
  • REGHRF: Regular Hours. Use this method when the contribution amount is based on all hours not designated as overtime hours. The contribution amount is calculated by adding all non-overtime hours for the payroll period and multiplying that figure by the contribution amount.
  • REGHRP: Regular Hours. Use this method when the contribution amount is based on all hours not designated as overtime hours. The contribution amount is calculated by adding all non-overtime hours for the payroll period and multiplying that figure by the contribution percent.
Rate %

Enter the rate, a maximum of four decimal places, that must be used to compute the contribution. Costpoint multiplies this number by the wages to compute the contribution amount. This is a required field if you have chosen any method other than FIXAMT (Fixed Amount) or NO DED (No Deduction).

If you have set up a PCTDED (Percent of Deduction) method with a Contribution Rate Schedule, you must set this field to 0.0000.

Amount

Enter the amount that must be contributed for each paycheck. This is a required field when you select the FIXAMT (Fixed Amount) method.

Base on Additional Deductions

Select this checkbox to include additional deductions in the contribution calculation. Use this to calculate contributions based on multiple deductions for a deferred compensation. For example, you want the 401(k) and Safe Harbor 401(k) deduction codes combined to determine the 401(k) contribution amount. To set this up, select the Base on Additional Deductions checkbox and add a second deduction (Safe Harbor 401(k)) in the Additional Deductions for Contribution Calculation table.

If you select this checkbox, you need to specify at least one row in the Additional Deductions for Contribution Calculation subtask.

Note: You can view this checkbox on if the contribution’s Computation Method is PCTDED (Percent of Deduction).
Modify Code

Enter, or click to select, a modify code that you have already set up in the Manage Deduction Modify Codes screen. Each modify code consists of a grouping of pay types, and information as to whether each pay type must be added or subtracted. You typically set up modify codes for each pension plan for which the formula for eligible wages differs.

The purpose of a modify code is to add or subtract amounts, identified by pay type, to or from the basis for a contribution (examples of a contribution basis include "gross pay" and "regular wages"). For example, some companies may include overtime, excess life, and uniform allowance in 401(k) eligible wages and some companies may not.

This code only applies to PCTREG, PCTGRS, GRSHRF, GRSHRP, REGHRF, REGHRP, and PCTANN methods. When any of these methods is selected and a modify code is assigned, the modify code-pay type amount is withheld in the basis for the contribution amount (where the pay type is set to be subtracted).

Ceiling Amount

If there is a calendar year ceiling on the amount that can be accrued as a contribution, enter that amount. This is typical for 401(k) type contributions, where there is a cap on the amount that is eligible each year.

HSA Deduction

For taxable HSA contributions, enter, or click to select, the corresponding deduction code that will be used as a taxable deduction for the HSA employer contribution. You must set up an HSA deduction with a computation method of ADDGRS.

Start Date

Leave this field blank to indicate that the contribution must start immediately. If the contribution must not begin until a particular pay period, enter, or click to select, the start date of that pay period.

Through Date

Leave this field blank to indicate that the contribution must continue indefinitely. If the contribution must stop after a particular pay period, enter, or click to select, that pay period's end date.

Include on Employee Paystub
Select this checkbox to include this contribution on the printed employee paystubs and payment advices. To use this feature, you must select the following:
  • Select the Print Contributions on Check Stub checkbox on the Configure Paycheck Settings screen for paychecks.
  • Select the Print Contributions on Advices checkbox on the Configure Direct Deposit Settings screen for payment advices.

Payroll Tax Interface

Field Description
Tax Type

From the drop-down list, select the tax type code for the record. Valid options are:

  • City Income Tax
  • City Income Tax (Residence only)
  • County Income Tax
  • School District Income Tax
  • Other Income Tax

Costpoint uses the value entered here to report the locality type when creating the CTS tax files. This value is required if a CTS Local Code is specified.

State

Enter, or click to select, the state where the local tax applies.

Tax Service Code

Enter the tax code which identifies the deduction in your payroll tax service system. This value is included when export the deduction amount to the Payroll Tax Service provider. You must enter a value in this field if you use the deduction to track a state or local tax.