Income Tax Calculator for Financial Year 2009-2010 for India - Excel by pankajbatra

VIEWS: 16,349 PAGES: 1

Income Tax Calculator for Financial Year 2009-2010

More Info
									http://www.PankajBatra.com
Tax Calculator F.Y. 2009-10 Sex (for male - 1, for female - 0) 1 Place of Residence(For Metro cities0,For Non Metro cities-1) 1 Number of children 0 Salary Breakup Investment & Bills Details Basic HRA Transport Allowance Child Education Grade/Special Allowance Arrears LTA Leave Encashment Performance Incentive Medical Reimbursement Food Coupons\Periodical Journals Telephone Reimbursements Car Reimbursement Internet Expense Driver Salary TOTAL SALARY Less : Exemptions Actual Rent paid as per rent receipts HRA Exemption EPF Employer Contribution Child Education Allowance Medical Reimbursement Transport Allowance LTA Food Coupons Telephone Reimbursement Car Expenses Reimbursement Internet expense Driver Salary Other Reimbursement Balance Salary Professional Tax Net Taxable Salary Loss from House Property (interest component) Any other Income Gross Total Income

April

May

June

July

August

September

October

November December

January

February

March

Total -

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deductions under chapter VIA 80C + 80CCC(Pension Fund): Amt. Invested LIC Premium Employee's contribution to PF PPF ELSS Others Tution Fees paid Housing Loan Principal repayment Infrastructure Bonds Fixed Deposit for 5 yrs. or more Others Total of Section 80C Pension Fund (80 CCC) Total Deduction under Section 80C & 80CCC 80D (Medical insurance premium) 80E (Interest on Loan for Higher Education) 80U (Handicapped person) 80G (Donations to Govt. Relief Funds) 80G (Donations to Charitable trust) Total Income Total Income rounded off Tax on Total Income Surcharge Tax Payable Education Cess @ 3% Balance TDS Net Tax Payable Monthly Deductions from salary TDS Professional Tax Employee's PF Contribution Others Employer's PF Contribution In Hand April May June July August September October November December January February March

-

-

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

ADVANCE TAX SCHEDULE Total Tax as per Consolidation Sheet: PARTICULARS Payable upto 15th June, 2009 Payable upto 15th September, 2009 Payable upto 15th December, 2009 Payable upto 15th March, 2010 % 15% 30% 60% 100% PAYABLE PAID DIFFERENCE -


								
To top