Search documentation

Find a guide by title or topic

Managing your team

Export approved hours

Hand approved hours to payroll or billing: layouts, Harvest and QuickBooks import files, Xero and Deel recipes, rounding and the API.

ForOwnerAdminManagerTeam leadAuditor

TimeLogger stops at approved hours: it never computes pay, rates or invoices. The approved-hours export is how those hours reach your payroll, billing or accounting tool — as a spreadsheet, a ready-to-import file, or through the API.

Who can do this:OwnerAdminManagerTeam leadAuditorFor the people in your scope. Members can export their own approved hours.

Download approved hours#

  1. Open the export

    Go to WorkspaceReportsApproved hours.

  2. Choose the period

    This week, Last week, Last 30 days or This month, or pick dates.

  3. Choose the layout

    See the table below. Import files match a specific tool’s template.

  4. Download

    Choose Download CSV, Download XLSX or Download PDF. Long ranges are built in the background.

The Approved hours tab, with the QuickBooks recipe open.

Only approved time

Only approved and locked timesheets are included. Lock the period first so the export can’t change later. Dates and times are in each person’s own time zone.

Layouts#

LayoutWhat it means
By member and periodTotals: one row per person per timesheet period.
By projectTotals: hours per project, with code and client.
By taskTotals: hours per project and task.
One row per entryDate, person, project, client, task, note, start, end and hours.
Per person, day, project and taskThe usual shape for timesheet imports, such as Xero and Deel.
Harvest time importHarvest’s CSV template columns.
QuickBooks time activitiesQuickBooks Online time-activity columns.

Rounding#

If your workspace rounds time (for example to the nearest 6 minutes), each entry is rounded in the export. Tracked time itself is never changed. Set it up in Timesheet settings.

Import recipes#

Check the import preview

The Harvest and QuickBooks layouts follow those tools’ published CSV import templates. Names of people, clients, projects and tasks must already exist in the other tool — always check its import preview before confirming.

QuickBooks#

  1. Pick QuickBooks time activities and download the CSV.
  2. Import it into QuickBooks Online with your time-activity importer (or QuickBooks Time’s timesheet import). The columns are Date, Employee, Customer, Service Item, Description and Duration.
  3. Customers use QuickBooks’ Client:Project naming, the service item is the task (or “Hours” when there’s no task), dates are MM/DD/YYYY and durations are H:MM.

Harvest#

  1. Pick Harvest time import and download the CSV.
  2. In Harvest, open the time import in an administrator’s Import/Export settings and upload the file.
  3. Columns: Date (YYYY-MM-DD), Client, Project, Task, Notes, Hours, First name, Last name. Entries without a client use your workspace name, and entries without a task use “General”, because Harvest needs both.

Xero#

Pick Per person, day, project and task. Use Xero’s timesheet import where your plan offers it, or a connector app, mapping Date, Email (to match the employee), Project and Hours.

Deel#

Pick Per person, day, project and task and submit the hours per day for hourly contracts, matching people by email. Teams with many contractors usually automate this through the API.

The API#

To automate the hand-off, create an API key with the exports:read scope and call the approved-hours export with the same layouts. The API recipe tab has a ready-made request, and the full reference is under Public API in the app.

Questions#

Why is my export empty?
Nothing in that period is approved yet. Approve the timesheets first — only approved and locked time is exported.
Can the export include rates or amounts?
No. TimeLogger never stores money. Your payroll or billing tool applies rates to the hours.
An approved timesheet changed after I exported it. What happened?
An edit inside an approved sheet sends it back for re-approval. Lock periods after exporting so they can’t change without an audited unlock.

Something unclear or out of date? Tell your workspace admin, or write to the TimeLogger team from Settings — we update these guides with every release.