Timesheet & Overtime Tracker | Google Sheets Template

Know exactly how many hours you worked, how much of it was overtime and what you should be paid. Type your clock in and clock out times and this Google Sheet works out breaks, hours, the regular and overtime split and your gross pay for every shift, pay period and month.

WHAT'S INSIDE (7 tabs)

- START HERE: quick setup steps and tips

- Dashboard: hours, overtime and earnings this pay period and this year, average hours per week, vacation days left, weekly regular vs overtime chart, overtime share, earnings per month, hours by job, hours by weekday and your recent pay periods

- Time Log: date, job or client, shift type, clock in, clock out and break, with automatic hours, regular and overtime split, rate, pay, pay period and week

- Pay Periods: every weekly, biweekly or monthly pay period with shifts, days worked, hours, overtime, overtime share, gross pay and average per hour

- Monthly Summary: twelve months side by side with a regular vs overtime chart

- Leave Tracker: vacation, sick and personal day allowances, days taken and days remaining, plus a days off log

- Setup: currency, default hourly rate, daily and weekly overtime limits, overtime multiplier, pay period, week start, auto break rule, jobs with their own rates and shift types with extra pay per hour

HOW IT WORKS

1. After purchase, download the PDF from the link in your confirmation email.

2. Click the link. Google asks you to make a copy, which is saved to your own Google Drive.

3. Set your rate and overtime rules once, then log each shift. Everything else updates automatically.

GOOD TO KNOW

- Two versions included: one with sample data to explore and a blank one ready for your own shifts

- Overtime by the day, by the week or both, with your own multiplier (for example 1.5×)

- Shifts past midnight, unpaid breaks and multiple jobs with different rates are all handled

- Gross pay is simple hours × rate. It is a record for checking your pay, not tax advice

- Works in any currency

- Works in Google Sheets on computer, tablet and phone. A free Google account is needed. Not made for Excel or Numbers

- Cells that calculate show a gentle warning if you try to edit them, so formulas are not deleted by accident

- This is a digital product. No physical item will be shipped

- For personal use only. Please do not share or resell

- Because this is a digital download, returns are not accepted. If you have any problem, reply to your download email and I will be happy to help