Documentation is everything. Even if you work on a fixed salary, documenting the hours worked is important.
Many keep a handwritten time log. That is not wrong, but it can turn into additional work in the case of claims for reimbursement in court.
As I know from my own experience, the judges would prefer it to be readable. Ideally as a well-organized table. For a friend, I prepared the hours and put them into a clean table with all the data, so the judge wouldn’t have to do a lot of work.
This table I created many years ago. Since it is an Excel table or more precisely a table for LibreOffice Calc, I recommend that you use the free LibreOffice on your laptop / PC or on your tablet the free Collabora Office .
The table itself can be downloaded here .
You enter the working hours from start to finish into the table. The rest is automatically calculated.
You should not be surprised that the calculation of the salary results in a different value than what you actually earn.
The table calculates the salary based on the current minimum wage of 12,82 €. The result is gross. That is before tax and social security deductions.
A few tricks I included
in the table. So you can use the table for each year again. You will find a worksheet named “Feiertage” (Holidays). There, you only need to change the current year, and all federal holidays in the respective month will be considered and displayed. Regional holidays are not included.
Currently, as already mentioned, the current minimum wage of 12,82 € is used as the basis for salary calculation. Those with a different hourly wage can also change this in the “Feiertage” sheet.
What the table cannot do:
Currently, the table cannot calculate in 24-hour periods. So not from 22:00 p.m. to Monday morning at 08:00 a.m.
It is therefore only calculated from 00:00 to 24:00.
Travel expenses of 28 € are also not automatically included. These must be manually entered in the “Spesen” column.
No support for self-inflicted damages
The table is designed so that you can change everything. So also the formulas that calculate the individual times. Change something here only if you know what you are doing. I won’t fix it for you again.
