SAP Withholding Tax India (CIN) | ERP软件技术分享

Former Member

July 14, 2013 7 minute read

Withholding Tax India (CIN)

FollowRSS feedLike

25 Likes 21,621 Views 44 Comments

Withholding tax is a tax deducted at the beginning of payment flow. Amount withheld paid and reported to the tax authority on behalf of the person who is subject to tax. Two type of withholding tax

1. Classical Withholding tax

2. Extended withholding tax

Here we will see extended withholding tax setting.

Configuration by table maintenance, Tcode SM30 >>> Enter table name >>>> click maintain.

Step-1 Check Withholding Tax Countries (V_T005Q)

Withholding tax country is needed to maintain relevant tax code party master record and also print the withholding tax form.

C……..W………Description

IN……..IN………India

Step -2 Define Withholding Tax Keys (V_T059O)

The withholding tax keys correspond to the withholding tax laws according to which tax is withheld. The system can therefore assign the withholding tax items to the correct withholding tax return

Enter country key – IN

New Entry –

Step -3 Define Reasons for Exemption (V_T059V)

you define reasons for exemption from withholding tax. You can enter this indicator in the vendor master record or in the company code withholding tax master record information.

Enter country key – IN

New Entry –

Setp -4 Define Sect.code (J_1I_SECCODE)

Business places are the location where tax is deducted.

New Entry –

Setp 5 Define Business palce (J_1BBRANCV)

Business places are the location where tax is deducted .i.e location from where business of the company is carried out. Business place may head office, branch office, regional office etc which may have separate TAN. When post transaction business place must be enter, toensure that transaction is assigned to correct tax entity

And activate business place for country India (VIDBUPLA_ACTIVE)

C…….BP active

IN……chk

Withholding tax type used to classify different type of withholding tax in a country. Withholding type controls the essential calculation options. Two type of tax

1. Withholding tax type for invoice posting

2. Withholding tax type for payment posting

Step – 6 Define Withholding Tax Type for Invoice Posting (V_T059PI)

Tax type controls the essential calculation options. The withholding tax type must enter in the customer/vendor withholding tax master data. The withholding tax type for entering a invoice and for posting of payment.

Country key – IN

Step – 7 Define Withholding Tax Type for Payment Posting (V_T059PP)

Country key – IN

Save

Step 8 Check Recipient Types (V_T059C)

This is required to categorize the vendors. i.e company or non-company

Enter country key – IN

New Entry –

Step-9 Define Withholding Tax Codes (V_T059Z)

The withholding tax code only controls the percentage rate of the withholding tax.

Country key – IN

New Entry

Step-10 Assign Withholding Tax Types to Company Codes (V_T001WT)

By assign tax type to company code, by doing this, the tax type can be used for the specific company only.

Step -11 Activate Extended Withholding Tax (V_T001_EXT)

go to cocd Ext.w/tax ….chk

Step -12 Define Accounts for Withholding Tax to be Paid Over (T code – OBWW)

Here we defined GL accounts to which the system will post tax amount.

Enter Chart of accounts –

Click Rule-

Select Debit/Credit

Click Account- Enter relevant account

Step -13 Maintain Number group (J_1IEWTNUMGR_N)

set up the numbering for the remittance challans. In this activity, you group together the permutations of company code, business place, and official withholding tax key that you want to remit withholding tax for.

Step -14 Assign number range (J_1IEWTNUM)

Number……..in

10…………….03

Step -15 Maintain Number Range (T code – J1INUMBER)

press F6———– (select group) ——– Shift+F5 —————- Wnter cocd —— year —– from number ——–to number

Step -16 Same steps repeats for Withholding Tax certificate For vendors and customers (above three steps) in following three areas.

J_1IEWT_CERT_N,

J_1IEWT_CERTNO,

T code – J1INCT

Steps -17 Maintain company code setting (J_1IINDCUS)

Step -18 check party master record in company code “withholding tax accounting”. (FK01/FK02/FK03) This field should filled accordingly.

In vendor master record, assign tax type, tax code and recipient type to the master record. Which will be used to deduct tax during transaction postings.

Enter a vendor invoice FB60

Additional Seting

Defining Withholding Tax Type for ECESS at Invoice/payment Posting This tax type is used for calculating Education Cess on tax and posting the tax amount at the time of creating invoice/payment. The configuration is similar to the previous section except that the field – Inherit base should be checked. Then define dependencies between withholding tax categories.

Tax due date can be maintain in table J_1IEWTDUEDATE: In India withholding tax due date is 7th of next month. Enter 777 for the due date

Defining Withholding Tax Type for ECESS at Invoice/payment Posting this tax type is used for calculating Education Cess on tax and posting the tax amount at the time of creating invoice/payment. The configuration is similar to the previous section except the field – Inherit base should be checked i.e for cess tax type setting select “Inherit base”. Then define dependencies between withholding tax categories.

