Reports
Marketplace GST report checks
A marketplace GST report is only useful after you name the client, the marketplace, the report type, and the month. The file is then checked against that marketplace’s column map. Rows are copied into one standard transaction list. The original file is left unchanged.
Checklist updated 18 Nov 2026. Part of GST accounting. Check one amount in the GST calculator. Crop a label PDF in the shipping label cropper.
Which marketplace GST report to download
Download the tax or GST sales report for that month from the seller account. Use it for invoices, HSN, taxable value, and GST. If you also need fees and TCS, download the settlement or payments report as a second file with its own report type.
Do not add a tax report and a settlement report into one sales total. The tax report is the sales source. The settlement report is the fees and TCS source. Each file keeps its own template version, so a column change on Amazon does not break Flipkart.
- Amazon, Flipkart, Meesho, Myntra, Snapdeal, JioMart, and Paytm each have their own column map
- A further marketplace is a new map, not a new calculator
- Accepted files are CSV and XLSX
- You can select more than one file when they share the same client, marketplace, report type, and month
What must pass before processing starts
The check covers the extension, the size limit on your plan, whether the file opens, the column names, the mandatory columns, the data types, and blank values in required fields. A corrupt file or a file for the wrong marketplace stops here, with the reason on screen.
A duplicate is the same checksum for the same client, marketplace, report type, and period. You get a warning before those rows are processed again. If you continue, the new run is a separate attempt. It does not delete the earlier transactions or the earlier JSON and XML files.
How rows become one transaction list
Marketplace column names stay in the template. The processing step writes a standard row: order id, item id, invoice number and date, order date, transaction type, product name, SKU, HSN, quantity, selling price, taxable value, discount, shipping, GST rate, CGST, SGST, IGST, cess, TCS, fees, refund, settlement, customer state, and place of supply.
Dates are stored in one format. Money is stored in rupees and paise. GST rates use the same list of slabs. State names are stored with their state codes. Optional cells can be empty. A missing HSN, a GST rate that is not on the slab list, a bad date, or a transaction type the template does not know is an error row, not a silent zero.
How a row is classified
Each marketplace template maps its own status words onto a short list: sales, sales returns, refunds, cancelled orders, credit notes, debit notes, shipping, marketplace adjustments, fees and commission, TCS, and other adjustments. Returns and refunds stay out of the sales total. Fees stay out of taxable value unless the template says that column is already part of the tax base.
Do this in order
- Open the client.
- Choose the marketplace, the report type, the financial year, and the month.
- Upload the CSV or Excel file you downloaded from that seller account.
- Read the validation result. Fix a rejected file in the source report and upload it again, or correct the error rows the screen lists.
- Process the file. The summary shows records read, records kept, records failed, sales, returns, taxable value, GST, TCS, fees, and refunds.
Figures to keep
- Stored with the file
- File name, client, marketplace, report type, period, size, who uploaded it, when, and status.
- Error row
- Row number, field, the bad value, what is wrong, and a correction you can apply before a retry.
- Original file
- Kept as uploaded. Processing writes a new transaction batch and does not edit the file.
- Retry
- A failed job can be run again. A finished batch is not overwritten. The new attempt is stored beside it.
Official references
Frequently asked questions
Which Amazon file should I start with?
Start with the monthly tax or GST sales report from the Amazon seller account. Add the settlement file only as a fees and TCS report, with its own report type.
What if Flipkart renames a column?
That month’s file fails the column check. Update the Flipkart template version, then reprocess. Older months keep the template version they used.
Can I upload a PDF invoice here?
No. This step accepts CSV and Excel reports. Label PDFs belong in the shipping label cropper, which stays in your browser.
What does a failed row look like?
You see the row number, the field, the value that failed, and a short reason such as a missing HSN or a date the template cannot read. Correct that row and reprocess the attempt.
Will a second upload double my sales?
The same checksum for the same client, marketplace, report type, and month is flagged first. A deliberate reprocess keeps the old batch and writes a new attempt. Exports point at one batch, not at both.
Next accounting steps
GST
HSN and GST rate summaries
Taxable value, CGST, SGST, IGST, and cess by HSN code and by slab, for one client and month.
Open the checklist
TCS
TCS reconciliation
Expected GST TCS against the marketplace column and the credit shown in your GST records.
Open the checklist
Export
GSTR-1 JSON
A validated JSON file for the GST portal workflow, tied to one client, period, and processing batch.
Open the checklist