Automated Reconciliation of Asynchronous Time Attendance Records

Resolve Bottlenecks,
Find Innovative Solutions
Generate 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

VSEngineering 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

Engineering Contradiction:
Improveindependence of time clocksVSAvoidtime for reconciliation
Core Design Contradiction:
Adaptability or versatilityVSLoss of time

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.

Inventive Principle:
Principle #24Intermediary (Mediator)

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.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

2Device complexity

If time attendance records are processed manually, then no central coordination is needed, but calculation accuracy and reliability deteriorate

Engineering Contradiction:
Improvesimplicity of system structureVSAvoidaccuracy of timesheets
Core Design Contradiction:
Device complexityVSReliability

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.

Inventive Principle:
Principle #23Feedback

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.

Inventive Principle:
Principle #25Self-service

3Adaptability or versatility

If employees move between job sites, then the system must track multiple locations, but the complexity of synchronizing records increases

Engineering Contradiction:
Improvetracking multiple locationsVSAvoidsynchronization complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

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.

Inventive Principle:
Principle #1Segmentation

Data Source

PatentUS8121912B2Automated method for reconciling asynchronous time attendance records
Publication Date: 2012.02.21 EXAKTIME INNOVATIONS INC A CALIFORNIA DBA EXAKTIME
  • US8121912B2 patent drawing
  • US8121912B2 patent drawing
  • US8121912B2 patent drawing

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.