Capital Markets Reconciliation

Part 7 of the Complete Guide to Reconciliation Systems in BFSI

Shortly after a portfolio manager buys 10,000 shares, the trading screen shows a completed order. The broker confirms the execution, and the portfolio system includes the shares in its expected position. Two days later, operations learns that 2,000 shares did not settle because the delivering party lacked sufficient securities.

Nothing in the original execution screen looked wrong. A trade had occurred, but part of the promised exchange of securities and cash had not been completed.

The failed quantity now affects several records. The investment manager has an executed trade, the clearing process has an obligation, the custodian has only 8,000 newly settled shares, and cash may have moved differently from the original expectation. Risk, funding, client reporting, and accounting can each receive a different representation unless the failure is identified and controlled.

This story reveals the central challenge of capital-markets reconciliation: an executed trade is not the same as a cleared obligation, a settled movement, or a position held in custody. Reconciliation connects these stages without pretending that they are one event.

One Trade, Several Distinct Stages

#

Capital markets bring together investors, investment managers, brokers, trading venues, central counterparties, clearing members, settlement systems, custodians, securities depositories, cash banks, and accounting systems. The exact participants depend on the instrument, market, and trading arrangement.

The lifecycle can be understood through several distinct concepts:

• Execution occurs when a buy and sell order result in an agreed trade.
• Trade confirmation communicates or affirms the trade’s economic details between relevant parties.
• Clearing determines, validates, and may net the obligations that must be fulfilled. In some markets, a central counterparty becomes buyer to every seller and seller to every buyer through a legal process governed by that market.
• Settlement completes the contractual exchange, normally through delivery of securities and payment of cash or another agreed consideration.
• Custody is the safekeeping and administration of securities for an owner or client, reflected through accounts maintained by a custodian and relevant market infrastructure.
• A position is a quantity or exposure in a security at a stated time and under a stated basis, such as traded, settled, available, or beneficially owned.

These terms must not be collapsed into one status called “complete.” A broker can correctly report an execution while a custodian correctly reports no settled holding yet.

Observation: Different systems can correctly represent different stages of the same trade.

Concept: Capital-markets reconciliation establishes continuity from agreement through obligation to final movement and safekeeping.

From Order to Broker Execution

#

An investment decision usually enters an order management system (OMS), which records the instruction to buy or sell. An execution management system (EMS) may route the order and receive fills from brokers or venues. A fill is an executed portion of an order; one order can produce several fills at different prices and times.

Suppose a manager orders 10,000 shares with a price limit. The broker executes three fills:

The weighted average execution price is $25.004 because $250,040 divided by 10,000 equals $25.004. Commissions, taxes, levies, or other charges are separate economic components and should be reconciled under the applicable agreement and market rules.

Order-to-execution reconciliation can test:

• Account, portfolio, broker, instrument, side, and currency
• Ordered quantity against filled, canceled, and open quantities
• Individual fills against broker execution reports
• Price and gross consideration
• Trade date and execution time
• Commission and other approved charges
• Duplicate, missing, or late execution messages

The control should preserve the one-to-many relationship between an order and its fills. Comparing only the final quantity can conceal a duplicate fill offset by a missing one. It should also distinguish an OMS cancellation from an execution that occurred before the cancellation reached the market.

Trade Confirmation and Allocation

#

After execution, the parties must agree on the trade details and direct the trade to the correct account. Allocation divides an executed block trade among portfolios or client accounts. Confirmation or affirmation processes establish agreement on the economic and settlement details, although terminology and workflow vary by market.

Imagine that the 10,000-share trade should be allocated 6,000 shares to Fund A and 4,000 to Fund B. A transmission defect sends 5,000 to each fund. The broker’s total still agrees with the manager’s total, so an aggregate trade reconciliation passes. Account-level reconciliation fails because each fund has the wrong obligation and expected position.

