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	Type	Length	Remarks
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	N	12	Dollars & cents; right justify/zero fill; no decimal
053 - 054	Employee base weeks	N	2	Range 00 - 14; right justify/zero fill
055 -“ 160	Filler	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

Line	CMD	Type_1	Operand_1	OPER	Type_2	Operand_2	Type_3	Operand_3	If GOTO	Else GOTO
10	LET	V	min_earns	MLT	$C	NJ_MIN_WAGE	N	20	100
100	LET	V	elpl_start_date	EQ	$S	PERIOD-START-DATE			110
110	LET	V	elpl_end_date	EQ	$S	PERIOD-START-DATE	A	+6D	120
120	LET	V	earnings-W1	ELPL	ET	GROSS			1000
1000	IF	V	earnings-W1	GE	V	min-earns			1010	2000
1010	LET	V	weeks-worked	EQ	N	1			2000
2000	LET	V	earnings-W2	ELPL	ET	GROSS			2100
2100	LET	V	earnings-W2	SUB	V	earnings-W2	V	earnings-W1	2200
2200	IF	V	earnings-W2	GE	V	min-earns			2300	9000
2300	LET	V	weeks-worked	ADD	N	1	V	weeks-worked	9000
9000	LET	PC	9400	EQNL	V	weeks-worked	N	0	99999
99999	EXIT

---

Notes#

Click to create a new notes page