Export timesheets in just a few clicks so you can send data to clients or integrate it with payroll systems. It brings flexibility, speed, and better organization to your workflow.
1. Only users with export permissions can export timesheets.
2. If a user cannot view a candidate, they cannot export that candidate’s timesheets.
Note: Currently, this feature is in beta version and can be enabled upon request. Please feel free to reach out to your Account Manager to have it enabled for your account.
📋 How to Export Timesheets
Go to the Jobs page and open a job with the type set to Contract or Contract to Permanent.
Scroll to the Candidate Pipeline section and click View All Timesheets.
3. There are two ways to export timesheets: individually or in bulk.
Export an Individual Timesheet
You can directly export the desired timesheet in XLSX (default format) by clicking on the Export button in the Action column.
If you want to export it in CSV, follow along -
i. Click on the desired timesheet period.
ii. Choose the preferred export format (XLSX or CSV).
iii. Click Export.
Export Multiple Timesheets
i. Select the timesheets you want to export, or use the top box to select all.
ii. Click the Export button on the top header bar.
iii. Choose the fields you want to include that will be exported in the timesheet.
iv. If you want to export each day as a separate column, check the box at the top. This generates a day-wise breakdown with separate sheets for each timesheet period, with the option to include daily work and overtime hours.
v. Select the desired format (XLSX or CSV) and click Export.
If CSV is selected with day-wise export enabled, the output is delivered as a ZIP file containing a separate CSV for each timesheet period.
Please note
You can follow the same steps to export timesheets from the Deals section.
🚀 Key Features
Comprehensive Export
Export timesheets in any status: Open, Submitted, Approved, or Rejected.
Bulk Export
Export multiple timesheets in one action from the Contractor Details or Deals Details page.
Single Timesheet Export
Export an individual timesheet directly from its detail view.
Multiple Formats
Export in XLSX (default) or CSV.
Customizable Fields
Select fields such as candidate name, job name, company name, deal name, and other timesheet-related details.
Day-wise Breakdown
Export each day as a separate column for detailed totals, including work hours and overtime.
Separate sheets are created for each timesheet period when day-wise breakdown is enabled.
Organized Data
Timesheet dates are exported in MM/DD/YYYY format. Hours appear in decimal form (e.g., 8h 30m shows as 8.5).
If you would like to learn more about this feature, you can book a quick call with our team through this link.
❓ FAQs
What if I choose day-wise columns?
What if I choose day-wise columns?
In XLSX, each timesheet period appears as a separate sheet within one file.
In CSV, each period is exported as an individual file, and all files are bundled in a single ZIP.
If day-wise export is not selected, all data appears in one sheet with the chosen fields.
How are work hours exported for shifts?
How are work hours exported for shifts?
Shift-based timesheets show hours exactly as recorded. For example, a shift from 09:00 to 17:00 appears the same in the export.