INDIA BUSINESS INTERNATIONAL eCommerce for the World
IBI Logo v6.1
IBI GST Report Generator
GSTR-1 from marketplace files · IBI Apps
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

Amazon GSTR Report XLSX

GSTR-1 Excel with B2B, B2B CN, B2C Small sheets.

Amazon
amazon

Amazon B2B CSV CSV

B2B transaction CSV — needed for HSN Summary & Documents Issued.

Amazon
amazon

Amazon B2C CSV CSV

B2C transaction CSV — needed for Documents Issued.

Flipkart
F Flipkart

Flipkart GSTR Report XLSX

GSTR-1 Excel with 7(A)(2), 7(B)(2) and Section 13 sheets.

mMeesho
m meesho

Meesho TCS Sales XLSX

Monthly TCS sales report from Meesho seller panel.

mMeesho
m meesho

Meesho TCS Returns XLSX

TCS returns — automatically subtracted from sales.

mMeesho
m meesho

Meesho Tax Invoice Details XLSX

Invoice_Info sheet — provides exact invoice numbers for Documents Issued.

ShopClues
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).
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 (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.