Skip to main content
How-To · 6 min read

How Do I Record an Amazon or Flipkart Settlement in My Books?

Never book only the net payout as sales. Record the full sale, park it in a marketplace receivable account, then clear that account with the bank credit and separate lines for fees, GST TCS and Section 194O TDS.

Terra Insight
Terra Insight Editorial Team Reconciliation Infrastructure

Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →

Published 14 October 2026
Domain expertise
TDS Reconciliation GST Input Credit Platform Settlements NACH Batch Matching Bank Reconciliation Form 26AS Matching ERP Integrations Enterprise Finance Ops
Knowledge Card
Problem

Sellers book only the net marketplace payout as sales, which understates revenue and GST turnover and loses the TCS and TDS credits.

How It's Resolved

Record the gross sale against a marketplace receivable, then clear the receivable with the bank credit plus separate lines for commission and fees with GST, GST TCS and Section 194O TDS.

Configuration

Ledgers for marketplace receivable, sales, output GST, marketplace fees, input GST, GST TCS receivable, TDS receivable and returns; order ID kept on every entry.

Output

A marketplace receivable account that closes at nil or at delivered-but-unpaid orders, with TCS and TDS credits ready to match against official statements.

Book the full sale as revenue and the marketplace (Amazon, Flipkart, Meesho and so on) as a customer who owes you money. When the payout lands, clear that receivable with the bank credit and post commission, GST TCS and TDS as separate lines. Never book only the net payout as your sales.

Why not just book the net payout as sales?

Because the payout is not your sale. It is your sale minus several deductions, and each deduction means something different:

  • Commission and fees are an expense, and the GST on them is usually input tax credit.
  • GST TCS at 0.5 percent of the net taxable value (under Section 52 of the CGST Act 2017, reduced from 1 percent from 10 July 2024) is a GST credit you can use.
  • Section 194O TDS at 0.1 percent (reduced from 1 percent from 1 October 2024) is income-tax paid on your behalf.

If you book only the net amount, three things go wrong: your sales figure is lower than the invoices you issued, so your GSTR-1 and books disagree; the TCS and TDS credits never reach a ledger, so you may not claim them; and fees disappear without a GST input claim.

What are the entries for one order?

Take one order. Taxable value ₹1,000, GST at 5 percent ₹50, so the invoice is ₹1,050. The marketplace charges an illustrative commission and shipping fee of ₹150 plus 18 percent GST of ₹27. (Commission rates vary by category and marketplace; these figures are for illustration only.)

StepDebitCreditAmount
1. Sale on deliveryMarketplace receivableSales ₹1,000 and output GST ₹50₹1,050
2. Commission and feesMarketplace fees ₹150 and input GST ₹27Marketplace receivable₹177
3. GST TCS (0.5 percent of ₹1,000)GST TCS receivableMarketplace receivable₹5
4. Section 194O TDS (0.1 percent of ₹1,000)TDS receivableMarketplace receivable₹1
5. Bank receiptBankMarketplace receivable₹867
Return (if any)Sales returns and output GSTMarketplace receivableReverse step 1

Check: ₹1,050 − ₹177 − ₹5 − ₹1 = ₹867. After step 5 the marketplace receivable for this order is nil.

In Tally Prime or Zoho Books, create the marketplace as a ledger under Sundry Debtors, and keep the order ID in the narration so you can trace each line later.

How do I know the marketplace account is clean?

At month end, the marketplace receivable balance should equal orders you have delivered but the marketplace has not yet paid, plus anything it is holding (for example, a reserve or a disputed return). If the balance is higher, you have missed a deduction or a payout. If it is lower or negative, you have probably booked a payout twice or missed a sale.

A simple monthly routine:

  1. Download the marketplace’s settlement report for the month.
  2. List unpaid delivered orders by order ID.
  3. Compare that list’s total with the ledger balance.
  4. Chase any difference before closing the month.

Worked example: one week of orders

A seller has 40 orders in a week worth ₹48,000 including GST. Three are returned, worth ₹3,600. Net sales including GST: ₹48,000 − ₹3,600 = ₹44,400, of which the taxable value is about ₹42,286.

The settlement report shows:

  • Commission, fixed fees and shipping with GST: ₹5,727 (illustrative)
  • GST TCS at 0.5 percent of ₹42,286: ₹211
  • Section 194O TDS at 0.1 percent of ₹42,286: ₹42

Payout: ₹44,400 − ₹5,727 − ₹211 − ₹42 = ₹38,420. That is the bank credit.

Entries: debit the receivable ₹48,000 for sales, credit it ₹3,600 for returns, credit it ₹5,727 for fees, ₹211 for TCS, ₹42 for TDS and ₹38,420 for the bank receipt. The receivable closes at ₹48,000 − ₹3,600 − ₹5,727 − ₹211 − ₹42 − ₹38,420 = nil.

Where do the TCS and TDS credits go next?

The TCS shows on the GST portal after the marketplace files its GSTR-8. The TDS shows in your TDS credit statement (Form 26AS, or Form 168 from tax year 2026-27, where Section 194O maps to payment code 1035 under the Income-tax Act 2025). Match both ledgers every quarter.

Marketplace settlement reconciliation is on the TransactIG roadmap; see payment gateway reconciliation for where it fits.

Primary reference: Central Board of Indirect Taxes and Customs — for Section 52 of the CGST Act 2017, under which e-commerce operators collect GST TCS on the net value of taxable supplies made through them..

Frequently Asked Questions

Should I book the net payout from Amazon or Flipkart as my sales?
No. Book the full invoice value as sales and the marketplace as a receivable. The net payout is what is left after commission, fees, TCS and TDS, so booking it as sales understates turnover and loses the tax credits.
Is the GST TCS deducted by a marketplace an expense?
No. GST TCS collected under Section 52 of the CGST Act is a credit you can use. Post it to a TCS receivable ledger and claim it on the GST portal once the marketplace files its return.
Is the Section 194O TDS an expense?
No. It is income-tax paid on your behalf. Post it to a TDS receivable ledger and match it with your TDS credit statement before claiming it in your return.
Can I claim GST input tax credit on marketplace commission?
Generally yes, if the marketplace issues a valid tax invoice to your GSTIN for its commission and fees and the invoice appears in your GSTR-2B. Book the GST on fees to an input tax ledger, not to expense.
What should the marketplace receivable balance be at month end?
It should equal orders delivered but not yet paid out, plus any amounts the marketplace is still holding. Any other balance is a mismatch to investigate.

See how TransactIG handles reconciliation for your industry

Configuration takes 2–4 weeks. No code development required. ISO 27001:2022 certified.