Import intraday and futures & options trades using the Excel template.

Created by Prarthi Shah, Modified on Mon, 16 Dec at 2:11 PM by Lasya Pamidi

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.