
If you sell on Amazon, Flipkart or your own D2C store, the hardest part of bookkeeping is not raising invoices, it is making sense of the marketplace settlement. The amount that lands in your bank is never the same as what you sold, because every payout mixes together sales, commission, shipping fees, GST on those fees, TCS, TDS, offers and returns. This guide gives you a clear, repeatable method to record and reconcile Amazon and Flipkart sales in Zoho Books down to the last rupee, while staying fully GST-compliant.
The approach below is the same one professional e-commerce accountants use. It relies on a single idea, a settlement clearing account, that keeps your sales, your GST and your bank balance correct at the same time.
What Is Marketplace Settlement Reconciliation?
Marketplace settlement reconciliation is the process of matching the sales you recorded against the net amount a marketplace actually pays into your bank. Because platforms like Amazon and Flipkart deduct commission, fees, TCS and TDS before paying you, reconciliation confirms that your gross sales, the marketplace's charges, and the final bank deposit all agree, with nothing missing or double-counted.
Why E-commerce Accounting Is Different
In ordinary retail, you sell, the customer pays, and the sale equals the deposit. Marketplace selling breaks that link. The platform collects the full amount from the buyer, holds it, deducts its charges, and pays you a net settlement days or weeks later. A single order therefore touches your books in three places, on three dates, for three different amounts. To account for it correctly, you must record far more than the sale value:
- Gross sales at the invoice value the customer actually paid
- Marketplace commission and fixed/closing fees (which carry 18% GST)
- Shipping, collection and reverse-shipping fees
- TCS under GST and TDS under Section 194-O
- Offer reimbursements, protection-fund claims and other income
- Returns, RTO and cancellations that reverse a sale
- Multiple GSTINs when stock is stored across states
Never book your bank payout as your sales figure. It understates your revenue, understates your GST output tax, and hides the fees you actually paid. Your bank deposit is only what is left after the marketplace takes its cut, so it can never be your sales number.
The Settlement Formula
Every marketplace payout follows the same underlying formula. Understanding it is the key to reconciling your books:
Bank Payout = Gross Sales + Offer/Other Income − Commission − Fees − GST on Fees − TCS − TDS − Returns. To keep your books accurate, record each of these components separately in Zoho Books, not just the final number that reaches your bank.
What You Need Before You Start
Gather these reports and set up these accounts before recording a single transaction. Having them ready prevents rework and rejected imports.
- Settlement reports: the Flipkart settlement report (Orders sheet) and the Amazon Monthly Unified Transaction report (MTR)
- A tax or order report listing every invoice with its SKU, HSN and taxable value
- GST reports for reconciliation: the Flipkart GSTR-1 ready-to-file report and the Amazon MTR/GSTR-1
- Your item master with correct SKUs, HSN codes and GST rates
- Your bank statement showing the marketplace payouts
- Zoho Books (India edition, GST enabled) with a GSTIN for every state you sell from
Step 1: Set Up Clearing Accounts and Your Chart of Accounts
Create the accounts every settlement will post to. The centrepiece is a separate clearing account per marketplace, which acts as a bridge between your sales and your bank.
- Clearing accounts (current asset): "Amazon Settlement Clearing" and "Flipkart Settlement Clearing"
- Expense and input-credit accounts: Marketplace Fee Expense, GST Input Credit on Fees
- Receivable accounts: TCS Receivable, TDS Receivable
- Income accounts: Offer Reimbursement Income, Protection Fund Income
How the Clearing Account Works
Every transaction in the marketplace cycle flows through this one account. When all of them are posted, the account nets to zero, which is your proof that the period is fully reconciled.
| Transaction | Effect on Clearing | What it represents |
|---|---|---|
| Customer payment (settled orders) | Debit | Gross sale value collected by the marketplace |
| Settlement journal | Credit | Commission, fees, GST on fees, TCS, TDS (less offer income) |
| Bank receipt | Credit | The actual net payout deposited to your bank |
| Credit note (returns) | Credit | Reversal of orders that were paid and then returned |
| Closing balance | Zero | Only unsettled / in-transit amounts remain |
Step 2: Configure GSTINs as Locations and Import Your Item Master
If you store stock in more than one state through marketplace fulfilment, register a GSTIN in each state and set up each one as a separate branch or location in Zoho Books. Then import your item master with the exact SKU, HSN code and GST rate for every product, because invoices are matched to items by SKU.
Set up items and locations before importing invoices. Once each item's HSN and tax rate and each GSTIN location are correct, Zoho Books automatically applies IGST for inter-state orders and CGST + SGST for intra-state orders, so you never have to fix tax treatment invoice by invoice.
Step 3: Import All Sales Invoices at Gross Value
Create a sales invoice for every order, not just settled ones, at the full price the customer paid. For each invoice, set:
- The invoice number and date from your order or tax report
- The correct SKU, HSN and GST rate on every line
- The place of supply from the delivery state
- The GSTIN / location that dispatched the order
Recording every order keeps your sales and GSTR-1 complete from day one. Returned orders are handled later with credit notes, so they do not need to be excluded here.
Step 4: Record Payments Only for Settled Orders
Using the settlement report, record a customer payment for each order the platform has actually settled (net settlement greater than zero). Three rules keep this accurate:
- Deposit to the clearing account, not the bank
- Use the real settlement/payout date from the report, not one fixed date
- Pay the gross invoice value; leave returned, RTO and cancelled orders unpaid
Marking only settled orders as paid means returns and RTO stay open automatically, so you never overstate collections. When a return is later confirmed, a credit note closes the open invoice cleanly, and your clearing account still ties out.
Step 5: Post the Settlement Journal for Fees, Taxes and Income
For each settlement period, post one journal that captures the marketplace's deductions and credits, taken straight from the columns of the settlement report:
- Debit: Marketplace Fee Expense, GST Input Credit on fees, TCS Receivable, TDS Receivable
- Credit: Offer Reimbursement Income, Protection Fund Income (where applicable)
- Credit: Settlement Clearing Account (the balancing figure)
Book each real column from the report as its own line rather than netting figures together. A journal built column-by-column can be traced straight back to the marketplace statement, which makes audits, GST reviews and error-hunting far faster.
Step 6: Match the Bank Payout to the Clearing Account
When the marketplace deposits money into your bank, record the receipt against the settlement clearing account. The two platforms pay differently, so match each deposit to the settlement it belongs to:
- Flipkart settles through weekly NEFT transfers, so the payout date is usually the bank credit date
- Amazon disburses on a reserve-and-release schedule across cycles, so July earnings may reach your bank in August
Once the customer payments, the settlement journal and the bank receipt are all posted, the clearing account should net to zero, apart from unsettled or in-transit amounts.
Step 7: Raise Credit Notes for Returns and RTO
For orders that were sold and then returned, create a credit note against the original invoice. A single credit note does three things at once:
- Reverses the sale value and closes the open invoice balance
- Reverses the output GST on that sale
- If you track inventory, moves the stock back into Inventory Asset at cost and reverses Cost of Goods Sold
Handling returns as credit notes keeps your revenue, GST liability and stock all accurate, without disturbing the settlements you have already reconciled.
Step 8: Reconcile Against GSTR-1 and the Marketplace Reports
Close the month by matching your Zoho Books sales against the marketplace GST reports. Your books are recorded at gross, while the operator reports are usually net of returns, so differences are expected and normal.
When your books are higher than the marketplace's GST report, the gap is almost always returns you have yet to credit-note plus month-end boundary invoices (filed by the marketplace in one month but exported in your report the next). These are timing differences, not errors, but each one should be explained so GSTR-1 and your books agree.
Amazon vs Flipkart: What's Inside a Settlement
Both platforms deduct similar charges, but they report them differently, which changes how you record them in Zoho Books.
| Component | Flipkart | Amazon |
|---|---|---|
| Commission / referral fee | Shown as a separate column | Bundled into fees |
| GST on marketplace fees | Own column (easy input credit) | Embedded in the fee (needs the fee tax invoice to split) |
| Offer / promotion income | Offer reimbursement paid to seller | Promotional rebates and reimbursements |
| TCS (GST) | Reported per settlement | Reported per settlement |
| TDS (Section 194-O) | 0.1% on gross | 0.1% on gross |
| Payout cycle | Weekly NEFT (fast) | Reserve/release, disbursed in cycles (slower) |
| GST report for reconciliation | GSTR-1 ready-to-file report | MTR (B2C/B2B) and GSTR-1 report |
Common Reconciliation Mistakes to Avoid
Most marketplace accounting errors come down to the same handful of mistakes. Avoid these and your books will stay clean:
- Booking only the bank payout as sales, which understates revenue and GST
- Ignoring TCS and TDS credits you are entitled to claim
- Paying invoices that were never settled (returns, RTO, cancellations)
- Double-counting duplicate or multi-warehouse orders that appear twice in reports
- Using the wrong IGST vs CGST/SGST treatment on inter-state orders
- Not tagging sales to the correct GSTIN/location
- Forgetting credit notes, leaving returned stock and reversed GST unrecorded
Moving From Tally to Zoho Books
Many D2C and marketplace sellers outgrow Tally because it was not built for high-volume, multi-GSTIN, marketplace-driven selling. A successful Tally to Zoho Books migration usually follows this order:
- Set up the chart of accounts, including per-marketplace clearing accounts
- Import your item master with correct SKUs, HSN codes and tax rates
- Configure each GSTIN as a branch/location
- Enter opening balances as on the migration date
- Import historical sales, purchases, payments and settlement journals month by month
- Reconcile every month against marketplace and GST reports before moving on
Learn About Our Zoho Books Accounting Services
Conclusion
E-commerce accounting feels complicated only because a single order is split across sales, fees, taxes and a delayed payout. Once you invoice every order at gross, pay only settled orders, post fees and taxes through a settlement journal, and reconcile the bank payout through a clearing account, your books become accurate, your GST returns tie out, and your true profit becomes visible. Zoho Books gives online sellers the automation and multi-GSTIN handling to make this repeatable every month.
At ProTax, we help e-commerce and D2C brands set up Zoho Books, migrate from Tally, and reconcile Amazon and Flipkart settlements to the last rupee, so you can focus on growing sales while we keep the books clean and GST-ready.
Talk to an E-commerce Accounting Expert
Frequently Asked Questions
How do I record Amazon and Flipkart sales in Zoho Books?
Create a sales invoice for every order at its full (gross) value, then record a customer payment only for the orders the marketplace has actually settled, deposited to a settlement clearing account. The marketplace's commission, fees, GST on fees, TCS and TDS are posted through a settlement journal, and the money that reaches your bank is matched against the clearing account. This keeps your sales, your GST output, and your bank balance all correct at once.
Why doesn't my Amazon or Flipkart payout match my sales?
Because the marketplace deducts several charges before paying you. A typical payout subtracts commission, fixed and closing fees, shipping and collection fees, GST on those fees, TCS and TDS, and may add back offer reimbursements. The gap between your gross sales and the bank deposit is made up of these components, which is exactly why a settlement clearing account is used to reconcile them.
What is a settlement clearing account in Zoho Books?
A settlement clearing account is a temporary holding account that sits between your sales and your bank. Customer payments debit it, the settlement journal credits it with fees and taxes, and the actual bank payout credits it. When all three are posted, the account nets to zero, which proves your marketplace accounting for that period is complete and accurate.
How is TCS handled for e-commerce sellers under GST?
Marketplaces deduct TCS at 0.5% CGST + 0.5% SGST (or 1% IGST) on the net taxable value of your sales and deposit it against your GSTIN. Record it as TCS Receivable, because you can claim it in your electronic cash ledger when filing GSTR-3B. It is reported by the operator in GSTR-8.
How do I record TDS deducted under Section 194-O?
Under Section 194-O, e-commerce operators deduct TDS at 0.1% on the gross value of sales. Book it in Zoho Books as TDS Receivable (an asset) that you later adjust against your income tax liability, and capture it as a separate line in the settlement journal so the clearing account reconciles to the exact bank payout.
Do e-commerce sellers need a separate GST registration for each state?
You need a GST registration in every state you supply goods from. If you use marketplace fulfilment (such as Amazon FBA or Flipkart warehouses) and store stock in multiple states, you generally need a separate GSTIN for each state. In Zoho Books, each GSTIN is set up as a separate branch or location so invoices, IGST vs CGST/SGST, and GST returns are handled correctly per state.
What is the difference between IGST and CGST/SGST on marketplace sales?
It depends on the place of supply. If the seller's state is the same as the customer's delivery state, it is an intra-state sale and attracts CGST + SGST. If they are different, it is an inter-state sale and attracts IGST. Zoho Books applies this automatically once each item and GSTIN location is set up correctly.
Should I record marketplace sales as individual invoices or one summary entry?
For most sellers, individual invoices per order is the more accurate approach. It lets you match each sale to the settlement, track returns with credit notes, tie out GST at the invoice level, and reconcile GSTR-1 against the operator's report. A single monthly summary entry is faster but makes reconciliation, returns and GST matching much harder as volumes grow.
How do I account for returns and RTO orders in Zoho Books?
Returns and RTO orders should not be marked as paid, because the marketplace never settles them as a sale. Best practice is to invoice every order but record payment only for settled ones, leaving returns open. When a return is confirmed, issue a credit note that reverses the sale, the output GST, and (if you track inventory) the stock at cost.
How do I reconcile my Amazon or Flipkart settlement in Zoho Books?
Follow four steps: (1) import sales invoices at gross value, (2) record customer payments for settled orders into the clearing account, (3) post a settlement journal for commission, fees, GST on fees, TCS and TDS (less offer income), and (4) match the bank payout against the clearing account. When done correctly, the clearing account nets to zero.
Can I migrate my e-commerce accounts from Tally to Zoho Books?
Yes. Many D2C and marketplace sellers move from Tally to Zoho Books for better automation and multi-GSTIN GST handling. A clean migration sets up the chart of accounts, item master with HSN, GSTINs as locations and opening balances, then imports historical sales, purchases, payments and settlement journals period by period, reconciling each month against the marketplace reports.
How often should I reconcile marketplace settlements?
At minimum, reconcile every settlement cycle (weekly for Flipkart NEFT payouts and per disbursement for Amazon), with a monthly close that ties your Zoho Books sales to GSTR-1, your settlements to your bank, and your fees to the operator reports. Regular reconciliation catches missing invoices, duplicates and fee errors before they distort your GST returns.
What are the most common e-commerce accounting mistakes in Zoho Books?
The most frequent mistakes are booking only the bank payout as sales (which understates revenue and GST), ignoring TCS and TDS credits, using the wrong IGST vs CGST/SGST treatment, missing month-end boundary invoices, not tagging sales to the correct GSTIN/location, and forgetting credit notes for returns. A structured clearing-account method prevents almost all of these.
Frequently Asked Questions
How do I record Amazon and Flipkart sales in Zoho Books?
Create a sales invoice for every order at its full (gross) value, then record a customer payment only for the orders the marketplace has actually settled, deposited to a settlement clearing account. The marketplace's commission, fees, GST on fees, TCS and TDS are posted through a settlement journal, and the money that reaches your bank is matched against the clearing account. This keeps your sales, your GST output, and your bank balance all correct at once.
Why doesn't my Amazon or Flipkart payout match my sales?
Because the marketplace deducts several charges before paying you. A typical payout subtracts commission, fixed and closing fees, shipping and collection fees, GST on those fees, TCS and TDS, and may add back offer reimbursements. The gap between your gross sales and the bank deposit is made up of these components, which is exactly why a settlement clearing account is used to reconcile them.
What is a settlement clearing account in Zoho Books?
A settlement clearing account is a temporary holding account that sits between your sales and your bank. Customer payments debit it, the settlement journal credits it with fees and taxes, and the actual bank payout credits it. When all three are posted, the account nets to zero, which proves your marketplace accounting for that period is complete and accurate.
How is TCS handled for e-commerce sellers under GST?
Marketplaces deduct TCS at 0.5% CGST + 0.5% SGST (or 1% IGST) on the net taxable value of your sales and deposit it against your GSTIN. Record it as TCS Receivable, because you can claim it in your electronic cash ledger when filing GSTR-3B. It is reported by the operator in GSTR-8.
How do I record TDS deducted under Section 194-O?
Under Section 194-O, e-commerce operators deduct TDS at 0.1% on the gross value of sales. Book it in Zoho Books as TDS Receivable (an asset) that you later adjust against your income tax liability, and capture it as a separate line in the settlement journal so the clearing account reconciles to the exact bank payout.
Do e-commerce sellers need a separate GST registration for each state?
You need a GST registration in every state you supply goods from. If you use marketplace fulfilment (such as Amazon FBA or Flipkart warehouses) and store stock in multiple states, you generally need a separate GSTIN for each state. In Zoho Books, each GSTIN is set up as a separate branch or location so invoices, IGST vs CGST/SGST, and GST returns are handled correctly per state.
What is the difference between IGST and CGST/SGST on marketplace sales?
It depends on the place of supply. If the seller's state is the same as the customer's delivery state, it is an intra-state sale and attracts CGST + SGST. If they are different, it is an inter-state sale and attracts IGST. Zoho Books applies this automatically once each item and GSTIN location is set up correctly.
Should I record marketplace sales as individual invoices or one summary entry?
For most sellers, individual invoices per order is the more accurate approach. It lets you match each sale to the settlement, track returns with credit notes, tie out GST at the invoice level, and reconcile GSTR-1 against the operator's report. A single monthly summary entry is faster but makes reconciliation, returns and GST matching much harder as volumes grow.
How do I account for returns and RTO orders in Zoho Books?
Returns and RTO orders should not be marked as paid, because the marketplace never settles them as a sale. Best practice is to invoice every order but record payment only for settled ones, leaving returns open. When a return is confirmed, issue a credit note that reverses the sale, the output GST, and (if you track inventory) the stock at cost.
How do I reconcile my Amazon or Flipkart settlement in Zoho Books?
Follow four steps: (1) import sales invoices at gross value, (2) record customer payments for settled orders into the clearing account, (3) post a settlement journal for commission, fees, GST on fees, TCS and TDS (less offer income), and (4) match the bank payout against the clearing account. When done correctly, the clearing account nets to zero.
Can I migrate my e-commerce accounts from Tally to Zoho Books?
Yes. Many D2C and marketplace sellers move from Tally to Zoho Books for better automation and multi-GSTIN GST handling. A clean migration sets up the chart of accounts, item master with HSN, GSTINs as locations and opening balances, then imports historical sales, purchases, payments and settlement journals period by period, reconciling each month against the marketplace reports.
How often should I reconcile marketplace settlements?
At minimum, reconcile every settlement cycle (weekly for Flipkart NEFT payouts and per disbursement for Amazon), with a monthly close that ties your Zoho Books sales to GSTR-1, your settlements to your bank, and your fees to the operator reports. Regular reconciliation catches missing invoices, duplicates and fee errors before they distort your GST returns.
What are the most common e-commerce accounting mistakes in Zoho Books?
The most frequent mistakes are booking only the bank payout as sales (which understates revenue and GST), ignoring TCS and TDS credits, using the wrong IGST vs CGST/SGST treatment, missing month-end boundary invoices, not tagging sales to the correct GSTIN/location, and forgetting credit notes for returns. A structured clearing-account method prevents almost all of these.
