The best tool is the one that matches your sales and settlement reports order by order, checks every commission and fee against your agreed terms, and tracks returns through to recovery. For Myntra and Nykaa sellers, confirm it reads each marketplace's actual report formats today, not on a roadmap, and test it on your own data before committing.
What 'best' means for a Myntra and Nykaa seller
No single tool is best for every brand. A brand with a few hundred orders a month and one person in finance needs something different from a brand shipping thousands of orders a day across several warehouses. Judge any tool against the work you actually do every month:
- Matching each order to its settlement line
- Checking commission, fixed fees, shipping and other deductions against your agreement
- Tracking returns, RTOs and disputed claims until money is recovered or written off
- Producing numbers your accountant can use at month-end
If a tool only gives you a dashboard of total payouts, it is reporting, not reconciliation. Totals can look fine while individual orders are short-paid.
The checks a reconciliation tool must cover
- Sales to settlement matching. Every order in your sales report should appear in a settlement, or be flagged as pending, returned or missing.
- Commission and fee verification. The tool should compare what was charged with your agreed terms, not just show what was charged.
- Deduction breakdown. You should be able to see each deduction by type, so you can question the ones you do not recognise.
- Returns and recovery cases. Returned and damaged items, claims raised and amounts recovered should sit in one trail with status and ageing.
- Exportable audit trail. Finance and your auditor should be able to trace any number back to the source report line.
Why Myntra and Nykaa need separate handling
Each marketplace has its own report layout, settlement cycle, deduction names and return rules. A tool that handles one well may not handle the other. Do not accept a general claim of 'multi-marketplace support'. Ask the vendor to run a sample of your own Myntra report and your own Nykaa report, and show you the output.
Fee rates, commission slabs and tax treatment change over time. Always take them from your seller agreement, the current rate card and your settlement reports, and confirm the latest terms with the marketplace. For TCS, GST and TDS treatment, check with your tax adviser rather than relying on a tool's default assumptions.
Spreadsheets, accounting software or a dedicated tool
| Option | Works well when | Watch out for |
|---|---|---|
| Spreadsheets | Order volumes are low and one person owns the process | Manual lookups, version errors, no memory of open recovery cases |
| General accounting software | You need ledger entries and tax filing support | Usually books a payout as one entry, without checking order-level deductions |
| Dedicated reconciliation tool | Volumes, SKUs or marketplaces make manual matching unreliable | Report format coverage and setup effort, so test on real files |
Questions to ask before you buy
- Which Myntra and Nykaa reports do you read today, and which are still planned?
- How do you load my agreed commission and fee terms, and what happens when they change?
- Can you show an order that was short-paid, with the evidence I would need to raise it?
- How are returns, RTOs and recovery cases tracked over time?
- Who sets up the mapping, and how long until I see a first reconciled month?
- How is pricing structured, and what does it depend on?
Be wary of any vendor that quotes recovery outcomes before seeing your data. Results depend on your terms, your volumes and your marketplace's processes.
Where MarketplaceMetrics fits
MarketplaceMetrics by Fundle reconciles marketplace sales and settlements for Indian brands, checks commissions and fees against agreed terms, and tracks returns and recovery cases. Myntra Excel reports are reviewed today. Other marketplaces, including Nykaa, are in scope discussion, so confirm your exact report formats with the team before assuming coverage. Pricing is a tailored quote based on your setup.
Worked example
Illustrative example only. The figures and rates below are assumptions to show the method, not actual marketplace rates. Taxes are left out for simplicity.
| Line | Expected per agreement | Actually settled |
|---|---|---|
| Order value | ₹2,000 | ₹2,000 |
| Commission | ₹360 (assumed 18%) | ₹400 (charged at 20%) |
| Fixed fee | ₹30 | ₹30 |
| Logistics | ₹70 | ₹70 |
| Net payout | ₹1,540 | ₹1,500 |
The ₹40 gap traces to commission charged above the agreed rate. At a single order it looks small, but a tool that checks every order shows how often it happens, and gives you a documented case to raise with the marketplace.
Questions and answers
Can one tool reconcile both Myntra and Nykaa payouts?
It can, if it reads each marketplace's report formats. Formats, deduction names and settlement cycles differ, so ask for a demo on your own Myntra and Nykaa files and confirm current coverage in writing before you commit.
Is Excel enough for marketplace reconciliation?
Excel can work at low volumes with one careful owner. It struggles as orders, SKUs and returns grow, because matching is manual and open recovery cases are easy to lose. If month-end close keeps slipping, consider a dedicated tool.
How do I know my commission was charged correctly?
Compare each charged commission with the rate in your seller agreement or current rate card, order by order. Rates can be revised, so confirm the latest terms with the marketplace. A tool automates this check across all orders.
Does MarketplaceMetrics support Nykaa?
MarketplaceMetrics reviews Myntra Excel reports today. Other marketplaces, including Nykaa, are in scope discussion, so share your report formats with the Fundle team to confirm what is possible. Pricing is a tailored quote.