Settlement Reconciliation•8 min read•
How to Reconcile Meesho Payment Settlement Reports: The Complete Step-by-Step Guide
Learn how to audit official Meesho payment Excel spreadsheets, spot hidden reverse freight penalties, verify GST TCS/TDS withholdings, and match bank disbursements against dispatched orders.
ES
Evyaparsathi Financial Intelligence Team
Ecommerce Accounting Specialists
Table of Contents
1. Why Meesho Bank Disbursements Don't Tell the Full Story
When you check your bank account after a Meesho payout cycle, you receive a single lump-sum NEFT or RTGS credit. But that single bank transfer represents the net result of hundreds of separate micro-transactions: delivered orders, customer return penalties, courier return (RTO) freight charges, advertising deductions, compensation claims, and statutory tax withholdings.
Without granular reconciliation, sellers frequently face three critical blind spots:
- **Unsettled Delivered Orders:** Orders marked as delivered 30+ days ago that were never credited to your bank account due to platform processing delays.
- **Double-Deducted Return Charges:** Returns where courier reverse freight was charged twice or applied to courier-fault cancellations.
- **Unverified Tax Deductions:** 1% GST TCS (Tax Collected at Source) and 1% TDS under Section 194-O deducted from gross sales that need to match your Form 26AS and GSTR-8 portal filings.
2. Understanding the Multi-Sheet Meesho Payment Report
When you download your settlement file from the Meesho Supplier Panel (under Payments > Previous Payments > Download Excel), the resulting workbook contains multiple specialized tabs:
1. **Order Payments:** The positive credits for customer-delivered orders, listing the Supplier Listed Price, customer price, marketplace fee waivers, and net payable.
2. **Returns / Reverse Freight:** Negative entries representing shipping charges deducted when a customer returns a delivered item.
3. **Compensations:** Credits granted by Meesho when goods are damaged in courier transit or lost in the delivery network.
4. **Advertising & Promotions:** In-platform marketing deductions for sponsored product ads running on the Meesho feed.
5. **Other Deductions:** Manual adjustments, penalty fees, or carrier chargebacks.
Understanding how each sheet impacts your bottom line is the first step toward stopping settlement leaks.
3. The 5-Step Order-to-Settlement Audit Process
To perform an accurate audit of your marketplace payouts:
- **Step 1: Normalize Sub-Order Numbers:** Never reconcile by Master Catalog ID. Always match on the granular Sub-Order Number (e.g., `123456789_1`), as multi-item customer carts are split into separate fulfillment events.
- **Step 2: Connect Orders to Payment Entries:** Cross-reference your Meesho Orders CSV with the Order Payments sheet. Check off every dispatched order that has reached an official `DELIVERED` state.
- **Step 3: Audit Deductions by SKU:** Attribute return shipping deductions directly to the specific SKU that generated them. This reveals if certain fragile or low-cost products are generating net losses across their batch.
- **Step 4: Check Tax Withholdings:** Verify that TCS (1% of net taxable supply under Section 52 of CGST Act) and TDS (1% under Section 194-O of Income Tax Act) match your internal sales ledger.
- **Step 5: File Timely Supplier Support Tickets:** Meesho has strict dispute windows (typically 7 to 14 days from payout statement). Raising tickets with precise Sub-Order Numbers and Excel row references dramatically improves claim approval rates.
4. Automating the Entire Process with Evyaparsathi
Manually cross-referencing multi-thousand-row Excel files with VLOOKUP is tedious and error-prone. Evyaparsathi automates this entire lifecycle:
- Ingests raw multi-sheet Meesho payment workbooks with cryptographic SHA-256 deduplication.
- Automatically breaks down all 18 standard deduction columns.
- Reconciles every customer sub-order against bank settlement lines.
- Highlights uncredited orders and underpayments on an actionable review ledger.
Explore Related Evyaparsathi Features
Put these concepts into practice with our purpose-built financial intelligence tools for Meesho sellers:
Feature GuideMeesho Settlement ReconciliationAudit payment workbooks, deductions & bank deposits.Feature GuideRTO & Returns IntelligenceStop reverse freight loss and track accurate return rates.Feature GuideDated Landed SKU Cost HistoryPreserve historical margins when supplier costs change.Feature GuideBreak-Even Pricing SimulatorCalculate target profits and price floors algebraically.
Stop guessing your marketplace profit.
Join Indian ecommerce sellers using Evyaparsathi to reconcile settlement workbooks and maintain verified net margins.
