About this plugin
GST Report for WooCommerce is a lightweight, fast admin dashboard built entirely with native PHP and direct database queries. It generates GST-compliant reports for Indian WooCommerce stores, handles both intra-state (CGST + SGST) and inter-state (IGST) tax calculations across 18% and 5% GST rates, and lets you export to Excel or open a PDF tax invoice in one click — all without leaving WordPress admin.
Designed for Indian store owners who need to file GSTR-1, GSTR-3B, or provide tax invoices to B2B buyers, without the overhead of a full accounting plugin.
Key Features
- Setup Wizard — On first activation, a guided wizard checks your HSN codes, GST tax rates, and PDF Invoices plugin configuration so your dashboard is accurate from day one.
- GST Report tab — Line-item breakdown per order with CGST/SGST (intra-state) and IGST (inter-state) at 18%, 5%, and 0% rates, with separate columns for each. Cancelled and refunded orders appear as negative entries.
- Orders tab — Card-based order view showing customer name, GSTIN, billing state, order status, and a full per-order GST breakdown (CGST, SGST, IGST).
- Products tab — All published products with thumbnail, SKU, HSN code, price, stock quantity, GST rate, and stock status.
- Excel export — Download the filtered report as a properly formatted.xlsx file using a zero-dependency PHP XLSX writer. Includes date, invoice number, DC number, customer, GSTIN, state, HSN, quantity, subtotal, and all GST columns.
- PDF invoice — Opens the WooCommerce PDF Invoices & Packing Slips invoice for any order in a new tab with one click. Access key is read automatically from the order — no manual configuration needed.
- Flexible HSN lookup — Reads HSN from product meta ( hsn, _hsn_code ), product attributes (any attribute whose name contains “HSN”), or order-item meta — whichever is present. Checks variation first, then parent product.
- HPOS compatible — Works with both the classic wp_posts order table and WooCommerce High-Performance Order Storage (HPOS/COT). Detects automatically.
- Filtering & search — Filter by start/end date, sort newest or oldest, search by order ID or billing email. Paginated at 50 orders per page.
- Summary stat cards — Total orders, total products, revenue, total GST collected, and average order value — calculated via a single SQL aggregation query (no N+1 queries).
Who Is This For?
- Indian WooCommerce store owners filing GSTR-1 or GSTR-3B returns
- Stores selling to GST-registered buyers (B2B) who need tax invoices with GSTIN
- Accountants or store managers who need a quick Excel export of GST data for a given period
- Stores in Tamil Nadu (TN) needing CGST + SGST split, or any other state needing IGST
How GST Calculation Works
The plugin uses WooCommerce’s own tax totals stored against each order line item:
- Intra-state (TN): If billing state is Tamil Nadu, tax is split 50/50 as CGST + SGST.
- Inter-state: All other billing states are treated as IGST.
- 5% GST: Products assigned to a tax class whose name contains 5 (e.g. “GST 5%”) are reported under the 5% columns.
- 18% GST: All other taxed products are reported under the 18% columns.
- 0% / Exempt: Products with no tax are reported under the zero-rated supply column.
Technical Notes
- Pure PHP — no JavaScript frameworks, no React, no REST API.
- All data fetched via WC_Order_Query and direct SQL with $wpdb->prepare().
- All $_GET input is sanitised with sanitize_key(), sanitize_text_field(), absint(), and wp_unslash().
- All output escaped with esc_html(), esc_url(), esc_attr(), wp_kses_post().
- Stats query result cached with wp_cache_get/set.
- Nonce-protected on all export actions.