PunchTrack — Time & Activity Tracking System
Time-tracking system for employees to clock in/out and log receipts and mileage. Started as a Raspberry Pi prototype with RFID authentication, later redesigned as a scalable web application.
Overview
PunchTrack is a workforce time and activity tracking platform designed to provide accurate employee accountability, expense tracking, and payroll support through a centralized and auditable system. Originally developed as an RFID-based time clock solution, the platform has evolved into a full-stack application capable of managing employee time records, mileage logs, receipts, and administrative workflows across an organization.
The system was engineered with a strong focus on data integrity, auditability, and future scalability. Every employee action is recorded as a discrete event, creating a transparent history of timekeeping and expense-related activities while reducing opportunities for data loss or unauthorized modification.
Key Features
- Employee clock-in and clock-out tracking
- RFID-based employee authentication
- Receipt submission and expense tracking
- Mileage logging with individual record retention
- Administrative review and approval workflows
- Historical audit trail for all employee activity
- Role-based access controls and user management
- Extensible authentication architecture supporting future biometric and computer vision integrations
Technical Architecture
PunchTrack utilizes a Flask-based backend and PostgreSQL database designed around relational integrity and long-term record preservation. Business logic is intentionally separated from hardware-specific implementations, allowing the system to support multiple authentication methods without impacting core application functionality.
The platform follows a modular architecture where employee authentication, time tracking, mileage reporting, and receipt management operate as independent but connected components. This approach simplifies maintenance, testing, and future expansion.
Technology Stack
- Python
- Flask
- PostgreSQL
- RFID Authentication
- Raspberry Pi Edge Devices
- REST API Architecture
- Role-Based Access Control (RBAC)
Engineering Challenges
Data Integrity and Auditability
Rather than relying on destructive updates, the system was designed to preserve historical records wherever possible. This approach provides a verifiable audit trail and improves accountability for payroll and reimbursement processes.
Hardware Independence
Authentication hardware is abstracted behind a dedicated interface layer, allowing the platform to evolve independently of the physical devices used for employee identification. This design enables future migration to technologies such as biometric authentication, facial recognition, or NFC-based systems without requiring major backend changes.
Scalability
The project began as an embedded RFID time clock running on a Raspberry Pi and was later redesigned into a centralized web application. By transitioning from SQLite to PostgreSQL and exposing functionality through REST APIs, the system became capable of supporting multiple users, locations, and devices while maintaining consistent data management practices.
Future Development
Planned enhancements include biometric authentication, computer vision-based identification, advanced payroll reporting, mobile device support, and deployment on higher-performance edge computing platforms such as the NVIDIA Jetson Orin Nano.