Form 24 in excel format for Annual Statement of Income Tax

Sheet5 Sheet4 Sheet3 Sheet2 Sheet1 FORM NO 24 (See Section 192 ad Rule 37) Annual return of "Salaries" under section 206 of the Income-tax Act, 1961 for the year ending 31st March 1.(a) (b) 2(a) (b) Road/Street/Lane Area/Locality Town/City/District State Pin Code 3 *. Has address of the employer/person responsibilbe for paying salary changed since filling the last return Tick √ as applicable Employer Yes No Person responsible for paying salary * If address has changed give changed address in column 2(b)/4(b) 4.(a) Flat/door/Block Number Name of the Premises/Building Name of the person responsible for paying salary(if not the employer (If not the employer) Address of the Employer:- Address of the person responsible for paying salary :- Tax Deduction Account No :- Permanent Account No :- Name of the Employer:- Flat/Door/Block Number :- Name of the premises/Building :- Road/Street/Lane :- Area/Locality :- Town/City/District :- State :- Pin Code :- Permanent Account Number(PAN) of the employee Name of the employee Period for which employed during the financila year Total Amount of Salary,exculding amount required to be shoen in clumns 206 & 207(see note Total amount of house rent allowances and other allowances to the extent chargeable to tax[see section 10(13A)] read woth rule 2A and section 10(14)] Value of perquistes and amount of accretion to employee's Provident Fund account as per Annexure Amount of allowances and perquisites claimed as exempt and not included in columns 206 and 207 Total of Columns 205+206+207 Total deductions under section 16(i),16(ii) and 16(iii) (specify each deduction separately) Income chargeable under the head "Salaries"(coumn 209 - 210 Income (including loss from house property) under any head other thatn income under the head "Salaries" offered or TDS[Section 192(2B)] Amount deductable under section 80G in respect of donations to certain funds,charitable institutions. Amount deductible under section 80GG in respect of rents paid Amount deductible under any other provision of Chapter VI-A(indicate relevant section and amount deeducted) Total amount deductible under Chapter VI-A(Total of Columns 214+215+216) Total Taxable Income (Column 213 - 217) Income Tax on Total Income Income tax rebate under section 88 on the insurance premium,contribution to provident fund etc(see note 2) Income Tax Rebate under section 88 B) Income Tax Rebate under section 88 C Tot6al Income-tax payable (column 219 - (220+221+222)and surcharge thereon Income tax relief under section 89,when salary etc. is paid in arrears or in advance Net tax payable(Colmn 223 - 224) Tax deducted at source-income tax Tax deducted at source-surcharge Total income tax deducted at source(total of columns 226+227) Tax payable/refundable(Difference of Colmns 225 - 228) Remarsks(See notes 3 and 4 Gross total income (Total of colmn 211+212) Pranab Bandyopadhyay 31/3/11 Date To PAN No Sl.No Sl. No 5. Details of salary paid and tax deducted thereon from the employees Date from 6. Details of tax deducted and paid to the credit of the Central Government Amount Deducted Transfer Voucher/Challan No. given by Bank Date ofTransfer Voucher/Challan Bank Branch Code Total Rs. Note:- Government deductors to give particulars of transfer vouchers, other deductors to give particulars of challan no. regarding deposit into bank I Certify that : (i) the above return consists of ……………….pages serially numbered from …………………to…………………………..and furnishes the prescribed particulars in respect of ……………………………( given number employees) (ii) to all persons shose income for the year under the head "Salaries" exceeded the maximum amount which is not taxable under the Finance Act of the year. (iii) The amount of tax shown in clumn 226 has been paid to the Central Government vide particulars given in item number 6 above. (iv) All the particulars furnished in the return and the Annexure are correct. Place……………………………. Date…………………………….. Name and Signature of the employer/person responsible for paying Salary Designation Notes: 1. Salary includes wages, annuity, pension, gratuity, fees, commission, bonus, repayment of amount deposited under the Additional Emoluments (Compmpulsory Deposit) Act, 1974, or profits in lieu of or in addition to salary or wages, including payments made at or incooection with termination of employment adgvance of salary or any other sums chargeable to income-tax under the head "Salaries". 2. Where an employer deducts from the amoluments paid to an employee or pays on his behalf any contributions of that employee to any approved superannuation fund,all such deductions or payments should be included in the return. 3. Where tad has been deducted at a lower rate or no tax has been deducted on the basis of a certificate given by the Assessing Officer under section 197(1), This should be indicated in this column and a copy of such order should be attached along with the return. 4. Please record on every page the totals of each the columns. The above return contains complete details of total amount chargeable under the heae"Salaries" paid by ………………… (a) Tax Deduction Account No. Permanent Account No Name of the Employer Address of the employer Flat/Doof/Block Number Name of the Primess/Building Particulars of value of perquisites and amount of accretion to Employee"s Provident Fund Account for the year ending 31st March……………………. Name of Employee Employee"s Serial No.in Form No.24 Where accommodation is unfurnished Value as if accommodation is unfurnished Cost of furniture (Including TV sets,radiosets, refrigerators, other household applicanes and air-conditioning plant or equipment Perquisite value of furniture(10% of column 240) Total of Columns 239 and 241 Rent, if any, paid by the employee Value of perquisite(Column 238 minus 243 or Column 242 minus Column 543, as may be applicable) Where any conveyance has been provided by the employer free or at a concessional rate or where the employee is allowed the use of one or more motor cars owned or hired by the employer or where the employer incurs the running expenses of a motor car owned by employees estimated value of perquisite(give details) Remuneration paid by the employer for domestic and personal service provided to the employee(give details) Value of free or concessional passages on home leave and other travelling to the extent chargeable to tax(give details) Estimated value of any other benefit or amenity provided by the employer free of cost of at concessional rate not included in the prcceding columns(give details) Employer"s contribution to recognised provident fund in excess of 12% of the employee"s salary interest credited to the assessee"s account in recognised provident fund in excess of the rate fided by Central Government Total of columns 244 to 250 carried to column 207 of Form No. 24. Value of rent-free accomodation or value of any concession in rent for the accommodation provided by the employer(give basis of computation) Where accommodation is furnished Place Date Name and signature of employer/person responsible for paying salary Designation……………… www.pranab.jiaganj.com 5 www.pranab.jiaganj.com 5 www.pranab.jiaganj.com 5 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 www.pranab.jiaganj.com 4 www.pranab.jiaganj.com 4 www.pranab.jiaganj.com 4 0.00 0.00 www.pranab.jiaganj.com 3 www.pranab.jiaganj.com 3 www.pranab.jiaganj.com 3 000.00 000.00 000.00 000.00 000.00 0.00 www.pranab.jiaganj.com 2 www.pranab.jiaganj.com 2 www.pranab.jiaganj.com 2 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 000.00 0.00 0000000000.00 5/1/2009 000000.00 0.00 0.00 0.00 0000.00 0.00 0.00 0.00 00000.00 000000.00 00000.00 0.00 0.00 0.00 0000.00 0.00 0.00 0000000000.00 000000.00 0.00 0000000000.00 0.00 0.00 0.00 0.00 0.00 0.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 00.00 www.pranab.jiaganj.com www.pranab.jiaganj.com www.pranab.jiaganj.com