Myntra settlement reconciliation software takes your sales, returns and settlement reports, matches them order by order, and checks deductions against your agreed terms. It flags short payments, wrong fees and unrecovered returns so finance can raise cases with evidence. Look for order-level matching, rule-based fee checks, returns tracking and an audit trail, not just a payout summary.
Why Myntra payouts are hard to reconcile
A Myntra settlement is rarely a clean number. One payout can combine many orders, returns, commissions, fees, adjustments and tax deductions, often spread across different dates. When the bank credit does not match your sales report, the gap could come from any of these lines.
Brands usually hit the same problems:
- Timing gaps: an order is sold in one period but settled in another.
- Return mismatches: a return is deducted, but the stock never reaches you, or comes back damaged.
- Fee variances: a charge differs from what your seller agreement or rate card says.
- Bundled adjustments: penalties, reversals and corrections appear as lump sums.
Doing this monthly in Excel works at low volume. It breaks down when SKUs, returns and settlement cycles multiply.
What good reconciliation software should do
Before comparing vendors, define the job. For a Myntra seller, the software should cover five things:
- Match at order level. Every settled order should link to a sale, and every deduction to an order or a documented adjustment.
- Check fees against your terms. Commission and other charges should be compared with the rates in your agreement, not with what Myntra charged last month.
- Track returns end to end. From return deduction to stock received to credit confirmed.
- Surface exceptions. Short payments, missing credits and unexplained deductions should appear as a worklist.
- Keep evidence. You need order IDs, report references and dates ready when you raise a query with the marketplace.
A dashboard showing total payout versus total sales is not reconciliation. It hides the order-level differences that actually cost money.
The data you need before you start
Software is only as good as its inputs. Gather these from your Myntra seller panel and your own records. Report names and formats change, so use what your panel currently provides.
- Sales or order report for the period.
- Settlement or payout report with the order-wise breakup of deductions.
- Returns report, including return reasons and status.
- Seller agreement and rate card with the commission and fee terms you agreed. Confirm the latest version with your account manager.
- Bank statements to confirm the actual credit date and amount.
For GST, TCS or TDS treatment on settlements, follow your settlement report and your tax adviser. Do not assume a rate from a blog post, including this one.
Evaluation checklist for buyers
Use this table when shortlisting tools or reviewing an in-house build.
| Capability | What to ask |
|---|---|
| Input handling | Can it read Myntra Excel reports as you download them, without heavy reformatting? |
| Matching depth | Is matching at order or line level, or only at payout total? |
| Fee rules | Can you set rules from your own agreement and see which orders break them? |
| Returns | Does it track return deductions against stock received and credits? |
| Exceptions | Is there a worklist with status, owner and notes? |
| Audit trail | Can you export evidence for a dispute? |
| Scope | Can it extend to other marketplaces you sell on? |
Spreadsheet, in-house build or specialist tool
Spreadsheets are fine while volumes are small and one person owns the process. Risks are broken formulas, version confusion and knowledge that leaves with the person.
In-house builds give control, but need engineering time to maintain when report formats change.
Specialist tools make sense when you have many SKUs, frequent returns, or finance time is going into repeated matching. The deciding question is simple: how many hours does your team spend each month, and how often do unexplained differences go unresolved because nobody has time to chase them?
How MarketplaceMetrics approaches Myntra reconciliation
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 as part of the process. Other marketplaces are in scope discussion, so ask about your specific mix.
Pricing is a tailored quote based on your setup. When you book a demo, bring one recent settlement report and your agreement, and ask to see how a mismatch is traced from payout to order to rule.
Worked example
Illustrative example only. Figures are not real rates or results.
| Line | Amount (₹) |
|---|---|
| Gross sales in the settlement batch | 1,00,000 |
| Less: returns deducted | 12,000 |
| Less: commission and fees as per agreed terms | 18,000 |
| Expected settlement | 70,000 |
| Actual settlement received | 67,500 |
| Variance to investigate | 2,500 |
Order-level matching splits the ₹2,500 gap into ₹1,400 of fees charged above the agreed terms on a few orders and ₹1,100 of return-related deductions with no matching return received. Each now has an order list, so your team can raise two specific cases instead of querying a vague shortfall.
Questions and answers
What is Myntra settlement reconciliation?
It is the process of matching Myntra payouts to your orders, returns, fees and adjustments, then checking each deduction against your agreed terms. The aim is to confirm you were paid correctly and to identify differences you can raise with Myntra.
Can Excel handle Myntra reconciliation?
Yes, at low volumes with a careful owner. As orders, returns and settlement cycles grow, formula errors, version issues and manual effort rise. Software helps when you need repeatable order-level matching and a trackable list of exceptions.
What reports do I need for reconciliation?
Typically the sales or order report, settlement report, returns report, your seller agreement or rate card, and bank statements. Report names and layouts can change, so use what your Myntra seller panel currently provides and confirm terms with your account manager.
Does MarketplaceMetrics support marketplaces other than Myntra?
Myntra Excel reports are reviewed today. Other marketplaces are in scope discussion, so the answer depends on which ones you sell on and what reports they provide. Share your marketplace mix when requesting a tailored quote.