GST Sales Report from Multiple Marketplaces: Step-by-Step

Nearly 80% of GST notices in India trace back to one problem: numbers in your returns that do not match. CBIC’s GST Policy Wing shared that figure in October 2026, and it should make every online seller pay attention. If you sell on Amazon, Flipkart and Meesho, you download three different tax files each month, each with its own columns and quirks. Turning them into one accurate GST sales report from multiple marketplaces is exactly where most mismatches begin.

The pressure is growing, too. India’s e-retail market reached about $65-66 billion in gross merchandise value in 2025, with 290-300 million online shoppers, according to Bain & Company’s How India Shops Online 2026 report. Redseer estimates that online GMV grew roughly 25% year-on-year in the first half of 2026. More orders mean bigger files, more returns and more places for a small error to hide.

This guide walks you through the whole job in plain steps. You will learn which report to download from each marketplace, what your combined file must contain for GSTR-1, and how to build it two ways: by hand in Excel and with automation. You will also see a side-by-side comparison, the 2026 rule changes that raise the stakes, and answers to the questions sellers ask most.

Table of Contents

Juggling Amazon, Flipkart and Meesho reports every month?

See how Narti turns your marketplace files into one GSTR-1-ready report using your own data. No pressure, just a quick walkthrough.

Book a Free Demo

Which GST Reports Each Marketplace Gives You

Every marketplace names its tax file differently. Before you build a GST sales report from multiple marketplaces, you need to know exactly which file to pull from each seller panel. Pick the wrong one, such as a payment or settlement file, and your GSTR-1 will not match what the marketplace reported against your GSTIN. If the difference feels fuzzy, our explainer on the sales report vs settlement report clears it up.

Amazon MTR (B2B and B2C) and STR

Amazon gives you the Merchant Tax Report, better known as the MTR. You download it from Seller Central under Reports, in the tax section, from the GST monthly reports page. Amazon splits it into an MTR B2B file and an MTR B2C file, and you need both every month. If you use FBA, also download the Stock Transfer Report (STR), which lists stock that Amazon moved between warehouses in different states.

Preparing GSTR-1 from Amazon report files is usually the easiest part of the job, because the MTR already carries invoice numbers, ship-to state, HSN and the tax split. The catch is volume. A busy month can mean thousands of rows across three files. Our guide to the Amazon GST automation tool shows how sellers handle that load without manual copying.

Flipkart Sales Report

On Flipkart Seller Hub, open the Reports Centre, create a new report, and choose Tax Report as the type and Sales Report as the sub-type. The Flipkart GST report downloads as an Excel file. It holds order IDs, invoice numbers, event types such as sale, return and cancellation, and the GST break-up. Watch the event column closely. One order can appear as a sale in October and a return in November, and each row must land in its own month.

Keep in mind that the Flipkart GST report tells you what to file, not what you were paid. To check payouts, pair it with the steps in our Flipkart settlement reconciliation software guide.

Meesho GST Report

Meesho keeps things simple but different. In the Supplier Panel, go to Payments, click Download and choose GST Report. You get a ZIP file with two sheets: tcs_sales for sales and tcs_sales_return for returns and cancellations. This Meesho tax report is organised around the TCS the platform collects, so you have to net the returns sheet against the sales sheet yourself. Our Meesho GST reconciliation guide explains the columns one by one.

Myntra, JioMart and Other Marketplaces

Myntra, AJIO, JioMart and smaller platforms each have their own tax or sales exports. Column names change, date formats change, and some files mix B2B and B2C rows. The rule stays the same everywhere: download the invoice-level tax report, not the payment report. Fashion sellers should also read our Myntra GST reconciliation guide, since long return windows can push credit notes into later months.

What a Complete GST Sales Report from Multiple Marketplaces Must Include

A GST sales report from multiple marketplaces is only useful if every row lands in the right GSTR-1 table. That means your combined file should be organised around the return, not around the marketplaces. Here is what it needs before you or your CA open the GST portal.

B2B Invoices (Table 4)

Any sale to a buyer who gives a GSTIN is a B2B supply. You report it invoice by invoice, with the buyer’s GSTIN, invoice number, date, value, place of supply and tax. Your buyer claims input tax credit based on what you file, so a missing B2B invoice quickly turns into an unhappy customer. For most marketplace sellers, Amazon Business orders are the biggest source of B2B rows.

B2C Large and B2C Small (Tables 5 and 7)

Sales to unregistered buyers fall into two buckets. Since 1 August 2024, inter-state B2C invoices above ₹1 lakh count as B2C Large (B2CL) and go invoice-wise into Table 5. The old limit was ₹2.5 lakh, so older Excel templates often get this wrong. Everything else, including all intra-state consumer sales, goes into B2C Small (B2CS) as a summary by state and tax rate. For a typical marketplace seller, B2CS is the largest table by far.

