NJ Wage Hub certified payroll CSV checker

Check the Step 2 and Step 3 CSV files you filled in from NJDOL's template before you upload them to the New Jersey Wage Hub: column names, dates, hours, dollar formats, totals and net wages.

Runs entirely in your browser. Your payroll file is never uploaded to our servers.

1. Get NJDOL's template

Download the CSV templates from the Wage Hub (Contracts > Add/View Certified Payroll), or directly from NJDOL's CSV template zip. Fill in one row per employee.

2. Step 2 file: employees, hours and deductions

Drop Employee_Hours_Worked_Deductions_Step_2.csv or click to choose it

3. Step 3 file: fringe benefits (optional)

Drop Fringe_Benefits_Step_3.csv or click to choose it

Choose your Step 2 file to check it.

What the checker looks at

NJDOL's guide to its CSV templates sets an input format for every column and says the Wage Hub shows an error when a format is wrong (How to Use the New Jersey Wage Hub CSV Template, updated January 21, 2025, in the template zip). The checker tests those formats:

  • Column names exactly as in NJDOL's Step 2 and Step 3 templates, in the same order.
  • Job title: Apprentice, Foreman or Journeyman. Sex: M, F or X. Race: W, B, A, N, I or M. Ethnicity: H or N.
  • Dates as mm/dd/yyyy, each one on the right weekday column (Date_Sun is a Sunday, and so on), all within one week.
  • Hours such as 8.5, and weekly totals that equal the days added up.
  • Rates and amounts written like $95.50 (an amount without the $ is accepted with a warning); fringe benefit costs per hour in Step 3; a nine-digit USDOL benefit plan filing number.
  • Deductions_Total equal to FICA, state tax, federal tax and other deductions added up, and Net_Wages_Week equal to Gross_Week minus Deductions_Total, as NJDOL's guide defines it.

Notes on NJDOL's formats

The guide labels the hours format "HH.MM" but gives 8.5 as the example, which reads as eight and a half hours. Check how the Wage Hub shows fractional hours after your upload. The guide lists I as a race code without describing it. Fields may be left blank, and the Wage Hub lets you review and edit the data before you certify.

Want both files made from your payroll export every week, together with the WH-347 and underpayment checks? That is what the PrevailReady app does. New to the Wage Hub? Read the NJ Wage Hub guide.

PrevailReady is not affiliated with the New Jersey Department of Labor and Workforce Development.