{"id":7187,"date":"2026-03-27T10:17:07","date_gmt":"2026-03-27T04:47:07","guid":{"rendered":"https:\/\/maxiomwealth.com\/blog\/?p=7187"},"modified":"2026-09-15T15:52:27","modified_gmt":"2026-09-15T10:22:27","slug":"zerodha-tradebook-download-guide","status":"publish","type":"post","link":"https:\/\/maxiomwealth.com\/blog\/zerodha-tradebook-download-guide\/","title":{"rendered":"How to Download and Read Your Tradebook"},"content":{"rendered":"

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

What Is a Tradebook?<\/h2>\n

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.<\/p>\n

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.<\/p>\n

How Do You Download Your Tradebook?<\/h2>\n

Most discount brokers publish this under a Reports section of their back-office or web platform. The steps are broadly similar across brokers:<\/p>\n

    \n
  1. Log in to your broker’s back-office or reports portal with your client ID and password.<\/li>\n
  2. Click on Reports<\/strong> in the left sidebar.<\/li>\n
  3. Select Tradebook<\/strong> from the menu.<\/li>\n
  4. Set the date range<\/strong>. For tax purposes, select the full financial year (1 April to 31 March). You can also filter by segment (equity, F&O, commodity, currency).<\/li>\n
  5. Click View<\/strong> to load the trades on screen.<\/li>\n
  6. Click the download icon<\/strong> to save as CSV or Excel. The CSV format works best if you plan to sort or filter the data.<\/li>\n<\/ol>\n

    For the current day’s trades, you can also usually view them on your broker’s mobile app under Orders > Executed.<\/p>\n

    What Does Each Column in Your Tradebook Mean?<\/h2>\n

    Here is a breakdown of the key columns:<\/p>\n

    \n\n\n\n\n\n\n\n\n\n\n\n\n
    Column<\/th>\nWhat It Contains<\/th>\nWhy It Matters<\/th>\n<\/tr>\n<\/thead>\n
    Trade Date<\/td>\nThe date the trade was executed<\/td>\nDetermines short-term vs long-term holding period<\/td>\n<\/tr>\n
    Symbol<\/td>\nThe stock\/instrument ticker (e.g., RELIANCE, NIFTY24MARFUT)<\/td>\nIdentifies the security traded<\/td>\n<\/tr>\n
    Trade Type<\/td>\nBuy (B) or Sell (S)<\/td>\nNeeded for FIFO matching during tax computation<\/td>\n<\/tr>\n
    Quantity<\/td>\nNumber of shares or lots traded<\/td>\nMultiplied by price to get trade value<\/td>\n<\/tr>\n
    Price<\/td>\nThe actual execution price per unit<\/td>\nMay differ from your order price (market orders, partial fills)<\/td>\n<\/tr>\n
    Order ID<\/td>\nUnique identifier for the order<\/td>\nCross-reference with contract notes for discrepancies<\/td>\n<\/tr>\n
    Trade ID<\/td>\nExchange-assigned unique trade number<\/td>\nOfficial reference for any disputes with the exchange<\/td>\n<\/tr>\n
    Exchange<\/td>\nNSE or BSE<\/td>\nSame stock can trade at slightly different prices on different exchanges<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n

    How Do You Use the Tradebook for Tax Computation?<\/h2>\n

    The tradebook is your primary source document for computing capital gains tax. Here is the process:<\/p>\n

      \n
    1. Match buys with sells using FIFO:<\/strong> The Income Tax Department requires First-In-First-Out matching. The earliest purchase is matched against the earliest sale of the same stock.<\/li>\n
    2. Classify as STCG or LTCG:<\/strong> 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).<\/li>\n
    3. Compute the gain:<\/strong> Sale price minus purchase price minus brokerage and charges equals capital gain.<\/li>\n
    4. Aggregate:<\/strong> Total all STCG and LTCG separately for the financial year.<\/li>\n<\/ol>\n

      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.<\/p>\n

      You can calculate your tax liability here<\/a> to get a quick estimate before you file.<\/p>\n

      How Can You Track Brokerage and Charges?<\/h2>\n

      The tradebook itself does not show charges, but you can cross-reference it with the Tax P&L report<\/strong> that most brokers publish on their reports portal, which breaks down charges per trade. Key charges to watch:<\/p>\n