Attendance and timesheet integration
Biometric punch clock synchronization, Ethiopian statutory overtime multipliers (1.5x, 2.0x, 2.5x), shift scheduling, and project cost absorption.
SmartERP integrates physical biometric access control hardware with digital project timesheets (hr_attendance and smart_enterprise_timesheet), ensuring precise tracking of employee working hours, overtime compliance, and labor cost absorption.
Biometric Punch Clock Integration#
SmartERP connects directly to network biometric devices (ZK-Teco, Anviz, Suprema, and RFID badge scanners) via automated REST and TCP listeners:
- Automated Punch Ingestion: Biometric check-in and check-out logs are ingested into
hr.attendancein real time. - Geofencing & Mobile Check-In: For field personnel, project sites, and remote staff, GPS-verified check-ins are recorded via the mobile interface.
- Missing Punch Correction Workflow: If an employee forgets to clock out, SmartERP generates an automated attendance notification, requiring the department supervisor's electronic sign-off before attendance locks.
Ethiopian Statutory Overtime Multipliers#
Under the Ethiopian Labor Proclamation No. 1156/2019 (Article 68), overtime hours worked beyond standard 48-hour working weeks must be compensated using statutory multiplier tiers:
| Overtime Category | Statutory Timing Window | Proclamation 1156/2019 Rate | Computational Multiplier |
|---|---|---|---|
| Daytime Overtime | Work performed between 6:00 AM and 10:00 PM | 1.5x Hourly Rate | $ ext{Overtime Pay} = ext{Hours} imes ext{Hourly Rate} imes 1.50$ |
| Nighttime Overtime | Work performed between 10:00 PM and 6:00 AM | 1.75x Hourly Rate | $ ext{Overtime Pay} = ext{Hours} imes ext{Hourly Rate} imes 1.75$ |
| Weekly Rest Day | Work performed on scheduled Sunday / Rest Day | 2.0x Hourly Rate | $ ext{Overtime Pay} = ext{Hours} imes ext{Hourly Rate} imes 2.00$ |
| Public Bank Holiday | Work performed on Ethiopian Statutory Holiday | 2.5x Hourly Rate | $ ext{Overtime Pay} = ext{Hours} imes ext{Hourly Rate} imes 2.50$ |
Mathematical Derivation of Hourly Rate#
The statutory standard monthly working hour denominator in Ethiopia is 160 Hours (for 40-hour work weeks) or 192 Hours (for 48-hour work weeks):
$$ ext{Hourly Wage} = \frac{ ext{Contract Basic Wage}}{160 ext{ Hours}}$$
$$ ext{Total Overtime Pay} = \sum ( ext{Overtime Hours Worked} imes ext{Hourly Wage} imes ext{Tier Multiplier})$$
Timesheet Integration & Project Cost Absorption#
In corporate professional services, engineering, and manufacturing, employee attendance is directly synchronized with project accounting:
- Matrix Grid Encoding: Employees log daily activity hours against specific Project Analytic Accounts using
smart_enterprise_timesheet. - Attendance Reconciliation: SmartERP cross-references logged timesheet hours against physical biometric office attendance. If an employee logs 8 hours to a client project but physical biometric records reflect only 4 hours on-site, a reconciliation exception is flagged.
- Real-Time Project Cost Absorption: Every validated timesheet hour immediately debits the Project Analytic Account at the employee's fully burdened contract cost rate, updating real-time project commercial profitability (
smarterp_project_dashboard).