If you'd like a Flat Amount 401K Deduction to calculate on a Second or Higher sequenced check, you can either manually enter the amount using Enter Checks, (Tasks/Enter checks) or use the following formula and either place this formula on the Employee Deduction record, or create a second Deduction for 401K Flat amount deductions and place the formula on that Deduction Setup.
In either solution you would enter the amount of the Flat amount on the Employee Deduction record on the Amount column.
Create the following formula which would use the same 401K deduction for all employees. This formula is for employees who want a flat amount deduction.
- Go to Setup Employees and select Deducts.
- Click list and select 401K.
- Change the Calc Method to Formula.
- Enter the amount of the flat amount deduction in the Amount column.
- Place the formula below on the Formula column.
- Select the automatic check box.
- Calc Frequency is check.
401K FLAT AMT:
Lookup(Amount(PR Employee Deduct), Employee(PR Check), "401K")
If you choose to setup a new Deduction for Flat amount contributions do the following:
Setup/Deductions
- Enter your Deduction id, for this example we choose 401KFLAT.
- Enter your Description.
- Deduction type is Normal.
- Printed desc: 401KFL
- Select your Liability account.
- Calc Method is Formula, select the formula you created above.
Add this deduction to the Employee Deduct record:
- Go to Setup Employees and select Deducts.
- Click list and select 401KFLAT.
- Leave the Calc Method at Default.
- Enter the amount of the flat amount deduction in the Amount column.
- Select the automatic check box.
- Calc Frequency is Check.
If you choose to setup a second 401KFLAT deduction you'll want to create a formula to combine both deduction ID's on your W2 form.