Export hours to your payroll provider
Pick your payroll provider in Settings, then download a file in its own import layout (Gusto, ADP, Paychex Flex, Justworks) or a sheet to type into QuickBooks or Square.
Choose your provider in Settings > Pay and overtime > Payroll. From then on, Reports > Payroll shows a button for that provider's file, such as Gusto hours import file. Gusto, ADP, Paychex Flex and Justworks import it as it is. QuickBooks Online and Square Payroll have no file import for hours, so for them it is a sheet to type from.
Choose your provider
- In the sidebar, click Settings, then Pay and overtime > Payroll.
- In Payroll provider, open Provider and pick yours.
- Fill in what that provider needs (below), then click Save beside the heading.
Using Paychex Flex? It needs your client ID first. See the Paychex Flex upload.
On ADP? Pick ADP RUN or ADP Workforce Now. A business that chose ADP before 19 Nov 2026 gets the ADP RUN file; switch to Workforce Now in the same list if that is your ADP. Both need your ADP company code, and you can type your own earning codes for regular, overtime, double time, paid time off and sick hours (REG, OT, DT, PTO and SICK until you do).
Each person's provider ID
Most providers match each row on their own ID for the person. Kloqk keeps it in one field, named the way your provider names it: Gusto ID, ADP Employee ID (RUN), ADP File # (Workforce Now), Paychex Worker ID, OnPay Clock User ID, Rippling employee number or Paylocity employee number. Fill it in on the person's profile (the Job card, or the Pay tab), or for everyone at once in the team sheet. Justworks matches on the name and work email instead.
Anyone with hours and no ID is named above the download button with a Fill them in link. The file still downloads.
Download the file
- In the sidebar, click Reports, then Payroll.
- Set the Period. It opens on your last completed pay period. If you have more than one location, pick All locations or one site.
- Click the provider button. It is the first button in the row.
- Import the CSV in your provider, or for QuickBooks and Square type the hours in from the sheet.
What each file holds
| Provider | Layout |
|---|---|
| Gusto | Gusto's hours template: last_name, first_name, ssn, title, gusto_employee_id, regular_hours, overtime_hours, double_overtime_hours, bonus, commission, paycheck_tips, cash_tips. One row per person. The ssn column is left empty (Kloqk keeps no Social Security numbers). The template has no time off column, so enter paid time off in Gusto; the report names whose it is. |
| ADP RUN | ADP's generic paydata import: ##GENERIC## V1.0 on the first line, then Company Code, Pay Frequency, Pay Period Start Date, Pay Period End Date, Employee ID, Earnings Code, Pay Hours, Dollars, Separate Check, Worked In Dept, Rate Code. One row per person per earning code. |
| ADP Workforce Now | A paydata batch named PR(company code)EPI.csv: Co Code, Batch ID, File #, Reg Hours, O/T Hours, Hours 3 Code, Hours 3 Amount, Temp Rate. Double time and paid leave go in Hours 3, a row per code. Temp Rate is filled only for somebody with two rates in the period. |
| Paychex Flex | The Payroll Upload file. See the Paychex Flex upload. |
| Justworks | Justworks' template: First name, Last name, Work email, Week start date, Week end date, Regular hours, Overtime hours, Double time hours, PTO hours. One row per person per Sunday to Saturday week. |
| QuickBooks, Square Payroll | A sheet to type from: each person's hours by day (regular, overtime, double time, paid time off), then their total. QuickBooks Online and Square take no hours file. QuickBooks Desktop's IIF time import is not built yet. |
| OnPay, Rippling, Paylocity (beta) | These providers do not publish their import layout, so the file follows what other time clocks send: hours by person keyed on the OnPay Clock User ID or Rippling employee number, and for Paylocity no header, a row per earning code (REG, OT1, OT2, VAC, SICK). If your provider refuses it, send us your import template and we will match it. |
Every hour in these files is the payroll report's own figure, to the hundredth. Your provider prices the hours from the rates it holds. Salaried people are paid by your provider from its own setup, so an import file carries only their overtime and double time; the sheets for QuickBooks and Square list them with their pay type.
The Spreadsheet button
Spreadsheet beside it downloads hours per person for any provider, or if you chose Other / not sure: Employee, Worked, Break, Lunch, Regular, Overtime and DoubleTime, with the period at the bottom.
Good to know
- The file holds exactly what the screen showed: the same dates and the same location.
- PTO hours are the paid time off hours that fall inside the period, not the whole request.
- Somebody who left during the period is still in the file for the hours they worked.
- Set up a column mapping for the file before 19 Nov 2026? The layouts changed that day to match each provider's own, so set the mapping up once more.
- Fix missing clock-outs before exporting. A clock-in still open after 24 hours counts for nothing until it is fixed. See missing clock-outs.
- Payroll exports are on every plan, including Free. Kloqk does not run payroll; your provider does.
Questions people ask
My provider isn't listed. What do I export?
Choose Other / not sure, then use the Spreadsheet button on Reports > Payroll. It has regular and overtime hours per person in a plain CSV.
Why don't I see a provider button on the Payroll report?
No provider is chosen yet, or it is set to Other / not sure. Pick one in Settings > Pay and overtime > Payroll and save that section.
Can I export just one location?
Yes. Pick the location in the Location dropdown at the top of Reports before clicking the button.
Does the file include pay rates?
No. Provider files carry hours, and your provider applies the rates it holds. The ADP Workforce Now file adds a Temp Rate only for somebody with two rates in the period.
Can Kloqk import hours into QuickBooks Online or Square?
Not as a file: neither takes an hours file. Reports > Payroll gives you a sheet with each person's hours by day to type in.
Related guides
Still stuck, or missing a feature?
Ask in the chat in your dashboard or email [email protected]. A real person reads every message, and we'll work it out.
Updated 2026-11-19