Setups Works

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.
<h4>Key Features</h4>
<ul>
<li>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.</li>
<li>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.</li>
<li>Orders tab — Card-based order view showing customer name, GSTIN, billing state, order status, and a full per-order GST breakdown (CGST, SGST, IGST).</li>
<li>Products tab — All published products with thumbnail, SKU, HSN code, price, stock quantity, GST rate, and stock status.</li>
<li>Excel export — Download the filtered report as a properly formatted <code>.xlsx</code> file using a zero-dependency PHP XLSX writer. Includes date, invoice number, DC number, customer, GSTIN, state, HSN, quantity, subtotal, and all GST columns.</li>
<li>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.</li>
<li>Flexible HSN lookup — Reads HSN from product meta (<code>hsn</code>, <code>_hsn_code</code>), product attributes (any attribute whose name contains “HSN”), or order-item meta — whichever is present. Checks variation first, then parent product.</li>
<li>HPOS compatible — Works with both the classic <code>wp_posts</code> order table and WooCommerce High-Performance Order Storage (HPOS/COT). Detects automatically.</li>
<li>Filtering & search — Filter by start/end date, sort newest or oldest, search by order ID or billing email. Paginated at 50 orders per page.</li>
<li>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).</li>
</ul>
<h4>Who Is This For?</h4>
<ul>
<li>Indian WooCommerce store owners filing GSTR-1 or GSTR-3B returns</li>
<li>Stores selling to GST-registered buyers (B2B) who need tax invoices with GSTIN</li>
<li>Accountants or store managers who need a quick Excel export of GST data for a given period</li>
<li>Stores in Tamil Nadu (TN) needing CGST + SGST split, or any other state needing IGST</li>
</ul>
<h4>How GST Calculation Works</h4>
The plugin uses WooCommerce’s own tax totals stored against each order line item:
<ul>
<li>Intra-state (TN): If billing state is Tamil Nadu, tax is split 50/50 as CGST + SGST.</li>
<li>Inter-state: All other billing states are treated as IGST.</li>
<li>5% GST: Products assigned to a tax class whose name contains <code>5</code> (e.g. “GST 5%”) are reported under the 5% columns.</li>
<li>18% GST: All other taxed products are reported under the 18% columns.</li>
<li>0% / Exempt: Products with no tax are reported under the zero-rated supply column.</li>
</ul>
<h4>Technical Notes</h4>
<ul>
<li>Pure PHP — no JavaScript frameworks, no React, no REST API.</li>
<li>All data fetched via <code>WC_Order_Query</code> and direct SQL with <code>$wpdb->prepare()</code>.</li>
<li>All <code>$_GET</code> input is sanitised with <code>sanitize_key()</code>, <code>sanitize_text_field()</code>, <code>absint()</code>, and <code>wp_unslash()</code>.</li>
<li>All output escaped with <code>esc_html()</code>, <code>esc_url()</code>, <code>esc_attr()</code>, <code>wp_kses_post()</code>.</li>
<li>Stats query result cached with <code>wp_cache_get/set</code>.</li>
<li>Nonce-protected on all export actions.</li>
</ul>

GST Report for WooCommerce

A native PHP GST dashboard for WooCommerce — CGST/SGST/IGST breakdown, Excel export, and PDF tax invoices. No JavaScript frameworks, no REST API.

qubenza

MarginMinds GST helps Indian WooCommerce store owners handle GST effortlessly.
Configure your business GSTIN, apply CGST/SGST or IGST, collect customer GSTIN at checkout, and generate GST-compliant PDF invoices — all from a single, easy-to-use settings panel.
<h3>Source Code</h3>
The full source code is available at: https://github.com/Qubenza/marginminds-gst
Free Features:
<ul>
<li>Configure business GSTIN and legal name</li>
<li>Enable CGST/SGST or IGST tax types</li>
<li>Set default GST rate (0%, 5%, 12%, 18%, 28%)</li>
<li>Inclusive and exclusive tax pricing</li>
<li>Apply GST based on customer shipping state</li>
<li>GSTIN field at WooCommerce checkout (optional / required)</li>
<li>Save customer GSTIN to orders</li>
<li>Display GST breakdown on cart, checkout, and order summary</li>
<li>GST details in order confirmation emails</li>
<li>PDF invoice generation with invoice prefix</li>
<li>GSTIN printed on invoice</li>
<li>Attach invoice PDF to order emails</li>
<li>Dashboard overview</li>
</ul>
Coming in Pro:
<ul>
<li>Advanced GST Reports (GSTR-1, GSTR-3B ready)</li>
<li>HSN / SAC Code Support per product</li>
<li>Export to CSV / Excel</li>
<li>B2B and B2C GST Handling</li>
<li>Priority Support</li>
</ul>

MarginMinds – GST & Tax Invoice for WooCommerce

Generate GST-compliant tax invoices, CGST/SGST/IGST breakdowns, and advanced tax summaries for WooCommerce stores.

GST Report for WooCommerce vs MarginMinds – GST & Tax Invoice for WooCommerce