Real settlement, not sale value
Profit is calculated from the final settlement amount in your payment sheet — the money actually credited — rather than the listed sale price.
Free online tool · no sign-up
Meesho P&L Analyzer for what you actually earned
Upload your Meesho payment sheet and a SKU cost list to get order-wise and SKU-wise profit and loss — calculated from the real settlement amount, with returns and RTO flagged, right in your browser.
Analyses a whole payment sheet. To check the margin on a single price before you list, use the Meesho Profit Calculator.
- Files stay on this device
- .xlsx and .csv supported
- Download the analysis
1. Add sheets2. Analyse3. Export
₹0Free analyzer
Order + SKUTwo breakdowns
.xlsx exportThree sheets
On-deviceNo file upload
The short answer
What is a Meesho P&L Analyzer?
A Meesho P&L Analyzer reconciles what you sold against what Meesho actually settled. It reads the payment sheet, matches each Supplier SKU to your purchase price, and reports profit per order and per SKU using the final settlement amount — so returns, RTO and deductions land in the numbers instead of hiding behind gross sales.
Run your sheet
Analyse Meesho profit and loss online
Add your payment sheet and cost sheet, then run the analysis. Both files are read inside this browser tab.
Use the original payment file from the Supplier Panel for the most reliable column detection. Open the analyzer full screen ↗
Built for settlement reality
Gross sales hide the problem SKUs
A profitable-looking month often contains a handful of SKUs quietly losing money on returns. This analyzer surfaces them per order and per SKU.
SKU performance summary
Units settled, net payout, sourcing cost, net profit, blended margin and return rate, aggregated for every SKU in the file.
Return and RTO flags
Each order is marked as profitable, loss, RTO inventory recovered, return recovered, or loss on return shipping, so problem orders stand out.
Unmapped SKU warnings
SKUs with no purchase price in your cost sheet are listed separately and flagged, because treating their cost as zero overstates profit.
Download the full analysis
Export one workbook containing the Order-Wise P&L, SKU Performance and Exceptions sheets for your records or accountant.
Runs in your browser
The payment sheet is parsed locally. Order, customer and SKU data is not sent to an EcomFriendly server for processing.
Step-by-step tutorial
How to analyse your Meesho P&L in five steps
The accuracy of the result depends on the cost sheet, so fix unmapped SKUs before trusting the margin.
Clear the exceptions first
Any SKU without a purchase price is costed at ₹0, which overstates profit.
Cost means landed cost
Include packaging and handling in the purchase price, not just the supplier invoice.
- 01
Download your Meesho payment sheet
In the Meesho Supplier Panel, download the payment file for the period you want to analyse. The analyzer looks for the tab containing the Sub Order No and Supplier SKU columns.
- 02
Prepare a cost sheet
List each Supplier SKU against its purchase price. It can be a separate .xlsx/.csv, or a tab inside the payment file — the analyzer detects either.
- 03
Add both files to the analyzer
Choose the payment sheet, and the cost sheet if it is separate. Nothing is uploaded; both files are read locally in your browser.
- 04
Run the analysis
Click Analyze to produce the settlement, sourcing cost, net profit, blended margin, order-wise table and SKU performance summary.
- 05
Fix exceptions, then export
Check the unmapped-SKU list, add any missing purchase prices, re-run, then download the .xlsx with the order-wise, SKU and exception sheets.
What you get back
Two views of the same money
One row per order for investigating specific problems, and one row per SKU for deciding what to keep selling.
ORDER-WISE P&L
Every sub-order, with a verdict
Sub order number, SKU, product, status, quantity, sale amount, final settlement, purchase price, profit, margin and a plain-English remark such as Profitable, Loss or RTO — Inventory Recovered.
SKU PERFORMANCE
Which products deserve your stock
Units settled, net payout, sourcing cost, net profit, blended margin and return rate for each SKU, sorted so the strongest and weakest products are immediately visible.
Private by design
Your payment sheet never leaves your device
A Meesho payment sheet contains order, settlement and SKU-level business data. This analyzer reads the workbook, runs the calculations and builds the download locally in your browser—without a file-upload API.
Read the privacy policyYour sheetsSelected on this device
→Your browserMatches and calculates
→Your downloadAnalysis workbook
Questions, answered
Meesho P&L Analyzer FAQ
What does the Meesho P&L Analyzer do?
It reads your Meesho payment sheet and your SKU purchase prices, then calculates gross settlement, total sourcing cost, net profit or loss and blended margin — with an order-wise table and a SKU-wise performance summary. It is built to answer "what did I actually earn", not "what did I sell".
Which files do I need to upload?
The Meesho payment sheet (.xlsx or .csv) containing the order payments tab, plus a cost sheet mapping each Supplier SKU to its purchase price. The cost sheet is optional if the cost data already sits in a tab inside the payment file.
How should the cost sheet be formatted?
One row per Supplier SKU with its purchase price. The analyzer recognises SKU columns named Supplier SKU, SKU or Row Labels, and price columns named PP, Purchase Price, Sourcing Cost, Cost Price or Cost.
What does "Purchase Price Missing" mean?
That SKU appears in the Meesho file but has no matching row in your cost sheet, so its purchase cost is treated as ₹0 and its profit is overstated. Those SKUs are listed in the Unmapped Exceptions section — add them to your cost sheet and run the analysis again.
Which orders count towards sourcing cost?
Units are counted as settled for delivered and exchange orders. Returned and RTO orders still appear in the table with their settlement impact and a flag, so you can see the cost of returns separately.
Is my payment sheet uploaded to a server?
No. Reading the workbook, matching SKUs, calculating profit and building the download all happen locally in your browser. The files you choose are not sent to EcomFriendly for processing.
Can I download the results?
Yes. The analyzer exports a single .xlsx workbook containing an Order-Wise P&L sheet, a SKU Performance sheet, and an Exceptions sheet listing any unmapped SKUs.
Is the Meesho P&L Analyzer free?
Yes. It is free to use with no account required. If you are signed in to EcomFriendly, you are taken to the dashboard version of the same tool.
Free for every payment cycle
Find out what last month actually earned
Run the payment sheet, clear the unmapped SKUs, and get an order-wise and SKU-wise picture you can act on.