Attendance Matching – Comparing Hours Worked vs Hours Scheduled

Celayix is Automating Attendance Matching One of the tasks that someone at your company will need to do for payroll and billing is calculating the hours that employees have worked. This usually involves reviewing the employee attendance data and matching it to the shift schedule. Attendance data contains clock-in/out times and break times. This helps […]

Celayix is Automating Attendance Matching

One of the tasks that someone at your company will need to do for payroll and billing is calculating the hours that employees have worked. This usually involves reviewing the employee attendance data and matching it to the shift schedule. Attendance data contains clock-in/out times and break times. This helps calculate the employee hours including any overtime, while also verifying if whether the actual data is consistent with the schedule.

Attendance data can be collected in various ways, from traditional methods such as a landline, a smart phone app, mobile or desktop web browser, to more specialized devices and systems, such as time clocks with biometric recognition technologies.

Physical Time Recording

Physical time clock collection devices are available with various features, including RFID or magnetic card readers, and biometric verification like facial recognition, fingerprint reader, and hand geometry. Time clocks with biometric recognition are used when there is a concern about time theft (buddy punching) or whether or not employees are actually onsite. Physical clocks are suitable for punching in multiple employees quickly. It’s also great for places where internet connectivity is unavailable or unreliable.

Ultimately, the choice of technology depends on the needs of the business, as well as the physical environment your business is located in.

For external time collection systems, the scheduling system must also capture the attendance data. That way, the system can match and verify data based on the schedule. Oftentimes, this is a time-consuming process and can also introduce errors in the verification process. Therefore, it’s worthwhile for businesses to have a platform that handles both scheduling and time collection.

Automating Timekeeping & Scheduling

Automating this process helps reduce both the time spent and the potential errors that can be made. With an automatch process, matching a single attendance record is automatic (example “clock-in” punch), done with a shift as soon as the attendance record is available. This automatching process not only removes the manual steps someone needs to take to match records, but will also allow for clock alerts to be sent to supervisors, as well as real-time reporting based on shift actual clock-in/out/break times.

In this example, an employee is late clocking-in. The record is sent to Celayix, an automatch is performed and the shift actual-in time is updated. A supervisor alert is also generated informing them of the late clock-in.

This process is also followed for other clock actions.

How We Do It

Celayix will execute the mapping and matching rules in order to find the corresponding shift record. The mapping rules are executed to translate the badge number used on the device to an employee id. The matching rules are executed for “clock-in,” “clock-out,” “break start,” and “break end” attendance records.

One of the challenges with reconciling attendance data from external systems is that it can be inaccurate. For example, an employee can forget to clock-in or out. With an automated process, Celayix can generate alerts notifying a supervisor who will be able to correct shift in/out times. Other incorrect attendance records that can be generated include items like a double clock-in, a clock-out is recorded as a clock-in etc.

An automatch process can detect and generate match exceptions for many anomalies in the attendance data from external devices. With any automatic process, a user interface needs to be provided to help users view records and apply corrections.

With Celayix, the user interface allows users to see the attendance and shift data, review the results of the automatch process, apply corrections by unmatching records, manually match records, re-execute an automatic match for multiple records or ignore bad attendance records.

If the shift is matched, the corresponding shift field is updated. For example, the “actual start time” is updated when a “clock-in” attendance record is received. If there is any concern with how the matching is automatically done, users can remove the automatic match and manually match the records. In addition, if a shift is not matched, a shift exception record is created allowing users to do a manual match.

This provides our users with the best options – strong biometric and location validation from specialized devices and external systems with real time integration with existing schedule and alerts functionality. Reducing the time spent matching information leaves more time for verifying that the information is correct. Automatching also reduces the chance of introducing errors into the matching process and will allow users to spend more time completing other important tasks.

You may also like…

What is Self Scheduling and its Benefits?

What is Self Scheduling and its Benefits?

Self-scheduling is a method of scheduling a workforce through the participation of employees. Is self-scheduling right for your company?
Workplace Privacy: An Employer’s Obligation to Their Employees

Workplace Privacy: An Employer’s Obligation to Their Employees

Employees have a right to privacy even when they're using company computers and mobile phones. Employers have an obligation to protect employee records. Workplace privacy can be a complex issue, so we've laid it all out for you.
The True Causes & Costs of Absenteeism in the Workplace

The True Causes & Costs of Absenteeism in the Workplace

Absenteeism is a minefield of different causes, costs, and effects. Whether you know it or not, you are likely throwing money away by not addressing it upfront in your organization. We've broken down the causes and costs of absenteeism, and what you can do to combat it in your organization.