GST Report for WooCommerce

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.