How do I calculate GSTR-1 if I sell on Amazon, Flipkart, and Meesho?

You need to download the sales reports from each platform (Amazon MTR or Ready-to-File, Flipkart GSTR Return Report, Meesho TCS Sales + TCS Return), then combine them into a single state-wise and HSN-wise GSTR-1 summary. Manually this takes 4–6 hours per month. The Thoiba Trader GSTR-1 Calculator does it automatically in under 10 seconds when you upload all three reports together.

What reports do I need to calculate GSTR-1 for Meesho?

For Meesho, you need two reports: the TCS Sales report and the TCS Return (refund) report. You must subtract the return values from the sales values to get net taxable sales. This data must then be broken down state-wise and GST rate-wise (5%, 12%, 18%) before it can be entered in GSTR-1.

Can I file GSTR-1 separately for each ecommerce platform?

No. There is only one GSTR-1 per GSTIN per month. If you sell on three platforms, you must merge all three platform reports into a single GSTR-1 return. The GST portal does not accept separate returns per platform.

How long does manual Excel calculation take for GSTR-1?

For sellers with 100+ orders per month across multiple platforms, manual Excel calculation typically takes 4 to 6 hours. This involves downloading reports, cleaning data, removing cancelled and returned orders, applying SUMIFS formulas, grouping by state and GST rate, and merging all three platform totals.

What is B2C Small in GSTR-1 for ecommerce sellers?

B2C Small (Table 7 in GSTR-1) is for consumer sales (B2C) where the invoice value is less than ₹2.5 lakh. Most ecommerce sales fall under B2C Small. These must be reported as a state-wise, rate-wise consolidated summary — not individual invoice entries. Ecommerce platforms generally handle invoice issuance, but you are responsible for the GSTR-1 summary entry.

Is the Thoiba Trader GSTR-1 Calculator safe? Does it store my data?

Yes, the calculator is built using client-side processing technology. Your uploaded files and business data never leave your browser and are never sent to any server. Processing happens entirely on your device, and data is deleted when you close the tab. No login or account creation is required.

What is the difference between Amazon MTR and Amazon Ready-to-File for GSTR-1?

Amazon MTR (Monthly Tax Report) is a detailed transaction-level report listing every order, return, and fee. Amazon Ready-to-File is a pre-summarised GSTR-1-friendly report. Both can be used for GSTR-1 calculation. The GSTR-1 Calculator accepts both formats.

How to Calculate GSTR-1 for Ecommerce Sellers (Amazon, Flipkart & Meesho) 2026 Guide

1. Why GSTR-1 Calculation is Hard for Ecommerce Sellers

It's not just about adding up numbers — it's about merging three completely different data formats.

If you sell on a single platform and file yourself, the platform might give you a "Ready to File" report that looks almost usable. But the moment you sell on more than one platform — or the moment you try to combine Meesho, Flipkart, and Amazon into one GSTR-1 — the challenge multiplies.

Here is what makes it genuinely difficult:

1

One GSTR-1 for all platforms

There is only one GSTR-1 per GSTIN. You cannot file a separate return for each marketplace. All your Amazon, Flipkart, and Meesho sales must be merged into a single return. The GST portal does not know or care which app you sold on.

2

Every platform has a different report format

Amazon gives you an MTR (Monthly Tax Report) with thousands of rows. Flipkart splits intra-state and inter-state sales into separate sheets. Meesho gives you TCS Sales and TCS Returns as two separate files that must be subtracted. None of these are in the same format.

3

You must group by State AND GST Rate

The GST portal requires a state-wise, rate-wise summary. That means you need to know your total 5% sales in Assam, your 12% sales in Maharashtra, your 18% sales in Delhi, and so on — for every state you delivered to, across all three platforms combined.

4

Returns and cancellations must be excluded

Your gross sales include returned orders, cancelled orders, and platform-adjusted amounts. These must be identified and removed before you can get to your actual taxable turnover. One missed return = wrong return filed.

