Exporting timesheets for payroll
payroll, pay, wages, salary, accountant, spreadsheet, excel, export, hours
Check everyone’s hours for a pay period, correct anything that’s wrong, and download a spreadsheet for your accountant.
Updated 5 October 2026
Open the pay period
Section titled “Open the pay period”Go to Timesheets. If you keep a timesheet of your own, choose Staff at the top. Then choose Pay period.
It opens on last month. The arrows step a month at a time. If you pay on other dates, such as a fortnight, press Custom dates, choose the First day and Last day, and press Show these dates: the arrows then step by that length.
Check the totals
Section titled “Check the totals”Everyone with hours in the period is listed with their shifts, hours and what they cost. Underneath is the total to pay.
A volunteer’s cost says Unpaid, never £0.00.
Hours are in hours and hundredths, as in the spreadsheet: 39.10 is 39 hours and 6 minutes. Correct anything that’s wrong
Section titled “Correct anything that’s wrong”Press a person to see their weeks in the period. Press a day to open it, change the times, and press Save hours. You can correct anyone’s hours, however long ago.
If a shift has no finish time, a warning above the table says so, because it counts as no hours. Press Review to find it and add the finish.
Export it
Section titled “Export it”Press Export. The spreadsheet for the period on screen downloads, ready to send to your accountant.
Why the periods are whole months
Section titled “Why the periods are whole months”A pay period is always a whole month, or the whole dates you chose, never “up to today”. So it covers the same days whenever you open it, and an export sent on a Wednesday matches one sent on Friday, unless someone has corrected their hours in between.