To find short-paid orders, export your order report and settlement report for the same period, join them on order ID, and calculate the expected payout from your agreed commission, fee and shipping terms. Any order where the actual payout is lower than expected is a candidate. Then check the cause, such as fee, weight slab, return or missing credit, and raise a claim with evidence.
What short-paid actually means
A short-paid order is one where the amount credited to you is lower than what your agreed terms say it should be. It is rarely a missing payout of the full order. More often it is a small gap on a single line item, repeated across many orders.
- Fee errors: commission or fixed fee charged on the wrong category or price band.
- Shipping and weight charges: a heavier weight slab applied than your product actually falls in.
- Return mismatches: a return or cancellation reversed, but the original charges not credited back.
- Missing orders: delivered orders that never appear in any settlement.
- Unexplained deductions: penalties or adjustments with no matching reason in your terms.
Gather the right data first
You need three sets of data for the same period before you compare anything.
- Your order data: order ID, SKU, selling price, order status and delivery or return date from your own system or the marketplace order report.
- The settlement or payment report: download it from Amazon Seller Central or Flipkart Seller Hub. Report names and layouts change, so confirm the current names in the seller help section.
- Your commercial terms: the seller agreement, the current rate card and any category-specific or campaign-specific fee notices.
Do not rely on memory for fee rates. Take them from your agreement and rate card, and confirm the latest version with your account manager, because marketplaces revise fees and the effective date matters when you test older orders.
Step-by-step: compare expected and actual payouts
Do this in a spreadsheet or a reconciliation tool. The logic is the same either way.
- Join on order ID. If your settlement uses order item IDs, join at that level so multi-item orders do not blur together.
- Separate the lines. Split each settlement row into sale amount, commission, fixed or closing fee, shipping or weight fee, tax-related lines, refunds and other adjustments.
- Calculate expected values. Apply your agreed terms to each order to get the expected fee on each line and the expected net payout.
- Compute the variance. Actual payout minus expected payout, per order and per line.
- Filter and group. Sort by variance, then group by cause: fee line, SKU, category or date.
| Check | What to compare | Where the data sits |
|---|---|---|
| Commission | Charged vs rate card for that category and price | Settlement report, rate card |
| Shipping or weight fee | Slab charged vs your product weight and dimensions | Settlement report, product master |
| Returns | Refund line vs fee reversal line | Return report, settlement report |
| Missing orders | Delivered orders with no settlement row | Order report vs settlement report |
Where short payments usually come from
Once you have a variance list, patterns matter more than individual orders. Look for these first.
- Repeated SKU variances. If one SKU is always off, the marketplace may hold wrong weight, dimension or category data for it. Fixing the catalogue record can stop future losses.
- Return-related gaps. Check whether returned orders show both the refund and the matching reversal of fees, as your terms provide. Return rules differ by marketplace and by category, so read your agreement.
- Timing differences. Some gaps are not errors, just orders that will settle in the next cycle. Mark them pending and re-check rather than claiming immediately.
- Tax-related lines. TCS, TDS and GST lines affect net payout but follow statutory rules. Do not treat them as short payments without confirming the current rates and treatment with your tax adviser.
Raise the claim with evidence
A claim succeeds when the marketplace can verify it quickly. For each case, prepare:
- Order ID, order date, delivery or return date.
- The settlement reference and the exact line that is wrong.
- The clause or rate card entry that supports your expected amount.
- Product data such as weight and dimensions, where a shipping fee is disputed.
- A clear statement of the amount you expect to be corrected.
Check your seller agreement and help documentation for the dispute window and the correct channel, whether a support case or your account manager. Raise claims promptly, since old orders may fall outside the window. Group similar cases into one ticket with an annexure and keep a log of case ID, date, status and amount recovered.
Make it a monthly routine
Checking once finds past losses. Checking every settlement cycle stops them recurring. Fix a cadence, keep your fee terms in a single versioned sheet, and track open claims until they are credited or closed.
If you sell across several marketplaces, a tool helps. MarketplaceMetrics by Fundle reconciles sales and settlements, checks fees against agreed terms and tracks returns and recovery cases. Myntra Excel reports are reviewed today, and Amazon and Flipkart coverage is a scope discussion, so confirm what is supported for your setup.
Worked example
Illustrative example only. The rates and amounts below are made up to show the method and are not actual marketplace fees.
| Line | Expected (per your terms) | Actual (settlement) |
|---|---|---|
| Selling price | ₹1,000 | ₹1,000 |
| Commission (assumed 10%) | ₹100 | ₹100 |
| Fixed fee | ₹20 | ₹20 |
| Shipping fee | ₹60 | ₹90 |
| Net payout (taxes ignored) | ₹820 | ₹790 |
The variance is ₹30, and it sits wholly in the shipping line, which points to a higher weight slab than the product warrants. If the same SKU shows this on 200 orders, the illustrative shortfall is ₹6,000. That is worth one consolidated claim with the product weight proof attached.
Questions and answers
How often should I check settlements for short payments?
Check every settlement cycle if you can, or at least monthly. Frequent checks keep orders within the dispute window in your seller agreement and help you spot recurring errors, such as a wrong weight slab, before they multiply.
Can I find short-paid orders using only the settlement report?
Not reliably. The settlement report shows what was paid, but not what should have been paid. You also need your order data and your agreed fee terms to calculate expected payouts and identify missing orders.
Are all payout differences errors by the marketplace?
No. Some are timing differences, where an order settles in a later cycle, and some are valid deductions such as returns or statutory tax lines. Classify each variance by cause before claiming, and confirm tax treatment with your tax adviser.
Where do I find the correct fee rates to compare against?
Use your signed seller agreement, the current rate card and any fee notices from the marketplace. Rates change and can vary by category and price band, so confirm the latest applicable terms rather than relying on old figures.