Report E-Commerce Sales in GSTR-1 Table 14 Tally Prime
Report E-Commerce Sales in GSTR-1 Table 14 Tally Prime
Learn how to report E-Commerce Operator (ECO) sales in GSTR-1 Table 14 in Tally Prime under Section 52 TCS and Section 194O TDS compliance.
Who is this for: GST & E-Commerce
Quick Answer: How to Report E-Commerce Operator Sales in GSTR-1 Table 14?
In Tally Prime Release 4.1+: Open GSTR-1 > Press Ctrl+H (Change View) > Select 'e-Commerce Summary'. Use Table 14(a) to report supplies made through ECOs liable to 1% TCS under Section 52 (Amazon, Flipkart, Meesho). Use Table 14(b) for supplies where ECO pays tax under Section 9(5).
- Table 14(a): Supplies via ECO liable to TCS under Section 52 (1% TCS).
- Table 14(b): Supplies via ECO liable to pay tax under Section 9(5).
- Section 194-O Income Tax TDS is 0.1% on gross sales (Form 26Q), separate from GST Table 14.
- Tally Prime Release 4.1+ provides an e-Commerce Summary view (Ctrl+H) for GSTR-1.
GSTR-1 Table 14 Breakdown: 14(a) vs 14(b)
Applies to goods sold on platforms like Amazon, Flipkart, Meesho, or Tata CLiQ where the ECO collects 1% TCS. The seller pays GST in GSTR-3B and reports ECO-GSTIN summary in Table 14(a).
Applies to services (e.g. passenger transport, accommodation, or food delivery via Swiggy/Zomato) where the ECO is statutorily liable to pay the GST. Values auto-populate to GSTR-3B Table 3.1.1(ii).
Step-by-Step SOP: Generating E-Commerce Summary in Tally Prime
Create/Alter Party Ledger for Amazon/Flipkart. Set Registration Type: e-Commerce Operator and enter valid ECO GSTIN.
Pass Sales Voucher (F8). Select e-commerce sales ledger and link the ECO party in dispatch/party details.
Go to GSTR-1 Report > Press Ctrl+H (Change View) > Select e-Commerce Summary to view consolidated ECO-wise sales.
Copy the ECO GSTIN, taxable value, and tax breakdown from Tally e-Commerce Summary into GSTR-1 Table 14(a) on the GST portal.
Automate Purchase Invoices for E-Commerce Businesses
Post vendor PDF bills for packing materials, logistics, and warehousing to Tally in 15 seconds.
E-commerce sellers receive dozens of vendor bills for courier freight, corrugated boxes, and warehousing fees. TrulyInvoice AI reads vendor PDF invoices, extracts line items, HSN codes, and tax rates, and posts clean F9 Purchase Vouchers to Tally Prime via Port 9000 local sync in 15 seconds.
Founder & Chief Architect of TrulyInvoice