Export hours for invoicing or payroll
Download CSV, Excel, PDF, QuickBooks or ERP files from Team hours.
Team plan and aboveOwners and admins1 min read
- Open Time, then Team hours
- Set the period, person and client you need
- Choose Export…
The Export time window shows how many entries and which filters apply.
- Choose a format
See the table below.
- Choose options
Billable entries only and Include hourly rates and amounts.
- Choose Download
| Format | What you get |
|---|---|
| CSV | Every entry with hours, rate and amount. Opens in any spreadsheet. |
| Excel | A workbook with all entries, plus totals by client, person and project. |
| A printable timesheet. Your browser’s print window opens: choose “Save as PDF”. | |
| QuickBooks | A CSV laid out for QuickBooks import tools. QuickBooks Online has no built-in time import, so use your importer’s column mapping. |
| ERP / accounting | A standard CSV with ISO dates, stable ids, dot decimals and UTF-8. Map the columns in your system’s importer. It is not certified for one specific product. |
Be careful
Rates and amounts are confidential. Store the file somewhere secure. If there are no billable entries in view, IdeaLine asks you to clear Billable entries only or change the period.
Related articles
- See team hours and totalsHours, billable time and value by client, person and project.
- Set hourly rates and weekly capacityGive each person a billing rate and a number of hours they can take on each week.
- Download everything: your data backupGet a complete copy of your workspace as a ZIP, Excel workbook or JSON file.
Still stuck on this one?