Free Trading Journal Template for Prop Firm Challenges: Excel and Notion Setup Guide (2026)

A prop firm evaluation can become difficult when a trader loses track of daily losses, increases position sizes after a losing trade, or reaches a profit target without understanding how much risk was taken to get there. A few profitable trades do not necessarily demonstrate a repeatable process, and a single breach of an account's rules can undo substantial progress.

A free trading journal template for prop firm challenges helps traders record each trade, monitor account-level risk, measure performance, and identify habits that need attention before they become costly mistakes.

The most useful journal does more than record entry and exit prices. It connects individual trading decisions with the rules of a specific evaluation or funded account. It should show whether a strategy is producing positive results, how much drawdown has occurred, and whether the trader is following a consistent process.

This guide explains how to build a trading journal in Excel or Notion, which metrics to track, how to adapt the system to The5ers and FTMO, and how to use the results when comparing funding programs.

![StockRadars trading app screen displaying financial charts and market metrics for prop firm risk trackingpexels-stockradars-co-1851828201-28682348.jpg.

1. Why Do You Need a Trading Journal for a Prop Firm Challenge?

A trading journal helps traders measure their decisions against a documented process rather than relying on memory or recent profits. It can reveal repeated mistakes, inconsistent risk-taking, and trading patterns that may conflict with evaluation rules.

Research published in the Review of Economic Studies examined self-monitoring and trading performance in an experimental financial market. It found that self-monitoring was associated with better performance in the experiment, while overconfidence-related miscalibration reduced performance. This supports the value of examining trading decisions, but it does not establish that journaling guarantees better results in real-world prop firm challenges. Read the research.

Can a trading journal improve consistency during an evaluation?

A journal can make consistency easier to measure by recording what happened, why a trade was taken, how much was risked, and whether the entry followed the strategy.

For example, a trader might discover that most avoidable losses occur after two consecutive losing trades. The journal cannot eliminate that behavior, but it can make the pattern visible and support a predefined response, such as pausing after a set number of losses.

A useful record should answer four questions:

• ●Did the trade meet the strategy's entry criteria?
• ●Was the position size appropriate for the planned stop-loss?
• ●Did the trade follow the account's rules?
• ●What should be repeated or changed next time?

The goal is not to make every trade profitable. It is to understand performance over a meaningful sample and distinguish a strategy's normal losses from preventable execution errors.

What should a prop firm journal track beyond ordinary trade results?

A regular journal often focuses on profit and loss. A prop firm journal also needs to track the account's rule boundaries.

Record the following:

• ●Daily loss: The applicable daily loss limit and the current amount of headroom remaining.
• ●Maximum drawdown: The account's permitted overall loss and the current distance from its breach threshold.
• ●Equity exposure: Floating profit or loss, commissions, swaps, and other costs where relevant to the firm's calculation.
• ●Rule compliance: Any restrictions involving trading times, news, instruments, position holding, or prohibited strategies.
• ●Evaluation progress: Current profit relative to the target, required trading days, and any other applicable conditions.

These controls matter because some firms calculate limits using equity, not just closed-trade results. An open position can therefore threaten a limit even when the journal's closed-trade profit looks acceptable.

2. What Should a Prop Firm Trading Journal Template Include?

A useful trading journal combines trade-level information with account-level metrics. Trade-level fields explain individual decisions; account-level figures show how those decisions affect performance and rule compliance over time.

Which trade-level fields matter most?

Start with one row per completed trade. Add a separate record for open positions if you want to monitor floating exposure in real time.

Keep the notes specific. "Bad trade" does not explain what went wrong. "Entered before the confirmation candle closed" identifies a behavior that can be reviewed.

Also record whether a trade was closed manually, reached its stop-loss, or reached its target. This can help distinguish a strategy problem from an execution problem.

Which account-level metrics should you calculate?

These are the most useful starting metrics for a prop firm trading journal.

These figures require careful interpretation. A high win rate can coexist with negative expectancy if losses are much larger than wins. Positive historical expectancy also does not guarantee future profitability.

For meaningful comparisons, calculate results after trading costs and use a consistent definition of a trade, a trading day, and the equity series.

Important distinction: Your journal's personal maximum drawdown is not necessarily the firm's maximum-loss calculation. A firm may use a static threshold, a daily reset, a trailing rule, or a combination of conditions. Keep the two measurements separate.

3. How Do You Set Up a Free Excel Trading Journal for a Prop Firm Challenge?

Excel is particularly useful when you want formulas, numerical summaries, and an equity curve in one place. A basic journal can be created using a spreadsheet without purchasing specialized trading software.

How do you build an Excel journal with formulas and a dashboard?

Create four worksheets:

1. ●Trade Log: One row per completed trade.
2. ●Daily Summary: Daily realized P&L, trading costs, and account-level observations.
3. ●Rules Dashboard: Applicable profit targets, loss limits, current equity, and remaining headroom.
4. ●Review: Weekly and monthly observations about strategy execution and recurring errors.

In the Trade Log, use columns for date, instrument, setup, entry, stop-loss, exit, planned risk, gross P&L, costs, net P&L, R-multiple, and compliance.

Assuming the planned risk is in column G, net P&L in column J, and R-multiple in column K, example formulas are:

• ●Net P&L: =H2-I2 where H is gross P&L and I is total costs.
• ●R-multiple: =IF(G2>0,J2/G2,0)
• ●Win rate: =COUNTIF(J2:J101,">0")/COUNT(J2:J101)
• ●Profit factor: =SUMIF(J2:J101,">0",J2:J101)/ABS(SUMIF(J2:J101,"<0",J2:J101))

These formulas assume the columns are arranged as described and that the selected range contains closed trades. Handle blank rows and periods with no losses separately so that the dashboard does not display misleading errors.

For an equity curve, calculate cumulative net P&L and add it to the starting balance. Plot the resulting balance or equity values over time. To calculate historical drawdown, compare each value with the highest previous value, then measure the decline from that peak.

A simple dashboard should show:

• ●Net P&L and total trading costs
• ●Win rate, expectancy, and profit factor
• ●Current equity and historical drawdown
• ●Current distance from daily and overall loss thresholds
• ●Number of rule-compliant trades
• ●Performance by strategy or instrument

Use conditional formatting to flag approaching risk limits. Treat those flags as warnings, not as a substitute for the firm's official account calculations.

How should you log trades and review performance each week?

Use a repeatable routine:

1. ●Before trading: Enter the account's applicable limits and calculate the risk allowed under your own plan.
2. ●After a trade closes: Record the actual result, costs, setup, and any execution deviation.
3. ●At the end of the day: Review current equity, daily loss headroom, and rule compliance.
4. ●At the end of the week: Group trades by setup, instrument, and execution quality.
5. ●Choose one improvement: Define a specific process adjustment to test in the next review period.

For example, if a strategy performs well when the entry criteria are fully met but poorly when trades are taken early, the next review can focus on entry compliance rather than increasing risk to recover losses.

A spreadsheet is only as reliable as its inputs. Reconcile important figures with account statements or platform records, especially when open positions, fees, or daily resets affect a firm's limits.

This template method is intended for educational tracking and is not financial advice.

4. How Do You Create a Notion Trading Journal on a Free Plan?

Notion is useful when the journal needs to combine trade records, written notes, strategy documentation, and weekly review pages. Excel generally has an advantage for complex numerical calculations, while Notion can be more convenient for organizing research and written observations.

How do you duplicate and customize a Notion journal?

Create a database with one entry per trade. Add properties for date, instrument, setup, direction, risk, result, R-multiple, and rule compliance.

Then create views for:

• ●All trades
• ●Trades grouped by setup
• ●Winning and losing trades
• ●Rule violations
• ●Trades awaiting review

Add a separate page for the evaluation's rules and a recurring review template. Record the firm's rule version and the date it was checked so that an old rule does not silently remain in use after a program changes.

If you are using a public template, inspect its database properties and formulas before relying on it. A template that records profits but ignores floating losses or daily loss resets is not sufficient for managing a rule-based evaluation.

What does Notion's Free plan allow, and how does it compare with Excel?

According to Notion's official pricing information checked on October 9, 2026, the Free plan supports unlimited pages and blocks for individual use, file uploads up to 5 MB per file, and seven days of page history. The Free plan also supports guests, subject to applicable workspace and guest limits. Plan limits can change, so verify the current details on Notion's official pricing page and page-history guide. Source: Notion pricing and help documentation.

Which should you choose? Choose Excel if numerical analysis and risk monitoring are your priorities. Choose Notion if your main need is organizing trades, documenting strategies, and reviewing decisions. You can also use both: calculate the key metrics in Excel and link to a Notion page containing your written review.

Neither platform automatically knows the correct rules for every prop firm. You must configure and maintain the relevant thresholds yourself.

5. How Do You Adapt Your Journal to The5ers Programs and Other Prop Firm Rules?

A prop firm journal becomes much more useful when it reflects the exact evaluation model, loss calculation, payout conditions, and scaling criteria of the account being traded. The5ers is a relevant example because its published programs offer different evaluation paths and account-growth structures.

The5ers' official website currently lists High Stakes, Bootcamp, and Pro Growth offerings, alongside program-specific rules and scaling information. These are distinct programs, so their thresholds should not be combined into one generic rule set.

![Trader manually logging trade details and risk management notes while reviewing live market charts on desktop monitorspexels-jakubzerdzicki-36633860.jpg.

How should you track The5ers' drawdown, targets, and evaluation flexibility?

Start by creating a separate rule profile for each account. Include the program name, account type, evaluation stage, initial balance, target, daily loss limit, maximum loss, reset time, minimum profitable days if applicable, and restrictions on trading activity.

The following examples illustrate why program-specific tracking matters.

The5ers program rule-mapping examples

The5ers' published High Stakes page lists a 10% target for Step 1, a 5% target for Step 2, a 5% maximum daily loss, and a 10% maximum loss. It also lists unlimited evaluation time and a minimum of three profitable days under the displayed program conditions.

Its published Bootcamp page shows a three-step evaluation with stage-specific profit targets and maximum-loss figures, followed by a funded stage with a 3% daily pause. The same page describes scaling against 5% targets. These details should be checked against the exact account and current terms before use.

The practical lesson is that a journal must store rules by stage, not simply by company. A threshold that applies during evaluation may differ from the funded-stage condition.

Also, do not treat unlimited evaluation time as permission to trade without a plan. The published program terms include inactivity conditions, and an evaluation without a deadline still requires discipline and risk control.

For each account, build a rules dashboard with these fields:

• ●Current balance and equity
• ●Applicable daily loss threshold
• ●Overall maximum-loss threshold
• ●Current profit target and progress
• ●Remaining loss headroom
• ●Required profitable or trading days
• ●Rule-specific restrictions and reset time
• ●Last date the rules were verified

Calculate the distance to the threshold using the same balance or equity basis the firm specifies. If the rule depends on floating losses, a closed-trade-only spreadsheet cannot accurately determine current headroom.

The5ers also offers performance-related tools within its Hub. Its official What's New page describes Trade Score, introduced in May 2026, as a feature for reviewing trade data and quality metrics. The page also lists TradingView integration and additional dashboard functionality.

These features can complement an external journal by giving traders another way to examine performance. An external spreadsheet or Notion database remains useful for custom notes, strategy tagging, and comparisons across review periods. Do not assume that a dashboard feature replaces every journal function or independently enforces every risk rule.

How do you track The5ers scaling milestones, profit splits, and payout cycles?

A scaling tracker should distinguish account growth from money actually earned or withdrawn. A higher account balance does not necessarily mean a trader has received that amount as a payout.

The5ers' published profit-split FAQ describes different starting splits and scaling conditions across its programs. For example, the page lists an 80% starting profit split for High Stakes, with the potential to scale to 100% under the stated conditions. It describes different starting arrangements for Bootcamp and Pro Growth. These conditions are program-specific and may change.

Track each milestone with the following fields:

The5ers' official Bootcamp FAQ, for example, states that the first payout can be requested 14 days after receiving a funded account, with subsequent requests every two weeks. It also states that the cycle resets when the account scales. Confirm that these conditions apply to the account in question before relying on them.

For a practical example, imagine a trader is tracking a $20,000 starting account and reaches a hypothetical 5% scaling milestone. The balance target would be $21,000 before considering fees, withdrawals, or other program-specific adjustments. The journal should record the target and the firm's confirmation separately; it should not automatically assume that reaching a calculated figure makes the trader eligible to scale.

A well-maintained scaling journal helps answer three separate questions:

1. ●Is the trading process staying within the account's risk rules?
2. ●Has the program's published milestone actually been satisfied?
3. ●Have the payout and scaling conditions been confirmed for this account?

That separation is particularly important when comparing programs. Two firms can use similar target percentages but different loss calculations, eligibility requirements, payout schedules, and scaling rules.

How can you adapt the journal to FTMO?

The same framework works for FTMO, provided its own rules are entered separately. FTMO's official Trading Objectives page describes different requirements for its 1-Step and 2-Step evaluation models. For its 2-Step model, the published rules include a 10% first-phase profit target, a 5% verification target, a 5% maximum daily loss, and a 10% maximum loss. The daily limit is recalculated using the specified midnight account balance, while the maximum-loss calculation differs from the 1-Step model.

For a $100,000 FTMO 2-Step evaluation, the journal can record the first-phase target of $10,000, the verification target of $5,000, and the applicable loss thresholds. It must also account for equity, including floating profit or loss, commissions, and swaps, where specified by the official rules.

Do not copy The5ers' rule settings into an FTMO account or vice versa. Even if the percentages look similar, calculation methods and reset conditions can differ.

FTMO is also distinct from Funded Trader Markets (FTM). These are separate names and must not be treated as the same company when researching program rules or building comparisons.

6. How Can You Use Journal Data to Compare Prop Firms and Make a Funding Decision?

A journal can help you evaluate whether a funding program's rules fit your existing trading process. It cannot establish that a particular firm will be profitable for you or that you will pass an evaluation.

The best comparison starts with your own measurable trading behavior, then considers the program's rules, cost, and payout conditions.

How do you compare The5ers and FTMO fairly?

Use the same checklist for each program, but record its exact requirements separately.

The5ers may appeal to traders who value its published scaling pathways and evaluation structures with no evaluation time limit in programs such as High Stakes and Bootcamp. Its multiple program paths allow traders to examine different approaches to evaluation, account growth, and profit sharing. However, the relevant loss thresholds, stage requirements, fees, and payout conditions must still fit the trader's strategy.

FTMO offers a useful comparison for traders assessing how one-step and two-step evaluations differ in targets and loss calculations. The right choice depends on the trader's strategy, risk tolerance, and ability to follow the selected program's terms, rather than on the headline account size alone.

Before making a purchase, use the journal to simulate the effect of each program's rules on your historical trading results. This is a retrospective exercise, not a prediction. Past performance may not reflect future results, and simulated rule compliance does not guarantee success in a live evaluation.

What journal results should you review before buying a challenge?

Review at least these five areas:

1. ●Strategy evidence: Do you have a sufficiently broad record of trades to evaluate your method, including losses and costs?
2. ●Risk discipline: How often did your actual position size exceed the risk planned before entry?
3. ●Drawdown behavior: How deep and how long were your historical losing periods?
4. ●Rule compatibility: Would the firm's daily and overall loss calculations have conflicted with your recorded trading behavior?
5. ●Financial readiness: Can you afford the challenge fee without relying on a payout or risking money needed for essential expenses?

A positive expectancy over a limited sample is not proof of a durable edge. Nor does a history of profitable trades demonstrate that the same approach will stay within a firm's particular loss limits.

The journal should help you identify the evidence you have and the gaps that remain. If your data is incomplete, risk-taking is inconsistent, or a program's rules are unclear, additional testing and research may be more useful than buying an evaluation immediately.

7. How Often Should You Review Your Trading Journal?

A daily review catches immediate risk problems, a weekly review identifies recurring execution patterns, and a monthly review helps assess the strategy over a broader sample. Each review serves a different purpose.

What patterns should you look for?

Use a consistent checklist rather than judging your performance by the last few trades.

Daily review

• ●Did any trade breach the planned risk limit?
• ●Is current equity safely within the firm's applicable thresholds?
• ●Were entries and exits consistent with the trading plan?
• ●Are any positions exposed to a rule change or daily reset?

Weekly review

• ●Which setups performed best after costs?
• ●Were losses concentrated in a particular session or instrument?
• ●Did performance change after consecutive losses?
• ●Were there trades taken outside the documented strategy?

Monthly review

• ●Is expectancy positive across a meaningful sample?
• ●Has maximum drawdown changed?
• ●Are results dependent on a small number of unusually profitable trades?
• ●Is the trading process consistent enough to justify further testing?

Avoid changing a strategy after every losing trade. Look for repeated patterns and assess them against a defined sample and review process.

What indicates readiness for a funded account or scaling milestone?

No single metric proves readiness. A more credible assessment combines positive historical expectancy, controlled drawdown, consistent execution, and demonstrated understanding of the intended firm's rules.

A useful pre-evaluation checklist is:

• ●The strategy has been tested over a meaningful sample.
• ●Results include trading costs and losing trades.
• ●Risk per trade is predefined and consistently applied.
• ●Daily and overall loss calculations are understood.
• ●Trading restrictions and payout conditions have been reviewed.
• ●The evaluation fee is affordable without depending on future trading income.
• ●The journal is accurate enough to support an informed decision.

Scaling should be treated as a separate decision from passing an evaluation. A larger account may introduce greater financial exposure to rule breaches and more pressure to maintain discipline. Follow the program's actual criteria and avoid increasing personal risk simply because a milestone appears close.

Summary: Turn Your Trading Journal Into a Decision-Making Tool

A trading journal is most valuable when it connects individual trades with account-level risk and the specific requirements of a prop firm evaluation.

Excel is a strong starting point for numerical analysis, while Notion is useful for organizing strategies and written reviews. Both can support a practical workflow when the underlying data is accurate and the rules are configured correctly.

For traders considering The5ers, the key is to understand the differences between its evaluation paths, drawdown mechanics, scaling milestones, and payout conditions. Compare those requirements with your recorded trading behavior before deciding whether a program fits your approach. Apply the same evidence-based process when comparing FTMO or any other active firm.

The next step is straightforward: build a journal, record a meaningful sample of trades, review the results, and verify the official program terms before committing to an evaluation. No template can guarantee a pass or payout, but a well-maintained record can make your decisions more informed.

For more prop firm comparisons, scaling guides, and practical trading education, explore Prop Firm Insider and its educational resources on evaluation rules, risk management, and funded-account growth.