Salary Statement Tax - Excel - Excel by ayj20360

VIEWS: 0 PAGES: 10

More Info
									                     Income Tax Calculation software,for the financial year 2010-2011, Assessment Year 2011-20
 Prepared by Pranab Banerjee,Kalisthanpara,Jiaganj,Murshidabad,West Bengal, India.For contact Mobile:-890627
                                      pranab.banerjee83@gmail.com OR www.pranab.jiaganj.com
                                                         Male Or
   A      Name & Designation of the Assesses                        Male      Pranab Kr.               Bandyopadhyay                           Please follow It
                                                         Female
                                                                                                                                                                        Double Click
   B      Residential Address         Vill:-          Kalisthanpara        P.O.            Jiaganj              District                      Murshidabad
                                                                                                                                                                        Password "p
   C      State             West Bengal                    Pin Code No.           742123             Put the Pass word " pranab" in Yellow Cell

   D      Pan No                AA8899JJ                      GIR NO                                   Office permanent A/C No.

                            D.A.               Rate of               Spl.         Arrear                                                                 P.             H.B.
MONTH B.PAY         D.A.              H.R.A.               M.A.            Bonus                TOTAL         Total Earn                       G.P.F.          G.I.S.
                            Rate               H.R.A.              Alwnces       Received                                                               TAX             ADV

Mar-09     14450    3179        22%   2168      15%        300         0    1000     15700       20097                                         3000     130     40      1050

Apr-09     14450    3902        27%   2168      15%        300         0                         20820                                         3000     130     40      1050
May-09     14450    3902        27%   2168      15%        300         0                         20820                                         3000     130     40      1050




                                                                                                                   TOTAL EARN FOR THIS YEAR
Jun-09     14450    3902              2168      15%        300         0                         20820                                         3000     130     40      1050
                                27%
 Jul-09    14850    4010              2228      15%        300         0                         21388                                         3000     130     40      1050
                                27%
Aug-09     14850    4010        27%   2228      15%        300         0                         21388                                         3000     130     40      1050

Sep-09     14850    4010              2228      15%        300         0                         21388                                         3000     130     40      1050
                                27%
Oct-09     14850    4010        27%   2228      15%        300         0                         21388                                         3000     130     40      1050

Nov-09     14850     0                2228      15%        300         0                         17378                                         3000     130     40      1050
                                0%
Dec-09     14850     0          0%    2228      15%        300         0                         17378                                         3000     130     40      1050

Jan-10     14850     0          0%    2228      15%        300         0                         17378                                         3000     130     40      1050

Feb-10     14850     0          0%    2228      15%        300         0                         17378                                         3000     130     40      1050

TOTAL     176600   30925              26496                3600        0    1000     15700      237621          254321                         36000    1560    480     12600

   Edit the only Yellow Cell.DOUBLE CLIK ON THE YELLOW CELL FOR EDIT,Want a PASSWORD, please put the PASSWORD is "
                                           pranab",(without quote) and Edit the Cell.
ear 2011-2012
ile:-8906279547, 9474316768, Mail:-



Double Click on the Yellow cell and Put the
Password "pranab" and Edit the yellow Cell




      H.B.Int TUTION Advance        House Rent
                     Income
       Paid    FEES                    Paid
                     tax Paid

        0        0        0             0

        0                     LIC                20000
        0                  NSC                    0
                80U Hand.cpd.Self(Max
        0             750000/-)                   0
               Health.Ins 80D(Max-15000)
        0                                         0

        0
               Infrustructure Bond(Max-
        0                20000)                   0

        0       Income from Bank/NSC              0
                     Income from House
        0                 Property                0

        0     80E(Higher Education)

        0       80DD(Handcpd for fmly)            0
              80DDB(Medical treatmentfor
              Sever Desease)
        0                                         0
        0

ORD is "
                  INCOME TAX STATEMENT FOR THE FINANCIAL YEAR 2009-2010
                               ASSESSMENT YEAR 2010-2011
A. Name & Designation of the Assesses                    Pranab Kr. Bandyopadhyay
B. Residential Address            Kalisthanpara       Jiaganj       Murshidabad          Pin No   742123
C. Pan No            AA8899JJ           GIR NO                      Office permanent A/C No.
1 a) Salary income with allowance excluding H.R.A.:-……………………………                             Rs.     211125
   b) House Rent Allowance :-……………………………………………………………                                        Rs.     26496
   c) Bonus :-…………………………………………………………………………………                                               Rs.      1000
   d) Arrear,if any :-…………………………………………………………………………..                                        Rs.     15700
