Quarterly Wage Reporting http://www.state.nj.us/treasury/revenue/njbgs/pdf/webemail.pdf

Electronic Record Layout#

Processing Information#

A new UDF (NJ_MAG_AUTH) is added to IDGV. RPYEU automatically generates the new UDF when it does not exist, so the User does not need to insert this. The user then needs to enter the NJ Mag Authorization Number on IDGV and run RPYEU. When IDGV UDF (NJ_MAG_AUTH) is not set up on State SUI Registration, it uses IDGV State Registration.

Employer "M" Record Layout#

Location Description TypeLengthRemarks
001 -“ 001 Record ID A/N 1 Always "M"
002 -“ 013 FEIN N 12 Federal employer identification number
014 - 015 Filler A/N 2 Spaces
016 -“ 051 Employer Name A/N 36 From tape authorization letter
052 - 086 Street Address A/N 35
087 -“ 106 City A/N 20
107 -“ 111 State A/N 5
112 -“ 120 Zip Code A/N 9 Left justify, spaces
121 -“ 122 Quarter & year or report N 2 Qtr #1, 2, 3, 4; last digit of year
123 -“ 128 Number of employees reported N 6 Right justify, zero fill; must equal the number of employee "B" record this employer
129 -“ 142 Total wages paid this quarter N 14 Dollars & cents; right justify/zero fill;no decimal
143 -“ 151 FEIN N 9 Federal employer identification number
152 -“ 155 Magnetic authorization number N 4 From tape authorization letter
156 - 160 Filler A/N 5 Spaces

Employee "B" Record Layout

001 -“ 001 Record ID A/N 1 Always "B"
002 -“ 010 Employee SSN N 9
011 -“ 040 Employee name A/N 30 Last name, first, mi; no punctuation
041 -“ 052 Employee wages paid this quarter N12 Dollars & cents; right justify/zero fill; no decimal
053 - 054 Employee base weeks N 2 Range 00 - 14; right justify/zero fill
055 -“ 160Filler A/N 106 Spaces

The number of base weeks is determined by the application using the IDFDV Form specified and at SEQ 7285 W2-SUI-WK-WRK and 7290 W2-SUI-WEEKS-WRK if both are left blank the number of weeks is determined by the application by adding up the number of weeks paid on the pay headers IPPH.

If the company makes use of part timers you may not want to report the IPPH weeks worked but review the NJ Dept of Labor to the definition of base weeks as "A base week is any calendar week (Sunday through Saturday) in the reporting quarter during which the employee earned in employment remuneration equal to or more than 20 times the state hourly minimum wage ($8.25/hr in 01 Jan 2014)." This value can be calculated with a payroll usercalc IMUC.

Sample usercalc that can be added to the pay point IPPP

LineCMDType_1Operand_1OPERType_2Operand_2Type_3Operand_3If GOTOElse GOTO
10LETVmin_earnsMLT$CNJ_MIN_WAGEN20100
100LETVelpl_start_dateEQ$SPERIOD-START-DATE 110
110LETVelpl_end_dateEQ$SPERIOD-START-DATEA+6D120
120LETVearnings-W1ELPLETGROSS 1000
1000IFVearnings-W1GEVmin-earns 10102000
1010LETVweeks-workedEQN1 2000
2000LETVearnings-W2ELPLETGROSS 2100
2100LETVearnings-W2SUBVearnings-W2Vearnings-W12200
2200IFVearnings-W2GEVmin-earns 23009000
2300LETVweeks-workedADDN1Vweeks-worked9000
9000LETPC9400EQNLVweeks-workedN099999
99999EXIT

Notes#

Click to create a new notes page