Checked 2026-11-10
Why doesn't my trading journal P&L match my broker statement?
Almost always one of six things: the export left out commissions and fees, so the journal shows gross P&L; the export carried dates but no execution times, so trades landed on the wrong day or at a fake hour; a multi-leg options position was recorded as separate legs; a file was imported twice; the account's base currency was not the journal's; or a partial fill was averaged differently. Check them in that order. None of them is fixed by a different chart.
1. Commissions and fees are missing from the export
Most broker CSV exports list the fill price and quantity and omit the commission, exchange and regulatory fees. A journal that imports that file can only compute gross P&L, and the statement shows net. On an active futures account the gap compounds quickly: a few dollars per round turn, dozens of round turns a week.
How to check: pick one closed trade, compute (exit − entry) × quantity × multiplier by hand, and compare it to the journal. If the journal matches your arithmetic but not the statement, the fees are the gap. Several vendors document this in their own help pages — Tradovate shares commission data only for same-day API syncs, Webull's CSV carries no commissions, and Tradervue's broker table flags many platforms "No commission data".
TradeFlow Quantum: CSV imports that include a realised-P&L column keep the broker's own net figure; files without one are computed gross from entry, exit and quantity, and the per-broker setup page says which case applies. The direct-API connections import gross P&L, except Coinbase, whose adapter deducts the commission the broker reports; each per-broker page says which.
2. The export has dates but no execution times
A date-only row ("2026-11-04") has to be stored as some instant, and the convention is midnight UTC. In US Eastern time that instant is 7 or 8 PM the previous evening, so a journal that formats stored instants in the market's time zone — which it must, to put a 21:30 ET Tuesday trade on Tuesday — will show a Nov 4 trade on Nov 3, at 7 PM, on the wrong weekday. Every date in the journal is one day early and every hour-of-day chart has a single spike at an hour you never traded.
How to check: open any trade and compare its date with the statement. If every trade is exactly one day early, the file had no times.
TradeFlow Quantum: since November 8, 2026 a stored instant at exactly midnight UTC is treated as date-only — it is filed on the written date, its weekday is the written date's, and its hour is reported as unknown rather than 7 PM. The import summary tells you how many rows had no time, and those rows are left out of hour-of-day views rather than plotted at midnight. The fix came from a trial account that imported 79 date-only trades and saw all of them a day early.
3. Multi-leg options are recorded as separate legs
A vertical, a calendar or an iron condor is one position with one P&L, but the broker export lists two to four fills. A journal that treats each fill as its own trade shows legs that each look like a loss or a win, computes risk on the wrong basis, and can leave a phantom open position when a closing leg is dropped. Reviewers of widely used journals report it in 2025–2026.
How to check: count the trades the journal shows for one spread you know you opened and closed. If it is more than one, legs were not grouped.
TradeFlow Quantum: of the ten direct-API adapters only Alpaca, Charles Schwab, Tradier, Tastytrade, Questrade and E*TRADE import option fills today; of the other four, TradeStation keeps equities only, Tradovate keeps futures, OANDA forex and Coinbase crypto, so an option fill there is left out rather than imported as a mis-sized stock trade, and each per-broker page states which. CSV import recognises an option only from a full OCC symbol. The grouping engine — OCC parsing, FIFO matching per contract, spreads, calendars, condors, rolls, expirations and assignments — was built and fixture-tested on November 8, 2026 and is wired to a broker only behind a reconciliation test against that broker's own transaction shapes; the supported-brokers page says "options sync" for a broker only when that test passes.
4. The same file was imported twice
Re-uploading an export, or syncing a broker after a CSV of the same period, doubles the trades unless the journal has a stable identity for each fill. Symptom: P&L roughly double the statement, trade count double.
TradeFlow Quantum: the trades table has a uniqueness key on user, symbol, open time, side, entry, quantity and the broker's execution id, so a re-import is skipped row by row and the import summary reports those rows as "already in your journal" rather than inserting them.
5. Currency base and 6. Partial fills
A statement in CAD or EUR compared with a journal that assumes USD disagrees by the exchange rate; forex P&L quoted in pips rather than account currency disagrees by the lot size. And a position filled in three pieces at three prices will show one average price on the statement and up to three rows in a journal that does not merge fills.
How to check: confirm the account currency on the per-broker page, then compare one partially filled order's row count.
TradeFlow Quantum: OANDA P&L is taken from the broker's own pl field, and only USD-home OANDA accounts sync today — a non-USD account is skipped rather than imported in the wrong currency; Questrade and Coinbase amounts are imported in the account's currency as reported. Partial fills are paired lot by lot, first in first out, so one order filled in three pieces can appear as up to three trades; TradeStation's connection reads whole orders, so its fills arrive combined. CSV files that list executions behave the same way.
What "matches the statement" should mean
A journal's job is to reproduce the statement's net P&L per closed position, per day, to the dollar, and to say which inputs it was not given. If it cannot, the analytics built on it — expectancy, drawdown, hour-of-day, setup comparisons — inherit the error silently. Before trusting any chart, reconcile one week by hand: five closed trades, statement net versus journal, and the day each landed on.
Questions traders ask
My journal shows every trade one day early. What happened?
Your export had dates without execution times. Stored at midnight UTC and formatted in US Eastern, each date becomes the previous evening. TradeFlow Quantum files such rows on the written date and reports how many rows had no time; in other journals, re-export with execution times.
Why is my journal P&L higher than my broker's?
Commissions and fees are missing from the export, so the journal computed gross P&L. Compare one trade by hand; if the journal matches (exit − entry) × quantity but not the statement, fees are the difference.
Does TradeFlow Quantum import options from my broker?
Of the ten direct-API adapters only Alpaca, Charles Schwab, Tradier, Tastytrade, Questrade and E*TRADE import option fills today, through the multi-leg grouping engine. Of the other four, TradeStation keeps equities only, Tradovate keeps futures, OANDA forex and Coinbase crypto (with real contract multipliers), and option fills there are left out rather than mis-priced. CSV import recognises options from a full OCC symbol.
If I import the same CSV twice, do I get duplicates?
No. Rows are matched on user, symbol, open time, side, entry, quantity and execution id, and the import summary reports repeats as already in your journal.
Sources
- TradeFlow Quantum — supported brokers and per-broker notes
- TradeZella help — Tradovate P&L issues (commission data only on same-day sync)
- TraderSync help — Why doesn't my P&L match my broker?
- Tradervue — supported brokers table ("No commission data" flags)
- Tradervue help — importing without execution times
Related
- Supported brokers
- Webull CSV import
- How to journal options trades
- What is a prop firm consistency rule, and how is it calculated?
- Which brokers sync automatically with TradeFlow Quantum, and what does each sync actually import?
- How should a trading journal group multi-leg options trades?
- What happens when I hit a prop firm's daily loss limit: do I fail, or just stop for the day?
- What is a trailing drawdown, and what is the difference between end-of-day and intraday trailing?
- When does a broker connection expire, and how will I know?
- Which broker CSV formats does TradeFlow Quantum recognise before upload?
- Can I import my Tradervue export into TradeFlow Quantum?
- Is my trading journal data backed up?
- Which prop firms lock the trailing drawdown, and where?
- How many losing days can a prop firm evaluation take before it fails?
- What is the profit target as a share of the account at each prop firm?
- What is the minimum number of trading days to pass a prop firm evaluation?
- Can I share my prop evaluation progress without showing my P&L?
- What happens to my trading journal if I cancel TradeFlow Quantum?
- Can I connect my prop firm account (Topstep, Apex, FundedNext) to a trading journal?
- Can I import Robinhood trades into a trading journal?
- How does a prop firm evaluation fail? The rules that end one, and the ones that only delay a pass
- Is there a free trading journal?
- Does TradeFlow Quantum sync Alpaca automatically?
- Does TradeFlow Quantum sync Charles Schwab automatically?
- Does TradeFlow Quantum sync Tradier automatically?
- Does TradeFlow Quantum sync Tastytrade automatically?
- Does TradeFlow Quantum sync TradeStation automatically?
- Does TradeFlow Quantum sync Tradovate automatically?
- Does TradeFlow Quantum sync Questrade automatically?
- Does TradeFlow Quantum sync OANDA automatically?
- Does TradeFlow Quantum sync E*TRADE automatically?
- Does TradeFlow Quantum sync Coinbase automatically?
- Does TradeFlow Quantum sync Interactive Brokers automatically?
- Does TradeFlow Quantum sync Fidelity automatically?
- Does TradeFlow Quantum sync Robinhood automatically?
- Does TradeFlow Quantum sync Webull automatically?
- Does TradeFlow Quantum sync NinjaTrader automatically?
- Does TradeFlow Quantum sync Sierra Chart automatically?
- Does TradeFlow Quantum sync MetaTrader 5 automatically?
TradeFlow Quantum is a $15/month trading journal: 10 direct broker connections that work during the 7-day trial, nightly sync for paid accounts, a prop-evaluation copilot, and a P&L-free weekly discipline grade. Descriptive analytics only — nothing in the analytics edits your trades.
Start your 7-day free trial →