Time Tracking and Leave Management System

Now G Suite users can use Apps Script based web application developed by SBC Technology to Manage Daily Timehsheet and Employee Leaves.

No need for third party Database. Google sheets are used as Database
Time sheet Management
Employees can log their timesheet in the system against the project they are working.
Leave Management
Employees will apply leave in the system which will be later approved by the assigned manager.
A Monthly report is generated automatically by the system for Work Time Tracking and Leaves applied by the employees
Various system properties can be configured in Configuration Spreadsheet.
General Properties
These are general properties used by the system to tell where is the database folder, what the report templates. What is yearly leave quota etc.

Leave types
These are the available leave categories for an employee. Employee will choose on of these when applying leave in the system.

Projects
These are the projects which are going on in the company. Users will be assigned one or more projectors. Employees will be able to log timesheet against assigned project only.

Holiday List
These the list of Holidays which will appear in the Time sheet screen. User’s can not enter time sheet on an holiday