Sales Report vs Settlement Report: Complete Guide 2026

Your order report says ₹5.9 lakh. Your tax report says ₹4.84 lakh. Your settlement report says ₹3.97 lakh. So which number shows your real sales? Surprisingly, all three are correct, because each one answers a different question. Once you understand the sales report vs settlement report vs tax report difference, those numbers stop looking like errors and start telling one clear story.

Most sellers download all three files every month without knowing which one to trust for which job. As a result, some file GST from the settlement report, while others judge profit from the order report. Both mistakes cost real money. In this guide, you’ll get marketplace reports explained in plain language, see how MTR vs settlement really differs, and learn the sales report vs settlement report rules that turn every file into a clean reconciliation input.

Sales Report vs Settlement Report vs Tax Report: The Short Answer

Here’s the quick version. A sales report tells you what you sold. A settlement report tells you what you got paid. A tax report tells you what you must report for GST. In the sales report vs settlement report gap, the difference is simply the cost of selling plus timing, while the tax report sits in the middle as the legal record of your sales.

Three Reports, Three Different Questions

Think of each report as the answer to one question. The sales or order report answers, “What did buyers order, and when?” The settlement or payment report answers, “How much money did the marketplace send me, and why?” The tax report answers, “What taxable sales did I make, at what GST rate, in which state?” If you ask the wrong report the wrong question, you get a confusing answer.

Why Marketplaces Split Your Data Into Separate Report Types

Marketplaces build each report for a different team. Operations teams need live order data, finance teams need payout data, and tax teams need invoice-level GST data. Each team also works on a different date: order date, payout date or invoice date. That’s why one platform can give you three totals for the same month, and why knowing your report types is the first step in any sales report vs settlement report check.

A Simple Shop Analogy

Imagine you run a small shop. Your order book lists every customer request, including the ones that got cancelled. Your billing register lists the invoices you actually issued, with GST. Your cash box shows what’s left after paying the delivery boy, the card machine fee and a few refunds. Online, the order report is your order book, the tax report is your billing register, and the settlement report is your cash box.

What Is a Sales Report (Order Report)?

The sales report, often called the order report, is the first file most sellers open. It lists every order buyers placed in a period, usually with live status updates. It’s great for tracking demand and stock. However, it’s the least reliable report for money, because it shows orders, not final sales.

What a Sales or Order Report Contains

A typical order report includes the order ID, order date, SKU or product name, quantity, item price, shipping charge, fulfilment channel and order status. Many also show the buyer’s ship-to state and pin code. On Amazon, the All Orders report gives you this view, while Flipkart and Meesho offer order exports in their seller panels. The order ID in this file is the key you’ll later use to connect every other report.

When You Should Use the Sales Report

Use the order report for day-to-day business decisions. It shows which products sell, how fast stock moves and how many orders get cancelled. It also helps you plan ads, restock inventory and spot sudden drops in demand. In a sales report vs settlement report comparison, this is your starting-point number.

Where the Sales Report Falls Short

The order report usually shows gross value, including orders that were later cancelled, returned or never delivered. It doesn’t show commission, shipping fees, TCS or TDS. Its status column can also change after you download it, so last week’s file may already be out of date. That’s why you should never use it alone for GST filing or profit calculation.

What Is a Settlement Report (Payment Report)?

The settlement report, also called the payment report, is the marketplace’s explanation of every payout. It starts with the sale value of each order and subtracts each deduction until it reaches the net amount sent to your bank. If the order report is a promise of revenue, the settlement report is the receipt. It’s also the half of the sales report vs settlement report pair that your bank statement must agree with.

What a Settlement Report Contains

A settlement report usually lists the order ID, settlement ID, deposit date, sale amount, commission or referral fee, closing and shipping fees, GST on those fees, TCS, TDS, refunds, reserves and the net payout. On Flipkart, each cycle’s report shows the sale value, every deduction, any reversal and the net credited for each order. Amazon’s settlement report also shows the TDS and TCS it withheld. Because it carries a settlement ID, you can tie each batch to one bank credit.