2 Any other income as stated by the Assesses :-
   a) Income from N.S.C./Bank interest etc:-………………………………………….                               Rs.       0
   b) Income from House Property:-…………………………………………………….                                     Rs.       0
3 Gross Income(Col.1 + 2 ) :-………………………………………………………………                                       Rs.     254321
4 Interest paid as H.B.Loan (1.5 Lacks maximum) U/S 24(B):-……………………….                       Rs.       0
5 Professional Tax U/S 16(iii) :-…………………………………………………………                                     Rs.      1560
6 Exemption U/S 10(13A) :-
   a) H.R.A.Received :-         ………………………………………                              Rs.   0
   b) House Rent paid :-        ……………………………………….                             Rs.   0
   c) Expenditure on rent in excess of
   10% Salary Income :-         ……………………………………..                             Rs.   0
   d)40% of Salary:-            ……………………………………..                             Rs.   0
   e) Amount exempted (Least of a,c,&d):-            ……………………                Rs.   0        Rs.       0
7 Total Income(Col.3-4-5-6) :-……………………………………………………….                                        Rs.     252761
8 Deduction U/S 80 C (Maximum Rs.1,20,000/-):-
   a) Contribution to G.P.F.:- ……………………………………..                              Rs. 36000
   c) Group Insurance Savings Scheme :-              ………………….                Rs.  480
   d) L.I.C./P.L.I./U.Lip Premiam paid:-(including Notified
   Pension Scheme for maximum Rs.10,000/-:-)                                 Rs. 20000
   e)Purchase of N.S.C. :-      …………………………………….                              Rs.   0
   f) Amount paid as excluisively tuition fees to any
   University/College/School for maximum of two
   Children( 2 )Maximum Rs.75000/-                                           Rs.   0
   g) Payment of H.B.Loan (Principal) :-                                     Rs. 12600
   h) Equity linked savings scheme/tax savings bond etc.:-                   Rs.   0
   j) Others, if any as notified :-
     i) 80U          0 ii)80DD            0 iii)80D        0                 Rs.   0
    iv)80E           0          v)80DDB                    0
   k) Total Amount Deducted (a to j) :-……………………….                            Rs. 69080      Rs.     69080
9 Taxable Income (7-8) :-…………………………………………………………….                                           Rs.     183681
10 i) Upto Rs.1,60,000/- Tax Nil,       (ii)Rs.1,60,001/-to 5,00,000/-Tax 10%
   iii) Rs.5,00,0001/- to 8,00,000/- Tax 20%, iv)Rs.8,00,001/-to Onwards Tax 30%
   v) For Women employee upto Rs.1,90,000/- Tax Nil
11 Total Tax :-………………………………………………………………………….                                                Rs.      2,368
12 3% Educational cess on tax :-……………………………………………………                                        Rs.        71
13 Tax payable including educational cess(Col.11 + 12) :-…………………..                          Rs.      2,439
14 Relief from arrear salary U/S 89(1)with Rule 21A (Form 10E enclosed)…….                           1,617
15 Net Tax payable( Col.13-14)              ………………………………………………………..                                   822
16 Tax already deducted from source :-………………………………………….                                     Rs.        0
17 Balance Tax                        -      Payable                                        Rs.       822

                                                        Signature of the employee
   Counter Signed by                                    Designation
                                                        Date




  www.pranab.jiaganj.com                             7/10
               Pay Statement for the year 2010-2011(April'10 to March'11)
MONTH &                                         Spl.
           B.PAY      D.A.    H.R.A.    M.A.                 TOTAL    G.P.F.     P.TAX       G.I.S.   H.B. ADV
 YEAR                                          Allwns

 Mar-09     14450     3179    2168      300       0          20097    3000        130         40          1050


 Apr-09     14450     3902    2168      300       0          20820    3000        130         40          1050


May-09      14450     3902    2168      300       0          20820    3000        130         40          1050


 Jun-09     14450     3902    2168      300       0          20820    3000        130         40          1050


 Jul-09     14850     4010    2228      300       0          21388    3000        130         40          1050


