Why Your Trading Journal Doesn't Match Your Broker Statement

Your journal says one thing and your broker statement says another. The difference might be small, but ignoring it leaves you unsure which result to use in your review. Start with one account and one trading day. Compare the result after fees on both sides, then check fees, missing fills, and the way each record assigns the trading date. Do not change a number just to make the totals agree. Find the reason for the difference, correct the underlying record where needed, and keep any unresolved amount visible until you can explain it.

Why a small difference matters

A small difference can reveal a repeated problem. One missing fee may look unimportant on an individual trade, but the same omission across your records changes the result you are reviewing. A fill assigned to the wrong day can make one day look stronger and another weaker without changing the weekly total. The amount tells you how far the records disagree. It does not, by itself, tell you whether the cause is harmless or likely to happen again.

Your broker statement is the reference for the account result it reports. Your journal is a record you build from exported trades, entered costs, and your own notes. The two records may describe different parts of the same activity unless you deliberately compare the same account, date, and type of result. Before looking for a calculation error, make sure you have not compared a trading result before fees with a statement total after fees.

Matching matters because you use the journal for other questions. You may compare setups, review a difficult day, or look at what rule breaks cost. Those comparisons depend on the underlying trades and fees being complete. A detailed note cannot correct a missing execution, and a neat calendar cannot decide which day a fill belongs to. Get the record right before treating its summaries as an explanation of your trading decisions.

Agreement at the end of a week does not prove that every day is correct. A trade assigned one day early can create equal and opposite differences in two daily totals. Looking only at the combined result hides the timing problem. If you then compare weekdays or review a particular session, the error reappears in the analysis. This is why a day-by-day check can reveal something a monthly total will not show.

It is also possible for two errors to offset one another. An omitted losing trade might partially hide an omitted fee, leaving a smaller difference than either error alone. Do not assume the smallest visible difference must come from the smallest item. Begin with the complete record and work through it in a consistent order. The aim is to explain the result, not to find any adjustment whose amount happens to close the gap.

Keep a short note of what you have already checked. Record the account, trading date, export range, statement line, and remaining difference. That prevents you from repeating the same search the following evening or forgetting why you left a day unresolved. A clear unresolved record is more trustworthy than an unexplained match. It tells you what is known, what is missing, and which conclusion should wait until the underlying information is available.

Missing fees

The first question is whether both totals include the same costs. A price gain is not the same as the result after trading fees. Your platform export may include a commission column, a combined fee amount, or no fees at all. Your statement may show charges on separate lines. Read the column headings and the statement descriptions rather than assuming that a number labelled profit already contains every cost you need.

For a hypothetical example, imagine that the recorded price movement produced $50 and the day's relevant trading fees were $6. The result after those fees is $44. Comparing the $50 figure with the $44 figure produces a difference even when every entry and exit price is correct. These are illustrative amounts, not a broker's rates. The useful check is whether the difference can be traced to actual charges in your own records.

Check commissions, exchange fees, and regulatory fees separately where the source makes that possible. Do not add a charge a second time if the export already includes it within a combined amount. The description of a column matters as much as its value. If you cannot tell what a total includes, keep that uncertainty in your notes and inspect the statement breakdown before deciding that the journal needs an additional fee entry.

Pay attention to whether a fee is quoted per side, per contract, or for a completed round trip. A charge for the entry alone is not the total cost of entering and exiting. The number of contracts also matters. When the amount seems close but not quite right, compare the units before changing a rate. A calculation can be mechanically correct and still produce the wrong result if the value you entered describes a different unit.

A platform export that omits fees needs a documented way to supply them. Use the fee schedule that applies to your platform and account rather than a figure remembered from another account. Then inspect what the journal added. The presence of a fee number does not prove it is the right number. Compare it with the actual statement, especially when the same export layout is used across accounts with different charges.

After you identify a fee problem, recheck the day rather than stopping at the first explanation. Fixing one missing charge may reduce the difference without eliminating it. There could still be an omitted execution or a date problem. Keep the before-and-after amounts in your review note so you can see what the correction explained. A useful correction has a reason you can describe, not just a total that happens to look more plausible.

Partial fills and missing executions

An order is an instruction, while a fill records an execution. One order can be filled in pieces. If your export contains only part of that execution history, the journal does not have the same trading record as the statement. This can happen even when the symbol and the final position look familiar. Compare the actual quantities and execution records rather than assuming that one visible order row represents everything that happened.

Start with a trade you can identify on both sides. Check the instrument, the account, the direction, the quantity, and the relevant times. Then compare the entries and exits that belong to it. If one side shows more executed quantity, investigate the missing row before questioning the resulting profit. A difference in the trade record must be resolved at the trade-record level; changing a fee to compensate for it only creates another error.

