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

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

  1. Navigate to File > Capital Gains > Crypto.
  2. Click Add Crypto.
  3. Select Upload using Excel Template.
  4. Enter your Exchange Name and Account ID, then click Save.
  5. Open the account and click Upload Excel Template.
  6. Download the Excel Template.
  7. Fill in the Excel template with your crypto transaction details.
  8. Save the file without changing its format.
  9. Upload the completed Excel Template and click Import. Once you upload the report, you will need to review and then save and continue.

Note: After the upload is complete, Quicko will process and import your crypto settlements. If any settlements have warnings, you'll see the total number of warnings on the Review page. You can download the Error Report to view the exact issues and make the necessary corrections.

Quicko will validate the uploaded data and automatically calculate your capital gains or losses.

Things to Keep in Mind

  • Use only the Excel Template downloaded from the upload screen.
  • Do not modify the column names or the file format.
  • Review the imported transactions before filing your return.

Still need help?

Raise a support ticket and our team will get in touch with you.

    • Related Articles

    • 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 ...

    • Add Capital Gains (Crypto) from CoinSwitch

      If you trade cryptocurrency on CoinSwitch, you can import your crypto settlements directly into Quicko using the Tax P&L Report downloaded from your CoinSwitch account. Download your crypto transaction report from your CoinSwitch account and keep it ...

    • 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 (Crypto) Manually

      If you've bought and sold cryptocurrency, you can manually add each settlement in Quicko to calculate your capital gains or losses. Steps to Add a Crypto Settlement Manually Navigate to File > Capital Gains > Crypto. Click Add Crypto. Select Add ...

    • 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 ...