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.
- No sign-up
- No newsletter
- Free to use
What is in the template?
Ready to use, with formulas, sample data and a legend.
- Twelve monthly sheets for 2026, with weekends marked
- The hourly rate and the earnings threshold freely set in the header
- Earnings and the remaining amount up to the threshold calculated automatically
- A plain-language warning when the threshold has been exceeded
- A record in the form section 17 MiLoG requires for mini-jobs
When does the template fit?
Ideal as an interim solution or for small teams, with clear limits.
- Mini-jobs in hospitality, retail, care and cleaning
- Casual staff with fluctuating hours
- Evidence for the mini-job centre and a customs inspection
The threshold breaks on the 27th, not at the end of the month.
Anyone who only checks the earnings threshold when running payroll notices too late that one shift was too many. In MetronHR every temp's clocked hours are in the system on the same day, and the tax firm gets the finished overview and the DATEV payroll file at the end of the month, with nobody collecting sheets.
| Excel template | MetronHR | |
|---|---|---|
| Upkeep | Manual upkeep | Automatic calculations |
| Approvals | No workflows | Approval workflow |
| Reminders | No reminders | Reminders |
| Team | Copy again for every employee | One central source for the whole team |
Frequently asked questions
Answers on usage and legal aspects.
Question not answered here? Every step is explained in the help centre.
Send us a messageHow high is the mini-job earnings threshold in 2026?
603 euros a month, so 7,236 euros a year. The threshold is tied to the statutory minimum wage and is calculated as 130 times the minimum wage divided by three, rounded up to whole euros (section 8 (1a) SGB IV). At an hourly rate of 13.90 euros that is about 43 hours a month.
How high is the minimum wage in 2026?
13.90 euros per hour since 1 January 2026. On 1 January 2027 it rises to 14.60 euros. Anyone paying less breaches the Minimum Wage Act, regardless of what the employment contract says.
May the threshold be exceeded?
Occasionally and unforeseeably yes, as a rule in up to two calendar months within a year, with earnings then not exceeding twice the threshold. Anyone who exceeds it as a matter of course is no longer in marginal employment. Clarify the individual case with payroll before the shift is planned.
Do I have to record working time for mini-jobs?
Yes. Section 17 (1) MiLoG applies to marginally employed staff regardless of industry. The start, end and duration of daily working time must be recorded no later than seven calendar days after the work was done and kept for two years.
Are mini-jobbers entitled to holiday and continued pay?
Yes. Marginally employed staff are employees with all employment law entitlements: paid annual leave under the Federal Holiday Act, continued pay when sick and on public holidays, and notice periods. The holiday entitlement follows from the number of working days a week.
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.
- No credit card required
- Ready quickly
- Cancel monthly
- Full access to every feature
Ready in 5 minutes, no credit card