Indian GST Invoicing
HSN Invoice Report
Automatically group line items by HSN/SAC codes in your PDF invoices, display detailed CGST/SGST/IGST splits, and export complete HSN transaction details to Excel.
INDIA GST COMPLIANCE
CGST / SGST / IGST
GSTR-1 Excel Report
Trusted Partners
More Than 150+ Brands
The HSN Invoice Report module by Ahex Technologies adds automated grouping of products and services on invoice PDF printouts and provides a reporting tool to export HSN-wise sales details. It operates without requiring manual sorting or layout adjustments.
It adds a customized invoice layout where items are clustered under their respective HSN/SAC code headers. Additionally, the module adds a wizard in Odoo Accounting to generate structured Excel reports containing HSN details, quantities, taxable values, and tax splits.
HSN / SAC PDF Grouping
Lines on the printed PDF invoice are grouped under HSN or SAC code headers automatically.
Tax Rate & Amount Splits
Shows dedicated columns for Rate and Amount for CGST, SGST, and IGST on each invoice line item.
Custom PDF Layout
Features a custom external layout with company logo, header details, payment terms, and page numbers.
GSTR-1 HSN Excel Wizard
Generates a date-filtered XLSX sheet of HSN transactions directly from Odoo Accounting reports.
Additional Custom Fields
Adds fields for HSN description on products; partner type/code on contacts; and USD rate, invoice type, & PO number on invoices.
Out-of-the-Box Setup
Install the module, enter HSN/SAC codes on your products, and the layout and wizard are ready to use.
Below is a representation of the invoice body table generated in the custom PDF layout, showing line items grouped under HSN/SAC headers
| S.No | Description | Qty | Rate | Disc% | CGST (Rate/Amt) | SGST (Rate/Amt) | IGST (Rate/Amt) | Price |
|---|---|---|---|---|---|---|---|---|
| HSN/SAC Code : 8471 | ||||||||
| 1 | Computer Hardware | 1.0 | 50,000.00 | 0.00 | 9% (4,500.00) | 9% (4,500.00) | 0% (0.00) | 50,000.00 |
| HSN/SAC Code : 998314 | ||||||||
| 2 | IT Implementation Services (SAC) | 1.0 | 30,000.00 | 0.00 | 0% (0.00) | 0% (0.00) | 18% (5,400.00) | 30,000.00 |
| Subtotal | 80,000.00 | |||||||
| GST | 14,400.00 | |||||||
| Total | ₹ 94,400.00 |
The module includes a wizard to export HSN detail reports within custom date ranges. The generated Excel spreadsheet (.xlsx) contains the following columns
| HSN | HSN Desc | UQC | Voucher Number | Voucher Date | Total Quantity | Total Value | Rate Of Tax | Taxable Value | IGST | CGST | SGST | Cess |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8471 | Computer Hardware | NOS | INV/2026/ 0001 | 01-06-2026 | 1.0 | 59,000.00 | 18.00 | 50,000.00 | 0.00 | 4,500.00 | 4,500.00 | 0.00 |
The module extends Odoo's standard database tables with the following fields to track additional compliance and trade data
| Model / Form View | Field Name | Label / Description | Type / Values |
|---|---|---|---|
| res.partner (Contacts Form) | party_type | Party Type | Selection (Customer, Vendor, Other) |
| partner_code | Partner Code | Char | |
| product.template (Products Form) | hsn_description | HSN Description | Char |
| usd_currency_rate | USD Currency Rate | Float (Default: 1.0) | |
| account.move (Invoices Form) | invoice_type_custom | Invoice Type Custom | Selection (Local, Export) |
| x_studio_customer_po_no | Customer PO Number | Char |
Module Installation
Place the folder in your custom addons path, update the app list in Developer Mode, and click install. The module will install with no extra configurations.
Update Product & Contact Records
Configure HSN/SAC codes on product templates along with the HSN Description field. Add Party Type and Partner Code on the contact records if required.
Create Customer Invoices
Create customer invoices as usual. Standard invoicing works normally, with optional fields available to record PO numbers, currency rates, and custom invoice types.
Print Grouped Invoice PDFs
When printing invoices, the new template is automatically applied. The lines are grouped by HSN/SAC codes, and CGST/SGST/IGST rates and amounts are displayed per line.
Export HSN Excel Summary
Go to Accounting > Reporting > GSTR-1 HSN Detail Report. Specify a Start Date and End Date, then click "Generate Report" to build and download the Excel file.
Compatibility
- Odoo.sh
- On-Premise
- Community Edition
- Enterprise Edition
Dependencies
Invoicing
Indian Localization (l10n_in)
- No third-party libraries required.
- No external services required.
- All standard Odoo modules available in both Community and Enterprise.
Ready to Print GST-Compliant Invoices?
Get the HSN Invoice Report module for Odoo, to enable automated HSN-grouped PDF invoices and generate date-filtered Excel summaries.
What Our Clients Say About Us
Explore Our Blogs on Odoo Integration
Related to Implementation
The module inherits three models: account.move (Invoices), product.template (Products), and res.partner (Contacts).
Yes. The module provides a transient wizard model (hsn.report.wizard) that writes data using xlsxwriter to let you download the report in base64 binary formats.
It reads tax mappings from line items, looks up the tax group (checking for CGST, SGST, IGST, and Cess), computes the values, and scales them by the custom USD currency rate multiplier if USD invoicing is used.
Yes, the PDF template checks and displays the discount percentage (Disc%) and applies it to calculate the line-level rates, taxes, and subtotal pricing.
It uses the Odoo Proprietary License (OPL-1) and is published by Ahex Technologies.
Minimum Order Quantity
Forem ipsum dolor sit amet, consectetur adipiscing elit. Nunc vulputate libero et velit interdum, ac aliquet odio mattis. Class aptent taciti sociosqu ad litora
Know more ➞
Minimum Order Quantity
Forem ipsum dolor sit amet, consectetur adipiscing elit. Nunc vulputate libero et velit interdum, ac aliquet odio mattis. Class aptent taciti sociosqu ad litora
Know more ➞
Minimum Order Quantity
Forem ipsum dolor sit amet, consectetur adipiscing elit. Nunc vulputate libero et velit interdum, ac aliquet odio mattis. Class aptent taciti sociosqu ad litora
Know more ➞
Looking for a Solution? Let's Talk
- sales@ahex.co.in
- (India) +91 - 8885564224
- (USA) +1 - 6503197394
DEVELOPERS
YEARS IN OPERATION
GLOBAL CLIENTS
