What Is Ecommerce Reconciliation? Complete Guide 2026

India’s e-commerce market is worth about USD 159 billion in 2026, according to Mordor Intelligence. Yet if you ask most online sellers, “Did every rupee from last month’s orders reach your bank?”, you usually get a long pause. That pause is the reason this guide exists. So, what is ecommerce reconciliation, and why should you care about it right now?

Put simply, ecommerce reconciliation is the habit of checking that your orders, the marketplace settlement and the payout in your bank all agree. When they don’t, money slips away through wrong fees, missed returns and unclaimed tax credits. In this guide, you will learn the marketplace reconciliation meaning in plain words, see one real settlement worked out line by line, and follow a 7-step ecommerce reconciliation process you can start using this week.

What Is Ecommerce Reconciliation? A Plain-English Definition

Ecommerce reconciliation is the process of matching every sale you make online against the money you actually receive and the entries in your books. For a seller on Amazon, Flipkart, Meesho or Myntra, this means comparing three records: the order report, the settlement report and your bank statement. If all three agree, you can trust your numbers. If they don’t, reconciliation shows you exactly where the gap is and which order caused it.

Marketplace Reconciliation Meaning in Simple Words

The marketplace reconciliation meaning is a little narrower. It focuses on the money a marketplace collects on your behalf. When a buyer pays Flipkart, that money doesn’t come straight to you. Flipkart holds it, takes out commission, shipping fees, taxes and return charges, and then sends you what’s left on a fixed cycle. Marketplace reconciliation checks that this “what’s left” amount is correct for every single order.

The Three Numbers You Must Match: Orders, Settlement and Payout

Every reconciliation, big or small, comes down to three numbers. You need all three sources open side by side:

• Orders: What the customer bought and paid, including GST. You find this in the order or sales report, such as the Amazon MTR or the Flipkart sales report.
• Settlement: How the marketplace split that payment into fees, taxes and your share. You find this in the settlement or payment report.
• Payout: The money actually credited to your bank. You find this in your bank statement, usually with a UTR or reference number.

Matching is the heart of the job. First, you match each order ID to its settlement line. Next, you match each settlement batch to a bank credit using the UTR number. Any line that doesn’t match becomes a question you need to answer.

Reconciliation vs Bookkeeping: How They Differ

Bookkeeping records transactions, while reconciliation checks them. Your bookkeeping in Tally, Busy or Zoho Books shows what you think happened. Reconciliation proves it actually happened, order by order and rupee by rupee. You need both, because clean books built on unchecked marketplace data are still wrong. That is why many sellers use an ecommerce Tally plugin that only posts entries after the data is reconciled.

Why Ecommerce Reconciliation Matters for Indian Sellers in 2026

Indian e-commerce is set to grow at about 15.89% a year and reach USD 332.94 billion by 2031, as per Mordor Intelligence’s 2026 report. More sales sound great. However, every extra order also brings extra fees, extra returns and extra tax entries to check. Without a clear reconciliation habit, your growth can hide a growing pile of mistakes.

Revenue Leakage Hides in Small Deductions

Revenue leakage is money you earned but never received. It rarely comes from one big error. Instead, it builds up from small things like an extra ₹12 shipping charge, a refund that was never reversed or a lost return that was never claimed. Industry benchmarks for Amazon FBA sellers suggest that 1-3% of annual revenue goes unclaimed through reimbursable errors. On ₹50 lakh in yearly sales, even 2% means ₹1 lakh gone without anyone noticing.

GST, TCS and TDS Shrink Every Payout

Every marketplace payout is reduced by two government deductions. Under Section 52 of the CGST Act, the marketplace collects GST TCS at 0.5% of net taxable value, a rate cut from 1% with effect from 10 July 2024. On top of that, Section 194-O of the Income Tax Act requires 0.1% TDS, which jumps to 5% if you haven’t given your PAN or Aadhaar. Both amounts are your money, and you can claim them back. However, you can only do that correctly if they match your own sales records. The GST Council’s TCS FAQ explains the rules, and our guide on how GST reconciliation works step by step shows the seller side.