In India there is some thrash hold for deduction, exemption limit upto certain amount at specified rate within time frame. There is no such setting in current SAP system. Refer note 1415026. But we can manage to some extend in SAP.

Case 1

In a fiscal year

Upto 30000 at 2%

More than 30000 at 10%

For this we use formula. In tax code don’t put any percentage, select “W tax form.” and in tax type select accumulation type. And maintain formula for the tax type and tax code.

Case -2

Tax will be deducted for limited period at lower rate. For this you may enter vendor master record, valid period for the tax type.

Special Transactions

Down payment requests and payment requests

When you post down payment requests and payment requests, the system only calculates the withholding tax base amounts.

Document parking

The system does not calculate any withholding tax base amounts when you save or change parked documents, only when they are posted.

Document holding

When documents are held, the system does not calculate any withholding tax amounts/base amounts.

Posting with reference

When you post documents using a reference, the system defaults withholding tax base amounts, but not any existing withholding tax amounts. The system does not calculate any withholding tax base amounts/tax amounts when you enter a reference document

Recurring entry documents

The system does not calculate any withholding tax base amounts/tax amounts when you enter a recurring entry document.

Summary

The basic withholding tax settings for India (Country India Version) will include the following sub processes which are commonly used within the main process.

Defining withholding tax keys

Defining branch offices (Section codes)

Defining withholding tax type invoice & payment posting

Defining withholding tax type for ECESS at Invoice posting

Maintaining surcharges

Defining withholding tax codes

Defining GL accounts to post the withholding tax

Maintenance of number ranges for tax certificates and Challan

1. Withholding Tax Countries The withholding tax country is needed for printing the withholding tax form.

2. Withholding Tax Keys to identify the different withholding tax types. you can define these official names for your tax codes here i.e 194C, 194J 192 etc. The official withholding tax key will assign to relevant withholding tax code.

3. Recipient Types The type of recipient categorizes the vendor i.e company/non-company

4. Business Places/section code Create a business place for each (TAN), which is responsible to deduct tax and report to tax authority accordingly. A system object that represents the organizational unit responsible for collecting and remitting withholding tax, as identified by a TAN. When you post a document with a withholding tax item, enter the section code in order to make sure that the tax item is assigned to the correct TAN.

5. Withholding Tax Type The withholding tax type governs the way in which extended withholding tax is calculated and is defined at country level. There two type of withholding tax type, withholding tax types for calculating tax at invoice posting and another one forcalculating tax at payment posting. You must enter the withholding tax type in the customer/vendor withholding tax master data .

6. Withholding Tax Code The withholding tax code determines the withholding tax percentage and tax base. You make the settings for each country and withholding tax type. You can therefore define as many withholding tax codes as required for each withholding tax type.

7. Posting Define account determination for the tax.

8. Assign Withholding Tax Types to Company Code. Now specific company code can deduct tax from business partner against specific tax type for specified period.

Alert Moderator

Assigned tags

FIN (Finance)

SAP ERP

enterprise resource planning

erp financials

sap erp financials

Related Questions

Withholding tax Minimum base amount Vs Exemption Threshold in TAN Exemption for India/CIN

By Gurram Nethaji, Nov 26, 2018

Customer withholding tax

By Former Member, Sep 11, 2008

Output withholding tax in Purchase Order

By Former Member, May 07, 2011

44 Comments

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

Murali Babu Nallamothu

September 14, 2013 at 1:56 am

Thanks Nakul for such a useful document.

Like(0)

Former Member Post author

September 15, 2013 at 11:33 am

Thank you

Regards

Nakul

Like(0)

Diwa p

September 17, 2013 at 1:55 pm

Hi Nakul,

please help me.

our Client has requirement in CIN. client wants to calculate TDS up to 10000000 3%. If it exceeds 10000000 tax rate 10%. as you mentioned in post about the configuration i have configured according to you. in that configuration i am able to restrict the amount upto 10000000 3% where as after 10000000 i can able to restrict this to 10%. please help me on this.

Regards

Diwa

Like(0)

Diwa p

September 17, 2013 at 1:56 pm

i cannot able to restrict 1000000 to 10%

Like(0)

Former Member Post author

September 18, 2013 at 6:25 am

Hi Diwa

Step 1 : Check tax type. In tax type select appropriate Accumulation type. If your company use calender year, accumulation type will be “per calender years” otherwise select “per year, starting with month” and enter starting month.

Step 2: Check tax code. dont put any tax rate in calculation area. select w. tax from.

Step 3: enter tax formula for the tax code like:

To base amount whldtax Redrt Redu. Base amt

