INCOME TAX CALCULATOR - Excel by 17QQ3HN0

VIEWS: 4,139 PAGES: 5

									                                                                                                                                        Page 1 of 5




                                                                 INCOME TAX CALCULATOR
                                                              FOR THE (FY)2012-13 & (AY) 2013-14                                                                                               Dearness Allowance
                                                         (KVS EMPLOYEES MAY USE THIS CALCULATOR)
                                                   Name of the Employee                                                                                                                        1-Jan-12                         65.00
                                                              Designation                                                                                                                       1-Jul-12                        70.00
                                                         Kendriya Vidyalaya                                                                                                       PAN NUMBER

                                                                                                                                 MALE / FEMALE
                    Enter City code where you are posted( Othere Cities=OC, A1&A Cities=A1)                                                                                        DA hiked on January '12                      7%
                    If Govt. Qr. Not Allotted in the city coming under ("X"[30%], "Y"[20%] & "Z"[10%]) or If
                    you are in Govt Accomodation then "N"

                    Basic Pay in Pay band as on 1st April                                                                                                                                                  EASY TO KNOW
                                                                                                                                                                                                             YOUR TAX
                    Grade Pay as on 1st April

                    IF YOU ARE HANDICAPED "YES"/"NO"
                    PLEASE MENTION WHETHER YOU ARE(NRDCPS/GPF/CPF) HOLDER

                    Transport Allowance (Automatically coming according to City)                                                                                   FALSE          Rebate of the Tr.Allowance                      9600
                                                                    PARTICULARS (HPL/EOL)                                                                         AMOUNT
                                        MARCH




                    NATURE OF

                                                                                                                                                                                     2012-13(FY) &
                                                  APRL




                                                                     JUNE




                                                                                                      SPET
                      LEAVE
                                                                                JULY


                                                                                         AUG
                                                              MAY




                                                                                                                          NOV


                                                                                                                                  DEC
                                                                                                                OCT




                                                                                                                                                        FEB
                                                                                                                                             JAN
                                                                                                                                                                    TOTAL
                       HPL                                                                                                                                             0               2013-14(AY)
                       EOL                                                                                                                                             0

                                         0         0          0       0         0         0           0         0         0       0          0           0             0
                    Total
                       Basic Pay with 1st July
                                                                      Dearness              Trasport            Houserent       DA arrear Jan &
                                                                                                                                                    Govt.                             SAVINGS u/s 80C,80CCC
                         Increment counted        Grade Pay                                                                                     Contribution to
                    automatically(3% of BP+GP)                        Allowance            Allowance            Allowance         Feb 2012
                                                                                                                                                  the NPS                              &80CCD(Chapter VIA)
                                0                         0                 0                    0                    0                 0                     0               0
                    Children Education Allowance                                                                                                                                                   Provident Fund
                    Leave Encashment under LTC during the year                                                                                                                0             Insurance Premium
                    Allowances received during the year (Like Family Planning
                                                                                                                                                                                                                  P.P.F.
                    Allowance etc.)
                                                                                                                                                                                Principal amount against House
                    Bonus received
                                                                                                                                                                              0               Building Advance
                    VI PC arrear received during this Year                                                                                  NIOS &JEE
                                                                                                                                                                                         NSC Certificate/NSC
                                                                                                                                                                                                      Interest                            0
                    Any other Income during the year                                                                                                                                                      Tuition Fee                     0
                                                                                                                                                                                  Govt. Contribution to the New Pensioner u/s
                    Any other Income (Bank interest etc)                                                                                                                                      80CCD limited to 10% of salary              0
                                                                                                                                                                                  Own Contribution to the New Pensioner u/s
                    Any other Income (House property)                                                                                                                         0             80CCD limited to 10% of salary                0
                    If EOL/Excess payment during the year                                                                                                                                     Any other Savings
                                                                                                                                                                              0                                                           0
                    Over payment recovery                                                                                                                                                     Any other Savings
                                                                                                                                                                              0                                                           0
                                                                            TOTAL INCOME                                                                                      0                                     Total                 0
                    Deduction of Tr. Allowance as per applicable                                                                                   0                          0          Infrastructure Bond

                                                                            Net Income                                                                                        0                                     Total                 0
                    Children Education Allowance rebate u/s 2BB(5) Rs.1200/- p.a, Hostel
                    subscidy Rs.3600/- p.a u/s 2BB(6)                                                                                                                                         Education Cess
                                                                                                                                                                                                                                         2%
                    Interest paid on House Building Advance u/s 24(1)(vi) Self
                    Occupied/residential property (30,000/1,50,000)                                                                                                                                  HS Edu.Tax
                                                                                                                                                                                                                                         1%
                    Interest on Loan for Higher Studies 80E
                                                                                                                                                                              0                 Total                                    3%
                    Under section 80U (Employee suffering from Physical Disability)
                                                                                                                                                                              0          TAX DEDUCTION AT SOURCE
                    Tax on Employeement (Prof. Tax)                                                                                                                                         THROUGH PAY BILLS
                                                                                                                                                                              0
                    Mediclaim/Health Insurance 80D (15,000/-[20,000/-member of
                    family sr.citizen])                                                                                                                                       0       Tax deducted Month                        Amount
                      Under section              House Rent 10% of the                 House Rent paid excess    HRA
                                                    paid      Salary                       of 10% salary        Received
                                                                                                                                            Rebate
                      80GG (House
                       Rent Paid)
                                                                            0                    0                    0                            0                          0                                 March
                    Under section 80G (Various Donations)                                                                                                                     0                                  April
                    Rehabilitation of Handicapped Dependent Relative
                    80DD,50000 {75000 severe disability}                                                                                                                      0                                     May
                    Medical Expenditure on Self or Dependent Relative 80DDB[40000/-
                    (60,000 sr.citizen of dep.family member)]                                                                                                                 0                             June
                    Total net Income                                                                                                                                          0                              July
                    SAVINGS u/s 80C,80CCC &80CCD                                                                                                                              0                           August
                    Taxable Income                                                                                                                                            0                        September
                    Rounded to nearest Rupee                                                                                                                                  0                           October
                    Tax                                                                                                                                            FALSE                                November
                    Education tax & Cess 3%                                                                                                                        FALSE                                December
                    Tax Pable                                                                                                                                                 0                           January
                    Relief under section 89(Details are atched)                                                                                                               0                            February
                    Net Tax Due                                                                                                                                               0
                    At source deduction                                                                                                                                       0
                    Tax Due / Excess                                                                                                                                          0 Total                                                     0
                    If any body finds any calculation mistake or further guidence, please inform me through e-mail (gkrao_kv@yahoo.co.in). If you are satisfied with this calculator,
                    please send me an appriciation letter to my school address.
                    Prepared by: G.Kondal Rao, UDC(1st UDC in KVS Incentive Awardee 2009), KV, IIT, Kharagpur (Mobil No.09233369815 Land Line 03222-649966( R ), 277223(O)

                                                                                                                      In case of individual and HUF:-
                                                                    Income Level                                                         Income Tax Rate
                                    Where the total income does not exceed Rs.2,00,000/-.                                                                                             NIL
                          Where the total income exceeds Rs.2,00,000/- but does not exceed                                                              10% of amount by which the total income exceeds Rs. 2,00,000/-
                                                     Rs.5,00,000/-.
                          Where the total income exceeds Rs.5,00,000/- but does not exceed                                                  Rs. 30,000/- + 20% of the amount by which the total income exceeds Rs.10,00,000/-.
                                                    Rs.10,00,000/-.
                                   Where the total income exceeds Rs.10,00,000/-.                                                        Rs. 1,30,000/- + 30% of the amount by which the total income exceeds Rs.10,00,000/-
                                                                                                                                                                                  .




Date:____________                                                                                                                                                                                                                             Sig.of the Employee
                                                                                                                               Page 2 of 5




                                                                                                                        FORM 16
                                                                                                                   [ see rule 31 (1) (a)
                                                                                              Certified under Section 203 of the Income-Tax act 1961 for tax
                                                                                               deducted at source from income under the head "Salaries
                                                          Name & address of Employer                                                                                    Name & designation of Employee
                                                                 THE PRINCIPAL                                                                 NAME:                                   0
                                                 KENDRIYA VIDYALAYA,                                                                           DESIGNATION:                            0
                                     [under KVS(HQ), New Delhi, an Autonomous Body under HRM, Govt. of India]                                  K.V.                                    0
                            PAN No. of the Deductor                               TAN No. of the Deductor                                                                  PAN No. of the Employee
                                                                                                                                                                                       0
              Acknowledgement No. of all quarterly statement of TDS under sub -section                                                    Period
              (3) of section 200as provided by TIN Facilitation Centre or NSDL web site                                                                                                                 Assesment Year
                                                                                                                   From                                           To
                               Quarter                          Acknowledgement No.
                             Quarter-1
                             Quarter-2                                                                             2012                                        2013                                      2113-14
                             Quarter-3
                             Quarter-4
                                                                                      DETAILS OF SALARY PAID, OTHER INCOME AND TAX DEDUCTED
                   1      Gross salary                                                                                                                                                0
                          (a) Salary as per provision contained in section 17(I)
                          (b) Value of perquisities under section 17(2) (asper Form no. 12BA, whereapplicable
                          (c) Profit in lieu of salary under section 17(3) (asper Form no. 12BA, whereapplicable
                          (d) Total                                                                                                                                                                             0
                   2       Less Allowances to the extent exempt under section 10 (80GG)                                                                                                0
                          Transportallowances/conveyance Residence-Office                                                                                                              0
                          Under section 80U (Employee suffering from Physical Disability)                                                                                              0
                          Under section 80G (Various Donations)                                                                                                                        0


                          Total                                                                                                                                                                                 0
                   3      Balance (1-2 )                                                                                                                                                                        0
                   4      Deduction under section 16:
                          (a) Entertainment allowance                                                                                    ,,0
                          (b) Tax on Employment                                                                                          ,,0
                   5      Agregate of 4 (a) and (b)                                                                                                                                                          ,,0
                   6      Income chargeable under the head "Salaries" (3-5)                                                                                                                                                     ,,0
                   7      Add: any other income reported by employee                                               U/s
                          Bank Interest                                                                                                                                                0
                          House property income                                                                                                                                        0
                          Leave encashment etc.                                                                                                                                        0
                          Any arrear received during the year                                                                                                                          0
                          Total                                                                                                                                                                                 0
                   8      Gross Total Income (6+7)                                                                                                                                                                              ,,0
                   9      Deductions Under Chapter VI
                          A. Section 80C, 80CCC and 80CCD
                          a) Section 80C                                                                                                                                  Gross Amt           Deductible Amt
                          (i) GPF/CPF/PPF                                                                                                ,,0                                          ,,0
                          (ii) LIC Premium                                                                                               ,,0                                          ,,0
                          (iii) P.P.F.                                                                                                   ,,0                                          ,,0
                          (iv) HB refund                                                                                                 ,,0                                          ,,0
                          (iv) NSC Interest                                                                                              ,,0                                          ,,0
                          (v)Tuition Fee                                                                                                 ,,0                                          ,,0
                          (vi)Any other                                                                                                  ,,0                                          ,,0
                          b) Section 80 CCD                                                                                              ,,0                                          ,,0
                          c) Section 80 CCD                                                                                              ,,0                                          ,,0
                          TOTAL                                                                                                                                                       ,,0                       0
                          B. Other Sections Under Chapter VI A                                                     Gross Amt                                       Qualifying Amt           Deductible Amt
                          House Building interest                                                                                        ,,0                                          ,,0
                          Interest on Loan for Higher Studies 80E                                                                        ,,0                                          ,,0
                          Mediclaim/Health Insurance (upto 15,000/-)                                                                     ,,0                                          ,,0
                          Any other amount rebate under rules (HC,Medical etc)                                                           ,,0                                          ,,0
                          Leave encashment etc.                                                                                          ,,0                                          ,,0
                                                                                                                                                                                      ,,0
                                                                                                                                                                                      ,,0
                                                                                                                                                                                      ,,0
                          Total (B)                                                                                                                                                   ,,0                    ,,0
                10        Aggregate of deductible amount under Chapter VI                                                                                                                                                       ,,0
                11        Total Income 8-10)                                                                                                                                                                                    ,,0
                12        Tax on total income                                                                                                                                                                          FALSE
                13        Surcharge                                                                                                                                                                                             ,,0
                14        Education Cess                                                                                                                                                                               FALSE
                15        Tax payble on total income 12+13+14                                                                                                                                                                   ,,0
                16        Relief under section 89(attach details)                                                                                                                                                               ,,0
                17        Tax payble (15-16)                                                                                                                                                                                    ,,0
                18        Less (a) Tax deducted at source u/s 192(1)                                                                                                                                                            ,,0
                          less (b) Tax paid by the employer on the behalf of the employee under section 192(1A) on perquisites under
                          section 17(2)                                                                                                                                                                                         ,,0
                19        Tax Payble/(refundable (17-18)                                                                                                                                                                        ,,0
                                                                              DETAILS OF TAX DEDUCTED AND DEPOSITED INTO CENTRAL GOVT ACCOUNT
                                                                                    ( The deductor is to provide transction -wise detail of tax deducted and deposited)
              SN          TDS Rs      Surchare        Education             Total tax                          Cheque/DD No.                              BSR Code of bank Branch           Date on which tax       Transfer voucher
                                                      Rs                                                                                                                                    deposited               identification



                   1           0                                       0
                   2           0                                       0
                   3           0                                       0
                   4           0                                       0
                   5           0                                       0
                   6           0                                       0
                   7           0                                       0
                   8           0                                       0
                   9           0                                       0
                10             0                                       0
                11             0                                       0
                12             0                                       0
               Total           0             0             0            0
                       I, --------------------- son of -------------------------------- working in the capicity of Principal, ---------------------------- do hereby certified that
              a sum of Rs.           0                                                         No Rupees Only
              I further certified that the above information is true and correct based on the books of accounts, documents and other available records.


              Place:                                                                                                                                                    Signature of person responsibe for tax deduction
                                                                                                 Full Name:
              Date:                                                                           Designation:                                                                      PRINCIPAL
Prepared By__________                                                                                                                                                                                                                  P.T.O
                          Page 3 of 5




              Date:
                        (Drawing & Disbursing Officer)(Seal)




Prepared By__________                                          P.T.O
12365   370.95
           370

12400     372
        0.95                   -0.95        370


MOD(I14,10) IF(K14 <1,-K14,10-K14)     L14+I14

								
To top