Marketplace Reconciliation: Track Every Rupee from Amazon, Flipkart & More

If you sell on Amazon, Flipkart, Meesho, or any other e-commerce marketplace in India, money flows through a long and opaque chain before it reaches your bank account. Orders, shipping, returns, fees, commissions, and settlements — each step can introduce discrepancies. Marketplace reconciliation is the process of verifying that you received every rupee you were owed. This guide covers the complete process.

What Is Marketplace Reconciliation?

Marketplace reconciliation is the process of matching your order data, marketplace settlement reports, and bank credits to ensure that the amount you receive for each order is correct after accounting for all fees and deductions.

Unlike traditional B2B sales where you issue an invoice and receive a payment, marketplace sales involve the platform as an intermediary. The platform collects payment from the customer, deducts its fees (commission, shipping, closing fees, etc.), and remits the balance to you in periodic settlements — typically every 7-14 days.

The challenge: you're trusting the marketplace to calculate deductions correctly across thousands of orders. Without reconciliation, overcharges and errors go undetected.

The Settlement Flow

Understanding the settlement lifecycle is essential for effective reconciliation. Here's how money flows from a customer's payment to your bank:

• •Order placed: Customer pays the marketplace. For prepaid orders, the marketplace holds the funds. For COD orders, the delivery partner collects cash.
• •Order shipped: The marketplace registers shipment against the order. Shipping fee is calculated based on weight, distance, and delivery partner.
• •Order delivered: Delivery confirmation triggers the settlement clock. The settlement cycle (typically 7 days for Amazon, 7-10 days for Flipkart) begins.
• •Return window: After delivery, the customer has a return window (usually 7-10 days depending on category). If a return is initiated, the settlement for that order is held.
• •Settlement calculation: The marketplace calculates your payout — selling price minus referral fee minus closing fee minus shipping fee minus any other applicable deductions (advertising, damage, etc.).
• •Settlement to bank: The net amount is transferred to your registered bank account via NEFT. Multiple orders are batched into a single settlement.
• •Bank credit: The settlement amount appears in your bank statement, usually with a reference number linking to the settlement report.

Why Reconciliation Is Critical for Sellers

Money can be lost at every stage of the settlement flow:

• •Commission applied at a higher rate than your category warrants
• •Shipping fees calculated on volumetric weight when actual weight is lower
• •Returns processed after the return window but deductions still made
• •COD orders delivered but settlement delayed indefinitely
• •Damaged/lost inventory claims not reimbursed by the marketplace
• •Advertising fees deducted without corresponding ad performance data
• •GST on commission calculated incorrectly

Each of these is an individual discrepancy. But across hundreds or thousands of orders per month, the cumulative impact on margins can be significant. Sellers who don't reconcile are effectively accepting the marketplace's calculations on faith.

Amazon Settlement Reconciliation

Amazon India (Amazon.in) provides detailed settlement reports through Seller Central. Here's what you need to know:

Fee Types

• •Referral Fee: A percentage of the selling price (varies by category — typically 5% to 17%). This is the primary commission.
• •Closing Fee: A fixed fee per item (varies by price range and category, e.g., ₹5-₹30 per unit for most categories).
• •FBA Fees (if using Fulfillment by Amazon): Storage fees (per cubic foot per month), pick-and-pack fees (per unit), and weight handling fees. These vary by product size tier.
• •Shipping Fee: For non-FBA orders, the shipping fee depends on delivery zone, weight, and whether it's local, regional, or national delivery.
• •Advertising Fees: If you run Sponsored Products or other ads, these are deducted from settlements.
• •Return Processing Fee: Applied when a customer returns an item. Varies by category.

How to Download Reports

In Seller Central, go to Reports > Payments > Date Range Reports. Download the settlement report for the period you want to reconcile. Also download the Order Report from Reports > Business Reports for the same period. You'll need both to match orders against settlement line items.

What to Match

For each order in the settlement report, verify: the selling price matches your listing price, the referral fee percentage matches your category's rate card, the closing fee matches the applicable slab, shipping fee is consistent with the weight and zone, and the net amount (selling price minus all deductions) is correct. Any deviation is a discrepancy to investigate.

Flipkart Settlement Reconciliation