⚠️ A Wrong Calculation Has Real Consequences If you underreport or misreport your turnover in GSTR-1, the GST department can issue a notice. The mismatch between your GSTR-1 and the platform-reported TCS data (which Amazon, Flipkart, and Meesho file independently) is visible to the department. Even a small arithmetic error on the wrong line can flag your return for scrutiny.

2. What Reports You Need From Each Platform

Before any calculation, you need the right files downloaded.

📦 Amazon MTR or Ready-to-File

Download either the MTR (Monthly Tax Report) from Seller Central → Reports → Tax Document Library, or the Ready-to-File GSTR-1 report from the same location. Both work — the MTR is transaction-level, the Ready-to-File is pre-summarised. Amazon's report is the most straightforward of the three platforms. 📖 Full Amazon download guide →

🛒 Flipkart GSTR Return Report

From Seller Hub → Reports → Taxes → GSTR Return Report. You must request the report first — it takes up to 24 hours to generate. Download it once status shows "Generated." Note: the report has separate sheets for local (intra-state) and inter-state sales. You need both sheets included in your calculation. 📖 Full Flipkart download guide →

🛍️ Meesho TCS Sales + TCS Returns

You need two separate files from Meesho: the TCS Sales report and the TCS Return (refund) report. Meesho does not give you a combined net report — you have to subtract returns from sales yourself. This is where most manual errors happen. The data must also be broken down by GST rate (5%, 12%, 18%) before it can go into GSTR-1. 📖 Full Meesho download guide →

✅ Pro Tip: Request Flipkart Early Flipkart's report generation takes up to 24 hours. If your GSTR-1 deadline is the 11th, request the Flipkart report by the 8th at the latest. Amazon and Meesho reports are available immediately on demand.

3. Method 1 — Manual Excel

The default that most new sellers try. Here is what it actually involves.

📊

Method 1 · The Hard Way

Manual Excel Calculation

You open all your platform reports, load them into Excel or Google Sheets, and write formulas to do the merging, grouping, and summarising yourself.

⏱ 4–6 hours/month ₹0 direct cost 🔴 High error risk

Here is exactly what manual Excel involves when you sell on all three platforms:

1

Meesho: Net Sales Calculation

Open both the TCS Sales and TCS Return files. Use SUMIF or VLOOKUP to match and subtract return amounts from sales amounts. This must be done for every product, every state, and every GST rate separately. One wrong SUMIF range = wrong total.

2

Amazon: Clean and Filter the MTR

The MTR may have tens of thousands of rows. You must filter out cancelled orders, identify returns, and keep only actual sales. Then group by state and rate using SUMIFS or Pivot Tables.

3

Flipkart: Process Both Sheets

Open the GSTR Return Report and locate both the local sales sheet and the inter-state sheet. Process each separately, then combine. If you accidentally process only one sheet, your total is wrong.

4

Merge All Three Into One Summary

This is the hardest part. You now have three separate state-rate summaries in different formats. You must combine them into a single master summary: one row per state per GST rate, with all three platforms' totals added together. If any column header is even slightly different across your three Excel files, the formulas will silently fail.

5

Enter Into GST Portal Manually

Finally, go to the GST portal and enter each state-rate value by hand into Table 7 (B2C Small). One digit wrong = one wrong return filed. For 28 states × 3 GST rates = potentially 84 manual entries.

🏪

Sanathoiba Singha

Ecommerce Seller · Thoiba Trader (Assam)

When I started selling on Meesho, I was doing all of this on my phone — a small screen, mobile Excel, manually scrolling through TCS files and typing SUMIFS formula by formula. I remember some months where 3 to 4 days went just on this calculation. Not 3 to 4 hours — days. I would redo it because I wasn't confident the number was right.

The mental stress alone was exhausting. I kept wondering: what if one formula is wrong? What if I missed a return? What if the GST notice comes next month? That fear is very real when you're a small seller operating on thin margins.

