Free templates

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.

No credit card required · Cancel monthly

  • Instant download, no email required
  • Free to use and adapt within your company
  • Only templates for processes MetronHR actually covers
The MetronHR dashboard in the browser: team calendar with leave and open requests, hours worked and overtime.
DashboardDr Lindner's practice · Wednesday, 21 October
01:24:153
Hello, Dr Lindner3 requests are waiting for you. 9 of 12 are in today.View requests
Worked Today3:49h
Leave left13 days
Overtime+12:30h
Open requests3
Team calendar 19–30 October
MonTueWedThuFriMonTueWedThuFriLena H.Leave · 5 daysTobias K.openAylin D.Request openMehmet Y.SickSophie B.Mara W.Remote
My tasks 3 open
Leave, 3 daysAylin Demir · 28–30 Oct
Training, 1 dayTobias Krüger · 22 Oct
Leave, 3 daysNadia Schulz · 22–24 DecReview
Month endSeptember · Krämer payroll officeDone

All templates at a glance

36 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.

Preview: A timesheet and working time record as an Excel template or a printable PDFExcel templateA 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.

XLSXPDFGo to the template
Preview: Holiday planner 2026 as a free Excel templateExcel templateHoliday 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.

XLSXGo to the template
Preview: Onboarding plans by industryOnboarding · 7 industriesOnboarding plans by industry

Seven industry-specific 90-day onboarding templates: office, retail, service, kitchen, trades, care and practice, with tasks and owners that fit each industry.

XLSXPDFGo to the template
Preview: Client allowance tracker as a free Excel templateExcel templateClient 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.

XLSXGo to the template
Preview: Shift roster and duty roster as a free Excel templateExcel templateShift 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.

XLSXGo to the template
Preview: Working time record under section 17 MiLoGMiLoG recordWorking 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.

XLSXPDFGo to the template
Preview: A timesheet for mini-jobs with earnings monitoringMini-jobA 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.

XLSXPDFGo to the template
Preview: Calculate working time with a break checkCalculation sheetCalculate 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.

XLSXPDFGo to the template
Preview: Overtime account with a time off agreementOvertimeOvertime 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.

XLSXPDFGo to the template
Preview: Project time tracking with client, project and hourly rateExcel templateProject 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.

XLSXPDFGo to the template
Preview: Monthly duty roster with shift codesExcel templateMonthly 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.

XLSXPDFGo to the template
Preview: Holiday planner 2027 for the whole teamExcel templateHoliday 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.

XLSXPDFGo to the template
Preview: Holiday request as a form to fill inFormHoliday 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.

PDFGo to the template
Preview: Internal sick note as a formFormInternal sick note as a form

One sheet for the internal report: period, type of report, the status of the medical assessment, cover and handover.

PDFGo to the template
Preview: A sample agreement on mobile workingPatternA 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.

PDFGo to the template
Preview: Notice on break rules under section 4 ArbZGNoticeNotice 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.

PDFGo to the template
Preview: Sample works agreement on recording working timePatternSample works agreement on recording working time

Nine clauses as a starting point for the negotiation: data recorded, purpose limitation, access, corrections, retention, permitted reporting.

PDFGo to the template
Preview: Checklist: introducing time trackingChecklistChecklist: introducing time tracking

Eight steps from the legal duty to the first month end, with 36 points to tick off, owners and dates.

PDFXLSXGo to the template
Preview: Duty roster for kitchen and service, with split shifts and rest checksExcel and PDFDuty roster for kitchen and service, with split shifts and rest checks

One week per person with two parts per day. The Excel file adds up the hours and flags rest that is too short, missing breaks and days over ten hours.

XLSXPDFGo to the template
Preview: Duty roster for reception, night audit and housekeepingExcel and PDFDuty roster for reception, night audit and housekeeping

A weekly plan with night duties past midnight. The Excel file recognises the next day, adds up the hours and flags rest that is too short when switching from late to early.

XLSXPDFGo to the template
Preview: Duty roster for early, late and night duties in careExcel and PDFDuty roster for early, late and night duties in care

A weekly plan with night duty and split duty. The Excel file adds up the hours and flags where the rest becomes too short when switching from late to early.

XLSXPDFGo to the template
Preview: Duty roster for shop floor and stockroom, with temps and SaturdayExcel and PDFDuty roster for shop floor and stockroom, with temps and Saturday

A weekly plan from goods in to closing time. The Excel file adds up the hours and flags missing breaks, rest that is too short and days over ten hours.

XLSXPDFGo to the template
Preview: Duty roster for site and event security, with night dutyExcel and PDFDuty roster for site and event security, with night duty

