Employee Reporting in Odoo 18
By Braincuber Team
Published on January 14, 2026
Your company has 150 employees across 8 departments. Four employee certificates expire next month. You need to know which departments are understaffed, who has Python programming skills for a new project, and what your total salary budget is by department. Getting this information from spreadsheets or individual employee records would take hours. You need a reporting dashboard.
Odoo 18's Employee module provides comprehensive reporting capabilities for HR analytics. The Reporting section includes three key areas: Contracts (salary, headcount, budget analysis), Skills (employee competencies and skill levels), and Certifications (credentials tracking with expiration alerts). Use graph views for trends, pivot tables for detailed analysis, and filters to drill into specific departments, time periods, or employee groups. These reports transform your employee data into actionable insights for workforce planning.
Employee Reporting in Odoo 18: HR analytics tools for analyzing contracts, skills, and certifications. Graph and pivot views visualize headcount trends, salary costs, skill distribution, and certification status. Filters and grouping enable department-level, company-level, and custom analysis.
Three Reporting Areas
Contracts
Analyze employee headcount, new hires, departures, salary costs, and contract durations across departments and time periods.
Skills
Track employee competencies, skill types, proficiency levels, and skill gaps across your organization.
Certifications
Monitor employee credentials, expiration dates, and renewal needs with color-coded status indicators.
Accessing Employee Reports
Open Employee Module
- Go to Apps from main dashboard
- Open the Employees app
Navigate to Reporting
- Click Reporting in top menu
- Choose from: Contracts, Skills, or Certifications
Contracts Reporting
Contracts reporting provides comprehensive analytics on employee agreements, headcount trends, salary costs, and workforce changes over time.
CONTRACTS REPORTING IN ODOO 18
═══════════════════════════════════════════════════════════
NAVIGATION: Employees → Reporting → Contracts
AVAILABLE MEASURES
───────────────────────────────────────────────────────────
Employees
Total count of current employees
Example: 147 active employees
New Employees
Count of employees hired in selected period
Example: 12 new hires in Q1 2026
Departure Employees
Count of employees who left
Example: 5 departures this quarter
Annual Employee Budget
Total yearly allocation for salaries + HR costs
Example: $2.4M annual budget
Wage
Total or average salary amounts
Example: $185,000 average salary
Contract Duration
Length of employment contracts
Example: 24-month average contract
Salary Count
Number of salary records (for analysis)
GRAPH VIEW ANALYSIS
═══════════════════════════════════════════════════════════
Default: Bar chart by month/year
Visualizations available:
• Bar Chart: Compare values across categories
• Line Chart: Track trends over time
• Pie Chart: Show proportional distribution
EXAMPLE: HEADCOUNT TREND BY MONTH
───────────────────────────────────────────────────────────
Employees
200 ┤ ████
│ ████ ████
150 ┤ ████ ████ ████
│ ████ ████ ████ ████
100 ┤ ████ ████ ████ ████ ████
│████ ████ ████ ████ ████ ████
50 ┤████ ████ ████ ████ ████ ████
│████ ████ ████ ████ ████ ████
0 └────────────────────────────────────
Jul Aug Sep Oct Nov Dec
Shows headcount growth over 6 months
PIVOT VIEW ANALYSIS
═══════════════════════════════════════════════════════════
Pivot tables for detailed breakdowns:
EXAMPLE: SALARY BY DEPARTMENT
┌────────────────────────────────────────────────────────┐
│ Department │ Employees │ Total Wage │ Avg Wage │
├────────────────────────────────────────────────────────┤
│ Engineering │ 45 │ $4,500,000 │ $100,000 │
│ Sales │ 32 │ $2,880,000 │ $90,000 │
│ Marketing │ 18 │ $1,440,000 │ $80,000 │
│ Operations │ 25 │ $1,750,000 │ $70,000 │
│ HR │ 12 │ $840,000 │ $70,000 │
│ Finance │ 15 │ $1,200,000 │ $80,000 │
├────────────────────────────────────────────────────────┤
│ TOTAL │ 147 │ $12,610,000│ $85,782 │
└────────────────────────────────────────────────────────┘
EXAMPLE: NEW HIRES VS DEPARTURES
┌────────────────────────────────────────────────────────┐
│ Quarter │ New Employees │ Departures │ Net Change │
├────────────────────────────────────────────────────────┤
│ Q1 2026 │ 12 │ 5 │ +7 │
│ Q4 2025 │ 8 │ 4 │ +4 │
│ Q3 2025 │ 15 │ 7 │ +8 │
│ Q2 2025 │ 10 │ 6 │ +4 │
├────────────────────────────────────────────────────────┤
│ TOTAL │ 45 │ 22 │ +23 │
└────────────────────────────────────────────────────────┘
Insight: Company grew by 23 employees over past year
Filters and Grouping
FILTERS AND GROUPING IN EMPLOYEE REPORTS
═══════════════════════════════════════════════════════════
FILTER OPTIONS
───────────────────────────────────────────────────────────
Standard Filters:
Creation Date Filter by when record was created
Contract Start Filter by contract beginning date
Contract End Filter by contract expiration
Custom Filters:
Add Custom Filter → Select any field
Examples:
• Department = "Engineering"
• Wage > 100000
• Contract End Date <= "2026-03-31"
• Employee Type = "Full-Time"
GROUP BY OPTIONS
═══════════════════════════════════════════════════════════
GROUP BY EMPLOYEE
───────────────────────────────────────────────────────────
Groups data by individual employee
Best for: Detailed employee-level analysis
Example output:
John Smith → $95,000 salary, 2 years tenure
Sarah Jones → $110,000 salary, 4 years tenure
Mike Chen → $85,000 salary, 1 year tenure
GROUP BY DEPARTMENT
───────────────────────────────────────────────────────────
Groups employees by department
Best for: Department budgets, headcount planning
Example output:
Engineering → 45 employees, $4.5M total salary
Sales → 32 employees, $2.9M total salary
Marketing → 18 employees, $1.4M total salary
GROUP BY COMPANY
───────────────────────────────────────────────────────────
Groups by company (multi-company setups)
Best for: Consolidated reporting across entities
Example output:
Main Corp USA → 120 employees
Subsidiary EU → 45 employees
Branch Asia → 35 employees
CUSTOM GROUPING
───────────────────────────────────────────────────────────
Click "Add Custom Group" for:
• Job Title
• Manager
• Country
• Contract Type
• Work Location
Example: Group by Job Title
Software Engineer → 25 employees
Senior Engineer → 12 employees
Tech Lead → 6 employees
Engineering Manager → 4 employees
COMBINING FILTERS + GROUPS
═══════════════════════════════════════════════════════════
Example Analysis:
"Engineering salaries by seniority level"
1. Add Filter:
Department = "Engineering"
2. Add Group By:
Job Title
Result:
┌────────────────────────────────────────────────────────┐
│ Job Title │ Count │ Total Wage │ Avg Wage │
├────────────────────────────────────────────────────────┤
│ Junior Developer │ 8 │ $480,000 │ $60,000 │
│ Software Engineer │ 18 │ $1,440,000 │ $80,000 │
│ Senior Engineer │ 12 │ $1,320,000 │ $110,000 │
│ Tech Lead │ 5 │ $750,000 │ $150,000 │
│ Engineering Manager │ 2 │ $460,000 │ $230,000 │
└────────────────────────────────────────────────────────┘
SAVING FAVORITE REPORTS
═══════════════════════════════════════════════════════════
Save frequently used filter/group combinations:
1. Apply filters and groups
2. Click star icon → "Save current search"
3. Name it: "Engineering Salary Report"
4. Check "Use by default" to auto-apply
Access saved reports:
Click search bar dropdown → Favorites
Skills Reporting
Skills reporting helps you understand workforce competencies, identify skill gaps, and match employees to projects based on their abilities.
SKILLS REPORTING IN ODOO 18 ═══════════════════════════════════════════════════════════ NAVIGATION: Employees → Reporting → Skills SKILL COMPONENTS ─────────────────────────────────────────────────────────── Skill Types (Categories): • IT / Technical • Programming Languages • Soft Skills • Languages • Industry Knowledge • Tools & Software Skills (Specific abilities): • Python, JavaScript, SQL (Programming) • Communication, Leadership (Soft Skills) • English, Spanish (Languages) • Excel, Salesforce (Tools) Skill Levels: • Beginner (0-25%) • Intermediate (26-50%) • Advanced (51-75%) • Expert (76-100%) Level Progress: Percentage indicating proficiency (0-100%) SKILLS PIVOT VIEW ═══════════════════════════════════════════════════════════ Matrix view of skills across organization: EXAMPLE: PROGRAMMING SKILLS BY EMPLOYEE ┌────────────────────────────────────────────────────────────┐ │ Employee │ Python │ JavaScript │ SQL │ Java │ ├────────────────────────────────────────────────────────────┤ │ John Smith │ Expert │ Advanced │ Expert│ - │ │ Sarah Jones │ Advanced│ Expert │ Inter.│ Beginner│ │ Mike Chen │ Inter. │ Inter. │ Expert│ Advanced│ │ Lisa Park │ Beginner│ Advanced │ Inter.│ Expert │ ├────────────────────────────────────────────────────────────┤ │ TEAM COVERAGE │ 4 │ 4 │ 4 │ 3 │ └────────────────────────────────────────────────────────────┘ EXAMPLE: SKILL DISTRIBUTION BY LEVEL ┌────────────────────────────────────────────────────────────┐ │ Skill Type │ Beginner │ Inter. │ Advanced │ Expert │ ├────────────────────────────────────────────────────────────┤ │ Programming │ 5 │ 12 │ 18 │ 8 │ │ Soft Skills │ 3 │ 8 │ 25 │ 15 │ │ Languages │ 10 │ 15 │ 8 │ 5 │ │ Tools │ 8 │ 20 │ 12 │ 6 │ └────────────────────────────────────────────────────────────┘ Insight: Strong in soft skills, need programming training USE CASES FOR SKILLS REPORTS ═══════════════════════════════════════════════════════════ 1. PROJECT STAFFING "Find employees with Python + SQL for data project" Filter: Skill = Python, Level >= Advanced AND: Skill = SQL, Level >= Intermediate Result: 8 candidates identified 2. TRAINING NEEDS "Identify departments with low JavaScript coverage" Group by: Department Measure: Count where JavaScript >= Intermediate Result: Operations team needs JS training 3. SUCCESSION PLANNING "Find potential tech leads" Filter: Python = Expert OR JavaScript = Expert AND: Leadership skill exists Result: 3 candidates for promotion 4. SKILL GAP ANALYSIS "Company-wide skill coverage report" Compare: Skills needed vs skills available Identify: Missing critical skills Action: Hire or train to fill gaps
Certifications Reporting
CERTIFICATIONS REPORTING IN ODOO 18
═══════════════════════════════════════════════════════════
NAVIGATION: Employees → Reporting → Certifications
CERTIFICATION DATA DISPLAYED
───────────────────────────────────────────────────────────
For each certification:
• Employee Name
• Certification Title
• Validity Start Date
• Validity End Date
• Expiration Status
COLOR-CODED STATUS INDICATORS
═══════════════════════════════════════════════════════════
BLACK
Status: Valid
Meaning: Certification is current and active
Action: No action needed
ORANGE
Status: Expiring Soon
Meaning: Expires within 90 days
Action: Schedule renewal
RED
Status: Expired
Meaning: Certification has lapsed
Action: Immediate renewal required
EXAMPLE CERTIFICATIONS REPORT
───────────────────────────────────────────────────────────
┌───────────────────────────────────────────────────────────┐
│ Employee │ Certification │ Expires │Status │
├───────────────────────────────────────────────────────────┤
│ John Smith │ AWS Solutions Arch. │ 2027-06-15 │ ● │
│ Sarah Jones │ PMP │ 2026-02-28 │ ● │
│ Mike Chen │ CISSP │ 2026-01-10 │ ● │
│ Lisa Park │ Scrum Master │ 2025-12-01 │ ● │
│ Tom Wilson │ Google Cloud Prof. │ 2026-08-20 │ ● │
├───────────────────────────────────────────────────────────┤
│ ● Valid ● Expiring ● Expired │
└───────────────────────────────────────────────────────────┘
FILTERING BY EXPIRATION STATUS
═══════════════════════════════════════════════════════════
Click dropdown → Select Expiration Status:
• Valid - Show only current certifications
• Expiring - Show certifications expiring in 90 days
• Expired - Show lapsed certifications
Monthly Renewal Planning:
Filter: Expiration Status = "Expiring"
Result: 4 certifications need renewal this quarter
Action Items:
- Sarah Jones: Renew PMP by Feb 28
- Mike Chen: Renew CISSP by Jan 10 (urgent!)
CREATING NEW CERTIFICATION
═══════════════════════════════════════════════════════════
Navigate: Reporting → Certifications → New
Fields:
Title: "AWS Solutions Architect"
Employee: Select employee
Type: Certificate type (defines display location)
Duration:
Start Date: 2026-01-15
End Date: 2029-01-15 (3-year validity)
Display Type:
Classic → Only on resume
Course → Resume + links to training course
Certification → Resume + Certifications report
Description: Detailed certification info
Save → Certification appears in reports
CERTIFICATION USE CASES
═══════════════════════════════════════════════════════════
1. COMPLIANCE TRACKING
"Ensure all finance staff have CPA"
Filter: Department = Finance
Check: CPA certification exists and valid
Result: 12/15 compliant, 3 need certification
2. RENEWAL CALENDAR
"Plan Q1 certification renewals"
Filter: Expiring between Jan 1 - Mar 31
Result: 8 certifications need renewal
Budget: Allocate $15,000 for renewals
3. SKILL VERIFICATION
"Verify cloud expertise for client project"
Filter: Certification contains "AWS" OR "Azure"
Result: 6 certified cloud professionals
Assign: Best candidates for project
Practical HR Analytics Examples
Headcount Planning
Track employee growth trends by department to forecast hiring needs and budget requirements.
Salary Benchmarking
Compare wages by department and job title to ensure competitive compensation.
Turnover Analysis
Monitor new hires vs departures to identify retention issues and growth patterns.
Skill Gap Analysis
Identify missing competencies and plan training programs to fill gaps.
Compliance Tracking
Ensure required certifications are current for regulatory compliance.
Project Staffing
Find qualified employees based on skills and certifications for project needs.
Best Practices
✅ Employee Reporting Best Practices:
- Keep data current: Regularly update employee skills and certifications
- Use saved favorites: Create reusable reports for monthly HR reviews
- Combine filters: Layer multiple filters for precise analysis
- Export for presentations: Download reports for board meetings
- Track trends over time: Use date filters to compare periods
- Monitor certification expirations: Review expiring certs monthly
- Align with business goals: Focus on skills critical to strategy
- Share insights: Distribute reports to department managers
Conclusion
Odoo 18's Employee Reporting transforms HR from administrative record-keeping into strategic workforce management. The Contracts report reveals headcount trends, salary costs, and turnover patterns across departments. The Skills report maps organizational competencies and identifies training needs. The Certifications report tracks credential compliance with color-coded expiration alerts. Use graph views for executive presentations, pivot tables for detailed analysis, and saved favorites for recurring reports. These tools enable data-driven decisions about hiring, training, compensation, and resource allocation—turning your employee data into competitive advantage.
🎯 Key Takeaway: Three reports (Contracts, Skills, Certifications) | Graph + Pivot views | Filter by date, department, company | Group by employee, department, job title | Save favorites for quick access | Color-coded certification expiration tracking.