"Tax collection at Source" (TCS) on sale of goods for India in Dynamics 365

Applies to: Dynamics 365 for Finance and Operations

Summary


TCS on sale of goods

This document covers the functionality of the Tax collection at Source (TCS) on sale of goods. This feature describes how to do the basic setup for TCS
  deduction on sale of goods transaction, calculate TCS on transactions from customer or on group of customer , TCS on transaction when customer do not have PAN number, and so on. 

 

As per section 206C (1H) TCS should be collected at the time of receipt of payment from customer in view of this interim accounting is introduced for this feature. Where TCS amount will be posted to interim account and added to invoice value at the time of issuance of invoice and liability of TCS will be recorded in the books at the time of receipt of payment.

 

Another important aspect of this feature is that if multiple customer have same PAN number than accumulate transaction amount will be taken to compare with threshold limit to determine the eligibility of transaction for TCS deduction.

image.png

Base amount for TCS deduction:

No specific clarification is available regarding base amount for TCS deduction on sale of goods, in absence of any specific provision or circular or clarification by CBDT, it is unclear as to whether TCS will be levied on GST charged in invoice or not.

 

There are two views whether TCS on Sales value including GST or excluding GST. Both views are supported by different analysis. However, till the clarification by CBDT, it will be more appropriate that TCS should be collected on Sales Value including GST.

 

 

PAN based accumulation of transaction of multiple customers:

In case of TCS on “sale of goods” deduction of TCS will be made based on PAN number. If multiple customers have same PAN number than all transactions executed by different customers have same PAN will be accumulated and compared against threshold limit prescribed by the government.

 

User has option to accumulate purchase threshold based on PAN number of vendors like customers. However, accumulation will take place based on vendor or customer within one legal entity. Inter legal entity accumulation will be out of scope.

 

 

The point of collection of tax

 

As per the interpretation of TCS on sales of goods u/s 206C (1H), tax should be collected ‘at the time of receipt’ . It is clarified under law that TCS on sales of goods will be collected when actual payment is received by the seller.

However to collect TCS on sale of goods, the seller needs to raise sale invoice including the amount of TCS, account in the books as a TCS liability even in actual sense it is not payable. Even though the TCS amount is debited to the buyer, the liability under Section 206C (1H) does not arise until the time the amount is collected. In order to cater this requirement new option “Tax liability on payment” is added under “Withholding tax group”.

On marking this option system will activate “interim account” field under the withholding tax code. At the time of posting of sale of goods invoice Tax amount will be posted to “Interim TCS payable account” and debit to “customer account”. When user receive payment from buyer at that time system generate “Related voucher” for posted invoice transaction to accrue TCS liability on payment.

 

TCS on Advance receipt of payment:

 

Every time the seller receives part of the sale consideration in advance, the seller is mandated to deduct TCS under Section 206C(1H). The difficulty arises in the calculation of the amount when TCS is deducted on multiple advance payment transaction and when payments transactions are adjusted against Invoice amount. Currently in the system user must manually adjust the TCS amount computed on invoice transaction to ensure that TCS amount on invoice is equal to TCS amount on payment.

The feature is supported in followingor later versions of Finance:

Dynamics 365 Finance versions:

  • 10.0.12
  • 10.0.13

Symptoms


None

Cause


None

Setup


Steps to dosetup for TCS on sale of goods:

Please notethat it is mandatory for user to apply “Advance threshold” feature to enablededuction of TCS on sales of goods scenarios.

Create new withholding tax code “Saleof goods”:

Tax>Setup>withholding tax code>Sale of goods

When user attach “withholding taxcomponent” of type “TCS” new field “Interim account” will enable.

Do not select any account until mark checkbox “Tax liability on payment” under “Withholding tax group.

Select “Enable threshold hierarchy”- “Yes”.

On selection of “Yes” “PAN basedaccumulation “option will enable

User can mark this option if dealing withcustomers have same PAN number.

 

image.png

 

Create new withholding tax group “Sale of goods.”

Tax>setup>withholding taxgroup>Sale of goods

Create withholding tax group with tax type“TCS” and mark check box “Tax liability on payment”-Yes.

After this go back to withholding tax codeform and select  “ “Interim TCS payableaccount” in the field “Interim account” created in the chart of account with posting type “India withholding tax(TCS)

Include GST tax component if part of TCSbase amount calculation under field “Include GST tax component for TDS or TCScalculation “

If charges are not part of TCS calculationselection “Yes” under field “Exclude charges for TDS or TCS calculation”

Click on “Designer” button on action paneand define TCS calculation formula.

 

image.png

Define Threshold definitions:

Navigateto Tax > Setup > Threshold definitions.

Define threshold definition for “Sale of goods.”

Two threshold slabs have to be defined.

  • 0-Max
  • Max-0
image.png

TCS Threshold setup for “Sale ofgoods”

TCS on sales of goods apply on single customer ormultiple customers having same PAN number.

If customer PAN number is not available higher taxrate will apply after crossing the exempted turnover amount.

If customer have PAN number than lower tax rate willapply.

Users need to define threshold reference forcustomers:

image.png

Click on Threshold designer

Define two slabs with option:

  • With PAN number
  • Without PAN number

Define separate TCS rate for each option.

When defining calculation basis forexempted slab

  • Calculate tax – No

(Anotheroption Calculate tax – Yes and value – 0) 

  • Calculate previous non-tax transactions-No.
  • Include in turnover base – Yes.

When defining calculation basis for Taxableslab

  • Calculate tax – Yes.
  • Calculate previous non-tax transactions-No.
  • Include in turnover base – Yes.

  

image.png

 

Activate calculation of TCS forcustomer:

Accounts Receivable>Customers >All customers

image.png

Postingof Invoice:

Wheninvoice is posted, and the accumulated transaction cross the threshold limitfollowing accounting entry is posted:

 

image.png

TCS rate @0.1% (If PAN number is available ) 

 

Invoice isposted as below:

 

image.png

   

TCS liabilitywill arise on collection of payment.

When userreceive payment and attach Invoice with payment transaction, TCS amount iscomputed on full payment amount and reverse through related voucher. However,one more related voucher is generated with Invoice to show tax liabilityrecognition in books for eligible amount only.

 

image.png

Relatedvoucher will generate as below:

image.png

Important:

One more related voucher will generate withposted sales Invoice to book actual TCS liability.

Users have to go to posted sales invoicevoucher and check the related voucher entry.

image.png

 
Note: In case of purchase transaction wherevendor is deducting TCS, user have to create new TCS withholding group

TCS on Purchase of goods deducted by vendor:

In case TCS is deducted against theorganization by the selling vendor, user must create separate withholding taxgroup “TCS on purchase of goods”. In the “Withholding tax group” under fieldgroup “Apply threshold” mark check box “PAN based accumulation “. User mustdefine threshold definition for vendor and attach withholding tax group withthe­ respective vendor. On posting purchase order TCS amount deducted by vendorposted to TCS recoverable account.

Every Organization will claim credit of TCSdeduction after reconciling the deduction with Form 26AS.

Go toTax>>Inquiries and reports>TDS/TCS inquiry

User can select required column fields togenerate report.

image.png
 

click ok to run the report. 

More information


You can contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit one of the following Microsoft websites:

Partners

https://mbs.microsoft.com/partnersource/resources/support/supportinformation/Global+Support+Contacts

Customers

https://mbs.microsoft.com/customersource/northamerica/help/help/contactus

In special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.