How do I export timesheets to Excel?
Filter the Timesheets page, click the green Export button and choose Default or Payroll. The file appears on your Downloads page when it's ready.
Export types
- Default – full timesheet details, with one row for each timesheet.
- Payroll – hours grouped by worker, ready for payroll.
Steps if MYOB is not connected
- In the left menu, under Field Operations, click Timesheets.
- Set the filters and dates to show only the timesheets you want in the file.
- Make sure you're in the list view. The Export button isn't shown in the weekly view.
- Click the green Export button and choose Default or Payroll.
- You will see Export started. You'll be notified once ready.
Steps if MYOB is connected
- Set the filters and dates on the Timesheets page.
- Click the green Export button at the top right, next to Add Timesheet.
- In the Export Timesheets window, pick Default or Payroll under Export Type.
- Check the Selected Filters box. To change them, close the window and change the filters on the page.
- Click Export.
Good to know
- The export uses the filters you've set. If you don't pick any status, timesheets of every status are included.
- The Export button on the Timesheets tab only makes Excel files. For MYOB, see How do I export timesheets to MYOB?
- To download the file, see Where do I find exported files?
If something goes wrong
- Can't see the Export button – if MYOB isn't connected, switch to the list view. If MYOB is connected, look at the top right of the page.