| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Employee Contracts (hr_contract)
• Time Off (hr_holidays) • Employees (hr) • Discuss (mail) • Calendar (calendar) |
| Community Apps Dependencies | Show |
| Lines of code | 3254 |
| Technical Name |
monthly_salary_slip_report |
| License | LGPL-3 |
| Website | https://www.ash.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Employee Contracts (hr_contract)
• Time Off (hr_holidays) • Employees (hr) • Discuss (mail) • Calendar (calendar) |
| Community Apps Dependencies | Show |
| Lines of code | 3254 |
| Technical Name |
monthly_salary_slip_report |
| License | LGPL-3 |
| Website | https://www.ash.com |
📑 Monthly Salary Slip Report
Generate a complete, ready-to-share monthly salary sheet in Excel format for all employees — with dynamic salary components and one-click export, directly from Payroll.
Month & Year Selection
Pick any month and year from a simple, intuitive wizard form.
Excel Export
Generates a polished .xlsx file with styled headers, borders and formatted amounts.
Dynamic Components
Automatically includes every salary rule found in the selected payslips — no hardcoded columns.
Gross & Net at End
Gross and Net Salary columns are always positioned last for quick scanning.
Employee Details
Each row includes Employee Name, Code and Department alongside salary figures.
Instant Download
Click Print — the file is generated and downloaded immediately, no extra steps.
Open Report
Go to Payroll → Reports → Monthly Salary Slip Report.
Select Month & Year
Choose the payroll period you want to generate the sheet for.
Click Print
The system fetches all confirmed (done) payslips for that period.
Columns Built
Salary components from those payslips become dynamic columns; Gross & Net move to the end.
Excel Downloaded
A formatted .xlsx file downloads instantly, ready to share or print.
| SL | Employee Name | Employee Code | Department | Basic | HRA | Deduction | Gross | Net Salary |
|---|---|---|---|---|---|---|---|---|
| 1 | Ahmed Khan | EMP-001 | Sales | 5,000.00 | 1,000.00 | 200.00 | 6,000.00 | 5,800.00 |
| 2 | Sara Ali | EMP-002 | HR | 4,500.00 | 900.00 | 180.00 | 5,400.00 | 5,220.00 |
| 3 | John Smith | EMP-003 | IT | 6,200.00 | 1,200.00 | 300.00 | 7,400.00 | 7,100.00 |
| 4 | Maria Lopez | EMP-004 | Finance | 3,800.00 | 760.00 | 150.00 | 4,560.00 | 4,410.00 |
⚡ Columns shown above (Basic, HRA, Deduction, Gross, Net Salary) are examples — actual columns depend on the salary rules configured in your Payroll module and used in the selected month's payslips.
| Item | Detail |
|---|---|
| Odoo Version | 17.0 |
| License | LGPL-3 |
| Category | Human Resources / Payroll |
| Dependencies | hr_payroll_community |
| New Models | salary.sheet.wizard, report.monthly_salary_slip_report.salary_sheet_xlsx |
| Output Format | Excel (.xlsx) via xlsxwriter |
| Menu Location | Payroll → Reports → Monthly Salary Slip Report |
| Payslip Filter | Status = Done, within selected month/year date range |
Please log in to comment on this module