How to Record TCS on Sale of Goods in TallyPrime

TCS on sale of goods (Section 194O) is a tax collected at source on specified goods sold by GST-registered dealers in India. TallyPrime automates TCS calculation, ledger posting, and reporting when properly configured under F11 Features.

What is TCS on Sale of Goods?

Tax Collected at Source (TCS) under Section 194O of the Income Tax Act applies to the sale of certain specified goods by GST-registered dealers. The buyer is required to deduct TCS at a prescribed rate and remit it to the government. Common TCS-liable goods include steel and iron products, cement, chemicals, and a growing list notified by the Central Board of Direct Taxes (CBDT). Unlike TDS on professional fees or contractor payments, TCS on sale of goods is triggered by the sale transaction itself, not a service or contract.

The threshold for TCS applicability is typically Rs 50 lakh per financial year per buyer. Once the cumulative sale value to a single buyer exceeds this limit, TCS must be collected on all subsequent invoices to that buyer in the same financial year. This makes accurate tracking and compliance critical for businesses using TallyPrime.

Why TCS Matters for GST-Registered Businesses

If your business sells specified goods and is GST-registered, TCS compliance is non-negotiable. Failure to collect or remit TCS can result in penalties, interest, and legal action. TallyPrime helps you stay compliant by automating TCS calculation on eligible invoices, maintaining a clear audit trail, and generating reports for filing with income tax authorities. Moreover, TCS collected is a liability that must be tracked separately and reconciled with bank deposits before filing Form 27EQ.

Enabling TCS in TallyPrime

To enable TCS in TallyPrime, follow these steps:

1. Open TallyPrime and go to Gateway of Tally.
2. Press F11 to open Features.
3. Navigate to Statutory & Taxation.
4. Select TCS (Tax Collected at Source).
5. Set the status to Yes to enable TCS.
6. Configure TCS rates, item categories, and thresholds as per current CBDT notifications.
7. Save and exit.

Once enabled, TallyPrime will prompt you to create TCS ledgers and link them to sale transactions. You can also set item-wise TCS applicability under the Item Masters.

Creating a TCS Ledger in TallyPrime

A TCS ledger is a liability account where you record TCS amounts collected from buyers. To create a TCS ledger:

1. Go to Gateway of Tally > Create/Alter > Ledger.
2. Enter a name such as "TCS on Sale of Goods" or "TCS - Section 194O".
3. Set the ledger type to Duties & Taxes.
4. Under Tax Type, select TCS.
5. Assign the appropriate tax rate and item categories.
6. Save the ledger.

You can create multiple TCS ledgers if you want to track TCS by category (e.g., separate ledgers for steel, cement, and chemicals). This granular approach helps with reconciliation and reporting.

Configuring Item Masters for TCS

For TCS to auto-calculate on invoices, you must flag items as TCS-liable in the Item Master. To do this:

1. Go to Gateway of Tally > Create/Alter > Item.
2. Open the item that is subject to TCS (e.g., steel rods, cement bags).
3. Under Tax Details, enable TCS and select the applicable rate and category.
4. Save the item master.

TallyPrime will now automatically apply TCS to any sale invoice containing that item, provided the buyer has crossed the annual threshold.

Recording a Sale Invoice with TCS

When you create a sale invoice in TallyPrime for a TCS-liable item, the software auto-calculates TCS if the cumulative sale to that buyer exceeds the threshold. Here is a worked example:

Scenario: ABC Steel Traders (GST-registered) sells steel rods to XYZ Construction Ltd. The TCS rate is 0.75%. The annual threshold is Rs 50 lakh. In the current financial year, XYZ Construction has already purchased Rs 52 lakh worth of steel from ABC. ABC now issues an invoice for Rs 10 lakh.

Calculation:

• Invoice value: Rs 10,00,000
• TCS rate: 0.75%
• TCS amount: Rs 10,00,000 x 0.75% = Rs 7,500
• Net amount to be received: Rs 10,00,000 - Rs 7,500 = Rs 9,92,500

In TallyPrime, when you create this invoice, the software will automatically deduct Rs 7,500 as TCS and post it to the TCS ledger. The sale will be recorded at the full value (Rs 10 lakh) in the sales ledger, and the TCS liability will appear in the TCS ledger as a payable.

TCS Rates and Item Categories

TCS rates vary by item category and are notified by CBDT from time to time. Common rates as of 2024-25 are:

Item Category	TCS Rate	Threshold
Steel and iron products	0.75%	Rs 50 lakh per buyer per FY
Cement	0.75%	Rs 50 lakh per buyer per FY
Chemicals (specified)	0.75%	Rs 50 lakh per buyer per FY
Brass and copper items	0.75%	Rs 50 lakh per buyer per FY
Mineral ores	0.75%	Rs 50 lakh per buyer per FY

