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
From India, Bangalore
1I 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
From India, Bangalore
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
[IMG]https://www.citehr.com/misc.php?do=email_dev&email=cmFtZXNobXNoZXR0eUBnbW FpbC5jb20=[/IMG]
From India, Bangalore
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
[IMG]https://www.citehr.com/misc.php?do=email_dev&email=cmFtZXNobXNoZXR0eUBnbW FpbC5jb20=[/IMG]
From India, Bangalore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Monthly Salary Statement - CTC and TDS Calculator.xls