How to Download and Read Your Zerodha Tradebook

Think of your tradebook as the passbook of your trading account. Just as your savings account passbook shows every credit and debit, your Zerodha tradebook records every buy and sell transaction you have executed. It is the most detailed record of your trading activity, and you will need it for tax computation, brokerage tracking, and reconciliation.

What Is a Zerodha Tradebook?

A tradebook is a transaction-level report showing every executed trade in your account for a selected date range. It includes the trade date, instrument name, buy or sell, quantity, price, exchange (NSE or BSE), and order ID. SEBI requires brokers to maintain these records for a minimum of five years.

The tradebook is different from a holding statement (which shows what you currently own) and a P&L statement (which shows your profits and losses). The tradebook shows the raw transactions that feed into both.

How Do You Download Your Zerodha Tradebook?

Follow these steps on Zerodha Console:

1. Log in to console.zerodha.com with your client ID and password.
2. Click on Reports in the left sidebar.
3. Select Tradebook from the menu.
4. Set the date range. For tax purposes, select the full financial year (1 April to 31 March). You can also filter by segment (equity, F&O, commodity, currency).
5. Click View to load the trades on screen.
6. Click the download icon to save as CSV or Excel. The CSV format works best if you plan to sort or filter the data.

For the current day’s trades, you can also view them on the Kite app under Orders > Executed.

What Does Each Column in Your Tradebook Mean?

Here is a breakdown of the key columns:

Column	What It Contains	Why It Matters
Trade Date	The date the trade was executed	Determines short-term vs long-term holding period
Symbol	The stock/instrument ticker (e.g., RELIANCE, NIFTY24MARFUT)	Identifies the security traded
Trade Type	Buy (B) or Sell (S)	Needed for FIFO matching during tax computation
Quantity	Number of shares or lots traded	Multiplied by price to get trade value
Price	The actual execution price per unit	May differ from your order price (market orders, partial fills)
Order ID	Unique identifier for the order	Cross-reference with contract notes for discrepancies
Trade ID	Exchange-assigned unique trade number	Official reference for any disputes with the exchange
Exchange	NSE or BSE	Same stock can trade at slightly different prices on different exchanges

How Do You Use the Tradebook for Tax Computation?

The tradebook is your primary source document for computing capital gains tax. Here is the process:

1. Match buys with sells using FIFO: The Income Tax Department requires First-In-First-Out matching. The earliest purchase is matched against the earliest sale of the same stock.
2. Classify as STCG or LTCG: If the holding period (trade date of buy to trade date of sell) is less than 12 months for listed equity, it is Short-Term Capital Gains (STCG, taxed at 20%). If 12 months or more, it is Long-Term Capital Gains (LTCG, taxed at 12.5% above Rs 1.25 lakh per year).
3. Compute the gain: Sale price minus purchase price minus brokerage and charges equals capital gain.
4. Aggregate: Total all STCG and LTCG separately for the financial year.

If you trade in F&O, your profits are treated as business income (not capital gains) and must be reported under ITR-3. F&O losses can be carried forward for eight assessment years.

You can calculate your tax liability here to get a quick estimate before you file.

How Can You Track Brokerage and Charges?

The tradebook itself does not show charges, but you can cross-reference it with the Tax P&L report on Console, which breaks down charges per trade. Key charges to watch:

• Brokerage: Zerodha charges zero on delivery trades and Rs 20 per executed order on intraday and F&O.
• STT (Securities Transaction Tax): 0.1% on delivery buy and sell, 0.025% on intraday sell, 0.0125% on F&O sell.
• Exchange charges: Typically 0.00345% for NSE equity.
• GST: 18% on brokerage and exchange charges.
• Stamp duty: 0.015% on buy-side transactions (varies by state for physical delivery).

In fact, charges can add up significantly for active traders. A trader executing 200 F&O orders per month pays roughly Rs 4,000 in brokerage alone, plus STT and other levies. Tracking this helps you understand the true cost of your trading activity.

How Do You Use the Tradebook for Reconciliation?

Reconciliation means verifying that your broker’s records match your own. Compare your tradebook against:

• Contract notes: Zerodha sends a contract note (digitally signed PDF) for each trading day. The trades in your tradebook should exactly match the contract note quantities and prices.
• Holding statement: Your current holdings should equal the net of all buys minus all sells from your tradebook history. If there is a mismatch, it could indicate a corporate action (bonus, split, merger) that was not reflected.
• Form 26AS/AIS: The Annual Information Statement from the Income Tax Department shows STT paid and some transaction details. Cross-check against your tradebook to ensure nothing is missing from your ITR.

Frequently Asked Questions

How far back can I download my tradebook from Zerodha?
Zerodha Console allows you to download tradebook data going back several years. For very old data (pre-2015), you may need to contact Zerodha support.

Can I download the tradebook for a specific stock only?
Yes. After loading the tradebook on Console, use the search or filter option to narrow down to a specific symbol. You can then download just those filtered results.

Why does my tradebook show multiple entries for a single order?
This happens when your order is partially filled across multiple trades. If you placed a buy order for 100 shares and it was filled in batches of 40 and 60, you will see two tradebook entries, both with the same Order ID but different Trade IDs.

Is the tradebook the same as the contract note?
Not exactly. The contract note is a legally binding document sent by the broker for each trading day. The tradebook is an aggregated view across multiple days. The data should match, but the format differs.

Do I need the tradebook if Zerodha already provides a Tax P&L report?
The Tax P&L report is a summary. The tradebook is the raw data. For detailed tax computation, audit support, or reconciliation, you need the tradebook. Clearly, the Tax P&L is convenient, but the tradebook is authoritative.

To Sum Up

To sum up, your Zerodha tradebook is the most granular record of your trading activity. Download it from Console at least once per quarter, use it for FIFO-based tax computation, and cross-reference it with contract notes and Form 26AS for accuracy. It takes five minutes and can save you hours during tax season.

Plan your investments with our free SIP Calculator →