Skip to Content

Withholding tax or Tax collected at source:

In India tax has to be collected at source (by the seller) from buyer on specific items like alcoholic liquor, tendu leaves, timber, other forest produce, on mining/quarrying & scrap. Withholding tax rate or TCS rate is generally 1% – 5% varying from product to product. We will see below process configuration for TCS on sale of affected products by creating a provision for the same in sales pricing procedure.

1. First we will create two condition types say JTCS for charging TCS in sales order & JWTS for posting TCS amount in FI with an offsetting entry. Here, JWTS will be 100% value of JTCS and will be posted from sales order with accrual key say JTS.


2. Include JTCS & JWTS in pricing procedure after regular taxes:

3. Assign withholding tax type in customer master as under:

NOTE: Create condition records for JTCS – 1%  with withholding tax code T1 & JWTS – 100%  with tax code T1 for your key combination in VK11.

Tax collected at source entries in accounting document from sale of scrap will be as under:

Please note Extended withholding tax has to be activated for the company code and relevant FI configuration is required before use of withholding tax in Sales.

FI Configuration is as under:

  1. Define Withholding Tax Keys

After including country code (IN) in basic settings  – check withholding tax countries, a key for withholding tax has to be created. Enter official key 206C for withholding tax – Tax collected at source

2. Now, define withholding tax type for invoice posting

Double-click and choose configuration for T1. Your choice of base amount & rounding rule here have to be backed up with subsequent configuration for the same.

3. Assign condition type JTCS to withholding tax type T1.

4. Define withholding tax code in FI

Assign Withholding tax code for withholding tax type T1.

5. Further, assign withholding tax type to company code and define accounts for the same.

6.Define accounts for withholding tax to be paid over and accounts for withholding tax offsetting entry

7. Define processing key for modified net amount

*****


To report this post you need to login first.

33 Comments

You must be Logged on to comment or reply to a post.

      1. G Lakshmipathi

        Karuna Ravuri

        Only after Abhishek Laghate referring your blog, I have gone through and you have nicely presented.  Keep it up and by the way, I have one query.  You should be aware, for implementing TCS, couple of OSS notes are there and you have not mentioned about those notes in your blog.  So do you mean to say, without implementing those notes also, this can be achieved ?  It is more than 5 years since I touched this area and not able to recollect how I achieved in one of my earlier projects.

        G. Lakshmipathi

        (0) 
        1. Karuna Ravuri Post author

          Hi Lakshmipathi, Thank you for your appreciation!

          Regarding OSS notes, I really need to go through them before commenting. I noted you mentioned two notes in Abhishek’s discussion which I will check and revert back.

          When I along with my FI counterpart did the TCS configuration for one of our clients, we did not refer to any SAP notes, but did google on the subject 🙂

          (0) 
          1. G Lakshmipathi

            Apart from the notes I referred, there are also other couple of notes like 1168591, 1394827, 1873488 etc., which I feel, definitely in your system.

            G. Lakshmipathi

            (0) 
      1. kumaraswamy karre

        Hi Karuna,

         

        I did all the above configuration. My sale orders have more than one item. In accounting document, withholding tax lines(OFF, WIT) appeared only for first item. why offsetting entry is not done for remaining items ?

        Below is my accounting document of invoice having two scrap items. Please help.

        Regards

        Kks

        (0) 
  1. Prashant Chaudhari

    Hi Karuna,

    Thanks for this step by step TCS configuration.

    We have done all configuration as per your suggestion but FI document result is not correct.

    Withholding tax percentage is 1 %.  While posting document, WHT calculated on Base amt + Vat +SD tax ZTC*1% (100000 + 12500 + 1125*1% = 1136.25) however it should be Base amount + Vat *1%  (100000 + 12500*1% = 1125)

    Can you please urgently advise why we are not getting correct result ?

    Capture.PNG

    (0) 

Leave a Reply