A sample report you can check yourself
Explore 727 sample orders across four products. See how settlement becomes profit and follow the exact calculations with fixed sample costs. No sign-up required.
All orders, products and claims are made up. This is an educational example, not a seller testimonial or an official Meesho report.
Where the sample settlement goes
Settlement − item cost − stock written off − packaging = estimated profit. Platform deductions and the sample’s claim credits are already included in settlement.
Fixed assumptions: ₹6 packaging per dispatched unit and full item-cost write-offs on RTO and customer returns. The examples model stock that cannot be resold.
Product results with the fixed sample costs
| Product | Profit | Margin |
|---|---|---|
Cotton Kurti SetKRT-104 | ₹8,549 | 12.0% |
Printed Silk SareeSAR-221 | ₹5,037 | 9.6% |
Kids Frock ComboKFC-009 | ₹4,942 | 15.9% |
Men's Track PantsTRK-330 | −₹303 | -2.0% |
Reproduce these totals from the XLSX
- Download the workbook above. Its Order Payments sheet contains the same rows used by this walkthrough. The original dashboard uses its own separate sample fixture.
- In your own account, upload it and set each item cost from the Sample instructions sheet. Costs are entered manually; that sheet is not imported automatically.
- Set packaging to ₹6 and enable both item-cost write-offs. You should get ₹1,69,751.84 settlement and ₹18,224.84 profit.
This separate educational fixture uses the same calculation engine as uploaded reports; its totals differ from the original sample dashboard. No external advertising or account-level charges are present in this workbook.
Follow the money, one order at a time
These examples use the downloadable fictional report with ₹6 packaging per dispatched order. Item cost on RTO and customer returns is enabled, modelling stock that cannot be resold. The examples below use these fixed assumptions.
Delivered order · Cotton Kurti Set
Sub-order 1284700002_1. The seller keeps the sale proceeds after report deductions.
| Report line or seller cost | Amount |
|---|---|
| Sale amount (P) | ₹329.00 |
| Commission (W) | ₹0.00 |
| Forward shipping (AD) | −₹58.50 |
| Customer-return shipping (AB) | ₹0.00 |
| Withholdings (AI + AK, illustrative) | −₹3.44 |
| Final settlement (N), fees already included | ₹267.06 |
| Product cost / stock write-off | −₹205.00 |
| Packaging | −₹6.00 |
| Profit on this payment row | ₹56.06 |
Return to origin · Cotton Kurti Set
Sub-order 1284700050_1. The buyer never received the item. This sample has no RTO return-shipping charge.
| Report line or seller cost | Amount |
|---|---|
| Sale amount (P) | ₹0.00 |
| Commission (W) | ₹0.00 |
| Forward shipping (AD) | ₹0.00 |
| Customer-return shipping (AB) | ₹0.00 |
| Withholdings (AI + AK, illustrative) | ₹0.00 |
| Final settlement (N), fees already included | ₹0.00 |
| Product cost / stock write-off | −₹205.00 |
| Packaging | −₹6.00 |
| Profit on this payment row | −₹211.00 |
If this item comes back fully saleable, omit its item-cost write-off when calculating your own report. That adds ₹205.00 back to this example’s profit; packaging remains spent. A later claim is a separate credit and is added once when calculating the product total.
Customer return · Cotton Kurti Set
Sub-order 1284701721_1. The sale is reversed; forward and customer-return shipping remain in this illustrative payment row.
| Report line or seller cost | Amount |
|---|---|
| Sale amount (P) | ₹329.00 |
| Sale reversal (Q) | −₹329.00 |
| Commission (W) | ₹0.00 |
| Forward shipping (AD) | −₹58.50 |
| Customer-return shipping (AB) | −₹78.20 |
| Withholdings (AI + AK, illustrative) | ₹0.00 |
| Final settlement (N), fees already included | −₹136.70 |
| Product cost / stock write-off | −₹205.00 |
| Packaging | −₹6.00 |
| Profit on this payment row | −₹347.70 |
If this item comes back fully saleable, omit its item-cost write-off when calculating your own report. That adds ₹205.00 back to this example’s profit; packaging remains spent. A later claim is a separate credit and is added once when calculating the product total.
Why Men's Track Pants loses money in this sample
100 orders include 77 delivered units, 15 RTOs and 6 customer returns. ₹14,984.96 settlement − ₹11,550.00 delivered item cost − ₹3,150.00 stock written off on RTO/returns − ₹588.00 packaging = −₹303.04.
The loss reflects this fictional seller’s inventory-write-off assumption. An RTO is not automatically lost inventory. Check the returned stock’s condition before applying the same setting to your business.
Map the report to the calculation
| Column | Meaning | How the tool uses it |
|---|---|---|
| A / H / K | Sub-order ID / status / quantity | One lifecycle outcome per sub-order; costs follow item quantities. |
| D / E | Product name / SKU | Costs and aggregation use product name; SKU is shown as a reference. |
| M / N | Payment date / final settlement | Payment-date trend and the starting point for profit. |
| P / Q | Sale / sale reversal | Explain revenue separately from the final payout. |
| W / AB / AD | Commission / return shipping / shipping | Displayed as a breakdown; never subtracted again from settlement. |
| AI / AK | TCS / TDS | Explain cash withheld; the dashboard does not calculate your tax liability. |
| AL / AM / AN | Compensation / claims / recovery | Keep signed amounts, including blank-status adjustment rows. |
Repeated rows, missing costs and report boundaries
A sub-order can appear on several payment rows. The engine sums their signed settlements and adjustments, but uses one lifecycle outcome to count units and apply physical item costs. A blank status with a monetary amount is an adjustment, not another sale. Identical duplicated payment rows are not automatically removed: avoid combining overlapping exports.
A missing item cost is treated as zero, so enter every product’s purchase cost before relying on its margin. The margin shown here is profit divided by the absolute settlement amount, not the customer’s sale price. It is a settlement-based estimate; overhead, tax credits, income tax, inventory valuation and charges absent from your file require separate reconciliation.
Meesho’s published policy states 0% commission, no collection fee and no return-shipping fee for RTOs. Customer returns are different. Check the actual signed entries in your file and your applicable seller terms. Sample tax and shipping amounts are illustrative, not a current tariff or tax-rate reference. Source: Meesho pricing policy (checked 9 October 2026).
Use the same method on your own report
Start with your actual payment file, enter purchase and packaging costs, and check returned inventory before choosing write-off settings.
Get started freeRead the payment-file guide