By VestAI Research | Published: April 2026 | 10 min read
Zerodha Trading Journal — Import Tradebook CSV & Track P&L Automatically
Zerodha is India’s largest stockbroker with over 1.5 crore active clients. If you trade on Zerodha Kite, you are generating valuable trade data every day — but Zerodha does not provide a trading journal. Their Console shows your tradebook and a basic P&L report, but there is no win rate analysis, no calendar heatmap, no strategy tagging, no behavioral pattern detection, and no AI-powered insights. VestAI fills this gap. You can export your tradebook CSV from Zerodha Console and import it into VestAI in one click. All trades are parsed automatically, Indian charges (STT, stamp duty, exchange fees, GST) are calculated for every trade, and Orion AI analyzes your trading patterns. This guide walks you through the entire process step by step.
Import Your Zerodha Trades in 2 Minutes
Download CSV from Zerodha Console. Upload to VestAI. See your real P&L with all charges calculated.
Open Trading Journal — FreeWhy Zerodha Does Not Have a Built-In Trading Journal
Zerodha is a discount broker — their business model is built on executing trades at low cost (₹20 per order for intraday and F&O, zero for equity delivery). Their platform, Kite, is designed for order execution and basic charting. Zerodha Console provides reporting — tradebook, P&L statement, tax reports, and contract notes.
But a trading journal is fundamentally different from a tradebook. A tradebook is a record of what happened. A trading journal is a tool for understanding why it happened and how to improve. A journal needs strategy tagging, emotional state tracking, win rate and profit factor analytics, calendar heatmaps, time-of-day analysis, and behavioral pattern detection. Building this kind of analytics platform is outside Zerodha’s core competency as a broker.
This is exactly why VestAI exists. It takes the raw data from your Zerodha tradebook and transforms it into actionable insights. Think of Zerodha as the execution engine and VestAI as the analysis engine — they complement each other.
How to Export Your Tradebook CSV from Zerodha Console
Follow these steps to download your Zerodha tradebook in CSV format:
Step 1: Log in to Zerodha Console
Go to console.zerodha.com and log in with your Kite credentials (client ID and password + TOTP/PIN). Console is Zerodha’s back-office platform — it is separate from the Kite trading app but uses the same login.
Step 2: Navigate to Reports and Tradebook
In the Console sidebar, click on Reports, then select Tradebook. This shows all your executed trades across equity, F&O, currency, and commodity segments.
Step 3: Select Date Range
Choose the date range for which you want to export trades. You can select specific dates or use presets like “This Month,” “Last Month,” or “This Financial Year.” Zerodha Console allows you to go back up to 3 years. For your first import, start with the last 1-3 months of data to get meaningful analytics.
Step 4: Download as CSV
Click the Download button (usually a download icon or “Export” button) and select CSV format. The file will be downloaded to your computer. It typically has a name like “tradebook-XXXXXX-EQ.csv” where XXXXXX is your Zerodha client ID.
Step 5: Check the Downloaded File
Open the CSV to verify it contains data. The file will have columns like: symbol, ISIN, trade date, exchange, segment, series, trade type (buy/sell), auction, quantity, price, trade ID, order ID, and order execution time. You do not need to modify anything — VestAI parses the raw Zerodha CSV format directly.
How VestAI Imports Your Zerodha CSV
Once you have your Zerodha CSV file, importing it into VestAI takes about 30 seconds:
Step 1: Open VestAI Trading Journal
Go to vestai.io/journal and sign in (free account, no credit card needed). If you do not have an account, sign up with Google — it takes 10 seconds.
Step 2: Click Import CSV
In the journal, click the Import button. Select Zerodha as the broker. Drag and drop your downloaded CSV file or use the file picker to select it.
Step 3: Automatic Parsing
VestAI reads the Zerodha CSV format and extracts all fields: symbol, exchange, segment, trade type (buy/sell), quantity, price, and execution time. Buy and sell trades for the same symbol on the same day are automatically matched to create complete trade entries with entry and exit prices.
Step 4: Auto Charge Calculation
For every parsed trade, VestAI automatically calculates: STT (based on segment — equity delivery, intraday, futures, or options), stamp duty (buy-side, rate varies by segment), exchange transaction charges (NSE rates), SEBI turnover fee (₹10/crore), brokerage (₹20/order for intraday and F&O, zero for delivery — matching Zerodha’s pricing), and GST (18% on brokerage + exchange charges). The result is a true net P&L for every single trade.
Step 5: Review and Tag
Once imported, review your trades in the journal. Add strategy tags (breakout, pullback, VWAP, etc.) and emotional state (calm, FOMO, revenge) to each trade. These qualitative tags are what transform raw trade data into actionable insights. You can tag in bulk or individually.
What Gets Imported from Zerodha CSV
| Zerodha CSV Field | VestAI Field | Auto-Processed |
|---|---|---|
| symbol | Symbol / Instrument | Yes |
| trade_date | Trade Date | Yes |
| order_execution_time | Entry / Exit Time | Yes |
| trade_type | Buy / Sell | Yes |
| quantity | Quantity | Yes |
| price | Entry / Exit Price | Yes |
| exchange, segment | Exchange, Segment | Yes |
| (calculated) | STT, Stamp, Exchange, GST | Yes (auto) |
| N/A | Strategy, Emotion, Notes | Manual (add after import) |
What You See After Importing Your Zerodha Trades
Once your Zerodha CSV is imported, VestAI generates a comprehensive view of your trading performance:
Calendar Heatmap
A color-coded calendar showing your daily net P&L. Green days are profitable, red days are losing, with color intensity reflecting magnitude. You instantly see patterns — are your Mondays consistently red? Do you perform better in the first half of the month? The visual format reveals patterns that tables of numbers hide.
Performance Metrics
Win rate (what percentage of trades are profitable), profit factor (gross profits divided by gross losses — above 1.5 is good), average winning trade, average losing trade, expectancy (expected P&L per trade), and total net P&L after all Indian charges. These are the numbers professional traders track obsessively.
Charges Breakdown
Total STT paid, total stamp duty, total exchange charges, total GST, and total brokerage — broken down by period. Many Zerodha users are shocked when they see the total charges. A trader who thinks “Zerodha is cheap at ₹20 per order” often discovers that STT and exchange charges dwarf the brokerage cost, especially for options trading.
Orion AI Analysis
Run Orion on your imported Zerodha data and get personalized insights: revenge trading patterns, FOMO vs. planned trade comparison, best and worst trading hours, overtrading detection, and strategy performance ranking. Orion reads your actual data — not generic advice.
Tips for Zerodha Users Starting a Trading Journal
If you trade on Zerodha and have never maintained a journal, here is how to get started:
Start with Last Month’s Data
Download your tradebook for the last 30 days from Console and import it to VestAI. You will immediately see your win rate, charges, and P&L metrics. For most traders, this first import is an eye-opening experience — especially seeing total charges and the gap between gross and net P&L.
Import Weekly Going Forward
Set a weekly reminder (Saturday morning) to download your Zerodha CSV for the week and import it to VestAI. This takes under 2 minutes. Then spend 30 minutes on your weekly review — check the calendar heatmap, analyze win rate by strategy, and note any behavioral patterns.
Add Strategy and Emotion Tags
The CSV gives you the what (trade details). You need to add the why (strategy and emotion). After importing, tag each trade with the strategy you used and your emotional state. This takes a few minutes but is essential for meaningful analysis. Without these tags, Orion can still detect revenge trading and overtrading, but cannot compare strategy performance or FOMO impact.
Compare Zerodha P&L Report vs. VestAI P&L
Zerodha Console shows a basic P&L report. Compare it against VestAI’s calculated P&L to verify accuracy. VestAI’s charge calculation should closely match Zerodha’s contract notes. Any small differences are typically due to rounding. This verification builds confidence in the journal’s accuracy.
Use the Tax Report at Year End
Zerodha provides tax P&L reports in Console. VestAI’s journal data can supplement this — if you have tagged all trades by segment and type, you have a clear record for short-term and long-term capital gains calculation. For more on tax implications, see our guide on capital gains tax on stocks in India.
Other Broker CSV Import — Coming Soon
VestAI currently supports Zerodha CSV import. Support for the following brokers is actively being built and will be available soon:
- Groww — India’s second-largest broker by active clients
- Angel One — Large retail broker with active F&O traders
- Upstox — Discount broker popular with intraday traders
- Dhan — Growing broker with options-focused features
- ICICI Direct — Full-service broker with large delivery base
In the meantime, if you trade with a broker other than Zerodha, you can use VestAI’s manual trade entry to log trades individually. The auto charge calculation works regardless of which broker you use — you just need to enter the trade details manually. For a comparison of journal options, see our best trading journal apps in India guide.
Import Your Zerodha Trades Now
Download your tradebook CSV from Zerodha Console and upload to VestAI. See your real P&L, win rate, and behavioral patterns in under 2 minutes. Free forever.
Open Trading Journal — FreeNo credit card. No trial period. Unlimited trades.
Frequently Asked Questions
Does Zerodha have a built-in trading journal?
No. Zerodha (Kite) provides a tradebook that shows your trade history and a basic P&L report in Console, but it does not offer a trading journal with analytics. There is no win rate calculation, no calendar heatmap, no strategy tagging, no emotional state tracking, no AI-powered behavioral analysis, and no way to compare performance across strategies or time windows. The tradebook is a raw data dump — useful for records, but not for improving your trading.
How do I download my tradebook from Zerodha Console?
Log in to Zerodha Console (console.zerodha.com) with your Kite credentials. Go to Reports > Tradebook. Select the date range you want (you can go back up to 3 years). Click the Download button and select CSV format. The downloaded file contains all your trades for that period including symbol, trade type, quantity, price, order time, and exchange. Upload this CSV to VestAI for automatic parsing and charge calculation.
Does VestAI support Zerodha Kite API integration?
Currently, VestAI supports Zerodha CSV file import (from Console tradebook). Direct API integration with Kite Connect is on the roadmap. CSV import works well for daily or weekly journal updates — download your tradebook, upload to VestAI, and all trades are parsed automatically with Indian charges calculated. Groww, Angel One, and Upstox CSV import support is also coming soon.
Are the Indian charges calculated by VestAI accurate for Zerodha?
Yes. VestAI calculates all charges based on the official rates published by NSE, BSE, and the government. STT, stamp duty, exchange transaction charges, SEBI turnover fee, and GST are calculated for each trade based on its segment (equity delivery, intraday, futures, options). For Zerodha specifically, brokerage is Rs 20 per executed order for intraday and F&O, and zero for equity delivery. These rates match what Zerodha charges. If rates change, VestAI updates them.
Want more insights like this?
Get free stock analysis, market insights, and investment ideas delivered to your inbox.
No spam. Unsubscribe anytime.
Related Articles
- Free Trading Journal for Indian Traders — Complete guide with charge tables and all features
- Best Trading Journal Apps India — Compare 10 journal apps for Indian traders
- Intraday Trading Journal — Journaling techniques for Zerodha day traders
- Capital Gains Tax on Stocks — Understanding STCG and LTCG for your trading P&L