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.

anku1991

The plugin displays the GST Calculator widget anywhere you want with the help of a shortcode. The plugin is very easy to use as you just need to put the shortcode to any post, page, or sidebar in order to display the widget. 
You can also add as a widget on your page in order to disply the calculator.
Shortcode: [wpgstcal]
NOTE: Please do clear or purge website cache after plugin activation.

Awesome GST Calculator Widget

The plugin displays the GST Calculator widget anywhere you want with the help of a shortcode. The plugin is very easy to use as you just need to put t …

GST Report for WooCommerce vs Awesome GST Calculator Widget