Contractor Crew Timesheet & Payroll Hours Calculator - Excel & Google Sheets (Overtime, Time Cards, Labor by Job)

Stop adding up crew hours on the back of a receipt. Log each worker's start and end times, and this workbook works out daily hours, regular and overtime hours, gross pay and labor cost per job automatically. It works in Excel and Google Sheets.

WHAT'S INCLUDED

• Crew Timesheet & Payroll Hours Calculator (.xlsx), a blank copy ready to use, with 7 tabs:

- Start Here: settings and step-by-step instructions

- Crew: up to 25 workers with role, hourly rate, W-2 Employee or 1099 Helper, and hours this week and all time

- Jobs: up to 50 jobs or customers, used as a dropdown

- Time Log: 1,000 rows with date, worker and job dropdowns, start and end time, and unpaid break. Hours calculate automatically, overnight shifts included, or you can type hours by hand

- Weekly Payroll: hours for each day of the week, total, regular, overtime, rate, regular pay, OT pay and gross pay for every worker, plus crew totals

- Time Card: pick a worker to get a printable one-page time card with signature lines

- Labor by Job: crew hours and labor dollars per job, for this week and all time

- Payroll History: 52 weeks of crew hours and labor cost

• A filled-in EXAMPLE copy with a sample crew so you can see how it works

OVERTIME, DONE FOR YOU

• Weekly overtime threshold is editable and pre-set to 40 hours

• OT multiplier is editable and pre-set to 1.5x

• Optional daily overtime for states that use it (for example, over 8 hours a day)

• 1099 helpers are paid straight time

• Overtime hours are flagged in red

FEATURES

• Working formulas with no macros

• Yellow means type here, grey means calculated. Sheets are protected with no password, so you can customize them

• Pick any pay week by changing one date

• Print-ready on US Letter

WHO IT'S FOR

Handymen, remodelers, general contractors, painters, landscapers and trade contractors with a small crew who want simple, accurate weekly hours without paying for a monthly payroll app.

PLEASE NOTE

This is a timekeeping and recordkeeping tool. It does not calculate tax withholding or run payroll, and it isn't legal or tax advice. Overtime rules vary by state and worker type, so check your state's rules.

INSTANT DOWNLOAD

You'll get one ZIP file right after purchase. This is a digital download, and no physical item will be shipped.

Designed with AI assistance