Aug-09      14850     4010    2228      300       0          21388    3000        130         40          1050


 Sep-09    14850      4010    2228      300       0          21388    3000        130         40          1050


 Oct-09     14850     4010    2228      300       0          21388    3000        130         40          1050


 Nov-09     14850         0   2228      300       0          17378    3000        130         40          1050


 Dec-09     14850         0   2228      300       0          17378    3000        130         40          1050


 Jan-10     14850         0   2228      300       0          17378    3000        130         40          1050


 Feb-10     14850         0   2228      300       0          17378    3000        130         40          1050


 TOTAL     176600 30925       26496     3600      0          237621   36000       1560       480          12600


           Note :- Total Advance Income Tax Paid during this Financial Year Rs.                       0




  Date:-                               Signature of the Emplyee                Designation




 www.pranab.jiaganj.com                               8/10
                                                       FORM NO.10 E
                                                          [See rule 21AA]


           Form for furnishing particulars of income under section 192(2A) for the year ending 31 st March, 2010 for
           claiming relief under section 89(1) by a Government servant or an employee in a 2[company,co-operative
           society,local authority ,university, instituty,Institution,association or body.
  1        Name and address of the employee                 Pranab Kr.             Bandyopadhyay
  2        Permanent account number              AA8899JJ

  3        Residential status                        RESIDENT AND ORDINARILY RESIDENT

              Particulars of income referred to in rule 21A of the Income-tax Rules, 1962,during the previous year relevant to
                                                          assessment year 2010-11

 1 (a)     Salary received in arrears or in advance in accordance with the provisions of sub-rule (2)
           of rule 21A.
                                                                                                                 15700
 (b)
           Payment in the nature of gratuity in respect of past services, extending over a period of
           not less than 5 years in accordance with the provisions of sub-rule (3) of rule 21A.
                                                                                                            Not Applicable

 (c)
           Payment in the nature of compensation from the employer or former employer at or in
           connection with termination of employment after continuous service of not less than 3            Not Applicable
           years or where the unexpired portion of term of employment is also not less than 3 ye

 (d)       Payment in commutation of pension in accordance with the provisions of sub-rule (5) of
           rule 21A
                                                                                                            Not Applicable
  2        Detailed particulars of payments referred to above may be given in Annexure I,II,IIA,III,
                                          or IV as the case may be.
                                                                                                               ANNEX-I


                                                                                   …………………………………………..
                                                                                   Signature of the employee

                                                            Verification
         I,                                         _______,do hereby declare that what is stated above
            is true to the best of my knowledge and belief.
                                Verified today, the                                Day of


Place: …………………….                                                            ………………………………………
Date:……………………                                                                 Signature of the employee




         www.pranab.jiaganj.com
                                                     ANNEXURE-I
                                          [See item 2 of Form No.10E]
                                         Arrears or advance salary
   Sl No.                                      Particulars                                   Amount (Rs.)
     1       Total income (excluding salary received in arrears or advance)                       167,981
     2       Salary received in arrears or advance                                                 15700
             Total income (as increased by salary received in arrears or advance)
     3
             [Add item 1 and item 2]
                                                                                                  183,681
     4       Tax on total income [as per item 3]                                                   2,439
     5       Tax on total income [as per item 1]                                                    822
             Tax on salary received in arrears or advance
     6
             [Difference of item 4 and item 5]
                                                                                                   1,617
             Tax computed in accordance with Table "A"
     7
             [Brought from column 7 of Table A]
                                                                                                      0
             Relief under Section 89(1) [Indicate difference between the amounts mentioned
     8
             against item 6 and item 7]                                                            1,617

                                                      TABLE "A"
                                               [See item 7 of Annexure 1]

             Total income      Salary      Total income (as    Tax on total Tax on total   Difference in tax
                of the       received in      increased by   income [as per  income[as [Amount under column
               relevent      arrears or salary received in column (2)-After per column    (6) minus amount
               previous       advance          arrears or       Rebate and     (4) After under column (5)]
             year    (Rs.) relating to the advance) of the    including Edn  Rebate and          (Rs.)
  Previous                    relevent     relevent previous     Cess and     including
    year                   previous year year mentioned         Surcharge]  Edn Cess and
                           as mentioned      in column (1)         (Rs.)     Surcharge]
                           in column (1) [add colmn 2 &                          (Rs.)
                                (Rs.)          3] (Rs.)



    (1)           (2)            (3)                 (4)                 (5)        (6)              (7)

2008-09       138,000          15700           153,700                   0          0                 0



                                                                 Signature:

Place:                                                           Name:

Date:                                                            Designation:
                                                                 Dept:




www.pranab.jiaganj.com

								
To top