How do I account for Meesho customer returns in Tally?

For customer returns or RTO (Return to Origin) orders, you must record a Credit Note in Tally. This reverses the gross sales ledger and reduces your tax liability by matching the original invoice's SGST/CGST/IGST rates.

What is the correct journal entry for Meesho TCS and TDS under Section 194O?

You must debit 'TCS Receivable' and 'TDS 194O Receivable' (under Current Assets) and credit the 'Meesho Ledger' (Sundry Debtor) to reflect the tax deductions made by Meesho before releasing your payout.

Can I directly import Meesho e-commerce sheets to Tally Prime?

Tally Prime does not natively parse Meesho payout formats. Sellers must clean the sheet manually or use a PDF/Image parser like TrulyInvoice to extract the raw transaction rows into formatted vouchers before syncing.

How to Import Meesho Seller Sales Statements in TallyPrime

Managing accounts as a Meesho seller can quickly become overwhelming. Unlike traditional wholesale businesses that generate 10–20 large invoices a month, active e-commerce merchants on Meesho process thousands of individual orders, micro-payouts, RTO (Return to Origin) claims, and e-commerce tax deductions.

If you try to type each order manually into TallyPrime, you will exhaust your accounting team. Instead, a structured e-commerce bookkeeping workflow is required to reconcile Meesho payouts, sales, returns, and taxes.

Understanding the Meesho Payout Sheet Structure

Every week, Meesho releases payouts to its sellers along with a detailed settlement spreadsheet. To account for this data in Tally, you must understand the key components of the payout calculation:

Column/Charge Name	Accounting Group in Tally	Effect on Payout
Gross Sale Amount	E-commerce Sales A/c (Sales)	Addition
Customer Returns	Sales Returns A/c (Sales)	Deduction
TCS under GST (1%)	GST TCS Receivable (Current Assets)	Deduction (Withheld)
TDS u/s 194O (1%)	TDS 194O Receivable (Current Assets)	Deduction (Withheld)
Shipping & Return Charges	E-commerce Marketplace Fees (Indirect Expenses)	Deduction

Step-by-Step Tally Ledgers Setup

Before importing or entry posting, ensure the following ledgers are created in your Tally company:

Meesho Sundry Debtor Ledger: Name it Meesho Marketplace under Sundry Debtors. Disable 'Maintain bill-by-bill' unless you do manual reconciliation.
Sales Account: Create Meesho Sales A/c under Sales Accounts. Ensure GST is applicable.
TDS Section 194O Ledger: Create TDS 194O Receivable under Current Assets. This tracks the 1% tax withheld by Meesho.
GST TCS Ledger: Create GST TCS Receivable under Current Assets.
Return Shipping Charges: Create Meesho Shipping Expense under Indirect Expenses with GST applicability.

The Standard Double-Entry Bookkeeping Flow

To maintain 100% compliance with GST and Income Tax laws, a complete cycle requires four distinct entries:

1. Booking the Gross Sales (Sales Voucher - F8)

Debit the Meesho Sundry Debtor and credit your Sales and GST accounts:

Debit: Meesho Marketplace (Sundry Debtor)  -- [Gross Sale + GST] Credit: Meesho Sales A/c (Sales)           -- [Taxable Value] Credit: Output SGST / CGST / IGST          -- [GST Component]

2. Booking Returns (Credit Note - Alt+F6)

When customer returns occur, issue a Credit Note to reverse the sale value and GST liability:

Debit: Meesho Sales Return A/c             -- [Taxable Value] Debit: Output SGST / CGST / IGST           -- [GST Reversed] Credit: Meesho Marketplace (Sundry Debtor) -- [Total Return Value]

3. Recording Payout Deductions (Journal Voucher - F7)

Since Meesho sends you net payouts, you must record the withheld TDS/TCS and fees to balance the Sundry Debtor account:

Debit: TDS 194O Receivable                 -- [1% of Gross Sales] Debit: GST TCS Receivable                  -- [1% of Net Sales] Debit: Meesho Shipping Expense             -- [Return Shipping Charges] Debit: Input SGST / CGST (on shipping fees)-- [GST on Shipping] Credit: Meesho Marketplace (Sundry Debtor) -- [Sum of all Deductions]

4. Payout Settlement Receipt (Receipt Voucher - F6)

When the deposit hits your bank account, clear the debtor account:

Debit: Bank Account (HDFC/ICICI/SBI)       -- [Actual Payout Received] Credit: Meesho Marketplace (Sundry Debtor) -- [Settlement Cleared]

Streamlining E-Commerce Accounting

Manually entering these details for hundreds of rows every week is highly prone to human error. That is why smart accountants use PDF parser utilities like TrulyInvoice.

TrulyInvoice automatically reads your bank statements and invoices, extracts transaction details, and syncs them directly into Tally Prime for plans starting at ₹399/month.