Odoo
Implementation
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Attendances (hr_attendance)
• Employees (hr) • Payroll (hr_payroll) • Time Off (hr_holidays) • Discuss (mail) • Employee Contracts (hr_contract) • Calendar (calendar) |
| Lines of code | 2094 |
| Technical Name |
hr_attendance_sheet_lb |
| License | OPL-1 |
| Website | https://lucidbrainz.com |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Attendances (hr_attendance)
• Employees (hr) • Payroll (hr_payroll) • Time Off (hr_holidays) • Discuss (mail) • Employee Contracts (hr_contract) • Calendar (calendar) |
| Lines of code | 2094 |
| Technical Name |
hr_attendance_sheet_lb |
| License | OPL-1 |
| Website | https://lucidbrainz.com |
| Versions | 18.0 19.0 |
HR Attendance Sheet & Policies - Professional Edition
Complete Attendance Management System with Advanced Policy Engine, Overtime Calculation, Payroll Integration & Automated Sheet Generation for Odoo 18
Overview
HR Attendance Sheet & Policies - Professional Edition by LucidBrainz is the most comprehensive attendance management solution for Odoo 18 that automates employee attendance tracking with sophisticated policy-based calculations across multiple categories: Overtime Rules, Late Penalties, Absence Deductions, and Difference Time Management. Transform your HR operations from manual spreadsheet chaos to automated, policy-driven attendance processing! This intelligent system helps you track employee attendance with precision, calculate overtime automatically, apply progressive late penalties, manage absence deductions, handle public holidays, and generate professional payslips with complete attendance integration. Perfect for HR managers, payroll administrators, attendance coordinators, operations managers, plant supervisors, shift managers, compliance officers, and any organization that needs accurate time tracking, policy-based calculations, attendance compliance, or automated payroll processing. The module features configurable attendance policies, multi-level overtime rules, progressive late penalty systems, absence tracking with escalation, public holiday management, automated attendance sheet generation, real-time policy calculations, seamless payroll integration, employee self-service, manager approval workflows, and comprehensive reporting capabilities. It intelligently manages complete attendance lifecycle: (1) Fetch Employee Attendances from check-in/check-out records, (2) Apply Attendance Policies with overtime, late, absence, and difference time rules, (3) Calculate Policy-Based Deductions/Allowances using progressive rates and thresholds, (4) Generate Detailed Attendance Sheets with daily breakdowns and summaries, (5) Submit for Manager Approval with workflow states (Draft → Confirmed → Approved), (6) Create Payslip Integration with work entries for all attendance components. The system provides complete visibility into attendance patterns through intuitive interfaces showing planned vs actual timings, overtime calculations, late penalties, absence tracking, difference time calculations, and comprehensive totals. When you process attendance data, the module automatically applies your configured policies showing daily attendance lines, all calculated values, policy applications, and summary statistics, presenting everything in a professional attendance sheet format with status indicators, approval workflows, detailed notes, and direct payroll integration. The payroll integration creates work entries for each component ensuring accurate salary calculations. Ideal for businesses that want to reduce attendance processing time by 75%, eliminate manual calculations, ensure policy compliance, improve attendance accuracy, automate overtime tracking, manage late penalties fairly, track absence patterns, streamline payroll processing, and make data-driven HR decisions for workforce optimization!
Business Benefits & ROI
75% Time Savings
Automate attendance processing from hours to minutes. Eliminate manual calculations and spreadsheet maintenance.
100% Accuracy
Policy-based calculations ensure consistent and fair attendance processing without human errors.
Cost Reduction
Reduce HR administrative costs, minimize compliance issues, and optimize overtime expenses.
Employee Satisfaction
Transparent attendance tracking with clear policy applications builds trust and reduces disputes.
Advanced Features & Capabilities
- Automated Attendance Sheet Generation: One-click creation of comprehensive attendance sheets for any date range. Fetch all employee attendance records and apply policies automatically
- Flexible Policy Configuration: Create unlimited attendance policies with multiple overtime rules, late penalties, absence rates, and difference time calculations
- Multi-Level Overtime Calculation: Separate rates for working days (1.5x), weekends (2.0x), and public holidays (2.5x) with configurable thresholds
- Progressive Late Penalty Engine: Escalating penalties based on occurrence count (1st, 2nd, 3rd time) with time-based thresholds (15min, 30min, 1hr)
- Smart Absence Tracking: Rate-based deductions with escalation (First Time: 1.0x, Second Time: 2.0x, etc.) and automatic occurrence counting
- Difference Time Management: Track planned vs actual work hours with penalties for early departures and incomplete work periods
- Public Holiday Calendar: Manage company holidays with date ranges, reasons, and notes. Automatic holiday detection for overtime calculations
- Detailed Daily Breakdown: Line-by-line attendance data showing planned vs actual timings, overtime, late, absence, and difference time calculations
- Three-State Workflow: Draft (data entry) → Confirmed (calculated) → Approved (payroll ready) with proper approval controls
- Seamless Payroll Integration: Automatic work entry creation for overtime, late, absence, and difference time with proper categorization
- Manual Adjustment Capability: Change attendance data wizard for corrections with reason tracking and audit trail
- Comprehensive Summary Statistics: Overtime count/hours, late count/hours, absence days/hours, and difference time totals
- Enhanced Employee Search: Search employees by name or employee code for quick access and identification
- Timezone & Calendar Integration: UTC/local timezone handling with resource calendar integration for accurate working hours
- Half-Day Leave Support: First half/second half leave tracking with proper attendance calculation adjustments
- Custom Work Entry Types: Dedicated work entries for Late (LATE), Overtime (OVT), Absence (ABS), Difference Time (DIFFT), etc.
- Advanced Salary Rules: Pre-configured payroll rules for all attendance components with proper deduction/allowance categorization
- Role-Based Access Control: Security permissions for attendance coordinators, managers, and HR administrators
- Interval Mathematics Engine: Sophisticated time interval processing for complex attendance scenarios and overlapping periods
- Real-Time Policy Application: Instant calculation updates when policies change with live preview of impacts
- Status-Based Tracking: Visual indicators for absence, weekend, public holiday, leave, and unpaid leave days
- Contract Integration: Link attendance policies to employee contracts with automatic policy inheritance
- Comprehensive Reporting: Detailed attendance reports with policy breakdowns, trends analysis, and export capabilities
- Mobile-Friendly Interface: Responsive design for mobile attendance management and approval workflows
- Multi-Language Support: Full translation support for global organizations with localized attendance terms
- Data Migration Tools: Import existing attendance data and policy configurations from legacy systems
- Extensible Architecture: Clean model structure for easy customization and integration with other modules
Live Module Screenshots
🏖️ Public Holiday Management
Create and manage company public holidays with date ranges, reasons, and notes. The system automatically recognizes holidays for overtime calculations and attendance processing.
Create and manage company public holidays with date ranges, reasons, and notes. The system automatically recognizes holidays for overtime calculations and attendance processing.
⏰ Overtime Rules Configuration
Configure overtime rules for different day types:
• Working Day Overtime: 1.5x rate after 15 minutes
• Weekend Overtime: 2.0x rate from first minute
• Public Holiday Overtime: 2.5x premium rate
Set apply-after thresholds and multiplier rates for each rule type
Configure overtime rules for different day types:
• Working Day Overtime: 1.5x rate after 15 minutes
• Weekend Overtime: 2.0x rate from first minute
• Public Holiday Overtime: 2.5x premium rate
Set apply-after thresholds and multiplier rates for each rule type
⚠️ Progressive Late Penalty System
"Attendance Lateness" rule with escalating penalties:
• 15 minutes late: Rate-based penalty (1.00x rate)
• 1 hour late: Rate-based penalty (2.00x rate)
• 3 hours late: Fixed penalty (08:00 amount)
Progressive structure ensures fair but firm late policy enforcement
"Attendance Lateness" rule with escalating penalties:
• 15 minutes late: Rate-based penalty (1.00x rate)
• 1 hour late: Rate-based penalty (2.00x rate)
• 3 hours late: Fixed penalty (08:00 amount)
Progressive structure ensures fair but firm late policy enforcement
👤 Absence Rules Management
"Absence Rule" with escalating deduction rates:
• First Time Absence: 1.00x deduction rate
• Second Time Absence: 2.00x deduction rate
• Third Time Absence: 3.00x deduction rate
• Fourth Time Absence: 4.00x deduction rate
• Fifth Time Absence: 5.00x deduction rate
Progressive absence penalties encourage better attendance compliance
"Absence Rule" with escalating deduction rates:
• First Time Absence: 1.00x deduction rate
• Second Time Absence: 2.00x deduction rate
• Third Time Absence: 3.00x deduction rate
• Fourth Time Absence: 4.00x deduction rate
• Fifth Time Absence: 5.00x deduction rate
Progressive absence penalties encourage better attendance compliance
🎯 Complete Attendance Policy Configuration
"Attendance Policy" showing integrated policy setup:
• Overtime Rules: Public Holiday (2.5x), Weekend (2.0x), Working Day (1.5x)
• Difference Time Rule: Early departure penalty configuration
• Late In Rule: Progressive lateness penalty system
• Absence Rule: Escalating absence deduction rates
All rules work together to create comprehensive attendance management
"Attendance Policy" showing integrated policy setup:
• Overtime Rules: Public Holiday (2.5x), Weekend (2.0x), Working Day (1.5x)
• Difference Time Rule: Early departure penalty configuration
• Late In Rule: Progressive lateness penalty system
• Absence Rule: Escalating absence deduction rates
All rules work together to create comprehensive attendance management
📊 Attendance Sheet Generation Process
"Attendance Sheet of Pieter Parker for August-2017" showing:
• Get Attendances Button: Fetch raw attendance data from check-in/check-out records
• Daily Breakdown: Planned vs Actual timings for each day
• Status Indicators: Weekend work, absence tracking, overtime identification
• Real-Time Calculations: Late in, overtime, difference time computations
Complete visibility into employee attendance patterns with detailed daily analysis
"Attendance Sheet of Pieter Parker for August-2017" showing:
• Get Attendances Button: Fetch raw attendance data from check-in/check-out records
• Daily Breakdown: Planned vs Actual timings for each day
• Status Indicators: Weekend work, absence tracking, overtime identification
• Real-Time Calculations: Late in, overtime, difference time computations
Complete visibility into employee attendance patterns with detailed daily analysis
✏️ Manual Attendance Correction Wizard
"Change Attendance Data" popup for manual adjustments:
• Overtime: Modify calculated overtime hours (04:20)
• Late In: Adjust late penalty minutes (10:00)
• Diff Time: Change difference time calculations (00:00)
• Reason Tracking: Document why changes were made
Provides flexibility for corrections while maintaining audit trail
"Change Attendance Data" popup for manual adjustments:
• Overtime: Modify calculated overtime hours (04:20)
• Late In: Adjust late penalty minutes (10:00)
• Diff Time: Change difference time calculations (00:00)
• Reason Tracking: Document why changes were made
Provides flexibility for corrections while maintaining audit trail
📈 Attendance Summary Dashboard
Comprehensive statistics for "Pieter Parker" showing:
• Overtime: 5 occurrences, 24.50 total hours
• Late In: 3 instances, 08:00 total late time
• Absence: 2 days, 27.00 hours deducted
• Difference Time: 1 occurrence, 01.50 hours variance
Perfect for quick performance assessment and payroll preparation
Comprehensive statistics for "Pieter Parker" showing:
• Overtime: 5 occurrences, 24.50 total hours
• Late In: 3 instances, 08:00 total late time
• Absence: 2 days, 27.00 hours deducted
• Difference Time: 1 occurrence, 01.50 hours variance
Perfect for quick performance assessment and payroll preparation
💰 Payslip Integration - Salary Computation
Generated payslip showing attendance-based calculations:
• Basic Salary: 6,000.00 (base pay)
• Overtime Allowance: 636.75 (calculated from attendance)
• Absence Deduction: -692.31 (policy-based)
• Late In Deduction: -205.13 (progressive penalty)
• Difference Time Deduction: -47.01 (early departure penalty)
• Net Salary: 5,692.31 (final amount)
Complete integration ensures accurate payroll processing
Generated payslip showing attendance-based calculations:
• Basic Salary: 6,000.00 (base pay)
• Overtime Allowance: 636.75 (calculated from attendance)
• Absence Deduction: -692.31 (policy-based)
• Late In Deduction: -205.13 (progressive penalty)
• Difference Time Deduction: -47.01 (early departure penalty)
• Net Salary: 5,692.31 (final amount)
Complete integration ensures accurate payroll processing
✅ Final Attendance Sheet - Ready for Payroll
Completed attendance sheet in "Draft" state showing:
• Three-Stage Workflow: Draft → Confirmed → Approved
• Daily Detailed Lines: Complete breakdown of all attendance components
• Status Indicators: Weekend work identification and absence tracking
• Policy Applications: All rules applied automatically
• Payroll Ready: Can generate payslip with all work entries
Professional attendance management from start to finish
Completed attendance sheet in "Draft" state showing:
• Three-Stage Workflow: Draft → Confirmed → Approved
• Daily Detailed Lines: Complete breakdown of all attendance components
• Status Indicators: Weekend work identification and absence tracking
• Policy Applications: All rules applied automatically
• Payroll Ready: Can generate payslip with all work entries
Professional attendance management from start to finish
Our Professional Services
Odoo
Customization
Odoo
Migration
Support &
Maintenance
📞 Contact Us
WhatsApp:
Email:
Website: |
🌐 Follow Us📘 Facebook 📸 Instagram 💼 LinkedIn 🎥 YouTube |
© 2025 LucidBrainz Infotech | Professional Odoo Solutions | All Rights Reserved
Odoo Proprietary License v1.0 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.
Please log in to comment on this module