Skip to main content
How-To · 6 min read

Marketplace Fee Audit: Identifying Revenue Leakage in E-Commerce Settlement Reports

E-commerce sellers lose 2-3% of gross payment volume to fee errors that never get audited. Commission category misclassification, volumetric weight overcharges, incomplete return reversals, and incorrect TCS calculations compound silently across thousands of orders. For a seller processing ₹5 crore GMV per month, that translates to ₹10-15 lakh in annual leakage from settlement report discrepancies alone.

Terra Insight
Terra Insight Reconciliation Infrastructure

Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →

Published 3 April 2026
Domain expertise
TDS Reconciliation GST Input Credit Platform Settlements NACH Batch Matching Bank Reconciliation Form 26AS Matching ERP Integrations Enterprise Finance Ops
Knowledge Card
Problem

E-commerce sellers lose 2-3% of gross payment volume to undetected marketplace fee errors — wrong commission categories, weight overcharges, and unreversed return fees.

How It's Resolved

Decompose each settlement into commission + shipping + TCS + TDS + returns. Compare commission rate against product category master. Validate volumetric weight against actual weight. Verify return fee reversals within 90-day SAFE-T window.

Configuration

Commission rates 2-22% by category, volumetric weight formula L×W×H/5000, SAFE-T claim window 90 days, settlement report retention 90 days, TCS at 0.5% on net taxable supplies.

Output

Fee variance report by error type, overcharge recovery claims with SAFE-T filing support, and monthly settlement reconciliation with order-level P&L.

A seller processing 500 orders per day across Amazon, Flipkart, and Meesho receives settlement reports with 15-20 different fee line items per order. Commission rates, shipping charges, closing fees, fixed fees, TCS deductions, and return adjustments are each computed independently by the marketplace. When any one of these calculations is wrong, the error repeats across every affected order until the seller identifies it. Most sellers never do.

What a Marketplace Fee Audit Involves

A marketplace fee audit is the systematic comparison of fees charged in settlement reports against the applicable fee schedule for each order. The audit covers referral commission rates by category, shipping and weight charges, closing fees, fixed fees, return-related fee reversals, and TCS computations. The objective is to identify systematic overcharges that reduce the seller’s net realisation per order.

The challenge is scale. A seller with 15,000 orders per month across three marketplaces generates 45,000 order-level fee records. Settlement reports are retained by marketplaces for only 90 days, making proactive download and archival essential for any retroactive audit.

Where Fee Errors Occur

Commission Category Misclassification

Amazon and Flipkart referral commission rates range from 2% to 22% depending on the product category. A product listed under “Electronics Accessories” at 10% commission that the marketplace system classifies under “Computers and Accessories” at 5.5% creates a systematic variance on every order. The reverse is more common and more costly: a lower-commission product classified into a higher-commission category. Sellers with 200+ SKUs across multiple categories are most exposed to this error.

Volumetric Weight Overcharges

Marketplaces compute shipping charges using the higher of actual weight or volumetric weight (L x W x H / 5000). A packaging discrepancy of 10 grams can push an order into the next weight slab, adding ₹15-30 per shipment. Across 10,000 shipments per month, a systematic 10-gram overstatement costs ₹1.5-3 lakh monthly. Sellers must verify the weight recorded in the settlement report against actual dispatch weight, which requires maintaining dispatch-level weight logs.

Return Fee Reversal Failures

When a customer returns an order, the marketplace should reverse the commission, closing fee, and shipping charge. In practice, reversals are often incomplete. Amazon’s November 2025 policy change stopped reimbursing closing fees on returned orders. Refund administration fees are retained even on legitimate returns where the seller was not at fault. Each unreversed fee is typically ₹20-50 per order, but at 8-12% return rates on fashion and lifestyle categories, the aggregate impact is significant.

TCS Calculation Errors

Section 52 of the CGST Act requires marketplaces to collect TCS at 1% (0.5% CGST + 0.5% SGST for intra-state, or 1% IGST for inter-state). The computation base must be the net value of taxable supplies excluding GST. Errors occur when TCS is computed on the gross value including GST, or when the intra-state vs. inter-state classification does not match actual delivery geography.

