OdooWiki OCA HUB

HR Attendance Sheet

hr_attendance_sheet folder_open OCA/hr-attendance open_in_new
Human Resources License: AGPL-3

This module extends attendance and adds sheets and other features. Feature List:

  • Attendance sheets, generated Daily, Weekly, Bi-Weekly or Monthly
  • Auto lunch calculation option in the duration if attendance duration surpasses time.
  • Several Approval Options
  • HR Manager/Officer,
  • Employee's Manager or Attendance Admin
  • Manager or HR or Employee's Manager or Attendance Admin

auto_awesome What this module does

AI-generated from the code · Odoo 14.0

Groups employee check-in/check-out records into attendance sheets that can be submitted, reviewed, approved and locked. Adds automatic lunch deduction and overtime calculation based on company settings.

This module turns raw attendance records into period-based attendance sheets per employee. Sheets are created automatically by a scheduled job for employees flagged with 'Use Attendance Sheets', using the period (Day, Week, Bi-Week or Month) and start/end dates configured on the company.

Each sheet shows the employee, department, manager, working hours, hours to work, total time and overtime. Overtime is total time minus the expected hours to work, never below zero. A 'Check in/out' button is available while the sheet is in Draft.

Sheets follow a status flow: Draft, Waiting Review, Approved and Locked. Buttons let users Submit to Reviewer, Approve, Refuse, Set to Draft, Lock and Unlock. Approval rights depend on the company review policy: HR Manager/Officer, Employee's Manager or Attendance Admin, or HR or Manager or Attendance Admin. A reviewer must be linked to an employee record. Submitted sheets cannot contain attendances without a check-out. Locked or approved sheets cannot be edited or deleted.

If Auto Lunch is enabled on the company, a lunch period is deducted when an attendance exceeds the configured duration; users can override it with a reason. Menus appear under Attendances: Attendance Sheets, My Attendance Sheets and Employee's Attendance Sheets. Two reports are provided: Attendance Sheet and Attendance Sheet Preview.

Depends on

hr_attendance

Menus it adds

Attendance SheetsAttendance SheetsMy Attendance SheetsEmployee's Attendance Sheets
Models and fields (7)
  • hr.employee · extends an existing modelhours_to_work (Hours to Work), attendance_admin (Attendance Admin), use_attendance_sheets (Use Attendance Sheets)
  • res.company · extends an existing modeldate_end (Date To), auto_lunch (Auto Lunch), date_start (Date From), auto_lunch_hours (Lunch Hours), auto_lunch_duration (Duration), attendance_week_start (Week Starting Day), use_attendance_sheets (Use Attendance Sheets), attendance_sheet_range (Attendance Sheet Range), attendance_sheet_review_policy (Attendance Sheet Review Policy)
  • hr.attendance · extends an existing modelduration (Duration (Hrs)), auto_lunch (Auto Lunch Applied), company_id (Company), override_reason (Override Reason), attendance_admin (Attendance Admin), auto_lunch_enabled (Auto Lunch Enabled), attendance_sheet_id (Sheet), override_auto_lunch (Override Auto Lunch)
  • hr.department · extends an existing modelattendance_admin (Attendance Admin)
  • hr.employee.public · extends an existing modelhours_to_work (Hours to Work), attendance_admin (Attendance Admin), use_attendance_sheets (Use Attendance Sheets)
  • hr.attendance.sheet · new modelname, state (Status), active (Active), user_id (User), date_end (Date To), overtime, can_review (Can Review), company_id (Company), date_start (Date From), manager_id (Manager), total_time, employee_id (Employee), reviewed_on (Reviewed On), reviewer_id (Reviewer), department_id (Department), hours_to_work (Hours to Work), review_policy (Review Policy), working_hours (Working Hours), attendance_ids (Attendances), attendance_admin (Attendance Admin)
  • res.config.settings · extends an existing modelauto_lunch (Auto Lunch), auto_lunch_hours (Lunch Hours), auto_lunch_duration (Duration), attendance_week_start (Week Starting Day), attendance_sheet_range (Attendance Sheet Range), attendance_sheet_review_policy

Text generated by AI (DeepSeek) from reading the Odoo 14.0 code on GitHub; it may contain mistakes, so check the code before deciding. The module is very large and only part of the code was read. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 2 confirmed, 7 with no information of 9 versions.

terminal Installation and usage

OCA documentation · Odoo 14.0

Configuration

Source · Odoo 14.0

Attendance Sheet Configuration:

  • Go to Attendances -> Configuration.
  • Set the Attendance Sheet Range to be used to calculate start/end dates

on the sheet when they are created.

  • Set the Attendance Sheet Review Policy for who can review sheets.
  • Choose Auto Lunch if you want a lunch calculated automatically. Duration is

maximum hours where a lunch would be calculated with the lunch duration. For example, duration set to 5hrs, lunch set to .5hrs, if attendance is 6hours then the duration on the attendance would show 5.5hrs due to the auto lunch. Note: if there is two attendances and there is enough time between them, then auto lunch won't be applied.

Employee Configuration:

  • Go to Attendances -> Manage Attendances -> Employees.
  • Open the Employee and then HR Settings
  • Check Manual Attendance to give them access to the attendance app.
  • Check Attendance Sheets if they will be having sheets created for them.
  • Set Hours to Work which is the expected work time during the sheet period,

this is used to calculates overtime values on the sheet.

  • If manager's are set to review, make sure a manager is set on the employee.

Usage

Source · Odoo 14.0
  • Sheets will be auto created by a scheduled action for employees that have

the attendance sheet checked on their employee record.

  • Sheets will have a start/end time based on the period set in settings.
  • Attendances that have dates between the sheet start/end time will

automatically be put into the sheet.

  • Auto lunch (if enabled) will be calculated in the attendance duration if the

duration exceeds the auto lunch setting. A banner will show on the attendance stating that an auto lunch has been applied.

  • After sheet period ends, Employee submits sheet to reviewer. Reviewer makes

changes if necessary and approves sheet.

No verified information in OCA: Installation.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.