HSN-Wise Summary (Table 12)

Table 12 groups your sales by HSN code, with quantity, taxable value and tax. Since the May 2025 tax period, the portal splits it into separate B2B and B2C tabs. It also asks you to pick HSN codes from a dropdown and checks that totals match your other tables. Businesses with turnover above ₹5 crore must use 6-digit HSN codes, while smaller businesses use at least 4 digits on B2B supplies. One wrong HSN on a single listing can throw the whole table off.

Credit Notes and Returns (Table 9B)

Customer returns become credit notes, and where they go depends on the original sale. Returns on B2B invoices go into Table 9B as credit notes for registered buyers. Returns on B2C Large invoices go in as credit notes for unregistered buyers. Returns on B2C Small sales are simply netted against that month’s B2CS figures.

Two more pieces complete the picture. Since January 2024, Table 14 asks you to report supplies made through each e-commerce operator, listed against the operator’s GSTIN. Table 13 lists the invoice and credit note number ranges you issued. Skip either, and your GST sales report from multiple marketplaces is incomplete even if every other number is right.

How to Build a GST Sales Report from Multiple Marketplaces in Excel

Manual consolidation still works if you sell on one or two platforms with a few hundred orders a month. Even if you automate later, it helps to understand the steps, because they show you exactly what a tool should be doing. Here is how most accountants build a GST sales report from multiple marketplaces by hand.

Collect and Clean the Raw Files

  1. Download every file for the same month. That means Amazon MTR B2B, MTR B2C and STR, the Flipkart sales report, the Meesho GST ZIP and any other marketplace exports.
  2. Save untouched copies. Keep the originals in a separate folder so you can always trace a number back to its source.
  3. Separate cancellations from returns. Orders cancelled before dispatch usually drop out. Orders that were delivered and then returned stay in, because they become credit notes.

Map Every File into One Master Sheet

  1. Create fixed columns. Use marketplace, operator GSTIN, order ID, invoice number, invoice date, buyer GSTIN, ship-to state, HSN, quantity, taxable value, IGST, CGST, SGST and transaction type.
  2. Paste and normalise. Copy each file into those columns. Fix date formats, check that returns carry negative values, and split any combined tax column into IGST or CGST plus SGST.
  3. Tag each row. Add a helper column with formulas that label every row as B2B, B2CL, B2CS or a credit note, based on buyer GSTIN, invoice value and whether the sale crossed state lines.

Summarise, Cross-Check and File

  1. Build pivot tables. Create the B2CS summary by state and rate, the HSN summary split into B2B and B2C, and the Table 14 summary for each marketplace.
  2. Match the totals. Compare your figures with each marketplace’s own report and with the TCS credit shown on the GST portal.
  3. Prepare the return. Enter the data in the GST Offline Tool to generate a JSON file for upload, or hand the workbook to your CA.

Here is what that means in hours. Imagine you sell on three platforms and handle 3,000 orders a month with an 8% return rate. That is about 3,240 rows before you add the STR. At roughly 30 seconds per row to paste, tag and check, you are looking at about 27 hours every month, and that is before you fix a single error. To understand the logic behind each check, see how GST reconciliation works step by step.

Accuracy is the bigger risk. A reversed minus sign on a batch of returns can overstate your liability. Since July 2025, you can no longer correct that figure inside GSTR-3B.

Still copying MTR rows into Excel at month-end?

Bring your own Amazon, Flipkart and Meesho files to a free demo and watch Narti turn them into a GSTR-1-ready report, with returns and HSN codes already sorted.

See It With Your Data

How to Automate a GST Sales Report from Multiple Marketplaces, Step by Step

Automation follows the same logic as the manual method. The difference is that software does the copying, tagging and checking, and you only step in when something looks wrong. Here is how an automated GST sales report from multiple marketplaces comes together.

Step 1: Bring Your Data In by API or Upload

Most tools give you two options. You can connect your marketplace seller accounts through an API so sales data syncs on its own. Or you can upload the same reports you would download for Excel. API sync suits high-volume sellers, while uploads suit CAs who receive files from many clients. A good tool supports both, so you can switch as your business changes.

Step 2: Let the Tool Classify, Net and Validate

Once the data is in, the software reads each marketplace’s format and maps it into one structure. It then runs the checks that eat up most manual hours:

  • Splits B2B, B2CL and B2CS rows using the current ₹1 lakh B2CL threshold
  • Nets returns and cancellations against the right invoices, even across months
  • Flags missing or invalid HSN codes and buyer GSTINs
  • Catches duplicate invoice numbers across marketplaces
  • Checks place of supply so IGST or CGST plus SGST is applied correctly
  • Groups supplies by e-commerce operator for Table 14

