Trade Accounting and Reconciliation Explained

Trade Accounting and Reconciliation

Reconciliation checks that internal records of trades, positions and cash match brokers, custodians and clearing houses. Learn the process, common breaks and fixes.

Advanced3 min readUpdated 3 Oct 2026

Lesson 34 of 44

Every trade creates records in several places: the trader's system, the broker's system, the clearing house, the custodian and the accounting ledger. Reconciliation is the process of comparing those records and resolving any differences, called breaks. It sounds like back office paperwork, but it is one of the most important controls in trading. Unreconciled breaks have hidden rogue trading, led to wrong risk numbers and caused firms to trade on positions they did not actually have.

What gets reconciled#

Item	Compared against
Trades	Broker confirmations and exchange or clearing records. See Execution Reports and Trade Confirmations
Positions	Custodian, prime broker or clearing statements
Cash	Bank and broker cash balances
Corporate actions	Dividends, splits and other events applied correctly. See Corporate Actions, Delistings and Rolls in Backtests
Fees and commissions	Broker invoices and schedules
P&L	Risk system versus accounting system
Collateral and margin	Amounts posted and received

The daily process#

Collect records from internal systems and external statements.
Match trades and positions by identifiers such as trade IDs, symbols, quantities and prices.
Identify breaks: differences in quantity, price, date, account or missing items.
Investigate the cause of each break.
Resolve: correct internal records or chase the counterparty to fix theirs.
Escalate old or large breaks to management.
Report reconciliation status as a control metric.

Common breaks and causes#

Break	Typical cause
Missing trade	Order booked manually and not entered in the system, or a late fill
Quantity mismatch	Partial fill recorded as complete
Price mismatch	Average price calculation or rounding differences
Wrong account	Trade allocated to the wrong fund or sub account
Settlement date difference	Wrong settlement cycle applied
Corporate action break	Split or dividend not processed on time
Duplicate trade	Same fill recorded twice after a system retry. See Alerts, Error Handling and Reconnection

Trade accounting basics#

Concept	Meaning
Trade date accounting	Record trades on the day they are executed
Settlement date accounting	Record when cash and securities change hands
Realised P&L	Profit or loss on closed positions
Unrealised P&L	Gains or losses on open positions marked to market. See Mark-to-Market
Cost basis methods	FIFO, specific identification or average cost, affecting realised P&L and taxes. See Trading Taxes and Capital Gains

Why reconciliation is a key control#

The Barings and Société Générale rogue trading cases both involved hidden positions or fictitious offsetting trades that proper, independent reconciliation should have caught. Regulators expect firms to reconcile regularly and to separate the people who trade from those who reconcile. See The Fall of Barings Bank and Operational and Model Risk.

Automation#

Firms use reconciliation software that matches millions of records automatically and flags exceptions for human review. Clean data, consistent identifiers and timely statements make the process faster and more reliable. See Data Pipelines and ETL.

For individual traders#

Compare your journal or trading software with broker statements at least monthly, and check year end tax forms against your own records. Automated traders should reconcile positions with the broker at startup and frequently during trading. See Record Keeping for Traders.

Frequently asked questions#

What is trade reconciliation?#

Comparing internal records of trades, positions and cash with external records from brokers, custodians and clearing houses, and resolving any differences.

What is a reconciliation break?#

A difference between two sets of records, such as a mismatched quantity, price or missing trade, that must be investigated and corrected.

Why is reconciliation important?#

It ensures positions, cash and P&L are accurate, catches errors and fraud early and supports correct risk management and reporting.

Next, learn how P&L is explained by its sources in P&L and Performance Attribution.

Check your understanding

3 quick questions on this lesson. Get them all right to finish it.

Turn on JavaScript to take the quiz.

Finished this lesson?Sign in to save your progress across devices.

Next lessonP&L and Performance AttributionPerformance attribution explains where returns came from: allocation, selection, factors, Greeks and costs. Learn Brinson attribution, P&L explain and how to use it.