ExcelFree · no sign-upF&O and derivatives

Net P&L After STT & Brokerage Tracker

An 8-column Excel sheet that takes each trade from gross to net: STT, brokerage and exchange charges in their own columns, so you can see what costs take out of a month.

The .xlsx opens in Excel, LibreOffice or Google Sheets (upload it to Drive, then open with Sheets). Delete the sample row before you log real trades.

See a worked example →
Trade Log
DateSymbolGross P&LSTTBrokerageExchange ChargesNet P&LNotes
04/06/2026NIFTY CE97.506.0040.0010.6440.86Scalp, 1 lot
05/06/2026NIFTY PE−390.005.2740.0010.43−445.70Scalp, 1 lot
Illustrative scalps of one Nifty lot. Exchange Charges here also holds GST, SEBI fee and stamp duty.
FormatExcel (.xlsx)
Trade Log sheet8 columns
Best forHigh-frequency F&O traders
Fill itWeekly, from contract notes

What is inside

Charges are small on one trade and large over a month. A scalper taking ten one-lot option trades a day pays roughly ₹40 to ₹60 per round trip, which is ₹400 to ₹600 a day before a single point of edge.

Fill this sheet from contract notes once a week. The ratio of total charges to total gross P&L is the number to watch: when it climbs past a third, the strategy needs bigger moves or fewer trades.

Trade Log · 8 columns

One row per trade or per contract note.

  • Date
  • Symbol
  • Gross P&L
  • STT
  • Brokerage
  • Exchange Charges
  • Net P&L
  • Notes

Worked example

A small winner that charges cut in half

Bought 1 lot of a Nifty call at ₹60 and sold at ₹61.50 a few minutes later (illustrative).

Gross P&L
₹97.50
Total charges
₹56.64
Net P&L
₹40.86
Charges / gross
58%

More than half the gross went to costs. Moves this small only pay if the win rate is very high.

The numbers

Gross = (61.50 − 60) × 65₹97.50
STT = 0.15% × 61.50 × 65₹6.00
Exchange 0.03553% of premium + 18% GST + stamp₹10.64
Net = 97.50 − 6.00 − 40 − 10.64₹40.86

Formulas to paste in

The download has headers and a sample row, not formulas. These match its column letters.

Net P&L (G2)
=C2-D2-E2-F2
Charges as % of gross, month total
=SUM(D:F)/SUM(C:C)

How to fill it

  1. Get the contract notesDownload the week’s contract notes from your broker’s back office.
  2. Copy one row per tradeEnter Gross P&L, then STT, brokerage and other charges as listed on the note.
  3. Check the net against the brokerThe total of Net P&L should match the broker’s net for the week.
  4. Watch the ratioTrack total charges divided by total gross each month.

Same review, without the typing

TradeLyser imports trades from supported Indian brokers by sync or CSV, with charges, and shows win rate, profit factor and drawdown for each strategy.

Try TradeLyser free

Read next

Questions traders ask

What is STT on options from April 2026?

STT on options is 0.15% of the premium on the sell side. Exercised options pay 0.15% of intrinsic value. On futures it is 0.05% of the sell-side value.

Why does my net P&L not match gross minus brokerage?

Exchange transaction charges, GST at 18% on brokerage and exchange charges, SEBI fee and stamp duty are also deducted. Copy all of them from the contract note.

Is the Net P&L After STT & Brokerage Tracker free?

Yes. The download link on this page needs no sign-up or email. The workbook ships with column headers and one sample row; add your own formulas or use the ones listed on this page.