Trading in the Intraday and Futures & Options segment, but your broker isn't listed with us? No worries! You can still import your trades using the Excel template.


Steps to Import Trades Using the Excel Template

1. Download the Quicko Excel Template


  • Go to File > Business & Profession > Add Business

  • Select Trading Securities – Intraday and F&O > Upload P&L Report

  • Enter your business details

  • Scroll down and download the Excel Template by Quicko


2. Map Data to the Template

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

For Intraday Trades:

  • Open the Excel template and navigate to the Stocks tab

  • Enter the following details: ISIN number, Symbol, Quantity, Buy Date, Buy Price (per unit), Sell Date, Sell Price (per unit), Transfer Expense

For Futures & Options Trades:

  • Open the Excel template and navigate to the Futures/Options tab

  • Enter the following details: Contract Name, Asset Type (Equity, Commodity, Currency), Quantity, Buy Date, Buy Price (per unit), Sell Date, Sell Price (per unit), Transfer Expense

Ensure that "Buy date" and "Sell date" is in DD/MM/YYY format. 


Once the details are filled in, save the template and upload it under File > Business & Profession > Upload P&L report.


If there's a formatting issue or missing fields during the upload, the system will show an error. You can download the error report and make the necessary changes.

Need help adding trade details manually or preparing the Balance sheet? Here's a detailed step-by-step guide:
  • How to add Intraday and Futures & Options income manually?
  • How to fill your business balance sheet 


Still need help? You can raise a ticket to get in touch with us.