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.

This is simple <a href="https://hstcalculator.ca" rel="nofollow ugc">HST calculator</a> for harmonized sale tax calculation in Ontario province in Canada.
Calculator is very easy customizable: you can change color of background, borders and text to match your web site’s theme and change widget title.

Ontario HST Calculator

Add a free simple customizable Ontario HST calculator to your web site.

GST Report for WooCommerce vs Ontario HST Calculator