Flipkart's settlement structure is similar to Amazon's but with some differences:

Fee Structure

• •Commission Fee: Percentage of selling price, varies by category (6% to 20% for most categories). Includes a marketplace fee component.
• •Shipping Fee: Based on weight, zone, and shipping method. Flipkart's logistics arm (Ekart) handles most deliveries.
• •Collection Fee: Charged for COD orders — typically 1-2% of the order value. This covers the cost of cash collection and remittance.
• •Fixed Fee: A per-unit fixed fee similar to Amazon's closing fee.
• •Return Charges: Processing fee for returned items, varies by reason and category.

Payment Cycles

Flipkart typically settles every 7-15 business days after delivery confirmation. The settlement cycle can be longer for new sellers. Settlements are made via NEFT to your registered bank account. The settlement frequency and cycle can vary — verify your specific terms in the Flipkart Seller Dashboard.

Report Formats

Flipkart provides settlement reports through the Seller Dashboard under Finance > Settlements. Download the detailed order-level report for reconciliation. Flipkart also provides a Fee Summary report that shows aggregate fees by type — useful for a quick sanity check before diving into order-level details.

Common Discrepancies

Commission Overcharges

The most common discrepancy. A product listed in 'Home & Kitchen' at 12% commission might get charged at 15% if the marketplace's category mapping differs from your expectation. Rate card changes that aren't communicated clearly also cause overcharges.

Wrong Category Fee Application

If your product is mapped to an incorrect category, every order incurs the wrong commission rate. This can happen during listing creation or when the marketplace reclassifies products. Check the category mapping in your seller dashboard periodically.

Return Deduction Errors

Returns processed outside the return window, returns where the customer received a refund but the item was returned in used/damaged condition, or reverse logistics charges applied when the return was marketplace's fault. Each of these should be flagged and disputed.

Shipping Fee Mismatches

The shipping fee should be based on actual weight or dimensional weight, whichever is higher. If the marketplace uses incorrect weight data, you're overcharged on shipping for every order. Compare the weight in the shipping fee calculation against your actual product weight.

Delayed COD Remittance

For Cash on Delivery orders, the marketplace collects cash from the customer and should remit it in the next settlement cycle. Delays in COD remittance affect your cash flow directly. Track COD orders separately and verify they appear in settlements within the expected timeframe.

How to Detect Commission Overcharges

Detecting overcharges requires a systematic comparison of expected fees against actual deductions:

