F&O Trading Journal with Automatic STT, Brokerage, SEBI and GST Charges

A record-keeping workbook for individual F&O traders on NSE and BSE: log a trade and see every charge worked out from a dated, editable rate table, so you see net P&L, not just gross. It gives no trade ideas, no strategies and no signals.

What's inside

• FnO-Trading-Journal-v1.0.xlsx: 11 sheets (Start Here, Settings, Charges, Trades, Contract Note Check, Daily, By Setup, By Instrument, By Weekday, Risk Rules, Year Summary, Lists) with 120 fictional sample trades, clearly labelled Sample
• FnO-Trading-Journal-Guide.pdf: a 14-page guide with a worked example, how to reconcile a contract note, and how to read R-multiple and expectancy

How to use it

1. On Settings, enter your exchange, brokerage plan and your own risk rule.
2. Clear the 120 sample rows on Trades, then log each trade you close: entry, exit, lots and exit type.
3. Every charge (STT, exchange transaction charge, SEBI turnover fee, stamp duty, brokerage, GST) computes automatically from the Charges sheet, along with gross P&L, net P&L, R-multiple and turnover.
4. Use Contract Note Check to compare a day's total against your broker's contract note, and open Daily, By Setup, By Instrument and By Weekday to see your own patterns.

Requirements

• Microsoft Excel 2010 or later. The workbook uses only functions that Google Sheets also supports (SUMIFS, INDEX/MATCH, IF, SUMPRODUCT and similar); no macros, no external links and no live data connection.

Good to know

• This is a template for general information, not legal, tax or financial advice. Laws and rates change. Check the current rules, or consult a qualified professional (an advocate, chartered accountant or company secretary), before relying on it.
• Trading in derivatives carries a high risk of loss for individual traders. See SEBI's "Study - Profitability of Individual Traders in the Equity Derivatives Segment (FY25-FY26)", dated 20 August 2026 (link on the Start Here sheet).