To reconcile Meesho supplier payments with orders, download your order and payment reports for the same period, match them on order or sub-order ID, compute the expected payout from your agreed terms, compare it with the amount received, and classify each difference as timing, return, deduction or error. Raise a support ticket for errors, with evidence.
Why Meesho payments rarely match orders one-to-one
A payout is not a simple sum of your sales. It is a net figure: the order value, less deductions, adjusted for returns and any earlier corrections. A single bank credit can cover many orders, and a single order can show up in more than one payment cycle.
So the goal is not to make two totals equal on day one. The goal is to explain every rupee of difference. Typical reasons include:
- Timing: delivered orders that are not yet due for payment.
- Returns and RTOs: reversed or adjusted amounts.
- Deductions: charges that your seller agreement allows, and some it may not.
- Tax items: amounts withheld or collected under tax rules.
- Errors: wrong weight slabs, duplicate charges or missing credits.
Collect the right data first
Pull everything for one fixed period, ideally a calendar month, so you are comparing like with like. Report names and columns change, so check the current labels in your supplier panel.
- Order report: order or sub-order ID, order date, SKU, quantity, selling price, status.
- Payment or settlement report: payment date, order ID, payout amount, each deduction line, adjustments.
- Returns data: return type (customer return, RTO), dates, receipt status at your warehouse.
- Bank statement: the actual credits received.
- Your agreement and current charge terms: the reference for what should be deducted.
Confirm the latest charge structure from your Meesho agreement and the panel, not from memory or old emails.
Step-by-step: match payments to orders
- Standardise IDs. Make sure order IDs have the same format in both files. Remove spaces and stray characters, and keep IDs as text so Excel does not alter long numbers.
- Match on order or sub-order ID. Use a lookup so each order row shows the payout and deductions from the payment report.
- Classify every order. Use statuses such as paid, pending (not yet due), returned, and missing from payments.
- Compute expected payout. Selling price less the deductions your terms allow, adjusted for returns.
- Compare expected with received. Calculate the difference per order and sort by largest variance.
- Tie to the bank. Total payments by payment date and check them against bank credits. Any gap here is a settlement-level issue, not an order-level one.
Check deductions against your agreed terms
This is where most recoverable money hides. List each deduction type that appears in the payment report, then compare it with your agreement or the current rate card. Do not assume a charge is right because it appears consistently.
- Is each charge type actually in your terms?
- Is the rate or slab applied the one you agreed to?
- Is any charge applied twice to the same order?
- Do tax-related lines match the basis in your tax adviser's guidance? Rates and rules change, so confirm the latest position with your adviser and the marketplace documentation.
Keep a short deduction master sheet with charge name, basis, source document and date of last check. It makes the next month much faster.
Handle returns, RTOs and pending items
Returns are the second big source of mismatch. For each returned order, confirm three things: the reversal in the payment report, any return-related charge, and whether the item physically reached you in saleable condition.
- Match return receipts at your warehouse with return entries in the report.
- Flag returns that were charged but never received, or received but not credited.
- Age your pending items. If an order is delivered and past the payment window in your terms but still unpaid, move it to a follow-up list.
Teams that handle this at scale often track these as recovery cases with an owner, a ticket reference and a status. MarketplaceMetrics by Fundle does this for Indian marketplace sellers, checking fees against agreed terms and tracking returns and recoveries. Myntra Excel reports are reviewed today, and Meesho coverage would be a scope discussion.
Make it a monthly routine
Reconcile on a fixed schedule, such as weekly for payments and monthly for a full close. Before closing the month, make sure every order is in one bucket: paid and tied out, pending with an expected date, or disputed with a ticket.
- Record the variance reasons, not just the amounts.
- Raise tickets with order ID, expected amount, received amount and the clause or rate card you rely on.
- Check your agreement for any time limit on raising disputes, and act well inside it.
- Review repeat issues quarterly and escalate patterns, not just single orders.
Worked example
Illustrative example only. These figures are made up to show the method, not real Meesho rates or amounts.
| Order | Expected payout (₹) | Received (₹) | Difference (₹) | Likely reason |
|---|---|---|---|---|
| A (delivered) | 520 | 520 | 0 | Matches terms |
| B (delivered) | 410 | 380 | -30 | Deduction not found in agreed terms |
| C (RTO) | 0 | -40 | -40 | Return charge to verify |
| Total | 930 | 860 | -70 | Two items to investigate |
The ₹70 gap is not a mystery once split by order. Order B and Order C go to the follow-up list with the relevant clause, and Order A is closed.
Questions and answers
Which Meesho report should I use to reconcile payments?
Use the order report together with the payment or settlement report from your supplier panel, covering the same period. Report names and columns can change, so check the current options in the panel and keep the bank statement for the final tie-out.
Why is my Meesho bank credit different from my sales?
The credit is a net amount. It reflects deductions, return adjustments, tax-related items and timing differences, and may cover orders from different dates. Break it down order by order to see which component explains the gap.
How often should I reconcile Meesho payments?
A weekly check on payments received and a full monthly reconciliation before books close works for most sellers. High-volume sellers may check more often, because earlier detection leaves more time to raise disputes within the window in their agreement.
Can I reconcile Meesho payments in Excel?
Yes. Standardise order IDs, use lookups to join order and payment data, compute expected payouts from your terms, and sort by variance. It works well at low volumes, but gets slow and error-prone as order counts and return cases grow.
