Auto Tax Calculator Excel Sheet

Wednesday, April 14, 2010 | comments

Friends
                      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)
                  


Share this article :
 
Support : Tds Tax India
Copyright © 2011. Tds Tax India - All Rights Reserved
Site Created by Tds Tax India