Clean Books Help With Audits, Loans and GST Notices

Reconciled books make every outside conversation easier. Your CA files GSTR-1 and GSTR-3B faster because the numbers already agree. Banks and lenders trust your profit figures when they can trace them to real payouts. And if you receive a GST notice, you can answer it with order-level proof instead of rough totals. In short, reconciliation turns your accounts from “probably right” into “provably right”.

How a Marketplace Settlement Works: From Order to Payout

Most sellers are surprised the first time they trace a single order all the way to the bank. The customer paid one amount, but a much smaller amount shows up in your account. Knowing where each rupee went is the first real step in understanding what is ecommerce reconciliation in practice. Let’s walk through one order together.

A Worked Example for One ₹1,180 Order

Say you sell a product for ₹1,180, including 18% GST. Here is how a typical marketplace might split that money. The fee rates below are for illustration only, since real rates vary by marketplace and category.

Look closely, and you will see something important. Only ₹902.60 reaches you, yet you still owe the ₹180 output GST to the government. Some of it comes back as ₹41.40 input tax credit and ₹5 TCS credit, but only if you track them. Miss these credits on hundreds of orders a month, and the loss becomes real money.

Where Each Deduction Shows Up in Your Reports

Each marketplace spreads this information across different files. Amazon uses the Merchant Tax Report (MTR), settlement reports and payment reports, each in its own format. Flipkart and Meesho have their own layouts again, with different column names for the same fee. If you sell on several channels, our guides on the Amazon GST automation tool, Flipkart settlement reconciliation software and the Meesho GST reconciliation guide explain each report in detail.

Why Your Bank Credit Never Equals Your Sales

Marketplaces pay out in batches, not order by order. One bank credit can include dozens of orders, minus returns from last month, minus a reserve the marketplace holds back. As a result, comparing your monthly sales total with your monthly bank credits almost never works. You have to break each payout down to its order-level settlement lines. Only then can you see which orders were paid, which were short-paid and which were never paid at all.

The Ecommerce Reconciliation Process: 7 Simple Steps

Now that you know how a settlement is built, here is the full ecommerce reconciliation process. You can follow these steps in a spreadsheet or let software run them for you. Either way, the logic stays the same.

1. Download your reports. Collect order, settlement, return and tax reports from each marketplace for the same date range.
2. Clean the data. Remove duplicate rows, fix date formats and keep only the columns you need.
3. Standardise product names. Map every marketplace listing name to one master SKU in your books.
4. Match orders to settlement lines. Use the order ID to link each sale to its fees, taxes and net amount.
5. Match settlements to bank credits. Use the UTR or settlement ID to link each batch to your bank statement.
6. Investigate every difference. Check unpaid orders, wrong fees, missing return credits and unclaimed TCS.
7. Post to bookkeeping and GST. Export clean entries to Tally, Busy or Zoho Books and prepare GSTR-1 and GSTR-3B data.

Steps 1 to 3: Collect, Clean and Standardise Your Data

The first three steps decide how smooth everything else will be. Product naming is the hidden trap here. For example, one hair oil might be “Bhringraj Hair Oil 1L” in your books but appear under four different names on Amazon, Flipkart, Meesho and Shopify. Your accounting software then treats it as four products. That quietly breaks your stock reports and profit numbers, so map every listing to one master product before you match anything.

Steps 4 to 6: Match, Flag and Investigate Differences

Matching is where most of the time goes. A seller with 3,000 orders a month on three marketplaces may have over 9,000 rows to match. Doing this with VLOOKUP formulas works, but one wrong cell reference can hide dozens of errors. The goal is simple: every order should land in one of three buckets, namely fully paid, short-paid or unpaid. You then chase only the last two.

Step 7: Post Clean Entries to Bookkeeping and GST Returns

Once the numbers agree, you can post them with confidence. Sales, returns, fees, TCS and TDS each go to the right ledger. Re-typing this data by hand, however, brings new errors back in. That’s why sellers often use an ecommerce accounting plugin for Busy or a Zoho Books accounting plugin for ecommerce to move reconciled data straight into their bookkeeping software.

