Export hours to ADP, Paychex, Gusto or Sage

Hand approved hours to ADP Workforce Now, Paychex Flex, Gusto or Sage 100 Contractor as their import file, checked before download.

Growth and Pro Last updated:

Already run payroll in ADP Workforce Now, Paychex Flex, Gusto or Sage 100 Contractor? Keep it there. Use Manpower OS for scheduling, GPS check-in and approving hours, then download the hours as your provider’s import file — checked before you download, and logged every time.

Provider exports are included in the Growth and Pro plans and during the free Pro trial, and need the Payroll module. Only admins can use them. The feature is in beta: each provider’s default layout follows its public documentation where there is one — check the layout against a sample file from your provider before your first import.

What goes into the file

  • Only approved days. Hours still waiting in Hours review, and rejected days, are never exported. The check screen tells you how many days are still waiting, so you can approve them first.
  • Regular, overtime and double time, split per day by your overtime rules (Payroll setup → Overtime). Each overtime tier is reported as overtime or double time — by default a tier paid at 200% or more is double time; you can change it under What goes in the file.
  • Paid leave and holidays (optional). Manpower OS records leave and public holidays as days, not paid hours. If you switch this on, approved leave (except unpaid leave) on work-week days counts as PTO hours and a public holiday the worker did not work counts as holiday hours, at the hours per day you set. This applies to hourly workers only — a monthly salary already covers leave and holidays.
  • Bonus and allowance amounts (optional, from a locked payroll run). Regular and overtime pay are never sent as money: your provider pays the hours at its own rates.

Make an export

  1. Open Payroll → Provider export.
  2. Pick the provider, then either a pay period (approved days between two dates) or a locked payroll run (its payslip hours, including any edits). You can also start from a locked run’s page with Payroll provider file.
  3. Press Check and preview. Every employee is listed with their hours and any problem. Red rows block the file; orange rows are worth a look but do not block it.
  4. Press Download file and import it at your provider.

Nothing is ever left out silently. If some employees have errors, you can fix them, or tick Leave out the N employees with errors to download a file without them — they must then be paid separately, and the history records who was left out.

What the check looks for

CheckBlocks the file?What to do
No provider IDYesGive the employee an employee number, or a provider ID under IDs per employee.
Two employees with the same IDYesCorrect one of them.
ID in the wrong formatYesFor example ADP file numbers are up to 6 digits, Paychex worker IDs up to 10 letters or digits.
Hours with no column or codeYesEnter the provider’s earning code, or add a column in the layout.
Days waiting for approvalNoApprove them in Hours review and check again, or export without them.
Hours differ from the payroll runNo (yes for Sage time cards from a run)The payslip was edited, or hours were approved after the run. Re-pull the run’s hours, or export the pay period.

Employee IDs

By default the employee number is used as the provider’s ID (ADP file number, Paychex worker ID, Gusto employee ID, Sage employee number). If your provider knows someone by a different number, enter it under Provider export → provider → IDs per employee. Leave it empty to keep using the employee number.

The providers

ProviderDefault fileYou set
ADP Workforce NowPaydata batch “EPI” CSV named EPI + company code + two digits (e.g. EPIAO401.csv): Co Code, Batch ID, File #, Reg Hours, O/T Hours, Hours 3 Code/Amount, Earnings 3 Code/Amount. Extra hour or earning codes go on extra lines for the same employee. Company code; batch ID (default: period end as YYMMDD); Hours 3 codes for double time, holiday and PTO, and Earnings 3 codes for bonus — they are company-specific, copy them from ADP.
Paychex FlexStandard payroll import (SPI) CSV with 16 columns — CLIENT ID, WORKER ID, ORG, JOB NUMBER, PAY COMPONENT, RATE, RATE NUMBER, HOURS, UNITS, LINE DATE, AMOUNT, … — one line per worker per pay component. Client ID; the exact (case-sensitive) pay component names from your Paychex company.
GustoOne row per employee: Last_name, First_name, Gusto_employee_id, Regular_hours, Overtime_hours, Double_overtime_hours, bonus. Upload it under Run payroll → Import payroll data. Nothing required. Add PTO or holiday columns only if your Gusto template has them.
Sage 100 ContractorDaily time-card lines: Employee, Date, Job, Phase, Cost Code, Pay Type, Hours — with Sage pay types 1 Regular, 2 Overtime, 3 Premium, 5 Vacation, 6 Holiday. Sage job number per site (job costing), optional default job, phase and cost code. Sage does not publish a time-card import layout, so this is a starting point to match to your import tool.

In Gusto a zero overwrites a value already entered and a blank leaves it alone: hours are always written, money columns are left blank when there is nothing to add.

Change the layout

Every provider’s settings page has a Column layout: add, remove and reorder columns, rename headers, and choose the delimiter, date format, quoting, decimals and line endings. Use it to match the template your provider gives you. Reset to default goes back to the documented layout. The settings page also lists the public sources each default comes from.

Export history

Every download is logged with who made it, when, the provider, the period or run, the number of rows, anyone left out and the file’s SHA-256 fingerprint — so a file found later can be matched to its export. Downloading from a locked run marks the run as exported, like the other payroll files.

Was this helpful?

Related articles