Income Tax Calculator - Excel by 75mzELcr

VIEWS: 156 PAGES: 5

									                       DDO Information
Name of the Office
Address
Name of the DDO
Son of
Designation
PAN of the Deductor
TAN of the Deductor
Place
Date

                       Employee Information
Name of the Employee                                         Shri
Designation
Pan No
Male / Female             F
(Write M for Male & F for Female )

                                Summary of Tax Deducted at Source
                                  Receipt Numbers               Date   Tax deducted Tax deposite
                                                                        in respect of in respect of
                                                                       the employee the employee

      Quarter 1
      Quarter 2
      Quarter 3
      Quarter 4
                                                              Pay and Allowance Statement
                                                                                                                                               Prepared by mfas.in
Name :-       Shri 0                                                  Design.                      0                             F.Y.                    2011-12
   Office     :                        0                                                                           PAN No. :                             0
                                                                                                                                                      Hsg.
                                                                               H.B.A               L.I.C
                                                 Othr                                                                C.M.               Tution Mutual Loan
 Period     Basic      GP   D.A   HRA      C.L.A        TA   TOTAL G.P.F G.I.S Re           P.T    From      I.Tax             PPF NSC
                                                 All.                                                                Fund                Fee    fund Principl
                                                                              covery               Salary
                                                                                                                                                      e Private
Mar-11        0        0     0     0         0    0     0      0      0         0     0       0         0      0       0          0   0       0     0         0
Apr-11        0        0     0     0         0    0     0      0      0         0     0       0         0      0       0                             0
May-11        0        0     0     0         0    0     0      0      0         0     0       0         0      0       0    L.I.C                    0
                                                                                                                            Privat
Jun-11        0        0     0     0         0    0     0      0      0         0     0       0         0      0       0                             0
                                                                                                                              e
Jul-11        0        0     0     0         0    0     0      0      0         0     0       0         0      0      500        0
Aug-11        0        0     0     0         0    0     0      0      0         0     0       0         0      0       0          0     LIC. Jivan                0          0
                                                                                                                                        Suraksha                       Hsg.
Sep-11        0        0     0     0         0    0     0      0      0         0     0       0         0      0       0          0                       Medi
                                                                                                                                         80CCC                         Loan
Oct-11        0        0     0     0         0    0     0      0      0         0     0       0         0      0       0                     0            claim
                                                                                                                                                                      Interest
Nov-11        0        0     0     0         0    0     0      0      0         0     0       0         0      0       0                U/S/80CCD
Dec-11        0        0     0     0         0    0     0      0      0         0     0       0         0      0       0
Jan-12        0        0     0     0         0    0     0      0      0         0     0       0         0      0       0               NSS
Feb-12        0        0     0     0         0    0     0      0      0         0     0     300         0      0       0
Total         0        0     0     0         0    0     0      0      0         0     0     300         0      0      500         0        0         0            0          0
                                                                                     Hsg. Loan                                   HRA           Dedn u/s80U
                                                                                                                                                              Relief
     Others                                                           0         0   Principle as       PLI     0      80G                           for
                                                                                                                               Exemption                      U/s 89
                                                                                      per (U6)                                                 Orthopedically
Pay Adv                                                               0         0         0             0      0      500          0                 0               0
Arrears                                                        0
 TOTAL        0        0     0     0         0    0     0      0      0         0     0     300         0      0     1000          0                                         0
टिप :-
1   घरभाडे भत्‍त्‍याचा दर 30 % प्रमाणे घणेेयात आलेले असून आपला दर 20% क िं वा 10% असल्यास त्‍यानुसार formula (E-6 ते E-17) मध्ये आवश्य   ते बदल   रणे.

2   Tution Fees ची रक् म भरतािंना S-6 मध्ये पटिल्या मुलाची तर S-8 मध्ये दस-या मुलाची फी भरावी.
                                                                         ु
                                                                                                                                      Prepared by mfas.in
                                                                     FORM NO. 16
                                                                   [See rule 31 (1) (a)]
                                                                         Part A
                    Certificate under section 203 of the Income-tax Act, 1961 for tax deducted at source on Salary
                      Name and address of the Employer                                        Name and design.of the Employee                       F
                                           0                                                     Shri            0
                                           0                                                                         0
             PAN of the Deductor                      TAN of the Deductor                                   PAN of the Employee
                       0                                       0                                                     0
                                       CIT (TDS)                                                  Assesment Year                     Period
