Income Tax calculator in Excel Sheet is available for the Financial Year 2009-10 or Assessment Year 2010-11. No doubt, tax calculator is already available on www.fastworking.blogspot.com, but individual status can be stored in below excel sheet. Only white cell are for data entry.
The following entries can be filed in this calculator
1) Emp No = Empployee Number
2) Pan = Permanent Account Number
3) Name = Name of Assessee
4) Sex = M = Male , W = Women and S = Sr. Citizen
5) Gross =Total Income
6) Others = Other Income, type with minus (-) if there is loss.
7) Total = Total Income +Other Income
8) 80C = Saving Amount Not more than Rs. 1,00,000.00
9) Other Deduction = Amount of other deductions other than 80C'
10) Total Income = Total - 80C - Other Deductions
11) Income Tax = Auto calculated field
12) Surcharge = zero value
13) Cess = Auto Calculated field
14) Relief 89 = Can be entered.
15) Total Tax Payable = Total Tax After deducting tax relief 89
16) TDS = Tax deducted by employer
Specially, Individual Tax information can be stored in it which was not available in earlier Calculators .
for viewing this excel based tax calculator (Click Here)
2) Pan = Permanent Account Number
3) Name = Name of Assessee
4) Sex = M = Male , W = Women and S = Sr. Citizen
5) Gross =Total Income
6) Others = Other Income, type with minus (-) if there is loss.
7) Total = Total Income +Other Income
8) 80C = Saving Amount Not more than Rs. 1,00,000.00
9) Other Deduction = Amount of other deductions other than 80C'
10) Total Income = Total - 80C - Other Deductions
11) Income Tax = Auto calculated field
12) Surcharge = zero value
13) Cess = Auto Calculated field
14) Relief 89 = Can be entered.
15) Total Tax Payable = Total Tax After deducting tax relief 89
16) TDS = Tax deducted by employer
Specially, Individual Tax information can be stored in it which was not available in earlier Calculators .
for viewing this excel based tax calculator (Click Here)
No comments:
Post a Comment