Console Tradebook

Overview

The Console Tradebook is a chronological record of every order that reached an executed state in a Zerodha account during a chosen date range. It is available through Zerodha Console, the broker’s back-office and reporting portal, and can be downloaded as a CSV or Excel file. The Tradebook covers all segments, equity delivery, intraday (MIS/BO/CO), futures and options (F&O), currency derivatives, and commodities, providing a single, unified view of trading activity across exchanges.

Unlike the daily contract note, which is issued per settlement and aggregates trades within a single day, the Tradebook allows arbitrary date ranges spanning multiple financial years. This makes it the primary source for computing capital gains, reconciling positions, reconstructing cost-basis figures, and responding to audit queries.

What the Tradebook contains

Each row in the Tradebook represents one trade execution. The standard fields are:

Derivative rows additionally carry the strike price, option type (CE/PE), and expiry date to uniquely identify the contract.

How to download the Tradebook

1. Log in to Zerodha Console at console.zerodha.com.
2. Navigate to Reports > Tradebook in the left-side navigation.
3. Select the segment (or “All”) from the dropdown.
4. Set the From date and To date. The maximum span per download request is one financial year (1 April to 31 March).
5. Click Download and choose CSV or XLSX.

The portal generates the file server-side and delivers it as a browser download. Very large accounts (tens of thousands of trades) may take a few seconds for file preparation. There is no size limit beyond the one-financial-year window; multi-year histories require one download per financial year.

For programmatic access, Zerodha exposes the Kite Connect Historical Data API, which is a separate, fee-based data product. The Console download does not require an API subscription.

Regulatory framework

SEBI requires every registered broker to maintain complete records of all client transactions. The primary obligations derive from:

• SEBI (Stock Brokers and Sub-Brokers) Regulations, 1992, Regulation 17, which mandates that brokers keep books and records in specified formats.
• SEBI Circular CIR/MIRSD/16/2011 and subsequent circulars on contract notes and record maintenance, which establish the minimum data fields that must be preserved per trade.
• NSE/BSE Trading Member Regulations, which require that member firms retain trade data for a minimum of five years from the trade date and make it available to clients on request.

The Tradebook as presented on Console is the client-facing extract of the broker’s internal Order Management System (OMS) records. The exchange’s own trade confirmation files (TCF), which Zerodha receives daily, serve as the authoritative source; the Console Tradebook is reconciled against these files.

Operational and tax uses

Capital gains computation

Under the Income Tax Act, 1961, capital gains are computed on the basis of acquisition cost and disposal consideration. For equity delivery trades, acquisition cost is determined by the FIFO (First In, First Out) method mandated by the Act. The Tradebook provides the raw buy and sell records from which chartered accountants or tax software reconstruct FIFO lots. Zerodha also offers a pre-computed ITR-ready capital gains statement that uses Tradebook data as its input, but many professionals prefer to verify against the raw Tradebook.

Reconciliation

Traders who maintain their own journals or use third-party portfolio trackers (Smallcase, INDmoney, etc.) periodically reconcile those records against the Console Tradebook to detect missed entries, corporate-action adjustments, or data-import errors.

Audit and dispute resolution

If an exchange or SEBI raises a query about a specific trade, the Trade ID and Order ID in the Tradebook allow the client and the broker to cross-reference the exchange’s own records quickly. Similarly, in Income Tax scrutiny, the Tradebook is the standard document produced to substantiate turnover figures for F&O traders computing business income under Section 44AB.

F&O turnover calculation

For traders who treat F&O income as business income and are subject to tax audit under Section 44AB, “turnover” for audit-threshold purposes is computed as the absolute sum of all profits and losses on squared-off positions plus the premium received on options sold. The Tradebook provides the raw data for this calculation.

Retention period

SEBI and exchange regulations require brokers to retain trade records for five years. Zerodha’s Console portal makes data available online for the same period. Clients are advised to download and archive their own copies because:

• Regulatory minima (five years) may be shorter than the holding period of certain assets.
• Long-term capital assets held for more than 24 months (36 months for unlisted equity before 2023) require cost records going back beyond the retention window in some edge cases.
• Grandfathering provisions introduced under Finance Act, 2018 (for equity LTCG above Rs 1 lakh) require acquisition cost or fair market value as of 31 January 2018, which predates typical online availability.

Best practice is to download the Tradebook at the end of every financial year and store it alongside the corresponding Console Tax P&L statement and contract notes.

Common operational considerations

Date range and financial year boundary. The Console Tradebook defaults to the current financial year (1 April to the current date). When downloading for tax purposes, always use exactly 1 April to 31 March. Trades placed on 31 March after market hours but settled on 1 April follow a T+1 settlement cycle (introduced in phases from 2022 and fully live across all equity stocks by 2024); such trades may appear on the settlement date rather than the trade date depending on the report mode selected.

Multiple segments. Downloading “All” in the segment filter produces a single file containing rows from all segments. When computing F&O turnover separately from equity capital gains, it is cleaner to download segment-specific files.

Rights issues and off-market transfers. These appear in the Tradebook with a remark indicating the transaction type. They carry a price of zero (rights) or the agreed off-market price and must be excluded from normal trading turnover calculations.

Bonus and split adjustments. Corporate actions such as stock splits and bonus issues are reflected as separate rows with quantity adjustments and zero price. Software that ingests the raw Tradebook must handle these rows correctly to avoid inflating turnover.

Options premium. For options contracts, the trade price is the premium per unit, not the notional value. Quantity represents the number of lots multiplied by the lot size at the time of execution.

Related reports on Console

The Tradebook is one of several reports available on Zerodha Console. Related reports include:

• Console Tax P&L statement – pre-computed profit and loss with FIFO applied, suitable for direct use in ITR filing.
• Console Funds statement – ledger of all fund inflows, outflows, brokerage debits, and settlement credits.
• Console Contract notes – exchange-mandated daily trade confirmation documents.
• Console Holdings report – current demat holdings with acquisition cost basis.
• ITR-ready capital gains statement – formatted capital gains summary for Schedule CG of the ITR.

References

1. SEBI (Stock Brokers and Sub-Brokers) Regulations, 1992, Regulation 17 – Record keeping obligations.
2. SEBI Circular CIR/MIRSD/16/2011 dated 22 August 2011 – Electronic contract notes and trade records.
3. National Stock Exchange, Trading Member Regulations – Record retention requirements.
4. Zerodha Support, “How to download the Tradebook from Console” – support.zerodha.com.
5. Income Tax Act, 1961, Section 112A – Long-term capital gains on equity.
6. Income Tax Act, 1961, Section 44AB – Tax audit applicability for business income.