Spreadsheet: f95a6b12-12a8-4ba4-9d31-c30e0f8ff601
Sheet: Sheet1

Unnamed: 0 | http://www.PankajBatra.com | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 | Income Tax Calculator [NAME]-13 (AY 2013-14)
 | Gender | Male | Have a Question? Ask it here: http://www.SocialFinance.in
 | Place of Residence | Metro City
 | Age | 30
 | Number of children | 0
 | [NAME] |  | April | May | June | July | August | September | October | November | December | January | February | March | Total
 | Basic Salary |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | House Rent Allowance (HRA) |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Dearness allowance (DA) |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Transport/Conveyence Allowance |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Child Education Allowance |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Grade/Special/Management/Supplemementary Allowance |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | City Compensatory Allowance (CCA) |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Arrears |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Gratuity |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Leave Travel Allowance (LTA) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Leave Encashment |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Performance Incentive/Bonus |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Medical Reimbursement |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Food Coupons |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Periodical Journals |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Uniform/Dress Allowance |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Telephone Reimbursements |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Professional Development Allowance |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Car Reimbursement |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Internet Expense |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Driver Salary |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Gifts From Non-Relatives |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Gifts From Relatives |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Agricultural Income |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | House Rent Income (income from house property) |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Saving bank account interest |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Other income (Fixed deposit /NSC/SCSS Interest) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Short Term Gains from Share Trading/Equity MFs |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | [NAME] from Share Trading/Equity MFs |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | TOTAL INCOME |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Exemptions
 | Actual Rent paid as per rent receipts |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | HRA Exemption | Availing both HRA and Home loan exemption | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Non-Taxable Allowances | Investment/Bills Details
 | Child Education Allowance | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Medical Reimbursement receipts submitted | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Transport/Conv. Allowance | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | LTA receipt submitted | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Food Coupons | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Periodical Journals | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Uniform/Dress Allowance | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Telephone Reimbursement receipts submitted | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Prof. Development receipts submitted | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Car Expenses Reimbursement receipts submitted | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Internet expense receipts submitted | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Driver Salary receipts submitted | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Other Reimbursement receipts submitted | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Non taxable Gratuity | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Non taxable leave encashment | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Non taxable House rent income | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Professional Tax |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Net Taxable Salary |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | House and [NAME] | On loan and Self Occupied
 | Home Loan Interest Component | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Gross Total Income |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Deductions under chapter VIA
 | Life Insurance Premium payment | 0
 | Employee's contribution to PF | 0
 | PPF (Public Provident Fund) | 0
 | Equity Tax saver Mutual Funds - ELSS | 0
 | National Savings Certificate (NSC) deposit | 0
 | National Service Scheme (NSS) deposit | 0
 | Senior Citizen Savings Scheme (SCSS) deposit | 0
 | Post Office/Tax saving Bonds investments | 0
 | New pension scheme (NPS) Deposit 80CCD | 0
 | Children Tution Fees paid | 0
 | Housing Loan Principal repayment | 0
 | Tax saving Fixed Deposit for 5 yrs. or more | 0
 | Stamp Duty/Registration charges for house | 0
 | Other Eligible Investments | 0
 | Total of Section 80C | 0
 | Pension Fund (80 CCC) | 0
 | Total Deduction under Sec. 80C & 80CCC | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 80D (Medical insurance premium for Self and/or Family) | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 80D (Medical insurance premium for Parents) | 0 | Parents above 60 years |  |  |  |  |  |  |  |  |  |  |  | 0
 | 80DD (Maintainence of depandant disabled) | 0 | With Severe Disability |  |  |  |  |  |  |  |  |  |  |  | 0
 | 80DDB (Medical treatment for specific diseases) | 0 | Patient Below 65 years |  |  |  |  |  |  |  |  |  |  |  | 0
 | 80E (Interest paid on Higher Education Loan) | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 80U (Handicapped person/Perm. Disability) | 0 | With Severe Disability |  |  |  |  |  |  |  |  |  |  |  | 0
 | Donations - 80G (100 % deductions) | 0 | Without 10% Adjusted Gross total income cap |  |  |  |  |  |  |  |  |  |  |  | 0
 | Donations - 80G (50 % deductions) | 0 | Without 10% Adjusted Gross total income cap |  |  |  |  |  |  |  |  |  |  |  | 0
 | Direct Investment in Equity under RGESS | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | [NAME]. Bonds (Section 80CCF) | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Taxable Income |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Taxable Income rounded off |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Income Tax on Total Income |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Education Cess @ 3% |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Income tax including education cess |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | TDS (Tax deducted at source) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Pending Tax Payable |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Monthly Deductions from salary |  | April | May | June | July | August | September | October | November | December | January | February | March
 | TDS (Tax deducted at source) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Professional Tax |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Employee's PF Contribution |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Employee's NPS Contribution |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | VPF (Voluntarily Provident Fund) contribution |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Deduction for company provided transport |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Deduction towards State Labour welfare Fund (LWF) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Deduction towards company provided Group Term insurance |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Deduction towards Leave availed |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Deduction towards company provided medical insurance |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Other Deductions from Employer |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Employer's NPS Contribution |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Employer's PF Contribution |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | In Hand Salary |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | In Hand Salary without reimbursments |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Total Income in this year |  |  |  |  | 0
 | ADVANCE TAX SCHEDULE - NOT APPLICABLE FOR SENIOR CITIZENS
 | Total Tax as per Consolidation Sheet: | 0
 | PARTICULARS | % | Payable | Paid | Difference
 | Payable upto 15th September, 2012 | 0.3 | 0 | 0 | 0
 | Payable upto 15th December, 2012 | 0.6 | 0 | 0 | 0
 | Payable upto 15th March, 2013 | 1 | 0 | 0 | 0
 | Male | Metro City | On loan and Self Occupied |  |  | With Severe Disability | Parents below 60 years |  | With 10% Adjusted Gross total income cap |  | Patient Below 65 years |  |  | Availing both HRA and Home loan exemption
 | Female | Non-Metro City | On loan but [NAME] out |  |  | Without Severe Disability | Parents above 60 years |  | Without 10% Adjusted Gross total income cap |  | Patient Above 65 years |  |  | Availing Only HRA Benefit
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Availing Only Home loan exemption
 |  | STCG | Wrong | W/O STCG | 0
 | Super Senior | 0 | 0 | 0
 | Senior | 0 | 0 | 0
 | Male | 0 | 0 | 0
 | Female | 0 | 0 | 0
 | Super Senior | 500000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Senior | 250000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Female | 200000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Male | 200000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 200000 | 10
 |  |  | 500000 | 20
 |  |  | 1000000 | 30
 |  |  | STCG | 15