AI prompt: convert a Snapdeal report into the AprilTax B2C sheet

1. In Snapdeal Seller Zone, export your GST / tax sales report for the filing month (Reports section). Also download the AprilTax B2C template.

2. Open ChatGPT or Claude, attach both files, and paste this prompt:

3. CopyConvert my attached Snapdeal sales report into the attached AprilTax B2C template, keeping the template's exact column headers. Rules:
   
   1. One row per order line. Include return/refund rows too.
   2. State = the buyer's delivery state. Write it as the GST state code + name, e.g. "02-Himachal Pradesh", "27-Maharashtra". Use the shipping state, never the seller's state.
   3. Rate = the GST rate as a plain number (0, 3, 5, 12, 18 or 28). If the report gives tax amounts instead of a rate, derive it: rate = tax ÷ taxable × 100, rounded to the nearest standard rate.
   4. Taxable Value = the pre-GST amount. If the report shows a GST-inclusive price, back-calculate: taxable = price × 100 ÷ (100 + rate). Returns, refunds and cancellations must be NEGATIVE taxable values.
   5. HSN Code and Quantity - copy from the report when present, else leave blank.
   6. Invoice Number - copy the invoice number from the report (used for the documents summary).
   7. Platform/Ledger Name = "Snapdeal" on every row.
   8. GSTIN of e-commerce operator = the Snapdeal GSTIN exactly as shown on my GST portal TCS statement (it looks like 09AABCJ8820B1C3) - same value on every row.
   9. After converting, show me: total taxable value per rate, and the count of positive vs negative rows - so I can check them against the report.
   
   Give me the result as a downloadable Excel (.xlsx) file.

4. Check the AI's summary against your Snapdeal report: per-rate totals should match, and returns should show as negative rows.

5. Upload the converted file at Step 1 - Upload → Other Platforms → B2C Sheet. With the operator GSTIN filled, your Snapdeal sales also land in Table 14 and reconcile against the portal's TCS statement in the TCS Match step.

💡 This mapping is taken from real Snapdeal filings done through AprilTax - state written as "code-name", Snapdeal's operator GSTIN on every row, returns as negatives. Myntra and Jio prompts work the same way - only the operator GSTIN changes.