Payroll

Reports and exports

Pull crew hours from the Clox Reports page: set a date range, switch h:mm or decimal, customize columns, and export CSV, Excel, PDF, QuickBooks, or Gusto.

The Reports page is where you pull hours for payroll, billing, and audits. You pick a date range, choose how the numbers show, and download the right file for whatever you're feeding it into. This is the overview. For the step-by-step QuickBooks import, see the Export for payroll article.

The Reports page

Open Reports in the web app at app.getclox.com. The Dates button at the top sets the range. You get presets for this and last week, this and last month, and (once you've set up a pay period) this and last pay period. There's also a Custom option: pick a start and end date, then hit Apply.

Managers get a Just me / All staff toggle to switch between your own hours and the whole crew. The Summary / Detailed toggle controls whether you see per-person totals or every individual shift. Filters lets you narrow to specific employees, projects, or clients.

Display: h:mm vs decimal

The Display menu has two things. Sort orders the report by hours or name. Format switches how hours read: h:mm shows them like a clock (8:30 is eight and a half hours), and Decimal shows 8.50. Most payroll systems want decimal, so check what yours expects before you export.

Customizing columns

In the Export menu, click Customize columns… to choose which columns the spreadsheet files carry and in what order. You can add or drop fields like Start, End, Breaks (min), Lunch (min), Regular, Overtime, and Double-time hours, pay amounts, notes, certified, and meal-break review. Your layout saves to your account, so it follows you across devices.

Custom columns only change the Standard exports (CSV, Excel, PDF). The payroll-provider and analysis files have fixed layouts, since the other system expects them a certain way.

Export formats

The Export menu groups every download into four sets. Every file uses the same date range, scope, and filters as what's on screen, so the download matches what you're looking at.

Standard — CSV (a spreadsheet of every shift in range), PDF (a printable summary with your logo), and Excel (XLS) (a per-employee, per-day, per-project rollup).
Payroll — QuickBooks Online (CSV) for QuickBooks' Import Time Activities flow, QuickBooks Desktop (IIF) for the desktop version, and Gusto (CSV) with hours by employee for a Gusto run.
Analysis & audit — Attendance (CSV) is a per-punch log for workers' comp or DOL audits, Utilization (CSV) is your job-cost vs overhead hours (the bid-vs-actual report), and Leave balance (CSV) shows PTO used and remaining plus holidays in range.
Proof of presence: Proof of Presence (PDF) is a tamper-evident report of where and when each punch happened, and Verifiable bundle (JSON) is a machine-verifiable record for one employee that anyone can paste into getclox.com/verify. The bundle covers one worker at a time, so it is available only when the report is narrowed to a single employee.

Live QuickBooks Online sync

You don't have to download and import a file every time. Under Settings → Integrations, click Connect QuickBooks Online to link your company. Once it's connected, pick a date range and hit Push to QuickBooks to send completed hours over as time activities.

Re-pushing a range is safe. Days already sent are skipped, not duplicated. If a worker's name doesn't match a QuickBooks employee, those hours are skipped and Clox tells you who to add.

Zapier and the API

Also under Settings → Integrations, Zapier / API access lets you generate an API key, then connect Clox as a custom app in Zapier to push new time entries into 6,000+ other apps. Copy the key when it's shown. It won't be displayed again, but you can regenerate or revoke it anytime.

Export for payroll →

Step-by-step for the QuickBooks, Gusto, and CSV imports.

Overtime and break rules →

How regular, overtime, and double-time hours get split before they hit your reports.