These checks matter even more since GST rates were rationalised on 22 September 2025. Many HSN codes changed rate partway through the year, so a single FY 2025-26 sales file can show two rates for the same product.

Step 3: Review Exceptions and Export

You review only the rows the system flags, not every row. After that, you export a GSTR-1-ready summary and your accounting vouchers in one pass. For sellers on many platforms, this is where a multi-marketplace settlement and GST tool earns its keep: one review screen instead of five spreadsheets.

This approach came from real experience. The team behind Narti Solutions also runs Narti Herbs, which sells on more than 25 marketplaces. They built the tool after facing the same month-end report chaos described here. To weigh your options, see our roundup of the top e-commerce GST reconciliation tools.

Manual vs Automated: Which GSTR-1 Preparation Ecommerce Sellers Should Choose

Both methods produce the same return. What changes is the time you spend, the risk you carry and how well each method scales. The table below compares the two ways to build a GST sales report from multiple marketplaces.

Manual vs automated GST sales report from multiple marketplaces
FactorManual (Excel)Automated
Time per month (3 platforms, about 3,000 orders)25+ hours of copying, tagging and checkingMostly exception review
Data inputDownload and paste every fileAPI sync or a few uploads
B2B, B2CL and B2CS splitFormulas you build and maintainApplied automatically
Returns across monthsEasy to miss or double-countMatched to original invoices
HSN summary (Table 12)Manual pivots for B2B and B2C tabsGenerated with the report
Table 14 (operator-wise)Separate pivot per marketplaceGrouped automatically
Error riskHigh; one bad formula affects every rowLower; flagged rows shown for review
Adding a new marketplaceNew template for every formatAdd the platform to your plan
Accounting entriesTyped or imported separatelyReady-made vouchers for Tally, Busy and Zoho Books (with Narti)
Best for1-2 platforms, low volume3+ platforms, CA firms, growing sellers

When the Manual Method Still Makes Sense

If you sell on a single marketplace, file quarterly under QRMP and process a few hundred orders, Excel is fine. You stay close to your numbers and spend nothing extra. Just keep a clean template, update it whenever rules change, and save each month’s source files.

When Automation Pays for Itself

The maths shifts once you add a second or third platform. Say an accounts executive’s time costs you ₹300 an hour. At 25 hours a month, that is ₹7,500 a month, or ₹90,000 a year, spent only on report preparation. Narti, by comparison, costs ₹3,500 + 18% GST per platform per year. Three platforms come to ₹10,500 a year at list price (excl. GST), and the multi-platform discount brings that down further. This is the GSTR-1 preparation ecommerce teams usually hand off first, because it repeats every single month.

Want to see the time saving on your own numbers?

Book a free demo, upload last month’s marketplace reports and compare Narti’s output with your Excel file side by side. Prefer to explore alone? Start a 14-day free trial.

Book Your Free Demo

Common Mistakes and 2026 GST Changes to Watch

Most errors in a GST sales report from multiple marketplaces are small, repeat every month and only surface when a notice arrives. Knowing the common traps, and the rules that changed recently, saves you from expensive fixes later.

Mistakes That Create Mismatches

  • Using settlement reports as sales data. Payout files are net of fees and TCS, so your turnover looks lower than what the marketplace reported.
  • Ignoring the Amazon STR. Leaving out FBA stock transfers between your own registrations breaks your state-wise totals.
  • Applying an outdated TCS rate. Marketplaces collect TCS at 0.5% under Section 52. Any older rate left in your template will overstate the credit you expect.
  • Booking returns in the wrong month. A return processed in November belongs to November, even if the sale happened in October.
  • Using the old ₹2.5 lakh B2CL limit. The threshold has been ₹1 lakh since August 2024.
  • Different HSN codes for the same product. If your listings on two marketplaces use different HSNs, Table 12 will not add up.

Many of these errors also show up as payout gaps. Our guide to marketplace payout mismatch reasons covers the money side in detail.

GST Updates Every Marketplace Seller Should Know in 2026

Recent changes have made accurate GSTR-1 data more important than ever:

  • GSTR-3B is hard-locked. Since the July 2025 tax period, the outward liability auto-filled from GSTR-1, GSTR-1A or IFF cannot be edited in GSTR-3B. Fixes must go through GSTR-1A before you file GSTR-3B.
  • Three-year filing limit. Since July 2025, you cannot file GSTR-1 more than three years after its due date, so old gaps can no longer be patched later.
  • New return forms are coming. After the 57th GST Council meeting on 8 October 2026, draft GSTR-1, GSTR-1A and IFF forms opened for public comment from 1 to 30 November 2026. The revised forms are planned from 1 April 2027, as reported by Business Today.
  • Warehouse registration relief is proposed. The Council has proposed letting eligible small e-commerce sellers declare a platform warehouse as their principal place of business in states where they have no premises, subject to conditions. Watch for the final notification.

