eTimeTrack Lite Help Manual
eTimeTrack Lite Help Manual
eTimeTrack Lite Help Manual
1
eSSL Time Attendance and Payroll Management Help Manual
Table of Contents
Attendance Register........................................................................................................................................................................... 32
OT Register......................................................................................................................................................................................... 33
Device Details..................................................................................................................................................................................... 36
Upload Users...................................................................................................................................................................................... 39
Import From etimeTrack form will allows you import Employee and Log records from eTimeTrack software.................................... 41
Daily Attendance................................................................................................................................................................................ 44
Yearly Attendance.............................................................................................................................................................................. 54
Generate Matrix................................................................................................................................................................................. 68
3
eSSL Time Attendance and Payroll Management Help Manual
eSSL - eTimeTrack-Lite Software allows companies to track and evaluate the performance and work activities of
employees using a single software application. Time & Attendance Software enables employees to store, track and
organize the most important employee time related information in single place. The required information to track and
monitor employee activities and management processes is available on a computer. This can also be invaluable for
ensuring regulatory compliance with working regulations and proof of attendance.
4
eSSL Time Attendance and Payroll Management Help Manual
5
eSSL Time Attendance and Payroll Management Help Manual
The Database Settings link allows user to change the database settings.
Database Settings
Database Settings Form allows you to Change the Database Settings. This Software Supports Ms Access, Sql Server and
Oracle Database.
6
eSSL Time Attendance and Payroll Management Help Manual
Change password
Change password Form allows the Login User to change their Login password.
7
eSSL Time Attendance and Payroll Management Help Manual
• Whether Employee Code and Employee Code Stored in Device are same for application or not.
• Whether to allow a Fixed Shift for application or not. If Fixed Shift is checked then it will disable all shift Related
options like Shift Details, Shift calendar, Employee Shift , Department Shift etc.
• “Attendance Year starts on” Field will allows to set the start Attendance date and Month from which Attendance
calculation has to start. For e.g. If you are willing to generate monthly report then it will take that Attendance date as
Start of the month and if you are willing to generate Yearly Report then it will take Attendance date and Month as
start of year
• “Minimum difference between two Punches” Field will allow to set the difference between two punches .If the
difference between punches is greater than specified minutes then it will discard the later punch.
• “Punch Begin duration” Field is used to set maximum allowed time before Shift Begin Time.
• If Employee does not have any assigned shift then whether to consider the shift of previous day or Auto Shift.
Auto Shift will take the shift according to Firth Punch and Shift Begin Time.
• Whether to take Auto backup after Specified Days and Save it to specified Path or not. This Feature is allowed only
for Ms Access Database.
8
eSSL Time Attendance and Payroll Management Help Manual
User Management
This Form will display the List of all Users. It allows Login User to Add, Edit and Delete the users, if he has permission of
“Edit Users”
User Details consists of Login name, password, Role Name, Accessible companies and permission allowed to user. If user
“Is Admin” then he will able to access all Permission. ”Can access invisible Items” check box is used to give permission of
accessing Invisible companies.
9
eSSL Time Attendance and Payroll Management Help Manual
Company Management
eSSL eTimeTrack Lite Software support multiple companies. This form will display the List of Companies which is
accessible By Login User. It allows Login User to Add, Edit and Delete the Companies if he has the permission of “Edit
Companies”
Company Details Consist of Company Name, Short Name, email, Website and Address. ” Visible to All “ Check box is used
to make Invisible company which will be accessed by only the users who has permission to access Invisible Companies.
10
eSSL Time Attendance and Payroll Management Help Manual
Department Management
eSSL eTimeTrack Lite Software support multiple department. This form will display the List of departments. It allows Login
User to Add, Edit and Delete the departments ,if he has the permission of “Edit departments”.
11
eSSL Time Attendance and Payroll Management Help Manual
Category Details Consist of Category Name, short name and Attendance Calculation Details.
• OT Formula is used to set Method to calculate Overtime. There are Three types of OT^ Formula:.OT Not applicable
is used to ignore Overtime. Out Punch-ShiftEndTime will Calculate OT By subtracting Out Time (Last out Punch)
from Shift End Time if Out Time is Greater Than Shift End Time.
• Total Duration –Shift Duration will Calculate OT By subtracting Shift Duration from Total work duration.
• Early Coming + Late going will Calculate OT Adding early Coming minutes and Late Going Minutes which is
depended on Shift Begin Time and End Time.
• “Neglect Last In Punch” is used when there is no missed Out punch it will either make Out punch according to its
Shift end time or. Discard The Last In Punch.
• Grace Time is Used to neglect Late coming \ Early going Minutes if it is less than Specified Minutes.
• Weekly Off1 & Weekly Off2 is Used to set weekly off.
• “Consider Early Coming Punch” will allow you to set whether to take Punches before Shift Begin Time or not.
• “Consider Late going Punch” will allow you to set whether to take Punches after Shift End Time or not.
• “Consider Only First And Last Punch in Att Calculation” is used to set whether to calculate attendance by only First
And Last Punch or by I All punches.
• “Deduct Break Hours from Work duration” is used to set whether to deduct break hours from Work Hours or Not.
This Break Hours will be deducted according to Shift Break1 and Break2.
• “Calculate Half Day If Work duration Less Than” is used to set whether to mark half day Present or not if work
Duration is Less than specified Minutes.
• “Calculate Absent If Work duration Less Than” is used to set whether to mark Absent or not if work Duration is Less
than specified Minutes.
• “Marked Weekly Off and Holiday as Absent for Prefix day is Absent” is Used to mark Weekly off and holiday as
Absent if employee is Absent on Previous day .
12
eSSL Time Attendance and Payroll Management Help Manual
13
eSSL Time Attendance and Payroll Management Help Manual
Shift Details consists of Shift Name, Short Name, Begin Time, End Time, Break1 Details, and Break 2 Details.
14
eSSL Time Attendance and Payroll Management Help Manual
15
eSSL Time Attendance and Payroll Management Help Manual
Scheduler
Scheduler will allow you to schedule the Shift calendar. You can assign any shift or Weekly Off in Scheduler. This Form also
allows you assign Shift on Multiple dates in single shot.
16
eSSL Time Attendance and Payroll Management Help Manual
Holiday Management
This form will display the List of all Holidays. It allows Login User to Add, Edit and Delete the Holidays if he has the
permission of “Edit Holiday”. It also allows you to filter Holiday according to Company.
Holidays Details consist of Holiday Name, Company Name Date and description.
17
eSSL Time Attendance and Payroll Management Help Manual
Leave Type Details Consist of Leave type Name, Short Name, Yearly Limit, Carry Forward Limit, Gender to which leave is
Applicable. Allow negative balance and description. Allow Negative Balance Field specifiy whether allow to assign leave
entries Greater a than Yearly Limit or not.
18
eSSL Time Attendance and Payroll Management Help Manual
Employee Master
This form will display the List of all Employees. It allows Login User to Add, Edit and Delete the Leave Types if he has the
permission of “Edit Employee”. It allows you to filter Employee according to Employee Name, Code, Company, Department,
Designation, Employment Type, Status, Category and Location.
This form also allows to Update Multiple Employee Details which will you find in right click menu option.
Employee Details consists of Employee name, code, employee Code in device, Company, department, designation, and
employment type, Date of Joining, Date of Confirmation, Date of Resigning, Gender, Status i.e. Working or Resigned,
Category, Location, Photo.
Employee other details consist of employee Personal details Like Father Name, Mother Name, Date of Birth, Birth Place,
Address, Nominees.
“Biometric and RFID Details” Link is used to Load and Store Employee Fingerprint, Face and Card Details.
“Leave Summary” Link is used to get Employee Leave summary i.e. No of Leave taken, Standard allowed Leaves which
specified in Yearly Limit of Leave type, Actual Allowed leaves which you can edit also.
“Other Details “link is used to Load and Store Employee Other Details.
19
eSSL Time Attendance and Payroll Management Help Manual
20
eSSL Time Attendance and Payroll Management Help Manual
Register new Fingerprint allows you to Store Employee fingerprint, it will first ask you Fingerprint No. to be Register and
take fingerprint From Sensor. .It will capture Fingerprint from Biometric Fingerprint sensor.
21
eSSL Time Attendance and Payroll Management Help Manual
To Edit Actual allowed Leave you have to select any cell of Column “Allowed Leave (actual)” and then click right. It will open
the Update Leave Details Form through that you can update allowed Leaves.
22
eSSL Time Attendance and Payroll Management Help Manual
Schedule Shift
Shift scheduling is assigning either Shift or Shift Calendar to Employee and Department. If you want to assign shift to
particular Employee then you can use employee shift and If want to assign to whole Department of Particular Company then
you can use Department Shift. Both Employee shift and Department Shift can be Assign for Multiple Days.
Department Shift
This form will display the List of all assigned Shift to Departments. It allows Login User to Add, Edit and Delete the
Department shifts if he has the permission of “Edit Department Shift”. It allows you to search Employee Shift according to
Employee Name, Code, From Date and To date, Company and Department. Department shift details consists of
Department name, Company name, Shift Type ,Shift Name according to Shift Type From date and To date.
23
eSSL Time Attendance and Payroll Management Help Manual
Employee Shift
This form will display the List of all assigned Shift to Employees. It allows Login User to Add, Edit and Delete the Employees
shifts if he has the permission of “Edit Employee Shift”. It allows you to search Employee Shift according to Employee
Name, Code, From Date and To Date, Assigned Shift, Company, Department, Designation, Employment Type, status,
category and Location.
Employees shift details consists of Shift Type ,Shift Name according to Shift Type From date and To date. You can assign
shift to multiple employee.
24
eSSL Time Attendance and Payroll Management Help Manual
25
eSSL Time Attendance and Payroll Management Help Manual
26
eSSL Time Attendance and Payroll Management Help Manual
This form will allows assigning of leaves to multiple Employees for Multiple days either full day or half day or ¾ Day or ¼
day with specific Leave type.
This assigned leave will be used in calculation if is approved otherwise it will neglected
27
eSSL Time Attendance and Payroll Management Help Manual
• This form will allow assigning of outdoor entry to multiple Employees for Multiple dates.
• This form will also ask for Duration of Outdoor entries (in minutes) and Begin And End Time.
• This assigned leave will be used in calculation if is approved otherwise it will neglected.
28
eSSL Time Attendance and Payroll Management Help Manual
29
eSSL Time Attendance and Payroll Management Help Manual
This Form will display the all Logs according to specified From and To date. This Form will also allow you Add Logs
Manually to multiple date and you can Edit and delete only manually added logs. This will also allows you filter Logs
according to all employee Basic Details and Device. Add manual entries will require Direction and Log Date & Time.
30
eSSL Time Attendance and Payroll Management Help Manual
31
eSSL Time Attendance and Payroll Management Help Manual
eTimeTrackLite Registers
eTimeTrackLite Registers will show Attendance Details or Leave summary. It will also allow you export record to excel
Sheet and filter record according to employee Basic Details.
Attendance Register
This Register will show One Month Attendance status of all Employees. Status can be absent, present, weekly off, holiday,
on Leave, on outdoor entries and Combination of these also. Abbreviations for Status are:
A - Absent
P - Present
CL, PL, SL – Leave Types
OD - Out Door Duty
WO - Weekly Off
H – Holiday
32
eSSL Time Attendance and Payroll Management Help Manual
OT Register
This Register will show One Month overtime work duration of all Employees .This Register also allow you to Change
Overtime of multiple Employee by right click menu option. Update Overtime Form will ask you Overtime Work Duration (in
minutes) and to preserve it or not while recalculation of attendance. if you will not check this check Box will discard your
edited overtime when you will calculate attendance again and if want to remove Preserve overtime you first select the cell
which you don’t want to preserve and right click and click on “Don’t Preserve”. The cell with superscript with ( ¹ ) shows this
overtime is preserved.
33
eSSL Time Attendance and Payroll Management Help Manual
Leave Register
This Register will show yearly Leave Summary ( Leave Taken , Leave Current Balance , Leave Balance At year Start) of all
Employees .This Register also allow you to Change Leave Allowed at the Start of the Year for multiple Employee by right
click menu option ,The right click menu will be enable only when you Check “Leave balance at Year Begin” button.
This form also has Feature of Import Leave Balance From excel Sheet.
34
eSSL Time Attendance and Payroll Management Help Manual
35
eSSL Time Attendance and Payroll Management Help Manual
Download Logs
• This form will show you all Device List. The Right click menu option will allow you to Add, Edit and Delete Devices.
• “Start Download” button will start downloading of logs from selected Device if it’s connected.
• “Download Logs from Beginning” check box will allows you download all logs which are in device otherwise it will
download after Last Downloaded log date.
• “Download USB” will allow you to download the logs from “.dat “file.
Device Details
Device Details Consist of Device Name, Short Name, Serial No., Direction (In, Out, Alt In out, system In/Out) , IP address,
Connection Type that will be either Tcp/IP or USB and Comm key that is device communication password generally its
default value in device is “0”.
36
eSSL Time Attendance and Payroll Management Help Manual
Update device form will allows to update device information , Set system Date as Device Date and Time, Download Users
From Device and Store this into Database, Change Device IP Address ,View Device Status, Upload Users to Device,
Restart the device, clear all admin Privilege From Device.
Users in Device will show all existing user in Device with its details like user Name in Database an in device, Privilege,card
No, Password, Finger Print and Face
37
eSSL Time Attendance and Payroll Management Help Manual
38
eSSL Time Attendance and Payroll Management Help Manual
Upload Users
This form will upload User Details, Card no., Fingerprint and Faces to device.
Download Users
This form will Download Users Details, Card no., Fingerprint and Faces From device and store these to database.
39
eSSL Time Attendance and Payroll Management Help Manual
Schedule Downloader
To schedule Downloader setup is providing one more .exe “eSSL Online Downloader”. By Clicking on settings Link Button
You can schedule Downloader
40
eSSL Time Attendance and Payroll Management Help Manual
eTimeTrackLite Utilities
41
eSSL Time Attendance and Payroll Management Help Manual
Backup database
This from will allows you take your database backup on specified Path. This Feature is only available For Ms-Access
database.
Restore old Logs will Restore Log Records from “.bck ” File.
42
eSSL Time Attendance and Payroll Management Help Manual
eTimeTrackLite Reports
eTimeTrackLite generating report forms also allows you to various report like and filter report data according to company,
Department and employee Details.
43
eSSL Time Attendance and Payroll Management Help Manual
Daily Attendance
Daily Attendance Reports are: -
• Basic Attendance Report
• Detailed Attendance Report
• Summary Report
• CSV Export
Daily Attendance report can be filter according status i.e. Present. Absent, Late, Coming, Early Going, On leave, On
Outdoor Duty, Short worked, extra worked, Missed out punch.
44
eSSL Time Attendance and Payroll Management Help Manual
45
eSSL Time Attendance and Payroll Management Help Manual
46
eSSL Time Attendance and Payroll Management Help Manual
47
eSSL Time Attendance and Payroll Management Help Manual
Monthly Attendance
48
eSSL Time Attendance and Payroll Management Help Manual
49
eSSL Time Attendance and Payroll Management Help Manual
50
eSSL Time Attendance and Payroll Management Help Manual
51
eSSL Time Attendance and Payroll Management Help Manual
52
eSSL Time Attendance and Payroll Management Help Manual
53
eSSL Time Attendance and Payroll Management Help Manual
Yearly Attendance
Yearly attendance report will generate report which will show whole year attendance records if year is current year than it
will generate till current date only. It will take attendance start date and month which is specified in master settings.
54
eSSL Time Attendance and Payroll Management Help Manual
55
eSSL Time Attendance and Payroll Management Help Manual
Leave Summary
It will shows leave taken balance allowed Leave employee wise of whole year.
56
eSSL Time Attendance and Payroll Management Help Manual
57
eSSL Time Attendance and Payroll Management Help Manual
58
eSSL Time Attendance and Payroll Management Help Manual
59
eSSL Time Attendance and Payroll Management Help Manual
Logs Records
This Report will show all log records and this can be generate By Employee Wise, Device wise and Date wise
60
eSSL Time Attendance and Payroll Management Help Manual
61
eSSL Time Attendance and Payroll Management Help Manual
62
eSSL Time Attendance and Payroll Management Help Manual
63
eSSL Time Attendance and Payroll Management Help Manual
64
eSSL Time Attendance and Payroll Management Help Manual
65
eSSL Time Attendance and Payroll Management Help Manual
66
eSSL Time Attendance and Payroll Management Help Manual
67
eSSL Time Attendance and Payroll Management Help Manual
Generate Matrix
This report will show present employee count for department or company for each employment Type
68
eSSL Time Attendance and Payroll Management Help Manual
69
eSSL Time Attendance and Payroll Management Help Manual
Generate Graph
Graphical report shows Attendance Status i.e. Absent, Present, Early going/Late coming in Pie Graph . It can be generate
by employee Wise, department wise for each company and company wise.
70
eSSL Time Attendance and Payroll Management Help Manual
71
eSSL Time Attendance and Payroll Management Help Manual
72
eSSL Time Attendance and Payroll Management Help Manual
Employee Records
This Report shows All employee details .It can Be generated for both working and Non working employee.
73
eSSL Time Attendance and Payroll Management Help Manual
74
eSSL Time Attendance and Payroll Management Help Manual
Generate Memo
This Report will Generate Memo for Absentees, Early goers and Late Comers for specified date.
This Report Can be generated for individual employee or as Summary which shows list of employee
75
eSSL Time Attendance and Payroll Management Help Manual
76
eSSL Time Attendance and Payroll Management Help Manual
CSV Exports
This Form will allows you Export Attendance Logs in custom Format to Excel Sheet
This Form will allows you export Logs in Custom Format to Excel Sheet
77
eSSL Time Attendance and Payroll Management Help Manual
This Form allows you to export logs in third Party Payroll software format.
This Form allows you to export Device logs in custom format at specified path.
78