BLOG
Why Your Marketplace Sales and Settlement Amounts Don’t Match: A Complete Reconciliation Guide
Open your marketplace dashboard, check total sales for the month, then check what actually landed in your bank account. The two numbers rarely match, and if you sell on Amazon, Flipkart, Meesho, or JioMart, you've probably seen this gap more than once.
Most sellers assume something is wrong the first time they notice it. In reality, a marketplace sales and settlement amount mismatch is common and usually explainable, once you know where to look.
The real problem starts when sellers stop checking why the gap exists. Small unexplained differences pile up across settlement cycles, and by the time someone notices, it's hard to tell which part is a normal deduction and which part is a genuine loss.
This guide breaks down exactly why settlement amounts differ from sales figures, and how to reconcile them cycle after cycle without losing track of your money.
What Does It Mean When Sales and Settlement Amounts Don't Match?
A sales and settlement mismatch happens when the amount a marketplace reports as your total sales is higher than the amount actually credited to your bank account. This is usually not missing money; it reflects deductions such as commission, shipping fees, TCS/TDS, and returns processed after the order was recorded. A true mismatch only exists if the gap can't be explained by these known deductions.
Why Sellers Struggle to Reconcile Marketplace Payments
Reconciliation sounds simple on paper: compare what you sold against what you got paid. In practice, most sellers find it one of the most frustrating parts of running an online business.
Part of the problem is scale. A seller running Amazon, Flipkart, Meesho, and JioMart accounts together is dealing with four different report formats, four different settlement cycles, and four different sets of fee structures. What counts as a "settled" order on one marketplace might still be pending on another.
Then there's the manual work. Most sellers still download separate sales and settlement reports and try to match them line by line in spreadsheets. This works fine at low order volumes, but it breaks down fast once a business is processing hundreds or thousands of orders a month. A single missed row or mismatched Order ID can throw off an entire reconciliation sheet.
The bigger issue is visibility. Without a unified view that connects an order to its current status - delivered, returned, RTO, or cancelled - and its payment status, sellers end up guessing which gaps are normal and which need follow-up. That guesswork is where real revenue leakage hides.
Common Reasons Sales and Settlement Amounts Differ
Most mismatches come down to a handful of recurring factors. Understanding each one makes it much easier to tell a normal deduction apart from an actual problem.
Marketplace commission and referral fees
Every marketplace deducts a percentage-based commission plus category-specific referral fees before settling the payment, so the settled amount is always lower than the listed sale price.
Shipping and fulfilment charges
If the marketplace handles shipping (as with Amazon FBA-style or Flipkart-fulfilled orders), shipping, packaging, and fulfilment fees are deducted at source rather than billed separately.
TCS/TDS deductions
Under GST and Income Tax rules, marketplaces deduct Tax Collected at Source (TCS) and Tax Deducted at Source (TDS) before settlement. These appear as tax credits, not losses, but they do reduce the amount paid out.
Returns, RTO, and cancellations
An order can be recorded as a sale on the date it's placed, but if it's returned, cancelled, or comes back as RTO (Return to Origin) later, the settlement is adjusted or reversed in a future cycle.
Refunds and partial refunds
Full or partial refunds issued to customers reduce the settlement amount, sometimes in a completely different payment cycle than the original sale.
Delayed or pending settlements
Not every sale gets paid out immediately. Some orders fall into the next settlement cycle, which makes a month-to-month comparison look like a mismatch when it's really just timing.
Promotional or discount adjustments
Seller-funded discounts, coupons, or marketplace promotions reduce the amount you actually receive, even if the listed order value stayed the same.
Chargebacks or claims
Damage claims, lost-shipment claims, or customer disputes raised by the marketplace can result in deductions that don't clearly map back to a specific order in the sales report.
Reporting timing differences
Sales reports are usually generated by order date, while settlement reports are generated by payment date. A sale placed on the 28th of one month might not settle until the following cycle.
How to Reconcile Marketplace Sales and Settlement Reports (Step-by-Step)
Reconciliation doesn't need to be complicated, but it does need to be consistent. Following the same process every cycle is what actually catches genuine discrepancies.
Step 1: Export both reports separately
Download the marketplace's sales report and its settlement or payment report for the same period. Treat them as two different data sources, not one.
Step 2: Match orders using Order ID or AWB number
These are the only reliable identifiers across marketplaces. Matching by product name or amount alone leads to errors.
Step 3: Separate orders by status
Split the data into delivered, returned, RTO, and cancelled orders before comparing amounts. A settlement gap on a returned order means something very different from one on a delivered order.
Step 4: Deduct known fees and taxes from gross sales
Subtract commission, shipping charges, and TCS/TDS from the sales figure first, so you're comparing net expected settlement against actual settlement, not gross sales against net payout.
Step 5: Flag orders with no matching settlement entry
Any order that appears in the sales report but has no corresponding line in the settlement report needs a closer look.
Step 6: Cross-check flagged orders against return/RTO status
Many flagged orders turn out to be pending returns or RTOs that simply haven't been settled yet, not lost payments.
Step 7: Maintain a running reconciliation sheet by cycle
Track each settlement cycle separately so unresolved gaps don't get buried under the next month's data.
A Practical Example: Spotting a Real Mismatch
Here's how this plays out for a typical seller.
A Meesho seller records ₹50,000 in sales for a settlement cycle. When the payment settles, only ₹41,000 shows up in the bank account - a ₹9,000 gap.
Sales
₹50,000
Settled
₹41,000
Gap
₹9,000
- Commission and referral fees₹4,000
- TCS deduction₹1,000
- RTO order reversed in this cycle₹3,500
- Still unaccounted₹500
One order worth ₹3,500 was marked RTO after the sale was recorded, and its settlement was reversed in this cycle. That leaves roughly ₹500 unaccounted for.
At this point, the seller has explained ₹8,500 of the ₹9,000 gap through normal deductions and one RTO. The remaining ₹500 is small, but it's worth checking - it could be a partial refund, a rounding adjustment, or an order that genuinely needs follow-up with marketplace support.
This is the core of reconciliation: not assuming every gap is a fee, and not assuming every gap is a loss either.
Sales Report vs. Settlement Report: What Each One Shows
| Aspect | Sales Report | Settlement Report |
|---|---|---|
| Data source | Order-level data from the marketplace | Payment-level data from the marketplace's finance system |
| What it includes | Order value, product details, order date, buyer location | Net payout amount, fees deducted, TCS/TDS, refunds, adjustments |
| When it's generated | At the time the order is placed | At the end of a settlement cycle (weekly/biweekly/monthly, depending on marketplace) |
| Reflects returns/RTO? | Only current status at time of export | Yes, once processed and adjusted into a payout |
| Best used for | Tracking order volume and sales trends | Verifying actual money received and reconciling with bank statements |
Making Payment Reconciliation Easier with TrackMyOrders
Manually reconciling sales and settlement reports across multiple marketplaces is one of the most time-consuming parts of running an online business. TrackMyOrders helps by giving sellers a more organized way to manage this data.
Once you import your marketplace reports using TrackMyOrders' spreadsheet-based upload template, the platform centralizes orders from Amazon, Flipkart, Meesho, and JioMart into a single dashboard, instead of leaving them scattered across separate seller panels and spreadsheets. This makes it much easier to see the full picture without switching between platforms.
From there, TrackMyOrders lets you:
Track order status
See which orders are delivered, returned, RTO, or cancelled, so you know which settlement gaps are expected.
Monitor paid vs. due orders
Filter your dashboard to isolate orders that haven't been settled yet, instead of scanning entire reports manually.
Filter by marketplace, status, and date
Narrow down a specific settlement cycle or marketplace when you're trying to trace a discrepancy.
Search by Order ID or AWB number
Quickly pull up a flagged order instead of digging through a spreadsheet.
Export filtered data to CSV
Take a cleaned, filtered view of your data into your accounting workflow for final reconciliation.
Manage multiple firms separately
If you run more than one business or GST entity, keep reconciliation records completely separate for each one.
Best Practices to Avoid Reconciliation Errors
A few habits separate sellers who catch discrepancies early from those who discover them months later, when it's much harder to dispute anything.
Reconcile every settlement cycle, not just monthly
Marketplaces often settle weekly or biweekly. Waiting for a monthly summary means smaller cycle-level errors get buried in bigger numbers.
Don't ignore small recurring gaps
A ₹200–500 gap might seem too small to chase once, but if it repeats every cycle across hundreds of orders, it adds up to a meaningful loss over a year.
Update return and RTO status before reconciling
If your order statuses aren't current, you'll end up flagging orders as "missing payment" when they're actually pending returns that haven't settled yet.
Keep firm-wise records separate
Sellers running multiple businesses or GST registrations should reconcile each firm independently. Mixing them together makes it far harder to spot which business has the discrepancy.
Common mistakes to avoid
- Comparing gross sales directly to net settlement without subtracting fees and taxes first
- Ignoring TCS/TDS deductions and assuming they're missing money
- Reconciling before return/RTO statuses have been updated, which creates false flags
- Treating every unexplained gap the same way, instead of separating small rounding differences from genuine issues worth escalating
Conclusion
A marketplace sales and settlement amount mismatch is rarely a mystery once you break it down. Commission, shipping fees, TCS/TDS, returns, and timing differences explain most of the gap between what a marketplace reports as sales and what actually lands in your account. The real risk isn't the mismatch itself - it's not reconciling consistently enough to tell a normal deduction apart from a genuine loss.
Building a simple, repeatable reconciliation process each settlement cycle, and keeping your order and return statuses updated, is what protects your revenue over time.
TrackMyOrders helps e-commerce sellers organize marketplace orders, monitor returns, and reconcile payments from one dashboard. Start managing your orders with better visibility.