Features

Who it is for

More

Excel and PDF

Hours per job for payroll and job costing

One row per job, with the drive from the workshop. The Excel file sums up per job, checks every day against the Working Hours Act and flags late records.

Download XLSXDownload PDF
  • No sign-up
  • No newsletter
  • Free to use
Preview: Hours per job for payroll and job costing

What is in the template?

Ready to use, with formulas, sample data and a legend.

  • Hours and driving time per job on a sheet of their own
  • Several jobs a day, with a daily check across all rows
  • A "Recorded on" column with the 7-day deadline
  • Breaks and gaps between two jobs counted together
  • Notes on driving time and apprentices under 18

When does the template fit?

Ideal as an interim solution or for small teams, with clear limits.

  • Electrical, plumbing, heating, painting and joinery
  • Costing fixed-price jobs afterwards
  • A job sheet as a PDF in the vehicle
When Excel reaches its limits

Job costing is only right if the hours land on the job the same day.

In MetronHR the journeymen clock in on the job via the app, driving and work kept apart. In the Professional plan the hours per project show up in the budget straight away, and at month end the payroll file goes to the accountant.

How MetronHR solves it
In comparison
Excel templateMetronHR
UpkeepManual upkeepAutomatic calculations
ApprovalsNo workflowsApproval workflow
RemindersNo remindersReminders
TeamCopy again for every employeeOne central source for the whole team
More templates

Also goes with this

Attendance and job time kept apart, with labour units and efficiencyGo to the templateDrive, job and emergency call per customer, with rest until the next morningGo to the templateWorking time and client time in one list, with the billable shareGo to the templateProject, support and call-out times, with rest after a night call-outGo to the template

Frequently asked questions

Answers on usage and legal aspects.

Question not answered here? Every step is explained in the help centre.

Send us a message
Is the drive to the customer working time?

If the day starts at the workshop, yes, and so is the drive between two customers. Anyone driving to changing customers every day without a fixed place of work is working from leaving home (CJEU, 10 September 2015, C-266/14). Pay can be governed separately by the contract.

Does the 7-day deadline apply in trades too?

For trades providing construction work, yes, for all employees (section 2a(1) no. 1 SchwarzArbG with section 17 MiLoG). This often covers electrical, plumbing, painting, roofing and scaffolding. For mini-jobbers it applies in every trade.

How long may apprentices under 18 work?

At most eight hours a day and 40 a week (section 8 JArbSchG), between 6 am and 8 pm (section 14). Not on Saturdays in principle; building sites are not on the list of exceptions in section 16(2) JArbSchG.

Templates are a start. MetronHR is the answer.

When Excel reaches its limits in a team, MetronHR takes over the process. Try it free for 14 days.

Try it free for 14 days
  • No credit card required
  • Ready quickly
  • Cancel monthly
  • Full access to every feature

Ready in 5 minutes, no credit card