ARCHIVED New Jersey State Unemployment Insurance (SUI) formula adjustments for 2020

First, you will need to copy the TAXTABLE.DAT file attached to this article into the SAGE 50 DATAPATH. Next, a separate field will need to be created to compute the Family Leave Insurance (FLI) amount that will be added to the existing State Unemployment Field.

Step 1: Copying the TAXTABLE.DAT file to the DATAPATH

Note: Upgrade to the latest tax release. The taxtable.dat at the bottom of this KB is old and is missing the 2021 formulas. Skip to step 2 if you already have the latest tax tables installed

1. Locate the Sage 50 US DATAPATH by following the steps outlined in Article ID 10165: DocLink: How to find data path and program path.
2. Download the TAXTABLE.DAT file attached to this article and save it to your local machine.
3. Copy & Paste the TAXTABLE.DAT file into the Sage 50 US DATAPATH located in step 1.
4. When asked to replace the existing TAXTABLE.DAT file select yes to copy and replace.

Step 2: All Employee Defaults Setup

1. In the product, from the Maintain menu, select Payroll, Employee Defaults.
2. The Employee Defaults window appears. Click the Employee Fields tab.
3. In the next available/blank field, place your cursor in the Field Name field and type:
   ST_FLI (Note: The field name is case sensitive and must typed exactly in order for the correct computation to take place).
4. Place a mark in the box under the Memo column. The amount computed will be recorded on the General Ledger account already defined to track employee contributions to State Unemployment Insurance/SUI.
5. Place a mark in the checkbox under the Calc column.
6. Under the Formula column, place your cursor in the field, click the magnifying glass and select NJFLI from the dropdown list or type **FLI in the Formula field.
7. Click the button under the Adjust column.
8. The Calculate Adjusted Gross window appears. On the left, place a mark in the checkbox under the Use column in the Gross field.
9. Click OK.
10. You are returned to the Employee Defaults window. Click OK.

Step 3: Entering any catch up contributions

1. Determine the amount of catch up contribution needed to satisfy the tax liability for SUI EE and NJFLI. The maximum amount of SUI EE for 2020 is $150.03 and $215.84 for NJFLI. To determine catch up amounts:
   1. NJSUI EE - if the employee has over $35, 300 in gross wages run the yearly earnings report to determine the amount of SUI EE contributed. Subtrack the current contrubitions from the maximum of 150.03 and enter the difference manually as a negative number on the coming payroll check in the NJSUI EE field. If the employee has less than $35,300 in gross wages for the year - multiply the amount of gross wages over $34,400 (prior year limit) by the SUI EE rate of .425% and enter the difference manually as a negative number on the comeing payroll check in the NJSUI EE field.
   2. NJFLI - if the employee has over $134,900 in gross wages run the yearly eanings report to determine the number of the amount of SUI EE contributed. Subtract the current contributions from the maximum of 215.84 and enter the difference manually as a negative number on the coming payroll check in the NJFLI EE field. If the employee has less than $134,900 in gross wages for the year - multiply the amount of gross wages over $34,400 (prior year limit) by the FLI rate of .16% and enter the difference manually as a negative number on the NJFLI field on the coming payroll check.

Need further assistance? Join Sage Q&A Live to ask any additional questions you may have and get them answered right away from a Sage Expert! Join directly at sage.com/resources, select United States and then Sage 50 US as a product scroll down and select 'View Current Topics'.