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
- Sign in to Zerodha Kite at kite.zerodha.com
- Navigate to Console by clicking your profile icon and selecting “Console”
- In “Console”, go to Reports → Tradebook
- Select your desired date range (up to one financial year at a time)
- Click “Download” to save the CSV file
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 Buysell,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:
- Open Import statements in the sidebar, under Estate & assets → Portfolio
- Drop your Zerodha CSV file on the upload area or click to browse; the upload starts as soon as you choose the file
- The system detects the Zerodha format from the column headings and reads your trades
- Review the parsed transactions: rows that need attention carry a confidence badge
- Resolve any flagged items (e.g. delisted symbols or unrecognised instruments)
- 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




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.
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:
- Which files work: file types, size limit and plans
- Which statement to download: history, holdings or both
- Password-protected files: what we ask for and what we keep
- Number and date formats: decimal commas and day-first dates
- Currencies: base currency, statement rates, pence
- Checking your import: totals, holdings differences, gaps and duplicates
- Undoing an import: removing what one file added
- Fixing problems: what each import message means
Related pages
- Statement import overview: General guide for all supported brokers
- Portfolio transactions: Managing and editing your transaction history
- Portfolio overview: Understanding your portfolio dashboard
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
