How to Generate GSTR-1 from Meesho Sales and Return Reports

Preparing a Meesho GSTR-1 report can look difficult when you open the Meesho Excel files for the first time. There are sales values, returns, shipping amounts, HSN codes, GST rates, customer states, TCS details and separate invoice numbers.

The process becomes much easier once you understand which three Meesho files are required and what information should be taken from each file.

In this guide, we will explain how a Meesho seller, accountant or CA can manually prepare GSTR-1 from Meesho reports, how sales and returns should be calculated, how B2CS and B2CL work, and how CAWork Suite can automate the complete process.

Table of Contents

1. What is a Meesho GSTR-1 report?

2. Which 3 Meesho files are required?

3. What information is available in each file?

4. How to prepare Meesho GSTR-1 manually

5. How to calculate sales and GST

6. How to handle Meesho returns

7. B2CS and B2CL classification

8. HSN summary

9. Table 14 and TCS

10. Final reconciliation

11. Common mistakes

12. How CAWork Suite automates Meesho GSTR-1

13. FAQs

What Is a Meesho GSTR-1 Report?

A Meesho GSTR-1 report is not one ready-made GSTR-1 file. It is prepared by combining the GST-related sales, return and invoice information downloaded from the Meesho Supplier Panel.

These reports help you identify:

• Gross sales

• Customer returns

• Taxable value

• GST rate

• GST amount

• Customer state

• HSN code

• Quantity

• Shipping value

• Invoice numbers

• Credit-note numbers

• Meesho e-commerce operator GSTIN

This information is then converted into the applicable GSTR-1 sections such as B2CS, B2CL, HSN Summary, Documents Issued and Table 14.

For the standard Meesho B2C workflow explained in this guide, three files are required.

Which 3 Meesho Files Are Required for GSTR-1?

1. tcs_sales.xlsx & tcs_sales_return.xlsx : Meesho Supplier Panel → Payments → Download GST Reports

2. Tax_invoice_details.xlsx : Meesho Supplier Panel → Payments → Tax Invoice

Why are all three files important?
Think of it this way:

tcs_sales.xlsx
        +
tcs_sales_return.xlsx
        +
Tax_invoice_details.xlsx
        ↓
Complete Meesho GSTR-1 Working

The sales and return reports contain the values and GST information, while Tax_invoice_details.xlsx helps connect those transactions with the correct invoice or credit-note number.

Report names and layouts may change in the future, so always check the headings in the files downloaded from your Meesho Supplier Panel.

Important Fields in Meesho GST Reports

You do not need to understand every column.

The common fields most useful for GSTR-1 preparation are:

One very important point is that sub_order_num and Suborder No. are the link between the GST reports and the Tax Invoice Details file.

How to Prepare Meesho GSTR-1 Manually

Step 1: Select the Correct Filing Period

First confirm:

• Seller GSTIN

• GSTR-1 month or quarter

• Month selected while downloading Meesho reports

Download all three reports for the same filing period.

Do not combine files from different months without checking the transaction and return dates.

Step 2: Start with tcs_sales.xlsx

The sales file contains your forward sales.

Use:

Taxable Value

total_taxable_sale_value

GST Amount

tax_amount

Total Invoice Value

total_invoice_value

A simple validation is:

Total Taxable Sale Value
+ Tax Amount
≈ Total Invoice Value

Example

Taxable value = ₹1,000
GST rate = 5%
Tax = ₹50

Invoice value = ₹1,050

The report also contains taxable_shipping.

Do not automatically add taxable_shipping again to total_taxable_sale_value. First check whether it is already included in the total taxable figure. Otherwise, shipping can be counted twice.

Step 3: Find the Correct Invoice Number

tcs_sales.xlsx contains sub_order_num, but the actual invoice number is available in Tax_invoice_details.xlsx.

Match:

tcs_sales.xlsx
sub_order_num

        ↓ Match with ↓

Tax_invoice_details.xlsx
Suborder No.

Then take:

Type = INVOICE
Invoice No. = Actual invoice number

This gives you the correct invoice reference required for invoice-level calculations and document reporting.

Step 4: Check Place of Supply

Use:

end_customer_state_new

This tells you the customer’s destination state.

Now compare it with the seller state from the first two digits of gstin.

Example 1: Same State

Seller GSTIN starts with 24 = Gujarat
Customer State = Gujarat

This is normally an intra-State supply.

For a 5% GST transaction:

CGST = 2.5%
SGST = 2.5%

If total tax is ₹50:

CGST = ₹25
SGST = ₹25

Example 2: Different State

Seller State = Gujarat
Customer State = Maharashtra

This is normally an inter-State supply.

For 5% GST:

IGST = 5%

If total tax is ₹50:

IGST = ₹50

This treatment should always be checked against the applicable place-of-supply rules and the actual invoice.

