Importing from Zerodha

Export your tradebook from Zerodha Console and import it to automatically build your transaction history.

Last reviewed

Exporting your data from Zerodha

Zerodha provides transaction data through Console, their back-office reporting platform. You can export your tradebook as a CSV file, which is the report we read.

Using the tradebook export

  1. Sign in to Zerodha Kite at kite.zerodha.com
  2. Navigate to Console by clicking your profile icon and selecting “Console”
  3. In “Console”, go to Reports → Tradebook
  4. Select your desired date range (up to one financial year at a time)
  5. Click “Download” to save the CSV file
Zerodha Console limits exports to one financial year at a time (April to March). If you need a longer history, download separate files for each year and import them one at a time, avoiding overlapping dates between files.

Supported formats and columns

The import wizard recognises Zerodha exports in CSV format by these column headings: price, quantity, symbol, trade date. The default currency is INR.

Recognised transaction types

  • buy, b: recorded as Buy
  • sell, s: recorded as Sell

Costs

This export has no per-trade cost column, so no dealing charges are read from it.

Rows set aside

Some rows are recognised but not imported. The review step lists each one and why:

  • Unrecognised action — not imported
  • Cash transaction — not currently imported
  • Date could not be read — not imported
  • Unsupported product — only share dealing is imported
  • A number on this row could not be read — check it and add it by hand

The Trade number column is Zerodha’s own reference and is kept with each trade. Equity and mutual fund rows are imported as buys and sells, judged by the Segment column. Futures traded on NSE, BSE or MCX (including commodity futures) are imported as futures positions, with the exchange they traded on kept for the Indian tax treatment. Options and currency rows are set aside as unsupported products and listed under “View skipped”. Charges such as securities transaction tax and GST are not read. Where Trade value is missing, it is worked out from the quantity and price. Trade dates are read in year-month-day, day-month-year or day/month/year order, so either of Zerodha’s export conventions works.

Dividend transactions are not included in the Zerodha tradebook. Dividends can be found in your tax P&L report or added manually after import.

Step-by-step import

Once you have your Zerodha CSV file ready, follow these steps to import it:

  1. Open Import statements in the sidebar, under Estate & assets → Portfolio
  2. Drop your Zerodha CSV file on the upload area or click to browse; the upload starts as soon as you choose the file
  3. The system detects the Zerodha format from the column headings and reads your trades
  4. Review the parsed transactions: rows that need attention carry a confidence badge
  5. Resolve any flagged items (e.g. delisted symbols or unrecognised instruments)
  6. Confirm the import (the button shows how many rows will be created, for example “Confirm 12 transactions”) to create your transaction records

Screenshot, for illustration only

The broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs toThe broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs to
The broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs toThe broker statement importer on the first of its three steps, upload, review and confirm, asking what kind of statement is being imported, whose it is and which account it belongs to
The importer on its first step, upload, where you say what kind of statement it is, whose it is and which account it belongs to.
The tradebook’s ISIN column is read with each row to help identify the security. If a symbol has been renamed or the company has undergone a merger, you may need to manually select the correct security during the review step.

Cost line-item extraction

The Zerodha tradebook carries no cost columns: brokerage, securities transaction tax, exchange charges, GST, stamp duty and the SEBI fee all live in the separate PDF contract note. Annual maintenance and platform fees appear in the holdings and funds exports rather than the tradebook. To capture itemised costs, upload the contract note PDF as well; our document extraction system reads each charge and files it under the right cost type.

See Understanding investment costs (opens in a new tab) for how each cost affects cost basis in each supported jurisdiction.

Common issues

NSE vs BSE symbol differences

Some securities trade on both NSE and BSE with slightly different symbols. The ISIN is carried through from the tradebook and helps identify the holding whichever exchange you dealt on. If a row is still flagged as unrecognised, check the symbol against the alternate exchange during review.

Futures and options contracts

Futures and options contracts pack the expiry date and strike price into the symbol, such as NIFTY23DEC18000CE. A futures row (its symbol ends in FUT) is imported as a futures position rather than a share holding; the tradebook only says buy or sell, so whether a trade opens or closes a position is settled when you confirm the import. Options and currency rows are not imported: they are set aside as unsupported products and listed under “View skipped”.

INR currency handling

The Zerodha tradebook carries no currency column, so every row from it is recorded in Indian rupees, which is what Zerodha deals in.

Corporate actions and bonus shares

Bonus shares, stock splits, and other corporate actions are not included in the tradebook export. These events need to be recorded manually or imported from your Demat account statement separately.

Data security

Your uploaded files are processed using our self-hosted document processing system. Your financial data never leaves our servers without your approval and is not shared with any third-party services. The file itself is kept in your document vault so you can open the original statement alongside the imported rows, and you can delete it from there whenever you wish.

Before you import

Dedicated reader: Zerodha files are read by a reader built for their layout, without AI.

These parts of the Statement import guide apply to every broker:

Related pages

Can’t find what you’re looking for?

Our support team is here to help. Contact us and we’ll get back to you as soon as possible.

Contact us

We use cookies to improve your experience. See our Cookie policy (opens in a new tab) for details.