Last updated: 28 May 2026 · 9 min read
By Pulkit Mangal — equity + F&O trader since 2017, founder of TradeDiary. Past trading across Zerodha, Kotak, Upstox and Dhan; built TradeDiary after losing ₹14L in FY21 to mistakes a journal would have caught.
TL;DR: A trading journal template India traders can actually use needs three things a generic global template doesn't: STT + brokerage built into net P&L, FIFO-aware quantity tracking for Indian tax filing, and grouping by Indian expiry cycles. This post gives you a free Excel + Google Sheets template with those three things, plus the 7 fields that actually change behaviour. Copy it, fill 30 days, and you'll spot one losing pattern that's been quietly bleeding you.
You finally sat down to "start journaling" on a Sunday evening, opened Google and typed "trading journal template india". You got 40 results — half of them American templates with dollar signs, half of them ₹999 PDFs from a finfluencer, and a couple of free Excel files that crash the second you paste 200 rows of Zerodha contract notes.
That's the gap this post fills. Below is the template that the ~500 Indian retail traders we talk to actually use and stick with past month two — Excel + Google Sheets, FIFO-aware, STT + brokerage built in — plus the fields that matter and the ones that are pure procrastination.
💡 Short on time? Grab the free template + auto-import from Zerodha / Kotak / Upstox — no card needed.
1. What "trading journal template india" actually means
A trading journal is a structured log of every trade you place — entry, exit, instrument, quantity, P&L, why you entered, what you'd do differently. A template is the pre-built file (Excel, Sheets, Notion, or in an app) that gives you the columns so you don't reinvent them every week.
But three things make a generic global template (Tradervue's exports, the BabyPips Excel, the Trello board you found on Reddit) the wrong fit for an Indian trader:
- Costs are non-trivial and itemised. STT on Indian equity delivery is 0.1% per side; on options sell-side it's 0.15% of premium (since 1 April 2026); brokerage is ₹20/order on discount brokers plus exchange transaction charges + SEBI + GST + stamp duty. A "profitable" trade on screen can be flat or negative after charges. A template that doesn't have a net P&L column with these built in is lying to you.
- FIFO is mandatory for tax. The Income Tax Department treats Indian equities on a First-In-First-Out basis for cost-of-acquisition. If your template lets you write "avg price" and call it a day, you're going to mis-file your ITR-2. The template needs to track quantity-lots in the order you bought them.
- Expiry-cycle semantics. Weekly P&L grouped by ISO calendar week is useless if you trade F&O. NIFTY now expires Thursdays only (post the 2024–25 SEBI rationalisation); BANKNIFTY moved to monthly-only expiry from Nov 2024; FINNIFTY is Tuesdays. You want grouping by each underlying's native expiry cycle, not by Mon–Sun.
A template that ignores those three things isn't an Indian trading journal — it's an American spreadsheet with rupee signs glued on.
2. Why a journal matters more for Indian traders specifically
2.1 Tax filing depends on it
If you trade equity intraday or F&O, you're filing ITR-3 with business income — not ITR-2. That means you need a trade-wise ledger. SEBI also mandates retention of contract notes for 7 years. Most retail traders only realise this in July, panic, and pay a CA ₹15,000 to reconstruct what a journal would have shown for free. If F&O turnover crosses ₹10 crore (Section 44AB), mandatory tax audit kicks in — and the auditor wants exactly the columns your template should already have. (Income Tax Act, Section 44AB)
2.2 Indian brokers don't compute per-strategy P&L
Zerodha's Console shows realised P&L by trading symbol — not by strategy or by trader-intent. A NIFTY 22500 CE leg of last week's bull-call-spread shows up next to an unrelated NIFTY 22500 CE swing trade from three weeks earlier. You can't separate them without a journal that captures strategy tags.
2.3 SEBI rule changes can flip a strategy overnight
The SPAN + Exposure margin changes of 2023, the expiry-day cap of 2024, the lot-size revisions of Nov 2024 — each of these changed the math of strategies that worked for years. A journal lets you re-test old setups against the new regime in 20 minutes instead of trading blind for another quarter.
2.4 You're competing with prop desks that journal everything
If you're discretionary, you're across the order book from algos that A/B test every entry signal. Without a journal, you've conceded the only edge an individual trader actually has — learning faster than your last self.
3. The framework: a 7-field minimum
Skip the 40-column bloat templates. The fields that actually drive improvement for Indian traders:
| # | Field | Why it matters |
|---|---|---|
| 1 | Entry date + time | Slice P&L by time-of-day — most Indian retail loses in the first 15 minutes and the last 30 minutes |
| 2 | Instrument (NIFTY / RELIANCE / BANKNIFTY 48500 CE) | Group by underlying to spot which one you actually trade well |
| 3 | Strategy tag (e.g. "BNF expiry-day fly", "swing CE", "delivery value buy") | Multi-leg trades roll up under one tag; lets you kill negative-expectancy strategies |
| 4 | Net P&L after costs | Gross P&L is a lie. STT + brokerage + exchange + SEBI + GST + stamp included. |
| 5 | R-multiple (P&L ÷ planned max loss) | Lets you compare a ₹2,000 win on ₹2,000 risk to a ₹10,000 win on ₹10,000 risk — same R, equally good |
| 6 | Why you entered (one sentence) | The single highest-impact field. Forces a thesis. Without it you'll re-enter the same losing setup six months later. |
| 7 | What you'd do differently | Filled at exit. Becomes your edge over six months. |
Optional but useful:
- Lots / quantity (helps spot sizing creep — "I doubled when the trade started winning")
- Days held (intraday vs swing vs positional are different beasts; tag each)
- Screenshot link (chart at entry — invaluable when you re-read in 3 months)
Anything beyond these and you'll abandon the template in 3 weeks. Friction kills habits.
4. The template — Excel, Google Sheets, or app
Option A — Free Google Sheets template
Skip the setup: download our free trading journal Excel template. It has every column below, the formulas already filled in, and By strategy, Monthly and Mistakes summary sheets. It opens in Google Sheets too.
The simplest Indian-aware template has two tabs:
Tab 1: Trades log — one row per trade, with these columns:
Date | Time | Instrument | Strategy tag | Side (Buy/Sell) | Qty (lots/shares) | Entry price | Exit price | Gross P&L | STT | Brokerage | Other charges | Net P&L | R-multiple | Why entered | What I'd do differently
Tab 2: Weekly + monthly rollup — pivot table grouped by strategy tag, showing win rate, average R, total net P&L, and a count.
Two formulas to copy:
Net P&L = Gross P&L - STT - Brokerage - Other charges
R-multiple = Net P&L / Planned max loss
For STT on equity delivery use =IF(Side="Sell", 0.001 * Exit_price * Qty, 0). For options sell-side STT use =IF(AND(Side="Sell", Instrument_type="Option"), 0.0015 * Premium * Qty, 0). Brokerage on Zerodha/discount brokers: =MIN(20, 0.0003 * turnover) per order.
Option B — Excel with FIFO
Excel pulls ahead the moment you want FIFO matching (which you'll need for ITR). Add a third tab — Open positions — that holds unmatched buy lots in chronological order. On every sell, you write a small SUMPRODUCT formula (or a 20-line VBA macro) that pops lots from the open-positions tab in date order until the sell quantity is filled. Painful to build the first time; bulletproof once it's there.
If you don't want to build FIFO yourself, see excel vs trading journal for the break-even point at which switching to an app costs less than a Sunday evening.
Option C — App template (auto-imports broker contract notes)
TradeDiary ships with the same 7-field schema above, FIFO-matched at the database level, with the STT + brokerage + GST + stamp duty itemised per Indian broker. You upload your Zerodha tradebook XLSX (or Kotak / Upstox / Dhan contract notes) and the rows fill themselves — you only write the why entered and what I'd do differently columns.
Strong recommendation: if you trade ≥ 5 lots/month or across two brokers, the time saved on contract-note reconciliation pays for an Indian-built tool in a week. If you trade < 5 trades/month with one broker, the Sheet works fine. Pick one and commit — switching mediums every two months is how journals die.
5. Real example with numbers
Trader: Riya (Pune, freelance designer, 31). Started equity + occasional NIFTY options in April 2024 with ₹2L capital. By March 2026 she was up to ₹2.4L — but felt the gains were all from a single Adani Power swing trade and the rest was a wash. Started journaling April 1, 2026.
Three months of data, sliced by strategy tag:
| Slice | Trades | Win rate | Net P&L | Insight |
|---|---|---|---|---|
| Delivery — large-cap value | 14 | 64% | +₹19,800 | Working. Patient sizing. |
| Delivery — small-cap "tips" | 9 | 22% | −₹14,200 | Killed. Source was Telegram. |
| Intraday — opening range breakout | 31 | 41% | −₹6,400 | Killed. Costs ate the edge. |
| NIFTY weekly CE/PE (Wed entry) | 18 | 55% | +₹11,300 | Doubled allocation. |
Net result over the next quarter: +₹24,500 on ₹2.4L base ≈ +10% in 90 days, with less total trading activity. The journal didn't make her a better predictor of the market — it made her a better quitter of negative-expectancy strategies that were sitting inside her own behaviour the whole time.
6. Common mistakes that kill a template
- Logging only the trades you remember. Selection bias. You'll log the wins, "forget" some losses, conclude you're profitable, blow up again. Fix: auto-import everything, or commit to logging within 1 hour of exit.
- Tracking gross P&L not net. A 2% strategy edge gets wiped by 1% in round-trip costs on options. If your net-P&L column doesn't include STT + brokerage + exchange + GST + stamp, your "edge" is fiction. Use our R-multiple calculator for sanity-checks.
- 40 columns of vanity metrics. Greeks at entry, IV percentile, RSI, MACD, moon phase. The numbers that change behaviour are net P&L, R-multiple, win rate by strategy tag. Everything else is procrastination.
- Skipping the "why entered" field. This is where 90% of the value lives. If "good entry" is "Bollinger touch + EMA-20" you can test it. If it's "felt right" — that's data too. Either way: write it.
- Quitting after a bad week. A journal during a winning streak is dopamine. A journal during a losing streak is the whole point. Quitting in week 3 because the data is uncomfortable means you forfeit months 4–12.
- Mixing brokers in one tab without a broker column. Zerodha brokerage is ₹20/order; some banks' broking arms are 0.03% with no cap. If your template lumps them, you can't tell whether a "losing" strategy is actually losing or just being charged 3× more per trade. Add a broker column.
7. How TradeDiary helps
Most of this you can do in Sheets — and if you're disciplined enough to do that, you don't need a tool. For everyone else:
TradeDiary is built for Indian traders specifically. It auto-imports Zerodha / Kotak / Upstox / Dhan contract notes, FIFO-matches every quantity for ITR-ready reports, computes net P&L after STT + brokerage + GST + stamp per leg, and groups F&O weekly performance by each underlying's native expiry cycle. The free tier covers 50 trades/month — enough to journal your first month and see the patterns.
→ Start with the free template — no card needed.
You may also like: what to write in a trading diary, with 5 examples, excel vs trading journal — which wins, the Zerodha trade journal guide, why an AI trading journal beats a spreadsheet, or the full options trading journal India guide. You might also want where a Notion trading journal breaks. For the complete picture, start with the trading journal India guide.
Frequently asked questions
Is a trading journal template mandatory in India?
Not by law for retail traders. But if you trade intraday equity or F&O you file ITR-3 with business income, which needs a trade-wise ledger. SEBI also requires retention of contract notes for 7 years. A journal is the cleanest way to satisfy both — and the only one that also helps you stop losing money.
Can I use a free Excel template, or do I need a paid app?
For under 20 trades a month and one broker, free Excel/Google Sheets is fine — and arguably better because the manual entry forces reflection. Beyond 20 trades a month, two brokers, or any F&O multi-leg trading (iron condors, calendars), the maintenance cost of the Sheet exceeds the price of an app within four to six weeks.
What's the difference between a trading journal template and a tax P&L report?
A tax P&L report (like Zerodha Console's) tells you what happened — realised gains, STT paid, turnover. A journal template adds why it happened — strategy tag, planned R, the one-sentence thesis at entry. Tax reports satisfy the tax department; journals satisfy your future self trying to stop losing money.
Does Zerodha provide a built-in journal template?
Zerodha's Console gives you trade history and a tax P&L report, but not a strategy-tagged journal with notes, R-multiples, or behavioural fields. It's a record of what happened, not a tool for learning from it. Most active traders pair Console with a dedicated journal — see our Zerodha trade journal guide for the integration.
How long until journaling actually improves my P&L?
Two patterns from the ~500 Indian retail traders we've talked to: behavioural improvements (fewer revenge trades, less sizing creep) show up in two to four weeks. Strategy-level improvements (killing negative-expectancy tags, doubling positive ones) need a sample of 20–30 trades per tag — typically six to ten weeks for a part-time trader. Don't expect overnight; do expect noticeable change by month two.
Risk disclaimer
This article is for educational purposes only and does not constitute investment advice. Trading in equity and derivatives in India carries substantial risk of loss. Past performance is not indicative of future results. As per SEBI's January 2024 study, 9 out of 10 individual F&O traders incurred net losses over FY22. Trade only with capital you can afford to lose, and consult a SEBI-registered investment advisor for personal recommendations.
Author: Pulkit Mangal — Founder, TradeDiary. Equity + F&O trader since 2017. Built TradeDiary after personal losses of ₹14L in FY21 highlighted the absence of a market-aware journaling tool for Indian retail.
Last updated: 28 May 2026.