Monthly Performance Report (₹)
An 8-column Excel report with one row per month: net P&L, trades, win rate, profit factor, best and worst setup, and a line of reflection.
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 →| Month | Net P&L | Trades | Win Rate | Profit Factor | Best Setup | Worst Setup | Reflection |
|---|---|---|---|---|---|---|---|
| Apr 2026 | −6,200 | 58 | 47% | 0.91 | orb | expiry-theta | Too many expiry trades |
| May 2026 | +17,000 | 64 | 52% | 1.21 | orb | expiry-theta | Halve expiry size |
What is inside
The weekly review fixes behaviour. The monthly report is where you decide what to keep trading. Twelve rows a year is short enough to read in one look.
Best Setup and Worst Setup are the two columns to compare across months. A setup that is worst three months running is a candidate to pause.
Trade Log · 8 columns
One row per month.
- Month
- Net P&L
- Trades
- Win Rate
- Profit Factor
- Best Setup
- Worst Setup
- Reflection
Worked example
A green month with one weak setup
May: ORB made ₹28,000 and expiry-theta lost ₹11,000, for a net of ₹17,000 (illustrative).
Two red months in a row for expiry-theta: halve its size or pause it. Leave ORB alone.
The numbers
Formulas to paste in
The download has headers and a sample row, not formulas. These match its column letters.
- Year-to-date net
- =SUM(B:B)
- Months with the same worst setup
- =COUNTIF(G:G,"expiry-theta")
How to fill it
- Total last monthFrom your journal, total net P&L, trades, win rate and profit factor.
- Name best and worst setupsUse your journal’s setup tags.
- Write one line of reflectionOne decision for the month ahead.
- Compare with earlier monthsLook down the Worst Setup column for repeats.
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 should a monthly trading report include?
Net P&L after charges, trade count, win rate, profit factor, your best and worst setups, and one written decision.
Is this an Excel or Google Sheets file?
It downloads as an .xlsx file that opens in Excel, or in Google Sheets after you upload it to Drive.
Is the Monthly Performance Report (₹) 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.