Your broker's Tradebook records executions. A journal adds the context you will want when you review them: what you were trying to do, whether you followed your plan, and how you felt that day. If you already have months of Zerodha trades, you can bring supported closed trades into Jorli without typing every price by hand. Start with a small date range, inspect the preview, and keep the original CSV for reference.
1. Download the Tradebook from Zerodha Console
Sign in to Zerodha Console with your own account. Open Reports → Tradebook, choose the segment and date range, generate the report, and download the CSV. Choose the Tradebook, rather than an Orderbook or a P&L statement. An order can be cancelled or filled in pieces; the Tradebook describes the executions that actually happened.
Keep the downloaded file unchanged for your first import. Spreadsheet software can reformat dates, remove leading zeroes or alter quoted fields when you save again. A short range makes it easier to compare a few symbols against Console before importing a longer history. Download additional segments separately if they are not included in your selected report.
2. Understand the columns before importing
The standard Zerodha CSV includes symbol, ISIN, trade_date, exchange, segment, series, trade_type, auction, quantity and price, with additional identifiers or execution timestamps in some exports. The symbol identifies the instrument; trade_type says buy or sell; quantity and price describe each fill. trade_date determines the journal day. ISIN, exchange and segment help you recognise what you traded, but are not a substitute for checking the instrument itself.
Jorli's importer expects the standard Tradebook layout and recognises the trade_type and trade_date headers. It reads the symbol, date, side, quantity and price from that layout. It groups fills by date and symbol and calculates quantity-weighted average buy and sell prices. This means several executions in one symbol on one day can become one journal trade, rather than one row for every fill.
3. Open Settings → Import past trades
Create your free Jorli account, verify your email, and open Settings → Import past trades. The direct app route is /import-past-trades. Choose your CSV and wait for the preview. Selecting a file does not immediately save its trades.
Only fully closed symbol/day groups with equal total bought and sold quantities are eligible. Open positions and partially closed quantities are skipped. A delivery purchase on Monday and sale on Thursday will not be treated as a closed same-day group. This importer is therefore not a general reconstruction of multi-day holdings or an accounting ledger. Review skipped instruments rather than assuming the file's full turnover has been imported.
4. Review the days and the trade direction
Jorli checks existing journal days within the file's date range. Days already containing trades are pre-skipped, as are days marked No Trade Day. This protects an existing daily record from an accidental second import. A day with notes but no trades is different from a day that already has trades; inspect the preview's status before confirming your selection.
Direction is inferred from available execution timestamps, with a long default where the order cannot be established. Check it in the preview, especially for short intraday positions. Buy below sell does not establish direction: a short trade starts with the sale. Review prices, quantity, target and stop loss where relevant, then import the selected days. The summary shows imported dates, skipped dates and trade totals so you can cross-check the result.
5. Add the part the broker cannot tell you
Open a few imported journal days and compare them with Console. Reconcile charges against your contract note; an estimate is not a broker bill. Jorli's free NSE brokerage calculator helps separate commission from taxes and exchange charges. Then add a brief note about the setup, the day's mood and whether you followed your checklist. Do not invent old psychology scores you cannot remember; leave uncertain context blank.
Use broker sync for your daily routine
CSV import is for older Zerodha history. For today's trades, connect your personal broker app under Profile → Broker Sync. Jorli supports Zerodha and Dhan, with manual sync and optional weekday auto-sync at 4:30 PM IST while the session is valid. Today's fully closed trades are imported; open or partially closed positions are skipped. No Trade Days are also skipped.
Repeated broker sync updates its existing broker records, but manually entered trades remain separate and can duplicate an imported execution. Reconnect when the session expires; Zerodha normally needs a fresh login each trading morning. Follow the Kite setup guide or Dhan setup guide, then use past-trade import only when you need to fill an older gap.