Payroll Data Import
Works with what you already have.
WageDocket ingests CSV and Excel exports from the payroll systems your office already uses — QuickBooks Payroll, ADP Run, Paychex Flex, Gusto, or a manual timesheet spreadsheet. You don't need to change how you do payroll.
The import engine handles real-world files: headers on row 3, classification values written as 'Elec Jman' or 'JOURNEYMAN ELECTRICIAN' or 'J-Elect', currency symbols in rate columns, totals rows that need to be ignored, and multi-sheet workbooks where only one sheet contains the actual payroll detail.
After upload, you map columns once per source format. WageDocket saves your mapping as a profile so the second import from the same source takes minutes, not an hour.
What’s included
- CSV and Excel (.xlsx) support
- Auto-detection of actual header row
- Column mapping saved as reusable source profiles
- Multi-sheet workbook support with explicit sheet selection
- Handles merged cells, totals rows, and irregular layouts
- Re-import and supersede workflow — safely replace a prior batch
Prevailing Wage Enforcement
Applied to every row, every week.
Prevailing wage compliance isn't just about paying the right rate — it's about tracking the right rate per classification per project per week, handling fringe benefits correctly (cash-in-lieu vs. bona fide plan contributions), and making sure the data in your report matches the wage determination on file for that job.
WageDocket applies wage determination context to every row in your workbook and flags rows where the rate is inconsistent with the classification. If a worker is listed as a Journeyman Electrician but paid below the applicable prevailing wage, that's a blocking validation error — not something that slips through into the filed report.
Fringe benefit tracking is handled separately from base rates. WageDocket tracks annualized fringe contribution amounts, cash-in-lieu per-hour figures, and flags missing benefit information before you generate.
What’s included
- Project-specific wage determination context
- Classification-to-rate validation on every row
- Fringe benefit tracking (cash-in-lieu and bona fide plan)
- Flags rate-classification mismatches before generation
- Supports workers in multiple classifications in the same week
- Handles foreman differentials and apprentice ratio tracking
WH-347 Federal Form Generation
Auto-filled from your validated workbook.
The WH-347 is the U.S. Department of Labor's standard certified payroll form for Davis-Bacon and Related Acts contracts. Filling it out by hand every week — transposing employee names, SSN last-four digits, classifications, hours, rates, deductions, and fringe benefit amounts — is exactly the kind of repetitive, error-prone work that WageDocket eliminates.
Once your workbook clears validation, WageDocket generates a correctly formatted WH-347 output from the validated data. The Statement of Compliance is included. Employee data is mapped to the correct fields. Multi-classification workers are handled properly — a worker who split the week between Journeyman and Foreman appears as two rows as the federal form requires.
Generated WH-347 files are stored with your workbook record. If a correction is required, the amended report preserves the original and marks the correction clearly.
What’s included
- WH-347 output from validated workbook data
- Statement of Compliance included
- Multi-classification worker rows handled correctly
- Last-four SSN populated per DOL requirements
- PDF-ready output
- Correction and amendment workflow with history preserved
NY State Portal Format
XSD-validated XML for external portal upload.
Starting January 2026, New York requires electronic certified payroll submission through the NYSDOL Certified Payroll system for covered Article 8 projects. The NY portal has its own data format, field requirements, and submission structure — separate from the federal WH-347.
WageDocket generates NY-specific XML files validated against the official NYDOL XSD. You validate the workbook once, download the XML, upload it through the NY portal, and record the external submission in WageDocket.
New York's late submission penalty is $100/day after a 14-day grace period. WageDocket's validation and generation workflow is built around getting workbooks to filing-ready status before the deadline — not scrambling after it.
What’s included
- NYDOL XSD-validated XML export
- Supports Article 8 covered projects
- Contractor registration number and prevailing wage case number fields
- NY-specific fringe and benefit field mapping
- No-work week support for reporting continuity
- Submission status tracking per project per week
Error Detection Before Submission
Blocking errors and actionable warnings — not silent pass-throughs.
The most expensive certified payroll mistake is one that gets filed. Deficiency notices, compliance investigations, and corrections to submitted reports cost time, credibility, and sometimes access to future public-work contracts.
WageDocket runs a validation pass on every workbook before generation is allowed. Blocking errors — wrong classification, missing required employee data, overtime miscalculation, unresolved classification ambiguities — must be resolved. Warnings — unusual hour totals, data that looks inconsistent but is technically valid — are surfaced for your review without blocking generation.
Every validation issue includes a plain-English explanation of what's wrong and what needs to be corrected. You don't get a generic error code — you get 'Employee D. Osei is mapped to Journeyman Electrician but the rate on this row ($28.00/hr) is below the applicable prevailing wage of $57.40/hr for this project.'
What’s included
- Blocking vs. warning distinction — you decide on warnings, not the system
- Wrong classification detection
- Overtime calculation verification
- Missing required field detection (FEIN, employee ID, classification, fringe)
- Duplicate employee name detection with manual resolution flow
- Inconsistent gross / rate / hours detection
- Incomplete Statement of Compliance prerequisites flagged
Full Submission History and Audit Trail
Every change tracked. Nothing overwritten.
Certified payroll is a compliance record. When a state auditor or prime contractor asks for documentation of what was filed, when, and whether any corrections were made, you need a clear answer — not a folder of old PDFs.
WageDocket maintains an append-only audit log for every meaningful event: who created a workbook, who imported data, what changed during editing, when validation was run, when a report was generated, and what correction was filed if the original had an error. Corrections preserve the original record — nothing is overwritten.
Artifact storage keeps every generated report — WH-347s, NYDOL XSD-validated XML exports, NJ Wage Hub CSV exports, import batches, and correction packages — associated with the workbook that produced them. Your compliance history is structured and retrievable, not spread across email threads and shared drives.
What’s included
- Append-only event log per workbook
- Who created, imported, edited, approved, and generated — timestamped
- Correction and amendment workflow preserves original record
- Generated artifact storage (WH-347, NY export, import batches)
- Submission status history per project per week
- Exportable audit records for compliance review