Deduction Code Maintenance - Fields

 

Deduction Code Maintenance

Expand/Collapse all Show/Hide All

Deduction Code

Enter the deduction code representing the deduction type you want to add or maintain, or click the Lookup button to list all deduction codes.

Deduction code 01 must be used for Tips Reported. This is a permanent record and cannot be deleted. If your payroll requires tip reporting, see Allocating Tips.

Deduction code FB is a permanent record and cannot be deleted. For more information, see Fringe Benefits.

When an earnings code with a fringe earnings type is entered in Payroll Data Entry, an offsetting line with an FB deduction code is created automatically to deduct the line amount from the net check amount. The fringe benefit information will be printed in the box labeled "Benefits included in Box 1" on your W-2 forms.

 

Description

Type a description for the deduction (credit union, insurance, etc.).

 

Deduction Type

Select the deduction type to use for this deduction code.

Employer contributions are entered as deductions in this task and are entered in Payroll Data Entry using the normal deduction procedures. The contribution amount, however, is not subtracted from the employee's check. Instead, the amount is debited to the contribution expense account and credited to the deduction accrual account.

The amount deducted from either the pension plan or cafeteria plan can reduce the employee's taxable wages based on the tax information specified in this field.

After deductions have been posted for a deduction code, the code cannot be deleted until year-end processing has been completed.

 

Calculation Method

Select the calculation method to indicate how this deduction should be calculated.

When you print the Deduction Code Listing, the following codes will print on the listing to show which calculation method is selected for each deduction:

Calculation Method

Code

Fixed Amount

A

Percentage of Gross

P

Based on Reg Hrs Worked

R

Based on Total Hrs Worked

H

Percent of Net Wages

N
Equal to Earnings Code(s ) E
Based on Reg + OT Hrs S
Based on Paid Hrs I
Percentage of Total Hrs T
Based on Pay Rate Y

Percentage of Deduction

D

 

Standard Amount/Rate

If there is a standard deduction amount or rate, use the following table to determine the amount or rate to be entered based on your selection in the Calculation Method field.

Calculation Method

Standard Amount/Rate

Fixed Amount

Enter the fixed dollar amount.

Percentage of Gross

Enter the percentage of gross wages (1.000 = 1%, 1.500 = 1.5%, etc.).

Based on Reg Hrs Worked

Enter the amount to be multiplied by the number of regular hours.

Based on Total Hrs Worked

Enter the amount to be multiplied by the total number of hours worked.

Percent of Net Wages

Enter the percentage of net wages (1.000 = 1%, 1.500 = 1.5%, etc.).

Equal to Earnings Code(s ) This field is not available if this calculation method was selected.
Based on Reg + OT Hrs Enter the amount to be multiplied by the total of regular and overtime hours.
Based on Paid Hrs Enter the amount to be multiplied by the product of the total hours worked and the pay-rate multiplier.
Percentage of Total Hrs Enter the percentage rate to be multiplied by the total hours (1.000 = 1%, 1.500 = 1.5%, etc.).
Based on Pay Rate Enter the amount to be multiplied by the selected pay rate.

Percentage of Deduction

Enter the percentage rate to be multiplied by the deduction amount (1.000 = 1%, 1.500 = 1.5%, etc.).

If there is no standard deduction, enter 0. The amount (or rate) entered establishes the default deduction amount displayed when this deduction code is entered in an employee record or in Payroll Data Entry. The default amount can be changed at that time. This field is useful if all (or the majority) of employees have the same amount deducted for this deduction type (for example, insurance).

 

Standard Limit

Type a standard deduction limit, in terms of the dollar amount, for all employee records using this deduction code. The limit entered establishes the default deduction goal displayed when this deduction is entered in an employee record. Entering an amount of 0.00 assumes no dollar limit.

 

Reset Balance at Year End

Select this check box to retain employee deduction records, regardless of whether or not the limit is reached for the deduction code. The amount in the Ded. Balance field is reset to the amount in the Ded. Goal field in the Voluntary Deduction Maintenance window accessed in Employee Maintenance. Clear this check box if you do no t want to reset the deduction balance at year end. This field is available only for pension plan deduction typ es that have a limit entered in the Standard Limit field.

 

W2 - Box 12 Code

Type the Box 12 code that applies to this deduction. Elective deferred compensation and other reported contributions must be printed in Box 12 on W-2 forms by using the one-character code or two-character code defined by the IRS for this deduction. For more information about current Box 12 codes, refer to the W-2 form instructions provided by the IRS.

 

Deduction Code to Use

Enter the deduction code to use for the Percentage of Deduction calculation method, or click the Lookup button to list all deduction codes. This field is available only if Percentage of Deduction is selected in the Calculation Method field.

Note You cannot select a deduction code that uses the Percentage of Net Wages calculation method.

 

Pay Rate to Use

Select which pay rate to use for this deduction code. This field is available only if Based on Pay Rate is selected at the Calculation Method field.

 

Equal to Earnings Code

Enter up to three earnings codes for this deduction code, or click the Lookup button to list all earnings codes. These fields are available only if Equal to Earnings Code(s) is selected in the Calculation Method field.

 

Frequency of Deduction

Select the check box assigned to the pay period(s) of each month in which this deduction is to be applied automatically. For example, if a deduction is taken automatically every pay period, select the Every Pay Period check box. If the deduction is taken only when the deduction period specified in Payroll Data Entry is 1 or 3, select the Pay Period 1 and Pay Period 3 check boxes. If the deduction is always entered manually during Payroll Data Entry, clear all check boxes.

The pay period(s) selected are matched with the period specified in Payroll Data Entry, and deduction entries are automatically generated for employees with this deduction code. A deduction can be entered manually in Payroll Data Entry for periods not selected for automatic deduction.

 

Automatically Apply Deduction to Earnings Code

Enter the earnings code that will be increased by the amount equal to the deduction amount when this deduction is applied. Click the Lookup button to list all earnings codes. The earnings code must have Fixed Amount selected in the Method of Entry field in Earnings Code Maintenance. Leave this field blank if you do not want any automatic earnings applied.

To apply a deduction amount to an earnings code, the deduction code must be set up as an automatic deduction in the employee record if you use the Automatic Payment Entry feature. If you enter payroll data manually, the Auto Ded check box must be selected inPayroll Data Entry.

This field is not available if Equal to Earnings Code(s) is selected in the Calculation Method field.

Expand/Collapse item Example

If you pay a cash advance for meals of $15.00 per pay period, you can set up a matching earnings code and deduction code for meal allowances. You can then enter the earnings code designated as meal allowance in this field. Each time an employee has this deduction taken for meals, there will be an automatic addition of an equal amount in the form of earnings. This enables you to have applicable taxes deducted from the earnings amount and reflected on the employee paycheck.

 

Deduction Accrual Account

Enter the general ledger account number for posting amounts for this deduction code, or click the Lookup button to list all general ledger accounts.

If the account number is longer than the field, use the left and right arrow keys to view the entire account number.

Accounts can be created in this field if the appropriate settings are defined in the Auto Create when all Segments are Valid field in General Ledger Options.

 

Contribution Expense Account

Enter the general ledger contribution expense account number from the chart of accounts, or click the Lookup button to list all general ledger account numbers. This field is available only if Employer Contribution is selected in the Deduction Type field.

If the account number is longer than the field, use the left and right arrow keys to view the entire account number.

Accounts can be created in this field if the appropriate settings are defined in the Auto Create when all Segments are Valid field in General Ledger Options.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks