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
Posted 21st October 2008 From India, Bangalore
Attached Files
Shared By Cite.Community Member "rameshmshetty" For Public Download
File Type: xls TDS FY 2008-09 to HR.xls (581.0 KB, 6793 views)

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
Posted 22nd October 2008 From India, Bangalore
eka 
Dear Ramesh could you pl forward the password relased excel sheet to ekancs@gmail.com ? Eka
Posted 22nd October 2008 From India, Hyderabad
I am handling Morethan 500 IT dedutable employees. this is very useful for me Thanks k.venkatesan chennai
Posted 24th October 2008 From India, Thane
Hi Friend, This is really nice and useful worksheet to resolve the tidious task of TDS on Salaries. Anurag
Posted 24th October 2008 From India, Jaipur
Do mail me if you need any help in using this excel sheet

It will be hlpful if you are handling more than 25 employees and that o salaries varies months to month like incentive, bonus, ltc etc

You may go throught he guidelines provided in my original post

Work book is not protected at all, If you have basic knowledge of VB you can modigy income tax calculation function also if required

Regards

Ramesh Shetty




Posted 25th October 2008 From India, Bangalore
Hi Ramesh, Can you please provide me the excel sheet and share with me the TDS and hr policy if you have any iddea... Thanks, Stalina
Posted 27th September 2009 From India, Pune
Hi Ramesh, Can you mail me TDS file for the current F.Y. i.e. 2009-10 on far_syl@rediffmail.com. Thanks & Regards Sylvi
Posted 1st October 2009 From India, Mumbai
Dear Sir, Could you tell me the slabs of Salary. And also Salary Structure like what the % of Epf Esi etc. Regards, Abhi
Posted 10th February 2010 From India, Chandigarh



 
 
 
 







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.

About Us - Advertise - Contact Us - RSS   On Google+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network