Sample payroll
CSV column map
Fictional weekly payroll for Northline Electrical LLC and Riverside Substation Upgrade. Week ends Sunday, September 13, 2026. Safe for demos only; not a payroll or compliance record.
Download sample-payroll.csv · Load it in the app
| CSV columns | WH-347 / certified-payroll use |
|---|---|
| employee_name, employee_address, employee_id | Employee identification. The employee ID is a demo key, not an SSN. |
| withholding_exemptions | Withholding exemptions claimed, shown with the worker name. |
| classification | Work classification for the payroll classification column. Apprentice rows are marked RA. |
| monday_st–sunday_st / monday_ot–sunday_ot | Daily straight-time and overtime hours. |
| total_st_hours, total_ot_hours | Weekly straight-time and overtime totals (validated against daily columns). |
| regular_rate, overtime_rate | Rate of pay for ST and OT. Sample OT is 1.5× regular. |
| gross_st_wages, gross_ot_wages, gross_wages | Gross wages before deductions; overtime is separated for review. |
| fringe_cash_rate, fringe_cash_paid | Cash-in-lieu fringe rate and amount. v1 does not model a full benefit plan. |
| gross_plus_fringe | Gross wages plus cash fringe, for review. |
| fica_social_security, fica_medicare, federal_withholding, state_withholding, other_deductions | Itemized deductions. Illustrative amounts, not tax calculations. |
| total_deductions, net_wages_paid | Total deductions and net wages paid. |
| pay_period_start, pay_period_end, project_name, contractor_name | Cover information for the certified payroll header. |
| payment_method | Internal payroll detail; not a required WH-347 field. |
PayCert is a form assistant, not legal or tax advice. A contractor remains responsible for checking the applicable wage determination, classifications, rates, fringes, deductions, and Statement of Compliance before filing.