Trading Journal Workflow: A Template You Can Reconcile

Give the journal a job

A trading journal is more than a list of profits and losses. It should help answer a question that your statement cannot answer on its own: what did you intend to do, what actually happened, and what needs investigation? A statement is the financial record. The journal adds decision context, process observations and links to evidence.

CME’s trade-log lesson supports keeping and reviewing a consistent record. The workflow here is an original practical template, including separate fields for execution and copying events. It does not assume that journaling itself creates a profitable strategy.

Download the blank trading journal CSV template to start in a spreadsheet. The file contains headers only, so sample profits cannot be mistaken for your results. Add fields only when they support a review decision; a long form that is never completed is less useful than a short, reliable record.

Separate facts, plans and later interpretations

Use three layers. The first contains immutable facts from the broker or platform: identifiers, times, quantities, fills and costs. The second records the plan as it existed before execution: intended entry logic, risk amount and relevant constraints. The third contains observations made during review. Labeling these layers prevents hindsight from quietly rewriting the original decision.

If you correct a transcription error, preserve a note of the change and the supporting statement. If you change your opinion about a setup, add a new review note rather than editing the original rationale. That small discipline makes it possible to see whether a rule was followed or invented after the result.

Fields that earn their place

Field group	Examples	Review purpose
Identity	Account alias, trade group, order and deal IDs	Join evidence without exposing credentials
Instrument	Symbol, contract month, account currency	Keep units and expiry unambiguous
Timing	Decision, request and fill times with timezone	Investigate sequence and delay
Plan	Rule version, initial risk, intended quantity	Compare action with the prior plan
Outcome	Actual quantity, entry, exit, costs, net result	Reconcile the financial record
Review	Deviation, evidence link, next test	Turn an observation into a bounded action

Use an account alias rather than a login or account password. Keep private screenshots and statements in appropriately controlled storage. A shared review sheet rarely needs the personal identifiers visible in an unredacted brokerage export. The journal should improve traceability without becoming a repository for access credentials.

A worked record from decision to net result

Consider an invented trade with a planned $50 risk amount. The recorded gross result is +$82. Commission is $4 and another documented charge is $1. The net result is +$77. If the original risk definition is consistent with the journal’s convention, the net R multiple is $77 / $50 = 1.54R.

Suppose the intended entry was 100.00 but the actual entry was 100.02. Record both prices and the side. Do not automatically subtract a second slippage amount from net P&L if the actual-fill result already includes that price difference. A separate slippage measure explains execution; it should not be double-counted in the financial total.

The review can say, “The order met the documented entry rule; execution differed by two price units of 0.01; investigate whether the event window affected fills.” It should not say, “Good trade because it won.” A rule-compliant trade can lose, and an accidental oversized trade can win. These outcomes require different process responses.

Handle partial fills and partial exits consistently

Decide whether the journal’s main row represents an order, a fill or a complete position. For strategy review, a parent row for the full trading idea plus child fill records is often easier to interpret. The original deal identifiers should remain available for reconciliation even if the review sheet summarizes them.

For example, an entry filled in two pieces and exited in three pieces can generate several platform records. Counting every profitable exit as a separate winning trade changes the win-rate denominator. Group the records using a written rule and keep it unchanged across the reporting period. See orders, deals and positions for the distinction.

Use quantity-weighted prices when appropriate, and retain each fill if its timing matters. A single average price can hide a delayed partial fill. If a position remains open at period end, identify its valuation separately rather than silently dropping it from an equity-based performance review.

A quantity check can expose an error before any return calculation. For an invented one-unit position, entry fills of 0.4 and 0.6 total 1.0; exits of 0.25 and 0.75 also total 1.0, leaving zero open. Link each record to its original identifier and flag duplicates rather than adjusting quantities to make the totals agree. A cancelled unfilled remainder belongs in the operational log, not in realized profit as an extra zero-result trade. Apply this check independently to every copied account.

Record copied trades as related, separate outcomes

A master and follower may share a trade idea while differing in quantity, symbol mapping, commission and execution. Give the copying group a common identifier, then keep one financial record per account. This makes it possible to ask whether a missing follower result came from a rejected order, an intentionally skipped size or a missing export.

TradeCopier’s activity logs can help trace copying events. Pair those events with destination account statements. A successful routing event does not replace the broker’s fill record, and an account statement alone may not explain why a copier skipped a request.

If accounts use different currencies, retain both the original-currency result and the conversion convention used for any combined report. Do not add dollar and euro P&L into one total without conversion. The settlement currency reference explains the units to document.

A daily reconciliation that catches boring mistakes

1. Import or enter the day’s complete records, including losing and cancelled activity relevant to the review.
2. Match identifiers and quantities against platform exports.
3. Check commissions, funding and adjustments against the statement.
4. Flag unexplained differences without inventing a balancing number.
5. Attach concise notes to deviations from the recorded plan.
6. Mark the day reconciled only when totals and exceptions are understood.

Typical errors include a one-way commission entered as a round-trip fee, a timezone offset applied twice, duplicate imports and an exit attributed to the wrong entry. These are mundane problems, but they can change every later metric. Resolve them before comparing strategies or changing account settings.

Review one question at a time

A weekly review might examine whether actual risk stayed within the documented plan. Another might compare intended and realized entry prices during a specific session. Define the question, choose the relevant fields and retain unfavorable observations. Avoid searching dozens of combinations until a tiny subgroup appears profitable.

Use expectancy and profit factor as summaries, then inspect individual records behind unusual values. If one large winner explains the entire period, note that concentration. Do not remove it from the official record or assume it will recur.

For a process change, write a bounded next step: verify a contract setting in demo, correct a timezone field, or compare a new rule in a future test window. “Be more disciplined” is hard to verify. “Record initial risk before sending each demo order” creates an observable behavior.

Version the journal and protect its meaning

Changing a field definition halfway through a series can break comparisons. If you switch from balance returns to equity returns, start a new reporting version and explain the difference. If a setup label changes, preserve the old labels and an explicit mapping rather than rewriting history.

Back up the original exports separately from the working spreadsheet. Save a periodic read-only snapshot with the formulas used for the review. Test totals on a small hand-calculated example whenever a formula changes. A journal is a measurement system; it deserves the same attention to units and versioning as any other measurement process.

The useful output is an evidence trail that another person can follow from a question to a record and a calculation. It can reveal errors and support better tests. It cannot turn an incomplete sample into certainty about future returns.