The export's date range is a common place to look. A position may have begun before the selected range and ended inside it, or it may have been partly reduced near the boundary. Read what the export contains instead of assuming it captured a complete round trip. If you need a wider range to include the relevant fills, create that export and inspect its preview before saving it into the journal.

Filters can also hide relevant records. Check that the export includes the account and instruments you intend to compare. A file covering several accounts is not automatically comparable with a statement for one account. Likewise, a report of completed trades may not have the same structure as a report of individual executions. Use the report your journal supports and make sure its contents correspond to the question you are checking.

Do not count cancelled or working orders as executed trades. An order-history file can contain activity that never became a fill. If the statement has no corresponding execution, the order's presence in an export is not a reason to invent a trade. Read the import preview and the reported skips. A skipped row can be correct, or it can reveal a format problem that deserves investigation. The status and contents of the row determine which.

Once the missing activity is identified, correct the source or import through the supported workflow. Keep a copy of what you compared and avoid manually changing entry prices just to force agreement. After the corrected trades are in place, check quantities, fees, and the day's total again. A complete record should explain the difference. If it does not, the missing execution may have been one part of the problem rather than the whole explanation.

The futures trading day and trades near the 5 p.m. Central roll

A futures trading day is not always the calendar date shown beside a timestamp. An evening session can belong to the following trading day. In the convention described here, the boundary is 5 p.m. Central, and a Sunday-evening open counts toward Monday. If your statement and journal assign the same fill to different days, their daily totals can disagree even when the fill price, quantity, and overall profit are identical.

Take a hypothetical Thursday fill at 5:10 p.m. Central. Under that trading-day boundary, it belongs to Friday's trading day. If a journal instead groups it under Thursday because that is the timestamp's calendar date, the Thursday comparison gains activity that the statement places on Friday. The Friday comparison then lacks that activity. Looking at both days together may make the problem disappear, but the individual days remain incorrectly organized.

Check the time zone before checking the boundary. A time printed without a zone is incomplete information unless you know the convention used by the export. A record expressed in another zone cannot be compared with a Central-time boundary as if the printed hour meant the same thing. Read the platform's export instructions and your journal's import guidance. Do not simply add or subtract an hour because a recent trade seems to fit better afterward.

Use a fill you remember and can find on the statement to test the interpretation. Compare the actual execution time, the time printed in the file, and the trading date assigned after import. A second fill on the other side of the daily boundary can help you see whether the issue concerns the zone or the day assignment. Work from recorded times rather than trying to infer the correct setting from the profit total alone.

Weekend treatment deserves the same attention. Sunday evening should not become an isolated Sunday trading day when the broker includes it in Monday. That difference can make the start of the week look inconsistent even though all the fills are present. Read the trading-day label in the statement and compare it with the journal's label. The purpose is to use the broker's accounting day consistently, not to make every trade fit the date on your local clock.

After correcting a date interpretation, revisit both affected days. Moving activity from one day to another changes two comparisons, and fees attached to those trades must follow the same records. Write down the cause so you recognize it the next time an evening trade appears to be missing. If the export or statement remains ambiguous, leave the difference visible and seek clarification about that specific report rather than silently choosing the interpretation that produces a match.

Statements that leave fees out

Not every report that looks like a statement presents the same net figure. A performance report may emphasize the result from price movement while listing commissions elsewhere or omitting them from the displayed total. Before treating a disagreement as a journal error, identify the exact line you are comparing. Read its description and any separate fee lines. The right comparison is between equivalent results, not between the two largest numbers on the page.

The word net can also depend on the report's purpose. A total might be net of one adjustment while still excluding another charge relevant to your trading result. Do not rely on the word alone. Ask what was included and what was subtracted to produce that line. If the answer is not clear from the report, compare the detailed amounts or obtain the appropriate account statement before making a correction to your journal.

Keep trading fees separate from other account activity when deciding what should match. A deposit, withdrawal, or other account adjustment can change a balance without being the result of the trades in your export. Your task is to compare the journal's trading result with the corresponding trading result on the statement. It is not to force a trade-only record to explain every change in the account's total cash balance.

If the statement's relevant figure leaves fees out, record that fact before deciding which figure to enter for matching. Use an after-fee total only when you can explain how it was obtained from the actual statement information. Do not silently subtract a guessed amount or use another platform's fee rate. The corrected comparison should remain understandable to you later, when you no longer remember the details of the current day's investigation.

Sometimes the platform does not provide a suitable statement export. You may need to read the day's net from the statement and enter it by hand in a journal that supports that workflow. Manual entry makes careful checking more important, not less. Confirm the account and trading date, check the sign of the result, and make sure you have not copied a cumulative total into a field meant for one day.

