Download this free monthly trading performance report template in Google Sheets or Excel format. It tracks the 7 metrics that actually predict whether a trading edge is working — and includes a per-setup breakdown and written narrative block that most spreadsheet templates skip entirely.
What’s Included
- Monthly Summary Dashboard — Net P&L, win rate, profit factor, average R-multiple, max drawdown, and best/worst single day in one view. All cells are formula-driven; no manual calculations required.
- Per-Setup Breakdown Table — Each setup type gets its own row showing trade count, win rate, average P&L per trade, and total P&L contribution. This is the section most traders wish they had built months earlier.
- Trade Log Tab — A 22-column entry form covering date, symbol, setup name, direction, entry/exit prices, position size, commissions, and net result. The dashboard reads from this tab via SUMIF formulas.
- Profit Factor Calculator — Cell C4 on the Summary tab calculates gross wins divided by gross losses and applies conditional formatting: red below 1.5, green between 1.5 and 2.5, yellow above 2.5.
- Drawdown Tracker — Running peak-to-trough calculation across all trades in the month, updated row by row as you add trades.
- Narrative Block — A structured 3-row text section at the bottom of the Summary tab for written reflection. Research consistently shows that written self-assessment improves behavioral correction more than dashboards alone.
- Prop Firm Compliance Row — Compares your worst single-day loss against FTMO’s 5% daily rule and your total drawdown against the 10% maximum, using the starting balance in cell B2.
- Excel/CSV Version — An offline-compatible version for traders who prefer not to use cloud storage or want to share data with a coach without Google account access.
How to Use
Step 1: Copy the Template to Google Drive
Click the download link and select “Make a copy” to save the template to your own Google Drive. Rename the file with the month and year — for example, “May 2026 Performance Report” — before entering any data. Keep one copy per month; do not overwrite previous months.
Step 2: Enter Your Trade Log
In the Trade Log tab, add one row per trade. The minimum required fields are: Date (column A), Setup Name (column D), Direction (column F), Entry/Exit Prices (columns G and H), Position Size (column I), and Net Result in dollars (column N). Every formula on the dashboard pulls from column N and column D, so these two columns are non-negotiable. Commissions and fees go in column O and are subtracted automatically.
Step 3: Review the Per-Setup Breakdown
Navigate to the Setup Analysis tab after logging at least 8 trades. Rows populate automatically via SUMIF grouped by the setup names in column D of your Trade Log. Flag any setup where average P&L per trade is negative — this is the key insight the template is built around. A swing trader ending April with a +$1,840 net P&L might find that VWAP reclaim trades averaged +$310 per trade across 8 trades while earnings gap plays averaged -$95 per trade across 6 trades. The top-line number looks good; the setup breakdown shows exactly what to cut.
Step 4: Interpret Your Profit Factor
Cell C4 on the Summary Dashboard is the most important single number. Professional CTAs typically target a profit factor between 1.5 and 2.0. A reading below 1.5 points to an exit problem — either you’re closing winners too early or letting losers run too long. A reading above 2.5 with fewer than 15 trades is likely a small sample size artifact, not a repeatable edge. The healthy operating range for most retail strategies is 1.5 to 2.5.
Step 5: Complete the Narrative Block
Rows 28 through 30 of the Summary tab are the Narrative Block. Write 2–3 sentences in plain language: what drove performance this month, which setup or behavior cost the most, and one specific change to make next month. This section takes 5 minutes and is the difference between a performance record and a performance review.
Step 6: Archive and Compare Month Over Month
Save a PDF copy of the completed Summary tab (File → Download → PDF) before rolling into the next month. After 3 months of data, open the archived PDFs side by side and compare profit factor trends, setup-level shifts, and whether the behavioral change from the previous Narrative Block actually moved the numbers.
Key Benefits
- Setup-level attribution — Identifies the exact setups generating or destroying edge, not just whether the month was green or red
- Profit factor benchmarking — Built-in thresholds flag exit problems in real time, with context on what each range means behaviorally
- Prop firm readiness — Tracks FTMO-style daily and total drawdown limits automatically, useful for funded account applications and consistency reviews
- Written reflection built in — The Narrative Block prevents the common pattern of reviewing numbers without drawing behavioral conclusions
- Two formats, zero cost — Google Sheets version for coach sharing and collaboration; Excel/CSV version for offline or privacy-first workflows
Template vs JournalPlus App
| Feature | This Template | JournalPlus App |
|---|---|---|
| Trade entry | Manual row-by-row | Auto-import from 50+ brokers |
| Setup breakdown | Manual tagging in Trade Log | Auto-tagged with custom rules |
| Profit factor | Monthly calculation | Rolling 30/60/90-day, real-time |
| Drawdown tracking | Calculated per month | Live equity curve with peak-to-trough |
| Prop firm compliance | Manual threshold entry | Auto-linked to live account balance |
| Multi-month trends | Manual PDF comparison | Built-in cross-month analytics |
| Price | Free | $159 one-time, lifetime access |
This template is a genuine, complete tool for traders who want structure without a subscription. When manual entry becomes a bottleneck — typically around 20+ trades per month — or when cross-month trend analysis requires more than side-by-side PDF comparisons, JournalPlus handles both automatically.
Download
Download the free Monthly Performance Report Template and start your structured monthly review today. Both the Google Sheets and Excel/CSV versions are included. No account required.
Frequently Asked Questions
What metrics should a monthly trading performance report include?
A complete monthly report covers 7 core metrics — net P&L, win rate, profit factor, average R-multiple, max drawdown, best/worst single day, and a per-setup breakdown. Profit factor (gross wins divided by gross losses) is the single most useful number because it captures both win rate and reward-to-risk together.
How do I calculate profit factor in a spreadsheet?
In Google Sheets or Excel, profit factor equals SUMIF(result_range,">0") divided by ABS(SUMIF(result_range,"<0")). A result below 1.5 means you’re losing more on losers than you’re earning on winners — typically an exit timing issue rather than a setup selection problem.
How often should traders review their performance — daily, weekly, or monthly?
Monthly is the most effective cadence for behavioral improvement. Daily review is too granular — single-day results are dominated by noise. Quarterly review is too slow — poor habits solidify over 90 days before you address them. Monthly review gives enough trades for statistical signal while keeping the feedback loop tight enough to act on.
Do prop firms like FTMO require monthly performance reports?
FTMO and similar firms (TopStep, MyForexFunds) require traders to stay within daily loss limits (typically 5% of account) and total drawdown caps (typically 10%). While firms don’t always require a formatted monthly report, traders applying for funding upgrades or scaling plans benefit from structured records that demonstrate consistency — and this template tracks both thresholds automatically.
Is a Google Sheets trading journal template as good as dedicated software?
For traders with under 20 trades per month and no broker import needs, a Google Sheets monthly performance report template is a practical starting point. The limitations emerge at scale — manual entry becomes error-prone above 30 trades, and cross-month trend analysis requires building additional tabs. Dedicated tools like JournalPlus handle imports and multi-month analytics automatically, which is where most intermediate traders eventually land.
