| How to set up a taxable 401k loan deduction |
Resolution | Answer:
This can be set up as either a flat amount or a loan paid back in automatic installments.
Option I: Flat Amount
- Click Maintain and select Default Information, Employees.
- Go to the Employee Fields tab and scroll down to the first available line.
- Enter a name for the deduction, select the appropriate GL account and click [OK].
- Click Maintain and select Employees/Sales Reps.
- Select the employee (that you are setting this up for) from the drop down list and go to the Employee Fields tab.
- On the line for the new 401k Loan, clear the Use Defaults box and then enter the deduction amount (as a negative amount) in the Amount column.
- Click Save and then click Close.
- Because this is a deduction it is taxable by default, so no other changes needed.
Option II: Automatic Installments
- Click File, Payroll Formulas, User-Maintained.
- Enter Loan401K as the Formula ID.
- Enter Loan_401K 19 as the Name, where 12 is the current payroll year (2019).
- In the Effect on gross pay box, select Subtracts from gross.
- Leave Filing status as All.
- In the How do you classify this formula? box, select Deduction.
- In the Formula box, enter the following: Note: To create a new line in the formula, press CTRL+J
LIMIT=1000;
A=100;
B=-YTD(Loan_401K)+Loan_401K;
C=A-((A+B)-LIMIT);
D=IF((A+B) ANSWER=-D
Note: This calculation works for loans with any loan balance, whether they add up to the principle exactly or not (In our example, there will be ten payments of $100.00 to equal the loan of $1000.00).
-
- Click Save and then select Close.
- Click Maintain, Employees/Sales Reps.
- Select the employee (that you are setting this up for) from the drop down list and go to the Employee Fields tab.
- On the line for the new 401k Loan, uncheck the Use Defaults box, enter a check mark in the Calculated box, and then select from the drop down list Loan_401K in the Formula column.
- Click Save and then click Close.
DocLink: SES - Sage Expert Services for Sage 50—U.S. Edition Payroll Formula Configuration Service
[BCB:161:Chat 50 US:ECB] |
|