How to reconcile a trading journal with broker statements

By intent: trade · Published October 27, 2026

Reconcile a trading journal by matching the same account, date range, timezone and currency, then comparing closed trades one by one with broker records. Explain every difference before using the journal to evaluate performance. A matching total alone does not prove that the underlying trades are correct.

Start with the records, not a performance score

A journal can look complete while containing an imported trade twice or missing a commission. Keep the original statement, execution report and export unchanged, then work on a separate reconciliation copy. The SEC's account-statement guide recommends comparing statements with trade confirmations. Those records also help distinguish trading results from deposits, withdrawals and other account activity.

This guide covers a manual recordkeeping workflow, not an audit opinion, tax calculation or automatic broker connection. Start with the trade import guide if you still need to choose an input method. Here, the job is to check what arrived, regardless of whether it came from a spreadsheet, screenshot or supported report.

Define the comparison before looking for differences

• Account and currency: use one account and one reporting currency first. Do not add amounts from different currencies without a documented conversion method.
• Period: record an inclusive start and exclusive end, plus timezone. A midnight boundary can place the same execution on different dates in two systems.
• Event basis: decide whether the report groups by execution, closing date or settlement date. Compare like with like rather than moving entries merely to force a match.
• Trade unit: state whether one row means a fill, completed position or strategy idea. Several fills can belong to one position. Record how they were grouped.
• Result basis: identify whether profit includes commissions, exchange fees, financing and other costs. Keep open-position valuations separate from closed-trade results.

A five-pass reconciliation checklist

1. Count and match. Match each source execution or position to a journal record using account, source identifier, instrument, side, quantity and time. A repeated identifier is a clue, not enough by itself: some reports reuse an order ID across partial fills.
2. Check the economics. Compare actual fills, quantity, contract multiplier where relevant, gross result and currency. Investigate reversed signs or decimal separators before editing.
3. Check costs once. Identify costs already included in the reported net result. If profit is calculated from actual fills, the effect of slippage relative to an intended price is already in those fills; do not subtract that same effect again.
4. Separate non-trade movements. Deposits, withdrawals, interest, dividends and adjustments can change account value without being closed-trade profit. Classify them rather than adding them as winning or losing trades.
5. Close or document each exception. Correct a proven import error while preserving its source reference. Leave an unexplained difference marked unresolved. Recalculate totals only after checking the records.

Worked example: explain a 107 USD mismatch

This fictional example uses three fully closed positions in one USD account and one matching time window. There are no open positions, financing charges, currency conversions or cash movements. The broker result is gross actual-fill profit minus separately stated commissions.

The journal initially shows A twice at 116.00 each, B at -60.00 without its commission, and C at 64.00 after subtracting 12.00 of slippage a second time. Its total is 236.00 USD. It exceeds the broker's 129.00 USD by 107.00 USD.

Remove the proven duplicate A entry: 236.00 - 116.00 = 120.00. Include B's missing commission: 120.00 - 3.00 = 117.00. Reverse C's duplicate slippage deduction: 117.00 + 12.00 = 129.00. The corrected total matches, and every underlying correction has a reason. Do not use a single unexplained -107.00 adjustment to hide all three errors.

What if the totals still do not match?

Check partial closes, transactions just outside the timezone boundary, fees posted separately and later statement corrections. Preserve the reporting precision rather than rounding every fill prematurely. Document any tolerance you use; there is no universal rounding tolerance appropriate for every instrument and account.

If the broker record appears wrong or contains unfamiliar activity, use the broker's official support channel promptly rather than assuming the journal is right. Investor.gov's recordkeeping guidance recommends retaining transaction records and examining confirmations and statements for errors. A journal does not replace those documents or professional tax advice.

Copy this exception log

Use the checked records for review

Only after reconciliation should you compare journal metrics or run a weekly review. A clean dataset can describe what happened; it does not establish a profitable strategy or predict future returns.

You can perform this check in the free CSV template or your own spreadsheet. intent: trade supports exporting saved trades as CSV or JSON for review, but this guide does not claim automatic reconciliation or a direct connection to every broker. See the current feature boundaries before choosing a workflow. Creating, editing, importing or restoring trades in the app requires an active Standard or Grand subscription; creating an account does not start a free trial.

For recordkeeping and review. Not investment, accounting or tax advice.