⚠️ The Hidden Risk of Manual Calculation With 100+ orders per month across three platforms, the manual Excel method has a very high chance of human error. A mismatched column, a missed sheet, or a wrong formula can silently produce a wrong total — and you won't know until the GST department does.

Who should use it: Only sellers with 5–10 orders per month on a single platform with zero returns. For anyone else, the time cost and risk is too high to justify ₹0 saved.

4. Method 2 — Hire a CA

Reliable but expensive — especially for sellers who are still building their business.

👔

Method 2 · The Costly Way

Hire a CA or Tax Consultant

You hand your platform reports to a CA each month and they file the return for you.

⏱ Low personal time ₹500–₹2000 / month 🟡 Dependency risk

This is the option most sellers turn to after the Excel nightmare. A CA handles the calculation and filing, so your personal time is minimal. But the costs add up fast:

💰 The Annual Cost of a CA for GST Filing At ₹500/month → ₹6,000/year. At ₹1,000/month → ₹12,000/year. At ₹2,000/month → ₹24,000/year. For a seller making ₹50,000 profit per year, that's 5–50% of profits just on compliance.

Beyond the cost, there are other practical problems with this approach:

You are completely dependent on another person's schedule. If your CA is busy during filing week, your return gets delayed — and late filing attracts a late fee.
You lose visibility into your own numbers. You don't know your actual state-wise sales unless you ask.
You still have to download and send all the reports yourself every month, which takes its own time.
CAs often use the same large GST software whose annual subscription cost they factor into their fees.

🏪

Sanathoiba Singha

Ecommerce Seller · Thoiba Trader (Assam)

When I approached a CA after my Excel frustration, the first thing they did was talk about GST notices — the fear factor. "Do it wrong yourself and the department will come after you." That part is true. But when the fee came up — ₹2,000 per return — I did the math. That's ₹24,000 per year, just to file a return I could learn to do myself if I had a better tool.

For a new seller who hasn't crossed ₹1 lakh in monthly sales yet, ₹2,000/month for compliance is a significant drag on the business.

Who should use it: Established sellers with high monthly volumes (₹5 lakh+) who genuinely do not have time and have the margins to absorb the fee. For everyone else, it's a solution that costs more than the problem is worth.

5. Method 3 — Big GST Software

Built for enterprises. Too complex and too expensive for individual ecommerce sellers.

🏢

Method 3 · The Overcomplicated Way

Enterprise GST Software

Full-featured GST compliance platforms with dashboards, reconciliation tools, and multi-user access.

⏱ Medium setup time ₹5,000–₹15,000 / year 🟡 Steep learning curve

After the Excel struggle and CA cost discovery, many sellers turn to popular GST software platforms. These run into three recurring problems for individual ecommerce sellers:

1

Built for accountants, not sellers

The interfaces are designed for CA firms handling multiple clients. The terminology, navigation, and workflows assume GST expertise that a typical ecommerce seller simply does not have. The learning curve is steep and time-consuming.

2

Expensive annual subscriptions

Annual plans for these platforms typically range from ₹5,000 to ₹15,000 or more. For a seller who needs to file GSTR-1 once a month, this is extremely poor value.

3

Mandatory login and data upload

Every platform requires you to create an account and upload your business data to their servers. Your transaction data, customer states, product categories, and turnover history sits on a third-party server. For many small sellers, this is a genuine privacy concern.

Who should use it: Multi-branch businesses, large sellers with B2B invoices, or CA firms handling many clients. Not designed for the solo ecommerce seller who needs one GSTR-1 per month from three platforms.

6. Method 4 — Thoiba Trader GSTR-1 Calculator

Built by a seller, for sellers. Simple, private, affordable.

🚀

Method 4 · The Smart Way

Thoiba Trader GSTR-1 Calculator

