Payroll Integrations › QuickBooks
qb
Map columns once

Import Stafferin hours into QuickBooks Online Payroll

QuickBooks lets you upload a CSV of timesheets and shows a preview where you point each column to the right field. Friendly and forgiving — set up the mapping once and every future file just works.

⏱️ ~6 minutes first time 📄 CSV or TSV 🔁 Faster every period after
📖
Official QuickBooks documentation (read alongside this guide) Intuit's own help articles for importing a timesheet CSV:
⚠️
One-time setup in QuickBooks — turn on timesheets first: Payroll → Employees → Payroll Settings → under Business Management select Timesheets → Enable. You only do this once.

Step-by-step

1

Export the hours from Stafferin

Go to Payroll → Payroll Export, choose the pay period, and click Download CSV. Keep the Employee Name (or Employee #) and Date columns on — QuickBooks uses them to attach hours to the right person and day.

app.stafferin.com/payroll-export
📅Pay period: Jun 1 – Jun 15, 2026
⬇️Download CSVDownload CSV
① Get the file
2

Open the timesheet import in QuickBooks

In QuickBooks Online go to All apps / Payroll → Employees → Manage Employees → Import Timesheets, then in the dropdown choose Custom file upload.

app.qbo.intuit.com/payroll/employees
▾Import from…
📤Custom file uploadSelect
② Choose "Custom file upload"
3

Upload the file & set the date format

Drop in your Stafferin CSV. QuickBooks asks for the date format — Stafferin uses YYYY-MM-DD (e.g. 2026-06-02), so pick that. It then shows a preview of the first few rows.

4

Map each column (the one clever part)

For every column, tell QuickBooks what it is. You only do this carefully the first time — match them like this:

Stafferin column→QuickBooks field
Employee Name→Employee
Date→Date worked
Regular Hours→Regular hours
Overtime Hours→Overtime hours
Department / Location→Class / Customer (optional)
③ Use the live preview to confirm each column lines up
5

Approve & run payroll

Tick "Approve timesheets" if you want the imported hours auto-approved (otherwise they go through your normal approval). Finish the import, then Run payroll — the hours are already filled in for each employee.

✅
Done. QuickBooks remembers your column mapping, so next period it's just: export → upload → run.

Next steps

⬇️ Export hours now 📖 Official QuickBooks import article ← All payroll providers Need help? Email support