Odoo Wings HR Attendance Dashboard
by Odoo Wings https://apps.odoo.com/apps/modules/browse?author=Odoo%20Wings
Odoo
$ 5.00
⚡ Ready for Odoo 17 · Community & Enterprise
HR Attendance
Dashboard
Know exactly who is Present,
On Leave, and
Absent — right now.
Live summary cards, department breakdown, click-to-drilldown,
and one-click Excel export.
Odoo 17
Community & Enterprise
$5 USD
OWL 2 · Auto-Refresh
|
◕
Live Summary Cards
Total, Present, On Leave, Absent — updated in real time with percentage breakdowns.
|
🏢
Department Breakdown
Per-department Present / On Leave / Absent circles with a colour-coded mini bar.
|
📄
Excel Export
Export today's or any date-range attendance register as a formatted .xlsx file in one click.
|
🔎
Click-to-Drilldown
Every count card and department circle opens the filtered employee or attendance list view.
|
Overview
Your workforce at a glance — always up to date
The HR Attendance Dashboard gives HR managers and administrators a real-time snapshot of the entire workforce. Install it and instantly see a live count of who is Present, On Leave, or Absent — for the full company and broken down by department. Every number is clickable and opens the matching filtered list for immediate action.
|
◕ Four Live Summary Cards
Total Employees · Present Today · On Leave Today · Absent Today — each showing count and percentage, clickable to drilldown.
|
▮ Attendance Overview Panel
Colour-coded horizontal progress bars — green for Present, amber for On Leave, red for Absent — with exact counts alongside each bar.
|
|
🏢 Department-wise Breakdown
Scrollable row of department cards — each shows the dept name, employee count, and three clickable circles (green Present · amber On Leave · red Absent) plus a stacked mini bar.
|
📄 One-Click Excel Export
Export a formatted .xlsx attendance register for today or any custom date range — all employees, department, shift, check-in/out times, and P/A/L status.
|
Screenshots
See exactly what you get
Three screenshots — the full live dashboard, the export modal with Current Date mode, and the Date Range picker.
1 | Full Attendance Dashboard
Live summary cards · Overview panel · Quick Summary circles · Department-wise cards
|
The complete dashboard — 20 employees across 7 departments. Each department card shows clickable green (Present), amber (On Leave), and red (Absent) count circles with a stacked mini bar at the bottom.
2 | Present Employees Drilldown
|
Clicking the Present Today card opens the filtered hr.attendance list showing every employee who checked in today, with check-in/out times and work hours.
3 | On Leave Employees Drilldown
|
Clicking On Leave Today lists employees with a validated (approved) leave covering today and who have not checked in — including leave type, from/to dates, and duration.
4 | Absent Employees Drilldown
|
Clicking Absent Today opens the hr.employee list filtered to those with no attendance record and no approved leave — the employees you may need to follow up with.
5 | Export Modal — Current Date Mode
Choose "Current Date" to instantly download today's attendance register
|
"Current Date" mode — one click downloads today's full attendance as a .xlsx file.
6 | Export Modal — Date Range Mode
Switch to "Other Date(s)" to select any From / To date range
|
"Other Date(s)" mode — native date pickers for From and To dates. One row per employee per day in the exported file (max 366 days).
Features
Everything included — nothing to configure
◕ Live Summary Cards
Four large cards at the top of the dashboard:
Total Employees, Present Today, On Leave Today, and Absent Today.
Each card shows the count, the percentage of the total, and a colour-coded left border.
Click any card to open a filtered list view instantly.
▮ Attendance Overview & Quick Summary
A two-panel row beneath the cards. Left panel shows animated horizontal progress bars
(green · amber · red) with exact counts. Right panel shows three percentage circles
(Present · On Leave · Absent) — all clickable to open the matching employee list.
🏢 Department-wise Attendance
A horizontally scrollable row of department cards — one per department, automatically generated from your Odoo data.
Each card shows: department name, employee count, and three clickable circles —
● Green for Present,
● Amber for On Leave,
● Red for Absent —
plus a stacked colour-coded mini bar at the bottom of each card.
Departments sorted alphabetically. Click any circle to open that filtered employee list.
🔎 Click-to-Drilldown
Every metric is actionable. Clicking "Present Today" opens
hr.attendance filtered to today's check-ins — showing employee, department, check-in, check-out, and worked hours. Clicking "On Leave" or "Absent" opens hr.employee filtered to those employee IDs — showing name, department, job position, and phone. Department circles also drilldown to the matching subset.
↻ Auto-Refresh
The dashboard silently refreshes every 5 minutes in the background using an OWL
setInterval timer.
The timestamp of the last refresh is shown in the footer. A manual Refresh button is also available in the top header for immediate updates.
Excel Export
Download a formatted attendance register in one click
The Export button sits in the header next to Refresh. Click it to open the Export modal.
Choose Current Date for today's snapshot, or Other Date(s) to pick any date range up to 366 days.
The server generates a styled .xlsx file and the browser downloads it automatically.
1. Click Export
→
2. Choose Date Mode
→
3. (Optional) Pick Range
→
4. .xlsx Downloads
|
📅 Current Date
Downloads today's full attendance register in a single click — no date entry required. The filename is
attendance_YYYYMMDD.xlsx.
ⓘ Best for: Daily HR morning check, shift supervisors, attendance managers
|
📅 Other Date(s) — Range
Pick any From and To date (up to 366 days). One row per employee per day. Filename:
attendance_YYYYMMDD_to_YYYYMMDD.xlsx.
ⓘ Best for: Monthly payroll preparation, HR audits, leave reconciliation
|
Excel Columns in the exported file
| Column | Description | Notes |
|---|---|---|
| Sl No | Sequential row number | Auto-numbered |
| Employee Name | Full employee name | From hr.employee |
| Department | Employee department | Blank if no dept |
| Shift Name | Work schedule / shift | resource_calendar_id.name |
| Date | Attendance date | Range mode only |
| Check-In Time | First punch of the day | Local timezone |
| Check-Out Time | Last punch of the day | Blank if not checked out |
| Present | Yes / No | Green highlight |
| Absent | Yes / No | Red highlight |
| On Leave | Yes / No | Amber highlight |
Setup
Install in 3 steps — live in under 2 minutes
|
1
|
Install the module
Go to Settings → Apps → search "HR Attendance Dashboard" → Install. Requires
hr, hr_attendance, and hr_holidays. xlsxwriter (Python) must be installed on the server. |
|
2
|
Open the Attendance app
Navigate to Attendance → Dashboard in the top menu. The live dashboard loads immediately — no configuration required.
|
|
3
|
Use it — click, drilldown, export
Click any count card or department circle to open the filtered list. Use the Export button in the header to download the attendance register as Excel for today or any date range.
|
FAQ
Frequently asked questions
Does this work for both Community and Enterprise?
Yes. The module depends only on
hr, hr_attendance, and hr_holidays — all present in both editions of Odoo 17.How is "Present" calculated?
An employee is counted as Present if they have at least one
hr.attendance check-in record with a check_in timestamp falling within today's local calendar day (based on the logged-in user's timezone). Present always takes priority — if an employee has both an attendance record and an approved leave, they are counted as Present.How is "On Leave" calculated?
An employee is counted as On Leave if they have a validated
hr.leave record whose date range overlaps with today, and they are NOT already counted as Present.How often does the dashboard update?
Automatically every 5 minutes. The footer shows the exact time of the last refresh. Use the Refresh button in the header for an immediate update.
What does the Excel export contain?
Sl No, Employee Name, Department, Shift Name, Date (range mode), Check-In Time, Check-Out Time, Present (Yes/No), Absent (Yes/No), On Leave (Yes/No). Colour-coded cells: green for Present, red for Absent, amber for On Leave. Includes company name, period, and generation timestamp in the header.
Is xlsxwriter required?
Yes, for the Excel export feature.
xlsxwriter is a standard Python package included with most Odoo 17 installations. If not present, run pip install xlsxwriter on the server.Can I click on a department circle to see those employees?
Yes. Every circle in the department row is clickable. Clicking the green Present circle in "Machine Shop" will open
hr.attendance filtered to Machine Shop employees with a check-in today. The amber and red circles open hr.employee filtered to that department's on-leave or absent employees respectively.Technical
Module information
|
Compatibility
Odoo 17
Community & Enterprise
Version 17.0.1.0.0 |
Dependencies
Standard Modules Only
hr, hr_attendance,hr_holidays · xlsxwriter |
Frontend
OWL 2 Component
Native Odoo 17 OWL 2
SCSS · JSON-RPC |
|
Export
xlsxwriter
HTTP GET route · Browser auto-download · Styled .xlsx
|
License & Price
OPL-1 · $5 USD
One-time purchase
No subscription |
Support
Odoo Wings
vsmanoj144@gmail.com
Response within 48 hrs |
HR Attendance Dashboard
Live presence tracking · Department breakdown · Excel export · Odoo 17 · $5 USD
Install Now — $5 USD
Odoo 17 · OPL-1
By Odoo Wings · vsmanoj144@gmail.com
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Attendances (hr_attendance)
• Employees (hr) • Time Off (hr_holidays) • Discuss (mail) • Calendar (calendar) |
| Lines of code | 1533 |
| Technical Name |
hr_dashboard_odoo_wings |
| License | OPL-1 |
| Website | https://apps.odoo.com/apps/modules/browse?author=Odoo%20Wings |
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