Income tax return form ITR-5 for AY 2012-13 excel based

Income tax department has enabled income tax return form ITR-5 in excel for the assessment year 2012-13. Earlier income tax department has enabled Sahaj(ITR-1), ITR-2,ITR 3, ITR 4 and SUGAM(ITR-4S) for the assessment year 2012-13. ITR-5 form is to be filled by the firms, AOPs, BOIs and LLP. 

In this excel based ITR 5 income tax return form all the required fields are given with many sheets which will reduce any type of headache to file the income tax return. The given pages are as follows





Nature of business


Balance sheet

Profit and loss account

Other information

Quantitative details

House property

BP

Depreciation details

ESR

Schedule capital gains


Set off loss


Losses carried forward

Unabsorbed Depreciation

Section 10A deduction

Deduction in section 80G of income tax

Deduction in section 80IA of income tax

Exempt income

Advance tax

TDS/TCS details

Details of Tax paid outside India

 It is necessary to ENABLE the execution of macros in Return-Preparation-Utility in order to enter, validate and generate an .XML file for upload. Follow these steps to ENABLE execution of macros depending on the version of [Microsoft Office Excel] being used to open the Return-Preparation-Utility :

[Microsoft Office Excel 2003]

Navigate through the following excel menu option to reduce the level of security in executing macros :

Tools --> Macros --> Security --> Low

OR

Tools --> Macros --> Security --> Medium

Save the excel-utility and re-open it.


[Microsoft Office Excel 2007]

Navigate through the following excel menu options to reduce the level of security in executing macros :

Excel Options --> Trust Centre --> Trust Centre Settings --> Macro Settings --> Enable all macros

AND

Excel Options --> Trust Centre --> Trust Centre Settings --> ActiveX Settings --> Enable all controls without restriction and without prompting

Save the excel-utility and re-open it.

[Microsoft Office Excel 2010]

When you open the EXCEL-UTILITY, the yellow Message Bar appears with a shield icon and the Enable Content button. 
Click on the Enable Content to enable the macros.

Download ITR 5 excel based income tax return form
Tags-itr 5,itr 5 excel based,itr 5 2012-13,itr 5 12-13,excel form itr 5,itr 5 form,itr 5 ay 2012-13,itr 5 for whom,itr 5 acknowledgement 2012-13,itr 5 income tax,itr-5 income tax,itr 5 download,income tax return form 2012-13,income tax return forn ay 2012-13
Share on Google Plus

About Nitin Aggarwal

    Blogger Comment
    Facebook Comment