7/28/2019 Excelfinder.com Salary Tax Calculator

http://slidepdf.com/reader/full/excelfindercom-salary-tax-calculator 1/1

COMPUTATION OF INCOME TAX FROM SALARY FOR THE FINANCIAL YEAR - 2012-13Developed By : VIJAY CHITTE

Organization Employee Name Employee ID

F Address 1 M / F / SC / SC PLUS Employee PAN

  Address 2 Designation Date of Joining

 Other Details Department Date of Leaving

Other Details Other Details Place

Income April May June July August September October November December January February March Total

     E

     A     R     N     I     N     G

Basic 0 0 0 0 0 0 0 0 0 0 0 0

DA 0 0 0 0 0 0 0 0 0 0 0 0

HRA 0 0 0 0 0 0 0 0 0 0 0 0

Transportation 0 0 0 0 0 0 0 0 0 0 0 0

Sp. Child Edu. 0 0 0 0 0 0 0 0 0 0 0 0

Business Attire 0 0 0 0 0 0 0 0 0 0 0 0

Veh. R&M (Bike) 0 0 0 0 0 0 0 0 0 0 0 0

Veh. R&M (Car) 0 0 0 0 0 0 0 0 0 0 0 0

Medicale Exp. 0 0 0 0 0 0 0 0 0 0 0 0

Food Coupan 0 0 0 0 0 0 0 0 0 0 0 0

Books & Period 0 0 0 0 0 0 0 0 0 0 0 0

Telephone Exp 0 0 0 0 0 0 0 0 0 0 0 0

LTA 0 0 0 0 0 0 0 0 0 0 0 0

Other Income 0 0 0 0 0 0 0 0 0 0 0 0

Other Income 0 0 0 0 0 0 0 0 0 0 0 0

Other Income 0 0 0 0 0 0 0 0 0 0 0 0

Other Income 0 0 0 0 0 0 0 0 0 0 0 0

Total 0 0 0 0 0 0 0 0 0 0 0 0 0

     D     E     D     U     C

     T     I     O     N

Professional Tax 0 0 0 0 0 0 0 0 0 0 0 0 0

Providand Fund 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0

Total 0 0 0 0 0 0 0 0 0 0 0 0 0

Exemption under sec 10 & 17 Claim Eligible Tax Computation Amount

Transportation Allowance 0 0 Gross Salary 0

Food Coupan 0 Less : Profession Tax 0

Child Education Allowance 0 Less : Exemption under section 10 & 17 0 500

Medical Bill exemption 0 10% Actual recd Income chargeable under head 'Salaries' 0

Business Attire 0 0 0 Income chargeable under head 'House/Property' 0

Vehicle R&M (BIKE) 0 Plus : Saving Bank A/c. Interest 0Vehicle R&M (CAR) 0 0 1 Plus : Other Income 0

Metr HRA paid (Yearly) Metro City 0 0 2 Gross Total Income 0

etro Books & Periodical 0 0 3 Less : Exemption under sec VI-A 0

Telephone Expenses 0 0 Less : Investment up to Rs.1 lakh (section 80C) 0

LTA Exemption 0 0 Net taxable income 0

Total 0 0 32400 0 0

Tax Slabs Tax rate Appl Amt Balance Tax 0

Exemption under sec VI-A Eligible Medical 0 0 0.00% 0 0 0 0

Medical Ins. Premium (sec 80D) 0 Busi At 0 200001-500000 10.30% 0 0 0

Medical Ins. Prem.for parents (sec 80D) 0 Bikes 0 500001-1000000 20.60% 0 0 0 0

 YES Medical for handicapped dependents (80DD) NO 0 Car 32400 >1000001 30.90% 0 0 0

NO Medical for specified diseases (Sec 80DDB) NO 0 B&P 0 Total Tax Liability 0 0

Deduction for permanent disability NO 0  Tele 0 Less : TDS deduction from Salary 0 0

Other Deduction    Total 32400 Income tax due 0

Total 0 0

15000Balance Tax Payable 0

0

Exemption under Sec 80C Claim Eligible 20000

PF (Providand Fund) 0 0 350000

LIC Premium Paid 0  

Housing loan Principle repayment 0 0

Interest paid on higher education Loan 0   0

Public Provident Fund 0 0

NSC (National Savaing certificate) 0 0 0

E.L.S.S ( Equity Linked Saving Scheme) 0

Pension Scheme 0

School/College Fee paid for Child Edu. 0 20000   0

Other Deduction 0 

0 0

Total 0 0   0 0

  0

Housing Loan Interest / Other income Claim Eligible   0

Housing loan Interest (for tax exemption) 0

Saving bank A/c. Interest 0  Other Income 0 35000

Total 0 0

150000

TDS deductedfrom Salary