Demystifying the Meesho Settlement Report: Stop Losing Track of Your Money
Every Meesho seller knows the feeling of looking at their bank account and wondering, "Did I actually make money on those 500 dispatches this week?" While Meesho offers a zero-commission model, they deduct shipping, returns, GST, and tax compliance fees at source. The only way to know your true net earnings is to read the payment reconciliation sheets.
For most suppliers, opening the Meesho Settlement CSV is a confusing experience. With over 25 columns filled with technical terms, tax rates, and transaction IDs, it is easy to ignore the details. However, ignoring this report means you might be losing thousands of Rupees to double shipping fees, unclaimed returns, and tax mismatches. In this guide, we break down every single column of the Meesho payment CSV so you can audit your payouts like a pro.
Always download your payment reports in CSV format instead of PDF. CSVs allow you to use formulas, sort transactions by SKU, and upload files into automation tools for instant auditing.
How to Download the Meesho Payment CSV File
To get your hands on the raw settlement file, follow these simple steps:
- Log in to your Meesho Supplier Panel.
- On the left sidebar, click on Payments.
- Select the Payments Page tab.
- Find the specific payout date or click on Download Payout Report.
- Select your date range and export as CSV (Comma Separated Values).
The Meesho CSV Column Guide: What Every Field Means
Here is the exact mapping of the key columns in your Meesho payment report, what they represent, and how they affect your final bank settlement:
| Column Name | Data Type | Description & How to Audit It |
|---|---|---|
| Sub Order No | Numeric ID | The unique ID of the order. Use this to cross-reference customer returns and courier sheets. |
| SKU | Text Label | Your Stock Keeping Unit identifier. Essential for calculating SKU-level profit. |
| Product Price | Currency (INR) | The base price at which you listed the product on Meesho (before shipping fees). |
| Quantity | Integer | Number of units ordered. Verify this if you pack multi-unit orders. |
| Shipping Charge | Deduction (-) | The forward shipping charge deducted. Ensure it matches your weight slab! |
| Return Shipping Charge | Deduction (-) | Deducted only if a customer returns the item. Check if this is charged on RTOs (it shouldn't be). |
| TCS Amount | Tax Deducted (-) | Tax Collected at Source (usually 0.5% or 1% GST). Claim this back on the GST portal monthly. |
| TDS Amount | Tax Deducted (-) | Tax Deducted at Source (0.1% under Section 194-O). Appears on your Form 26AS for income tax. |
| Compensation Amount | Credit (+) | Reimbursement from Meesho for damaged returns, lost shipments, or approved claims. |
| Net Settlement Amount | Final Payout (+) | The actual amount sent to your bank. Product Price - Shipping - Taxes + Compensation. |
How to Find Hidden Margin Leaks in Your CSV
Now that you know what the columns represent, it is time to audit your file for common payment discrepancies. Look out for the following issues:
1. Double Forward Shipping Deductions
Sometimes, courier partners miscalculate the weight of your packages, pushing them into a higher slab. Compare the Shipping Charge column against your product weight. If a 200-gram item was charged ₹120 instead of ₹45, you can raise a ticket with the manifest proof.
2. Return Charges on RTO (Return to Origin)
According to Meesho policy, you should not be charged return shipping for RTOs (undelivered orders returned by the courier). If you see deductions in the Return Shipping Charge column for a sub-order marked as RTO, this is a mistake. Raise a dispute to claim a refund.
3. Missing Compensations
If you filed a Safe-T claim for a damaged customer return and it was approved, check the Compensation Amount column in the subsequent payout files. Many sellers forget to verify if the approved refund was actually credited.
Automating Your Payment Audit: Move Beyond Spreadsheets
Manually auditing thousands of rows in Excel is exhausting and prone to errors. To scale your business, you need automated reconciliation.
📊 Audit Your Meesho Payouts in One Click
Stop wasting hours on Excel files. Upload your Meesho Payment CSV directly to our secure dashboard to reconcile payments, track deductions, and find missing cash instantly.
Reconcile Payouts Now