Address :                                                                                                                     From           To
                                                                                                   2012 - 2013              4/1/2011     31/03/2012
City :                                  Pin Code :
                                                          Summary of tax deducted at source
  Quarter     Receipt Numbers of original satatments of TDS under sub-                  Amount of tax deducted in respect of        Amount of tax deposited
              section(3)of Section 200                                                             the employee                     remitted in respect of the
                                                                                                                                            employee
 Quarter 1                         0                              1/0/1900                               0                                       0
 Quarter 2                         0                              1/0/1900                               0                                       0
 Quarter 3                         0                              1/0/1900                               0                                       0
 Quarter 4                         0                              1/0/1900                               0                                       0
Total                                                                                                    0                                       0
                                                          Part B
                             DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED
1.    Gross Salary                                                                                                             0
(a)   Salary as per provisions contained in section 17 (1)                                                                     0
(b)    Value of perquisites under section 17 (2)                                                                               0
(c)   Profits in lieu of salary under section 17 (3) ((For (b)&(c)as per Form No. 12BB, wherever applicable)
                                                                                                                               0
(d) Total                                                                                                                                       0
2. Less : i) Allowance to the extent exempt u/s 10
                        Allowance                                                  Rs.
              HRA Exemption                                                       0                                            0
              TA                                                                  0                                            0                0
3. Balance (1-2)                                                                                                                                0
4. Deductions :
(a) Entertainment allowance                                                                                                 0
(b) Tax on Employment                                                                                                     300
5. Aggregate of 4 (a) and (b)                                                                                                              300
6. Income chargeable under the head ‘Salaries’ (3-5)                                                                                                       -300
7. Add : Any other income reported by the employee
                          Income                                                   Rs
                Interest on Housing Loan.                                          0
                                                                                                                                                0
8. Gross total income (6+7)                                                                                                                                -300
9. Deductions under Chapter VI A
(A) Sections 80 C, 80 CCC and 80 CCD                                                                                 Gross         Deductible
                                                                                                                     Amount         Amount
  (a) section 80C
  (i) GPF                                                                                                                      0                0
  (ii) PPF                                                                                                                     0                0
  (iii) HSG. LOAN REPAYMENT                                                                                                    0                0
  (iv) G.I.S.                                                                                                                  0                0
  (v) LIC                                                                                                                      0                0
  (vi) PLI                                                                                                                     0                0
  (vii) NSC/NSS                                                                                                                0                0
  (vii) TUTION FEE                                                                                                             0                0
  (viii) OTHERS                                                                                                                0                0
Total Saving u/s 80 C                                                                                                          0                0
(b)      section 80CCC                                                                                                         0                0
(c)     section 80CCD                                                                                                          0                0
Total Saving u/S 80 C, 80CCC, 80CCD Restricted upto one lakh rupees                                                            0                0           0
Note : 1. Aggregate amount deductible under section 80 C shall not exceed one lakh rupees.
  2. Aggregate amount deductible under the three sections, i.e. 80C, 80CCC, 80 CCD shall not exceed one lakh rupees.
(B) Other section (for e.g. 80E, 80G etc) under Chapter VI A
                                                                                                               Gross      Qualifying        Deductible
                                                                                                               Amount     Amount            Amount
(i) Section 80 G./                                                                                                   1000     750                      750
(ii) Section 80 D Mediclaim                                                                                             0       0                        0
(iii) Section 80 DD Ortho.Handicapped.                                                                                  0       0                        0
(iv) Section                                                                                                            0       0                        0
(v) Section                                                                                                             0       0                        0
10. Aggregate of Deductible amount under Chapter VI-A                                                                                                  750
11. Total Income (8-10)                                                                                                                              -1050
12. Tax on total income                                                                                                                                  0
13. Education Cess (on tax at S.No.12 and surcharge at S.No.13)                                                                                          0
14. Tax payable (12+13)                                                                                                                                  0
15 Relief under section 89 (attach details)                                                                                                              0
16. Tax Paid                                                                                                                                             0
17. Tax payable (14-15-16)                                                                                                                               0
                                                                       Verification


            I,                              0 son of                               0 Working in the capacity of                         0
do hereby certify that a sum of Rs.                      0 [ Rs ]                                                   has been deducted and deposited to the
credit of the Central Government, I further certify that the information given about is true, complete and corret and is based on the books of
account, documents, TDS Statement, TDS Deposited and other available records.
Place       0
                                                                                            Signature
Date        1/0/1900
Designation 0                                                                      Full Name                                         0

								
To top