Free Timesheet & Attendance Generator — hours, overtime and absences

How to fill in a timesheet

Build a whole month of day rows in one click, then correct the exceptions.

1. Add the employee and period

   On the Employee tab enter the name, employee ID and the period the sheet covers, plus who approves it.

2. Generate the month

   On the Days tab pick a month and press Generate days. Every date appears with Saturdays and Sundays already marked as weekend, so you only change the exceptions.

3. Correct the exceptions

   Change any day's status to leave, sick leave, work from home, late or absent. Hours stop counting on non-working days, and every status is tallied into the attendance summary at the bottom.

4. Set the hours rules, then download

   On the Hours tab set your standard day and overtime multiplier — anything beyond the standard day becomes overtime. Optionally add an hourly rate to show pay. Then click Download PDF.

Overnight shifts are handled: enter 22:00 to 06:00 and the tool works out eight hours rather than a negative span.

Timesheet and attendance in one document

A browser-based timesheet for small teams, contractors and agencies that need hours recorded and approved without buying time-tracking software.

What a timesheet should record

A timesheet is the record of what an employee or contractor actually worked in a period. It matters for three reasons: paying people correctly, billing clients accurately, and proving compliance with working-hours rules if anyone asks.

• The person and the period — name, employee ID and the month or week covered
• One row per day, including the days not worked, so gaps are explained rather than missing
• Start and end times, and unpaid break time deducted
• A status per day — present, remote, leave, sick, holiday, absent — which is what turns a timesheet into an attendance record
• Regular and overtime hours separated, since they are usually paid at different rates
• What the time was spent on, if you bill clients by project
• Approval — an unapproved timesheet settles nothing in a dispute

Timesheet or attendance report?

A timesheet answers "how many hours?" and an attendance report answers "who was here?". They are usually kept separately and then reconciled, which is where errors creep in. This tool produces both from the same rows: the table is the timesheet, the counts underneath are the attendance summary, and they cannot disagree because they come from the same data.

Getting overtime right

The tool splits anything beyond your standard day into overtime and applies your multiplier. What it does not know is your local law: overtime thresholds, mandatory rest days, maximum weekly hours and who is exempt all vary by country and often by contract. In Singapore, for example, overtime rules under the Employment Act apply to some employees and not others. Set the standard day and multiplier to match your rules, and check the result against your own obligations.

More free tools