eCommerce Payment Reconciliation: The Complete Guide for Marketplace Sellers
A brand never receives what a marketplace order was worth, and a meaningful share of the deductions in between are wrong. This guide explains what reconciliation is, why settlements leak, every deduction you should be checking, how the process works end to end, and how to run it at scale in India and the US.
eCommerce payment reconciliation is the process of matching every order a brand sells on a marketplace or channel against the payment it actually receives, after all deductions, to confirm the brand was paid correctly. It identifies short payments, incorrect fees, and missing refunds, and turns them into claims that recover the money. It is the financial control that sits between selling and getting paid, and it matters because sellers lose an estimated 2 to 3 percent of gross payment volume to fee and settlement errors.
From order value to bank balance, every deduction and how to check it
- What eCommerce payment reconciliation is, and what it is not
- Why marketplace settlements leak, and the 2 to 3 percent of gross payment volume it costs sellers
- Every deduction on a settlement, from commission and shipping to TCS and return reversals
- The reconciliation process end to end, and why classifying root cause is the step brands skip
- The metrics that prove reconciliation is working, led by leakage as a share of GMV
- How to run it at scale, whether you sell on Amazon and Flipkart in India or Amazon and Walmart in the US
Foundations: why marketplace payouts never match
When a brand sells on a marketplace, it never receives what the order was worth. Between the sale price and the money that lands in the bank sits a stack of deductions, commission, shipping, taxes withheld, return adjustments, penalties, advertising, and the marketplace calculates every one of them. Most of the time those calculations are correct. A meaningful share of the time they are not, and the difference is money the brand is owed but never sees.
The scale of that gap is larger than most founders assume. eCommerce sellers lose an estimated 2 to 3 percent of gross payment volume to fee and settlement errors, and around 70 percent of sellers are affected (industry analysis, 2025). For a brand doing Rs 5 crore in monthly GMV, that is Rs 10 to 15 lakh a year in deductions that were wrong and never challenged. On the thin margins that marketplace selling runs on, incorrect shipping-fee deductions alone can consume 15 to 25 percent of profit.
Reconciliation proves order value and settlement agree line by line, because the party taking the deductions is also the party reporting them.
What is eCommerce payment reconciliation?
In brief: eCommerce payment reconciliation is the process of matching every order a brand sells on a marketplace or channel against the payment it actually receives, after all deductions, to confirm the brand was paid correctly. It identifies short payments, incorrect fees, and missing refunds, and turns them into claims that recover the money. It is the financial control that sits between selling and getting paid.
Selling generates an order value. Getting paid produces a settlement, the marketplace's record of what it is paying you after it has subtracted its charges. Reconciliation is the act of proving those two agree, order by order, and investigating every case where they do not. Without it, a brand simply trusts that the marketplace has calculated commission, shipping, taxes, and return reversals correctly on every one of thousands of transactions, which the data says is not a safe assumption.
It is worth being precise about what reconciliation is not. It is not the same as accounting, though it feeds accounting. It is not just checking that a payout arrived, it is checking that the payout was the right amount. And it is not a once-a-quarter clean-up, it is a control run every settlement cycle, because marketplace claim windows are short and a deduction not challenged in time is money permanently lost.
Why marketplace payments never match what you expected
In brief: Marketplace settlements leak because the marketplace calculates every deduction, across many fee types, on every order, and errors are routine: commission charged at the wrong category rate, shipping billed on inflated volumetric weight, fees not reversed when an order is returned. At a handful of orders these are visible. At thousands a month across several marketplaces, they disappear into the totals.
The structural issue is that the party taking the deductions is also the party reporting them. A marketplace commission varies by product category, shipping is billed by weight slab, taxes are withheld at statutory rates, and fees are supposed to reverse when an order is returned or cancelled. Each of those is a calculation, and each calculation is a place an error can enter, usually in the marketplace's favour and rarely in yours.
The most common sources are consistent and well documented: commission charged on the wrong category, volumetric-weight overcharges on shipping, and incomplete fee reversals on returned orders (industry analysis, 2025). None of these are dramatic. Each is a few rupees or a few percent on an individual order. That is exactly why they survive, because no one is checking at the line level, and in aggregate they add up to the 2 to 3 percent of gross payment volume that leaks.
How much money leaks, and where
In brief: Around 70 percent of sellers lose revenue to incorrect deductions, typically 2 to 3 percent of gross payment volume, and shipping-fee errors alone can take 15 to 25 percent of profit. The leak concentrates in a handful of deduction types, which is what makes it recoverable once you know where to look.
The leakage is not random noise spread thinly across every line. It clusters in specific, checkable places, which is the good news, because a concentrated problem is a solvable one. The table below maps where the money most often goes.
| Leak source | What goes wrong | Why it is missed |
|---|---|---|
| Commission / category | Charged at a higher-category rate than the product warrants | Rates vary by category; errors look plausible |
| Shipping / logistics | Billed on inflated volumetric weight or the wrong slab | Weight slabs are opaque and rarely audited |
| Return and RTO reversals | Fees not fully reversed when an order comes back | Returns are high-volume and reconciled last |
| Penalties and SLA charges | Applied for breaches that did not occur or were not the seller's fault | Buried in settlement detail, rarely contested |
| Advertising and promotions | Charged beyond the agreed spend or misattributed | Ad billing sits apart from order settlements |
| Tax withholding (TCS/GST) | Withheld but not matched to filings, so credit is lost | Tax and settlement are reconciled separately, if at all |
Read together, these show why reconciliation pays for itself. The amounts are recoverable, the error types are known, and the only thing standing between a brand and the money is the discipline, or the software, to check every settlement at the line level and file the claims in time.
Order-to-Cash Process: All 8 Steps Explained (O2C)
The full path from order to money in the bank, and where reconciliation sits in it.
The Ecommerce Inventory Glossary: 60 Terms Defined
GMV, RTO, SKU and the rest of the vocabulary that settlement reports assume you know.
The structural issue is that the party taking the deductions is also the party reporting them.
Sellers lose an estimated 2 to 3 percent of gross payment volume to fee and settlement errors, and around 70 percent of sellers are affected. For a brand doing Rs 5 crore in monthly GMV, that is Rs 10 to 15 lakh a year in deductions that were wrong and never challenged.
The anatomy of a settlement and the types of reconciliation
Every payout a brand receives is a net figure. To reconcile it, you have to be able to rebuild it from the gross order value down, deduction by deduction. These are the components you will find on an Indian marketplace settlement, most of which have direct US equivalents.
You cannot catch an incorrect deduction you do not understand, and reconciliation is several checks, not one.
The anatomy of a marketplace settlement: every deduction explained
In brief: A marketplace settlement subtracts commission, shipping and logistics, payment and collection fees, taxes withheld, return and RTO adjustments, penalties, advertising, and fulfilment or storage fees before it pays out. Knowing what each one should be is the foundation of reconciliation, because you cannot catch an incorrect deduction you do not understand.
| Deduction | What it is | Where it goes wrong |
|---|---|---|
| Commission (referral fee) | The marketplace's revenue share, set by product category | Category misclassification charges a higher rate |
| Shipping / logistics fee | Weight-based fulfilment and delivery charge | Volumetric-weight overcharge or wrong weight slab |
| Payment / collection fee | Charge to collect and remit the customer's payment | Applied twice or at the wrong rate |
| TCS (India) | 1 percent tax collected at source under GST Section 52 | Not matched to GST returns, so input credit is lost |
| GST / sales tax | Tax on the transaction | Incorrect interstate or category treatment |
| Return / RTO adjustment | Reversal of fees for returned or undelivered orders | Fees only partly reversed, or not at all |
| Penalties / SLA | Charges for late dispatch or cancellation | Applied wrongly and left uncontested |
| Advertising / promotions | Sponsored ads, deal, and coupon costs | Billed beyond the agreed amount or misattributed |
| Fulfilment / storage fees | Pick-pack, storage, and long-term fees where the marketplace fulfils | Dimension and aged-inventory errors |
For Indian sellers, four of these appear on almost every Flipkart or Amazon settlement, commission, shipping, TCS, and return adjustments, and they are where most reconciliation work concentrates. US sellers face a close parallel, with Amazon fulfilment and storage fees, chargebacks, and state sales tax in place of TCS. The mechanics differ by market; the discipline of rebuilding the payout and checking every line is identical.
The types of eCommerce reconciliation
In brief: Reconciliation is not one check but several: payment or settlement reconciliation matches orders to payouts, fee reconciliation checks charges against what was contracted, returns reconciliation confirms fees are reversed, tax reconciliation matches TCS and GST to filings, and inventory-to-settlement reconciliation confirms every unit shipped was actually paid for.
- Payment or settlement reconciliation. The core check: every order matched to the settlement line that paid for it, confirming the payout arrived and was the correct amount after deductions.
- Fee and commission reconciliation. Each charged fee compared against the contracted rate for that product and category, to catch overcharges and misclassifications.
- Returns reconciliation. Confirmation that when an order is returned or fails delivery, the associated fees are reversed and any refund is correct. This is the highest-volume and most error-prone area in India.
- Tax reconciliation. Matching TCS and GST withheld by the marketplace to the brand's own filings, so statutory credits are claimed and nothing is paid twice.
- Inventory-to-settlement reconciliation. Confirming that every unit dispatched was ultimately paid for, catching orders that shipped but never settled, a leak that pure inventory tools cannot see.
A brand that runs only the first of these, checking that payouts arrived, is doing a fraction of the job. The money most often hides in the others: in returns that were not fully reversed, fees that were misclassified, and taxes that were withheld but never reclaimed.
Returns Management for Ecommerce: The 2026 Playbook
Returns and RTO end to end, the highest-volume and most error-prone reconciliation area in India.
Warehouse Video Management System: packing video and disputes
Packing video as evidence when contesting return claims, penalties and marketplace disputes.
Ecommerce Fulfilment: Models, Costs and How to Choose
What marketplace and 3PL fulfilment actually costs, and the fees that land on your settlement.
A brand that runs only the first of these, checking that payouts arrived, is doing a fraction of the job.
The reconciliation process, and why manual breaks at scale
eCommerce payment reconciliation is how brands close that gap: matching every order sold to the payment actually received, catching the deductions that should not have been made, and recovering the money.
Reconciliation is a seven-step cycle repeated every settlement period; spreadsheets hold at a few hundred orders and collapse at a few thousand, which is where automation takes over.
The reconciliation process, step by step
In brief: Reconciliation runs as a repeatable cycle: collect settlement reports from every channel, match each order to its settlement line and your own records, identify and classify discrepancies, flag recoverable amounts, file claims within the marketplace window, and post the reconciled figures to accounting with tax credits captured. It repeats every settlement period.
- Collect the settlement and payment reports from every marketplace, channel, and payment gateway for the period.
- Match each order to its settlement line, and to your own order, shipping, and returns records, at the line level rather than the summary.
- Identify discrepancies: unpaid orders, short payments, incorrect fees, penalties, and missing or partial return reversals.
- Classify each discrepancy by deduction type and root cause, so recurring errors can be fixed at source, not just recovered once.
- Flag the recoverable amounts and file claims with the marketplace within its claim window, which is often short and unforgiving.
- Post the reconciled figures to accounting, capturing TCS and GST for filing so statutory credits are not lost.
- Track recovery, measure the leak, and repeat the cycle every settlement period.
The step brands most often skip is the fourth, classifying root cause. Recovering a wrong deduction once is useful; identifying that a whole product category is being misclassified, and fixing the listing so the error stops recurring, is where reconciliation shifts from clawing money back to preventing the loss.
Why manual reconciliation breaks at scale
In brief: Manual, spreadsheet-based reconciliation works at a few hundred orders and collapses at a few thousand across several marketplaces. Returns are the breaking point: a large share of return-related refunds require manual verification, and claim windows pass before an overstretched finance team can work through the backlog.
At low volume, a founder can open the settlement report, scan for anything odd, and file the occasional claim. That approach has a hard ceiling. As order volume rises and the brand adds marketplaces, each with its own report format, fee structure, and claim window, the number of lines to check outgrows the hours available to check them. On Flipkart alone, a large share of return-related refunds require manual verification (industry analysis, 2025), and returns are the highest-volume category of all.
The failure is quiet, which is what makes it dangerous. Nothing breaks visibly; the payouts still arrive, the business still runs. What happens is that the checking simply stops keeping pace, claim windows lapse, and the 2 to 3 percent leak becomes an accepted, invisible cost of doing business. By the time a brand notices, it is not recovering a month of deductions, it is writing off a year of them.
Automated reconciliation and reconciliation software
In brief: Automated payment reconciliation software matches orders to settlements at the line level, validates every deduction against expected rates, flags only the exceptions for review, and supports claims, cutting reconciliation time by around 60 percent. It turns reconciliation from a manual backlog into a routine, exception-based control that keeps pace with volume.
Automation changes the economics of reconciliation because it inverts the work. Instead of a person checking every line to find the few that are wrong, the system checks every line automatically and surfaces only the exceptions, the short payments, incorrect fees, and missing reversals, for a human to act on. Automating the match reduces reconciliation processing time by roughly 60 percent (industry analysis, 2025), and, more importantly, it means nothing goes unchecked simply because the team ran out of hours.
A capable reconciliation system does four things: it ingests settlement data from every marketplace and gateway, it rebuilds and validates each payout against the expected commission, shipping, tax, and return treatment, it flags recoverable discrepancies and supports filing claims within the window, and it posts clean, reconciled figures to accounting. The last point matters more than it appears: reconciliation that does not connect to the books leaves the finance team doing the join by hand, which reopens the gap it was meant to close.
Order Management Process: Stages, Owners and Handoffs
The order records reconciliation matches settlements against, stage by stage.
Supply Chain Management in eCommerce: The Complete Guide
Where the money flow sits inside the wider ecommerce operation, from sourcing to settlement.
By the time a brand notices, it is not recovering a month of deductions, it is writing off a year of them.
Recovering a wrong deduction once is useful; identifying that a whole product category is being misclassified, and fixing the listing so the error stops recurring, is where reconciliation shifts from clawing money back to preventing the loss.
Closing the loop with accounting, and the metrics that prove it
For Indian sellers this is not optional housekeeping. Marketplaces withhold TCS at 1 percent under GST Section 52 and report it, and the brand must reconcile that against its own GST returns to claim the credit. A settlement that is reconciled for fees but not tied to tax filings still loses money, just in a different column. The same logic applies to revenue: the figure that belongs in the books is the reconciled net, not the gross order value or the raw payout.
Reconciliation is only complete when it flows into the books with tax captured, and leakage as a share of GMV is the number to watch.
Closing the loop: reconciliation, accounting, and tax
In brief: Reconciliation is only complete when its output flows into the books. Reconciled settlements feed accurate revenue recognition, and TCS and GST withheld by marketplaces have to be matched to filings so the brand claims its statutory credits. Reconciliation that stops before accounting leaves money on the table twice: in unrecovered deductions and in unclaimed tax credits.
This is why the strongest setups treat reconciliation and accounting as one connected process rather than two. When every reconciled settlement posts automatically, with tax captured, the month-end close is faster, the numbers are defensible, and the brand sees its true, net-of-everything margin per marketplace, which is the number that should drive channel decisions in the first place.
The metrics that prove reconciliation is working
In brief: Track reconciliation accuracy, unreconciled rate, leakage as a percentage of GMV, claim recovery rate, days to reconcile, and settlement-to-books variance. Together they show how much is leaking, how much is being recovered, and how quickly, which is what turns reconciliation from a chore into a measurable margin lever.
| Metric | How it is calculated | What it tells you |
|---|---|---|
| Reconciliation accuracy | Transactions reconciled correctly / total transactions | How much of settlements is verified, not assumed |
| Unreconciled rate | Unmatched or disputed lines / total lines | The size of the open problem |
| Leakage rate | Unrecovered incorrect deductions / GMV | The money still being lost, as a share of sales |
| Claim recovery rate | Amount recovered / amount claimed | How effective the claims process is |
| Days to reconcile | Cycle time to close a settlement period | Whether you can act inside claim windows |
| Settlement-to-books variance | Difference between reconciled payout and recorded revenue | Whether the books reflect reality |
The headline number to watch is leakage as a percentage of GMV. Benchmarked against the 2 to 3 percent that sellers typically lose, it tells a brand exactly how much of its own money is still on the table, and every tenth of a percent recovered flows straight to the bottom line.
Inventory Shrinkage: Formula, Causes and How to Stop It
The stock-side leak that pairs with settlement leakage: measuring loss as a rate and closing it.
Cycle Counting: Methods, Frequency and How to Start
A repeatable control cycle for inventory, the same discipline reconciliation applies to money.
Reconciliation that stops before accounting leaves money on the table twice: in unrecovered deductions and in unclaimed tax credits.
Watch leakage as a percentage of GMV. Benchmarked against the 2 to 3 percent that sellers typically lose, it tells a brand exactly how much of its own money is still on the table, and every tenth of a percent recovered flows straight to the bottom line.
Should you be using payment reconciliation software yet?
Pick the line that matches your operation.
Choosing software, India versus the US, and where EasyEcom fits
The argument of this pillar is that reconciliation is a margin lever hiding in plain sight, and that it works best when it is not a standalone audit but part of the operating system.
Shortlist tools that close the loop between money, inventory, and the books; the logic is the same in India and the US, only the deduction set changes.
How to choose payment reconciliation software
In brief: Choose on multi-marketplace coverage, line-level order-to-settlement matching, deduction validation against expected rates, a claims workflow that respects marketplace windows, native accounting and tax integration, and the scale to handle multi-marketplace, multi-currency volume. The differentiator is whether reconciliation connects to inventory and the books, or stops at a report.
| Criterion | What to require |
|---|---|
| Multi-marketplace coverage | Amazon, Flipkart, Myntra, Meesho, Noon, plus payment gateways |
| Line-level matching | Order-to-settlement matching per line, not summary totals |
| Deduction validation | Checks commission, shipping, TCS, and returns against expected values |
| Claims workflow | Flags recoverable amounts and supports filing within claim windows |
| Accounting and tax | Posts reconciled figures to ERP or Tally and captures TCS and GST |
| Scale and connection | Handles volume, and ties reconciliation to inventory and orders |
Most tools stop at producing a reconciliation report and leave the brand to act on it. The ones worth shortlisting close the loop, connecting the money back to the units sold and forward to the books, so reconciliation is not a standalone audit but part of how the business runs.
Reconciliation in India and the US
In brief: The discipline is universal but the details differ. India adds TCS at 1 percent and GST, a marketplace mix of Flipkart, Amazon, and Meesho, and very high return volumes that make returns reconciliation central. The US has no TCS but brings Amazon fulfilment and storage fees, chargebacks, reserves, and state-level sales tax. The reconciliation logic is the same; the deduction set changes.
For an Indian brand, the defining features are tax and returns. TCS withheld under GST Section 52 has to be reconciled to filings, GST treatment has to be correct across states, and the sheer volume of returns and RTO means fee reversals are the largest single reconciliation workload. The marketplace set, Flipkart, Amazon, Meesho, and others, each reports differently, so multi-format ingestion is essential from the start.
For a US brand, the tax picture is state sales tax rather than a withheld TCS, but the settlement is no simpler. Amazon in particular layers fulfilment, storage, and long-term-storage fees onto commission, holds reserves, and processes chargebacks, each of which is a reconciliation surface of its own. A brand selling in both markets needs a system that handles both deduction sets in one place, so it can see reconciled margin per marketplace and per country rather than per spreadsheet.
Where EasyEcom fits
In brief: EasyEcom builds payment reconciliation into the same platform that manages inventory and orders, and connects it to accounting. Every order sold is matched to the payment received, deductions are validated, discrepancies are flagged for recovery, and reconciled figures, with TCS and GST captured, post to the books, so a brand knows its true, net margin per marketplace without a separate reconciliation project.
That is how EasyEcom is built. Because inventory, orders, and reconciliation live on one platform, every unit sold can be traced to the payment it produced, and the gap between what was owed and what was paid is surfaced automatically rather than discovered months later.
In practice, this means settlements from every marketplace are ingested and matched at the line level, commission, shipping, tax, and return reversals are validated against what they should be, recoverable discrepancies are flagged, and the reconciled result flows into accounting with tax captured for filing. It is the connection most reconciliation tools lack: money tied back to inventory and forward to the books, closing the loop that pure inventory and warehouse systems leave open.
Want to see it on your own settlements? Explore EasyEcom's payment reconciliation.
Payment Reconciliation Software for Indian Sellers (2026)
Tools compared on Flipkart, Amazon and Meesho coverage, TCS handling and claims workflow.
Multi-Warehouse Management: How Order Routing Works
The inventory and order side that reconciliation ties money back to across sites.
Most tools stop at producing a reconciliation report and leave the brand to act on it.
The vocabulary, in plain English
The words that come up across every chapter, defined once, so nothing below needs a glossary tab open.
- Settlement
- The marketplace's record of what it is paying you after it has subtracted its charges. Reconciliation proves the settlement and the order value agree, order by order.
- GMVGross merchandise value
- The total value of orders sold before deductions. Leakage is measured as unrecovered incorrect deductions divided by GMV.
- Referral feeCommission
- The marketplace's revenue share, set by product category. Category misclassification charges a higher rate than the product warrants.
- Volumetric weight
- The dimension-based weight marketplaces bill shipping on. Inflated volumetric weight or the wrong weight slab is one of the most common overcharges.
- TCSTax collected at source
- 1 percent withheld by Indian marketplaces under GST Section 52. It must be reconciled against the seller's GST filings so the statutory credit is claimed.
- RTOReturn to origin
- An order that fails delivery and comes back. Fees are supposed to reverse on returned and RTO orders, and incomplete reversals are the highest-volume reconciliation error in India.
- Claim window
- The period a marketplace allows for disputing a deduction. It is often short and unforgiving, and a deduction not challenged in time is money permanently lost.
- Chargeback
- A customer-initiated payment reversal processed by the marketplace, a reconciliation surface of its own for US sellers, alongside reserves and fulfilment fees.
- Leakage rate
- Unrecovered incorrect deductions as a share of GMV. The headline reconciliation metric, benchmarked against the 2 to 3 percent sellers typically lose.
- Settlement-to-books variance
- The difference between the reconciled payout and recorded revenue. It shows whether the books reflect reality.