E-Commerce Accounting: Multi-Channel Tally Automation (2026)

Selling on multiple e-commerce platforms — Amazon, Flipkart, Meesho, Shopify, or Myntra — can rapidly scale your revenue. But the accounting complexity scales just as fast. Each platform settles payments differently: weekly, bi-weekly, or on-demand. Payouts arrive as net settlements, not gross sales, after deducting marketplace commission, platform fees, TDS under Section 194O, shipping charges, and GST TCS under Section 52.

If your accountant books only the net bank deposit, your sales are understated, your expenses are invisible, and your GST returns are wrong. This guide explains how to set up platform-wise ledgers in Tally Prime, process settlement reports correctly, and automate the entire workflow for audit-ready multi-channel e-commerce books.

The Core Challenge: Net Settlement vs. Gross Sales

To understand why this matters, consider a simplified Amazon settlement example:

If you book only ₹78,200 as sales, your Income Statement shows ₹21,800 less revenue than actuality. Commission expense, TDS asset, and TCS asset are all missing. Every financial ratio — gross margin, tax liability, cash flow — is distorted.

Step 1: Set Up Separate Ledgers for Each Platform in Tally Prime

Create dedicated ledgers for each marketplace channel. This structure allows you to generate platform-wise P&L reports and track outstanding receivables by channel.

Step 2: Book Gross Sales When an Order is Delivered

When goods are shipped and the sale is confirmed (not when the settlement arrives), record a Sales Voucher (F8) in Tally Prime. Use the platform's receivable ledger as the debit account — not your bank. The bank entry comes later when the settlement is paid.

Repeat this for every confirmed order, using the platform settlement report or your order management system as the source. For high-volume sellers, this entry can be done in batch using a daily or weekly summary sales voucher.

Step 3: Process the Platform Settlement Report

When the platform pays out, download the settlement report (Excel/CSV) from your seller central. The report details gross sales, commission, TDS, TCS, and the net bank transfer for the period. Record a Journal Voucher (F7) to clear the receivable and account for all deductions:

After this entry, the Amazon Receivable A/c balance for this settlement cycle returns to zero, and the bank deposit matches your bank statement. The TDS and GST TCS amounts sit in asset accounts to be claimed later.

TCS Under Section 52 (GST) vs. TDS Under Section 194O (Income Tax)

Both deductions have the same apparent effect — they reduce your cash payout — but they are governed by completely different laws and claimed through different mechanisms:

Processing Return Orders: Credit Notes in Tally Prime

E-commerce return rates can be 20%–40% for fashion and electronics. Every return must be processed as a Credit Note (Ctrl+F8 in Tally Prime) to reverse the original sales voucher.

If the platform has already charged a return processing fee or has reversed its commission on this transaction, record those adjustments in the same settlement journal voucher for that period. Amazon and Flipkart settlement reports clearly break out return credits and fee reversals per transaction.

Meesho and Flipkart: Key Settlement Differences

• Meesho: Meesho charges zero commission on most categories (as of FY 2024-25), but deducts TDS at 1% under 194O and logistics charges for non-self-ship orders. The Settlement Report is downloadable from the Meesho Supplier Panel weekly.
• Flipkart: Flipkart uses a more complex settlement with separate deductions for fulfilment fees, collection fees, fixed fees, and returns. Create separate expense sub-ledgers for each fee type for accurate P&L analysis.
• Shopify: For Shopify DTC sales, use the payment gateway clearing ledger approach (Razorpay, Cashfree, Stripe) as described in the standard DTC accounting model. Shopify itself does not deduct TDS or TCS — those are collected by the payment gateway operator only if required.

Year-End Reconciliation: Zero-Balance Check on Platform Receivables

At the end of each financial year (March 31), every platform receivable ledger should have a zero or near-zero balance. A non-zero balance means either:

• Outstanding settlement: The platform owes you a final payment from the last cycle of the year. Confirm the expected settlement date and book it as a current asset.
• Missing returns credit note: A return was processed by the platform but not recorded in Tally. Identify the missing credit notes from the settlement report and record them.
• Data entry error: A gross sales voucher was recorded twice, or a settlement journal was posted to the wrong platform ledger.

Run the Outstanding Receivables Report in Tally Prime (Gateway of Tally → Display More Reports → Statement of Accounts → Outstanding → Receivables) filtered by Sundry Debtors group. All platform receivable ledgers should appear here with their balances. Investigate and clear any balance above ₹500 before closing the financial year.

Automate Multi-Channel Accounting with TrulyInvoice

Processing settlement reports from five different platforms — each with a different column structure, currency format, and deduction breakdown — is one of the most time-consuming tasks in e-commerce accounting. Manual entry of gross sales, platform-wise commission splits, TDS, TCS, and returns is error-prone and scales poorly as order volumes grow.

TrulyInvoice is a purchase and sales invoice automation platform that integrates with Tally Prime. It extracts PDF and scanned invoice data from supplier bills and sales reports, maps each line item to the correct Tally ledger, and generates import-ready vouchers with:

• Gross sales booked per order line with correct GST splits
• Commission expense allocated per platform
• TDS Receivable (194O) and GST TCS Receivable (Sec 52) auto-populated
• Return credit notes matched to original sales vouchers
• Bank deposit matched to the net settlement amount for reconciliation

Whether you sell on one platform or six, TrulyInvoice keeps your multi-channel books audit-ready, your GST GSTR-3B ITC claims accurate, and your year-end receivables balanced — all for a flat subscription of plans starting at ₹399/month.