$ 115.29
In-App Purchases| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Payroll (hr_payroll)
• Discuss (mail) • Employees (hr) • Time Off (hr_holidays) • Employee Contracts (hr_contract) • Recruitment (hr_recruitment) • Sign (sign) • Calendar (calendar) • Invoicing (account) • Accounting (account_accountant) |
| Community Apps Dependencies | Show |
| Lines of code | 2415 |
| Technical Name |
kaz_payroll_report |
| License | OPL-1 |
| Website | http://www.kaizenae.com/ |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Payroll (hr_payroll)
• Discuss (mail) • Employees (hr) • Time Off (hr_holidays) • Employee Contracts (hr_contract) • Recruitment (hr_recruitment) • Sign (sign) • Calendar (calendar) • Invoicing (account) • Accounting (account_accountant) |
| Community Apps Dependencies | Show |
| Lines of code | 2415 |
| Technical Name |
kaz_payroll_report |
| License | OPL-1 |
| Website | http://www.kaizenae.com/ |
Payroll XLSX Report
for Odoo
Kaizen Payroll XLSX Report streamlines payroll analysis by generating clean, audit-ready Excel reports directly from Odooâno manual spreadsheets, no data stitching. With one click, HR and Finance can filter by date range or employee and export a comprehensive Cost-to-Company (CTC) view covering basic salary, housing and phone allowances, airfare and joining ticket, medical/life/workmen compensation insurance, visa and pension contributions, and provisions (leave, gratuity, bonus, training). The module adds essential HR/contract fields for richer reporting, applies consistent formatting in XLSX, and logs everything within Odoo for secure, role-based access. Ideal for monthly payroll cycles, management reviews, and external audits, it improves accuracy, saves hours of manual work, and gives stakeholders clear, reliable numbersâinstantly.
© 2025 Kaizen Principles
What's New in Payroll XLSX Report for Odoo
Detailed Payroll Reporting
Customizable Filters
Extended Contract Information
Comprehensive Output
Kaizen Principles
Your Partner
We're here to support your growth 24/7. Connect with our experts now.
All Features
Comprehensive Payroll Overview: Generate detailed CTC reports including wages, allowances, insurance, provisions, and visa costs.
Customizable Filters: HR can filter by employee and date range, ensuring reports are precise and context-specific.
Error-Free Reporting: Automatic calculations for provisions (leave, gratuity, bonus, pension) reduce manual errors.
Regulatory Alignment: Includes cost breakdowns (medical, life insurance, worker compensation, visa, pension) often required for audits and compliance.
Time Savings: Finance teams no longer need to manually prepare Excel templatesâreports are auto-generated in professional format.
Self-Service Access: Reports are stored inside Odoo, ensuring controlled access and auditability.
Kaizen's Top App Recommendations
Take a look at our other Odoo apps designed to make your life easier with a smooth workflow. Don't miss the chance to uplift your Odoo ERP experience with our apps!
More Apps »
POS Tamara
Pay point of sale orders with tamara payment gateway and refund orders paid with tamara....
Learn More »
UAE Corporate Tax
Get Complete State-specific legislation view of Company income taxes Generate / redraft related journals at any time during the year...
Learn More »
Stock Report PDF
PDF report to print inventory transactions using different fillters...
Learn More »
Payment Provider: Tamara
Integration With Tamara Payment Gateway (E-commerce and Point of Sale)...
Learn More »Free 30 Days Support
Kazien Principles will provide FREE 30 days support for any doubt, queries, and bug fixing (excluding data recovery) or any type of issues related to this module. This is applicable from the date of purchase.
Payroll XLSX Report
Gain full transparency into payroll costsâHR and Finance can export a single, well-structured XLSX workbook for any period or employee straight from Payroll ⸠Reports. With one click, the report pulls live payslip data and contract fields, organizing each employeeâs earnings (Basic, housing, phone, overtime, one-time items) and deductions (pension, gratuity/leave provisions, insurance, visa) with clear per-employee subtotals and a grand CTC total. Columns are already formatted for analysis (frozen header row, widths set, number formats applied), while optional fields like medical/life insurance, workmen compensation, airfare/joining ticket, and visa costs appear only when relevantâkeeping the sheet clean and audit-ready. Because itâs read-only and built on your existing payroll configuration, nothing in payslips or rules changesâyet monthly closing speeds up, manual spreadsheets disappear, and finance handover becomes a download. Ideal for month-end review, management reporting, and external auditsâwithout complex setup or new workflows.
Contract Details & Cost Snapshot
Benefits & Cost Allocation
Open âEmployees CTC Reportâ
Set Period & Employee
Review the Excel Output (CTC Breakdown)
Contract Details & Cost Snapshot
Review the employeeâs contract at a glanceâstart/end dates, structure type, schedule, and wageâthen validate the auto-computed cost summary (monthly & yearly). Confirm salary components (Basic, Supplemental Allowance, Guaranteed Salary) and benefits before proceeding. This step ensures the payroll report pulls accurate contract figures and CTC.
Benefits & Cost Allocation
Capture all contract extras that influence CTCârecurring allowances (mobile, housing, social, child), one-time items (joining ticket, mobile device, airfare), and employer costs (medical, life insurance, worker compensation, visa) with their start/end dates. These values feed the XLSX report to prorate monthly costs correctly and keep audit totals accurate.
Open âEmployees CTC Reportâ
From Payroll ⸠Reporting, launch the Employees CTC Report. This entry point opens the wizard where you choose the period and (optionally) an employee, then export the consolidated XLSX with earnings, deductions, and employer costsâready for month-end review and audits.
Set Period & Employee
In the Employee Payroll Report wizard, choose the Start Date and End Date (and optionally a specific Employee) to scope the export. Click Print XLSX to generate the consolidated workbook with earnings, deductions, and employer costs for the selected window.
Review the Excel Output (CTC Breakdown)
Open the generated Payroll Excel Report.xlsx and verify the sections: Employee profile (name, email, unit, department, grade, job), monthly earnings (Basic, Supplemental, Housing, Phone), one-time items (Mobile Device, Airfare), period info (From/To, Days), computed amounts (Prorated Gross, Net), and employer provisions/costs (Gratuity, Bonus, Medical, Life, Workmen Compensation, Training, Visa, UAE Pension, Joining Ticket) culminating in Total CTC. Headers are frozen and columns pre-formatted for quick analysis and audit sharing.
Why Kaizen
You know us as the makers of the Odoo "Payroll XLSX Report for Odoo".
Kaizen's Top App Recommendations
Take a look at our other Odoo apps designed to make your life easier with a smooth workflow. Don't miss the chance to uplift your Odoo ERP experience with our apps!
More Apps »
POS Tamara
Pay point of sale orders with tamara payment gateway and refund orders paid with tamara....
Learn More »
UAE Corporate Tax
Get Complete State-specific legislation view of Company income taxes Generate / redraft related journals at any time during the year...
Learn More »
Stock Report PDF
PDF report to print inventory transactions using different fillters...
Learn More »
Payment Provider: Tamara
Integration With Tamara Payment Gateway (E-commerce and Point of Sale)...
Learn More »Kaizen Odoo Services
Upscale your business with expert services from an Odoo Gold Partner.
Module Development
Implementation
Customization
Integration
Migration
Support & Maintenance
Consulting
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