Managing Middle Office Operations

Managing Middle Office Operations

Structures middle office functions with trade matching, position reconciliation, and P&L verification.

When To Use

• Standing up or restructuring a fund's middle office function (trade support, portfolio accounting, risk oversight)
• Investigating trade breaks, position mismatches, or NAV discrepancies
• Building or reviewing daily/monthly reconciliation workflows across custodians, prime brokers, and fund administrators
• Verifying realized and unrealized P&L calculations against official books and records
• Preparing middle office status reports for portfolio managers, COOs, or compliance

Inputs To Gather

• Trade blotter / OMS extract — executed trades for the period with order IDs, counterparties, quantities, prices, commissions, and settlement dates
• Custodian/PB position statements — end-of-day or end-of-period holdings from each custodian or prime broker
• Internal portfolio accounting records — positions and cash balances from the fund's book-of-record system
• Corporate action notices — dividends, splits, mergers, tender offers affecting held positions
• Pricing sources — vendor feeds (Bloomberg, Refinitiv) and any override/fair-value marks from the valuation committee
• Prior reconciliation exception log — outstanding breaks carried forward from the last cycle
• Fund governing documents — LPA/OA provisions on valuation methodology, fee waterfalls, and reporting obligations [VERIFY fund-specific terms]

Workflow

1. Trade Capture & Matching

• Import trade blotter from OMS; match each trade against broker confirmations on trade date (T+0)
• Confirm economic terms: security identifier (CUSIP/ISIN/SEDOL), side, quantity, price, currency, settlement date, commission/fees
• Flag unmatched or partially matched trades as breaks; classify by type (price break, quantity break, missing confirmation)
• Escalate unresolved breaks older than T+1 for listed securities or T+2 for OTC/derivatives [VERIFY settlement conventions by asset class and jurisdiction]

2. Position Reconciliation

• Pull end-of-day positions from (a) internal books, (b) custodian/PB statements, and (c) fund administrator records
• Run three-way reconciliation: internal vs. custodian vs. administrator
• Identify quantity breaks, settlement-date vs. trade-date differences, and pending-settlement items
• Reconcile cash balances including accrued interest, margin balances, and collateral postings
• Document each break with root cause (failed settlement, late booking, corporate action timing, FX conversion)
• Resolve or age breaks per the fund's tolerance thresholds (e.g., <$100 auto-clear, >$100 requires sign-off) [VERIFY materiality thresholds]

3. Corporate Action Processing

• Monitor announced corporate actions for all held positions; cross-reference against custodian/PB notifications
• Classify as mandatory (dividends, splits) or voluntary (tenders, rights offerings) and route voluntary actions for PM decision by election deadline
• Verify ex-date, record-date, and pay-date processing in the portfolio accounting system
• Confirm post-action position and cost-basis adjustments

4. P&L Verification

• Calculate daily/period P&L by component: realized gains/losses, unrealized mark-to-market, income (dividends, interest, premiums), and financing costs
• Cross-check pricing inputs against approved sources; flag stale prices (>1 day old for liquid securities, >5 days for illiquid) [VERIFY staleness policy]
• Reconcile P&L between the internal system and the fund administrator's independent calculation
• Investigate material variances (typically >0.5 bps of NAV); trace to specific positions or pricing differences [VERIFY variance tolerance]
• Verify FX rate sources and conversion timing for multi-currency portfolios

5. Exception Management & Reporting

• Maintain an exception log with: break ID, date identified, asset/account, break amount, root cause, owner, aging, resolution status
• Produce daily middle office dashboard showing: trade match rate, open position breaks by age bucket, P&L variance summary, pending corporate actions
• Escalate aged or material exceptions per defined SLA (e.g., >3 days unresolved → ops manager, >5 days → COO) [VERIFY escalation matrix]
• Prepare month-end summary for inclusion in the fund administrator's NAV package

Output

The deliverable is a Middle Office Status Report containing:

• Trade matching summary — match rate, open breaks with aging, resolution notes
• Position reconciliation results — three-way recon status by account, outstanding breaks with root cause
• P&L reconciliation — internal vs. administrator P&L, variance analysis by position and component
• Corporate action log — actions processed, elections made, pending items
• Exception dashboard — all open items, owners, SLA status, escalation flags
• Recommendations — process improvements, system issues, staffing or workflow adjustments

Quality Checks

• Every trade in the blotter has a corresponding broker confirmation or is flagged as an open break
• Three-way position recon covers 100% of accounts; no account is silently excluded
• P&L variance between internal books and administrator is within the fund's stated tolerance [VERIFY]
• All voluntary corporate actions have documented PM elections before the deadline
• Stale or overridden prices are individually justified and approved per the valuation policy
• Exception log has no items missing an assigned owner or aging date
• Report terminology is consistent (e.g., "break" vs. "discrepancy" — pick one and use throughout)
• All dollar amounts and share counts tie back to source extracts; no manual hardcodes without audit trail