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.
- 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
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. MetronHR shows the position continuously, warns before the threshold is passed and gives the tax firm the finished overview at the end of the month, with nobody collecting sheets.
In comparison
Excel template
Manual upkeep • no workflows • no reminders • copy anew for every employee
MetronHR
Automatic calculations • approval workflow • reminders • one central source for the whole team
Frequently asked questions
Answers on usage and legal aspects.
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.
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.
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.
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.
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.
Question not answered here? Every step is explained in the help centre.
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.
Ready in 5 minutes, no credit card