--- title: "Fund Reconciliation: A Comprehensive Guide" description: "Answers to all your fund reconciliation questions: What it is, who to reconcile against and why. Difference between hedge and mutual fund reconciliation." image: https://www.limina.com/hubfs/Banners%2c%20Headers%20and%20CTA%20images/New%20Site%20-%20553px/Fund%20Reconciliation%20header.webp --- ![Fund Reconciliation header](https://www.limina.com/hs-fs/hubfs/Banners%2c%20Headers%20and%20CTA%20images/New%20Site%20-%20553px/Fund%20Reconciliation%20header.webp?width=300&name=Fund%20Reconciliation%20header.webp) [Andreas Holtz](https://www.limina.com/blog/author/andreas-holtz)5 min read # Fund Reconciliation Software: Features, Benefits & Best Practices ## What is fund reconciliation? Fund reconciliation means comparing records between your internal system and custodians, brokers and fund administrators to ensure everyone has the same data. Data to be reconciled can be transactions, cash, positions, corporate actions, P&L and NAV. If all sources match each other, the data is likely correct. ![Reconciliation diagram - light bg](https://www.limina.com/hs-fs/hubfs/problem%20and%20solution/Reconciliation%20diagram%20-%20light%20bg.png?width=1000&height=682&name=Reconciliation%20diagram%20-%20light%20bg.png) ## Why reconcile Here are two examples of what incorrect data can lead to: 1. **Incorrect NAV** If your NAV is incorrect, you might have to correct it later, which is expensive and a potential reputational hit. Early fund accounting reconciliation avoids this. 2. **Settlement failures** Incorrect trade information at the custodian can lead to settlement failures, which are costly in terms of time and money. Trade and position reconciliation avoids this. Avoiding these kinds of issues is why [investment reconciliation ](https://www.limina.com/blog/investment-reconciliation)is essential. The goal is to capture errors before they become problems. Our article about [position reconciliation](https://www.limina.com/blog/position-reconciliation-guide) lists examples of what can go wrong. ### Less tangible benefits of solid reconciliation processes Reconciliation is valuable even if your admin’s NAV is always correct and trades are always delivered for settlement. Reconciliation, especially when conducted early, eliminates the need to resolve discrepancies later. For example, if you catch a transaction tax difference, it avoids dealing with a cash mismatch later (even if the settlement is successful). Another benefit of reconciliation is proving to investors that you do it. As institutional investors perform their due diligence, reconciliation processes can be a direct requirement (or indirect via a “shadow NAV” requirement). ### Front Office benefits of correct data Early reconciliation ensures that portfolio managers have reliable positions and cash balances. When they [rebalance portfolios](https://www.limina.com/blog/portfolio-rebalancing-software), they can do so more confidently and keep a lower cash buffer. A lower cash buffer creates operational alpha. [You can check out our online operational alpha calculator to see the potential AuM and profitability impacts of lowering your cash buffer](https://www.limina.com/operational-alpha-calculator). ## Fund reconciliation process - 01 Trades - 02 Corporate actions - 03 Positions - 04 Cash - 05 P&L - 06 NAV 01 Trades02 Corporate actions03 Positions04 Cash05 P&L06 NAV ### Transaction reconciliation **What [trade recon](https://www.limina.com/blog/trade-reconciliation-guide) entails**: Verify that all parties capture trades correctly, whether initiated internally (e.g. orders) or externally (e.g. FX-hedges). **Data to reconcile:** Trade quantity, execution price, commission, other fees, taxes and allocations. **Importance:** The primary reason is to avoid settlement failures. A secondary reason is to catch issues when they are easier to find. For example, a fee or tax mismatch will appear in the cash reconciliation later, but it will be easier to find and resolve in the trade recon. ### Corporate Actions Reconciliation **When to do this: **Sometimes, the custodian will be the only source of corporate action data. In this case, it’s still relevant to reconcile because what was projected a week in advance might not be what the custodian records (e.g. on the pay date for a dividend). If your internal systems take corporate action from multiple sources, such as the custodian and market data provider, reconciling those sources could be a good idea. **When not to reconcile corporate actions: **The corporate actions always impact positions (quantity, P&L, etc) or cash – so any discrepancy will be caught in those recons anyway.  ### Positions / Holdings recon **What it entails: **Confirm that the number of holdings matches. **Data to reconcile:** Instrument held (listed or OTC), currency, quantity/notional, valuation, market value (local current), acquired price or tax lots. **Importance:** The [position reconciliation](https://www.limina.com/blog/position-reconciliation-guide) is a catch-all for any issue that could’ve caused a position to be incorrect. It’s a great tool to avoid having to check all reasons individually and instead just answer the question, “Did we get the result correct?”. If not, an investigation can start to determine why there is a mismatch. **Reasons for mismatches:** Some examples include trade information not delivered to the custodian, differences in corporate actions, market price discrepancies, and using different identifiers. ### Cash balances **What it entails: **[Cash reconciliation](https://www.limina.com/blog/cash-reconciliation-guide) in fund accounting is a check of the internal cash view, compared to the custodian (settled cash) and the fund administrator (trade date cash). **Importance:** There are two main reasons to reconcile cash: - A “catch-all” layer for anything that affects cash. - From recon to admin: to ensure NAV accuracy and to catch unsettled cash (before settlement fails). - From recon to custodian: to ensure the settled cash aligns with expectations. This can catch things like a dividend that should’ve been paid but wasn’t. - Ensure that the cash view portfolio managers see is as up-to-date and accurate as possible. With a better cash view, they can keep a lower [cash buffer](https://www.limina.com/blog/what-is-cash-drag-and-how-to-reduce-it) and thus increase performance. ### Profit & Loss **What it entails: **Confirm that the profit or loss from holdings, fees and taxes matches between the fund administrator and the intern system. **Importance:** If the cash and position recon match, we know the portfolio aligns with the fund administrator. Adding [P&L, we reconcile the last component that goes into the NAV](https://www.limina.com/blog/pnl-and-nav-reconciliation-guide). So, with this step, we’ve completed a full reconciliation of all portfolio data relevant to NAV and settlement purposes. ### Net Asset Value **What it entails:** NAV reconciliation involves verifying that the total value of the fund’s assets minus liabilities is accurately calculated and reflects the actual value of the portfolio. **Importance:** The NAV is the fund’s value, so it’s tempting to conclude it’s the most essential reconciliation. We argue it’s the least important and you might not have to do it. If the 5 recons are performed and match, the NAV will also match. If you instead reconcile the NAV directly (skipping steps 1-5), it will be challenging to understand why it breaks and where to start investigating. This is why we recommend these 5-6 reconciliations in this order. ## Different types of funds Mutual funds and hedge funds need to go through the 6 steps above, but there are some nuances. ### Mutual fund reconciliation The mutual fund reconciliation process is generally characterised by: - Daily reconciliation, or sometimes even multiple times per day - Usually simple asset classes, at least with an ISIN available (there are many exceptions, however) - Often done across many funds at once - Often, many counterparties (multiple custodians, brokers or even fund administrators) ### Hedge fund reconciliation When reconciling hedge funds, there are some other commonalities: - Strict “Shadow NAV” requirements from investors - Sometimes monthly rather than daily - Holdings can be more complex, either [OTC](https://www.investopedia.com/ask/answers/052815/what-overthecounter-derivative.asp) or short positions via swap agreements that affect P&L and cash (financing) - Often, fewer funds (sometimes just one) and counterparties ## Turn fund reconciliation into reality In practice, reconciliation isn’t “just” about comparing data. Getting the data into a reconciliation system can be even more challenging. You get data delivered in multiple files, sometimes with overlapping data and in various formattings. When you investigate [fund reconciliation software](https://www.limina.com/blog/fund-reconciliation-software), we recommend focusing at least half of the evaluation on the data ingestion functionality as the reconciliation functionality. ### Explore a better reconciliation See Limina's approach to automated reconciliation in action - no strings attached [Get your demo now](https://www.limina.com/book-a-demo) ![avatar](https://www.limina.com/hs-fs/hubfs/IFT_WEBSITE_2022/Members/Andreas%20Holtz.jpg?width=290&name=Andreas%20Holtz.jpg) [Andreas Holtz ](https://www.limina.com/blog/author/andreas-holtz)Experienced client relations professional with a proven track record of building and nurturing successful client relationships, bringing a strategic and customer-centric approach to every interaction. ```json { "@context" : "https://schema.org", "@type" : "Organization", "address" : { "@type" : "PostalAddress", "addressCountry" : "Sweden", "addressLocality" : "Stockholm", "addressRegion" : "SE", "postalCode" : "111 22", "streetAddress" : "Kungsgatan 64" }, "email" : "+1 332 2164 772", "knowsLanguage" : "en", "logo" : { "@type" : "ImageObject", "url" : "https://www.limina.com/hubfs/Limina%20Arcesium.webp" }, "name" : "Limina", "telephone" : "+44 1983 632493", "url" : "https://www.limina.com/blog/fund-reconciliation-guide" } ``` ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "abstract" : "Answers to all your fund reconciliation questions: What it is, who to reconcile against and why. Difference between hedge and mutual fund reconciliation.", "author" : { "@type" : "Person", "name" : "Andreas Holtz" }, "dateModified" : "", "datePublished" : "", "headline" : "Fund Reconciliation Software: Features, Benefits & Best Practices", "image" : "https://www.limina.com/hubfs/Banners%2c%20Headers%20and%20CTA%20images/New%20Site%20-%20553px/Fund%20Reconciliation%20header.webp", "inLanguage" : "en", "keywords" : "[Article]", "mainEntityOfPage" : { "@type" : "WebPage" }, "name" : "Fund Reconciliation Software: Features, Benefits & Best Practices", "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.limina.com/hubfs/Limina%20Arcesium.webp" }, "name" : "Limina" }, "text" : "What is fund reconciliation? Fund reconciliation means comparing records between your internal system and custodians, brokers and fund administrators to ensure everyone has the same data. Data to be reconciled can be transactions, cash, positions, corporate actions, P&L and NAV. If all sources match each other, the data is likely correct. Why reconcile Here are two examples of what incorrect data can lead to: Incorrect NAV If your NAV is incorrect, you might have to correct it later, which is expensive and a potential reputational hit. Early fund accounting reconciliation avoids this. Settlement failures Incorrect trade information at the custodian can lead to settlement failures, which are costly in terms of time and money. Trade and position reconciliation avoids this. Avoiding these kinds of issues is why investment reconciliation is essential. The goal is to capture errors before they become problems. Our article about position reconciliation lists examples of what can go wrong. Less tangible benefits of solid reconciliation processes Reconciliation is valuable even if your admin’s NAV is always correct and trades are always delivered for settlement. Reconciliation, especially when conducted early, eliminates the need to resolve discrepancies later. For example, if you catch a transaction tax difference, it avoids dealing with a cash mismatch later (even if the settlement is successful). Another benefit of reconciliation is proving to investors that you do it. As institutional investors perform their due diligence, reconciliation processes can be a direct requirement (or indirect via a “shadow NAV” requirement). Front Office benefits of correct data Early reconciliation ensures that portfolio managers have reliable positions and cash balances. When they rebalance portfolios, they can do so more confidently and keep a lower cash buffer. A lower cash buffer creates operational alpha. You can check out our online operational alpha calculator to see the potential AuM and profitability impacts of lowering your cash buffer. Fund reconciliation process 01 Trades 02 Corporate actions 03 Positions 04 Cash 05 P&L 06 NAV 01 Trades02 Corporate actions03 Positions04 Cash05 P&L06 NAV Transaction reconciliation What trade recon entails: Verify that all parties capture trades correctly, whether initiated internally (e.g. orders) or externally (e.g. FX-hedges). Data to reconcile: Trade quantity, execution price, commission, other fees, taxes and allocations. Importance: The primary reason is to avoid settlement failures. A secondary reason is to catch issues when they are easier to find. For example, a fee or tax mismatch will appear in the cash reconciliation later, but it will be easier to find and resolve in the trade recon. Corporate Actions Reconciliation When to do this: Sometimes, the custodian will be the only source of corporate action data. In this case, it’s still relevant to reconcile because what was projected a week in advance might not be what the custodian records (e.g. on the pay date for a dividend). If your internal systems take corporate action from multiple sources, such as the custodian and market data provider, reconciling those sources could be a good idea. When not to reconcile corporate actions: The corporate actions always impact positions (quantity, P&L, etc) or cash – so any discrepancy will be caught in those recons anyway. Positions / Holdings recon What it entails: Confirm that the number of holdings matches. Data to reconcile: Instrument held (listed or OTC), currency, quantity/notional, valuation, market value (local current), acquired price or tax lots. Importance: The position reconciliation is a catch-all for any issue that could’ve caused a position to be incorrect. It’s a great tool to avoid having to check all reasons individually and instead just answer the question, “Did we get the result correct?”. If not, an investigation can start to determine why there is a mismatch. Reasons for mismatches: Some examples include trade information not delivered to the custodian, differences in corporate actions, market price discrepancies, and using different identifiers. Cash balances What it entails: Cash reconciliation in fund accounting is a check of the internal cash view, compared to the custodian (settled cash) and the fund administrator (trade date cash). Importance: There are two main reasons to reconcile cash: A “catch-all” layer for anything that affects cash. From recon to admin: to ensure NAV accuracy and to catch unsettled cash (before settlement fails). From recon to custodian: to ensure the settled cash aligns with expectations. This can catch things like a dividend that should’ve been paid but wasn’t. Ensure that the cash view portfolio managers see is as up-to-date and accurate as possible. With a better cash view, they can keep a lower cash buffer and thus increase performance. Profit & Loss What it entails: Confirm that the profit or loss from holdings, fees and taxes matches between the fund administrator and the intern system. Importance: If the cash and position recon match, we know the portfolio aligns with the fund administrator. Adding P&L, we reconcile the last component that goes into the NAV. So, with this step, we’ve completed a full reconciliation of all portfolio data relevant to NAV and settlement purposes. Net Asset Value What it entails: NAV reconciliation involves verifying that the total value of the fund’s assets minus liabilities is accurately calculated and reflects the actual value of the portfolio. Importance: The NAV is the fund’s value, so it’s tempting to conclude it’s the most essential reconciliation. We argue it’s the least important and you might not have to do it. If the 5 recons are performed and match, the NAV will also match. If you instead reconcile the NAV directly (skipping steps 1-5), it will be challenging to understand why it breaks and where to start investigating. This is why we recommend these 5-6 reconciliations in this order. Different types of funds Mutual funds and hedge funds need to go through the 6 steps above, but there are some nuances. Mutual fund reconciliation The mutual fund reconciliation process is generally characterised by: Daily reconciliation, or sometimes even multiple times per day Usually simple asset classes, at least with an ISIN available (there are many exceptions, however) Often done across many funds at once Often, many counterparties (multiple custodians, brokers or even fund administrators) Hedge fund reconciliation When reconciling hedge funds, there are some other commonalities: Strict “Shadow NAV” requirements from investors Sometimes monthly rather than daily Holdings can be more complex, either OTC or short positions via swap agreements that affect P&L and cash (financing) Often, fewer funds (sometimes just one) and counterparties Turn fund reconciliation into reality In practice, reconciliation isn’t “just” about comparing data. Getting the data into a reconciliation system can be even more challenging. You get data delivered in multiple files, sometimes with overlapping data and in various formattings. When you investigate fund reconciliation software, we recommend focusing at least half of the evaluation on the data ingestion functionality as the reconciliation functionality. Explore a better reconciliation See Limina's approach to automated reconciliation in action - no strings attached Get your demo now", "url" : "https://www.limina.com/blog/fund-reconciliation-guide", "wordCount" : "2336" } ``` ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Andreas Holtz", "url" : "https://www.limina.com/blog/author/andreas-holtz" }, "dateModified" : "2025-10-02T10:23:34.577Z", "datePublished" : "2024-08-23T06:51:54.000Z", "headline" : "Fund Reconciliation: A Comprehensive Guide", "image" : [ "https://www.limina.com/hubfs/Banners%2c%20Headers%20and%20CTA%20images/New%20Site%20-%20553px/Fund%20Reconciliation%20header.webp" ], "mainEntityOfPage" : { "@id" : "https://www.limina.com/blog/fund-reconciliation-guide", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.limina.com/hubfs/Limina%20Arcesium.webp" }, "name" : "Limina IMS" } } ```