myITreturn Capital Gain Template features:

• Import all data of top brokers into the excel template.

• Current import allowed from - Zerodha, ICICI, HDFC, PAYTM, UPSTOX

• Export to common format ready to be filed with myITreturn.com or Income-tax Department utility.

How to download the template?

Post login to myITreturn.com while you are on the Capital Gain: Securities page, click the "Import data from broker/traders sheet" option.

How to Import details of broker file into this template?

Download our excel template

Enable macros and fill data manually in excel template

How to validate details and correct errors if any?

After filling data right click any where, a capital gain template window will pop up. Select year and select format you wish to export into. Then click verify and export, errors if any will pop up as shown below

How to export details in desired format?

Enable macros and right click anywhere and below window will pop up. Select year and select format you wish to export to and click verify and export.

How to upload details onto myITreturn.com?

Come back on Capital Gain: Securities page and click on Select file and upload .mtr file.

Your data is uploaded. You may add, edit or delete record

You can also download record

How to export details in Income-tax Department utility?

Download .csv and login to Income-tax portal. Post login while you are filling details of capital gains, click on Schedule 112A. In Schedule 112A click on upload csv

Your capital gains records will be uploaded. Click on confirm

That's it. Your records are uploaded and your gain is also calculated here. You may now move ahead and fill in all your other details and finish filing your return.