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) • Calendar (calendar) |
| Lines of code | 2140 |
| 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) • Calendar (calendar) |
| Lines of code | 2140 |
| Technical Name |
hr_attendance_sheet_lb |
| License | OPL-1 |
| Website | https://lucidbrainz.com |
| Versions | 18.0 19.0 |
Odoo 19.0 Compatible
HR Attendance Sheet & Policies Pro
Complete Attendance Management System with Advanced Policy Engine, Overtime Calculation, Progressive Penalties, Payroll Integration & Automated Sheet Generation for Odoo 19
Overview
HR Attendance Sheet & Policies Pro by LucidBrainz is the most comprehensive and professional attendance management solution for Odoo 19 that transforms manual attendance tracking into fully automated, policy-driven workforce management. This enterprise-grade system automates overtime calculations, progressive late penalties, absence deductions, difference time management, and seamless payroll integration. Perfect for HR managers, payroll administrators, attendance coordinators, operations managers, compliance officers, and organizations requiring accurate time tracking, policy-based calculations, and automated payroll processing. The module features configurable attendance policies with multi-level overtime rules (Workday 1.5x, Weekend 2.0x, Public Holiday 2.5x), progressive late penalty systems with occurrence tracking, escalating absence deductions, early departure penalties, public holiday management, automated attendance sheet generation, real-time policy calculations, complete payroll integration with work entries, manager approval workflows (Draft → Confirmed → Approved), and comprehensive reporting. The system intelligently manages the complete attendance lifecycle: (1) Fetch Employee Attendances from check-in/check-out records with timezone conversion, (2) Apply Attendance Policies with flexible rule configurations for all scenarios, (3) Calculate Policy-Based Deductions/Allowances using rate-based or fixed amount formulas, (4) Generate Detailed Attendance Sheets with daily breakdowns showing planned vs actual timings, (5) Submit for Manager Approval with proper workflow state management, (6) Create Payslip Integration with dedicated work entry types (LATE, OVT, ABS, DIFFT) for accurate salary calculations. Built on Odoo 19 Community/Enterprise architecture with full multi-company support, role-based access control, custom work entry types, advanced salary rules, timezone handling, half-day leave support, and mobile-responsive interface. Ideal for businesses that want to reduce HR processing time by 75%, eliminate manual errors, ensure policy compliance, improve attendance accuracy, automate overtime tracking, manage penalties fairly, streamline payroll, and make data-driven workforce decisions!
Business Benefits & ROI
75% Time Savings
Transform hours of manual attendance processing into minutes with fully automated policy calculations and sheet generation.
100% Accuracy
Eliminate human errors with policy-based calculations ensuring consistent and fair attendance processing across organization.
Cost Reduction
Reduce HR administrative costs by 60%, minimize compliance issues, optimize overtime expenses with intelligent tracking.
Employee Trust
Build employee confidence with transparent attendance tracking, clear policy applications, and fair penalty systems.
Advanced Features & Capabilities
- One-Click Attendance Sheet Generation: Automatically create comprehensive monthly attendance sheets with complete policy calculations, daily breakdowns, and summary statistics
- Flexible Multi-Policy Configuration: Create unlimited attendance policies with different combinations of overtime rules, late penalties, absence rates, and difference time calculations
- Three-Tier Overtime System: Separate configurable rates for working days, weekends, and public holidays with apply-after thresholds and multiplier rates
- Progressive Late Penalty Engine: Smart escalation system with occurrence tracking (1st, 2nd, 3rd+ times) and time-based thresholds supporting both rate-based and fixed penalties
- Escalating Absence Deductions: Occurrence-based absence tracking with progressive rates (First Time: 1.0x → Fifth Time: 3.0x) encouraging attendance improvement
- Difference Time Management: Track planned vs actual work hours with configurable penalties for early departures and incomplete shifts
- Public Holiday Management: Comprehensive holiday calendar with automatic detection for premium overtime rate application
- Detailed Daily Breakdown: Line-by-line attendance analysis showing planned timings, actual check-in/out, late minutes, overtime hours, status indicators
- Three-State Approval Workflow: Professional workflow with Draft (data entry) → Confirmed (calculated & locked) → Approved (payroll ready) states
- Complete Payroll Integration: Automatic work entry creation with dedicated types (LATE, OVT, ABS, DIFFT) for accurate payslip generation
- Manual Adjustment Wizard: Correction capability with reason tracking, audit trail, and re-calculation support for special cases
- Summary Statistics Dashboard: Real-time totals for overtime count/hours, late instances/time, absence days/hours, difference time
- Enhanced Employee Search: Intelligent search by employee name or unique employee code for quick record access
- Timezone Intelligence: Automatic UTC/local timezone conversion with resource calendar integration for multi-location organizations
- Half-Day Leave Support: First half/second half leave tracking with proper attendance calculations and work hour adjustments
- Custom Work Entry Types: Pre-configured work entries for Late (LATE), Overtime (OVT), Absence (ABS), Difference Time (DIFFT) with color coding
- Advanced Salary Rules: Ready-to-use payroll rules for all attendance components with proper allowance/deduction categorization
- Role-Based Security: Granular access control for attendance officers, managers, HR administrators with data-level permissions
- Interval Mathematics Engine: Sophisticated time calculation algorithms handling complex scenarios, overlaps, and edge cases
- Real-Time Recalculation: Instant policy application updates when rules change with live impact preview
- Visual Status Indicators: Color-coded status for absence, weekend work, public holidays, paid/unpaid leaves for quick identification
- Contract Integration: Link attendance policies to employee contracts with automatic policy inheritance and validation
- Analytics & Reporting: Comprehensive reports with policy breakdowns, trend analysis, attendance patterns, export capabilities
- Mobile-Responsive Design: Full mobile support for attendance approval, sheet review, and policy management on-the-go
- Multi-Language Ready: Translation support for global organizations with localized attendance terminology
- Multi-Company Support: Full Odoo 19 multi-company architecture with company-specific policies and configurations
- Extensible Architecture: Clean model structure, well-documented code, easy customization and third-party integration
Live Module Screenshots - Odoo 19
⚙️ Work Entry Types Configuration - Payroll Integration Foundation
Pre-configured work entry types for complete payroll integration:
• Attendance (WORK100): Regular working hours tracking
• Overtime Hours (OVERTIME): Extra hours with premium rates
• Late (LATE): Late-in penalty deductions
• Difference (DIFFT): Early departure penalties
• Absence (ABS): Absence day deductions
• Over Time (OVT): Weekend & holiday overtime
These work entry types automatically populate payslip calculations based on attendance sheets
Pre-configured work entry types for complete payroll integration:
• Attendance (WORK100): Regular working hours tracking
• Overtime Hours (OVERTIME): Extra hours with premium rates
• Late (LATE): Late-in penalty deductions
• Difference (DIFFT): Early departure penalties
• Absence (ABS): Absence day deductions
• Over Time (OVT): Weekend & holiday overtime
These work entry types automatically populate payslip calculations based on attendance sheets
🏖️ Public Holiday Calendar Management
Example: "Diwali 2025" public holiday configuration (Nov 1, 2025)
• Define company-wide public holidays with date ranges
• Automatic detection for premium overtime calculations
• Support for religious, national, and company-specific holidays
• Integration with overtime policy for 2.5x holiday rates
Holidays are automatically recognized during attendance sheet generation for proper overtime classification
Example: "Diwali 2025" public holiday configuration (Nov 1, 2025)
• Define company-wide public holidays with date ranges
• Automatic detection for premium overtime calculations
• Support for religious, national, and company-specific holidays
• Integration with overtime policy for 2.5x holiday rates
Holidays are automatically recognized during attendance sheet generation for proper overtime classification
👤 Employee Contract with Attendance Policy Assignment
"Abigail Peterson" employee contract showing complete setup:
• Contract: Oct 1, 2025 to Jan 22, 2026 (Fixed Wage: $6,500/month)
• Attendance Policy: Standard Policy (linked to contract)
• Work Entry Source: Attendances (automatic from check-in/out)
• Working Hours: Standard 38 hours/week
This setup ensures attendance sheets automatically apply correct policies and generate accurate payslips
"Abigail Peterson" employee contract showing complete setup:
• Contract: Oct 1, 2025 to Jan 22, 2026 (Fixed Wage: $6,500/month)
• Attendance Policy: Standard Policy (linked to contract)
• Work Entry Source: Attendances (automatic from check-in/out)
• Working Hours: Standard 38 hours/week
This setup ensures attendance sheets automatically apply correct policies and generate accurate payslips
🔐 Role-Based Access Control & Security
Administrator access rights showing granular permissions:
• Attendances: Administrator access for full control
• Officer: Manage attendances: Special permission for attendance officers
• User: Read his own attendances: Employee self-service access
• Payroll: Administrator access for payroll integration
• Time Off: Administrator control for leave management
Three-tier access model ensures proper data security and workflow control
Administrator access rights showing granular permissions:
• Attendances: Administrator access for full control
• Officer: Manage attendances: Special permission for attendance officers
• User: Read his own attendances: Employee self-service access
• Payroll: Administrator access for payroll integration
• Time Off: Administrator control for leave management
Three-tier access model ensures proper data security and workflow control
📋 New Attendance Sheet Creation Interface
"Attendance Sheet of Rahul Sharma for November-2025" showing:
• Period Selection: Nov 1 - Nov 30 (full month coverage)
• Attendance Policy: Standard Policy auto-assigned from contract
• "Get Attendances" Button: One-click to fetch all check-in/out records
• "Submit to Manager" Button: Workflow action for approval process
• Workflow States: Draft → Confirmed → Approved
Sheet starts empty and populates with daily lines after clicking "Get Attendances"
"Attendance Sheet of Rahul Sharma for November-2025" showing:
• Period Selection: Nov 1 - Nov 30 (full month coverage)
• Attendance Policy: Standard Policy auto-assigned from contract
• "Get Attendances" Button: One-click to fetch all check-in/out records
• "Submit to Manager" Button: Workflow action for approval process
• Workflow States: Draft → Confirmed → Approved
Sheet starts empty and populates with daily lines after clicking "Get Attendances"
⚠️ Smart Contract Validation System
Validation Error: "There is no running contract for Rahul Sharma"
• Pre-Generation Validation: System checks for active contracts before processing
• Data Integrity: Prevents attendance sheet creation without valid employee contracts
• Clear Error Messages: User-friendly guidance for resolution
• Workflow Protection: Ensures all prerequisites are met before calculations
This validation prevents payroll errors and ensures data consistency across HR modules
Validation Error: "There is no running contract for Rahul Sharma"
• Pre-Generation Validation: System checks for active contracts before processing
• Data Integrity: Prevents attendance sheet creation without valid employee contracts
• Clear Error Messages: User-friendly guidance for resolution
• Workflow Protection: Ensures all prerequisites are met before calculations
This validation prevents payroll errors and ensures data consistency across HR modules
📊 Attendance Sheets List View - Management Dashboard
Overview of multiple attendance sheets for "Rahul Sharma":
• November 2025 Sheet: Nov 1 - Nov 30 (current month)
• October 2025 Sheet: Oct 1 - Oct 31 (previous month)
• Employee Tracking: All sheets linked to specific employee
• Period Management: Easy navigation across different months
• Bulk Operations: Process multiple sheets efficiently
List view provides quick access to historical attendance data and comparison capabilities
Overview of multiple attendance sheets for "Rahul Sharma":
• November 2025 Sheet: Nov 1 - Nov 30 (current month)
• October 2025 Sheet: Oct 1 - Oct 31 (previous month)
• Employee Tracking: All sheets linked to specific employee
• Period Management: Easy navigation across different months
• Bulk Operations: Process multiple sheets efficiently
List view provides quick access to historical attendance data and comparison capabilities
💰 Salary Structure Configuration - Payroll Foundation
"Create Salary Rules for Employee" structure showing:
• Structure Type: Employee (standard employee payroll)
• Template: Payslip format configuration
• Salary Rules Tab: All payroll components defined
• Pre-configured Rules: Basic Salary, Taxable Salary, Deductions, Net Salary
• Attendance Integration: Rules for overtime, late, absence automatically applied
This structure template can be assigned to employee contracts for consistent payroll processing
"Create Salary Rules for Employee" structure showing:
• Structure Type: Employee (standard employee payroll)
• Template: Payslip format configuration
• Salary Rules Tab: All payroll components defined
• Pre-configured Rules: Basic Salary, Taxable Salary, Deductions, Net Salary
• Attendance Integration: Rules for overtime, late, absence automatically applied
This structure template can be assigned to employee contracts for consistent payroll processing
✅ Active Contract with Full Configuration
"Rahul Sharma" employee showing complete contract setup:
• Contract Period: Nov 1, 2025 - Nov 29, 2025 (Active)
• Wage: $400.00 per month (Fixed Wage)
• Contract Type: Full-Time (Permanent)
• Attendance Policy: Standard Policy assigned
• Work Entry Source: Working Schedule (automatic tracking)
• Working Hours: Standard 40 hours/week
This configuration enables automatic attendance sheet generation with policy applications
"Rahul Sharma" employee showing complete contract setup:
• Contract Period: Nov 1, 2025 - Nov 29, 2025 (Active)
• Wage: $400.00 per month (Fixed Wage)
• Contract Type: Full-Time (Permanent)
• Attendance Policy: Standard Policy assigned
• Work Entry Source: Working Schedule (automatic tracking)
• Working Hours: Standard 40 hours/week
This configuration enables automatic attendance sheet generation with policy applications
📝 Employee Without Active Contract
"Rahul Sharma" employee profile showing "Not Employed" status:
• Contract Status: Not Employed (no active contract)
• Attendance Policy: Standard Policy still assigned to employee
• Configuration Ready: All settings preserved for future contract
• Work Entry Source: Working Schedule configured
• Working Hours: Standard 40 hours/week maintained
System prevents attendance sheet generation until contract is activated, maintaining data integrity
"Rahul Sharma" employee profile showing "Not Employed" status:
• Contract Status: Not Employed (no active contract)
• Attendance Policy: Standard Policy still assigned to employee
• Configuration Ready: All settings preserved for future contract
• Work Entry Source: Working Schedule configured
• Working Hours: Standard 40 hours/week maintained
System prevents attendance sheet generation until contract is activated, maintaining data integrity
📋 Complete Salary Rules Library - Attendance Integration
Comprehensive salary rules showing attendance-based components:
• Basic Salary (BASIC): Base pay calculation
• Over Time (OVT): Overtime allowance (linked to OVT work entry)
• Holiday and Weekends (WEHD): Weekend/holiday premium
• Absence (ABS): Absence deduction (linked to ABS work entry)
• Un Paid Leave (UNPL): Unpaid leave deduction
• Late In (LATE): Late penalty deduction (linked to LATE work entry)
• Difference Time (DIFF): Early departure deduction (linked to DIFFT work entry)
• Net Salary (NET): Final salary calculation
All attendance components automatically flow to payslip via work entries
Comprehensive salary rules showing attendance-based components:
• Basic Salary (BASIC): Base pay calculation
• Over Time (OVT): Overtime allowance (linked to OVT work entry)
• Holiday and Weekends (WEHD): Weekend/holiday premium
• Absence (ABS): Absence deduction (linked to ABS work entry)
• Un Paid Leave (UNPL): Unpaid leave deduction
• Late In (LATE): Late penalty deduction (linked to LATE work entry)
• Difference Time (DIFF): Early departure deduction (linked to DIFFT work entry)
• Net Salary (NET): Final salary calculation
All attendance components automatically flow to payslip via work entries
📅 Working Schedule - Standard 40 Hours Configuration
"Standard 40 Hours" resource calendar showing complete week setup:
• Schedule Type: Fully Fixed (40.00 hours/week at 100% rate)
• Timezone: Asia/Kolkata (proper timezone handling)
• Daily Schedule: Monday-Friday detailed breakdown
• Morning Shift: 08:00-12:00 (0.50 duration, Attendance type)
• Lunch Break: 12:00-13:00 (0.00 duration, break period)
• Afternoon Shift: 13:00-17:00 (0.50 duration, Attendance type)
• Total per Day: 8 hours (0.50 + 0.50) across morning & afternoon
This schedule determines "planned" timings for attendance comparison and overtime calculations
"Standard 40 Hours" resource calendar showing complete week setup:
• Schedule Type: Fully Fixed (40.00 hours/week at 100% rate)
• Timezone: Asia/Kolkata (proper timezone handling)
• Daily Schedule: Monday-Friday detailed breakdown
• Morning Shift: 08:00-12:00 (0.50 duration, Attendance type)
• Lunch Break: 12:00-13:00 (0.00 duration, break period)
• Afternoon Shift: 13:00-17:00 (0.50 duration, Attendance type)
• Total per Day: 8 hours (0.50 + 0.50) across morning & afternoon
This schedule determines "planned" timings for attendance comparison and overtime calculations
👤 Progressive Absence Deduction Rules
"Standard Absence Rule" with escalating penalty structure:
• First Time Absence: 1.00x rate (single day salary deduction)
• Second Time Absence: 1.50x rate (50% increase for repeat offense)
• Third Time Absence: 2.00x rate (double penalty)
• Fourth Time Absence: 2.50x rate (2.5x penalty)
• Fifth Time Absence: 3.00x rate (triple penalty for chronic issues)
Progressive structure discourages frequent absences while remaining fair for occasional instances
"Standard Absence Rule" with escalating penalty structure:
• First Time Absence: 1.00x rate (single day salary deduction)
• Second Time Absence: 1.50x rate (50% increase for repeat offense)
• Third Time Absence: 2.00x rate (double penalty)
• Fourth Time Absence: 2.50x rate (2.5x penalty)
• Fifth Time Absence: 3.00x rate (triple penalty for chronic issues)
Progressive structure discourages frequent absences while remaining fair for occasional instances
⏱️ Difference Time (Early Departure) Penalty Rules
"Standard Diff Rule" with dual penalty structure:
• 30-Minute Early Departure: Rate-based (0.50 rate) with progressive multipliers
→ First Time: 1.00x | Second: 1.50x | Third: 2.00x | Fourth: 2.50x | Fifth: 3.00x
• 1-Hour Early Departure: Fixed penalty (50.00 amount) with escalation
→ First Time: 1.00x | Second: 2.00x | Third: 3.00x | Fourth: 4.00x | Fifth: 5.00x
Combination of rate-based and fixed penalties provides flexible enforcement for incomplete work periods
"Standard Diff Rule" with dual penalty structure:
• 30-Minute Early Departure: Rate-based (0.50 rate) with progressive multipliers
→ First Time: 1.00x | Second: 1.50x | Third: 2.00x | Fourth: 2.50x | Fifth: 3.00x
• 1-Hour Early Departure: Fixed penalty (50.00 amount) with escalation
→ First Time: 1.00x | Second: 2.00x | Third: 3.00x | Fourth: 4.00x | Fifth: 5.00x
Combination of rate-based and fixed penalties provides flexible enforcement for incomplete work periods
⚠️ Progressive Late-In Penalty System
"Standard Late Rule" with time-based threshold structure:
• 15-Minute Late (00:15): Rate penalty (0.50 rate) with no occurrence multipliers
• 1-Hour Late (01:00): Fixed penalty (10.00 rate = 100.00 amount)
→ First Time: 1.00x | Second: 2.00x | Third: 3.00x | Fourth: 4.00x | Fifth: 5.00x
Smart threshold system applies different penalties based on lateness duration and occurrence frequency
"Standard Late Rule" with time-based threshold structure:
• 15-Minute Late (00:15): Rate penalty (0.50 rate) with no occurrence multipliers
• 1-Hour Late (01:00): Fixed penalty (10.00 rate = 100.00 amount)
→ First Time: 1.00x | Second: 2.00x | Third: 3.00x | Fourth: 4.00x | Fifth: 5.00x
Smart threshold system applies different penalties based on lateness duration and occurrence frequency
🎯 Complete Attendance Policy - All Components Integrated
"Standard Policy" showing fully configured attendance management:
• OVERTIME RULES:
→ Workday OT (Working Day, 00:00 apply after, 0.00 rate)
→ Weekend OT (Working Day, 00:00 apply after, 0.00 rate)
→ Public Holiday OT (Working Day, 00:00 apply after, 0.00 rate)
• DIFFERENCE TIME RULE: Standard Diff Rule (early departure penalties)
• LATE IN RULE: Standard Late Rule (lateness penalties)
• ABSENCE RULE: Standard Absence Rule (absence deductions)
This unified policy applies all rules automatically during attendance sheet generation
"Standard Policy" showing fully configured attendance management:
• OVERTIME RULES:
→ Workday OT (Working Day, 00:00 apply after, 0.00 rate)
→ Weekend OT (Working Day, 00:00 apply after, 0.00 rate)
→ Public Holiday OT (Working Day, 00:00 apply after, 0.00 rate)
• DIFFERENCE TIME RULE: Standard Diff Rule (early departure penalties)
• LATE IN RULE: Standard Late Rule (lateness penalties)
• ABSENCE RULE: Standard Absence Rule (absence deductions)
This unified policy applies all rules automatically during attendance sheet generation
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 19 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