• •Step 1: Download the marketplace's current rate card for your categories. Save it — rate cards change, and you need the version that was active when the order was placed.
• •Step 2: For each order in the settlement report, calculate the expected referral fee based on the selling price and category rate.
• •Step 3: Compare expected fee vs actual deducted fee. Any difference beyond ₹1 (rounding tolerance) is a potential overcharge.
• •Step 4: Aggregate overcharges by category and time period. Patterns often emerge — a specific category consistently overcharged, or overcharges starting from a specific date (indicating a rate change you weren't aware of).
• •Step 5: File a dispute with the marketplace support team. Include order IDs, expected amounts, actual amounts, and the rate card reference.

Stuck Orders: Detection and Escalation

Stuck orders are orders that don't progress through the expected lifecycle. They're a hidden cash flow problem:

• •Shipped but never delivered: Order was shipped weeks ago but tracking shows no delivery update. The shipment may be lost.
• •Delivered but no settlement: Order shows as delivered but hasn't appeared in any settlement report past the expected settlement date.
• •Return initiated but never completed: Customer initiated a return, pickup was scheduled, but the item was never collected. The settlement for this order remains on hold.
• •Claim filed but not resolved: You filed a reimbursement claim for a lost/damaged shipment, but it's been pending for weeks.

Detection requires tracking each order's lifecycle and flagging orders that haven't progressed within expected SLAs: shipment to delivery (7 days for most zones), delivery to settlement (7-14 days), return pickup to refund processing (7 days). Orders exceeding these SLAs need investigation through the seller support channel.

Reconciling Settlements with Bank Statements

The final step in marketplace reconciliation is matching settlement amounts to actual bank credits:

• •Each marketplace settlement has a unique settlement ID and a total amount.
• •The settlement is credited to your bank via NEFT, usually with a reference that includes the settlement ID or the marketplace's entity name.
• •Match each settlement report's total amount to the corresponding bank credit. The amounts should match exactly — any difference indicates a bank processing error or a revised settlement.
• •If you sell on multiple marketplaces, settlements from Amazon, Flipkart, and others land in the same bank account. Tag each bank credit to its source marketplace for clean accounting.

This bank-level matching is important because it confirms the money actually arrived. A settlement report shows what the marketplace intends to pay — the bank credit confirms they actually did.

Multi-Marketplace Accounting

Sellers operating on Amazon, Flipkart, Meesho, their own Shopify/WooCommerce site, and potentially offline channels face a consolidation challenge:

• •Revenue recognition: Each marketplace has a different settlement cycle. Your accounting should recognize revenue at the point of sale (or shipment/delivery based on your policy), not at settlement.
• •GST treatment: You're the seller, and GST is on the selling price, not the settlement amount. TCS (Tax Collected at Source) at 1% is deducted by the marketplace and must be tracked for claiming credit.
• •Fee accounting: Marketplace fees are your expenses. Track them separately by marketplace and fee type for margin analysis.
• •Inventory: If you're using FBA (Fulfilled by Amazon) or Flipkart's warehouse, inventory is split across locations. Your stock records must reflect this.
• •Returns: Each marketplace has different return policies and processing times. Track returns by marketplace to understand true return rates per channel.

A unified view across all channels — what ReckOps provides — is essential for understanding true profitability per marketplace. Without it, you might be selling profitably on one platform and at a loss on another without knowing it.

Best Practices for E-commerce Sellers

• •Reconcile weekly, not monthly: Marketplace settlement cycles are continuous. Waiting for month-end creates a backlog that's hard to clear. Set aside time every week to match settlements.
• •Track fee changes proactively: Subscribe to marketplace seller communications. When fee structures change, update your expected-rate calculations immediately.
• •Maintain a dispute log: When you find a discrepancy and file a dispute, log the order ID, discrepancy type, amount, date filed, and resolution status. This helps track recovery and identify recurring issues.
• •Separate bank accounts: Consider using a dedicated bank account for marketplace settlements. This simplifies reconciliation because every credit in that account is a marketplace settlement.
• •Monitor stuck orders daily: Orders stuck in transit or pending settlement are cash flow tied up. A daily review of order lifecycle exceptions prevents buildup.
• •Calculate true margins per SKU per marketplace: After accounting for all marketplace fees, shipping, returns, and advertising spend, know your actual margin on each product on each platform. This informs pricing and channel strategy.

Frequently Asked Questions

How do I handle marketplace TCS in my GST returns?

Marketplaces deduct TCS (Tax Collected at Source) at 1% (0.5% CGST + 0.5% SGST for intra-state, or 1% IGST for inter-state) on net taxable supplies. This TCS is reflected in your GSTR-2A. You claim credit for TCS in your electronic cash ledger via GSTR-3B. It reduces your net GST liability. If TCS exceeds your liability, you can claim a refund.

What if a settlement amount doesn't match my calculation?

First, verify your calculation — check for rate changes, additional fees (advertising, penalties), or return adjustments included in the settlement. If the discrepancy persists after verification, download the order-level breakdown from the marketplace's finance section and compare line by line. File a ticket with seller support for unexplained differences.

How long should I keep marketplace reports?

Maintain settlement reports, order reports, and reconciliation records for at least 6 years — this aligns with GST audit and income tax record-keeping requirements. Store them digitally in an organized structure (by marketplace, by month) for easy retrieval.

Can I automate marketplace reconciliation?

Yes. Tools that connect to marketplace APIs (Amazon SP-API, Flipkart Seller API) can pull order data, settlement reports, and fee details automatically. They match settlements against expected payouts, flag discrepancies, and track stuck orders without manual report downloading. The time savings are significant for sellers processing over 500 orders per month.

How do I handle marketplace returns in my accounting?

When a return is processed: reverse the revenue for that order, reverse the cost of goods sold (if the returned item is restockable), and account for any return shipping or restocking fees charged by the marketplace. The net impact appears in the settlement where the return was processed, often as a negative line item.