You will require a CSV file export out of Zerodha to import your trading history into Sharesight. You can do this by following the below steps.
1 - Log into your Zerodha Console.
2 - Log in with your Kite credentials.
3 - Navigate to 'Reports'.
4 - Select 'Tradebook' from the dropdown menu.
5 - Select the necessary filters to include your historical buy and sell trades for the correct date range. (If you have already recorded trades from Zerodha make sure not to overlap the trade dates as it will duplicate your trades)
6 - Click on 'view' and your transaction details will be shown on the screen.
7 - Click on 'Download XLSX|CSV'
8 - The file will be downloaded in your PC.
1 – Login to Sharesight.
2 - On the ‘Let's get you started with Sharesight’ page, select the ‘Import from a Broker’ tile.
3 - Click on the ‘Zerodha’ tile on the ‘Import from a Broker’ page.
4 - Click the 'Upload a file' button.
5 – Select the CSV of trades you wish to import.
6 - Click import.
Note: If you have changed brokers and transferred the holdings to Zerodha these trades might not be imported into Sharesight, and will need to be added manually.
7 – The ‘Trades to import into Portfolio’ page will show an itemised list of all trades imported from your Zerodha trading account. Verify and edit the trade data as required.
If trades appear in red, this means that Sharesight can’t upload the trade or the trade will cause errors in your portfolio.
One common error when importing from a broker is:
'Saving this trade would result in a negative number of Shares being held'
This means you are importing more sell shares of a stock than buy shares. It happens if you have transferred stock from another broker or have any off-market trades.
Click ‘Import anyway’ for each of these stocks, then handle them later in Sharesight.
The solutions to other common errors can be found here.
8 – Once you have verified the trade data, click ‘Save all transactions’.
9 - Once the trades are saved, your Sharesight portfolio will be populated and the Portfolio Overview Page will load.
Your holdings will be calculated with Sharesight’s performance calculation methodology, which is a money-weighted return methodology, meaning the performance figures take account of the size and timing of cash flows.
Sharesight will automatically create dividends and corporate actions for the holdings you have imported.
1 - Review the trades imported:
a – Handle any negative holdings - Holdings with less buy trades than sell trades (occurs when you have transferred stocks from another broker).
b - Check fractional share trades for rounding differences.
c - Exchange rates are generated by Sharesight using the end of day exchange rate. These can be edited within the trade.
2 - Verify and confirm automatically generated data (dividends and corporate actions).
3 - Set up the Trade Confirmation Emails feature to automatically import future trades.
4 - Share access to your portfolio with your accountant.