Why Fund Reconciliation Matters
Fund reconciliation is one of the most critical recurring processes in private markets. It is the backbone of NAV accuracy, investor reporting, audit readiness, fee calculations, and compliance.
Yet despite its importance, reconciliation is still one of the most manual and time-consuming workflows for fund administrators and accounting teams.
This guide is designed to serve as the industry reference, covering:
- What fund reconciliation is
- Why it matters
- The complete “Reconciliation Rulebook”
- Break classification
- Step-by-step examples
- Templates (including cross-system mapping to Investran, Archway, QuickBooks, Allvue, and DwellFi)
- How automation changes the workflow
Fund reconciliation is the process of matching internal fund accounting records with external third-party statements to ensure all balances, transactions, positions, and valuations agree.
Reconciliation verifies that:
- Every cash movement is captured
- All positions and quantities match
- All investment activity is correctly posted
- Accruals are accurate
- FX conversions follow policy
- The GL reflects reality
In simple terms:
Reconciliation proves that the fund’s books are correct. If the books don’t reconcile, the NAV, PCAP, and investor statements can’t be trusted.
Why Reconciliation Is Essential in Private Markets
Reconciliation impacts every core reporting workflow:
- NAV production
- PCAP (partner capital account) statements
- Waterfall and carry calculations
- Fee calculations
- Financial statements
- Yearly audit requests
- LP reporting
- Regulatory filings
Errors caught late cascade into:
- Audit findings
- Restatements
- Incorrect LP allocations
- Misstated fees
- Delayed reporting
- Operational risk
This is why reconciliation is considered a core internal control by auditors, regulators, and LPs.
The Fund Reconciliation Rulebook
Every fund administrator uses an internal reconciliation rulebook, even if undocumented.
1.1 Matching Logic Rules
These rules determine how internal and external data must match.
Cash Matching Rules
- Match by amount
- Match by value date
- Match by transaction description
- Expected tolerances (often zero)
- FX handling rules for non-USD accounts
Position Matching Rules
- Match by security ID / ISIN / CUSIP
- Quantity must match exactly
- Market value differences must fall within tolerance
- Corporate action handling rules
Transaction Matching Rules
- Compare by amount, date, security, counterparty
- Recognize timing differences
- Accrual vs actual posting logic
Fee & Accrual Rules
- Management fee accruals must tie to agreements
- Admin fees posted monthly or quarterly
- Interest, withholding, expenses must align with supporting docs
1.2 Source Hierarchy Rules
Which source is “truth” when there’s a mismatch?
Most fund admins follow this order:
- Custodian or Bank
- Prime Broker or Investment Manager
- Internal Books (GL / OMS)
- Manual Adjustments
This hierarchy dictates how breaks are resolved.
Break Classification Matrix
Breaks are not equal, they must be classified so teams know how to resolve and escalate them.
Common Break Types:
Type | Description | Root Cause | Owner |
Timing | Posted on different dates | Cutoff mismatch | Fund Accountant |
Posting Error | Wrong amount or GL code | Manual error | Ops Team |
Missing Trade | Absent in one system | Delay or missed posting | Trading/Ops |
FX Variance | Different FX sources | Rate mismatch | Accounting |
Accrual Mismatch | Incorrect accrual logic | Policy issue | Controller |
Pricing Variance | Valuation differences | Different sources | Valuations |
1.3 Resolution Workflow Rules
Each break category must have:
- Assigned owner
- Supporting documentation requirements
- SLA (time expectation)
- Escalation path
- Approval rules
This ensures consistency and auditability.
1.4 Approval & Documentation Rules
A proper audit trail includes:
- Preparer signature
- Reviewer approval
- Controller oversight (if applicable)
- Date/time stamps
- Linked supporting documents
- Variance explanations
This is the type of structure auditors expect.
Step-by-Step Example: Cash Reconciliation Workflow
Step 1: Gather Inputs
Bank/custodian statement + internal cash ledger.
Step 2: Validate Opening Balances
Tie prior-period closing balance.
Step 3: Match Transactions
Apply rulebook matching engine.
Step 4: Identify Breaks
Timing, posting, missing trade, FX, etc.
Step 5: Resolve Breaks
Investigate differences and document fixes.
Step 6: Validate Ending Balance
Internal vs external must agree.
Step 7: Documentation
Attach support, explanations, approvals.
With DwellFi, teams can:
- Extract and structure statements automatically
- Auto-match transactions with rulebook logic
- Auto-classify breaks
- Generate explanations using AI
- Produce all outputs in any accounting system’s format
- Maintain a full audit trail
- Push structured data into downstream platforms
Instead of spending 4–8 hours per reconciliation, teams spend: 5–20 minutes reviewing exceptions.
Frequently Asked Questions about Fund Reconciliation in Private Equity
What is fund reconciliation in private equity?
Fund reconciliation ensures internal books match external records from custodians, banks, and managers.
How often should reconciliations be performed?
Daily cash; monthly/quarterly full reconciliations.
What is a reconciliation break?
A mismatch between internal and external data caused by timing, posting errors, FX, or missing trades.
What systems does reconciliation feed into?
QuickBooks, Investran, Archway, Allvue, Geneva, eFront, and DwellFi.
Can reconciliation be automated?
Yes, DwellFi automates extraction, matching, break classification, documentation, and output formatting.
Book a Demo to see Intelligent Reconciliation in Action