What is the Final Settlement Amount in the Meesho payment sheet?

It is the actual amount Meesho pays you for an order after deducting commission, shipping charges, GST adjustments, and penalties. It can be negative on returned orders. All profit calculations should start from this number, not the sale price.

Which orders in the payment sheet consume my inventory cost?

Only Delivered and Exchange orders consume inventory — book purchase cost against those. Return, RTO, and Cancelled orders recover (or never used) stock, so their cost is not consumed, though returns may still settle negative.

The Meesho Payment Sheet, Decoded: What Every Column Actually Means

The Meesho payment sheet is the most honest document in your business — and the least read. Most sellers glance at the total, feel good or bad, and close the file. But every rupee you truly earned (or lost) is itemised in there. Here's how to read it.

Where to get it

Meesho Supplier Panel → Payments → download the payment file (.xlsx). Look for the tab containing order-level payment rows (commonly "Order Payments").

The columns that matter

Sub Order No — the unique ID per item-level order. Your anchor for matching everything else.
Supplier SKU — your product code. If this is messy ("blue-2", "BLUE2", "blu2" for the same item), fix it at the source; every analysis depends on it.
Live Order Status — Delivered, Return, RTO, Exchange, Cancelled. This decides whether the order consumed inventory (Delivered/Exchange) or recovered it (Return/RTO).
Customer Paid / Total Sale Amount — what the buyer paid. Vanity number; don't calculate profit from it.
Final Settlement Amount — what Meesho actually pays you after commission, shipping, GST and penalties. This is your revenue. It can be negative on returns — those rows are real losses.

Reading it like a professional

Sum Final Settlement — your true gross for the period.
Subtract sourcing cost — purchase price × quantity, but only for Delivered/Exchange rows.
Group by SKU — profit concentrates. Find your top 3 and your bottom 3.
Scan negative settlements — cluster them by SKU. That cluster is your returns problem, itemised.

You can do this in Excel with SUMIFS and a cost lookup — or skip the formula-wrangling: the free EcomFriendly P&L Analyzer reads the payment sheet directly, matches your cost sheet, applies the status logic correctly, and gives you order-wise and SKU-wise tables plus a downloadable Excel report. Everything runs locally in your browser.

One habit worth stealing

Reconcile every payment cycle. Sellers who read their payment sheet weekly catch pricing mistakes, rising return rates, and unprofitable SKUs a month earlier than sellers who don't. In ecommerce, a month is the difference between a course-correction and a crisis.