Step 01 — Upload Source Files
Platform GST Reports
All files are optional — upload only what you have for the month. Missing platforms are simply skipped.
Amazon
Amazon GSTR Report XLSX
GSTR-1 Excel with B2B, B2B CN, B2C Small sheets.
—
Amazon
Amazon B2B CSV CSV
B2B transaction CSV — needed for HSN Summary & Documents Issued.
—
Amazon
Amazon B2C CSV CSV
B2C transaction CSV — needed for Documents Issued.
—
Flipkart
Flipkart GSTR Report XLSX
GSTR-1 Excel with 7(A)(2), 7(B)(2) and Section 13 sheets.
—
Meesho
Meesho TCS Sales XLSX
Monthly TCS sales report from Meesho seller panel.
—
Meesho
Meesho TCS Returns XLSX
TCS returns — automatically subtracted from sales.
—
Meesho
Meesho Tax Invoice Details XLSX
Invoice_Info sheet — provides exact invoice numbers for Documents Issued.
—
ShopClues
ShopClues GSTR Report XLSX
Upload only if you had sales on ShopClues this month.
—
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).
• 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).
9B Registered — B2B Credit/Debit Notes
9B Unregistered — B2C Credit Notes (Amazon Refunds)
Source: Amazon B2C CSV Refund rows with non-zero taxable value. Upload Amazon B2C CSV to populate.
Flipkart B2C — Intra + Inter State (Table 7)
Flipkart — Documents Issued (Section 13)
Meesho B2C — Net (Sales − Returns)
Note: Net = Sales file minus Returns file, grouped by state + rate. Negative = returns exceeded sales.
Meesho — Raw Detail (for Verification)
ShopClues B2C — All Supplies
Table 7 (B2C) — all platforms consolidated. Table 4A (B2B) — Amazon only.
B2C Combined — All Platforms (Table 7)
B2B + Credit Notes — Amazon (Table 4A)
Platform-wise Net Summary
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. Source: Amazon B2B CSV (Shipment rows, net of Credit Notes) + Amazon B2C CSV. Other platforms (Flipkart/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)
Step 04 — Export
Export Reports
Paste your deployed GAS Web App URL. Auto-saved in browser. Click 📋 GAS Code for setup instructions.