Guide
How to use the Website GST Summary (Shopify / WooCommerce)
1. Download the reports
Shopify orders export
- 1Shopify admin → Orders → filter the month (Date → custom range) → Export.
- 2Choose All orders matching your search and CSV for Excel. Shopify emails the CSV if there are many orders.
- 3Upload that CSV unchanged. Every line item is read; the tax lines ("Tax 1 Name" = "IGST 18%") give the rate when you haven't listed the SKU.
WooCommerce orders export
- 1WooCommerce has no built-in order CSV with line items, so use an export plugin such as Advanced Order Export For WooCommerce (free), one row per product.
- 2Include: Order Number, Order Date, Order Status, State Code (Shipping), Payment Method Title, Transaction ID, SKU, Item Name, Quantity, Order Line Total, Order Line Tax, Order Shipping Amount, Order Total Amount, Order Refund Amount.
- 3Export as CSV or Excel and upload it here.
Menu names in Seller Central change now and then. If a label looks different, search the report name in Seller Central's search bar.
2. Read the results
B2C by state & rate
Taxable value and tax per place of supply (ship-to state) and rate, net of refunds: GSTR-1 Table 7.
B2B invoices
Orders with a valid buyer GSTIN (add a GSTIN field at checkout and include it in the export): Table 4A.
B2CL
Inter-state B2C invoices above the limit (₹1 lakh by default): Table 5.
Credit notes
Refunds (the "Refunded Amount" of each order) as credit notes: Table 9B.
HSN summary
By HSN and rate, from your "SKU, HSN, rate" list: Table 12.
Order checks
Orders where the store's tax differs from the tax worked out here, totals that don't add up (gift cards, tips), or a missing ship-to state.
3. What to do next
- Enter your GSTIN and the "SKU, HSN, rate" list once (it is saved in this browser) and run again.
- Fix anything in Order checks, then download the CSVs for your CA or filing software.
- Use Website to Tally for the sales vouchers and Payment Gateway Reconciliation to check the money arrived.
4. Good to know
- •Export one month at a time, by order date.
- •GST on shipping charged with the goods follows the main item's rate (composite supply); change it in Settings if your CA treats it differently.
- •Your own website is not an e-commerce operator collecting TCS, so these sales are not in Table 14.
- •This is a working summary, not a filing. Have your CA verify it.
5. FAQ
Shopify charges the tax for me. Do I still need this?
Shopify only adds tax to the price; it doesn't file anything. You still report every website sale in GSTR-1 under your own GSTIN, by place of supply and rate. This turns the export into those tables.
My WooCommerce store has no tax set up.
Then your prices include GST. Leave "Store prices include GST?" on automatic and list each SKU's rate; the tool takes the tax out of the price.
Are my files stored?
No. The file is processed on our server in memory and deleted straight away. Customer names and addresses in the export are not read.
It says a column is missing. What now?
You probably uploaded a different report, or Amazon renamed a column. Download the report exactly as in step 1. If it still fails, tell us the report name and we'll add support.