A trader reaches out convinced their journal is broken: the total loss for the month lines up exactly with what their broker shows, trade for trade, dollar for dollar — but the account balance figure at the top of the dashboard is off by close to a hundred dollars. Nothing in the trade history explains it. The instinct is to assume a bad withdrawal slipped through unrecorded. Usually, that's not it at all.
P&L and balance are answering different questions
A trading journal that only ever computes starting balance + cumulative trade P&L is implicitly assuming the starting balance was the only money that ever entered the account, and that no money ever left it outside of trading. That assumption holds for a static backtest. It rarely holds for a real, live account — funded and prop accounts get topped up incrementally, and evaluation accounts that pass get paid out. Every one of those events is real cash movement that has nothing to do with whether a trade won or lost, and a journal with no concept of a deposit or withdrawal has no way to represent it. The P&L total stays perfectly correct; the balance, which depends on cash flows too, quietly drifts.
The usual suspect: a double-counted starting balance
The most common single cause isn't a missing withdrawal — it's a double-counted starting balance. Say an account was actually funded with a $100 initial deposit partway through its history. If that $100 is recorded once as the account's starting balance and again as a separate deposit event, the balance calculation counts it twice, and the account reads $100 richer than it actually is. This is exactly what happened investigating a real trader's report: the header balance came out to $217.63 against a confirmed real broker balance of $121.38 — a $96.25 gap that matched the account's starting balance almost exactly, not a missing transaction. The fix wasn't finding a phantom withdrawal; it was correcting the starting balance to $0, since the account's real first funding event was already captured as a deposit.
How to actually find the gap
Reconciling a balance mismatch by re-deriving it from scratch, by hand, from a raw broker statement is slow and error-prone. The faster path is bisection: look at the account balance after each individual trade, in order, and find the exact point it first diverges from the broker's own statement. Whatever changed at that specific point — a deposit that was missed, a withdrawal that was missed, or a starting balance that was wrong from day one — is the cause. Working backward from a single end-of-month total gives you no way to localize the error; working forward, trade by trade, does.
Fixing it without corrupting your performance metrics
The fix has to be careful about one thing: a deposit or withdrawal is not a trading result, and correcting the balance should never touch win rate, expectancy, profit factor, or drawdown %. Those are supposed to measure trading skill against trading capital — mixing in cash movements would make a trader's edge look better or worse than it actually is, for reasons that have nothing to do with how they traded. A cash flow ledger kept separate from the trade list — feeding the equity curve and balance display, but never the win-rate/expectancy/drawdown calculations — is what makes that possible. And since a starting balance is sometimes just wrong from the moment an account was set up, there needs to be a way to correct it later without a manual database edit — a real UI path, not a one-time fix only an engineer can make.
What to check if your own balance doesn't match
- Does your journal have any concept of a deposit or withdrawal at all, separate from trade P&L? If not, any incrementally-funded or prop-payout account will drift over time by construction, not by bug.
- Is there a running balance column you can check trade-by-trade against your broker or prop firm's own statement, rather than only a single current-balance number?
- Was the account's starting balance set correctly at import time — and is there a way to fix it later if it wasn't, without losing every trade already imported?
Neither number was lying
Same lesson as why your broker's win rate doesn't match your journal's: a mismatch between two numbers that both look authoritative doesn't mean one tool made an error. It means one of them is missing a piece of context — here, real cash movement that trade data alone can't capture. ExpectancyIQ tracks deposits and withdrawals per account, shows a running balance column on every trade so a mismatch can be bisected instead of guessed at, and lets you correct a starting balance from Settings if that turns out to be the actual source.
Want to check your own account balance against your broker or prop firm? Import a CSV into ExpectancyIQ for free and add any deposits or withdrawals from Settings.