Odoo
Implementation
$ 32.99
In-App Purchases| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 2849 |
| Technical Name |
lb_gstr |
| License | OPL-1 |
| Website | https://lucidbrainz.com |
| Versions | 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 2849 |
| Technical Name |
lb_gstr |
| License | OPL-1 |
| Website | https://lucidbrainz.com |
| Versions | 17.0 18.0 19.0 |
Indian GST Reports for Odoo 18
Complete GST Compliance Solution | GSTR-1, GSTR-2, GSTR-3B, GSTR-9
Overview
Indian GST Reports by LucidBrainz is the most comprehensive GST compliance solution for Odoo 18. Generate all mandatory GST returns with 100% accuracy including GSTR-1 (Outward Supplies with B2B, B2CL, B2CS, Export, HSN Summary), GSTR-2 (Inward Supplies with B2B, B2BUR, IMPS, IMPG), GSTR-3B (Monthly Summary with ITC calculations), and GSTR-9 (Annual Return). This module automatically handles reverse charge detection, multi-currency conversion to INR, fiscal position auto-assignment, credit/debit notes with proper sign reversal, HSN-wise summaries, and generates GSTN portal-ready Excel files. Perfect for manufacturers, traders, service providers, importers, exporters, and e-commerce businesses!
Key Features
- GSTR-1 (Outward Supplies): Complete sales reporting with B2B (registered customers), B2CL (large interstate >₹2.5L), B2CS (small sales), CDNR/CDNUR (credit/debit notes), Export (with/without payment), HSN summary (B2B & B2C split), Document summary
- GSTR-2 (Inward Supplies): Complete purchase reporting with B2B (registered vendors), B2BUR (unregistered vendors), IMPS (Import of Services), IMPG (Import of Goods with port code), CDNR/CDNUR (debit/credit notes), Exempted supplies, HSN summary
- GSTR-3B (Monthly Summary): Section 3.1 (Outward supplies & reverse charge), Section 3.2 (Interstate supplies to unregistered), Section 4 (Eligible ITC with import goods/services), Section 5 (Exempt & Nil-rated supplies), Interest & Late Fee calculations
- GSTR-9 (Annual Return): Section 4 (Outward supplies - B2B, B2C, SEZ, Deemed export, Credit/Debit notes), Section 5 (Non-taxable supplies), Section 6 (ITC availed), Section 17 & 18 (HSN summaries for outward & inward)
- HSN Summary: Product-wise HSN codes with quantities in base UOM, UQC codes, tax rates (5%, 12%, 18%, 28%), IGST/CGST/SGST/CESS breakdown, separate B2B and B2C sheets for GSTR-1
- Automatic Reverse Charge Detection: Intelligently identifies vendor bills requiring reverse charge (unregistered vendors without GSTIN for domestic purchases)
- Multi-Currency Support: Foreign currency invoices (USD, EUR, etc.) automatically converted to INR using exchange rates on invoice date
- Smart Fiscal Position: Automatically sets Inter-State position when customer is in different state, Intra-State for same state, Export position for foreign countries
- Credit/Debit Notes: Proper handling with automatic sign reversal, reported in CDNR (registered) and CDNUR (unregistered) sections, links to original invoices maintained
- Professional Excel Reports: GSTN portal-ready .xls files with multiple sheets, proper formatting, headers as per official templates, downloadable with one click
Odoo 18 Module Screenshots
Odoo 18: Accounting → Reporting menu dropdown showing India GST Return Periods section
with 4 GST reports: GSTR-1 Sales Report, GSTR1 Report, GSTR2 Report, GSTR3B Report, and GSTR9
Report clearly visible alongside other standard reports.
GSTR-1 Sales Report screen showing September 2025 data with sections: B2B Invoice,
B2C(Large) Invoice, B2C(Small) Details, Credit/Debit Notes (Registered), Export Invoices,
Nil Rated Supplies, HSN summary, and ECO liable columns. PDF export and month selection
options available at top.
GSTR1 Report wizard with date selection popup. Date From field shows 09/01/2025,
Date To shows 09/30/2025. Calendar widget open displaying September 2025 with date 1 highlighted
in blue circle. Generate GSTR1 and Cancel buttons at bottom. Easy month/year navigation with
arrow buttons.
Excel file B2B sheet showing complete column structure: GSTIN/UIN of Recipient (Column A),
Receiver Name (B), Invoice Number (C), Invoice Date (D), Invoice Value (E), Place of Supply (F),
Reverse Charge (G), Applicable % of Tax Rate (H), Invoice Type (I), E-Commerce GSTIN (J), Rate
(K),
Taxable Value (L), Cess Amount (M). Multiple sheet tabs visible at bottom: b2b, b2ba, b2cl,
b2cla,
b2cs, b2csa, cdnr, cdnra, cdnur, cdnura, exp, expa.
Excel B2CL (Large Interstate Sales) sheet structure showing columns: Invoice Number (A),
Invoice Date (B), Invoice Value (C), Place of Supply (D), Applicable % of Tax Rate (E), Rate
(F),
Taxable Value (G), Cess Amount (H), E-Commerce GSTIN (I). Sheet tabs visible: b2cl selected,
others include b2cla, b2cs, b2csa, cdnr, cdnra, etc.
HSN.B2B sheet showing actual product data: Row 2 - HSN 5403 (Four Person Desk) with
UQC UNT-UNITS, 0 quantity, 0 rates. Row 3 - HSN 94036900 (Large Meeting Table) with UNT-UNITS.
Columns include: HSN (A), Description (B), UQC (C), Total Quantity (D), Total Value (E), Rate
(F),
Taxable Value (G), Integrated Tax Amount (H), Central Tax Amount (I), State/UT Tax Amount (J),
Cess Amount (K). Multiple sheets visible including hsn.b2b, hsn.b2c, docs.
GSTR-2 B2B(3) - Summary Of Supplies From Registered Suppliers sheet. Shows From: 01-Sep-25,
To: 30-Sep-25. Columns include: GSTIN of Supplier (A), Invoice Number (B), Invoice Date (C),
Invoice Value (D), Place of Supply (E), Reverse Charge (F), Invoice Type (G), Rate (H),
Taxable Value (I), Integrated Tax Paid (J), Central Tax Paid (K), State/UT Tax Paid (L),
Cess Paid (M), Eligibility For ITC (N), Availed ITC Integrated Tax (O), Availed ITC Central Tax
(P),
Availed ITC State/UT Tax (Q), Availed ITC Cess (R). Sheet tabs: b2b, b2bur, imps, impg, cdnr,
cdnur, at, atadj, exemp, itcr, hsnsum.
GSTR-3B summary sheet showing From: 01-Sep-25, To: 30-Sep-25, GSTIN: FALSE,
Legal name: YourCompany. Section 3.1 visible with rows: (a) Outward Taxable supplies (other than
zero rated, nil rated and exempted), (b) Outward Taxable supplies (zero rated), (c) Other
Outward
Taxable supplies (Nil rated, exempted), (d) Inward supplies (liable to reverse charge),
(e) Non-GST Outward supplies. Columns: Taxable Value, IGST, CGST, SGST, Cess. All values showing
0.
Section 4. Eligible ITC visible below with details section showing (A) ITC Available
subsections:
(1) Import of goods, (2) Import of services, (3) Inward supplies liable to reverse charge,
(4) Inward supplies from ISD, (5) All other ITC, (B) ITC Reversed sections. Single sheet tab
GSTR-3B visible at bottom.
GSTR-9 Annual Return "4.Outward" sheet showing From: 01-Sep-25, To: 14-Oct-25 (demonstration
dates). Header showing "Details of advances, inwards and outward supplies made during the
financial
year on which tax is payable". Columns: Nature of Supplies, Taxable Value(₹), Central Tax,
State Tax/UT Tax, Integrated tax, Cess (Amount in ₹ in all tables). Rows visible: A (Supplies
made
to un-registered persons B2C) showing 0 in all columns, B (Supplies made to registered persons
B2B)
showing 124500 taxable value, C (Zero rated supply Export on payment of tax) showing 0, D
(Supply
to SEZs on payment of tax) showing 0, E (Deemed Exports) showing 0 in all columns. Row G (Inward
supplies on reverse charge basis) showing 0 in all columns except Deemed Exports column showing
0.
Multiple sheet tabs at bottom: 4.Outward, 5 Outward, 6 ITC Availed, 17 HSN Outward, 18 HSN
Inward
with + button to add sheets.
Odoo 18 Customer Invoice form (INV/2025/00005) showing Posted status. Customer: Deco Addict
with US address (United States - US12345673). Invoice Date: 10/14/2025, Payment terms: 30 Days,
Journal: Customer Invoices in USD. Invoice Lines tab showing 3 products: [E-COM07] Large Cabinet
(Qty 1.00, Price 320.00, Taxes: -15% + CGST 9% + SGST 9%, Amount $320.00), [E-COM12] Conference
Chair (Steel) (Qty 1.00, Price 33.00, Taxes: CGST 9% + SGST 9%, Amount $33.00), [E-COM10] Pedal
Bin
(Qty 1.00, Price 47.00, Taxes: -15%, Amount $47.00). Bottom right showing: Untaxed Amount
$400.00,
Tax 15%: $55.05, CGST 9%: $31.77, SGST 9%: $31.77, Total: $518.59, Amount Due: $518.59.
Outstanding credits section showing 4 credit notes (RINV/2025/00004 $41,750.00, RINV/2025/00005
$19,250.00, RINV/2025/00003 $31,750.00, MISC/2025/09/0001 $2,500.00). Module reads this invoice
data to populate GST reports with GSTIN, tax breakup, and amounts.
Our Services
Odoo
Customization
Odoo
Migration
Support &
Maintenance
📞 Contact Us
WhatsApp:
Email:
Website: |
🌐 Follow Us📘 Facebook 📸 Instagram 💼 LinkedIn 🎥 YouTube |
© 2025 LucidBrainz Infotech | All Rights Reserved | License: AGPL-3
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