This page (revision-3) was last changed on 26-Nov-2021 10:22 by kparrott

This page was created on 26-Nov-2021 10:22 by rforbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
3 26-Nov-2021 10:22 3 KB kparrott to previous
2 26-Nov-2021 10:22 3 KB kparrott to previous | to last
1 26-Nov-2021 10:22 129 bytes rforbes to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 removed 3 lines
Quarterly Wage Reporting
[http://www.state.nj.us/treasury/revenue/njbgs/pdf/webemail.pdf]
!!Electronic Record Layout
At line 5 removed 2 lines
!!!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.
At line 8 removed 16 lines
!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
At line 25 removed 27 lines
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| | | | | | | | |