A weekly plan for day, late, night and event duties. The Excel file calculates past midnight and flags shifts over ten hours and rest that is too short.

XLSXPDFGo to the template
Preview: Shift roster for warehouse and routes, with night shiftExcel and PDFShift roster for warehouse and routes, with night shift

A weekly plan for early, late and night shifts in the warehouse and for driver routes. The Excel file flags rest that is too short at a shift change and long days.

XLSXPDFGo to the template
Preview: Duty roster for sites with early and evening jobsExcel and PDFDuty roster for sites with early and evening jobs

Two jobs on the same day, before offices open and in the evening. The Excel file adds both up and shows when the rest until the next morning is not enough.

XLSXPDFGo to the template
Preview: Duty roster for front desk, training floor and classesExcel and PDFDuty roster for front desk, training floor and classes

A weekly plan from early opening to late closing, with weekend duties. The Excel file flags when the early duty follows too closely after the late duty.

XLSXPDFGo to the template
Preview: Shift roster for service hours with early, mid and late shiftsExcel and PDFShift roster for service hours with early, mid and late shifts

A weekly plan for a hotline from morning to evening. The Excel file adds up the hours and flags rest that is too short when switching from late to early and missing breaks.

XLSXPDFGo to the template
Preview: Timesheet per site, with the 7-day deadline under section 17 MiLoGExcel and PDFTimesheet per site, with the 7-day deadline under section 17 MiLoG

One month per person, one row per job. The Excel file adds up the hours per site, checks every day against the Working Hours Act and flags entries recorded later than seven days.

XLSXPDFGo to the template
Preview: Hours per job for payroll and job costingExcel and PDFHours 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.

XLSXPDFGo to the template
Preview: Attendance and job time kept apart, with labour units and efficiencyExcel and PDFAttendance and job time kept apart, with labour units and efficiency

One row per job with number plate and labour units. The Excel file converts units into hours, shows the efficiency per job and checks every day against the Working Hours Act.

XLSXPDFGo to the template
Preview: Drive, job and emergency call per customer, with rest until the next morningExcel and PDFDrive, job and emergency call per customer, with rest until the next morning

One row per drive and job, with the customer's signature. The Excel file sums up per customer and per type and flags when a night emergency call cuts the rest period.

XLSXPDFGo to the template
Preview: Working time and client time in one list, with the billable shareExcel and PDFWorking time and client time in one list, with the billable share

One row per task with client, project and billable yes or no. The Excel file sums up per client and project, shows the billable share and checks every day against the Working Hours Act.

XLSXPDFGo to the template
Preview: Project, support and call-out times, with rest after a night call-outExcel and PDFProject, support and call-out times, with rest after a night call-out

One row per task with client, ticket and type. The Excel file sums up per client and type and flags when the rest until work starts is missing after a night call-out.

XLSXPDFGo to the template
Preview: Project time and travel time kept apart, with what counts under the ArbZGExcel and PDFProject time and travel time kept apart, with what counts under the ArbZG

Every trip gets a type: driving, working on the way, set by the employer or free time. The Excel file only counts what is working time and checks every day against the Working Hours Act.

XLSXPDFGo to the template
Preview: Times per hirer under section 17c AUeG, with the 7-day deadlineExcel and PDFTimes per hirer under section 17c AUeG, with the 7-day deadline

One row per assignment with hirer, place of work and recording date. The Excel file sums up per hirer, flags late entries and checks the day across all hirers together.

XLSXPDFGo to the template
Preview: Volunteers, coaches and mini-jobs: assignments, allowances and the earnings limitExcel and PDFVolunteers, coaches and mini-jobs: assignments, allowances and the earnings limit

Enter each person's role, hourly rate and hours per month. The Excel file works out the annual pay, deducts the matching allowance and flags where the minimum wage or the mini-job limit does not fit.

XLSXPDFGo to the template

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.

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

Send us a message
Why are the templates free and without sign-up?

Because a template is only useful if you can download it straight away. No email required, no account, no newsletter.

Which formats are offered?

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.

Do you also have templates for travel expenses, payroll or applicant management?

No, we have none for those. There are templates for time, absences, personnel files, workflows, allowances and shifts.

May I adapt the templates and share them within my company?

Yes. You may change, copy and pass the templates on to colleagues internally. Republishing them commercially as your own product is not allowed.

How up to date are the templates?

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.

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.

  • No credit card required
  • Ready quickly
  • Cancel monthly
  • Full access to every feature

Ready in 5 minutes, no credit card