Payroll

Exporting payroll (CSV + PDF)

Export clean payroll files for QuickBooks, Gusto, or any provider, or sync hours straight into QuickBooks Online.

Where exports live

Open Reports and click the Export menu. You'll find several formats grouped by purpose:

CSV and Excel: a row per shift for spreadsheets or a generic payroll import
PDF: a printable summary for filing, workers' comp audits, and DOL records
QuickBooks (Online and Desktop) and Gusto: provider-specific files under the Payroll group
Proof of presence: a signed, tamper-evident record of where and when each punch happened, for disputes and audits. It comes as a printable PDF and a machine-verifiable JSON bundle. See the proof-of-presence article.

Setting the date range

Use the date pickers at the top to set the pay period. Common choices:

Last week (most common: Sunday-to-Saturday or Monday-to-Sunday)
Bi-weekly (last 14 days)
Custom range for special audits

What's in the CSV

Each row is one shift (not one employee), and you choose the columns. In the Export menu, choose Customize columns… to pick which to include and their order. It saves to your account and applies to CSV, Excel, and PDF. Available columns include:

Employee, date, start, and end times
Project and Client (the client a project belongs to)
Hours on the clock, breaks, lunch, and final paid hours
Regular / overtime / double-time hours and pay
Certified (employee sign-off) and any per-shift note

Importing into QuickBooks

In QuickBooks Online: Payroll → Run Payroll
Click Import time
Choose Upload CSV
Select the file you exported from Clox
Map the columns (QuickBooks shows a preview)
Confirm and run payroll

Sync straight to QuickBooks Online (no file)

If you'd rather skip files, connect your QuickBooks Online company under Settings → Integrations. Once it's connected, push a date range of hours straight into QuickBooks as time activities. Clox matches each worker to a QuickBooks employee by name and skips anything it already sent, so you can re-run a range without creating duplicates.

Importing into ADP and other providers

Most payroll providers accept a generic CSV with hours per employee. The Clox export matches the common format. Your provider's docs will have specific column-mapping instructions.

PDF format

The PDF is a complete record per employee: every shift, every break, every overtime hour, with the rules applied. Save these for:

Workers' comp audits (annual)
DOL inspections
Customer billing disputes
Your own annual records

For a record an outsider can verify

This PDF is a clean summary for your own files. When you need to hand a client, auditor, or lawyer a record they can check themselves, use the Proof of presence export instead. It is tamper-evident, so they can confirm it was not edited after the fact.

Best practice: save the PDF for every pay period in a date-stamped folder on your computer or cloud drive. 7 years of records is the standard retention window for payroll.