Monthly timesheet template
Enter the start and finish time and the break for each working day. The timesheet adds up the hours, splits off overtime above your daily limit and works out the pay at your hourly and overtime rates.
Monthly timesheet
Download template (9 KB)The file contains only formulas and example numbers — no macros, no links, nothing that connects to the internet.
What's inside
- 31 rows, one per day, with weekday shown
- Night shifts across midnight handled
- Overtime above a daily limit, at its own rate
- Totals for hours, overtime and pay
Prefer to calculate online? Use the Hours calculator.
How to use it
- Download the file with the button above and open it in Excel, Google Sheets (File → Import), LibreOffice or Numbers.
- Fill in the yellow cells — they hold your own numbers. The example values show the expected format.
- Everything else is worked out by formulas. Save a copy whenever you want to keep a snapshot.
Common questions
How do I enter times?
As hours and minutes, like 08:30 or 17:45. Leave the row empty on days off.
Can I use it for several employees?
Make a copy of the sheet for each person — right-click the sheet tab and choose Duplicate or Move or Copy.
More free templates
- Monthly budget plannerPlanned vs actual spending by category, with a 12-month overview.
- Expense trackerLog every purchase; totals by category and month appear automatically.
- Loan amortization scheduleMonthly payment, full schedule and the effect of extra payments.
- Debt snowball and avalanche plannerPayoff order, dates and interest for up to 10 debts.
- Savings goal trackerTrack up to 10 goals: progress bars and the monthly amount still needed.
- Net worth trackerAssets minus debts, month by month for a year, with a chart.
- Loan comparisonThree loan offers side by side: payment, total cost and APR with fees.
Ads on this page help keep Abacurio and these templates free. Thank you for your support.