Settlement Report vs Payment Report: Are They the Same?

In practice, yes. Amazon keeps settlement files under Reports, then Payments, in its report repository. Flipkart calls them settlement reports inside the Payments section of Seller Hub, while Meesho offers payment files in the Payments area of its supplier panel. Some panels also show a summary statement, but you need the detailed, order-level version for reconciliation.

Where the Settlement Report Falls Short

A settlement report follows payout dates, not invoice dates. So an order you shipped on 29 September may show up in an October settlement. It also shows values after deductions, which means it isn’t a GST sales register. Using it to file GSTR-1 is one of the costliest mistakes in the whole sales report vs settlement report mix-up.

What Is a Tax Report (MTR and GST Reports)?

The tax report is the legal record of your sales for GST. It lists each invoice and credit note with its taxable value, GST rate, tax split and place of supply. Your CA uses it to prepare GSTR-1 and GSTR-3B. In short, it sits between the order report and the settlement report as the official version of your sales.

Amazon MTR: The Merchant Tax Report Explained

Amazon’s tax report is the Merchant Tax Report, or MTR, which comes in B2B and B2C versions. You’ll find it in Seller Central under Reports, then Tax Document Library. The B2B file matters because GSTR-1 must be filed invoice by invoice for every Amazon Business order with a buyer GSTIN. The MTR also lists each shipment, refund and replacement as a separate row, so a quick pivot can double-count returns. If you pull data through Amazon’s API, the SP-API tax report documentation notes that the on-demand B2C MTR only covers the last 45 days, and our Amazon GST automation tool guide shows how to turn MTR rows into filing-ready data.

Flipkart and Meesho Tax Reports

On Flipkart Seller Hub, you open the Reports Centre, create a new report and choose Tax Report as the type. Its subtypes include a Sales Report, a GSTR Return Report and a TDS Report, and the sales workbook also carries a separate Cash Back sheet. Meesho bundles its GST data into one ZIP file from the Payments section, with tcs_sales.xlsx for sales and tcs_sales_return.xlsx for returns and cancellations. Each format uses different column names for the same data, which is why multi-channel sellers struggle. Our Meesho GST reconciliation guide and our guide to Flipkart settlement reconciliation software break these files down further.

How Tax Reports Feed GSTR-1, GSTR-3B and TCS Credits

Your tax report drives three filings. First, you report sales state-wise and rate-wise in GSTR-1, including Table 14 for supplies made through e-commerce operators. Then you pay the tax in GSTR-3B. Meanwhile, the marketplace reports the 0.5% TCS it collected in its GSTR-8, usually by the 10th of the next month, and that credit appears for you on the GST portal. If your tax report and the marketplace’s GSTR-8 disagree, notices can follow, as the GST Council TCS FAQ makes clear.

MTR vs Settlement: Why the Numbers Never Match

The most common question sellers ask about marketplace reports is about MTR vs settlement. One shows ₹4.84 lakh, the other shows ₹3.97 lakh, and neither one is wrong. There are three reasons the two never match. After that, you’ll see a full bridge that explains every rupee of the gap.

Timing: Invoice Date vs Payout Date

The MTR records a sale when the invoice is raised, usually at shipment. The settlement report records it when the money is paid, which can be one to three weeks later. So orders shipped in the last days of a month land in next month’s settlement. In the same way, part of this month’s payout belongs to last month’s sales.

Gross Taxable Value vs Net Cash

The MTR shows taxable value plus GST, before any marketplace deductions. The settlement report shows cash after commission, fees, GST on fees, TCS, TDS and reserves. This gap is expected, and most of it is either a business cost or a recoverable credit. For a full list of what drives it, see our guide to the 12 reasons your marketplace payout doesn’t match your sales.

A Worked Bridge From Sales Report to Settlement Report

Here’s an illustrative month for one marketplace, showing how the order, tax and settlement reports connect. The figures are rounded examples, and real fees vary by category and price band. Still, this is exactly how a sales report vs settlement report bridge should look.

