Meesho Payment Report Explained: Every Column (2026)
By Vanshika - ecommerce seller & educator, @chitraabyvanshika (100,000+ followers)
The Meesho payment report is an Excel file you download from Payments in the Supplier Panel. Its main sheet, Order Payments, has one row per sub order and about forty columns. The one that matters most is Final Settlement Amount: what Meesho actually paid you for that order. Meesho prints the formula for it in the file itself, and once you can read it, every surprise deduction stops being a mystery.
This guide walks through the file using a real one: a payment report covering 610 orders from June and July 2026. The numbers below are from real rows, with order IDs left out.
Meesho payment report kaise dekhe?
Supplier Panel mein Payments kholo. Wahan se payment report (Payments to Date ya previous payment) date range chun kar download karo. Excel file mein "Order Payments" sheet kholo: har row ek order hai, aur Final Settlement Amount column batata hai ki us order ka kitna paisa aapko mila.
Where to download it
- Log in at supplier.meesho.com and open Payments.
- Use Download and choose the payment report for the period you want. Meesho's support notes list the downloads as GST Report, Tax Invoice, Commission Tax Invoice, Payments to Date and Outstanding Payments.
- You get an Excel file with a name along the lines of
<supplier ID>_SP_ORDER_ADS_REFERRAL_PAYMENT_FILE_PREVIOUS_PAYMENT_<from>_<to>.xlsx.
The file has five sheets:
| Sheet | What it holds |
|---|---|
| Disclaimer | Meesho's note on how the figures are computed |
| Order Payments | One row per sub order: sale, deductions, taxes, settlement |
| Ads Cost | Ad spend deducted, by date and campaign, with GST |
| Referral Payments | Rewards from Meesho's referral programmes, if any |
| Compensation and Recovery | Platform-level compensation (for example a parcel lost by the courier) and recoveries |
The column groups in Order Payments
The sheet groups its columns under seven headings. Under each column name, Meesho prints a letter, such as B, C or G. Those letters are Meesho's own labels for the formula, not Excel's column letters, so read them from the third row of the sheet.
| Group | Columns | What to look at |
|---|---|---|
| Order Related Details | Sub Order No, Order Date, Dispatch Date, Product Name, Supplier SKU, Catalog ID, Order source, Live Order Status, Product GST % (A), Listing Price, Quantity | Status tells you if it was Delivered, Return, RTO, Exchange, Shipped or Cancelled |
| Payment Details | Transaction ID, Payment Date, Final Settlement Amount | Transaction ID is the bank reference for the payout |
| Revenue Details | Price Type, Total Sale Amount (B), Total Sale Return Amount (C), Fixed Fee (AD), Warehousing fee (AF), Return premium (U, V) | B is the sale including delivery and GST; C is the same amount reversed on a return |
| Deductions | Commission % (F) and Commission (G), gold and mall platform fees (AX, AA), Fixed Fee (AC), Warehousing fee (AG), Return Shipping Charge (H), GST Compensation (W), Shipping Charge (I) | All charged including GST |
| Other Charges | Other Support Service Charges (J), Waivers (K), Net (L = J + K), GST on them (P) | Usually zero for small sellers |
| TCS & TDS | TCS (Q), TDS Rate % (X), TDS (T) | Tax collected at source; both can be claimed back |
| Recovery, Claims and Compensation | Compensation (R), Claims (Y), Recovery (S) and their reasons | Where a successful claim shows up |
The Final Settlement formula
Meesho prints it under the Final Settlement Amount heading:
Final Settlement = B + C + G + H + I + L + Q + R + S + T + U + V + W + Y + AA + AD + AF + AX
Deductions are stored as negative numbers, so the formula simply adds everything. In plain words: what the buyer paid, minus any amount reversed on a return, minus Meesho's charges, minus TCS and TDS, plus any compensation or claim, minus any recovery.
Two formulas inside it are worth knowing:
- Commission: G = minus (B + C) times F. On most categories F is 0%, so G is 0.
- TCS: Q = a percentage of (B + C + U + V) divided by (1 + A), that is, of the sale without GST. The heading in the file still says 1%, but the TCS actually deducted in this file works out to 0.5%, which is the current rate. TDS is shown in column X at 0.1%.
Three real orders, line by line
A delivered order
| Column | Amount |
|---|---|
| Listing Price (Incl. taxes) | ₹300 |
| Total Sale Amount, B | ₹333.00 |
| Shipping Charge, I | -₹41.42 |
| TCS, Q | -₹1.59 |
| TDS, T | -₹0.32 |
| Final Settlement | ₹289.67 |
Notice that B is ₹333, not ₹300. The buyer paid a ₹33 delivery charge on top of the listing price, and it is part of your sale. Meesho then deducts its shipping charge (₹41.42 including GST). So shipping cost this seller a net ₹8.42 on this order, not ₹41. Across three sellers' files we checked, the buyer paid a delivery charge on almost every delivered order, and the seller's net shipping was usually under ₹13. That is roughly the 18% GST on the shipping, which a GST registered seller can claim back as input tax credit.
A customer return
| Column | Amount |
|---|---|
| Total Sale Amount, B | ₹363.00 |
| Total Sale Return Amount, C | -₹363.00 |
| Shipping Charge, I | ₹0 |
| Return Shipping Charge, H | -₹155.00 |
| Final Settlement | -₹155.00 |
The sale is reversed in full, forward shipping is not charged, and the return shipping charge is deducted. A negative settlement is taken out of your other orders in the same payment. In the files we checked, return charges were ₹155 to ₹175, in line with the reverse shipping rate card in our Meesho returns and RTO guide.
An RTO (never reached the buyer)
| Column | Amount |
|---|---|
| Total Sale Amount, B | ₹157.00 |
| Total Sale Return Amount, C | -₹157.00 |
| Final Settlement | ₹0 |
In the files we checked, RTO orders settled at zero: no shipping charge and no return charge. You lose the packing and the time, not money in the report.
Price Type: BASIC and PREMIUM_RETURN
The Price Type column tells you which of your two prices the buyer paid. PREMIUM_RETURN is your normal Meesho price, with normal returns. BASIC is the lower price for buyers who can only return a wrong or defective product. Our catalog upload guide explains how you set the two prices.
How to reconcile a payment
- Filter Payment Date to one payout.
- Sum Final Settlement Amount. It should match the amount credited to your bank under that Transaction ID.
- Subtract the Ads Cost sheet total if ads were deducted in the same cycle.
- Look at every negative row. Each one is a return, an exchange or a recovery. Check the return shipping charge against the rate card, and check the parcel itself when it arrives.
- Anything you disagree with goes to Support with the sub order number. Our Meesho return claim guide covers the evidence that gets claims accepted.
For when money arrives, see our Meesho payment cycle guide.
Mistakes that make the report look wrong
- Treating the listing price as revenue. Your sale is column B, which includes the delivery charge the buyer paid.
- Expecting returns to match the month of the sale. A return shows up in the payment when it happens, so an order sold in June can reduce July's payout.
- Reading Meesho's letters as Excel columns. Use the labels in row three.
- Forgetting TCS and TDS are yours. TCS is credited to your GST cash ledger and TDS can be claimed against income tax. See our GST report and GSTR-1 guide.
To see what your own numbers mean for profit per order, put them into the free Meesho profit calculator.
FAQ
Meesho payment report kaise dekhe?
Supplier Panel mein Payments kholo aur payment report download karo. Excel mein Order Payments sheet ka Final Settlement Amount column har order ka asli payment batata hai.
What is Final Settlement Amount on Meesho?
It is what Meesho paid you for that sub order: the sale including delivery, minus returns, Meesho's charges, TCS and TDS, plus any compensation or claims. Meesho prints the full formula under the column heading.
Why is my Meesho settlement negative?
A negative settlement is usually a customer return: the sale is reversed and the return shipping charge is deducted. It is adjusted against your other orders in the same payment.
Does Meesho deduct shipping from my payment?
Yes, as the Shipping Charge column, including GST. But the buyer usually pays a delivery charge that is added to your sale, so the net cost to you is much smaller than the charge itself.
Why does the TCS heading say 1% when Meesho deducts 0.5%?
The formula text in the file still says 1%, but the amounts deducted match the current 0.5% rate. Check yours by dividing TCS by the sale without GST.
Where do ad charges appear?
In the separate Ads Cost sheet, by date and campaign, including GST. They are not part of the per-order Final Settlement Amount.
Reading payments, returns and the monthly numbers is covered step by step in the Meesho A-Z Course.
Free download
Meesho Seller Checklist
10 things to do before listing your first product. The mistakes this prevents cost new sellers thousands of rupees.
Reading is free. A selling store changes your life.
The Meesho A-Z Course walks you from zero to your first orders - one short, practical lesson a day. Taught by Vanshika in simple language.
Join the Meesho Course - ₹999 →