Controls should compare the broker’s confirmation with internal records using instrument identifiers, trade date, side, quantity, price, currency, settlement date, account, place of settlement, counterparty, and charges. Where instruments have multiple identifiers, normalization must use governed reference data rather than an unreviewed text match.

Observation: Correct totals do not prove correct ownership or allocation.

Concept: Trade reconciliation must operate at the level where economic rights, obligations, and client reporting are assigned.

Clearing Creates Obligations

#

Clearing turns matched trade details into obligations for settlement. Depending on the market, obligations may remain bilateral, pass through a clearing organization, or be replaced by obligations to a central counterparty. Trades may settle individually or be netted, meaning multiple obligations are combined into a smaller net amount or quantity under defined rules.

For example, if a member must receive 10,000 shares and deliver 6,000 shares of the same eligible security in the same netting set, the clearing result may be a net receipt of 4,000 shares. This teaching example does not imply that every market, account, or instrument permits netting.

Trade records and clearing obligations are therefore related but not always equal row for row. A clearing reconciliation needs to explain:

eligible trades ± corrections, cancellations, and approved netting = cleared obligations

The rule must use the same clearing account, instrument, currency, settlement date, and netting scope. A net result cannot justify an unexplained missing trade. Operations should retain the link from the obligation back to its contributing trades.

Clearing controls also examine rejected trades, unmatched instructions, amended details, novated obligations where applicable, and cutoff failures. A trade omitted before clearing may later become a settlement failure even though the original execution is valid.

Settlement Is Not Universal

#

Settlement completes delivery and payment under the rules applicable to the instrument and market. Delivery versus payment (DvP) describes arrangements designed to link securities delivery with the corresponding payment so that one occurs if the other occurs according to the model’s rules. Not every transfer uses the same DvP model, and some movements are free of payment.

There is no universal settlement cycle for all capital markets. Settlement timing can depend on jurisdiction, venue, instrument, transaction type, currency, holiday calendar, and negotiated terms. Some markets use a standard number of business days after trade date; others support same-day, longer, or explicitly agreed settlement. Rules can also change.

For that reason, a reconciliation system should derive the expected settlement date from governed trade terms and applicable calendars. It should not hard-code one cycle as a global truth.

Settlement reconciliation compares the cleared or bilateral obligation with settlement instructions, depository or custodian movements, and cash movements. It should test:

• Security, quantity, account, and movement direction
• Cash amount, currency, and payment account
• Intended and actual settlement dates
• Counterparty and place of settlement
• Partial settlement and remaining quantity
• Instruction status, rejection reason, and repair history
• Fees, interest, claims, or penalties where applicable

A Failed-Settlement Example

#

Return to the purchase of 10,000 shares for $250,040 before charges. Assume that the parties’ governed terms specify settlement on the stated date. Only 8,000 shares settle, representing gross consideration of $200,032 at the trade’s weighted average price for this simplified example:

8,000 × $25.004 = $200,032

The remaining obligation is:

10,000 - 8,000 = 2,000 shares

and its simplified gross consideration is:

2,000 × $25.004 = $50,008

A failed settlement occurs when securities or cash are not delivered as required by the agreed obligation and applicable process. The cause might be insufficient securities, insufficient cash, incorrect instructions, mismatched details, a missed cutoff, an account restriction, or an upstream processing error.

The reconciliation should not mark the entire trade settled or leave the entire trade open. It should record 8,000 settled shares, 2,000 failed shares, the related cash treatment, cause, age, owner, expected next action, and downstream effects. Any later completion, cancellation, buy-in, compensation, or other remedy depends on the governing agreement and market rules.

Observation: Settlement status can apply to quantities and components, not only to the whole trade.

Concept: A failed-settlement control preserves the original obligation, completed movement, residual exposure, and resolution evidence separately.

Custody and Position Reconciliation

#

A custodian records securities held or administered through custody accounts. An investment manager or broker maintains its own internal positions. A depository or another subcustodian may provide further independent records. These sources can use different account structures and timestamps.