Every rupee of the ₹1,92,674 gap between the order report and the payout has a reason. The cancelled orders never became sales, the refunds became credit notes, and the fees, TCS and TDS appear line by line. Meanwhile, the timing rows simply move money between months. If any gap remains after these lines, that’s the part worth investigating.

Sales Report vs Settlement Report: Side-by-Side Comparison

Now that you know each report, here’s the full sales report vs settlement report vs tax report view in one place. Keep it handy whenever you open a marketplace panel. It also shows where each file usually lives on the three biggest Indian marketplaces.

Comparison Table: Order, Settlement and Tax Reports

Marketplaces rename menus from time to time, so confirm each path in your seller panel before you download.

Which Report to Use for Each Task

Picking the right report saves hours of confusion. Here’s a simple rule for each common job:

• GST filing (GSTR-1 and GSTR-3B): use the tax report, such as Amazon MTR or the Meesho GST report.
• Bank matching and cash flow: use the settlement or payment report.
• Fee and commission checks: use the settlement report, compared with the current rate card.
• Inventory and demand planning: use the order report.
• TCS and TDS claims: use the settlement report, matched with the GST and income tax portals.
• True profit per order: use all three, linked by order ID.

Why You Need All Three Data Sources

No single report gives you the full picture. The order report misses fees, the settlement report misses invoice detail, and the tax report misses cash. Only when you combine these data sources can you see real profit per order. That’s the whole point of the sales report vs settlement report comparison: each report fills a gap the others leave open.

How to Use All Three as Reconciliation Inputs: Step-by-Step

Your three reports work best as a team. When you treat them as reconciliation inputs instead of separate files, they explain each other. Follow these six steps every month:

1. Pick one period: download the order, settlement and tax reports for the same dates from every marketplace.
2. Clean each file: remove duplicate rows, fix date formats and keep only the columns you need.
3. Map product names: link every listing name to one master SKU, so a product looks the same in every report.
4. Link orders to invoices: match the order report to the tax report by order ID to confirm which orders became sales.
5. Link invoices to cash: match tax report rows to settlement lines by order ID, then match each settlement to a bank credit by settlement ID or UTR.
6. Review and post: check unmatched rows, raise disputes, and post clean entries to Tally, Busy or Zoho Books.

Steps 1-3: Collect and Clean Your Data Sources

Good reconciliation inputs start with matching date ranges. If your order report covers 1-30 September but your settlement report covers payouts from 3 September to 2 October, nothing will line up. Product names cause the second big problem, because one product may carry four names on four marketplaces. A single utility for multi-channel reconciliation can handle this mapping across every channel at once.

Steps 4-5: Link the Reports With Order ID and Settlement ID

The order ID is the thread that ties all three reports together. First, match orders to invoice rows in the tax report, and then match those rows to settlement lines. Next, use the settlement ID or UTR number to tie each payout batch to a bank credit. Any order missing from one report becomes a question, and that’s how a sales report vs settlement report check finds real errors.

Step 6: Post Clean Entries to Your Accounting Software

Once the reports agree, post sales, returns, fees, TCS and TDS to the right ledgers. Re-typing data by hand brings fresh errors back in, so most sellers automate this part. An ecommerce Tally plugin or an ecommerce accounting plugin for Busy moves reconciled data straight into your books. If you build your own systems, an ecommerce sales API for Tally or an ecommerce GST API for Zoho Books can do the same job.

Common Mistakes When Reading Marketplace Reports

Even experienced sellers mix up report types. These mistakes look small, but they lead to wrong GST returns, missed credits and false profit numbers. Most of them come from using one side of the sales report vs settlement report pair to do the other side’s job. Here are the three to watch for most.

Filing GST From the Settlement Report

The settlement value is net of fees and follows payout dates, so it’s never your taxable sales figure. If you file GSTR-1 from it, you under-report sales and create a mismatch with the marketplace’s GSTR-8. Always file from the tax report, and use the settlement report only to check cash. Our guide on how GST reconciliation works explains the filing side in detail.

