Timesheet Generator

How to use the timesheet generator

1. Enter the employee name, the employer, and the date the week ends. Seven rows are created for you, Monday to Sunday.
2. Set the hourly rate, the weekly hours at which overtime begins (38 is the common Australian full-time figure), and the overtime multiplier.
3. For each day, enter the start time, finish time and unpaid break in minutes. Daily hours are calculated instantly.
4. Check the summary — total hours, ordinary hours, overtime hours and total pay all update as you type.
5. Click Download PDF for a signed-off timesheet, or Download CSV to import the hours into a spreadsheet or payroll system.

Why use ZillaKit's timesheet generator?

Working out hours by hand is where payroll mistakes start. Ten past seven to half four with a forty-minute break is not a number most people can add up accurately fourteen times a week, and small errors compound into either an underpaid worker or an overpaid wage bill. This tool does the arithmetic exactly: finish minus start, minus the unpaid break, converted to decimal hours, then split into ordinary and overtime hours against your weekly threshold and priced at the correct rate for each.

It handles the cases that break spreadsheets. Overnight shifts that finish after midnight are recognised automatically rather than producing negative hours. Breaks are deducted in minutes, which is how people actually record them. The overtime rate is derived from your base rate and multiplier but stays editable, because plenty of awards and agreements set a flat figure instead. You can add or remove days, so it works for a five-day week, a seven-day roster or a single shift.

The PDF is a proper timesheet: employee, employer, week ending, a day-by-day table, the hours and pay summary, and signature lines for the employee and the supervisor. The CSV opens straight into Excel, Google Sheets or a payroll import. Everything runs in your browser — no employee names, no rates and no hours are ever uploaded, which matters because payroll data is some of the most sensitive information a business handles.

FAQ

How are the hours calculated?

Hours for a day equal the finish time minus the start time, minus the unpaid break in minutes, expressed as decimal hours. For example 7:00 to 15:30 with a 30 minute break is 8.00 hours.

How does the overtime split work?

All the hours in the week are added up. Hours up to the threshold you set are paid at the ordinary rate; every hour beyond it is paid at the overtime rate. With a 38 hour threshold and 45 hours worked, that is 38 ordinary hours and 7 overtime hours.

Does it handle night shifts that finish after midnight?

Yes. If the finish time is earlier than the start time, the shift is treated as crossing midnight, so 22:00 to 06:00 with a 30 minute break comes out as 7.50 hours rather than a negative number.

Can I export the timesheet to Excel?

Yes. The CSV download opens directly in Excel, Google Sheets, Numbers or a payroll import, with one row per day plus a totals row.

Is this a legally valid timesheet?

The PDF records everything a timesheet normally needs — employee, employer, dates, times, breaks, hours and signature lines — but your obligations depend on your jurisdiction, award or agreement. Check your local record-keeping rules and keep the signed copy.

Is my payroll data uploaded anywhere?

No. Names, rates and hours stay in your browser, and the PDF and CSV are created on your device. Your entries are saved only in your own browser so you do not lose them on refresh.