Odoo Spreadsheet Dashboard HR Payroll - Payroll Dashboard
Analyze payroll costs and salary with visual dashboards
The Spreadsheet Dashboard HR Payroll module provides in-depth analytics dashboards for payroll and HR costs in Odoo. This module aggregates data from HR Payroll to create visual reports on salary costs, taxes, insurance and department analysis.
With interactive charts, pivot tables and KPI dashboards, the module helps managers track total payroll costs, analyze salary structure, compare departments and forecast HR expenses.
Basic Dashboard Terminology
HR Payroll Dashboard Terms
| English | Vietnamese | Description |
|---|---|---|
| Payroll Dashboard | Dashboard lương | Payroll analytics control panel |
| Total Payroll Cost | Tổng chi phí lương | Total payroll cost in period |
| Gross Salary | Lương gross | Salary before tax and deductions |
| Net Salary | Lương net | Take-home salary |
| Personal Income Tax | Thuế TNCN | Personal income tax |
| Social Insurance | Bảo hiểm | Social, health, unemployment insurance |
| Department Cost | Chi phí phòng ban | Payroll cost by department |
| Salary Structure | Cơ cấu lương | Salary component analysis |
Dashboard Types
HR Payroll Dashboards
| English | Vietnamese | Description |
|---|---|---|
| Payroll Overview | Tổng quan lương | Payroll cost overview dashboard |
| Department Analysis | Phân tích phòng ban | Compare costs between departments |
| Salary Structure | Cơ cấu lương | Salary component analysis |
| Tax & Insurance | Thuế và bảo hiểm | Tax and insurance details |
| Payroll Trends | Xu hướng lương | Cost trends over time |
| Cost Forecast | Dự báo chi phí | HR cost prediction |
Main Menu Structure
The Spreadsheet Dashboard HR Payroll module is organized by groups:
Steps
1. Payroll Overview Dashboard: Overview of payroll costs and payslips
2. Department Cost: Analyze payroll costs by department
3. Salary Structure: Analyze salary structure and components
4. Tax & Insurance: Personal income tax and insurance details
5. Payroll Trends: Payroll cost trends over time
6. Custom Dashboards: Create custom dashboards as needed
Basic Workflow
HR payroll dashboard usage workflow:
Steps
1. Access dashboard from Spreadsheet or HR Payroll menu
2. Select payroll period and department to analyze
3. View key KPIs: total cost, gross, net, tax
4. Analyze details by department and employee
5. Compare with previous periods to assess trends
6. Export reports for accounting and management
Key Features
Key points
• Real-time dashboard updates when payroll is run
• KPI cards display total cost, gross, net, tax
• Payroll cost trend charts over time
• Multi-dimensional pivot table analysis by department, position, employee
• Cost comparison between departments
• Salary structure analysis: base salary, allowances, bonuses
• Personal income tax and insurance tracking per regulations
• HR cost forecasting for future periods
Important KPIs
HR Payroll KPIs
| KPI | Description |
|---|---|
| Total Payroll Cost | Total payroll cost in period |
| Gross Salary | Total salary before tax and deductions |
| Net Salary | Total take-home salary |
| Total Tax | Total personal income tax |
| Total Insurance | Total insurance (social, health, unemployment) |
| Average Salary | Average salary per employee |
| Payroll Cost Ratio | Payroll cost ratio to revenue |
| Department Cost Share | Cost proportion by department |
User Groups
User Permissions
| Group | Permissions |
|---|---|
| HR Officer | View payroll dashboard, HR analysis |
| Payroll Manager | View all dashboards, manage payroll |
| Finance Manager | Analyze costs, forecasts, financial reports |
| Department Manager | View own department dashboard |
Integration with Other Modules
Spreadsheet Dashboard HR Payroll integrates with:
Key points
• HR Payroll: Payroll data, payslips, salary rules
• HR: Employee information, contracts, departments
• Accounting: Payroll journal entries, HR expenses
• Analytic Accounting: Payroll cost allocation by cost center
• HR Attendance: Salary calculation based on attendance
Real-world Scenarios
Common use cases:
Key points
• Track total monthly payroll costs
• Compare payroll costs between departments
• Analyze salary structure to optimize policies
• Check tax and insurance compliance with regulations
• Forecast HR costs for annual budget
• Analyze salary increase trends over time
Best Practices
Steps
1. Set up dashboards with KPIs aligned to financial goals
2. Update data after each payroll run
3. Compare with budget to control costs
4. Analyze salary structure to optimize compensation
5. Track payroll cost ratio to assess efficiency
6. Use filters to analyze from multiple angles
7. Export reports periodically for management
System Requirements
To use the Spreadsheet Dashboard HR Payroll module:
Steps
1. Install spreadsheet_dashboard module
2. Install hr_payroll module
3. Configure salary structure and rules
4. Set up tax and insurance per regulations
5. Configure dashboard access permissions for users
6. Ensure payroll data is fully updated