Investment reconciliation is the control process used to prove that an investment manager's or fund's positions, trades, cash, income, fees, corporate actions, and valuations agree with the records held by custodians, prime brokers, fund administrators, counterparties, and internal accounting systems. It is not a single balance comparison. It is a connected set of reconciliations that supports accurate books, reliable exposure data, and the evidence used in NAV production and review.
In a hedge-fund environment, the same process must also account for short positions, margin, collateral, financing, derivatives, multiple prime brokers, and different valuation sources. That makes source ownership, cutoff, instrument identity, and exception evidence as important as the arithmetic difference.
Investment, fund, and hedge-fund reconciliation
These terms overlap, but they describe different operating perspectives. Investment reconciliation is the broad control discipline. Fund reconciliation applies it to a fund's books, counterparties, and reporting cycle. Hedge-fund reconciliation adds the operational complexity of prime-broker relationships, financing, short inventory, collateral, derivatives, and strategy-specific records. The underlying principle is the same: compare controlled populations, explain every difference, and retain evidence of resolution and review.
| Reconciliation layer | Records compared | Control objective |
|---|---|---|
| Positions | OMS/PMS or accounting book against custodian, prime broker, or administrator holdings | Prove quantity, instrument, account, and long/short direction |
| Trades | Executed orders and internal bookings against broker confirmations and settlement records | Identify missing, duplicated, misbooked, or unsettled trades |
| Cash | Internal cash ledgers against bank, custodian, and prime-broker balances and movements | Prove available cash, margin movements, income, fees, and settlement activity |
| Corporate actions | Entitlement calculations against announcements and counterparty postings | Confirm elections, quantities, rates, dates, and resulting cash or securities |
| Income and expenses | Accrual schedules against counterparty postings, contracts, and invoices | Support interest, dividends, financing, management fees, and operating expenses |
| Valuation | Internal or administrator marks against approved market, counterparty, or model sources | Identify price, FX, methodology, stale-price, and source differences |
| NAV | Manager or shadow books against the administrator's NAV package and component balances | Explain the final difference through supported component-level analysis |
Source-system matching matrix
A reliable process starts by defining which source is authoritative for each field and event. Treating one file as authoritative for everything can hide upstream errors or compare records that use different accounting bases.
| Source | Typical records | Key fields to control | Common limitation |
|---|---|---|---|
| OMS or EMS | Orders, executions, allocations, and trade status | Trade ID, instrument, side, quantity, price, trade date, broker, allocation | May not reflect final settlement or accounting adjustments |
| PMS or investment book of record | Positions, transactions, cash, exposure, and P&L | Portfolio, instrument, units, cost, local/base currency, valuation date | Depends on complete and timely upstream feeds |
| Prime broker | Positions, short inventory, cash, margin, financing, and settlements | Account, identifier, long/short, quantity, currency, collateral, settlement status | Different primes may use different identifiers and cutoff times |
| Custodian | Safekept positions, cash, income, and corporate actions | Account, security ID, settled quantity, value date, entitlement, cash movement | Pending trades and local-market updates can arrive later |
| Fund administrator | Accounting book, accruals, valuations, capital activity, and NAV | Fund, class, ledger account, instrument, price, FX rate, accrual, NAV date | Differences may reflect policy or timing rather than source error |
| Market or valuation source | Prices, curves, FX, reference data, and corporate actions | Source, timestamp, market, method, hierarchy, stale-price status | Multiple valid sources can produce different marks |
End-to-end investment reconciliation workflow
- Define scope and cutoff. Fix the fund, account, portfolio, valuation date, accounting basis, time zone, currency basis, source hierarchy, and responsible preparer and reviewer.
- Control the populations. Obtain final or clearly versioned extracts and retain report parameters, timestamps, record counts, control totals, and file provenance.
- Normalize reference data. Map internal and external account codes, security identifiers, currencies, transaction types, and long/short conventions without overwriting the original values.
- Match at the appropriate level. Compare summary balances and transaction-level records using rules appropriate to the asset class, event, and settlement lifecycle.
- Classify exceptions. Separate valid timing differences from missing records, booking errors, identifier problems, valuation differences, fee or accrual issues, and unexplained items.
- Investigate against evidence. Trace each break to the trade, confirmation, statement, notice, contract, market source, journal, or source-system record that explains it.
- Resolve through the controlled owner. Correct the system or party responsible for the error. Avoid plugs or unsupported manual overrides that only force totals to agree.
- Re-run and certify. Confirm the correction is reflected in the final population, age valid open items, record subsequent clearing evidence, and retain preparer and reviewer sign-off.
Hedge-fund reconciliation workflow
A hedge-fund cycle usually begins with the manager's transaction and position records, then expands to each prime broker, custodian, administrator, bank, and material counterparty. The operating sequence should follow the dependencies between records rather than treating every comparison as an isolated spreadsheet.
- Confirm trade completeness. Compare executions, allocations, cancellations, amendments, and broker confirmations before relying on the resulting positions.
- Reconcile settled and pending positions. Distinguish trade-date from settlement-date views and separate pending activity from true quantity differences.
- Reconcile cash, margin, and collateral. Tie cash movements to settlements, financing, fees, variation margin, collateral calls, subscriptions, and redemptions.
- Validate short inventory and financing. Compare borrowed quantities, recalls, borrow rates, financing charges, and associated cash or collateral entries.
- Review derivatives and valuations. Align contract identifiers, notional, units, reset terms, price sources, curves, FX, and valuation timestamps.
- Clear income and corporate actions. Confirm ex-date and record-date positions, elections, tax treatment, entitlement rates, and resulting cash or securities.
- Connect resolved records to NAV. Reconcile positions, cash, prices, FX, accruals, fees, and capital activity before reviewing any remaining NAV difference.
NAV reconciliation control sequence
NAV reconciliation should be the result of completed component controls, not the first place unexplained differences are investigated. A top-level NAV variance can be caused by a position, trade, price, FX rate, cash movement, accrual, fee, capital event, or classification difference.
| Sequence | Control | Evidence retained |
|---|---|---|
| 1 | Confirm the same fund, class, valuation date, cutoff, and accounting basis | NAV-package version, report parameters, calendar, and source timestamps |
| 2 | Clear material position and transaction differences | Position and trade reconciliations with open-item disposition |
| 3 | Clear cash, income, financing, fee, and capital-activity differences | Cash reconciliations, accrual schedules, notices, invoices, and investor records |
| 4 | Compare prices, FX rates, valuation sources, and methodology | Approved pricing hierarchy, source snapshots, overrides, and valuation review |
| 5 | Bridge the remaining NAV difference by component | Manager-to-administrator NAV bridge with owner and resolution for each item |
| 6 | Review, approve, and retain the final package | Certification, reviewer comments, escalation, and later clearing evidence |
Investment reconciliation exception taxonomy
| Exception class | Typical cause | Investigation route |
|---|---|---|
| Timing or cutoff | Different file times, trade-date/settlement-date views, late postings, or market-calendar differences | Compare timestamps, status, expected clearing event, and subsequent files |
| Missing or duplicate record | Failed interface, unbooked trade, duplicate load, allocation failure, or cancellation not reflected | Trace source IDs and lifecycle events across the originating and receiving systems |
| Reference-data mismatch | Security, account, strategy, book, currency, or transaction-type mapping difference | Compare original identifiers and controlled mapping tables before rematching |
| Quantity or direction | Incorrect units, split treatment, long/short sign, contract multiplier, or corporate action | Inspect trade history, instrument terms, event notices, and position roll-forward |
| Cash or settlement | Failed settlement, value-date difference, fee, tax, margin, or unmatched cash movement | Trace settlement status, bank or broker movement, and accounting entry |
| Valuation or FX | Different source, timestamp, methodology, curve, stale price, or currency conversion | Apply the approved hierarchy and document any authorized override |
| Income, fee, or accrual | Rate, basis, day count, invoice, financing, or recognition-period difference | Recalculate from the governing contract, notice, source balance, and policy |
| Unexplained | Cause not yet supported | Escalate with owner, age, materiality, next action, and explicit reviewer disposition |
Evidence checklist for a reviewable reconciliation
- Defined fund, portfolio, account, period, valuation date, cutoff, time zone, and currency basis.
- Controlled source files with timestamps, parameters, record counts, totals, and version history.
- Original identifiers alongside normalized mappings and documented rule changes.
- Matching result showing matched, partially matched, and unmatched populations.
- Exception record with amount or quantity, cause, evidence, owner, age, action, and due date.
- Approved correction or source-system remediation linked to the originating break.
- Proof that valid timing items subsequently cleared and that corrections appeared in the final books.
- Preparer certification, independent review, comments, escalation, and reopening history.
Who owns the control?
The investment manager, fund administrator, custodian, and prime broker maintain different records and responsibilities. Reconciliation does not transfer policy ownership from the fund or manager. The operating model should state who prepares each comparison, who corrects each source, who approves valuation and accounting judgments, who reviews aged items, and who signs off the final NAV package.
Aetherix can run the controlled data collection, normalization, matching, exception investigation, evidence assembly, and follow-up workflow. Authorized client and administrator owners retain decisions over accounting policy, valuation approval, materiality, posting, and final certification.
Related investment controls
Use the dedicated guides for deeper treatment of position reconciliation, trade reconciliation, and cash reconciliation. For service scope, see reconciliation operations for investment managers and fund administrators, or review family-office reconciliation services.
Frequently asked questions
What is hedge-fund reconciliation?
Hedge-fund reconciliation is the comparison of the fund's internal trades, positions, cash, margin, collateral, financing, valuations, income, fees, and corporate actions with records from prime brokers, custodians, administrators, banks, and counterparties. Differences must be explained, resolved, and retained for review.
How is fund reconciliation different from NAV reconciliation?
Fund reconciliation covers the underlying books and records across positions, trades, cash, valuations, accruals, fees, and capital activity. NAV reconciliation compares the resulting manager or shadow NAV with the administrator's NAV and explains the remaining difference by component.
Should positions be reconciled before NAV?
Yes. Material position, transaction, cash, valuation, and accrual differences should be investigated before the final NAV bridge. Otherwise the NAV variance becomes a summary of unresolved upstream breaks rather than an effective control.
Can the investment manager and fund administrator both reconcile?
Yes. Their reconciliations can be complementary because they maintain different books and control responsibilities. The operating model should define the independent sources, responsibilities, escalation route, and final approval for each control.
What evidence should be retained for a reconciliation break?
Retain the affected source records, identifiers, amount or quantity, cause, investigation evidence, owner, age, action, approval, correction or expected clearing event, and proof of final resolution.