Advertisement

Reading a Broker Statement and Trade History for Reconciliation

A broker statement is a periodic summary of cash balances, open positions, realized profit and loss, fees, swaps, and sometimes deposits and withdrawals. Trade history is the granular list of tickets and orders that should foot to that summary. Reconciliation means proving that your personal copy matches the firm’s copy within known tolerances. This article reads like a clerk’s guide to those documents. It does not recommend any broker and does not interpret whether a past trade was good or bad. It explains where numbers live and how disagreements surface.

Statement Sections and Their Plain Names

Statements usually open with account identification: name, account number, base currency, statement period, and generation timestamp. The equity and margin section lists balance, floating profit or loss, equity, used margin, free margin, and margin level percentage if applicable. The closed transactions section aggregates completed trades for the period. Open positions may appear on their own table with entry price, current price, swap to date, and unrealized result.

Advertisement

Fees may appear inline per trade or summarized in an adjustments line. Deposits and withdrawals should map to banking records. If your statement omits a expected deposit, the first action is chronological search, not assumption of loss.

PDF Versus Portal CSV

PDFs are human-readable; CSV exports feed spreadsheets. They should agree. Minor rounding on PDF footers can differ in the last digit from CSV floats. Define a tolerance—often one cent per thousand units of account currency—for automatic checks. Larger gaps are exceptions.

Portal downloads sometimes default to local timezone while PDFs use coordinated universal time. Normalize before comparing ticket times.

Advertisement

Trade History Fields Worth Mapping

Typical columns include ticket or deal ID, open time, close time, instrument, action buy or sell, size in lots or units, open price, close price, stop and take profit if set, commission, swap, taxes if withheld, profit, and comment. Pending orders that expired without fill may appear in a separate pending log rather than closed trades.

  • Match each closed ticket to a statement line or subtotal.
  • Sum swap for the period and compare to statement swap total.
  • Track partial closes as separate tickets that share an open parent where shown.

Some brokers split funding fees daily; others batch weekly. Read the glossary footnote once and file it.

Opening Reconciliation for a New Account

On day one, archive the welcome statement even if empty of trades. Note starting balance and currency. When the first trade closes, reconcile that single ticket manually before automating. Build a personal mapping table between platform column names and your spreadsheet headers. Automation fails silently when vendors rename columns.

Overnight and Rollover Boundaries

Swaps post at platform-defined rollover. A trade opened before rollover and closed after may show multiple swap lines. Statements that cut at midnight broker time may attribute swap to a different calendar day than your local notebook. Pick broker time as the authority for swap reconciliation.

Triple swap Wednesdays or Fridays appear in some metals and energy contracts; forex conventions vary. Highlight the broker’s published schedule in your folder readme file.

Floating Profit Versus Closed Rows

Statements taken mid-session show floating profit that will change with the next tick. Only closed rows belong in realized period P and L. Learners sometimes sum floating marks into monthly performance; statements do not do that until positions close or the period ends with a mark. Align personal performance rules with statement definitions before comparing to benchmarks.

Corporate actions on exotics may adjust open price retroactively with a comment ticket. Search history for adjustment deals when equity jumps without a visible market close.

Internal Transfer and Multi-Account Firms

Households may hold sub-accounts for strategies. Internal transfers should net to zero at the group level. If your reconciliation spans accounts, build a consolidation sheet with inter-account transfers explicitly negated.

Rebates and goodwill credits appear as positive balance adjustments with textual descriptions. Classify them in a non-trade income row in personal analytics so win-rate statistics on traded tickets stay honest.

When Numbers Disagree

Start from the newest authoritative artifact—usually the regenerated statement after a known platform maintenance window. Compare ticket by ticket from the disagreement date forward. Common benign causes include: unexported overnight ticket, duplicate manual spreadsheet row, currency conversion rounding on cross balances, and viewing an open trade as closed because the platform refreshed slowly.

Serious causes—missing fills, double fills, wrong size—require written support contact with attachments. Keep tone factual. Provide UTC times, ticket IDs, and screenshots of the history tab as of the download moment.

Third-Party Journal Imports

Analytics sites that import via read-only passwords can lag or drop micro tickets. Reconcile analytics totals to broker CSV monthly. Treat third-party dashboards as secondary evidence.

Tax software imports are tertiary. Never delete broker originals.

Retention Policy

Regulations vary on how long you must keep records. Even where law is silent, keep at least the current year and prior year of monthly statements plus raw ticket CSVs. Disk is inexpensive compared to reconstructing history after a laptop failure.

Encrypt backups that contain account numbers. Redact when sharing examples publicly.

Reading Without Storytelling

A statement is not a biography. Avoid margin call diaries that reinterpret every loss as lesson without numbers. The clerk’s view is enough: opening equity, additions, closed P and L, fees, withdrawals, closing equity, and a tie-out to trade history. Narrative comes after arithmetic agrees.

Handoff to Calendar and Margin Topics

Once reconciliation is routine, event-study logs and margin alarms become trustworthy inputs. Until then, spare time beats new indicators. Stable paperwork underpins every other educational topic on currency markets.

Currency of Account and Conversion Lines

Many retail accounts are denominated in United States dollars, euros, or pounds sterling even when the traded symbol is a cross rate. Profit on a euro-yen ticket may therefore appear translated into account currency at the platform’s rule. Statements sometimes show both native pair profit and conversion adjustment. Reconciliation requires summing those columns exactly as labeled rather than re-deriving from charts in a different currency.

Deposits in a third currency pass through conversion at bank or payment-provider rates that may not match the trading platform’s internal rate on the same minute. A one-day mismatch between bank receipt and platform credit is ordinary. File the payment receipt beside the statement line that acknowledges it.

Credit Bonuses and Segregated Ledgers

Promotional credits, if offered, may live in segregated balance buckets that cannot be withdrawn until volume conditions are met. Statements should identify non-withdrawable credit separately. Personal net-worth calculations should exclude non-withdrawable amounts unless you accept that constraint in writing. When a bonus expires, an adjustment line should appear; search history if equity drops without trades.

File Closed

Broker statements and trade history are twin ledgers. Build personal copies, respect timezones, investigate differences early, and store originals. That discipline protects you regardless of strategy fashion.

Disclaimer: This website is not a broker, does not execute trades, and does not provide trade signals or individualized financial advice. Foreign exchange quotations can move sharply; leveraged accounts can incur losses that exceed deposits. Information here is for general education only.

Advertisement
bxssadmin

The SportSports Editorial Team writes plain-English guides on insurance, health, education and forex trading. We check our work against official sources such as regulators, public health agencies and education departments, and we update guides when rules change.

Our editorial policy
Advertisement