Monthly Timesheet With Approval Status in Excel

This monthly timesheet template can be used to record an employee’s working hours on a monthly basis. It features section for approval status, allowing managers/supervisors to approve the timesheet for the employee. It is downloadable and printable in Excel format.

This monthly timesheet includes sections for company name, employee name, employee ID, start date, end date, date, day of week, time in, time out, lunch, total hours, status, weekly total, and total billable hours. The lowermost part also displays a field where the manager can attach his/her signature upon approval of the timesheet.

This Excel monthly timecard features formulas that automatically calculate the total hours based on the time in and time out details of the employee. The formulas featured made this timesheet convenient to use as you don’t need to perform any manual calculations. Moreover, this template considers lunch unpaid, therefore, you can leave this column blank, or if preferred, you can enter the number of minutes or hours (e.g., 1 hour). Whether or not you input your lunch hours will not affect the calculations of this timesheet.

Get this free printable monthly timesheet template to easily track your employee’s work hours now. It’s free to use, edit, print, or download. If you want to create your own monthly timesheet, you can also use this form as reference.

Instructions in using the Timesheet:

1. Enter company name and employee details.

2. Enter start date of the work week. Once start date is entered, the remaining dates for the four-week period will be automatically generated, along with the end date.

3. Enter time in and time out details for each day in a sample format of 8 am or 8:30 am. When entering the time in and time out in Excel timesheet, make sure you put a space between the time and the word AM/PM for the formulas to work. Example format: 8 am, 1:30 pm.

4. If preferred, enter lunch time. Enter lunch time under lunch column only if desired. Entering this data will not affect the calculation as this timesheet considers lunch unpaid. However, if you want to add these figures, feel free to do so. You can input the lunch duration using this format (e.g., 1 hour).

5. Review, email, or print the completed timesheet.