Skip to content

Overtime tracking spreadsheet

A ready-made template to record, add up and justify overtime per employee, with the official data that shows why this cannot be left loose in an uncontrolled spreadsheet.

288,000 cases

Overtime was the most recurrent topic in new labor court cases in Brazil between Jan and Jul 2023, with 288,000 cases filed. Official data from the TST (Brazil's Superior Labor Court) (it measures the volume of cases, not the value of liabilities in R$).

-91% overtime

That is the reduction CPFL achieved by moving away from manual control and automating working-hours tracking. See the full case study.

No number in this material estimates financial exposure in reais. The figures above cite the volume of cases (TST) and a result measured at a client (CPFL), never a forecast of liabilities.

What is inside the spreadsheet

Daily record of clock-in, clock-out and break per employee
Automatic calculation of overtime and time bank
Visual alerts for people close to the legal limit
Monthly summary by employee and by team, ready for audit

This spreadsheet is a structured starting point for those who still track working hours manually. It is not a personalized legal calculation and does not replace the analysis of your labor compliance team.

Get the spreadsheet by email

Enter your work email and we send the file straight to you, with no public download.

We use your email only to send this material and, if it makes sense, to talk about the Workday Assistant. No spam.

Want to go beyond the spreadsheet?

The Workday Assistant locks the computer outside the agreed working hours and reduces overtime automatically, with no reliance on spreadsheets or goodwill.

Meet the Workday Assistant