Reconciliation

Reconciliation

Core Concepts

1. Reconciliation Types and Hierarchy

Reconciliation is the systematic comparison of records across two or more systems to identify and resolve discrepancies. In securities operations, reconciliation ensures that the firm's internal records (the investment book of record, or IBOR) match the custodian's official records (the official book of record, or OBOR) and, where applicable, the clearing firm's records. The reconciliation hierarchy proceeds from the most fundamental data element (positions) through increasingly derived data elements.

Position Reconciliation. The foundational reconciliation. Compares the number of shares or units held for each security in each account between the firm's portfolio management system (PMS) and the custodian. Position reconciliation is typically zero-tolerance: any share count difference, no matter how small, constitutes a break. Fractional share differences (common with dividend reinvestment plans) must also be identified and resolved. Position reconciliation is performed daily, using end-of-day files from the custodian compared against the PMS position ledger.

Cash Reconciliation. Compares cash balances between the PMS and the custodian, accounting for settled cash, pending settlements, accrued income, and pending fee debits. Cash reconciliation is more nuanced than position reconciliation because timing differences are inherent — a trade executed on day T settles on T+1, and the PMS and custodian may record the cash impact on different dates. Cash tolerance thresholds are common, typically a small dollar amount (e.g., $0.50 to $5.00) to accommodate rounding differences across systems. Balances outside the tolerance require investigation.

Transaction Reconciliation. Compares individual transactions (trades, dividends, interest payments, transfers, fees) recorded in the PMS against the custodian's transaction ledger. Transaction reconciliation operates at the trade level, matching on security, quantity, price, trade date, and settlement date. Unmatched transactions on either side constitute breaks. Transaction reconciliation is typically performed on a T+1 basis — comparing yesterday's activity after the custodian's end-of-day file is received.

Market Value Reconciliation. Compares the total market value of each position and each account between systems. Market value breaks often result from pricing differences — the PMS and custodian may source prices from different vendors or apply different pricing hierarchies for thinly traded or illiquid securities. Market value tolerance is typically expressed in basis points (e.g., 5-10 bps of account value) rather than absolute dollars, because a $100 difference on a $50,000 account is more significant than a $100 difference on a $5,000,000 account.

Accrued Income Reconciliation. Compares accrued interest on fixed-income holdings and declared-but-unpaid dividends. Accrued income differences frequently arise from day-count convention differences (actual/actual vs. 30/360), ex-date vs. record-date timing, or different treatment of defaulted bonds. This reconciliation is particularly important for fixed-income-heavy portfolios where accrued income is a material component of total value.

Cost Basis Reconciliation. Compares the tax lot-level cost basis for each position between the PMS and the custodian. Cost basis discrepancies are among the most difficult to resolve because they may originate from historical corporate actions (splits, mergers, spin-offs, return of capital adjustments) that were processed differently in each system. Since the custodian reports cost basis to the IRS on Form 1099-B, cost basis discrepancies can result in incorrect tax reporting if not resolved. Cost basis reconciliation is typically performed less frequently than position reconciliation — monthly or quarterly — but with zero tolerance for discrepancies.

2. Three-Way Reconciliation

For advisory firms that use a portfolio management system separate from both the custodian and any clearing firm, three-way reconciliation is the standard of practice. The three records being compared are:

Advisor System (PMS / Portfolio Accounting). The firm's investment book of record (IBOR), maintained in the portfolio management system (Orion, Black Diamond, Tamarac, Addepar, or similar). This is the record the firm uses for performance reporting, billing, rebalancing, and client-facing communications. The advisor system reflects the firm's understanding of what each client owns.

Custodian Records. The official book of record (OBOR), maintained by the custodian (Schwab, Fidelity, Pershing, or similar). This is the legally authoritative record of client assets. The custodian is responsible for safekeeping assets, settling transactions, and reporting to the IRS. When the advisor system and custodian disagree, the custodian record is presumed correct unless the firm can demonstrate otherwise.

Clearing Firm Records. For firms that clear through a separate entity (introducing broker-dealers that clear through a correspondent clearing firm), the clearing firm maintains its own record of positions and transactions. The clearing firm processes settlements, maintains margin calculations, and generates customer statements. In a fully disclosed arrangement, the clearing firm's records should match the custodian's, but discrepancies can arise from timing, corporate action processing, or data feed errors.

