HR templates that save your team time
Timesheets, holiday planners, onboarding plans and more: free Excel templates for the topics MetronHR also automates in the product. No sign-up, no newsletter.
- Instant download, no email required
- Free to use and adapt within your company
- Only templates for processes MetronHR actually covers
All templates at a glance
18 Topics: time tracking and records, absences, duty and holiday planning, onboarding for seven industries, project time, allowances and sample agreements and notices. Free of charge, no sign-up.
A timesheet and working time record as an Excel template or a printable PDF
Timesheet, hours record, working time record: the same document. Daily target, breaks and overtime calculated automatically, one table per month. As Excel for the calculation, as PDF for printing.
Holiday planner 2026 as a free Excel template
An annual overview for the whole team with German public holidays, weekends and remaining holiday calculation, ready for 2026.
Onboarding plans by industry
Four industry-specific 90-day onboarding templates: office & knowledge work, retail & sales, hospitality & service, trades & construction, with industry-appropriate tasks and owners.
Client allowance tracker as a free Excel template
Hour packages per client in view: usage, roll-over and remaining balance per month, ideal for retainer models at agencies, IT service providers and law practices.
Shift roster and duty roster as a free Excel template
A duty roster with the classic A/B week pattern for rotating shifts (early, late, night), with an hours total per employee and a warning where rest periods are breached.
Working time record under section 17 MiLoG
The start, end and duration of daily working time, recorded in the form section 17 MiLoG requires: no later than seven calendar days after the work was done, kept for two years.
A timesheet for mini-jobs with earnings monitoring
Twelve monthly sheets with automatic earnings calculation against the marginal earnings threshold of 603 euros and a note on how much is still available that month.
Calculate working time with a break check
Enter the start and end, and the template deducts the required break and warns when the limits of the Working Time Act are exceeded.
Overtime account with a time off agreement
One annual sheet for target, actual, payout, time off in lieu and the running balance, plus a sample agreement on reducing the balance.
Project time tracking with client, project and hourly rate
One entry sheet for 120 lines and a report per client that adds up hours and revenue by itself.
Monthly duty roster with shift codes
One sheet for the whole month: enter a code per day and the hours total per person calculates itself, with the codes freely changeable.
Holiday planner 2027 for the whole team
An annual overview for 25 people with a holiday account per person and a sheet with the nationwide public holidays for 2027.
Holiday request as a form to fill in
One sheet for the request, cover arrangements, the holiday account and the decision, with the references from the Federal Holiday Act that count in case of doubt.
Internal sick note as a form
One sheet for the internal report: period, type of report, the status of the medical assessment, cover and handover.
A sample agreement on mobile working
Six sections covering what people argue about in a dispute: place and extent, working time and availability, equipment, occupational safety, data protection and accident insurance.
Notice on break rules under section 4 ArbZG
One sheet for the notice board: the statutory break times large and legible, plus the rules most often overlooked in daily work.
Sample works agreement on recording working time
Nine clauses as a starting point for the negotiation: data recorded, purpose limitation, access, corrections, retention, permitted reporting.
Checklist: introducing time tracking
Eight steps from the legal duty to the first month end, with 36 points to tick off, owners and dates.
Templates meant to help, not just to rank
Many providers release templates only after you enter an email address, or promote topics their software does not even cover. We do it differently.
No sign-up
No email required, no newsletter, no account. A direct download.
Free to use
Free to use, copy and adapt within the company. No licence needed.
Formulas already built in
Totals, balances and carry-overs calculate themselves. Not an empty grid to rebuild.
Frequently asked questions about the templates
What you should know before using a template.
Because a template is only useful if you can download it straight away. No email required, no account, no newsletter.
All templates are available as Excel (XLSX) with built-in formulas. We add printable PDF versions where they genuinely help, so do write and tell us which format you need.
No, we have none for those. There are templates for time, absences, personnel files, workflows, allowances and shifts.
Yes. You may change, copy and pass the templates on to colleagues internally. Republishing them commercially as your own product is not allowed.
Year-specific templates (the holiday planner, for example) are updated at the turn of the year. Generic templates are maintained when legal conditions or best practices change.
Question not answered here? Every step is explained in the help centre.
Templates do not replace a system, they show where one starts
MetronHR takes over exactly the processes you would otherwise maintain in Excel. Try it free for 14 days.
Ready in 5 minutes, no credit card