Kenya Attendance & Payroll XLSX Import
by Smartron Solutions Pvt Ltd https://smartronsolutions.co.uk$ 50.00
Kenya Attendance & Payroll XLSX Import
Turn attendance and payroll workbooks into Odoo attendance records, payroll adjustments, work entries, and recomputed Kenya payslips through one controlled import workflow.
One Import. Complete Payroll Flow.
Reduce repetitive entry while keeping imported attendance and payroll figures traceable to their source file, sheet, row, employee, and period.
Shift Attendance
Import worked durations for contracted staff, casuals, supervisors, and Day/Night layouts.
Overtime Tracking
Capture day hours, night hours, OT1, OT2, overtime hours, and overtime amounts.
Payroll Adjustments
Import basic pay, housing, allowances, advances, deductions, gross pay, and net audit values.
Payslip Synchronization
Create or update draft payslips and recompute them with Kenya payroll rules.
Access Import and Adjustments from Payroll
Dedicated menu entries keep the complete workflow close to your existing Odoo Payroll operations.
Upload and Control the Period
Set the final payroll month, day and night start times, shift lengths, and whether draft payslips should be created or updated.
- XLSX file validation
- Automatic month detection from file names
- Day and night shift configuration
- Optional payroll synchronization
Safe and Traceable Import Workflow
Designed to protect existing attendance and validated payroll records.
Upload Workbook
Select a supported attendance or payroll XLSX workbook.
Match Employees
Resolve employees by import code and standard identity fields.
Validate Records
Skip duplicates and overlaps while reporting row-level errors.
Sync Payroll
Create adjustments and safely recompute draft Kenya payslips.
From Imported Values to Payroll Results
Review source details and imported amounts, open the synchronized payslip, and inspect generated work entries.
Payroll Adjustment & Source Traceability
Recomputed Kenya Payslip
Calendar and Work Entries
Import Controls & Payroll Protection
- Duplicate and overlapping attendance prevention
- Employee creation when a valid employee is missing
- Employee-code conflict handling by normalized name
- Local timezone conversion for check-in and check-out
- Separate day and night attendance records
- Row-level imported, skipped, and error results
- Source file, sheet, row, date, and shift tracking
- Monthly adjustment create-or-update behavior
- Draft payslip synchronization and recomputation
- Validated or paid payslips are never overwritten
Technical Information
| Specification | Details |
|---|---|
| Odoo Version | 19.0 Enterprise |
| Dependencies | hr_attendance, hr_payroll, l10n_ke_hr_payroll |
| Python Dependency | openpyxl |
| Supported Files | XLSX workbooks with supported attendance, Day/Night, or PAYROLL layouts |
| License | LGPL-3 |
Our Services
Smartron Solutions Pvt Ltd
Odoo ERP customization, implementation, integration, localization, and ongoing technical support.
Need customization or implementation support? Contact Smartron Solutions.
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Attendances (hr_attendance)
• Payroll (hr_payroll) • Employees (hr) • Discuss (mail) • Time Off (hr_holidays) • Calendar (calendar) |
| Lines of code | 1033 |
| Technical Name |
odoo_kenya_attendance_payroll_import |
| License | LGPL-3 |
| Website | https://smartronsolutions.co.uk |
Please log in to comment on this module