Skip to content
Setup Journal

Why your trading journal's P&L doesn't match your broker

Missing exchange fees, trades counted as pairs, the wrong trading day and the wrong point value. The four reasons journal P&L drifts from your statement, with a real example.

· 3 min read

Cover illustration: Why your trading journal's P&L doesn't match your broker

You log your trades, add them up, and the total is off. Not by much, but enough that you stop trusting the journal. Once you stop trusting it, you stop using it.

There are four usual causes. Here’s a real day of micro futures trading to show each one.

The example day

Three round trips on a Tradovate account, two contracts each:

Trade Gross P&L
MNQ long 2 −$170.00
MNQ short 2 −$126.00
MES short 2 (closed in two pieces) +$128.75
Total −$167.25

The broker’s account balance history says the day’s realized P&L was −$178.53. That’s $11.28 missing.

1. Commission isn’t the whole fee

The fills export showed $0.39 commission per contract per side, $4.68 for the day. Even after subtracting that, the journal is still $6.60 off.

The rest is in the cash history. For each contract, on each side, this account paid:

Fee Per contract, per side
Commission $0.39
Exchange fee $0.35
Clearing fee $0.19
NFA fee $0.01
Total $0.94

Each round trip of one contract costs $1.88. Three round trips of two contracts each is 12 contract-sides, and 12 × $0.94 = $11.28. Subtract that from −$167.25 and you get exactly −$178.53.

On micro contracts the “other” fees are often as big as the commission. If your journal only knows the commission, every day looks better than it was, and a strategy that looks slightly profitable can actually be slightly losing.

Fix: use your broker’s cash or fee statement, not just the fills. Tradovate’s Cash History export has every fee line.

2. Pairs aren’t trades

That MES short was closed in two pieces: one contract, then the other. Most broker “performance” reports show that as two rows, each pairing a sell with a buy:

Pair P&L
Sell 1 @ 7450.50, buy 1 @ 7442.25 +$41.25
Sell 1 @ 7450.50, buy 1 @ 7433.00 +$87.50

If your journal counts rows, that’s two winning trades, not one. Scale in and out a lot and your trade count, win rate and average win all drift away from reality.

Fix: rebuild trades from executions. A trade starts when your position leaves flat and ends when it’s back to flat. Everything in between, scale-ins and partials included, is one trade.

3. The trading day isn’t the calendar day

CME futures sessions run from 6:00 pm to 5:00 pm New York time. A trade at 7:00 pm on Tuesday in New York belongs to Wednesday’s session, and that’s how your broker’s daily statement counts it.

It gets worse if you trade from another timezone. From India, the US cash session runs from 8:00 pm to 2:30 am in winter (7:00 pm to 1:30 am in summer), so one session spans two calendar dates. Group trades by your local calendar date and your daily totals never line up with the broker’s.

Fix: group trades by the exchange trading day, or at least know which convention your journal uses.

4. The wrong point value

MNQ is worth $2 per point and NQ is worth $20. MES is $5 and ES is $50. A spreadsheet formula that uses the wrong one is off by 10×, which is easy to spot. Rates and currency futures are harder: ZN is quoted in 32nds and moves in half-32nds, and 6J has a tick size of 0.0000005.

Fix: use a contract table rather than typing multipliers by hand. Our tick value calculator lists 60+ contracts.

How to know you’re right

The simplest check is to compare your journal’s daily total to the realized P&L on your broker’s daily balance report. If they match to the cent, your fees, pairing and trading-day grouping are all right.

Setup Journal does this check automatically. Import Tradovate’s Account Balance History with your fills, and the import preview shows Matches −$178.53 ✓ next to each day, or tells you exactly how far off it is.

Your next review takes 60 seconds

Free. Look around with sample data first, then create an account to import your trades.