How do I account for Amazon/Flipkart commissions in Tally?

Commission fees are recorded as expense ledger entries (grouped under Indirect Expenses). You must also claim the input tax credit (ITC) on the GST charged by the platform.

How is TCS (Tax Collected at Source) booked in Tally?

TCS values collected by e-commerce platforms must be debited to a 'TCS on GST Receivable' ledger (grouped under Duties & Taxes) to offset your monthly tax liabilities.

What is the best way to handle customer returns in Tally?

Group return transactions by order ID and import them as Credit Notes, adjusting the stock balances in your main inventory ledgers.

Can TrulyInvoice parse Shopify order invoices?

Yes. TrulyInvoice extracts customer details, taxable values, items, and tax details from Shopify PDF order invoices and pushes them to Tally Prime.

E-Commerce Vendor Purchase Invoice Automation in Tally Prime

E-commerce businesses operate at a high transaction volume. Selling across Amazon, Flipkart, and Shopify results in thousands of sales and returns monthly.

Reconciling platform settlement reports—which contain shipping fees, commission rates, customer returns, and TCS deductions—is a major accounting challenge. This guide details how to structure e-commerce settlements, map platform fees, and automate ledger sync.

Quick Answer: How to Automate E-Commerce Vendor Purchase Entry in Tally Prime (2026)?

TrulyInvoice automates e-commerce supplier purchase bill entry in Tally Prime by using Google Gemini AI OCR to extract vendor invoice PDFs, Shopify supplier bills, and warehousing tax invoices into F9 purchase vouchers via Port 9000 local sync.

Extracts supplier PDF invoices and vendor bills with 96% AI OCR accuracy.
Auto-matches vendor SKU names with Tally Prime inventory masters.
Validates GSTIN formats and auto-splits CGST/SGST vs IGST tax allocations.
Flat plans starting at ₹399/month subscription includes unlimited vendor invoice sync.

1. Deciphering E-Commerce Settlement Reports

A platform settlement sheet details outward sales values, refunds, and service fees. Identify these key fields:

Gross Sales: The total amount paid by customers.
Platform Commissions: Fees charged by Amazon or Flipkart.
Shipping & Pickpack Fees: Logistics costs charged by the platform.
TCS Deductions: Tax collected at source under GST regulations.

2. Mapping Platform Commissions and GST Input Credits

E-commerce marketplaces issue monthly invoice summaries for their services. To record these entries in TallyPrime:

Debit the Marketplace Commission Expense account (Indirect Expenses) and the corresponding CGST/SGST or IGST tax input accounts. Credit the **Marketplace Outstanding** ledger to balance the settlement entries. This allows you to claim the correct tax credits on platform fees.

3. E-Commerce Settlement Ledger Grouping Schema

Settlement Component	Tally Ledger Target	Ledger Group	Accounting Posting
Gross Sales Value	E-Commerce Sales Ledger	Sales Accounts	Credit
Platform Referral Fees	Marketplace Commission Expense	Indirect Expenses	Debit
TCS Deductions	TCS on GST Receivable	Duties & Taxes	Debit
Net Cash Received	Bank Current Account	Bank Accounts	Debit

4. Managing Customer Returns and Credit Notes

Customer returns are common in e-commerce. Match returned stock item codes against original sales references. Group return details by order ID and import them as Credit Notes in TallyPrime to adjust your inventory balances automatically.

5. Reconciling Payment Gateway Accounts

For Shopify or custom brand websites, reconcile payment gateway accounts (such as Razorpay, Stripe, or Paytm). Track gateway fees, transaction charges, and customer chargebacks in separate expense accounts to keep your bank records accurate.

Simplify E-Commerce Reconciliations and Accounting

TrulyInvoice parses vendor bills and customer PDF invoices from Amazon, Flipkart, and Shopify, extracting items, quantities, and GST rates for clean sync to Tally.

Start 14-Day Free Trial