QuickBooks Time and Payroll: Exporting Timesheets

API & Integrations > Accounting exports produces a CSV timesheet for a period: minutes per member, project and day, ready for QuickBooks Time or for any payroll system that imports a spreadsheet. Pick a layout, a period and whether to include unapproved time, then press Download CSV.

The accounting exports panel: layout, period and approved-only choices above the Download CSV button

The three layouts

QuickBooks Time timesheet import — the columns QuickBooks Time expects: First Name, Last Name, Date, Hours, Customer, Service Item, Notes, Billable. The project becomes the customer, hours are decimal, and the notes column names the project and the day. Import it in QuickBooks Time under its timesheet import.
Generic (hours as decimals) — date, first and last name, e-mail, project, hours, minutes, approved hours, manual hours and idle minutes. This is the one for a payroll system that lets you map columns yourself, and the one to open when a human will read it.
Spreadsheet (ids and names) — the same rows with the member and project ids included, for matching against records in another system.

The period

Leave the dates empty for the last 30 days, or set From and To for a closed month. A period may span at most 92 days; for a longer stretch, download it in parts. The downloaded file is named after the layout and the dates, so a folder of them stays readable.

Approved entries only, or everything

The default is Approved entries only, which is what payroll should see. Switch to All entries when you are reconciling and want to see what is still waiting for approval — the generic layout carries both the tracked and the approved hours side by side, so the gap is visible in one column.

What the file never contains

No pay rates, no worklog notes written by members, no screenshots, application names or window titles. It is hours, names, projects and dates. Rates stay in SCREENish: multiply in your payroll system, where they belong.

Automating it

The same file is available to your own software over the API, so a monthly export can run on its own rather than being downloaded by hand. See API Keys and the developers page. For a spreadsheet that keeps itself up to date instead of a file per month, see Google Sheets: A Live Timesheet That Updates Itself.