After entering the appropriate figure, inspect any remaining difference. A statement that excludes fees can explain one part of a mismatch while an incomplete export explains another. Keep the reasons separate in your notes. You should be able to say which adjustment came from understanding the statement and which correction came from repairing the trade record. That separation prevents a convenient number from becoming a permanent substitute for an accurate explanation.

Checking one day, start to finish

Choose one account and one trading day that you can inspect without guessing. Collect the platform export and the statement covering that day, and note the date range of each. If the journal already contains trades, check whether the export you are about to use overlaps with an earlier import. Use the journal's preview and duplicate-handling information rather than assuming every new file represents new activity. Your starting point should be a clearly defined set of records.

Read the statement's relevant result and determine whether it includes the trading fees. Then inspect the journal's total after fees for the same day. Write down both values and the difference before making any changes. That gives you a stable comparison to return to. If you begin changing dates, fees, and rows at once, you can reach agreement without knowing which change was necessary or whether another error was introduced.

Compare the trade record next. Match the instruments, quantities, and entries and exits where you can. Check skipped rows and investigate any execution present on the statement but absent from the export. If a position crosses the export boundary, include enough history to understand the complete trade. Do not treat a familiar-looking total as a replacement for this check. The records need to describe the same activity before their costs and results can be meaningfully compared.

Then inspect fees and trading dates. Check whether charges were present in the file or supplied separately, and verify the units used for the amounts. For trades near the evening boundary, compare the assigned day with the broker's statement. Work through one cause at a time. After each supported correction, recalculate or refresh through the journal's normal workflow and record how much of the original difference that correction explains.

When the day matches, confirm that the agreement did not depend on excluding an inconvenient trade or overwriting a valid figure. Look back at the changes you made and make sure each has a source-based explanation. A matching number is useful because the underlying records agree, not because you found a way to make the display show a match. Preserve the original export and your correction note so that the reasoning can be followed again if necessary.

When the day does not match, stop short of inventing an answer. Record the exact remaining difference and the smallest unresolved question, such as whether a partial fill is absent or a fee line is included in the statement total. That focused question is more actionable than saying the whole journal is wrong. Continue reviewing what you can verify, but keep conclusions that depend on the unresolved result provisional until the missing information is available.

Making it a weekly check

A weekly check should confirm that the individual days still make sense, not replace daily accuracy with a larger total. Begin with the days already reviewed and look for any that remain unresolved. New imports or corrected exports may have changed a prior comparison. Check those changes deliberately rather than assuming that a day you inspected once can never need another look. The goal is a stable record that remains explainable as information is added.

Keep the review focused on differences and changes. You do not need to reread every note if the trade record and statement comparison have not changed. Spend attention on missing days, incomplete exports, unexpected fees, and activity near the trading-day boundary. A repeatable order helps you notice what is different this week. It also makes the review easier to finish on a difficult week when you are less inclined to study the result.

Look for recurring causes without turning them into unsupported conclusions. If several differences come from the same export choice, improve that part of your routine. If they come from inconsistent date ranges, write down the range convention you intend to use. The useful pattern is in your records and workflow. You do not need to speculate about hidden platform behavior when a simpler explanation is visible in the files you actually exported.

Preserve the distinction between a corrected record and an unresolved one. A known difference is still a difference; writing a note about it does not make the missing trade or fee appear. Keep the amount visible in your own review and avoid presenting the affected total as exact. That honesty is especially important when you compare weeks. A cleaner-looking report is not an improvement if it conceals uncertainty that was visible before.

Once the numbers are checked, move on to the trading review. Read your entries, exits, tags, notes, and rule breaks with the benefit of a record you understand. Matching does not tell you which trade to take next or guarantee a better result. It removes avoidable confusion from the information you use to judge your own decisions. You can disagree with a trading decision without also wondering whether the profit figure beside it was calculated from incomplete data.

Finish by choosing one practical improvement to the recording routine. That might mean saving exports consistently, checking the fee column before confirming an import, or reviewing evening fills with the statement beside them. Keep the change small and observable. At the next weekly check, ask whether it reduced the specific confusion you identified. The aim is not a perfect-looking journal. It is a record whose numbers you can explain without reconstructing the entire week from memory.

The short version

Compare one account, one trading day, and one equivalent after-fee result. Most useful investigations begin with the same questions: are the fees included, are all executions present, and are the trades assigned to the same day? Read the statement line carefully, because a performance total may not include the costs you expect. Make one supported correction at a time and keep the reason for each change.

Tomorrow, choose one day and put its export beside its broker statement before interpreting the journal's total. If the numbers disagree, write down the exact difference and work through the records without guessing. A match should be the consequence of complete trades, correct fees, and consistent dates. If information is still missing, preserve the difference and the question you need answered rather than hiding either one.