# Zerodha Trading Journal

> To journal Zerodha trades in Nexus Journal, download your tradebook from Zerodha Console as a CSV or Excel file and upload it. Nexus recognises the Zerodha format from its columns and rebuilds each position from its entries and exits. Upload the Tax P&L report as well to bring in charges, and connect your own Kite Connect app to add each day's new trades.

Canonical: https://www.nexusjournal.co.in/zerodha-trade-journal
Last updated: 2026-11-15

Nexus Journal helps Zerodha traders move from raw tradebook data to structured trade review, analytics, and tax-aware performance tracking.

Reviewed 2026-11-15 by [Nexus Journal product team](https://www.nexusjournal.co.in/about-nexus-journal).

## From tradebook to journal

A broker tradebook shows executions, but it does not automatically explain lifecycle, setup quality, drawdown, risk exposure, notes, or chart context.

Nexus turns imported records into journal-ready data so traders can review the full story of each position.

## How to download your Zerodha tradebook

Log in to Zerodha Console, open Reports and choose Tradebook. Select the segment (equity, F&O, commodity or currency) and the date range, then download the report as CSV or Excel. Each segment is a separate download, so repeat the step for every segment you trade. Zerodha may rename menus over time; the report you need is the one that lists every executed trade with its trade ID and order execution time.

If your history is long, download it in several date ranges. Nexus accepts files of up to 20 MB each.

## How to import the tradebook into Nexus Journal

Upload the file in the journal's import screen. Nexus identifies a Zerodha tradebook from its column headers, such as trade date, trade type and order execution time, so the file name and the position of the header row do not matter. It reads the symbol, ISIN, exchange, segment, quantity, price, trade ID, order ID and execution time of every row.

Uploading an overlapping file again is safe: trades are matched on their Zerodha trade and order IDs, so existing trades are not doubled. If you have more than one Zerodha account, keep the client ID in the file name (for example tradebook-AB1234-EQ.csv) so the trades are assigned to the right account.

## Adding charges with the Zerodha Tax P&L report

The tradebook lists executions but not charges. For charges, download the Tax P&L report from Zerodha Console for the financial year as an Excel file and upload it to Nexus.

Nexus reads brokerage, STT, exchange transaction charges, SEBI charges, stamp duty, GST, IPFT and clearing charges, and matches them to the totals in the report's charges sections. It also reads the Other Debits and Credits sheet for items such as DP charges, MTF interest, pledge charges and AMC, so P&L can be reviewed after costs.

## Daily sync with Kite Connect

To add new trades without downloading files, connect Zerodha through Kite Connect. Create a personal app on the Kite developer site using the redirect URL shown in Nexus, then enter its API key and secret. The connection can also read open stop-loss orders and GTT triggers to fill in stop levels, if you switch that option on.

Kite Connect returns only the current day's trades, so run the sync on each trading day and use the Console tradebook for anything older. Zerodha expires the login every morning, so the connection needs a fresh login each day.

## Pyramids and partial exits

When the same symbol has multiple entries and exits, Nexus uses trade lifecycle logic to keep entries, exits, quantities, realized P&L, and chart markings aligned.

This is especially useful for traders who scale into winners or reduce positions in multiple parts.

## Analytics after import

After import, traders can review realized P&L, net P&L, monthly performance, drawdown, profit giveback, PF impact, top performers, and notes.

The journal is designed to help answer what worked, what failed, and whether risk was controlled.

## Can Nexus import my whole Zerodha history automatically?

Not through the connection: Kite Connect only provides the current day's trades. Upload your Console tradebook files once for past trades, then use the daily sync to keep the journal current.

## Does it handle F&O and commodity trades from Zerodha?

Yes. Futures, options and commodity rows are imported, including short positions. A short sale in the cash segment is imported when it is covered on the same day, as in intraday trading.

## What should I check after importing?

Compare the trade count, the date range, the symbols, the quantities and the gross P&L with Zerodha's own reports. You can also upload the Zerodha ledger to record deposits and withdrawals, which keeps monthly returns based on the capital actually in the account.

## Related

- [Trading Journal for Indian Market Traders](https://www.nexusjournal.co.in/trading-journal-india)
- [Trading Journal Metrics Explained](https://www.nexusjournal.co.in/trading-journal-metrics)
- [Broker Tradebook Import Guide for Trading Journals](https://www.nexusjournal.co.in/broker-import-guide)
- [Trading Tax Analytics for Indian Traders](https://www.nexusjournal.co.in/trading-tax-calculator-india)
- [How to Journal Partial Exits and Staged Profit Taking](https://www.nexusjournal.co.in/partial-exit-trading-journal)
- [Dhan Trading Journal](https://www.nexusjournal.co.in/dhan-trade-journal)
