The core marketplace reconciliation KPIs are settlement match rate, unreconciled balance and its ageing, fee and commission variance against agreed terms, return credit accuracy, claim recovery rate and cycle time, and days from sale to cash. Track them by value and by count, monthly at minimum, with an owner for each.
Why KPIs matter more than a month-end reconciliation
Most finance teams reconcile marketplace sales to settlements at month-end. That tells you what happened, but not whether your process is getting better or worse. KPIs turn reconciliation into something you can review, compare month to month and assign to an owner.
Keep the list short. Each KPI should have a clear formula, a data source (settlement report, order report, seller agreement) and a threshold that you set based on your own margins and volumes. There is no universal benchmark, so avoid copying numbers from other brands.
Matching and ageing KPIs
These show whether money you are owed is arriving and being explained.
- Settlement match rate: orders (or value) matched to a settlement line, divided by orders eligible for settlement. Track by count and by value, since a few high-value orders can hide behind a good count.
- Unreconciled balance: the value of sales, returns or adjustments not yet tied to a settlement entry.
- Ageing of unreconciled items: bucket items as 0-30, 31-60, 61-90 and 90+ days. Check your seller agreement for claim or dispute windows, since items older than the window may be hard to recover.
- Sales-to-settlement gap: gross sales less returns, fees and other deductions, compared with actual payouts for the same period.
Fee and commission KPIs
Fees are where small errors repeat across thousands of orders. Your expected fee must come from your signed agreement and current rate card, not from memory. Rates and fee structures change, so confirm the latest terms with your marketplace account manager.
- Fee variance: fees charged minus fees expected under agreed terms, shown in ₹ and as a percentage of expected fees.
- Variance by fee type: commission, fixed fee, shipping or logistics, collection and any other line in the settlement report. This shows which line causes the gap.
- Orders with variance: the share of orders where charged and expected fees differ, which separates one-off errors from systematic ones.
Tools such as MarketplaceMetrics by Fundle check commissions and fees against agreed terms, so these figures do not depend on manual spreadsheet lookups.
Returns and recovery KPIs
Returns create the messiest reconciliation, because the sale, the reversal and the physical stock movement happen on different dates.
- Return credit accuracy: returns where the settlement reversal matches the order and return record, divided by total returns.
- Returns received vs credited: items that came back to your warehouse compared with items for which you were credited, and the reverse.
- Claims raised: number and value of cases opened for lost, damaged, wrongly charged or not-credited items.
- Recovery rate: value recovered divided by value claimed.
- Recovery cycle time: days from raising a case to money received.
A low recovery rate with a long cycle time usually means evidence is incomplete or claims are raised too late.
Cash and tax KPIs
Days from sale to cash: average time between order or delivery date and settlement receipt. Compare it with the payment cycle in your agreement.
Net realisation per order: money actually received after returns and deductions, divided by orders. Watch it by category and month.
Tax statement agreement: compare tax-related deductions shown in settlement reports with what appears in your tax portal statements. Rates and treatment depend on current law and your registration, so confirm them with your tax adviser rather than assuming a figure.
Setting up the review cadence
Assign each KPI to an owner and a frequency:
- Weekly: match rate and new unreconciled items, reviewed by the operations or marketplace team.
- Monthly: fee variance, ageing, return credit accuracy and recovery, reviewed by finance before closing.
- Quarterly: net realisation, days to cash and fee terms, reviewed with leadership before commercial discussions.
Start with the marketplace that carries the most volume. MarketplaceMetrics reviews Myntra Excel reports today; other marketplaces are in scope discussion, and pricing is a tailored quote.
Worked example
Illustrative example (figures are made up for explanation only):
- Orders eligible for settlement in the month: 1,000. Orders matched to settlement lines: 940. Match rate: 94% by count.
- Expected fees under agreed terms: ₹1,50,000. Fees charged: ₹1,56,000. Fee variance: ₹6,000, or 4% of expected fees.
- Claims raised for missing return credits: ₹45,000. Recovered so far: ₹27,000. Recovery rate: 60%.
- Unreconciled items older than 60 days: ₹38,000, to be checked against the claim window in the agreement.
The finance head would first investigate which fee type drives the ₹6,000 variance, then clear the 60+ day items before they age out.
Questions and answers
What is the most important marketplace reconciliation KPI?
Settlement match rate by value is a good starting point, because it shows how much of what you sold is explained by payouts. Pair it with unreconciled ageing, since old unexplained items are the hardest to recover.
How often should finance heads review these KPIs?
Review match rate and new unreconciled items weekly, fee variance, returns and recovery monthly before closing, and cash and realisation trends quarterly. High-volume sellers or sale periods may justify more frequent checks.
What is a good fee variance percentage?
There is no universal benchmark. Ideally charged fees equal fees expected under your agreement, so any recurring variance deserves investigation. Set your own tolerance based on margins and volume, and confirm current rates in your agreement or rate card.
Can I track these KPIs in Excel?
Yes, for smaller volumes, using settlement and order reports with lookup formulas. It becomes hard to maintain as orders, returns and fee lines grow, so many brands move to automated matching and case tracking.