Review before download employees overtime hour through excel tracker or small software. You can print this easily with respect to any employee overtime required after just enter their ID. Let’s check out how this template can helpful to you? This sheet is year 2017, Month January you can edit and set month accordingly.

The template is prepared in excel tool to allow easy data entry and fast and accurate calculations. It consists of following 4 sheets:

Welcome screen

This is the introduction part of the summary showing what lies inside the template. It is already filled and designed, however you are just require to enter following information:

  • Company name
  • Parts of templates
  • Company address
  • Phone
  • Email
  • Address

Note:- All this information will be adjusted automatically.

Employee In- Out time Record Sheet

This part of the template shows in and out timing of the employee, as well as total working hours in the specific month and hours worked by specific employee. It quickly shows overtime worked by specific employee and fills automatically from employee database. It provides:

  • Data for 1 month
  • You can select any month for checking overtime record.
  • Just enter the total working hours in specific day, and add employee in and out time.
  • Monthly hours required, overtime hours and total hours worked will be automatically filled.

Employee Database Sheet

This part of the template is for the recording purpose. It must be filled manually and carefully as all the rest of the worksheets are filled from information in this section. It consists of:

  • Employee id
  • Employee name
  • Designation
  • Salary
  • Overtime rate/h
  • Contact
  • Address

Note: It must be cross checked twice.

Employee Overtime Record Summary

This part of the template provides quick summary for the overtime worked by the employee in the specific time duration. It provides quick overview about total hours required, total hours duty, total overtime hours and number of working days.

Total salary paid to employee in specific month is broken down into basic salary, rate/h, total overtime hours and total overtime pay.  For customize employees overtime template excel you must contact us.

Leave a Reply

Your email address will not be published. Required fields are marked *