Report Generation

Contents

  1. 1 Data Filtering
    1. 1.1 Employee Filter
    2. 1.2 Date Filter
    3. 1.3 Employees of Interest
  2. 2 Reports
    1. 2.1 Daily Attendance Report
    2. 2.2 Employee Summary
    3. 2.3 Department Summary
    4. 2.4 Detail Report
    5. 2.5 Current Stats
    6. 2.6 In/Out Statistics
    7. 2.7 Late Report
    8. 2.8 Late Summary
    9. 2.9 Early Out Report
    10. 2.10 Manual Entry
    11. 2.11 Single Entry
    12. 2.12 Exceptions
    13. 2.13 Transaction Log
    14. 2.14 Salary Slip Data
    15. 2.15 Pay Report 
    16. 2.16 Leave Register
    17. 2.17 Leave Balance
    18. 2.18 Late Memo
    19. 2.19 Export to Excel
  3. 3 Cross Tab Reports 
    1. 3.1 Detail Muster Roll
    2. 3.2 Paid / Unpaid
    3. 3.3 Late Mark
    4. 3.4 Overtime
    5. 3.5 Muster Roll
    6. 3.6 First Last Timestamps Report
  4. 4 Procedure of Report Generation

This window is used to provide various types of reports. This tool is generally required by the HR Managers and Top Management of the companies for attendance related appraisal of employee.

Data Filtering

For proper visualization and management of data, the filtering is important aspect. Here we provide interface so that employee can be filtered on the lines of departments and as individuals.

Employee Filter

Employee Filter provides three types of filters:

          - Department wise
- Employee wise

Of these, you can select multiple departments or employees. One more thing to note is that the selection happens through the check box and not through clicking on employee or department. 

Date Filter

For what information you want to see or reports, you should also provide which dates that fall in between. This gives you freedom to select monthly, weekly or even daily information.You can filter the employee data for dates as per your requirement also using General option, for that select the Date range for which the report is sought It can be a day , week , month or any period.

Employees of Interest

The employees of interest are those for whom you want to perform certain action. They can be All Employees that are selected from Employee filter. Otherwise you can select a single employee or multiple employees on which you want to perform certain action. By default last selected option remains selected.

Reports

Here you can get following Reports.

Daily Attendance Report

This report gives details of all departments of employees . The details provided are Employee Id, Employee Name, Department, Date, Shift, In Time, Out Time, Time Worked, Attendance, Pay Day and Quick Remark.

Employee Summary

This report gives the aggregate attendance for the selected time period. It displays the details of Employee Id, Employee Name, Department, the time period selected and the summary of Present days, Leave days, Holidays, Off Days, Absents, Work Days, Pay Days and Total Days.

Department Summary

This gives the summarize report of the employees present in the department(s) for the selected time period which includes details of Present days, Leave days, Holidays, Off Days, Absents, Work Days, Pay Days and Total Days.

Detail Report

This report gives the details of all the selected employees for the selected time period such as Employee ID, Name, Department, Shift, Time in, Time Out, Time worked, Leave, Holiday, Attendance, Remark, Present Day, Absentee, Pay Day, Off Day, Work Day.

Current Stats

This report displays the recent attendance status of selected employee for selected date and current status whether the employee is reported today or not or if late. This report is not generated from processed data. It gives only the current status. It also provides the Scheduled In time and the first attendance time of the day. 

In/Out Statistics

This report gives you the In Out attendance statistics of selected employees for selected time period. It shows average and deviation Time In and Time Out with present days.

Late Report

This report gives the details of the employees who came later than prescribed time for selected time period.

Late Summary

This report gives the late summary of the employees for selected time period. It displays total late marks of employee segregating details of late, very late and very very late.

Early Out Report

This report gives the details of selected employees who went early during their shift than the prescribed time.

Manual Entry

This report gives the details of the manual entries made for the attendance of selected employees and selected time period.

Single Entry

This report gives the details of the employees who give only one time stamp during the shift period which is not sought for the payday calculations and processing.

Exceptions

This is an aggregate report of all the above exceptions.

Transaction Log

This report gives transaction log reports of the employee. It gives details like Employee Code, Name, Transaction Date, Transaction Time, Time Event, VStatus, Loc.

Salary Slip Data

It displays the report with details for selected employees and for selected time period to be displayed into salary slip such as Total days, present days, absent days. late marks, off days, all type of leave days, holidays, work days and paid days,

Pay Report 

This report gives the break up salary amount to be paid according to set wage rates for selected employees for selected time period. This displays the time period we want, total number of work, paid days and overtime with amount of CTC, ESIC, PF, PT and total to pay in Rs. calculated according to wage rate assigned.

Leave Register

This report gives the details of leaves of selected employees within a selected time period such as, leave dates, names, quantity of currently available leaves, and credit and debit number of leaves.

Leave Balance

This report gives the information in detail for each type of leave and shows its balance for selected employees ans selected time period. It displays leaves allocated, availed and its balance for each type of leave assigned.

Late Memo

This report displays information about Scheduled In time and time the employee has marked attendance and late mark count, pay day, time worked for selected employee and time period. This field directly exports the report to Excel sheet.

Export to Excel

You can export all these reports to Excel Sheet by clicking the button Export to Excel button.

Cross Tab Reports 

These reports can be generated by selecting departments only. Following are cross tab reports;

Detail Muster Roll

This report displays the detailed information about shift, presence, whether manual entry, leave/holiday/weekly off and In time and Out for the day in a tabular format for each day separately for selected employees for selected time period.

Paid / Unpaid

This report displays whether the day is paid or unpaid for the selected time period for selected employees.

Late Mark

This report gives time of late marks for selected employee and time period.

Overtime


Muster Roll

This report displays the detailed information about Presence/ Absent / Leave/ Holiday/ Weekly off per day for selected employees for selected time period.

First Last Timestamps Report

This report gives the most resent time stamps given by the employees. This is important if it required to see the morning time stamps in the afternoon without processing.

Procedure of Report Generation


To know in detail, click here
Subpages (1): Procedure of Report Generation
Comments