How to Classify Meesho Sales into B2CS and B2CL

The common Meesho reports used in this workflow do not contain a buyer GSTIN field. Therefore, you should not invent a customer GSTIN or classify a transaction as B2B without supporting information.

For the normal consumer-sale workflow, transactions are treated as B2C and then divided into B2CS or B2CL where applicable.

B2CS

For return periods from August 2024 onwards:

• Intrastate B2C sale of any value → B2CS

• Interstate B2C invoice up to ₹1,00,000 → B2CS

B2CL

• Interstate B2C invoice above ₹1,00,000 → B2CL

The GST offline utility confirms the ₹1 lakh interstate B2C threshold from the August 2024 return period; earlier periods used ₹2.5 lakh.

Important: Calculate at Invoice Level

Do not apply the ₹1 lakh threshold to each Meesho row separately.

First match the actual Invoice No., group all rows belonging to the same invoice and calculate the complete invoice value.

Example:

Item 1 = ₹60,000
Item 2 = ₹45,000

Total Invoice Value = ₹1,05,000

If the supply is interstate and B2C, it becomes B2CL.

How to Handle Meesho Sales Returns

Now open:

tcs_sales_return.xlsx

It contains fields similar to the sales report, plus information such as:

cancel_return_date

Use the return file to reduce the applicable sales values.

Simple formula

Net Taxable Sales
=
Sales Taxable Value
− Return Taxable Value

Example

Total taxable sales = ₹1,00,000
Returned taxable value = ₹10,000

Net taxable sales = ₹90,000

Similarly:

Net GST
=
GST on Sales
− GST on Returns

If sales GST is ₹5,000 and return GST is ₹500:

Net GST = ₹4,500

Important: Returns May Appear as Positive Values

Do not assume that every return value will already carry a minus sign.

Because the transaction is coming from tcs_sales_return.xlsx, treat it as a return/reversal while preparing the working.

Do not make it negative twice.

How Credit Notes Are Identified

This is where Tax_invoice_details.xlsx becomes especially important.

Match the return:

tcs_sales_return.xlsx
sub_order_num

        ↓

Tax_invoice_details.xlsx
Suborder No.

For a return, you may find:

Type = CREDIT NOTE
Invoice No. = Credit-note number

This gives the document reference needed for the applicable credit-note treatment.

If a return happens in a later GST period, do not delete the original invoice from the earlier period. Review the credit note in the period in which it is issued, subject to GST rules.

How to Prepare the HSN Summary

For the Meesho HSN Summary, use:

• hsn_code

• quantity

• gst_rate

• total_taxable_sale_value

• tax_amount

Combine sales and returns.

Formula

Net Quantity = Sales Quantity − Return Quantity
Net Taxable Value = Sales Taxable Value − Return Taxable Value

Example

From the May 2025 return period, GST Portal Table 12 separates HSN reporting into B2B Supplies and B2C Supplies. The portal also requires minimum HSN digits based on the taxpayer’s aggregate annual turnover.

How Tax_invoice_details.xlsx Helps with Table 13

Tax_invoice_details.xlsx contains:

• Type

• Invoice No.

This makes it useful for checking your invoice and credit-note document series.

From the May 2025 return period, Table 13 — Documents Issued — became mandatory where B2B or B2C supplies are reported in GSTR-1.

Therefore, do not ignore invoice and credit-note numbers while preparing the Meesho GSTR-1 report.

Meesho Table 14 and E-Commerce TCS

The Meesho sales and return reports contain:

eco_tcs_gstin

This identifies the e-commerce operator GSTIN and is useful for preparing the applicable GSTR-1 Table 14 summary.

Table 14(a) requires suppliers to report an ECO-GSTIN-wise summary of supplies made through an e-commerce operator where TCS under Section 52 applies. The tax liability is already reported in the normal GSTR-1 sales tables, so Table 14 is an additional summary — it does not mean GST is paid twice.

TCS Is Not Output GST

Do not confuse:

GST on your sale

with:

TCS collected by Meesho

TCS collected by an e-commerce operator is reported separately and can flow to the supplier’s electronic cash ledger after the applicable GST reporting process.

The common files reviewed contain eco_tcs_gstin, but they do not provide a separate clear TCS-amount field. Therefore, reconcile the actual TCS amount separately with GST Portal records instead of calculating it from these files without support.

Final Reconciliation Before Filing

Before finalising GSTR-1, check:

• Total sales

• Total returns

• Net taxable sales

• B2CS total

• B2CL invoices

• Invoice numbers

• Credit-note numbers

• Place of supply

• GST rate

• IGST

• CGST and SGST

• HSN summary

• Table 13 document series

• Table 14 ECO GSTIN

• Meesho reports vs accounting sales register

Do not use the final bank payout as GSTR-1 turnover.