Always verify current rates with the latest CBDT circulars before configuring TallyPrime, as rates and item lists are updated periodically.

Tracking TCS Collections and Reconciliation

TallyPrime maintains a running total of TCS collected. To view your TCS position:

1. Go to Gateway of Tally > Display More Reports > TCS Reports.
2. Select the report type (e.g., TCS Summary, TCS by Item, TCS by Buyer).
3. Review the amounts collected and ensure they match your bank deposits.

Reconciliation is critical. TCS collected must be remitted to the government within the prescribed time. Any discrepancy between TCS recorded in TallyPrime and actual deposits should be investigated and corrected immediately.

Filing Form 27EQ and TCS Returns

Form 27EQ is the quarterly return of TCS collected under Section 194O. You must file this form with the income tax authority by the due date, typically 15 days after the end of the quarter. TallyPrime generates TCS reports that provide the data needed for Form 27EQ:

• Total TCS collected in the quarter
• TCS by item category
• TCS by buyer
• Dates of collection and remittance

Export these reports from TallyPrime and cross-check them with your bank statements before filing. Any mismatch can delay processing or trigger an income tax notice.

Common TCS Errors and How to Avoid Them

Many businesses make mistakes with TCS in TallyPrime. Here are the most common ones and how to prevent them:

• Not flagging items as TCS-liable: If you forget to enable TCS in the Item Master, TallyPrime will not auto-calculate it. Always verify item masters before creating invoices.
• Incorrect threshold tracking: TCS applies only after cumulative sales to a buyer exceed the annual threshold. Ensure TallyPrime is configured to track cumulative sales correctly.
• Wrong TCS rate: Using an outdated rate can lead to under-collection or over-collection. Update rates as soon as CBDT issues new notifications.
• Missing TCS ledger reconciliation: Reconcile TCS ledger balances with bank deposits monthly. Discrepancies should be investigated immediately.
• Late Form 27EQ filing: File Form 27EQ on time. Late filing attracts penalties and interest.

Integrating TCS with GST in TallyPrime

TCS and GST are separate taxes but often apply to the same transaction. In TallyPrime, GST is calculated on the full invoice value, while TCS is deducted from the buyer's payment. The sale is recorded at the full GST-inclusive value, and TCS is a separate liability. TallyPrime handles this automatically if both GST and TCS are enabled. However, always verify that GST is calculated correctly on the gross amount before TCS deduction, as per tax rules.

TCS on Sale of Goods vs. Other TCS Categories

TCS applies to multiple categories under the Income Tax Act. Section 194O specifically covers TCS on sale of goods. Other TCS sections include 194C (contractors), 194H (commission on sale of goods), and 194I (rent). TallyPrime allows you to configure and track each TCS category separately. If your business is subject to multiple TCS sections, create separate ledgers and configure each in the Features menu to avoid confusion and ensure accurate reporting.

Backup and Data Security for TCS Records

TCS records are critical for compliance. Always maintain regular backups of your TallyPrime company file. Use the backup feature under Gateway of Tally > Backup to create local copies. If you use Tally on Cloud, backups are automated daily. In case of data corruption, you can restore from a backup. For sensitive TCS data, consider using TallyPrime's role-based access control to restrict who can view or modify TCS entries.

Upgrading Your TallyPrime License for TCS Compliance

TCS features are available in both TallyPrime Silver and Gold editions. Silver (single user, perpetual) is priced at Rs 22,500 + 18% GST, while Gold (unlimited users on LAN, perpetual) costs Rs 67,500 + 18% GST. Both include 1 year of free Technical Support Services (TSS). If you need multi-user access for your finance team to collaborate on TCS reconciliation and reporting, consider upgrading from Silver to Gold (upgrade cost: Rs 45,000 + GST). TSS renewal costs Rs 4,500 per year for Silver and Rs 13,500 per year for Gold, ensuring you always have the latest TCS updates and support.

Getting Expert Help with TCS Setup

Setting up TCS correctly in TallyPrime requires understanding both tax rules and software configuration. If you are unsure about TCS applicability, rates, or how to configure TallyPrime, consult a Tally-certified professional. Global IT Care is a Tally 3 Star Certified Partner in Purnea, Bihar, serving businesses since 2010. Our experts can help you enable TCS, configure item masters, reconcile collections, and ensure timely compliance with Form 27EQ filing. We also offer TallyPrime training and support to help your team master TCS and other statutory features. Contact us today at +91 75469 00951 to schedule a consultation and ensure your TCS compliance is accurate and on time.