Automated Reconciliation of Asynchronous Time Attendance Records
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing methods for reconciling asynchronous time attendance records from multiple, unconnected time clocks are inefficient and prone to errors, leading to inaccurate timesheets and significant time and monetary losses, especially in industries like construction where employees move between locations.
Innovation Solution
An automated method assigns unique identifying codes to users and time attendance recorders, processes time attendance events to create chronological records, and automatically fills in missing start or stop times based on known events within a predetermined time span, ensuring accurate synchronization and reconciliation of time records.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If time attendance records are collected manually from multiple unconnected time clocks, then the system can operate independently at each location, but the reconciliation process becomes time-consuming and error-prone
Solution Approach 1:
The patent introduces a central server as an intermediary that receives time attendance data from multiple independent time clocks. The server reconciles asynchronous records by matching clock-in and clock-out events using employee identifiers and temporal logic, automatically generating accurate timesheets without manual intervention.
Solution Approach 2:
The patent replaces the manual mechanical process of collecting and reconciling paper time cards with an automated electronic system. The central server uses algorithmic processing to match time events, substituting human calculation with automated computational logic that handles asynchronous data from multiple clocks.
2Device complexity
If time attendance records are processed manually, then no central coordination is needed, but calculation accuracy and reliability deteriorate
Solution Approach 1:
The patent implements feedback mechanisms where the central server continuously receives time attendance data from multiple clocks, processes the information through reconciliation algorithms, and generates timesheets that reflect accurate work hours. The system provides feedback to supervisors and employees, allowing verification and correction of any discrepancies.
Solution Approach 2:
The automated reconciliation system performs self-service by automatically matching clock-in and clock-out events, calculating total hours worked, and generating timesheets without requiring manual intervention. The system serves itself by handling the entire reconciliation process autonomously, improving both accuracy and efficiency.
3Adaptability or versatility
If employees move between job sites, then the system must track multiple locations, but the complexity of synchronizing records increases
Solution Approach 1:
The patent segments the time attendance system into independent modular components: individual time clocks at each job site, a central server for reconciliation, and employee-specific time records. Each clock operates independently recording local time attendance, while the server segments the reconciliation process into matching events, calculating hours, and generating location-specific and consolidated timesheets.
Data Source
AI summary
A method for reconciling asynchronous time attendance records in a time attendance system is provided. The reconciliation method of the present invention can reconcile and synchronize time attendance records from a single time attendance recorder device, or multiple time attendance recorder devices which are independent from one another and not electronically connected to a central processor or each other. Each time attendance event includes a time attendance recorder identifying code, a user identifying code, and is processed according to whether it is determined to be a start activity or a stop activity. A series of completed time records is created for each user as all of the time attendance events from all of the recorder devices are processed.


