Here is how you can upload your Capital Gains using the Quicko Template:
1. Navigate to Incomes, Select Capital Gains.
2. Choose Import Investments, Select Import with Excel Sheet.
3. Download Quicko Capital Gains Template.
4. Enter the Details and Upload.
- Find ISIN Code
- FMV Report for Equity with ISIN : Select 'Equity with ISIN'.
- FMV Report for Mutual Fund : Select 'NAV as on 31-Jan-2018' and Download in 'Excel Format'.
- Purchase and Sale Date Format : "yyyy-MM-dd", "dd-MMM-yyyy", "dd-MM-yyyy", "dd/MM/yyyy", "yyyyMMdd", "dd-MM-yy", "dd-MMM-yy"
- Fields in red are mandatory: ISIN, trade description, Purchase and Sale date, Units sold, etc. There are two pages present in the template: Equity and Mutual Funds.