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 added 19 lines
Quarterly Wage Reporting
[http://www.state.nj.us/treasury/revenue/njbgs/pdf/webemail.pdf]
!!Electronic Record Layout
!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 21 added 7 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
At line 29 added one line
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].
At line 31 added 17 lines
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| | | | | | | | |