Add Capital Gains using Excel Template

Add Capital Gains using Excel Template

Have capital gains from securities, but your broker isn’t listed on our platform? No problem! You can still import your trades seamlessly using the Quicko Excel Template.

Things to Keep in Mind

  • Ensure all date fields (Buy Date and Sell Date) are in DD/MM/YYYY format.
  • If any fields are missing or incorrectly formatted, the system will automatically flag the errors.
  • You can download the error report, make the necessary corrections, and re-upload the template.
    Web
    Mobile
    Web

    1. Download the Excel Template

    • Go to File > Capital Gains > Add Securities
    • Select Upload P&L Report
    • Enter your account details
    • Scroll down and click Download Excel Template by Quicko

    2. Fill in Your Trade Details

    Use your broker’s Tax P&L report to map the required details in the Excel template.

    For Stocks / Bonds / Debentures

    • Open the Excel file and navigate to the Stocks/ Bonds/ Debentures tab
    • Fill in the following details:
      • ISIN number
      • Symbol
      • Is listed?
      • Is STT not paid?
      • Quantity
      • Buy Date
      • Buy Price (per unit)
      • Sell Date
      • Sell Price (per unit)
      • FMV (Fair Market Value)
      • Transfer Expense
      • Country

    For Mutual Funds / ETFs

    • Navigate to the Mutual Funds/ ETFs tab
    • Fill in the following details:
      • ISIN number
      • Scheme name
      • Asset Class
      • Is listed?
      • Is STT paid
      • Quantity
      • Buy Date
      • Buy Price (per unit)
      • Sell Date
      • Sell Price (per unit)
      • FMV
      • Transfer Expense
      • Country

    3. Upload the Completed Template

    • Save the Excel file
    • Go to File > Capital Gains > Upload P&L Report
    • Upload the filled template
    Mobile

    1. Download the Excel Template

    • Go to File > Capital Gains > Add Securities
    • Select 
      Upload P&L Report
    • Enter your account details
    • Scroll down and click Download Excel Template by Quicko

    2. Fill in Your Trade Details

    Use your broker’s Tax P&L report to map the required details in the Excel template.

    For Stocks / Bonds / Debentures

    • Open the Excel file and navigate to the Stocks/ Bonds/ Debentures tab
    • Fill in the following details:
      • ISIN number
      • Symbol
      • Is unlisted?
      • Is STT not paid?
      • Quantity
      • Buy Date
      • Buy Price (per unit)
      • Sell Date
      • Sell Price (per unit)
      • FMV (Fair Market Value)
      • Transfer Expense

    For Mutual Funds / ETFs

    • Navigate to the Mutual Funds/ ETFs tab
    • Fill in the following details:
      • ISIN number
      • Symbol
      • Scheme name
      • Scheme type
      • Is unlisted?
      • Quantity
      • Buy Date
      • Buy Price (per unit)
      • Sell Date
      • Sell Price (per unit)
      • FMV
      • Transfer Expense

    3. Upload the Completed Template

    • Save the Excel file
    • Go to 
      File > Capital Gains > Upload P&L Report
    • Upload the filled template

     

Need Help?

Raise a ticket to get in touch with us.



    • Related Articles

    • Upload Capital Gains (Crypto Settlements) Using the Excel Template by Quicko

      If you have multiple crypto transactions, you can upload them all at once using the Excel Template by Quicko instead of adding each settlement manually. Steps to Upload Crypto Settlements Navigate to File > Capital Gains > Crypto. Click Add Crypto. ...

    • Import Capital Gains using Investment Apps

      Have capital gains from trading or investments? Whether you’ve made a profit or a loss, you can easily import your trade data and track your capital gains using integrated investment apps. What Falls Under Capital Gains? Capital gains arise from the ...

    • Add Capital Gains from WintWealth

      If you use WintWealth to invest, you can easily import your capital gains into Quicko by uploading the Tax P&L Report downloaded from your WintWealth account. This saves you from entering each transaction manually. Before You Start Download your Tax ...

    • Add Capital Gains from INDmoney

      If you use INDmoney to invest, you can easily import your capital gains into Quicko by uploading the Tax P&L Report downloaded from your INDmoney account. This saves you from entering each transaction manually. Before You Start Download your Tax P&L ...

    • Import B&P Income from Excel Template

      If you’re actively trading in Intraday and Futures & Options (F&O) but your broker isn't integrated with our platform — no worries! You can still report your trades using our structured Excel Template. This allows you to maintain accuracy in your tax ...