Authoritative Source by Data Element. Different systems serve as the authoritative source for different data elements:

| Data Element | Authoritative Source | Reason | |---|---|---| | Share/unit count | Custodian | Custodian holds the securities in legal custody | | Settled cash balance | Custodian | Custodian controls the cash account | | Trade execution details | Executing broker / custodian | Trade occurred on their platform | | Cost basis (for tax reporting) | Custodian | Custodian reports 1099-B to IRS | | Performance returns | Advisor system (PMS) | PMS maintains the calculation methodology | | Model assignment and drift | Advisor system (PMS) | PMS manages the investment process | | Fee schedule and billing | Advisor system (PMS) | PMS calculates fees per advisory agreement | | Corporate action elections | Custodian | Custodian processes the action |

Reconciliation Frequency. The standard frequencies are:

• Position reconciliation: daily (end of each business day)
• Cash reconciliation: daily
• Transaction reconciliation: T+1 (one business day after the trade or event)
• Market value reconciliation: daily
• Accrued income reconciliation: daily or weekly, depending on portfolio composition
• Cost basis reconciliation: monthly or quarterly

3. Break Identification

A break is any discrepancy identified during reconciliation between two or more records. Break identification is the process of detecting, classifying, and prioritizing breaks for investigation and resolution.

Tolerance Thresholds. Not all discrepancies warrant investigation. Tolerance thresholds define the minimum discrepancy that constitutes a reportable break:

| Reconciliation Type | Typical Tolerance | Rationale | |---|---|---| | Position (shares/units) | Zero (exact match required) | Any share difference indicates a missing or erroneous transaction | | Cash balance | $0.50 - $5.00 | Small rounding differences across systems are expected | | Market value | 5-10 bps of account value | Pricing source differences create small value discrepancies | | Accrued income | $0.01 - $1.00 | Day-count and rounding conventions vary across systems | | Cost basis | Zero (exact match required) | Any basis difference affects tax reporting accuracy | | Transaction matching | Exact match on key fields | Unmatched transactions require investigation |

Break Categorization. Breaks are classified by root cause to enable pattern analysis and systemic remediation:

• Timing differences. The most common category. Arise when the PMS and custodian record the same event on different dates. Examples: a trade executed late in the day may appear in the PMS on trade date but in the custodian file the following day; a dividend may post in the custodian on the pay date but in the PMS on the record date. Timing breaks typically self-resolve within one to two business days.
• Pricing differences. Occur when the PMS and custodian use different pricing sources or apply different pricing hierarchies. Most common for fixed-income securities, international equities (with exchange rate differences), and illiquid or thinly traded securities.
• Corporate action differences. Arise when a corporate action (stock split, merger, spin-off, dividend reinvestment) is processed in one system but not the other, or processed with different terms (different exchange ratio, different effective date). Corporate actions are the single largest cause of position breaks that do not self-resolve.
• Missing transactions. A transaction appears in one system but not the other. Common causes: a trade placed directly at the custodian without going through the PMS, a manual journal entry in one system, or a data feed failure that dropped a transaction.
• Duplicate transactions. The same transaction is recorded twice in one system. Can result from data feed reprocessing, manual entry combined with automated feed, or system errors during corporate action processing.
• Data quality issues. Security identifiers do not match across systems (CUSIP changes, ticker symbol changes), account numbers are mapped incorrectly, or data feed parsing errors corrupt field values.

Break Severity Levels. Breaks are prioritized based on their operational impact:

• Critical (must resolve same day). Position breaks affecting client-facing reporting or imminent billing, cash breaks exceeding a material threshold (e.g., $10,000), and any break that would affect a trade if left unresolved.
• High (must resolve within two business days). Position breaks on any actively traded security, market value breaks exceeding the tolerance, and unmatched transactions from the prior day.
• Medium (must resolve within five business days). Accrued income differences, cost basis discrepancies identified in periodic reconciliation, and pricing breaks on less liquid securities.
• Low (resolve within the current monthly cycle). Minor rounding differences within tolerance, known timing differences expected to self-resolve, and informational discrepancies that do not affect reporting or billing.

4. Break Resolution Workflows