Position reconciliation starts by defining the position basis:

• Traded position includes executed trades according to the firm’s policy.
• Settled position includes completed securities movements.
• Available position considers holdings that can currently be delivered or used, subject to holds and market rules.
• Economic or beneficial position may reflect ownership rights under applicable agreements even when operational settlement is pending.

These measures should not be compared without adjustment. A simple settled-position roll-forward is:

opening settled position + settled receipts - settled deliveries ± other settled movements = closing settled position

Other movements can include transfers, corporate actions, conversions, and approved corrections. Pending trades belong in a bridge between traded and settled positions rather than being silently forced into custody.

In the opening story, the internal traded position includes 10,000 purchased shares, while the custody increase is 8,000. The 2,000-share difference is explained only if it maps to the failed settlement. An unexplained difference of the same size is a break even though the totals happen to resemble the known failure.

Position controls should compare account, instrument, quantity, status, location, and date. Cash and transaction reconciliations complement the position comparison because two missing movements can offset and leave the closing quantity unchanged.

Margin Reconciliation

#

Margin is collateral or financial resources required to cover exposure under trading, clearing, financing, or risk arrangements. The exact calculation and terminology depend on the agreement and market. Margin can include cash or eligible securities, and requirements may change as positions, prices, volatility, concentration, or other risk inputs change.

Margin reconciliation links:

• Positions and transactions used in the exposure calculation
• Prices, foreign-exchange rates, and risk parameters
• Required margin by account and currency
• Calls, substitutions, and returns
• Collateral delivered, received, held, and valued
• Eligibility, valuation adjustments, and concentration rules
• Cash, custody, clearing, and general-ledger records

Suppose a clearing record requires $1.2 million of margin, while an internal system shows $1.0 million. The $200,000 difference is not resolved by observing that $1.0 million was paid. Teams must compare the underlying positions, prices, parameters, collateral already recognized, and cutoff. The external requirement might contain a new trade missing internally, or the external file might use a later valuation point.

An amount within available liquidity can still be a material break because it may reveal missing exposure. Conversely, different values can be legitimate if the systems use documented purposes and valuation times. The bridge must make those differences explicit.

Corporate-Action Reconciliation

#

A corporate action is an event initiated by an issuer or arising under a security’s terms that changes holders’ rights, cash, securities, or reference data. Examples include dividends, interest payments, splits, redemptions, mergers, and elections.

The record date is the date used under the event’s governing terms and market process to determine the holders relevant to an entitlement. Eligibility cannot always be inferred from a current position alone. Trades, settlement status, market conventions, and claim processes may affect who ultimately receives the economic benefit.

Consider a cash dividend of $0.40 per eligible share. A custody record shows 12,000 eligible shares at the relevant record-date snapshot:

12,000 × $0.40 = $4,800 gross entitlement

An internal system uses today’s 10,000-share position and calculates $4,000. Both quantities may be accurate for their dates, but only the governed eligible position supports the event calculation. The $800 difference is:

$4,800 - $4,000 = $800

Corporate-action reconciliation should compare announcement terms, event identifiers, eligible positions, elections, rates, currencies, tax treatment, cash or security entitlements, actual receipts, allocations to clients, and accounting. Revised announcements need version control. A correct total received can still be allocated to the wrong funds.

Observation: A position can be correct today and wrong for a historical entitlement calculation.

Concept: Corporate-action reconciliation combines event terms with the position and eligibility basis required for that event.

Securities-Lending Reconciliation

#

Securities lending is a transaction in which securities are transferred to a borrower under an agreement requiring the return of equivalent securities, usually against collateral and a fee. Legal form, title transfer, collateral, income treatment, and recall mechanics depend on the agreement and jurisdiction.

The lender’s custody account may show securities delivered out, while its economic records retain a loan receivable for equivalent securities. The borrower may use or deliver the borrowed securities. Therefore, custody quantity alone does not describe the complete exposure.