Upload your Amazon, Flipkart, and Meesho reports together. Get a complete state-wise and HSN-wise GSTR-1 summary in seconds.

⏱ Under 2 minutes ₹99 / report 🟢 No error risk

After going through the Excel nightmare, the CA cost conversation, and the overcomplicated software trap, I built this tool specifically for one type of user: an ecommerce seller in India who needs a clean GSTR-1 summary without the headaches.

Three things guided how the tool was built:

Privacy-first, client-side processing. Your uploaded files never leave your browser. All calculation happens on your device. The moment you close the tab, the data is gone. We cannot see your data even if we wanted to.
No login required. No account. No email. No password. Open the page, upload your files, get your summary. That's the entire flow.
Built for the exact reports these platforms generate. The calculator understands Amazon MTR format, Amazon Ready-to-File format, Flipkart GSTR Return Report format (including the separate local and inter-state sheets), and Meesho's dual TCS Sales + TCS Returns format. You do not need to reformat or clean anything.

The output is a downloadable Excel file with your complete GSTR-1 summary — state-wise, rate-wise, HSN-wise — formatted so you can directly refer to it while entering data on the GST portal. No mental arithmetic. No second-guessing.

7. Side-by-Side Comparison

All four methods at a glance.

Feature	Excel	CA / Consultant	Big Software	GSTR-1 Calculator
Monthly Cost	₹0	₹500–₹2,000	₹400–₹1,200	₹99
Time Per Month	4–6 hours	30–60 min (sending files)	1–2 hours	Under 2 minutes
Human Error Risk	Very High	Low (but exists)	Low	None
Handles 3 Platforms	Manual merge required	Yes	Yes	Yes, automatic merge
Data Privacy	Your device only	Shared with CA	Uploaded to server	100% client-side
No Login Required	Yes	No (CA account)	No (mandatory)	Yes
Meesho Returns Handled	Manual SUMIF	Yes	Yes	Automatic
Flipkart Sheet Split	Manual (easy to miss)	Handled by CA	Yes	Auto-detected
Suitable for New Sellers	Only 5–10 orders/month	Too expensive	Too complex	Yes, any volume

8. How to Use the GSTR-1 Calculator

A complete walkthrough from upload to download.

1

Select Your Filing Details

Open the calculator and choose your registered state, the filing month, and the year. The state selection is important because it determines which sales are intra-state (CGST + SGST) and which are inter-state (IGST).

2

Choose Your Plan

Select Monthly (₹99) if you file GSTR-1 every month, or Quarterly / QRMP (₹249) if you file once a quarter under the QRMP scheme. The quarterly plan handles 3 months of combined platform data.

3

Upload Your Platform Reports

Upload whichever platforms you sell on — you do not need to have all three.

Meesho → TCS Sales file + TCS Return file
Amazon → MTR file OR Ready-to-File report
Flipkart → GSTR Return Report (Excel with multiple sheets)

4

Click Calculate and Download

The calculator processes all uploaded files, merges them, nets Meesho returns, handles Flipkart's sheet split, and groups everything by state and GST rate. Within seconds, download your complete GSTR-1 summary as an Excel file — ready to refer to while entering data on the GST portal.

✅ Flipkart Specific Tip For Flipkart, the calculator recommends uploading the Ready-to-File Report rather than the general Sales Report. The Ready to file Report has the most accurate and complete HSN-level data and handles the local/inter-state sheet logic automatically.

❌ Common Mistakes to Avoid

Uploading the wrong month's report. Always verify the date range on the file before uploading. A January report used for a February GSTR-1 is a serious error.
Uploading only the Meesho TCS Sales without the TCS Return file. You need both. Missing the returns file means your taxable turnover will be inflated.
Waiting until the last day of the filing deadline. Flipkart reports take up to 24 hours to generate. Request them 2–3 days early.

3 Ways to Calculate GSTR-1 for Ecommerce Sellers: Which is Best for You?