Sanjivkumar Shah (Account Manager) (286 Points)
13 February 2012Hello Friends,
Can anyone help me in calculating TDS in Salary Slip automatically for f.y. 2011 - 12 with dummy salary figure. I have tried it by putting the income tax formula but the correct amount is not getting it. I am attaching the files for any correction, if any.
Please its Urgent.
Regards
Sanjay
Sanjivkumar Shah
(Account Manager)
(286 Points)
Replied 14 February 2012
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
Sanjivkumar Shah
(Account Manager)
(286 Points)
Replied 14 February 2012
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
shraddha
(sr.accountant)
(21 Points)
Replied 28 February 2012
give me the chart live investment limit, deduction limit all the details of HRA for the same
DDDDDD
(.)
(176 Points)
Replied 28 February 2012
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.
DDDDDD
(.)
(176 Points)
Replied 28 February 2012
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.
Sanjivkumar Shah
(Account Manager)
(286 Points)
Replied 01 March 2012
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
DDDDDD
(.)
(176 Points)
Replied 03 March 2012
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
CAclubindia
