Trade Capture And Booking Errors
A trade that fills correctly in the market can still be booked wrong — the wrong account, wrong price, wrong quantity, wrong strategy tag — and catching that gap between execution and the books is a routine but essential part of running a desk.
Prerequisites: Blotter Hygiene: Keeping The Order Record Clean
An order executes cleanly in the market at exactly the intended price. Somewhere between execution and the firm's books, though, the trade gets booked with a fat-fingered quantity, credited to the wrong strategy, or captured against the wrong counterparty account. The market side of the trade was fine; the record of it wasn't. Trade capture is the process of turning an execution into an accurate entry in the firm's books and records, and a booking error is any place that process introduces a mismatch between what actually happened and what the books say happened.
Where booking errors come from
- Manual entry. Any trade that isn't captured straight-through from the exchange or venue — an over-the-counter deal, a phone trade, a correction — passes through a human at some point, and humans occasionally transpose digits or pick the wrong dropdown.
- System mapping issues. An instrument identifier that maps to the wrong security in one system but not another, silently booking the trade against the wrong underlying.
- Allocation mistakes. A block trade executed for multiple accounts or strategies has to be split correctly; get the allocation wrong and one book shows a position it doesn't have while another is short one it should have.
- Timing mismatches. A trade captured on the wrong date, especially around midnight or across time zones, throws off which day's P&L it counts against.
Worked example
A desk executes a block buy of 100,000 shares meant to be split 60/40 between two strategies. The trade capture system, due to a stale allocation template, splits it 50/50 instead. Both strategies' position files are now wrong — one shows 10,000 fewer shares than it actually has, the other 10,000 more — and both risk and P&L calculated off those files are wrong until the error is caught and corrected. Nothing about the trade itself was wrong; the booking was.
Catching it
The standard control is reconciliation: comparing the firm's internal trade record against an independent source — the exchange's execution report, the prime broker's confirmation, the counterparty's affirmation — and investigating any break. The sooner this happens after the trade, the cheaper the fix; a booking error caught same-day is a correction, while one caught weeks later can mean restating P&L that's already been reported.
What this means in practice
Same-day trade reconciliation, comparing every booked trade against an independent confirmation, is one of the most basic but highest-value operational controls a desk runs. It's unglamorous work, but the alternative — discovering a booking error during a client report or an audit — is far more expensive than catching it the same afternoon.
Execution and booking are two separate steps, and an error can enter at the second one even when the first was flawless. Same-day reconciliation against an independent record — the exchange, the broker, the counterparty — is the standard way to catch a booking error before it compounds into a bigger problem.
Further reading
- Harris, Trading and Exchanges (ch. 4)