Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Download-Income-Tax-Calculator-in-Excel-for-financial-Year-2009-2010

VIEWS: 22 PAGES: 9

									NOTE :              PLEASE DO NOT CHANGE ANY FIGURE OF COLOURED COLUMN
                    FILL ONLY BLANK COLUMN                                                                                                         INCOME TAX CALCULATOR FOR MALE
                                                       COMPANY NAME : DIPTY LAL JUDGE MAL PVT. LTD. NOIDA
                                           CALCULATION OF INCOME TAX(TDS) FOR THE YEAR -2009-2010 (01/04/09 TO 31/03/10)

NAME :                                                                 DESIGNATION
SEX :               MALE                                               DEPTT.




                                                                                                                  SALARY/ LEAVE



                                                                                                                                  INCENTIVE ETC.
                                                HRA




                                                                                                  OTHER INCOME
                                                                                                  PERQUISTIES &




                                                                                                                                                                                                                REMIBUSEMEN
                        BASIC SALARY




                                                                                                                                                                      BASIC SALARY
                                                                                                                                                     TOTAL GROSS




                                                                                                                                                                                     ADVANCE TAX




                                                                                                                                                                                                                MEDICAL EXP




                                                                                                                                                                                                                               MEDICAL EXP
                                                                        CONVEYANCE



                                                                                     CONVEYANCE
                                                                        ALLOWANCE



                                                                                     ALLOWANCE




                                                                                                                                  BONUS/GIFT/




                                                                                                                                                                                                   NET SALARY
                                                                                                                  SALARY ( IF
                                                                                                                  ARREAR OF




                                                                                                                                                                      EPF 12% OF



                                                                                                                                                                                     DEDUCTED/
                                                                                     EXEMPTED
                                                       RENT PAID
                                        HRA RECD

                                        COMPANY




                                                                                                                                                                                                                               TAXABLE
                                                                                                                                                     SALARY
         MONTH




                                        FROM




                                                                        PAID




                                                                                                                                                                                     PAID


                                                                                                                                                                                                   PAID
                                                                                                                                                                                     TDS




                                                                                                                                                                                                                T
  PREVIOUS
  EMPLOYER
   SALARY                                                                                   0                                                             0                                              0                                   0
APRIL'2009             12000                  6000          7200              750         750         6810                                            25560             1440               500       23620                                   0
MAY                    12000                  6000          7200              200         200         6810                                            25010             1440               500       23070                                   0
JUNE                   12000                  6000          7200              200         200         6810                                            25010             1440               500       23070                                   0
JULY                   12000                  6000          7200              200         200         6810                                            25010             1440               500       23070                                   0
AUGUST                 12000                  6000          7200              200         200         6810                        25000               50010             1440               500       48070                                   0
SEPT.                  12000                  6000          7200              200         200         6810                                            25010             1440               500       23070                                   0
OCT.                   12000                  6000          7200              200         200         6810                                            25010             1440               500       23070                                   0
NOV.                   12000                  6000          7200              200         200         6810                                            25010             1440               500       23070                                   0
DEC.                   12000                  6000          7200              200         200         6810                                            25010             1440               500       23070                                   0
JAN.2010               12000                  6000          7200              200         200         6810                                            25010             1440               500       23070                                   0
FEB.                   12000                  6000          7200              200         200         6810                                            25010             1440               500       23070                                   0
MARCH                  12000                  6000          7200              200         200         6810                                            25010             1440               500       23070                                   0
TOTAL                 144000               72000       86400                 2950       2950       81720                    0     25000              325670 17280                         6000     302390                 0                  0
ANNUAL TOT            144000               72000       86400                 2950       2950       81720                    0     25000              325670 17280                         6000     302390                 0                  0
                                                                                                                                                                                                                          0
WORKING:-                                            AMOUNT                                                                                        COMPUTATION FOR FY 2009-2010                                               AMOUNT

CONVEYANCE RECEIVED.                                        2950                                                                                   1. BASIC SALARY                                                             144000
LESS : DED.(800/- PM )                                      2950                                                                                   2. HRA TAXABLE                                                                   0
                                                               0                                                                                   3. CONVEYANCE TAXABLE                                                            0
HRA RECEIVED                                           72000                                                                                       4. SPL ALLOWANCE                            81720
50% OF SAL(NOIDA 40%)                                  72000                                                                                       5. BONUS & EXGRATIA & INCENTIVE             25000
RENT PAID        86400                                                                                                                             6. ARREAR OF SALARY/ LEAVE SALARY (IF ANY)      0
                                                                                                                                                   7. OTHER INCOME RECD.                       20000
                                                                                                                                                   8. MEDICAL EXP REMIBURSE > 15000                0
BASIC TOT             144000                                                                                                                                          TOTAL                   270720
BAS SAL%10             14400                           72000                                                                                       9.INCOME FROM HOUSE PROPERTY
HRA EXEMPT                                             72000                                                                                                Interest on Home Loan         0        0
                                                                                                                                                    GROSS TOTAL INCOME                        270720
TAXABLE HOUSE RENT                                                 0                                                                                  DEDUCTION U/S 80 C
                                                                                                                                                   Deduction allowed U/S 80 C                                     100000
         DEDUCTION U/S 80 C                                                                                                                             DEDUCTION U/S 80 D
PROVIDENT FUND                                         17280                                                                                       Deduction allowed U/S 80 d                                         4000
LIC PAID                                               55565                                                                                          DEDUCTION U/S 80 G**
NSC PURCHASED                                                                                                                                      Deduction allowed U/S 80 G                                             0
TUTION FEES                                                                                                                                            TOTAL DEDUCTIONS                                                        104000
PPF DEPOSIT                                            30000                                                                                          NET TOTAL INCOME                                                         166720
OTHERS                                                                                                                                             TAX DUE ON RS. R/ OFF                                            166720
REPAYMENT OF HLA                                                                                                                                                   TAX PAYBLE                                                           672
TOTAL                                                 102845                                                                                       ADD: EDUCATIONAL CESS 3%                                                                  20
MAXI.LIMIT Deduction U/S 80 C                          100000                                                                                          TOTAL TAX PAYBLE                                                               692
DEDUCTION U/S 80 D - MEDICLAIM INSURANCE                                                                                                           TDS DEDUCTED / ADVANCE TAX                                                        6000
MEDICLAIM INSURANCE PAID                                     4000                                                                                  BALANCE TAX PAYABLE                                                             -5308
DEDUCTION U/S 80 G                     PAID          EXEMPT                                                                                        AVERAGE MONTLY TDS                                                                        58
DONATION PAID ( 100%)                                              0
DONATION PAID (50% )                                               0
DEDUCTION U/S 80 G                                                 0   **

**ADJUSTED GROSS TOTAL
INCOME FOR THE PURPOSE OF
DEDUCTION U/S 80 G

GROSS TOTAL INCOME                                    270720
LESS DEDUTION U/S 80C                                 100000
LESS DEDUTION U/S 80D                                   4000
ADJUSTED GTI                                          166720
10 % of Adjusted GTI                                   16672
DONATION PAID                                                                                                                                      SIGNATURE OF EMPLOYEE
Deduction u/s 80 G          MINIMUM OF
50% of donation paid or 50 % of (10% of adjusted GTI
                0 or              8336
Deduction u/s 80 G                   0
NOTE :           PLEASE DO NOT CHANGE ANY FIGURE OF COLOURED COLUMN
                 FILL ONLY BLANK COLUMN                                                                                                                 INCOME TAX CALCU
                                                       COMPANY NAME : DIPTY LAL JUDGE MAL PVT. LTD. NOIDA
                                         CALCULATION OF INCOME TAX(TDS) FOR THE YEAR -2009-2010 (01/04/09 TO 31/03/10

NAME :                                                                   DESIGNATION
SEX :            FEMALE                                                  DEPTT.




                                                                                                                       SALARY/ LEAVE
                                             HRA




                                                                                                                                       INCENTIVE ETC.
                                                                                                   OTHER INCOME
                                                                                                   PERQUISTIES &
                   BASIC SALARY




                                                                                                                                                              TOTAL GROSS
                                                                         CONVEYANCE



                                                                                      CONVEYANCE
                                                                         ALLOWANCE



                                                                                      ALLOWANCE




                                                                                                                                       BONUS/GIFT/
                                                                                                                       SALARY ( IF
                                                                                                                       ARREAR OF
                                                                                      EXEMPTED
                                                       RENT PAID
                                      HRA RECD

                                      COMPANY




                                                                                                                                                              SALARY
         MONTH




                                      FROM




                                                                         PAID
  PREVIOUS
  EMPLOYER
   SALARY                                                                      300         300                                                                       300
APRIL'2009                                                                                   0                                                                         0
MAY                                                                                          0                                                                         0
JUNE                                                                                         0                                                                         0
JULY                                                                                         0                                                                         0
AUGUST                                                                                       0                                                                         0
SEPT.                                                                                        0                                                                         0
OCT.                                                                                         0                                                                         0
NOV.                                                                                         0                                                                         0
DEC.                                                                                         0                                                                         0
JAN.2010                                                                                     0                                                                         0
FEB.                                                                                         0                                                                         0
MARCH                                                                                        0                                                                         0
TOTAL                             0              0                  0          300         300                     0             0                      0            300
ANNUAL TOT                        0              0                  0          300         300                     0             0                      0            300


WORKING:-                                            AMOUNT                                                                                                 COMPUTATION FOR FY

CONVEYANCE RECEIVED.                                               300                                                                                      1. BASIC SALARY
LESS : DED.(800/- PM )                                             300                                                                                      2. HRA TAXABLE
                                                                     0                                                                                      3. CONVEYANCE TAXAB
HRA RECEIVED                                                        0                                                                                       4. SPL ALLOWANCE
50% OF SAL(NOIDA 40%)                                               0                                                                                       5. BONUS & EXGRATIA &
RENT PAID            0                                                                                                                                      6. ARREAR OF SALARY/
                                                                                                                                                            7. OTHER INCOME RECD
                                                                                                                                                            8. MEDICAL EXP REMIBU
BASIC TOT                         0
BAS SAL%10                        0                                 0                                                                                       9.INCOME FROM HOUSE
HRA EXEMPT                                                          0
                                                                                                                                                            GROSS TOTAL INCOME
TAXABLE HOUSE RENT                                                  0                                                                                        DEDUCTION U/S 80 C
                                                                                                                                                            Deduction allowed U/S 80 C
        DEDUCTION U/S 80 C                                   DEDUCTION U/S 80 D
PROVIDENT FUND                                  0        Deduction allowed U/S 80 C
LIC PAID                                                   DEDUCTION U/S 80 G**
NSC PURCHASED                                            Deduction allowed U/S 80 G
TUTION FEES                                                 TOTAL DEDUCTIONS
PPF DEPOSIT                                                NET TOTAL INCOME
OTHERS                                                   TAX DUE ON RS. R/ OFF
REPAYMENT OF HLA                                                TAX PAYBLE
TOTAL                                           0        ADD: EDUCATIONAL CESS
MAXI.LIMIT Deduction U/S 80 C              100000           TOTAL TAX PAYBLE
DEDUCTION U/S 80 D - MEDICLAIM INSURANCE                 TDS DEDUCTED / ADVAN
MEDICLAIM INSURANCE PAID                                 BALANCE TAX PAYABLE
DEDUCTION U/S 80 G              PAID   EXEMPT            AVERAGE MONTLY TDS
DONATION PAID ( 100%)                           0
DONATION PAID (50% )                            0
DEDUCTION U/S 80 G                              0   **

**ADJUSTED GROSS TOTAL
INCOME FOR THE PURPOSE OF
DEDUCTION U/S 80 G

GROSS TOTAL INCOME                        310000
LESS DEDUTION U/S 80C                          0
LESS DEDUTION U/S 80D                          0
ADJUSTED GTI                              310000
10 % of Adjusted GTI                       31000
DONATION PAID                                            SIGNATURE OF EMPLOY
Deduction u/s 80 G          MINIMUM OF
50% of donation paid or 50 % of (10% of adjusted GTI
                0 or             15500
Deduction u/s 80 G                   0
INCOME TAX CALCULATOR FOR FEMALE
VT. LTD. NOIDA
-2010 (01/04/09 TO 31/03/10)
             BASIC SALARY




                                                       REMIBUSEMEN
                            ADVANCE TAX




                                                       MEDICAL EXP




                                                                      MEDICAL EXP
                                          NET SALARY
             EPF 12% OF



                            DEDUCTED/




                                                                      TAXABLE
                            PAID


                                          PAID
                            TDS




                                                       T




                                                 300                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0           0            300             0                  0
                        0           0            300             0                  0
                                                                 0
 COMPUTATION FOR FY 2009-2010                                        AMOUNT

 1. BASIC SALARY                                                                    0
                                                                                    0
 3. CONVEYANCE TAXABLE                                                              0
 4. SPL ALLOWANCE                                0
 5. BONUS & EXGRATIA & INCENTIVE                 0
 6. ARREAR OF SALARY/ LEAVE SALARY (IF ANY)      0
 7. OTHER INCOME RECD.                      310000
 8. MEDICAL EXP REMIBURSE > 15000                0
                    TOTAL                   310000
 9.INCOME FROM HOUSE PROPERTY
          Interest on Home Loan         0        0
  GROSS TOTAL INCOME                        310000
    DEDUCTION U/S 80 C
 Deduction allowed U/S 80 C                                      0
    DEDUCTION U/S 80 D
Deduction allowed U/S 80 C       0
  DEDUCTION U/S 80 G**
Deduction allowed U/S 80 G       0
   TOTAL DEDUCTIONS                        0
  NET TOTAL INCOME                    310000
TAX DUE ON RS. R/ OFF        310000
       TAX PAYBLE                      13000
ADD: EDUCATIONAL CESS 3%                 390
   TOTAL TAX PAYBLE                    13390
TDS DEDUCTED / ADVANCE TAX                 0
BALANCE TAX PAYABLE                   13390
AVERAGE MONTLY TDS                     1116




SIGNATURE OF EMPLOYEE
NOTE :           PLEASE DO NOT CHANGE ANY FIGURE OF COLOURED COLUMN
                 FILL ONLY BLANK COLUMN                                                                                                           INCOME TAX CALCULA
                                                       COMPANY NAME : DIPTY LAL JUDGE MAL PVT. LTD. NOIDA
                                         CALCULATION OF INCOME TAX(TDS) FOR THE YEAR -2009-2010 (01/04/09 TO 31/03/10

NAME :                                     DESIGNATION
SEX :            MALE/FEMALE - SR. CITIZEN DEPTT.




                                                                                                                       SALARY/ LEAVE
                                             HRA




                                                                                                                                       INCENTIVE ETC.
                                                                                                   OTHER INCOME
                                                                                                   PERQUISTIES &
                   BASIC SALARY




                                                                                                                                                              TOTAL GROSS
                                                                         CONVEYANCE



                                                                                      CONVEYANCE
                                                                         ALLOWANCE



                                                                                      ALLOWANCE




                                                                                                                                       BONUS/GIFT/
                                                                                                                       SALARY ( IF
                                                                                                                       ARREAR OF
                                                                                      EXEMPTED
                                                       RENT PAID
                                      HRA RECD

                                      COMPANY




                                                                                                                                                              SALARY
         MONTH




                                      FROM




                                                                         PAID
  PREVIOUS
  EMPLOYER
   SALARY                                                                      300         300                                                                       300
APRIL'2009                                                                                   0                                                                         0
MAY                                                                                          0                                                                         0
JUNE                                                                                         0                                                                         0
JULY                                                                                         0                                                                         0
AUGUST                                                                                       0                                                                         0
SEPT.                                                                                        0                                                                         0
OCT.                                                                                         0                                                                         0
NOV.                                                                                         0                                                                         0
DEC.                                                                                         0                                                                         0
JAN.2010                                                                                     0                                                                         0
FEB.                                                                                         0                                                                         0
MARCH                                                                                        0                                                                         0
TOTAL                             0              0                  0          300         300                     0             0                      0            300
ANNUAL TOT                        0              0                  0          300         300                     0             0                      0            300


WORKING:-                                            AMOUNT                                                                                                 COMPUTATION FOR FY

CONVEYANCE RECEIVED.                                               300                                                                                      1. BASIC SALARY
LESS : DED.(800/- PM )                                             300                                                                                      2. HRA TAXABLE
                                                                     0                                                                                      3. CONVEYANCE TAXAB
HRA RECEIVED                                                        0                                                                                       4. SPL ALLOWANCE
50% OF SAL(NOIDA 40%)                                               0                                                                                       5. BONUS & EXGRATIA &
RENT PAID            0                                                                                                                                      6. ARREAR OF SALARY/
                                                                                                                                                            7. OTHER INCOME RECD
                                                                                                                                                            8. MEDICAL EXP REMIBU
BASIC TOT                         0
BAS SAL%10                        0                                 0                                                                                       9.INCOME FROM HOUSE
HRA EXEMPT                                                          0
                                                                                                                                                            GROSS TOTAL INCOME
TAXABLE HOUSE RENT                                                  0                                                                                        DEDUCTION U/S 80 C
                                                                                                                                                            Deduction allowed U/S 80 C
        DEDUCTION U/S 80 C                                   DEDUCTION U/S 80 D
PROVIDENT FUND                                  0        Deduction allowed U/S 80 C
LIC PAID                                                   DEDUCTION U/S 80 G**
NSC PURCHASED                                            Deduction allowed U/S 80 G
TUTION FEES                                                 TOTAL DEDUCTIONS
PPF DEPOSIT                                                NET TOTAL INCOME
OTHERS                                                   TAX DUE ON RS. R/ OFF
REPAYMENT OF HLA                                                TAX PAYBLE
TOTAL                                           0        ADD: EDUCATIONAL CESS
MAXI.LIMIT Deduction U/S 80 C              100000           TOTAL TAX PAYBLE
DEDUCTION U/S 80 D - MEDICLAIM INSURANCE                 TDS DEDUCTED / ADVAN
MEDICLAIM INSURANCE PAID                                 BALANCE TAX PAYABLE
DEDUCTION U/S 80 G              PAID   EXEMPT            AVERAGE MONTLY TDS
DONATION PAID ( 100%)                           0
DONATION PAID (50% )                            0
DEDUCTION U/S 80 G                              0   **

**ADJUSTED GROSS TOTAL
INCOME FOR THE PURPOSE OF
DEDUCTION U/S 80 G

GROSS TOTAL INCOME                        310000
LESS DEDUTION U/S 80C                          0
LESS DEDUTION U/S 80D                          0
ADJUSTED GTI                              310000
10 % of Adjusted GTI                       31000
DONATION PAID                                            SIGNATURE OF EMPLOY
Deduction u/s 80 G          MINIMUM OF
50% of donation paid or 50 % of (10% of adjusted GTI
                0 or             15500
Deduction u/s 80 G                   0
NCOME TAX CALCULATOR FOR SR. CITIZEN
VT. LTD. NOIDA
-2010 (01/04/09 TO 31/03/10)
             BASIC SALARY




                                                       REMIBUSEMEN
                            ADVANCE TAX




                                                       MEDICAL EXP




                                                                      MEDICAL EXP
                                          NET SALARY
             EPF 12% OF



                            DEDUCTED/




                                                                      TAXABLE
                            PAID


                                          PAID
                            TDS




                                                       T




                                                 300                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0                          0                                0
                        0           0            300             0                  0
                        0           0            300             0                  0
                                                                 0
 COMPUTATION FOR FY 2009-2010                                        AMOUNT

 1. BASIC SALARY                                                                    0
                                                                                    0
 3. CONVEYANCE TAXABLE                                                              0
 4. SPL ALLOWANCE                                0
 5. BONUS & EXGRATIA & INCENTIVE                 0
 6. ARREAR OF SALARY/ LEAVE SALARY (IF ANY)      0
 7. OTHER INCOME RECD.                      310000
 8. MEDICAL EXP REMIBURSE > 15000                0
                    TOTAL                   310000
 9.INCOME FROM HOUSE PROPERTY
          Interest on Home Loan         0        0
  GROSS TOTAL INCOME                        310000
    DEDUCTION U/S 80 C
 Deduction allowed U/S 80 C                                      0
    DEDUCTION U/S 80 D
Deduction allowed U/S 80 C       0
  DEDUCTION U/S 80 G**
Deduction allowed U/S 80 G       0
   TOTAL DEDUCTIONS                        0
  NET TOTAL INCOME                    310000
TAX DUE ON RS. R/ OFF        310000
       TAX PAYBLE                       8000
ADD: EDUCATIONAL CESS 3%                 240
   TOTAL TAX PAYBLE                     8240
TDS DEDUCTED / ADVANCE TAX                 0
BALANCE TAX PAYABLE                    8240
AVERAGE MONTLY TDS                      687




SIGNATURE OF EMPLOYEE

								
To top