Payroll Attendance
| Lines of Code | 541 |
| Technical name | to_hr_payroll_attendance |
| License | OPL-1 |
| Website | https://viindoo.com/apps/app/15.0/to_hr_payroll_attendance |
| Read description for | v 10.0 v 11.0 v 12.0 v 13.0 v 14.0 v 16.0 v 17.0 |
| Required Apps | Attendances (hr_attendance) Time Off (hr_holidays) Discuss (mail) Employees (hr) Calendar (calendar) Employee Contracts (hr_contract) |
| Included Dependencies | Payroll Partner Date of Birth HR Contract Action Buttons Employee Relatives Viindoo Base HR Attendance Validation Viin HR Base Employee Working Schedule Viin HR Contracts Time-Off Custom |
Demo video: Payroll Attendance
What it does
This module connects the Attendance and Payroll modules, allowing users to automatically load all employees' attendance data into payslips, as a base for payroll.
Key Features
After installing this module, in addition to the Working Calendar Info, Leave Summary, a Summary of Attendance will be added on the employee's pay slip with the following information:
- Late Coming Hours: total hours of late coming during the payslip period.
- Early Leave Hours: total hours of early leaves during the payslip period.
- Late Comings: number of times the employee came late during the payslip period.
- Early Leaves: number of times the employee leave earlier that the expected contracted check-out time during the payslip period.
- Missing Check-outs: the number of times the employee forgot to check-out during the payslip period.
- Total Attendance (in hours): The total time that the employee had been attending during the payslip period.
- Total Valid Attendance (in hours): The total valid time (that matches the employee's contracted working schedule) that the employee had been attending during the payslip period.
All these data is automatically loaded from the Attendance module.
Editions Supported
- Community Edition
Installation
- Navigate to Apps.
- Search with keyword ‘to_hr_payroll_attendance’.
- Press Install.
Instruction
Instruction video: Payroll Attendance
Set up formula on salary rule to get attendance data
Attendance data will be linked to the payroll based on the formulas established on the salary rule. Go to Payroll ‣ Configuration ‣ Salary Rules, at the General tab, you can set up the condition and formula for the salary rule by writing Python code.
You can refer how to access attendance data from salary rules:
# to get the employee attendance entries during the payslip period attendance_entries = payslip.attendance_ids # to get total attendance hours total_attendance_hours = payslip.total_attendance_hours # to get valid attendance hours valid_attendance_hours = payslip.valid_attendance_hours # to get total late coming hours late_attendance_hours = payslip.late_attendance_hours # to get total early leave hours early_leave_hours = payslip.early_leave_hours # to get number of late comes late_attendance_count = payslip.late_attendance_count # to get number of early leave early_leave_count = payslip.early_leave_count # to get number of times the employee forget to checkout missing_checkout_count = payslip.missing_checkout_count
An example of basic wage computation based on total valid attendance:
result = 0.0 # Loop over the payslip's working calendar lines that link to contract for wage calculation for line in working_month_calendar_lines.filtered(lambda l: l.contract_id): result += line.contract_id.wage * line.valid_attendance_hours / line.calendar_working_hours
An example of missing checkout penalty:
Assume each missing checkout would cost $5
result = 5 * payslip.missing_checkout_count
Information on payslips
This module is a combination of Attendances and Payroll applications, all employee attendance data will be linked to payslips at Attendance Summary. Go to Payroll ‣ Payslips ‣ Payslips ‣ Create , additional information includes:
- Late Coming Hours: The total number of hours late for work compared to the start time on the Working schedule. It is calculated based on employee attendance data.
- Early Leave Hours: The total number of hours early for work compared to the start time on the Working schedule. It is calculated based on employee attendance data.
- Late Comings: The number of late comings compared to the regulation.
- Early Leaves: The number of early comings compared to the regulation.
- Missing Check-outs: The number of times that you forgot to check out.
- Total Attendance Hours: Total attendance hours based on the employee attendance data.
- Valid Attendance Hours: Total valid attendance hours based on the work schedule and attendance data.
This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file).
You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one).
It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software.
The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.