Weekly Time & Expense Spreadsheet

I manage a driving school and do weekly payroll calculations for driving instructors.

I need a clean, reusable Excel workbook that lets me log regular and overtime hours alongside work-related costs (gas receipts with mileage), and any bonuses earned for each driving instructor (employee).

The sheet should automatically roll these daily entries into clear weekly totals, then feed monthly and yearly summaries so I can see trends at a glance without extra work. If you find a simple way to leave space for other cost or earnings categories (bonuses earned) that would be a plus.

Core requirements
• Input section for each instructor would be Name, Dates of Pay, Regular Hours, Overtime Hours, Regular Pay Rate, OT Pay Rate, Gas Expenses, Mileage, Average MPG, Cost/Mile, Miles Driven, and bonuses earned, comment section
• Built-in formulas that calculate weekly subtotals and push the data into separate summary tabs for month and year
• Drop-down lists or data validation where it helps prevent entry mistakes
• No macros required; pure Excel formulas, tables, and (if useful) PivotTables are fine

I’ll consider the job complete when I can open the file, enter sample data for a week, and instantly see correct figures on the weekly, monthly, and yearly pages.

I have include a screenshot of what I created, but need help making it easier to use.