10000000 3,00

999999999999 10,00 10000000

save

Impact: in a year, upto 10000000 rate will be 3%, if the amount exceed this amount, amount above 10000000 will be applied 10%

Regards

Nakul

Like(0)

Diwa p

September 19, 2013 at 6:35 am

Thanks a lot Nakul.

regards

Diwa

Like(0)

Former Member

September 24, 2013 at 5:06 pm

Hi Diwa,

Can u let me know, which section code your client is to be required.

Like(0)

Former Member

September 17, 2013 at 2:01 pm

Hi Nakula.

Congratulation by developed document and thank you for sharing it with us.

Best Regards.

Jandoval Nascimento

Like(0)

Former Member Post author

September 18, 2013 at 5:37 am

Hi Jandovai

Thanks

Regards

Nakul

Like(0)

Diwa p

September 24, 2013 at 9:05 am

Hi Nakul,

i followed your configuration its working fine.here we have one scenario we had set limit for

up to 1000000 3 % more than 100000 tax rate will be 10%. here we have posted invoice for 200000 entry will be expenses a/c…..Dr 200000

vendor a/c..Cr 187000

Tds payable Cr 13000

here user wants two tds gl account one tds gl account for exemption amount that is 3000 another gl account with 10000 how to do it Please help me on this.

Thanks&Regards

Diwa

Like(0)

Former Member Post author

September 24, 2013 at 9:17 am

Hi Diwa

As mentioned it is not possible in SAP currently.

(different tax rate for certain period for specific amount)

Two way to control TDS slabs.

First: Define two tax code, one for 3% and another 10%. In vendor master mention time period for the tax code.

Second: use formula for different tax code

Regards

Nakul

Like(0)

Diwa p

September 24, 2013 at 12:54 pm

Thanks

Like(0)

Former Member Post author

September 24, 2013 at 2:26 pm

I hope now you got logic how to use formula.

Regards

Nakul

Like(0)

Diwa p

September 26, 2013 at 7:12 am

we are using 194c, 194I, 194H,194A 195 this are the section were our client is using

Regards

Diwa

Like(0)

Diwa p

September 26, 2013 at 7:12 am

we are using 194c, 194I, 194H,194A 195 this are the section were our client is using

Regards

Diwa

Like(0)

Sampat Kumkar

September 26, 2013 at 8:47 am

Hi Nakula,

Thanks for nice documents

Sampat

Like(0)

Former Member Post author

September 26, 2013 at 5:42 pm

Hi Sampat

Thanks

Regards

Nakul

Like(0)

Ranu Eugene

September 26, 2013 at 9:29 am

Hi Nakula,

Nice and very useful document.

Thanks for sharing.

Keep up the good work.

Best of Luck. .

Regards

Eugene

Like(0)

Former Member Post author

September 26, 2013 at 5:43 pm

Hi Ranu

Thanks

Regards

Nakul

Like(0)

Former Member

November 1, 2013 at 4:27 pm

Quite useful document

Like(0)

Lakshmi Sama

November 14, 2013 at 9:57 am

Hello Nakula,

It is really a good document but requesting you to please avoid typo errors.

Thanks & Regards,

Lakshmi S

Like(0)

Soumya Ranjan

December 30, 2013 at 5:02 am

Hi Nakul,

It is indeed a good document. Could you please guide me on below requirement of client. My client is into construction business in Odisha. Here they deduct labour cess @ 1% from total bill from vendor along with a fixed percentage of 5% as security deposit , tds as well as WCT. My doubt is can we treat the fixed deposit of 5 % and labour cess 1% as the we deduct TDS or is there any other way around in SAP. Please guide.

Like(0)

Former Member Post author

April 10, 2014 at 5:39 pm

Hi Soumya

As per my knowledge you are correct.

regards

nakul

Like(0)

Former Member

January 7, 2014 at 2:46 am

Very nice document Buddy…….

Like(0)

Former Member Post author

January 7, 2014 at 7:21 pm

Thanks

Like(0)

Former Member

January 8, 2014 at 8:54 am

Good Document, thanks for sharing.

Regards,

Narin Kamuni

Like(0)

Former Member

February 19, 2014 at 10:09 pm

THanks for such a good explanation , nive document…

Like(0)

Sudeep A

February 26, 2014 at 8:33 am

Good document.. Really informative.. Thanks for sharing..

Regards,

Sudeep.

Like(0)

Former Member

March 11, 2014 at 1:51 pm

Hi Nakula,

DO we have any Notes or Patches released from SAP for EWHT in 2013. If yes can you provide me the details of the same.

Thanks,

M.Shiva

Like(0)

Mariks .

March 21, 2014 at 12:24 pm

Thanks for sharing the knowledge….