For official updates, check the advisories on the GST portal regularly.

GSTR-1-Ready Output with Narti

Narti Solutions is e-commerce GST reconciliation and GSTR-1 automation software for Indian marketplace sellers and CA firms. It is built to make GST return filing simple for online sellers on Amazon, Flipkart, Meesho and more. Here is what you get when you use it to create a GST sales report from multiple marketplaces.

What the Output Covers

Narti supports 23 marketplaces and more than 25 report formats. These include Amazon MTR (B2C and B2B) and STR reports, Flipkart sales reports, Meesho, Myntra and JioMart. You can connect your marketplace accounts by API for automatic data sync, or upload your reports in a few clicks. Narti then prepares GSTR-1-ready output, including the HSN-wise summary, and you or your CA file it on the GST portal.

Ready-Made Vouchers for Tally, Busy and Zoho Books

The same data flows straight into your books. Narti creates ready-made vouchers for Tally, Busy and Zoho Books, included in the price, with custom exports on request. If you work in Tally, see our GST reconciliation plugin for Tally. Busy users can read about the e-commerce GST plugin for Busy, and Zoho users can explore the e-commerce accounting API for Zoho Books.

Pricing, Security and Support

  • Simple pricing: ₹3,500 + 18% GST per e-commerce platform per year, with unlimited vouchers and no extra charge for order volume.
  • Multi-platform discount: the more marketplaces you add, the bigger your discount. List prices are ₹10,500 a year for 3 platforms and ₹17,500 for 5 (excl. GST), before discount.
  • Certified security: ISO 27001:2022 and ISO 9001:2015.
  • Marketplace-listed: available on Amazon Seller Central’s Service Provider Network and Flipkart Seller Hub Partner Services.
  • Real support: onboarding plus email, WhatsApp and remote help.

See your own GSTR-1-ready report before you commit.

Book a free demo with your real marketplace files, or start a 14-day free trial of Narti’s GST reconciliation and GSTR-1 automation software.

Book a Free Demo

Frequently Asked Questions About GST Sales Report from Multiple Marketplaces

How do I make one GST sales report from multiple marketplaces?

Download the invoice-level tax report from each marketplace for the same month, such as Amazon MTR, the Flipkart sales report and the Meesho GST report. Map every file into one master sheet with fixed columns, tag each row as B2B, B2CL, B2CS or a credit note, then summarise by state, rate and HSN for GSTR-1.

Which Amazon report is used for GSTR-1 filing?

Use the Merchant Tax Report (MTR) from Amazon Seller Central. Download both the MTR B2B and MTR B2C files for the month. If you use FBA and hold GST registrations in more than one state, also download the Stock Transfer Report, because inter-state transfers between your own registrations must be reported too.

Is the Flipkart GST report the same as the settlement report?

No. The Flipkart GST report, found under Tax Report and Sales Report in the Reports Centre, lists invoice-level sales, returns and tax. The settlement report shows payouts after commission, shipping fees and TCS. Use the sales report for GSTR-1 and the settlement report to check that you were paid correctly.

What TCS rate do marketplaces collect from sellers in 2026?

E-commerce operators collect TCS at 0.5% of net taxable supplies under Section 52 of the CGST Act, a rate in force since 10 July 2024. The TCS appears in your GST portal once the marketplace files GSTR-8, and you accept it before it reaches your electronic cash ledger.

Can I correct a GSTR-1 mistake after filing?

Yes, but timing matters. Before filing GSTR-3B for the same month, you can fix errors through GSTR-1A. Since the July 2025 tax period, the liability auto-filled into GSTR-3B is locked, so you cannot edit it there. After that, corrections go in the amendment tables of a later GSTR-1.

Final Thoughts on Your GST Sales Report from Multiple Marketplaces

A reliable GST sales report from multiple marketplaces comes down to three habits. Download the right tax report from every platform, map every row to the correct GSTR-1 table, and check your totals before you file. With GSTR-3B now locked and new return forms planned for April 2027, there is very little room left to fix mistakes after the fact.

If you sell on one platform, a careful Excel template can carry you. Once you add Flipkart, Meesho or Myntra to Amazon, the hours and the risk climb fast, and automation starts paying for itself. Either way, your goal stays the same: a clean GST sales report from multiple marketplaces every month, filed on time, with no surprise notices in your inbox.

Stop rebuilding the same report every month.

Book your free Narti demo today. Upload your Amazon, Flipkart and Meesho reports and get GSTR-1-ready output plus Tally, Busy or Zoho Books vouchers from one place.

Book My Free Demo

Leave a Comment

Your email address will not be published. Required fields are marked *