Once a break is identified and categorized, it enters a structured resolution workflow. Effective break resolution combines investigative rigor with operational efficiency.

Investigation Procedures. The standard investigation sequence for a position break is:

1. Verify the break is not a known timing difference by checking pending transactions and unsettled activity in both systems.
2. Review the transaction history for the affected security in both the PMS and custodian to identify the divergence point — the first date on which the records disagree.
3. Check for unprocessed corporate actions by reviewing the corporate action calendar for the security and confirming that all mandatory actions have been applied in both systems.
4. Check for missing or duplicate trades by comparing the trade blotter in the PMS against the custodian's trade confirmation file for the relevant dates.
5. Verify security identifier mapping — confirm that the CUSIP, ISIN, or ticker symbol in the PMS maps correctly to the custodian's security master.
6. If the cause remains unidentified, submit a custodian inquiry requesting the custodian's transaction history for the security and account over the period in question.

Common Break Causes and Resolutions.

| Break Cause | Resolution | |---|---| | Unprocessed stock split | Apply the split in the PMS (adjust shares and cost basis) | | Missed dividend reinvestment | Add the reinvestment transaction in the PMS | | Trade placed directly at custodian | Enter the trade retroactively in the PMS | | Data feed failure (dropped transaction) | Re-import the affected date's custodian file | | Duplicate trade entry | Remove the duplicate from the PMS | | CUSIP change (corporate action) | Update the security mapping in the PMS | | Pricing difference | Update the PMS pricing source or override the price | | Cash posting timing | Confirm the break self-resolves the following day; mark as timing |

Break Aging and Escalation. Unresolved breaks must be tracked by age. The aging clock starts on the date the break is first identified. Escalation rules ensure that aging breaks receive management attention:

• 0-2 business days: Operations analyst investigates and resolves.
• 3-5 business days: Escalate to operations supervisor. Supervisor reviews investigation notes and may reassign or provide guidance.
• 6-10 business days: Escalate to operations manager. A written explanation is required for why the break remains open.
• Over 10 business days: Escalate to the chief operations officer or chief compliance officer. Breaks of this age may indicate a systemic issue requiring vendor engagement or system changes.

Resolution Documentation. Every resolved break must be documented with: the date the break was identified, the break category, the root cause determination, the corrective action taken, the system in which the correction was made, the date of resolution, and the identity of the person who resolved it. This documentation forms part of the firm's books and records and is subject to regulatory examination.

Recurring Break Pattern Analysis. Operations teams should review break data periodically (weekly or monthly) to identify recurring patterns. If the same type of break occurs repeatedly for the same security, account, or data feed, the root cause is likely systemic rather than transactional. Systemic causes require process or system changes, not repeated manual corrections. Examples of systemic patterns: a particular custodian feed consistently drops fractional shares, a specific security type (e.g., foreign ordinaries) always has pricing breaks, or corporate actions for a particular issuer are consistently delayed.

5. Reconciliation Automation

Manual reconciliation — comparing records by hand in spreadsheets — is error-prone, time-consuming, and does not scale. Reconciliation automation reduces manual effort, increases accuracy, and enables exception-based processing where human attention is directed only to genuine breaks.

Automated Matching Engines. Reconciliation software compares records from two or more sources using configurable matching rules. The matching engine ingests data files from each source, normalizes the data into a common format, applies matching rules to pair records, and flags unmatched or out-of-tolerance items as exceptions.

Rule-Based Auto-Resolution. Beyond matching, advanced reconciliation systems can automatically resolve certain categories of breaks without human intervention:

• Timing breaks that match a known pattern (e.g., a transaction appears in the custodian file one day after it appears in the PMS) can be auto-resolved if the offsetting entry appears within a defined window.
• Rounding differences within tolerance can be auto-resolved and logged.
• Known pricing source differences for specific security types can be auto-resolved with the custodian price accepted as authoritative.

Auto-resolution rules must be carefully designed and regularly audited to ensure they are not masking genuine breaks. Each auto-resolved item should be logged for review.

Exception-Based Processing. The operational model for a mature reconciliation program is exception-based: the automated system handles the matching and auto-resolution of routine items, and human anal

…

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: JoelLewis
• Source: JoelLewis/finance_skills
• License: MIT

Install and usage instructions live in the source repository linked above.