Turning PT Timur Raya’s manual payroll into one automated workflow.
PT Timur Raya pays dozens of employees, but fingerprint data from the Fingerspot machine was not synced to any system. Attendance had to be reconciled manually and combined with employee loan deductions in spreadsheets. I built a custom payroll system that pulls attendance directly from the machine and turns it into a final payslip in one process.
Every payroll period, PT Timur Raya’s HR team spent days simply reconciling attendance. Fingerprint data from the Fingerspot machine was not connected to any system, so every attendance record had to be collected and matched manually before it could be calculated.
Three issues made the process especially slow and error-prone:
- Fingerprint data was not synced, so attendance had to be entered manually
- Collecting and matching each employee’s attendance took time and invited mistakes
- Employee loans and cash advances were calculated separately in spreadsheets
Because PT Timur Raya had very specific requirements, the system was built entirely from scratch. The core is a Laravel backend with a central MySQL database — one source of truth for attendance, loans, and payroll calculations. The HR interface uses Svelte so it stays fast and approachable for non-technical staff.
The hardest part was attendance. Instead of manual reconciliation, I built a desktop application with Rust + Tauri that reads the Fingerspot machine database directly and syncs it to the central system. Employee attendance now flows into payroll without a single copy-and-paste step.
Each technology was chosen for a specific role — web for HR, desktop for the hardware bridge.
Four core functions that replaced the old manual process.
Automated Attendance Aggregation
Pulls fingerprint scans directly from the Fingerspot machine and summarizes them by pay period without manual input.
Employee Loan Management
Records cash advances and loans, then automatically deducts them from salary according to the installment schedule.
Integrated Payroll Calculation
Combines attendance, overtime, and deductions into a final payslip in one process.
Desktop Synchronization
A Tauri application reads the Fingerspot database directly and sends the data to the central system.
The biggest impact was not a new feature, but the manual work that disappeared.
- Attendance was entered manually because fingerprint data was not synced
- Loan deductions were calculated in a separate spreadsheet
- Payroll reconciliation took days and was prone to calculation errors
- Attendance syncs automatically from the Fingerspot machine
- Loan deductions are calculated automatically in one system
- Final payslips are ready in a single process