How to Use Reporting in Odoo 18 Employee Module: Complete Guide
By Braincuber Team
Published on March 24, 2026
The Employee module in Odoo 18 provides comprehensive reporting capabilities for HR analytics, serving as a central location for maintaining employee records while enabling data-driven human resources management. HR managers can examine employee data including contracts, absences, time off, department performance, and more using these reports. This beginner guide explores the reporting functionalities in the Odoo 18 Employee module.
What You'll Learn:
- Understanding the three types of reporting in Odoo 18 Employee module
- Using filters and grouping options for customized reports
- Analyzing contracts with various measures and visualizations
- Tracking employee skills, types, and progress levels
- Managing certifications with expiration tracking
- Creating pivot views for comparative analysis
- Configuring favorite reports for quick access
- Using color-coded certification status indicators
Getting Started with Employee Reporting
To access the reporting features in Odoo 18, select the Employee module from your Odoo 18 Dashboard. Then navigate to the Reporting option within the Employee module interface.
Contracts
Monitor employee agreements including salary, job role, working hours, and contract validity periods.
Skills
Track employee competencies across skill types, levels, and progress for workforce planning.
Certifications
Manage professional credentials with expiration tracking and regulatory compliance monitoring.
Filters and Grouping Options
The Filter and Group By options help create employee reports in Odoo 18's Employees Analysis screen. These powerful features enable HR teams to analyze specific data points and organize information for better decision-making.
Using Filters
The Filter option allows you to filter by specific date fields including creation date, contract start and end dates, and more. You can also create custom filters based on fields like contract end date, certification type, or specific skill tags.
| Filter Type | Description |
|---|---|
| Date Filters | Filter by creation date, contract start/end dates |
| Contract Filters | Filter by contract end date, duration, status |
| Certification Filters | Filter by certification type, expiration status |
| Skill Filters | Filter by specific skill tags and types |
Group By Options
The Group By option enables you to organize data based on different criteria for comprehensive analysis. Understanding these grouping options helps HR managers extract meaningful insights from employee data.
Employee
Groups information according to a specific employee, helping in the analysis of data such as employee contract details, leave, and attendance records.
Department
Assigns workers to various departments including IT, HR, and Sales. Beneficial for HR planning or team-level reporting.
Company
Assigns employees to groups according to the firm to which they belong. Useful for multi-company organizations.
Custom Groups
Create custom groupings based on Job Title, Manager, Country, Contact type, and other fields.
Saving Favorite Reports
The Favorites option helps with quick access to frequently used reports. It allows you to check specific reports without having to reapply filters every time, saving time for HR professionals who need regular access to specific data views.
Contracts Reporting
The Employee module's Contracts Reporting feature in Odoo 18 is essential for maintaining and evaluating employee agreements including salary, job role, working hours, and contract validity. HR staff can efficiently monitor contract status, durations, and costs with the use of these reports.
Available Measures for Analysis
In the Measures menu, users can select various data points for analysis. The graph visualizes employee data by month and year, providing temporal insights into workforce changes.
| Measure | Description |
|---|---|
| Departure Employee | Number of employees who left the company officially |
| Employees | Number of employees who are currently available |
| New Employees | Number of newly appointed employees |
| Annual Employee Budget | Yearly fund allocated for employee salaries and HR expenses |
| Duration Contract | Shows the duration of employment contracts |
| Months Since Start | Months passed since the contract start date |
| Months Since End | Months passed since the contract end date |
| Wage | Shows total or average salary amount in employee contracts |
| Salary Count | General count of records under analysis |
Visualization Options
These metrics can be applied to various visualization views including line charts, bar charts, and pie charts for more detailed and adaptable insights into workforce data.
Available Views for Contract Analysis:
- Graph View (Line, Bar, Pie charts)
- Pivot View (Matrix representation)
- List View (Detailed tabular data)
Key Metrics to Track:
- Employee count by month/year
- Wage totals and averages
- Contract duration analysis
- Departure rate trends
Pivot View for Contracts
Odoo 18 Pivot View offers robust data analysis capabilities within the Employee module. It enables users to gather vast amounts of staff data and provides a matrix representation for improved comparative analysis. This is particularly useful for comparing metrics across departments, time periods, or employee categories.
Skills Reporting
The Employee module's Skill Feature in Odoo 18 helps HR departments monitor, control, and evaluate employee skills. It ensures that qualified individuals are assigned to appropriate jobs or projects by providing a comprehensive view of workforce competencies.
Key Features of Skill Management
Skill Types
Skills are categorized into various types including Soft Skills, IT, Programming Languages, and more.
Skills
Represents specific competencies such as decision-making, creativity, confidence, and languages spoken.
Skill Levels
Represents the level of each skill as Advanced, Beginner, Intermediate, or Expert.
Level Progress
Displays the percentage of the employee's skill proficiency in each area.
When you expand any employee from the list, you can view the skill type, skill, skill level, and level of progress which have been explicitly added for that employee. This granular view helps HR managers identify skill gaps and plan training programs accordingly.
Employee Skills Pivot View
The Employee Skills reporting feature in Odoo 18's Pivot View provides a concise, tabular overview of skills across the company. It organizes and analyzes data by employee, skill type, or skill level. The level of progress and skill count can be easily seen, enabling efficient tracking of employee skill development.
Certifications Reporting
The Employee module's Certifications feature in Odoo 18 enables HR teams to monitor and manage credentials and professional qualifications that employees have obtained. This aids in maintaining regulatory compliance and offers a convenient way to evaluate an employee's eligibility for a given position or project.
Planning training, renewals, or performance reviews is made simpler by the ability to use certificates in reports and filters to find workers who have valid, expiring, or missing certifications.
Accessing Certifications Report
Navigate to Certifications
Go to Reporting > Certifications in the Employee module to access the certifications report.
View Certification Details
The report displays all certifications grouped by employee showing Employee Name, Certification Title, Validity Start and End dates, and the associated cause.
Certification Color Coding
Certifications are color-coded for easy identification of their status. Understanding these color indicators helps HR teams prioritize renewal efforts and ensure compliance.
| Color | Status | Meaning |
|---|---|---|
| Black | Valid certifications | |
| Orange | Expiring within 90 days | |
| Red | Expired certifications |
Filtering by Expiration Status
You can filter expiration status by clicking on the drop-down in the search bar and selecting Expiration Status. The available options include Expired, Expiring, and Valid certifications. Based on this filtering, multiple certifications can be arranged for focused review and action planning.
Important Note
Only certifications with the display type set to 'Certification' appear in this report. Other certifications are visible on the employee's resume section.
Creating a New Certification
Navigate to Certifications
Go to Reporting > Certifications and click on the New button to create a new certification.
Enter Certification Details
Add a Title for your certification and assign an Employee. Choose a new certification Type which determines where it appears on the resume.
Set Duration and Display Type
Specify the Duration as start date and end date. Under Display Type, select how the certification appears: Classic (resume only), Course (resume with course link), or Certification (resume and report).
Add Description and Save
In the Description field, provide a detailed description of the certification. Click Save to create the certification record.
Key Takeaways
- The Employee module provides three types of reporting: Contracts, Skills, and Certifications
- Filters and Group By options enable customized analysis by date, department, employee, and more
- Contracts reporting tracks employee agreements, wages, and workforce trends
- Skills reporting monitors competencies across skill types and progress levels
- Certifications are color-coded for quick status identification
- Pivot views provide matrix representations for comparative analysis
- Favorites feature saves frequently accessed reports for quick retrieval
Frequently Asked Questions
How do I filter certifications by expiration status in Odoo 18?
Navigate to Reporting > Certifications, click on the search bar dropdown, and select Expiration Status. You can choose from Expired, Expiring (within 90 days), or Valid to filter the certification list accordingly.
What measures are available in Odoo 18 Contracts reporting?
Available measures include Departure Employee count, current Employees count, New Employees count, Annual Employee Budget, Contract Duration, Months since start/end dates, Wage totals/averages, and general Salary count for custom reports.
How do I track employee skill levels in Odoo 18?
Go to Reporting > Skills in the Employee module. Expand any employee to view their skill type, specific skills, skill level (Beginner, Intermediate, Advanced, Expert), and level progress percentage for each competency.
What do certification colors mean in Odoo 18 Employee module?
Black indicates valid certifications, orange indicates certifications expiring within 90 days, and red indicates expired certifications. This color coding helps HR teams prioritize renewal efforts efficiently.
How do I create custom groups in Employee reporting?
Use the Group By option in the reporting interface and select Add Custom Group. You can create custom groupings based on Job Title, Manager, Country, Contact type, and other available fields for tailored analysis.
Need Help with Odoo 18 Employee Reporting?
Our experts can help you configure comprehensive HR reporting, set up custom dashboards, implement skills tracking, and optimize your employee data management in Odoo 18.