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 →| Date | Symbol | Gross P&L | STT | Brokerage | Exchange Charges | Net P&L | Notes |
|---|---|---|---|---|---|---|---|
| 04/06/2026 | NIFTY CE | 97.50 | 6.00 | 40.00 | 10.64 | 40.86 | Scalp, 1 lot |
| 05/06/2026 | NIFTY PE | −390.00 | 5.27 | 40.00 | 10.43 | −445.70 | Scalp, 1 lot |
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).
More than half the gross went to costs. Moves this small only pay if the win rate is very high.
The numbers
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
- Get the contract notesDownload the week’s contract notes from your broker’s back office.
- Copy one row per tradeEnter Gross P&L, then STT, brokerage and other charges as listed on the note.
- Check the net against the brokerThe total of Net P&L should match the broker’s net for the week.
- 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.
Related templates
Read next
Free calculators
Terms on this sheet
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.