6 Common Reconciliation Gaps That Cause Revenue Leakage

Every seller’s gaps look a little different, but the same six problems show up again and again. If you check for these each month, you will catch most of your revenue leakage early.

• Unpaid orders: Orders marked as delivered but never included in any settlement.
• Missing return credits: Returned items that came back to you, but the refund was still charged against you or never reversed.
• RTO charges: Return-to-origin shipping fees charged on orders that never reached the customer.
• Wrong fee rates: Commission charged at the wrong category rate, or weight-based shipping charged on the wrong slab.
• Duplicate deductions: The same fee or penalty taken twice across two settlement cycles.
• Unclaimed TCS and TDS: Tax credits sitting on the GST portal or in Form 26AS that never got matched and claimed.

Returns and RTO That Never Get Credited Back

Returns are the biggest leak for many Indian sellers. Recent 2026 benchmarks show that cash-on-delivery orders can see RTO rates as high as 26%, compared with under 2% for prepaid orders. In fashion, return rates often sit between 25% and 40%. With a fully loaded cost of roughly ₹200-450 per return, every return that isn’t matched and credited correctly hurts twice: once in shipping and again in a missing refund.

Fee Errors, Weight Disputes and Double Deductions

Marketplaces process millions of orders, so small fee errors are bound to happen. A product might be charged on a heavier weight slab than its real size. A fee schedule might change, and an older rate might still be applied. These errors look tiny on one order. However, a ₹15 overcharge on 2,000 orders a month adds up to ₹30,000, which is ₹3.6 lakh a year.

Missing or Delayed Payouts

Sometimes a whole settlement batch arrives late or splits into two payments. If you only check totals, you might think the money is simply “on its way” for months. Reconciling each payout against its UTR number shows you immediately which batch is missing. As a result, you can raise a ticket with the marketplace while it is still easy to trace.

Manual vs Automated Ecommerce Reconciliation

You can do ecommerce reconciliation by hand or with software. Both use the same matching logic. The difference lies in time, accuracy and how well the method holds up as your orders grow. Here is a side-by-side comparison.

Narti time figures are based on the company’s own reported results. Your results may vary with order volume and number of marketplaces.

When Manual Reconciliation Still Works

If you sell on a single marketplace and handle a few hundred orders a month, a well-built spreadsheet can do the job. It costs nothing and teaches you how settlements really work. Just make sure you follow the same steps every time and keep a copy of each month’s file. The trouble starts when one person owns the sheet and nobody else understands it.

When It Is Time to Automate

You probably need automation when reconciliation takes more than a day each month, or when you sell on three or more channels. Another clear sign is when your CA keeps asking for “clean data” before filing. At this point, the hours you spend matching rows cost more than the software. Plus, automation keeps the process running even when a team member leaves.

What to Look for in Reconciliation Software

Look for a tool that supports every marketplace you sell on, maps product names to one master SKU and exports directly to your accounting software. It should also give you order-level detail, not just summaries. For a broader view of the market, compare options in our list of top ecommerce GST reconciliation tools. If you want to build reconciliation into your own systems instead, explore the ecommerce reconciliation API.

Case Study: How a Multi-Marketplace Seller Fixed Reconciliation

Theory is useful, but a real story shows the impact better. Narti Solutions didn’t start as a software company. It began inside Narti Herbs, an herbal products brand that sells across 25+ online marketplaces. The team ran into every reconciliation problem in this guide before they built a fix.

The Problem: Same Product, Different Names, Weeks of Matching

As Narti Herbs grew across Amazon, Flipkart, Myntra and other platforms, report formats kept changing from one channel to the next. TCS and commission deductions were hard to follow. Worse, a single product like Bhringraj Hair Oil 1L appeared under a different name on every marketplace. Reconciling settlements each quarter took the team weeks, and mismatched entries kept showing up at GST filing time.

The Fix: Import, Standardise, Reconcile, Export

