EngineersTimesheets
New job

Timesheets

Hours worked against hours booked · Yesterday, Mon 16 Nov

Payroll export (CSV)
4Submitted, to approve
2Queries
1Approved
17%Of the day spent travelling · 8h 55m
Travel between jobs is counted from the schedule, so you can see it before payroll. Anything over the booked day or with a lot of travel is flagged for a person to check.
EngineerBookedWorkedDifferenceBreakPaidOvertimeTravelStatusFlags
DRDan ReidGas engineer7h 30m7h 45m+15m30m7h 15mNone1h 10m15% of the dayTo approveNone
Ask a question
PSPriya ShahGas engineer7h 30m9h 5m+1h 35m30m8h 35m35m1h 25m16% of the dayQuery1h 35m over the booked day, no overtime approved
Ask a question
THTom HughesElectrician7h7h 10m+10m30m6h 40mNone55m13% of the dayTo approveNone
Ask a question
LPLewis PriceSenior gas engineer8h8hOn time30m7h 30mNone40m8% of the dayApprovedNone
AKAmira KhanFire and electrical engineer6h 30m6h 40m+10m30m6h 10mNone1h 35m24% of the dayTo approveNone
Ask a question
JMJake MorrisMaintenance engineer7h7h 20m+20m30m6h 50mNone2h 10m30% of the dayQueryTravel was 30% of the daySecond visit to Kingsway Dental not on the schedule
Ask a question
SOSam OkaforElectrician7h 30m7h 35m+5m30m7h 5mNone1h13% of the dayTo approveNone
Ask a question

Pay period: 31 Aug to 6 Sept

PreviousNextDownload for payroll
EngineerDaysPaid hoursNormalOvertimeHolidaySickExpensesNot approved yet
Dan Reid000000£0.000
Priya Shah000000£0.000
Tom Hughes000000£0.000
Lewis Price000000£0.000
Amira Khan000000£0.000
Jake Morris000000£0.000
Sam Okafor000000£0.000

Only approved days are paid. Overtime is anything over 8 paid hours a day, after a 30 minute break on days over 6 hours. Change these on the rota page.

Commission: 31 Aug to 6 Sept

Commission report
Finished job bonus£5.00 per finished job · everyone
Upsell on site5% of each accepted quote · everyone
£0.00 this period. Counted when a job is finished or a quote is accepted, for the person on the job.
Add a rule

Payroll file for your provider

  • Standard (any payroll): One row per person with every column. Opens in Excel.
  • Xero Payroll (key in): Xero Payroll UK doesn't import pay from a file yet. This sheet has one line per person and earnings rate, named as Xero names them, to key into the pay run or timesheets.
  • BrightPay: Payroll, More, Import Pay Records from CSV File, Import Mix of Payments, Additions and Deductions. Tick Match Header Row. Hours go in at the standard hourly rate (overtime at time and a half), commission and expenses as additions. Set the expenses addition as not taxable.
  • Sage 50 Payroll: File, Advanced Data Import, Timesheet Payments. Tick "Import File has Header Row" and map the columns once. Payment references 1 to 4 stand for basic, overtime, commission and expenses, so change them to your own pay element numbers. Check with your first real file
Approved hours, overtime, expenses and commission for the pay period, ready to import into your payroll.

Where approved timesheets go

Approved timesheets go to payroll export. It isn't connected yet. Connect it in Connections and approved hours go across on their own. Nothing is sent until a person approves it.

Working time (2)

All checks
Dan has a 11h 55m day on Fri 13 Nov (08:12 to 20:07)Long day
Sam has a 10h 5m day on Wed 11 Nov (08:01 to 18:06)Long day