Like(0)

Former Member

June 8, 2014 at 4:51 am

Thanks for your document.

In India and Bangladesh same withholding tax process is active.

How can we execute the accumulation invoice calculation process during calculation of withholding tax rate?

Here is the example –

Tax code 52H

First 200,000/- Nil

From 200,001 to 500,000/- 1%

From 500,001 to 1,000,000/- 2%

From 1,000,001/- to 3,000,000/- 3%

Over 3,000,000/- 4%

Period is from 1st July to 30th June (In Bangladesh TAX period)

Vendor submit 1st invoice BDT 500,000/-

Date 1st July

Withholding TAX is BDT 5,000/-

Vendor submit 2nd invoice BDT 1,500,000/-

Date 1st Aug

Now total invoice amount is BDT 500,000/- + 1,500,000/- = 2,000,000/-

So that TAX slab will be 4th Slab and withholding tax rate 3% will be applicable.

Withholding TAX will be BDT 40,000/- (BDT 45,000 – BDT 5,000)

Regards

Tarek H Chowidhury

Like(0)

Former Member

January 1, 2015 at 2:11 pm

nice posting

Regards

suresh

Like(0)

Former Member

January 2, 2015 at 10:16 am

Hi Nakula sir,

i want wht calculate based on formula , my system not calculate properly , For your ref find the below details of rate and amt

Amt TDS Rate

Rs O TO RS 1000 0 %

RS.1001 to 2000 20%

RS 2001 to 3000 30%

When i am posting Invoice Rs 2000 TDS amt is Rs 400 ( 2000 *20%) but my system is calculating Rs 300 TDS, i more thing i am using formula based WHT calculation any rule ?

Regards

jay

Like(0)

Former Member

January 2, 2015 at 10:42 am

Sorry ,,

When i am posting amt Rs 2000 so tds amt should be Rs 400 , ( 2000*20 %) But my system is calculating Rs. 300 Why?

Like(0)

Dibyendu Patra

January 2, 2015 at 11:07 am

Jay paul,

It is comment section of a blog post. Why you are posting you question here ?

If you have a problem or you want to ask a question, then you are always welcome to create a discussion. You can give a reference of this blog. Have a look into the document for a guidance The Difference between a Discussion, Blog Post,… | SCN

Like(0)

Former Member

January 2, 2015 at 11:16 am

Sorry sir !!!!

Like(0)

Former Member

March 4, 2015 at 6:59 pm

HI Nakula

Can you recommend this solution?

Scenario 1: Our business requirement is to modify or override the tax rate. let say for this year for vendors that belongs to Canada must be with held 40%

My Solution:

1) I have defined the “tax code” = 01= with 100%

2) in the vendor master data

a) With holding tax type = 42

b) With holding tax code = 01

b) Exemption% field = 60% so the system will calculate 100 – 60 = 40% (but in this way then i have to give to Populate the “exemption certificate no ” also, q) can we just choose our own exemption certificate no? because by default this vendor is not exempted at all. And the exemption no and the exemption % will also hit the table, Q) what will be the impact on the legal reporting since it will hit the tables as well. do you think that it can be a good proposal or solution? or can you recommend something more easy by using formula option?

Thanks in Advance

Like(0)

Former Member

March 5, 2015 at 6:41 am

Hi Nakula,

Thanks for a useful document.

Regards,

Umamageshwaran.S

Like(0)

Former Member

March 11, 2015 at 7:38 am

Thank you SAP GURU

That was a very valuable information for me

Thank you once again

Like(0)

Former Member

March 13, 2015 at 6:42 pm

Hi Guru,

Thanks a lot, was very useful and easy guidance.

Thanks again

Like(0)

Former Member

September 15, 2015 at 10:50 am

Thanks for the document.

Regards

Ganesh

Like(0)

Former Member

October 15, 2015 at 11:31 am

Hi Ganesh ,

Thanks for reply

Like(0)

Former Member

October 15, 2015 at 11:52 am

Very Nice Document,Thanks for Sharing.

Regards,

Ashwin

Like(0)

Monica Singhal

October 24, 2016 at 5:53 am

Hi Nakula,

Thanks for sharring Useful Information. I have to Define Multiple(250) Withholding Tax type ,Can you please suggest the Method to do it. FYI we are migrating from Oracle to S/4 HANA.

Thanks in Advance.

Like(0)

Exempted reason	Text
SA	Exampted

Cocd	Sect.Code	Name1
AR01	ND	New Delhi off

Wth,t,type	Rec.ty	Text
IC	Co	Company
IC	NC	No-Company

C	Sect. code	Off, w/tax	Number
AR01	ND	194C	19

Wth t	w/tax	Liable	Rec
IC	CI	Chk	co