Tds calcualtion in salary slip for f.y. 2011 - 12

Incorporate the following changes in ur sheet:

1. Cell J24 (Monthly TDS) correction in formula i.e. D38-180000 instead of D38+180000.

2. Divide the monthly tds amount by 12 which is not done.

any further query let me know.

Hi Ketan Kumar G. Shah

As per your advise i have done the correction, but there is only minor advise required from u regarding education cess @ 3%.

For E.G. if Annual salary of a person is 825000/- then TDS comes to Rs. 99500/- + 3% (Education Cess) 2985/- = 102485/-.  But in Xls. sheet it is not getting that amount.

Pls. correct me in that case. I am attaching the file.

Regards

Sanjay

Hi Ketan Kumar G. Shah

As per your advise i have done the correction, but there is only minor advise required from u regarding education cess @ 3%.

For E.G. if Annual salary of a person is 825000/- then TDS comes to Rs. 99500/- + 3% (Education Cess) 2985/- = 102485/-.  But in Xls. sheet it is not getting that amount.

Pls. correct me in that case. I am attaching the file.

Regards

Sanjay

give me the chart live investment limit, deduction limit all the details of HRA for the same

Hi sanjiv kumar here i attached the working relating to TDS on salaries.

I inserted a drop down menu for selecting the gender so that it will be easy for you to compute TDS both for Male and female employees.

And Btw while calculating monthly TDS we should deduct the total tax amount by 12. 

Dear Sanjiv Kumar,

Please ignore my previous message. 

Since you have linked the education allowances and bonus to the CTC you will not get the correct TDS amount in the payslip. Now i linked it to the CTC so pls consider the file which i'm attaching in this thread for your reference.

Hello Dinesh,

I have seen ur worksheet attached but the exact figure is not matching .

For Eg., if gross salary is 175000/- after deducting PT, Conveyance,etc., then the TDS AMOUNT Should be ZERO.

Pls. make salary slip in such way that it compute exact tds figure for male / female. Pls. also take into the consideration of Edu. Cess & Sec. Edu. Cess. Also requesting that the sheet attached by u is not editable.

Pls. also provide Profession Tax formulas in that sheet only consider the february month in which we have to pay Rs.300/-.

u can enter one more sheet before that salary slip having named as data input sheet in which all entries are put such as Basic, D.A., Conveyance, HRA,Bonus, investments, with formulas of PT, ESIC, PF, TDS.

BUT PLEASE MAKE IT AS EDITABLE SHEET.

PLEASE ITS URGENT.

REGARDS

SANJAY

I cannot understand ur requirement correctly.

Here in this file i edited the fields to include deductions relating to PF,ESI and professional tax etc.

I also edited the formula to show the correct tax amount

I considered Edu.  cess & Sec. & H. Edu cess in the previous file itself. And i dont think there is any logic behind having two sheets as input sheet and main sheet. Because it will just increase the confusion and you need to switch between the two sheets all the time.

I wont come to CAClubindia very often, if u hav any query in this file then mail me at dineshvanan.1989 @ gmail.com