What is Payment Reconciliation for E-Commerce? A Beginner's Guide

If you sell products on online marketplaces like Amazon, Flipkart, or Meesho, you have probably noticed that the amount deposited in your bank account rarely matches your total sales. The difference is caused by a maze of fees, commissions, deductions, refunds, and adjustments that marketplaces apply before settling your payments. Payment reconciliation is the process of matching these marketplace settlements against your actual order data to ensure you have been paid correctly. For e-commerce sellers, it is not just an accounting exercise — it is how you protect your revenue. This beginner-friendly guide explains everything you need to know about payment reconciliation and why it should be a core part of your business operations.

What Exactly is Payment Reconciliation?

Payment reconciliation is the process of comparing two sets of financial records to ensure they agree. In e-commerce, this typically means comparing the payments you receive from marketplaces (your settlement reports) against the orders you fulfilled. The goal is to verify that every order has been settled correctly — with the right fees deducted, correct refund amounts processed, and no missing transactions. When discrepancies are found, they are investigated and resolved, either by filing claims with the marketplace or correcting internal records.

Why Do Marketplace Payments Not Match Your Sales?

There are several reasons why your marketplace payments differ from your gross sales figures. First, marketplaces deduct various fees — referral commissions, fulfilment charges, closing fees, and shipping costs. Second, refunds for returned or cancelled orders are deducted from future settlements. Third, TCS (Tax Collected at Source) is withheld under GST regulations. Fourth, marketplaces maintain reserve amounts as a buffer against potential chargebacks. And finally, there are occasional system errors — incorrect fee calculations, missing orders in settlements, or duplicate deductions — that only surface through careful reconciliation.

Common Types of Payment Discrepancies

The most common discrepancies that sellers encounter include: orders delivered but not included in settlements (missing transactions), fee overcharges where the deducted commission or shipping fee exceeds the published rate, refunds processed for items that were not actually returned by the customer, double deductions on the same order, and settlement amounts that do not match the expected calculation when you add up product price minus all applicable fees.

Each of these discrepancies represents money that belongs to you but is not reaching your bank account. For sellers doing hundreds or thousands of orders per month, even a small per-order discrepancy adds up to a substantial amount over time.

Manual vs Automated Reconciliation

Manual reconciliation involves downloading settlement reports and order data from each marketplace, importing them into spreadsheets, and matching records line by line. While this approach works for very small sellers, it becomes impractical beyond a few hundred orders per month. The process is time-consuming, error-prone, and requires significant accounting knowledge. Most importantly, manual reconciliation is always retrospective — you are looking at last month's data, which means discrepancies may have already passed the claim filing window.

Automated reconciliation tools like eVanik's Payment Reconciliation pull data directly from marketplace APIs, perform matching in real time, and flag discrepancies as they occur. The Reconciliation Summary dashboard gives you an instant overview of your reconciliation status across all channels, making it easy to spot and resolve issues quickly.

Getting Started with Reconciliation

If you are new to payment reconciliation, start by downloading your latest settlement report and comparing the total against your expected payout (sum of order values minus published fee rates). If there is a gap, you have found your first discrepancy. As you scale, consider moving to automated tools that handle multi-marketplace reconciliation, track discrepancies over time, and generate reports for your accounting team. The key is to make reconciliation a regular habit rather than an annual exercise — the sooner you catch discrepancies, the easier they are to resolve.