Marketplace Fee Audit Reference

Fee TypeError PatternTypical Impact per OrderAudit Data Source
Referral commissionWrong product category applied₹20-200Settlement report vs. fee schedule
Shipping / weightVolumetric weight exceeds actual₹15-30Settlement report vs. dispatch weight log
Closing feeNot reversed on return₹20-50Return report vs. settlement adjustments
Fixed feeCharged on cancelled orders₹5-25Cancellation report vs. settlement
TCSComputed on gross including GST0.1-0.3% of order valueTCS certificate vs. GSTR-8
Refund admin feeRetained on seller-faultless returns₹10-30Return reason report vs. fee reversal

Recovery Mechanisms and Deadlines

Amazon SAFE-T (Seller Assurance for E-commerce Transactions) claims have a 90-day filing window from the date of the disputed transaction. The process requires supporting documentation within 3 days of an information request, and sellers get one appeal within 7 days of a denial. An active A-to-Z guarantee claim on the same order takes precedence and blocks SAFE-T filing.

Flipkart sellers must raise disputes through the seller dashboard within the settlement dispute window, which varies by seller tier. Settlement reports for both platforms are available for download for only 90 days, so finance teams must automate report downloads to preserve audit trail continuity.

For sellers managing settlements across multiple marketplaces, payment gateway reconciliation tooling that unpacks lump-sum bank credits into order-level components is essential. Manual VLOOKUP matching achieves approximately 51% match rate on settlement data; reconciliation software India-wide deployments with structured matching improve this to 88% by applying order ID, UTR reference, and amount-based multi-signal matching across settlement reports.

Fee schedules, settlement report formats, and SAFE-T claim procedures are available on Amazon Seller Central India.

Primary reference: Amazon Seller Central India — where settlement reports, fee schedules, and SAFE-T claim submission are available.

Frequently Asked Questions

How much revenue do sellers typically lose to marketplace fee errors?
Industry analysis indicates sellers lose 2-3% of gross payment volume to fee-related errors. For a seller with ₹5 crore monthly GMV, this translates to ₹10-15 lakh annually. The most common sources are commission category misclassification, volumetric weight overcharges, and incomplete fee reversals on returned orders.
How do I file a SAFE-T claim on Amazon India?
SAFE-T claims must be filed within 90 days of the disputed transaction through Seller Central. Amazon sends information requests with a 3-day response window. If the claim is denied, sellers have one appeal within 7 days. Note that an active A-to-Z guarantee claim on the same order blocks SAFE-T filing until the A-to-Z claim is resolved.
What is the settlement cycle for Flipkart sellers?
Flipkart settlement cycles depend on the seller tier: Platinum sellers receive settlements at T+5, Gold at T+7, Silver at T+10, and Bronze at T+15 business days. Following the 2025 pricing update, Flipkart determines the final selling price in certain categories, which means the commission structure is applied to a marketplace-determined base rather than the seller's listed MRP.
How should TCS on marketplace settlements be verified?
TCS under Section 52 of the CGST Act must be computed on the net value of taxable supplies, excluding GST. Sellers should verify that TCS is not being computed on the gross settlement amount including GST. Additionally, the intra-state and inter-state split must match actual delivery addresses, not the seller's registered address. Cross-reference TCS credits in Form 26AS against the marketplace TCS certificate quarterly.
Why do manual VLOOKUP audits miss marketplace fee errors?
Manual VLOOKUP matching against settlement reports achieves approximately 51% match rate because marketplace settlements arrive as lump-sum bank credits covering thousands of orders, with deductions for commission, shipping, TCS, and returns netted at the line-item level. Order-level matching requires unpacking each settlement row into its constituent fee components and matching against the original order, which VLOOKUP cannot do without extensive preprocessing.

See how TransactIG handles reconciliation for your industry

Configuration takes 2–4 weeks. No code development required. ISO 27001:2022 certified.