Salary TDS Calculator Template - Income Tax
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Human Resource Section > Human Resource Management

Salary TDS Calculator Template - Income Tax

rameshmshetty Started The Discussion:

Dear Friends

I am sharing herewith TDs calcutaion workbook in excel created by me which can be used for calculation of TDs on salaries

following points to be noted while using this excel workbook
1. You need to enable macro as there are few customised functions in VBA
2. Monthly data to be updated everymonth
3. range named "BM" stores no of balance months (to be updated every month once monthly data is updated
4. Piviot table to be refreshed after updating monthly data
5. Employees' name to be updated in the data sheet once. (EPF No is a key criteria which captures data from the pivot table. So EPF no must be entered in the monthly data sheet.
6. report sheet will provide you the IT calculation summury for the year 2008-09, Plese change the employee serial no for getting appropriate report
7. Modify the sheet accordingly if required (password to open/sheets is "admin"

8 You may modify the VBA function for modifying income tax on gross total income from salary

9. This will be helpful where monthly taxable salary varies (changes in performacne incentive etc).

Ramesh Shetty
Manager(Finance & Accounts)
Mangalore


Attached FilesProvided by community member rameshmshetty. Join us to learn and grow with your peers.
File Type: xls TDS FY 2008-09 to HR.xls (581.0 KB, 6183 views)
lak_souji_p - Member Since: Jul 2008
Hi Ramesh Shetty Can u provide the password for the attachment or can u send to my mail id lak_souji_p@yahoo.com Regards

nsBhanuprakasha - Member Since: Jan 2008
Can u provide the password for the attachment and please send to my e mail ID nsbhanuprakasha@gmail.com N.S. Bhanuprakasha

Mr. Christian Casino - Member Since: Jun 2008
Hi can you send me the file with the password to my id christianscasino@yahoo.com Thanks. Chris Casiņo

rameshmshetty - Member Since: Feb 2008
Hello friends I have provided password in my orginal post itself password = admin do mail me at rameshmshetty@gmail.com for any querries in this regard Regards Ramesh Shetty

eka - Member Since: Feb 2008
Dear Ramesh could you pl forward the password relased excel sheet to ekancs@gmail.com ? Eka

sanjay1822 - Member Since: May 2007
Hi Ramesh Shetty Can u provide the password for the attachment or can u send to my mail id ON sanjay1822@gmail.com Regards Sanjay Bhardwaj

perpectuals - Member Since: Sep 2008
hi, kindly, send me the presentation to my mail - mind.anizer@gmail.com With Thanks & Wishes, Thilak.

kvenkatesan_1 - Member Since: Mar 2008
I am handling Morethan 500 IT dedutable employees. this is very useful for me Thanks k.venkatesan chennai

Valegoankar - Member Since: Jul 2007
Hi, Thanks. Good Information shared. :):):)"Wish You All a Happy Festival of Lights - Deevali" :):):) Regards, Shirish



Found This Useful? +Vote Up This Page Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


14579
VIEWS

14
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network