Instead of hiring more staff, the team built an internal tool around four steps. First, it imports raw marketplace reports without any reformatting. Then it maps every listing name to one master product. Next, it matches settlements against invoice-level sales and flags gaps. Finally, it exports accounting-ready and GST-ready data to Tally, Busy and Zoho Books.

The Results and What You Can Learn

According to Narti Solutions, the same reconciliation that once took weeks now takes about five minutes per file, with far fewer mismatches at filing time. The lesson for you is simple. The problem isn’t your marketplace or your accountant. Instead, the problem is that marketplace data and accounting data speak different languages, and you need a reliable translator in between. You can read the full story in our Narti ecommerce GST reconciliation tool guide.

Best Practices for Accurate Ecommerce Reconciliation

Good reconciliation is more about habits than tools. These practices keep your numbers clean, whether you use spreadsheets or software. Start with one, and add the others over the next few months.

Reconcile Weekly, Not Just at Filing Time

Many sellers only reconcile when GSTR-1 is due. By then, a month of errors has piled up, and some claim windows may already be closing. A weekly check, right after each settlement cycle, keeps the work small. It also lets you raise disputes with the marketplace while the details are still fresh.

Keep One Master SKU List Across Every Channel

Create one master product list and map every marketplace listing to it. This single step fixes stock reports, product-wise profit and GST matching all at once. Update the mapping whenever you launch a new listing. A multi-marketplace settlement and GST tool can manage this mapping for you automatically.

Store an Order-Level Audit Trail

Keep reconciled data at the order level for at least the full GST assessment period. If you receive a notice, you will need to show exactly which orders made up a figure. Totals alone won’t satisfy an officer. Save your reports, your matching results and notes on every dispute you raised, and check your TCS credits on the GST portal each month. Sellers on fashion platforms should also review the extra return steps in our Myntra GST reconciliation guide.

Frequently Asked Questions About Ecommerce Reconciliation

What is ecommerce reconciliation in simple terms?

Ecommerce reconciliation means checking that three records agree: your marketplace orders, the settlement report that lists fees and taxes, and the payout that lands in your bank. When they match, your sales and profit figures are correct. When they don’t, reconciliation shows which order, fee or refund caused the gap so you can fix it.

Why is my marketplace payout lower than my sales?

Your payout is your sale value minus marketplace commission, shipping and closing fees, GST on those fees, 0.5% GST TCS, 0.1% income tax TDS, and any return or RTO charges. Settlements may also include adjustments from older orders. Matching each order to its settlement line shows whether every deduction was correct.

How often should I reconcile my marketplace settlements?

Reconcile at least once a week, ideally soon after each settlement cycle. Weekly checks catch missing payouts and wrong fees while the marketplace still accepts disputes. Waiting until your monthly GSTR-1 or the year-end audit makes errors harder to trace, and some claim windows may close before you notice the problem.

Can I claim back the TCS deducted by Amazon or Flipkart?

Yes. GST TCS collected under Section 52 is credited to your electronic cash ledger after the marketplace files GSTR-8 and you accept it on the GST portal. You can use it to pay GST. The catch is that the TCS figure must match your own sales records, which is why reconciliation matters.

Do I need software for ecommerce reconciliation?

If you sell on one marketplace with a few hundred orders a month, a careful spreadsheet can work. Once you sell on several channels, manual matching becomes slow and error-prone. Reconciliation software like Narti imports marketplace reports, matches orders to payouts, flags gaps and exports clean entries to Tally, Busy or Zoho Books.

Final Thoughts: What Is Ecommerce Reconciliation Worth to Your Business?

By now, you know the answer to what is ecommerce reconciliation: it is the simple, regular practice of matching your orders, settlements and payouts until every rupee is explained. It protects you from revenue leakage, helps you claim every TCS and TDS credit, and keeps your bookkeeping and GST returns accurate. Above all, it lets you grow without wondering whether your numbers are real.

You can start today with the 7-step process in this guide. However, if you sell on several marketplaces, the smartest move is to let software do the matching while you focus on growing. Narti Solutions’ ecommerce reconciliation software was built by sellers who faced these exact problems, and it now does the job in minutes instead of weeks.