Reconciliation should connect loan instructions, securities delivered and returned, open loan quantities, collateral, valuations, margin calls, fees, recalls, and substitute payments related to income events. It should distinguish:

owned securities held in custody

from

securities on loan and contractually due back

If 5,000 shares are lent and 2,000 are returned, the open loan is 3,000 shares. The reduction in physical custody is not a sale, and the remaining loan is not a settled custody position. Position reporting needs a transparent bridge among legal ownership, custody location, availability, and lending exposure.

Corporate actions add complexity. If a dividend occurs while securities are on loan, contractual and market processes may create a substitute or manufactured payment. The reconciliation must not count both the issuer distribution and the substitute payment as ordinary dividend income for the same entitlement.

Expected Timing and Genuine Breaks

#

Capital-markets records are produced at different lifecycle stages and cutoffs. An execution received before a scheduled broker confirmation, a matched instruction awaiting its settlement date, or a custody file awaiting its normal delivery window can be expected timing.

Timing is an explanation only when it has a specific source, start event, applicable calendar, cutoff, maximum age, owner, and evidence. An item becomes an exception when the approved window expires or its expected relationship fails.

Genuine breaks include unauthorized executions, missing or duplicate fills, wrong allocations, unmatched confirmations, rejected settlement instructions, unexplained partial settlement, cash or securities delivered to the wrong account, position differences without mapped pending activity, incorrect margin inputs, and corporate-action entitlements built from the wrong record-date position.

Operations should prioritize by more than amount. A zero-value security movement can alter voting or ownership records. A small position break can create an uncovered sale. A failed settlement can affect a client, liquidity, contractual obligations, and market reporting.

Resolution and Audit Evidence

#

Resolution must correct every affected representation. Repairing a settlement instruction may require changes to expected cash, position bridges, funding forecasts, client records, fees, claims, and accounting. A manual journal alone does not settle securities, and a custody adjustment alone does not prove the original trade terms.

The audit trail should retain source records, normalized identifiers, match rules, clearing and settlement statuses, original and corrected instructions, position snapshots, approvals, user actions, rerun results, and final evidence. Historical states must remain reconstructable.

Root-cause analysis turns exceptions into prevention. Repeated allocation breaks may indicate stale account reference data. Recurring settlement failures may reveal inventory or instruction problems. Corporate-action differences may expose incorrect position dates. The goal is not merely to close today’s queue but to reduce tomorrow’s uncertainty.

Chapter Summary

#

Capital-markets reconciliation follows a securities transaction from execution and confirmation through clearing, settlement, custody, and subsequent events. Each stage records a different fact: agreement, obligation, completed movement, safekeeping, exposure, or entitlement.

Trade controls preserve orders, fills, allocations, and charges. Clearing controls explain obligations and netting. Settlement controls connect securities and cash without assuming one universal cycle. Position controls distinguish traded, settled, available, and economic views. Margin, corporate actions, and securities lending introduce additional relationships that cannot be inferred from one closing quantity.

Key Takeaways

#

• Execution, clearing, settlement, custody, and position are distinct concepts.
• One order may have several fills, and one block trade may have several allocations.
• Aggregate agreement can conceal account-level allocation errors.
• Clearing obligations may differ from trade rows because of governed netting and corrections.
• Settlement cycles vary by market, instrument, transaction, and agreed terms.
• Partial settlement requires separate completed and failed quantities and cash treatment.
• Position reconciliation must state whether positions are traded, settled, available, or economic.
• Margin reconciliation tests requirements, collateral, valuations, and underlying risk inputs.
• Corporate-action entitlement depends on event terms and the relevant position basis, including record date.
• Securities on loan require a bridge among custody, ownership, collateral, and the obligation to return equivalent securities.
• Expected timing needs a defined window, owner, evidence, and escalation.
• Resolution must address every downstream representation and preserve an auditable history.

Previous: Part 6 — Lending Reconciliation · Series landing page · Next: Part 8 — Asset Management Reconciliation