Exporting payroll (CSV + PDF)

Export clean payroll files for QuickBooks, Gusto, ADP, and Paychex, or a universal summary for any other 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
• Payroll group: ready-to-import files for QuickBooks Online (CSV), QuickBooks Desktop (IIF), Gusto (CSV), ADP RUN (CSV), ADP Workforce Now (CSV), and Paychex Flex (CSV), plus a universal Payroll summary (CSV). Only the systems you select in Settings appear here; the summary always does.
• 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 (set your pay period to biweekly with a start date in Settings, and the date menu adds This pay period and Last pay period shortcuts)
• 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

1. In QuickBooks Online, open Settings (the gear icon) → Import data → Time activities. Time tracking must be on under Account and settings → Advanced
2. Upload the CSV you exported from Clox
3. Map the columns (QuickBooks shows a preview)
4. Confirm the import. The hours come in as time activities, ready for payroll and billing

If you're moving over from QuickBooks Time, the write-up on using Clox as a QuickBooks Time alternative covers what changes and what stays the same.

Sync straight to QuickBooks Online (no file)

If you'd rather skip files, go to Settings → Integrations → Payroll and select QuickBooks. That turns on the QuickBooks exports and reveals an optional Connect QuickBooks Online button for live sync. Connect your company, then 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

Clox has dedicated exports for ADP RUN, ADP Workforce Now, and Paychex Flex. Select those systems under Settings → Integrations → Payroll and the matching format appears in the Payroll group on Reports. ADP and Paychex match each worker by their Payroll ID, never by name, so set a Payroll ID on each employee from the Team page before you export. QuickBooks and Gusto match by name instead. For any provider without a dedicated format, use the universal Payroll summary (CSV).

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