Hourly Shift & Paycheck Tracker with Overtime

For retail, hospitality, warehouse, care and other hourly workers. Log your shifts and breaks and the sheet adds up your hours, splits weekly overtime and estimates your gross pay for each pay period, so you can compare it with your pay stub.

★ WHAT YOU GET

• 1 spreadsheet (.xlsx) with 6 tabs: Start here, Totals, Setup, Shifts (500 rows), Weeks (60), Paychecks (30 pay periods)

• Setup: hourly rate, weekly overtime threshold, overtime multiplier, first day of your pay week, paid weekly or every 2 weeks

• Shifts: start, end, unpaid break, tips; hours calculate automatically (overnight shifts handled)

• Weeks: regular vs overtime hours and estimated pay. Paychecks: estimated gross per period vs the gross on your pay stub, with any difference highlighted

★ COMPATIBILITY

Made for Google Sheets (free Google account; upload the .xlsx to Google Drive, then open it with Google Sheets), Microsoft Excel 2010 or later, and LibreOffice Calc. Formulas were checked for Google Sheets and Excel compatibility (standard functions only, no macros, no add-ins) and tested in LibreOffice Calc. Unzip the download first (double-click on most computers). Best used on a computer or tablet. Enter dates as real dates (e.g. 3/15/2027 or 15/03/2027).

★ GOOD TO KNOW

• Estimates before tax and deductions, using simple weekly overtime only. Daily overtime, night/weekend/holiday rates and local rules are not included.

• Not legal or financial advice. Check your contract or employer if the numbers don't match.

• Works in any single currency.

★ Personal use only: for your own work records. Please don't share, resell or redistribute the files.

★ Digital download: nothing physical is shipped. You get one .zip file; unzip it to get the files.

★ 14-day promise: if a file is faulty or not as described, contact me within 14 days and I'll fix it or refund you.

Made with the help of AI tools (drafting text, layouts and formulas); I chose the content and reviewed and edited every file.