Skip to content
← All posts
PAYROLLJuly 7, 20267 min read

How to Export Your Crew's Hours to Payroll

Every pay period ends the same way: the week is over and now you have to get the hours into payroll. Here is the the steps that let you stop typing hours in by hand. Finish the week, open Reports, pick the export for your system, download the file, and import it. Overtime and breaks are already calculated, so the totals are already correct.


Every pay period ends the same way. The week is over, the hours are somewhere, and now you have to get them into whatever runs your payroll. If you have been collecting times from texts and paper and typing them in by hand, this is the guide that ends that. Clox tracks your team's hours all week and hands you a file your payroll system can read, so you export instead of typing them in again. This is the short version of how that works, no matter which system you use.

There is one set of steps, and it is short. Finish the week, open Reports, pick the export that matches your payroll system, download the file, and import it. QuickBooks Online users can skip the file entirely with a live sync. That is all of it. The rest of this post just names which file each system takes and points you to the full guide for yours.


The steps, once, start to finish

Here are the steps you run each pay period. Only two of them happen at your desk.

  1. Your crew clocks in and out on their phones all week. One tap. It works offline, so a dead zone on the job does not lose a punch. Each punch is saved on the device with its real timestamp and syncs when signal returns.
  2. You review and approve the hours on the web. Time accumulates by person and by project, so you can see who worked where before you sign off.
  3. You open Reports and pick the export for your payroll system from the menu.
  4. You download the file and import it into your payroll system, or, on QuickBooks Online, use the live sync and send it with no file at all.
app.getclox.com/reports
Clox.
TodayTimesheetScheduleReportsTeam
DR
Dates: This week ▾All staffExport ▾
All staff · This week
412h 20m
23h 30m overtime — review before you run payroll
Hours by project
Hendrix Remodel
148h 10m
Oakdale New Build
121h 45m
Service Calls
82h 30m
Shop / misc
39h 55m
Hours and pay shown here are estimates — always verify against payroll.
app.getclox.com/reports
Clox.
TodayTimesheetScheduleReportsTeam
DR
Week of Jun 9–15
312.5 hrs · 4 with overtime
Export
EXPORT AS
CSV — QuickBooks Online
Straight into your payroll
CSV — ADP
RUN or Workforce Now
CSV — Paychex Flex
Standard payroll import
CSV — Gusto
Hours per employee
PDF timesheet
Every punch, break, overtime — for your CPA
8 employees · Mon–Sun · approved312.5 hrs

That is it. The crew never touches a spreadsheet, and you never type an hour twice. The export menu only shows the systems you told Clox you use, so you are not hunting through a long list to find yours.

Overtime and breaks are already in the numbers
Before Clox writes the file, it runs your hours through the same overtime engine and break math the detailed timesheet uses. Regular and overtime are split, unpaid breaks and auto-lunch are subtracted, and rounding is applied. So the totals in the file match what you approved on the Reports page to the minute. You are not exporting raw clock time and hoping the paycheck is right.

Which file does my payroll system take

Each system wants its hours in a specific shape, and Clox writes exactly that. Pick your system to see the file it takes.

Payroll systemFile Clox gives youHow it matches your people
GustoCSV with regular, overtime, and double-overtime hours per employeeBy first and last name
ADP RUNCSV with a separate row per earnings code (regular and overtime split into rows)By Employee ID
ADP Workforce NowPaydata CSV with regular and overtime in their own columnsBy File number
Paychex FlexCSV with one row per pay componentBy Worker ID
QuickBooks OnlineCSV that matches the import template, or a live sync with no fileBy employee name (CSV) or a mapped connection (sync)
QuickBooks Desktop.IIF file the desktop version importsBy employee name
Payroll system to Clox export file
IIF is Desktop, CSV or sync is Online
The two QuickBooks paths are easy to mix up. QuickBooks Online takes a CSV import or an optional live sync over a secure authorized connection. QuickBooks Desktop has no live connection, so it takes a downloadable .IIF file you import through File, Utilities, Import. Pick the one that matches the QuickBooks you actually run.

There is also a universal Payroll summary CSV that always appears in the export menu. It carries each employee with their payroll ID, the pay period dates, and regular, overtime, double-time, and total hours. If your system is not in the list above, this is the clean file you map into it, and it is a good backup for systems that have no file import at all.


Set your systems once

You tell Clox which payroll systems you use one time. After that, only those options show up in the export menu.

  1. On the web, go to Settings, then Integrations, then Payroll.
  2. Turn on the systems you use, and fill in the small setup each one asks for, such as your company code or worker IDs.
  3. If you use QuickBooks Online and want the live sync, authorize the secure connection to your account when prompted.
  4. Save. From now on those exports appear in the menu on the Reports page every pay period.
Run one real week before you decide
You can track a full pay period in Clox, approve it, and export it before you commit to anything. The trial is 14 days free with no credit card to start, and there is a 30-day money-back guarantee if you sign up and change your mind. That is enough to see your own hours land in your own payroll system.

Common questions

How does the overtime get split for each system

Clox calculates overtime once, on the web, using standard daily-8h and weekly-40h defaults you can configure per employee, with an optional California rule set that adds daily double-time. For most systems, such as Gusto, ADP, and Paychex, Clox writes the regular and overtime split directly into the file. QuickBooks is the exception. Its file carries total hours and QuickBooks applies its own overtime rules on import, so the split matches what you already set up there. The QuickBooks guide walks through that.

What if a job runs across two pay periods

Every punch is stamped with the date it was worked, so you export the date range that matches your pay period and the hours fall into whichever period they belong to. Nothing is lost at the boundary and nothing is double-counted. If you ever need to defend a specific record, Clox keeps a tamper-evident, hash-chained ledger of punches with a public verifier. See proof of presence and the verifier.

Do my workers need to install anything

The iPhone app is on a TestFlight beta right now, which anyone can join. If you would rather skip installs, a worker can clock in from a phone browser at app.getclox.com. Either way the punch works offline and syncs later. You can see current pricing before you commit.

Where is the step-by-step with screenshots

The docs carry the full walkthrough for approving hours and sending them out, plus a broader guide to everything on the Reports page. Start with export payroll and reports and exports.


Deep dives for each payroll system

This is the overview. Each system has its own guide with the exact columns, the match key, and the one-time setup. Read the one for yours.

Export crew hours to Gusto
The Gusto CSV, matched by name, with the regular, overtime, and double-overtime split filled in for the payroll run import.
Export crew hours to ADP
Both ADP paths: the ADP RUN earnings-code CSV and the ADP Workforce Now paydata import, matched by Employee ID and File number.
Export crew hours to Paychex
The Paychex Flex CSV, matched by Worker ID, with regular and overtime as their own pay components.
Export crew hours to QuickBooks
QuickBooks Online CSV or live sync, and QuickBooks Desktop IIF, with hours landing grouped by job for payroll and job costing.

Step-by-step: export payroll from Clox
The full walkthrough for approving hours and sending them to your payroll system, with the export menu and file options laid out.

The fastest way to see this work is to run a week of your own hours through it. Start a free trial at signup. It is 14 days free, no credit card to begin, and a 30-day money-back guarantee if you sign up and change your mind. Track a week, approve it, and send it to your payroll system before you decide anything.

Keep reading

PAYROLL
PAYROLL

Want this kind of clarity in your weekly payroll?

Start your free trial

14 days free · No credit card · 30-day money-back guarantee