ShiftlyGuides

Export timesheets for payroll or your records

Choose a ready-made spreadsheet of approved hours, adjust how it's laid out, check the preview and download it as Excel or CSV.

Transcript

If you pay staff through a payroll system that isn't connected to Shiftly, you can export your timesheets as a spreadsheet. Here's how to pick a layout, check it and download it.

  1. Open Export timesheets

    On the Timesheets page, select Export at the top right. Export timesheets opens, with your location, the dates and the pay weeks they cover under the title.

  2. Choose a spreadsheet

    Under Spreadsheets, pick the layout you need. Hours per person is selected to start. Select Pay run totals, and the preview on the right updates with the file name and how many people it covers.

  3. Adjust the layout

    Select Hours per person again. Under Adjust, set Spread across to Pay week, choose Excel, and tick Split hours by position. Changing these makes a Custom layout.

  4. Check what's left out

    Most spreadsheets count approved timesheets only. When some aren't approved, a badge beside the title says how many are left out. Hover it to see why, or select it to go back and review them.

  5. Change the dates

    To export a different period, select Change dates. Pick a start and end date, or a preset such as Last week, then select Done.

  6. Download the file

    Select Download. Shiftly saves the file to your computer, and you'll see Timesheets downloaded.

Approve your timesheets before you export them, and check the figures against your payroll provider before you pay anyone.

When you pay staff through a payroll system that isn't connected to Shiftly, or you want a record of hours and pay, you can export your timesheets as a spreadsheet. Pick the layout you need, check it in the preview, and download it.

Who this is for

Owners, and managers whose access includes Timesheets. Pay amounts, pay categories and allowances need Pay & labour cost too, and so do the Pay run totals, Pay lines, Pay category summary and Labour cost by position spreadsheets, and adding leave needs Leave. Without them the export still gives you hours.

Before you start

  • Open Time in the main navigation and choose Timesheets, at the location you want to export.
  • Approve the timesheets for the period first. Most spreadsheets count approved timesheets only. See Review and approve timesheets.
  • Set the date range in the toolbar to your pay period. The export starts on that range.

Export your timesheets

Open Export timesheets

Select Export at the top right of the Timesheets page. Export timesheets opens with the location, the dates and how many pay weeks they cover under the title, for example Surry Hills · Sun 20 Sep to Tue 20 Oct 2026 · 6 pay weeks.

The Export timesheets page for Surry Hills with the 12 timesheets left out badge, the Spreadsheets list on the left with Hours per person selected, the Adjust options below it, and a preview of the file on the right listing each person's paid hours, days, shifts and total pay

If you ticked timesheets on the Timesheets page, or filtered the table, a box at the top of the settings keeps the export to those. Untick it to export the whole period.

Choose a spreadsheet

Under Spreadsheets, pick the layout you need:

  • Every shift: a row for each pay category of each shift, with times, breaks, pay and notes.
  • Hours per person: total hours, days, shifts and pay for each person.
  • Pay run totals: shifts, then regular, public holiday and overtime hours, for each person and position. Regular hours take in weekday, Saturday, Sunday, early and late hours.
  • Pay lines: a row for each person and pay category, ready to enter into payroll.
  • Payroll sheet by position: hours by position and pay week, with overtime and allowances.
  • Pay category summary: a column for each pay category, such as Saturday or overtime.
  • Day-by-day: hours worked on each day of the period.
  • Labour cost by position: each person's hours and cost, split by position.

The preview on the right updates as you choose, with the file name and how many timesheets, people and columns it has.

If your business uses WageEasy, a Payroll import section below the spreadsheets also offers WageEasy import (.wtc), a timecard file to import into WageEasy. See Send timesheets to WageEasy.

Adjust the layout

Under Adjust, the options depend on the spreadsheet:

  • Group hours: Total, Regular & OT (regular, public holiday and overtime) or Every category.
  • Spread across: the Whole period, each Pay week, or each Day.
  • Names: SURNAME, First or First Last.
  • File type: Excel or CSV.

Under Include, tick what you want added, such as Split hours by position, Allowances ($), Cost ($) (gross pay, before super), Leave (paid leave, kept apart from hours worked), Staff with no hours or Employee number. Changing these makes a Custom layout; pick a spreadsheet again to start over.

Pay run totals has fewer options: Names, File type, and Split by award level, which shows each person's award level instead of a row for each position they worked.

The Pay run totals spreadsheet selected, with Names, File type and the Split by award level option on the left, and a preview listing each person's position, shifts, regular hours, public holiday and overtime hours, with a Total row

Check what's left out

Most spreadsheets count approved timesheets only. When some in the period aren't approved, a badge beside the title counts them, for example 13 timesheets left out. Hover it to see why, and select it to go back to the Timesheets page and review them.

The badge 13 timesheets left out with its tip: 13 are waiting for approval. Only the 34 approved timesheets are in this file. Select to review them

Every shift is the exception: it includes every status, and each row shows its timesheet's status, so you can check pending and rejected shifts too. Its Leave option adds approved leave, paid and unpaid, as a row for each day.

The Every shift spreadsheet selected, with the Every status included badge, File type and the Leave option on the left, and a preview with a row for each pay category of each shift, showing the employee, location, position, department, area, status, date and earnings type

Change the dates if you need to

Select Change dates to pick a Start date and End date, or a preset such as Last week or This month, then select Done. A period can be a year at most.

The Change dates bar with Start date 20/09/2026, End date Tue 20 Oct 2026, and the presets Last 2 weeks, Last week, This week, Next 2 weeks and This month

Download

Select Download. Shiftly saves the file to your computer and confirms Timesheets downloaded. The arrow at the top left takes you back to Timesheets.

Exported figures are estimates from your pay rules and awards. Check them against your payroll provider before you pay anyone.

On this page