Treating the Order Report as Final Sales

The order report includes orders that were cancelled, returned or are still in transit. If you treat its total as revenue, your profit looks bigger than it really is. In the example above, ₹1,06,200 of order value never became net sales. So use the tax report for revenue, and keep the order report for operations.

Missing Returns, Replacements and Cash Back Lines

Returns often sit in a separate file or a separate row type. Amazon’s MTR shows refunds and replacements as their own rows, Meesho splits returns into tcs_sales_return.xlsx, and Flipkart adds a Cash Back sheet. If you skip these, you over-report sales and pay extra GST. Fashion sellers see this most often, as our Myntra GST reconciliation guide explains.

Case Study: How Narti Herbs Handles Reports From 25+ Marketplaces

Narti Solutions grew out of Narti Herbs, an herbal products brand that sells on more than 25 online marketplaces. The team lived through every report problem in this guide before it built a fix. Their experience shows why the sales report vs settlement report question gets harder with every new channel you add.

The Problem: A Different Report Format for Every Channel

Each marketplace sent order, settlement and tax data in its own layout, with different column names for the same values. TCS and commission sat in different places on every platform. On top of that, one product carried a different name on each marketplace. As a result, reconciling settlements took the team weeks every quarter, and mismatches kept appearing at GST filing time.

The Fix: One Import, One Master SKU, One Export

The team built a tool that imports raw reports without reformatting, maps every listing to one master product and matches settlements against invoice-level sales. It then exports accounting-ready and GST-ready data to Tally, Busy and Zoho Books. According to Narti Solutions, work that once took weeks now takes about five minutes per file. You can read the full story in our Narti ecommerce GST reconciliation tool guide.

Frequently Asked Questions About Sales Report vs Settlement Report

What is the difference between a sales report and a settlement report?

A sales report lists what you sold: orders, products, quantities and prices. A settlement report shows what the marketplace actually paid you for those orders after commission, fees, returns, TCS, TDS and reserves. The sales report answers what you sold, while the settlement report answers how much cash reached your bank.

Which report should I use to file GSTR-1 as a marketplace seller?

Use the marketplace tax report, such as Amazon’s Merchant Tax Report (MTR) or the GST reports from Flipkart and Meesho. These show invoice-level taxable value, GST rates, place of supply and returns. Don’t file from the settlement report, because its values are net of fees and follow payout dates instead of invoice dates.

Why doesn’t my Amazon MTR match my settlement report?

The MTR records sales by invoice date at gross taxable value, while the settlement report records cash by payout date after deductions. Fees, TCS, TDS, reserves, returns and orders that fall into the next settlement cycle all create gaps. When you link both reports by order ID, most of the difference explains itself.

Is a payment report the same as a settlement report?

Mostly, yes. Marketplaces use both names for the report that breaks each payout into order-level sales, fees, taxes and adjustments. Amazon keeps it under Payments reports, while Flipkart and Meesho place it in their Payments sections. Some panels also offer a summary payment statement, so always download the detailed, order-level version.

How often should I download marketplace reports for reconciliation?

Download the settlement report after every payout cycle, usually weekly, and the tax report once a month before GST filing. Pull the order report for the same dates whenever you reconcile. Keeping all three data sources aligned to the same period makes matching faster and helps you catch errors while disputes are still possible.

Final Thoughts: Sales Report vs Settlement Report vs Tax Report, Made Simple

The sales report vs settlement report vs tax report question has a simple answer once you see the pattern. The order report shows what buyers ordered, the tax report shows what you legally sold, and the settlement report shows the cash that reached you. Each one is right for its own job. Problems only start when you use one report to answer another report’s question.

Start by downloading all three for the same period and linking them by order ID. If you sell on several marketplaces, though, matching thousands of rows by hand gets slow very quickly. Narti Solutions’ ecommerce reconciliation software was built by sellers who faced these same files, and it connects them in minutes. For the basics behind it all, revisit our guide on what ecommerce reconciliation is.