The amount received from Meesho and the amount reported as customer sales can differ because payment calculations may include returns, shipping-related adjustments and other settlement items.

Common Mistakes While Preparing Meesho GSTR-1

Avoid these common errors:

• Using only tcs_sales.xlsx and ignoring returns

• Forgetting Tax_invoice_details.xlsx

• Using sub_order_num as the final tax invoice number

• Adding taxable_shipping twice

• Treating returns as positive sales

• Making an already-adjusted return negative twice

• Applying the B2CL threshold per product row instead of per invoice

• Using customer state incorrectly

• Mixing IGST with CGST and SGST

• Ignoring credit-note numbers

• Ignoring HSN return adjustments

• Treating TCS as output GST

• Using bank settlement as turnover

How CAWork Suite Generates Meesho GSTR-1 Faster

Why Spend Hours Matching Three Excel Files Manually?

Every month, manually preparing a Meesho GSTR-1 report means:

• Matching sales and returns

• Finding invoice numbers

• Finding credit-note numbers

• Mapping states

• Calculating B2CS and B2CL

• Checking GST rates

• Preparing HSN summary

• Preparing Table 14

• Checking document series

CAWork Suite turns this into a simple workflow.

Step 1: Select GSTIN and Filing Period

Select the seller GSTIN and required GSTR-1 month or quarter.

Step 2: Upload the Three Meesho Files

Upload:

1. tcs_sales.xlsx
2. tcs_sales_return.xlsx
3. Tax_invoice_details.xlsx

You do not need to manually combine the files first.

Step 3: Review the Processed Transactions

CAWork Suite uses the supported fields to organise:

• Sales

• Returns

• Invoice and credit-note references

• Place of supply

• B2CS and B2CL

• Taxable values

• GST rates and amounts

• HSN data

• Table 14 information

• Applicable document details

Review the calculated transactions and correct any exceptional or incomplete record before final generation.

Step 4: Generate GSTR-1 Excel or JSON

After review, generate the supported:

• GSTR-1 Excel

• GSTR-1 JSON

The complete workflow is:

Select GSTIN and Period → Upload 3 Meesho Reports → Review GSTR-1 Working → Generate Excel or JSON

For supported and correctly formatted Meesho reports, CAWork Suite can prepare a review-ready GSTR-1 working in around two minutes. Final review time depends on whether the source files contain incomplete or unusual records.

Stop Matching Meesho Excel Files Manually

Upload the three original Meesho reports, review the prepared transactions and generate your supported GSTR-1 output through one organised process.

Generate GSTR-1 with CAWork Suite

Frequently Asked Questions

1. Which Meesho files are required for GSTR-1?
For the workflow explained here, use tcs_sales.xlsx, tcs_sales_return.xlsx and Tax_invoice_details.xlsx.

2. Why is Tax_invoice_details.xlsx required?
It provides the actual invoice and credit-note numbers that can be matched with the sales and return reports using the suborder number.

3. Can I prepare GSTR-1 only from tcs_sales.xlsx?
You should also include the return file and invoice-details file so that returns and document numbers are correctly considered.

4. How are Meesho returns calculated?
Subtract the applicable return taxable value, quantity and tax from the corresponding sales working.

5. How do I identify B2CL?
For current periods, an interstate B2C invoice with total invoice value above ₹1 lakh is B2CL. Apply the threshold to the complete invoice, not individual product rows.

6. Which Meesho field is used for place of supply?
end_customer_state_new provides the customer destination state used as an important place-of-supply reference.

7. Which field is used for HSN summary?
Use hsn_code with quantity, gst_rate, total_taxable_sale_value and the applicable tax amount.

8. Is Meesho TCS part of output GST?
No. E-commerce TCS is separate from output GST and should be reconciled separately.

9. Can Meesho reports be uploaded directly to the GST Portal?
The raw Meesho files first need to be converted into the applicable GSTR-1 structure.

10. How does CAWork Suite help?
CAWork Suite reads the three supported Meesho files, organises the transactions for review and generates supported GSTR-1 Excel or JSON output.

Conclusion

Creating a Meesho GSTR-1 report manually requires three important files: tcs_sales.xlsx, tcs_sales_return.xlsx and Tax_invoice_details.xlsx.

Start with gross Meesho sales, subtract valid returns, match each transaction with its correct invoice or credit-note number, determine place of supply, classify B2CS or B2CL, prepare the HSN summary and reconcile Table 14 and document details.

If you do not want to repeat this Excel matching every month, CAWork Suite simplifies the process. Select the GSTIN and filing period, upload the three Meesho reports, review the calculated transactions and generate the supported GSTR-1 Excel or JSON file.

Disclaimer: GST information in this article was reviewed in August 2026. This content is for educational purposes and is not tax or legal advice. GST rules, GST Portal validations and Meesho report formats may change. Review important transactions before filing or consult a qualified GST professional.