Generate Timesheet from Daily Time Records (using finger scanner In/Out)

Using DTR Biometric Finger Scanner application system time-in/time-out we create module process to generate Timesheet for every employee. Before generating employee timesheet cut-off date make it sure that all pending approval of leave & overtime covered on that payroll cut-off date that filed by the employee’s should be approved by designated department. The report monitoring status of Leave & Overtime will help you to identify head department with pending approval to prompt them to approve.

During the processing of time logs the attendance date will be mark-up with source tag:

  • BM => In/Out from Finger Scanner.
  • LS => In/Out from the manual data entry of locator slip.
  • HT => In/Out from Holiday Table.
  • SL => In/Out from Sick Leave.
  • VL => In/Out from Vacation Leave.

Also the date days will tag as based on the table entry of Holidays except Regular Day (RD) and Rest Day (RO):

  • RD => Regular Day
  • SH => Special Holiday
  • LH => Regular Holiday
  • DH => Double Holiday
  • RO => Rest Day

Mark-up tags are important rule of program logic during the processing of payroll computation and also gives an idea to the employee or head department who approved the timesheet. After the processing of Generate Timesheet module the system will notify message on employee dashboard account to review the timesheet. All invalid record is editable with corresponding reason while valid record is automatically lock by the system to eliminate changes. If employee review and approved their timesheet will notify the head department for approval. All approved timesheet will be available for payroll processing.

Sample of Valid Timesheet

Sample of Valid Timesheet

Sample of Invalid Timesheet

Sample of Invalid Timesheet

Sample of Approved Timesheet by Head Department

Sample of Approved Timesheet by Head Department