HSN Invoice Report & GSTR-1 Excel Export
Group products by HSN codes, calculate CGST/SGST/IGST tax rates per line on PDF invoices, and export GSTR-1 compliant Excel sheets.
Simplify GST & HSN Compliance
Under the Indian GST regime, businesses are required to report transaction details grouped by HSN/SAC codes and provide accurate tax rate splits (CGST, SGST, IGST, and Cess) for tax filings. Doing this manually or altering default invoice templates can be extremely tedious. This module solves the issue by grouping invoice product lines by HSN/SAC codes on printed PDF invoices, and offering a robust date-range wizard to export detailed GSTR-1 HSN Excel reports in seconds.
Key Features
HSN PDF Grouping
Automatically aggregates and groups invoice lines by their HSN/SAC codes on printed customer invoice PDF documents.
GSTR-1 Excel Export
Provides a date-range wizard to generate and download GSTR-1 HSN Detail spreadsheet reports, pre-calculated and ready for filing.
Line Tax Splits
Calculates and separates CGST, SGST, IGST, and Cess rates and amounts per line, formatting them into dedicated columns.
USD Currency Conversion
Converts values using invoice-level USD exchange rates to output standard Indian Rupees (INR) amounts in compliance documents.
Partner Party metadata
Configures Partner profiles with Party Type (Customer, Vendor, Other) and Partner Code fields for detailed transaction tracking.
Invoice Metadata Headers
Tracks Customer PO Number and Custom Invoice Types (Local vs Export) directly on the customer invoice layout.
GSTR-1 HSN Excel Report
The module features a built-in wizard to query, compute, and download the GSTR-1 HSN Detail Excel Report. This spreadsheet organizes data under columns for HSN, HSN Descriptions, Unit Quantity Codes (UQCs), quantities, values, tax rates, and tax divisions (CGST/SGST/IGST/Cess), allowing you to easily copy and upload details to compliance portals.
Step-by-Step Workflow
|
1
|
Product HSN ConfigurationConfigure your product templates with their respective HSN/SAC codes and custom HSN Descriptions under the Product Form. |
|
2
|
Invoice Custom FieldsUpon creating customer invoices, fill out the custom PO number, invoice type (local or export), and USD currency multiplier rate if invoicing in foreign currency. |
|
3
|
Print Grouped Invoice PDFFrom your invoice view, select "Print -> HSN Invoice Report". The generated PDF report will group all product lines by HSN/SAC codes automatically with subtotal summaries. |
|
4
|
Export GSTR-1 Excel DataGo to Invoicing -> Reporting -> HSN Detail Report. Specify your start and end dates in the wizard, and click "Generate Report" to download your GSTR-1 HSN Excel file. |
Report Columns Structure
The exported GSTR-1 HSN Excel report generates the exact statutory data columns required for verification and uploading:
| Column Header | Data Extraction & Mapping Logic |
|---|---|
| HSN / HSN Desc | Retrieves the product's HSN Code and customized HSN Description. |
| UQC | Unit Quantity Code mapped from the product's Unit of Measure (UoM). |
| Voucher Num & Date | The Odoo invoice sequence number and invoice date. |
| Total Qty & Value | The quantity sold and the total value (Taxable Subtotal + Calculated GST). |
| Rate Of Tax / Taxable Val | The combined tax rate percentage and the discounted line subtotal (converted to INR). |
| IGST / CGST / SGST / Cess | Calculated tax splits based on tax types, converted to INR if utilizing exchange rates. |
Technical Details
This module works in combination with standard Odoo accounting taxes. Ensure your products have valid HSN/SAC codes assigned under the standard localization tab to enable successful groupings.
| Information | Detail |
|---|---|
| Technical Name | hsn_invoice_report_ahex |
| Odoo Version | 18.0 (Community & Enterprise Editions) |
| Dependencies | account l10n_in |
| License | OPL-1 |
| Author | Ahex Technologies |
| Website | www.ahex.co |
Frequently Asked Questions
How does the HSN grouping work on printed PDF invoices?
The PDF report iterates over the invoice's lines, extracts unique HSN codes, and clusters all matching line items under dynamic HSN subheadings with subtotals, rather than rendering a single flat list.
Does the GSTR-1 Excel export handle currency rates?
Yes. If the invoice is processed in USD, the wizard checks the specified USD Currency Rate on the invoice record, automatically converting taxable amounts and taxes into Indian Rupees (INR) for portal compatibility.
How are CGST, SGST, and IGST rates determined?
The module inspects the tax mapping configurations on the invoice lines. It matches tax group names containing "CGST", "SGST", or "IGST", calculating the appropriate values and percentages per product.
Can we run the GSTR-1 wizard for multiple companies?
Yes. The GSTR-1 Excel wizard respects Odoo's multi-company environment, automatically filtering invoices belonging to the currently active user company.
Professional Support & Integration
Need help mapping custom taxes, configuring specific invoice report paper orientations, or adjusting layout column widths? Our engineering team is here to assist.
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 534 |
| Technical Name |
hsn_invoice_report_ahex |
| License | OPL-1 |
| Website | https://ahex.co |
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