Credit notes shown in red italic after linked invoice. Net B2B = Invoices − CN.
Table 4A — B2B Invoices (Taxable outward supplies to registered persons). These are GROSS invoices — Credit Notes are reported separately in Table 9B. Upload Amazon GSTR Report to populate.
Table 9B — Credit / Debit Notes. • Credit Note (CN) — issued when goods are returned or price reduced. SUBTRACTS taxable value and GST from original invoice.
• Debit Note (DN) — issued when price increases or additional charges apply. ADDS taxable value and GST.
• Registered (B2B) = CN/DN against a GST-registered buyer (GSTIN available).
• Unregistered (B2C) = CN/DN against an unregistered buyer (Amazon B2C refunds).
Section 13 — Documents Issued. Upload the Meesho Tax Invoice Details file (from Meesho Seller Panel → Reports → Tax Invoice Details) to get exact invoice numbers like u3hs926106 → u3hs926111. Without it, only the TCS transaction count is shown.
Table 12 — HSN-wise Summary of Outward Supplies (All Platforms). The primary report HSN All Platforms combines Amazon + Flipkart + Meesho HSN data. Amazon-only breakdowns are also provided for reference. This total should match your Table 14 eCommerce Operator Net supplies.
lipkart/Meesho) do not provide HSN-level transaction data.
Table 12 — excl. B2B (B2C Only)
Turnover within ₹2 Crore — only B2C supplies are mandatory for Table 12. Upload Amazon B2C CSV to populate.
Table 12 — incl. B2B (B2C + B2B Net)
Recommended for long-term strategy. Upload both Amazon B2C CSV and Amazon B2B CSV for complete Table 12. B2B is net of Credit Notes.
B2B Only — Amazon (for reference)
Shipment Reconciliation — Reference Only (NOT for GSTR-1 filing). For each platform: Forwarded (gross value shipped out) − Returns (value returned/refunded) = Delivered (net, which is what's filed in Table 7). This is purely for your own understanding of gross vs net movement.
Step 04 — Export
Export Reports
GSTR-3B — outward tax (Table 3.1) is taken from the reports above. Enter your Input Tax Credit for the month (Table 4) — read it from your purchase records or your accountant. Leave 0 if you don't claim ITC.
Paste your deployed GAS Web App URL. Auto-saved in browser. Click 📋 GAS Code for setup instructions.
✓ SAVED
📋 Google Apps Script (GAS) Code
Step 1. Open your Google Sheet → Extensions → Apps Script Step 2. Delete all existing code, paste the code below, press Ctrl+S to save Step 3. Click Deploy → New deployment → Type: Web App Step 4. Set Execute as: Me and Who has access: Anyone → Deploy Step 5. Authorize when prompted → Copy the Web App URL → Paste in the tool Note: Each time you re-deploy, get the new URL. Set access to Anyone, not Anyone with Google account.