CertifiedHours
Your payroll system

Certified payroll from Square Payroll: the pay run export, multiple rates, and what to add

Square Payroll downloads reports per pay run and pays a team member at several rates when timecards carry jobs. It has no WH-347. Here is what to export, how the columns land on the form, and where the classification and fringe come from.

Checked against the sources below October 16, 2026. Menus move; if a step is off, tell us from the Help menu and it is fixed the same week.

The short answer

Square Payroll does not produce a WH-347. Each pay run's reports download from Staff, then Payroll, then Run payroll, then Payroll history, View all, Download reports, with hours, rates, gross, taxes and deductions per team member; when timecards carry jobs, a person's hours come into payroll at each job's rate. Import the pay run report, or the Shifts timecard export for hours by day, and add the classification and the fringe when you review.

What Square Payroll gives you

  • Downloadable reports per pay run (Paycheck Details, Employee Totals) with wages and taxes per team member, from a computer.
  • Multiple pay rates per team member through jobs on Square Shifts timecards; hours come into payroll at each job's rate.
  • A timecard export from Shifts (Export shifts, a CSV) with hours by shift, which is closer to what the form wants than the pay run summary.

What the WH-347 still needs

  • Determination-worded classifications, the wage determination number, and the fringe columns.
  • Hours by day in the pay run reports; the timecard export has them.
  • The Statement of Compliance, apprentices, payroll numbering.

The export: Pay run reports (or the Shifts timecard export)

  1. Staff, then Payroll, then Run payroll. Under Payroll history, View all, then Download reports. Pick the report (Paycheck Details has the per-person figures) and the pay period.
  2. For hours by day and job: Shifts, then Time tracking, then Timecards. Filter the week, pick the team member, then Export, then Export shifts; repeat for each person.
  3. Import whichever has what you need; the timecard export carries the days, the pay run report carries the deductions. Column names vary by report; the import's mapping step lets you point each at the right field.

How each column lands on the form

The import matches columns by meaning, so the exact header can vary. It asks about anything it is unsure of before it fills the grid.

In Square PayrollOn the certified payroll
Team memberMatched to the crew by name once you point the column at Full name in the mapping step.
Job titleMatched to the job's trades.
Regular hours, Overtime hoursStraight time and overtime.
Hourly rateColumn 6A.
Gross payCompared with rate × hours: equal sets the cash fringe to 0; a plausible excess becomes the cash fringe per hour; a gross far past that is kept as 7B.
Federal income tax, Social Security, MedicareColumn 8.

Rates and classifications

Give the crew one job per classification in Square, named as the determination names it, and have them clock into the right job. Timecards then carry hours by job and the payroll pays each at its rate.

Fringe

Cash in lieu of fringe is a separate pay rate or an additional pay item per hour, which lifts the gross above rate × hours; the import sets the difference per hour as the cash fringe. Plan contributions are recorded against the plan in CertifiedHours.

Every week

  1. Run payroll in Square Payroll as usual, with the workweek ending on the day your contract's payroll week ends.
  2. Export the pay run report for that pay period as a CSV (or as Excel, saved as CSV).
  3. Open the week in CertifiedHours and choose Import hours from CSV. The columns are matched by meaning; check the two or three it asks about.
  4. Read the grid once against the export: trades, hours, rates, the fringe line. Fix anything the checks flag.
  5. File. The WH-347 and the signed Statement of Compliance print, and the prime gets the PDF by email if the job is set to send.

Questions people ask

Does Square Payroll do certified payroll?
No. It downloads pay run reports and exports timecards as CSV; the WH-347, the determination check and the statement are built elsewhere.
One person has two jobs in Square. How do their rows import?
Two rows that both carry hours stay two lines for the same person, with the same entry number, one per job title. The import merges rows for one name only when at most one of them carries hours (a deductions-only row). Check the trade on each line.

Sources

  1. Square Support: Run payroll for W-2 employees (multiple rates)
  2. Square Support: View payroll reports and tax forms (Download reports)
  3. Square Support: View team member timecard and scheduling reports (Export shifts)

Keep Square Payroll. Add the form.

Export the week, import it, read the checks, file. The WH-347 and the signed statement print; the prime gets the PDF. Free for one payroll a month, $19 for unlimited.

Start free