Tax Calculation in Excel Sheet

If anyone have problem opening this file in excel-2007 or 2010, report here with screenshoot.

Friends,

Atttached herewith  one excel file (in zip format) with tax computation having 3 sheets for F.Y. 2011-12 works in Excel-2007( service pack 2)  only.

1. Declaration form by Employee.

2. Salary Statement sheet from Payslip.

3. Tax Computation.

Fill declaration form received from Employee, Fill 2nd sheet for salary working from payslip & other details in yallow highlited cells.You can enter remaining month to know tds per month to deduct from salary.

It also caculate interest u/s 234 A B C

When you open file select enable macro to work this file.

If anyone have problem opening this file in excel-2007, report here with screenshoot.

Exshail

Originally posted by : Exshail
	Friends, Atttached herewith  one excel file (in zip format) with tax computation having 3 sheets for F.Y. 2011-12 works in Excel-2007( service pack 2)  only. 1. Declaration form by Employee. 2. Salary Statement sheet from Payslip. 3. Tax Computation. Fill declaration form received from Employee, Fill 2nd sheet for salary working from payslip & other details in yallow highlited cells.You can enter remaining month to know tds per month to deduct from salary. It also caculate interest u/s 234 A B C When you open file select enable macro to work this file. If anyone have problem opening this file in excel-2007, report here with screenshoot. Exshail

Thanks once again.
 

Please follow the below link :

https://www.cabcshettyco.com/OtherpageTheme6.aspx?TYPE=HORIZONTAL&CompanyID=0&PAGENAME=cal_Income_Tax&Parent=Calculators&Current=Tax%20Calculator

Originally posted by : B C Shetty
	Please follow the below link : https://www.cabcshettyco.com/OtherpageTheme6.aspx?TYPE=HORIZONTAL&CompanyID=0&PAGENAME=cal_Income_Tax&Parent=Calculators&Current=Tax%20Calculator

Thanks for the link.

For simple & quick calculation of Tax for next F.Y. 2012-13 (A.Y. 2013-14), visit out govt. site:

https://law.incometaxindia.gov.in/DIT/Xtras/taxcalc.aspx

From above link one can calculate Tax from A.Y. 2003-04 to  A.Y. 2013-14 for any type of assesse  i.e individual (men, woman, senior citizen ), huf, firms, company,etc..

So bookmark above link.