Cash reconciliation in a fund is the daily check that the cash balance in the fund's own books agrees with the balance reported by each bank, prime broker and custodian. Every difference is identified, explained as timing or error, assigned an owner and cleared. It confirms that the cash used in the NAV actually exists.
This guide goes beyond the definition of cash reconciliation. It covers the daily process, a worked example with numbers, the breaks that come up most often, how to age and escalate them, and where automation helps. Managers that want the work done for them can use outsourced fund reconciliation services run by a dedicated team.
What is a cash reconciliation in a fund?
A fund holds cash in several places: operating and subscription accounts at a bank, margin and free cash at one or more prime brokers, and cash at a custodian alongside the fund's securities. The fund's internal ledger records every expected movement: trade settlements, subscriptions, redemptions, fees, interest, dividends and FX conversions.
A cash reconciliation compares the two views, account by account and currency by currency. In a company, a bank reconciliation is often a monthly task. In a fund it is daily, because cash feeds the NAV, margin decisions and the trading desk's view of available funds.
How do cash, position and trade reconciliation differ?
Cash reconciliation is one of three core reconciliations. They check different things and usually run in a set order: trades first, then positions, then cash.
| Trade reconciliation | Position reconciliation | Cash reconciliation | |
|---|---|---|---|
| What is compared | Internal trades vs broker confirmations and clearing reports | Units held per security vs prime broker and custodian holdings | Cash balances and movements vs bank, prime broker and custodian statements |
| Matching key | Trade ID, security, quantity, price, dates | Security identifier, account, quantity | Amount, currency, value date, reference |
| Typical tolerance | Zero on quantity; small on price or commission | Zero | Zero, or a small amount for fee rounding |
| Typical break | Wrong price or allocation | Missed corporate action | Unbooked fee, wire in transit, FX difference |
| Glossary | Trade reconciliation | Position reconciliation | Cash reconciliation |
The order matters. A trade booked at the wrong price will settle for the wrong amount, so it shows up as a cash break. Fixing the trade first stops the same error being worked twice.
What are the steps in a daily cash reconciliation?
A daily cash reconciliation follows the same sequence every business day.
- Collect statements. Pull the prior-day closing statements and intraday activity from each bank, prime broker and custodian, by account and currency.
- Extract the internal ledger. Take the fund's cash ledger for the same accounts, cut off at the same point in time.
- Normalize the data. Map counterparty transaction codes to internal transaction types and align account numbers, currencies and date fields.
- Run automated matching. Match movements on agreed rules (reference, amount, currency, value date), including one-to-many matches for netted items.
- Compare balances. Compare closing balances per account and currency, then confirm that unmatched movements explain the whole difference.
- Investigate breaks. Classify each unmatched item as timing, booking error, counterparty error or unknown, and find the cause.
- Correct and chase. Book internal corrections with review, and contact the bank, broker or administrator for counterparty errors.
- Age and escalate. Record each open item with its age and value, and escalate items that pass agreed thresholds.
- Review and sign off. A second person reviews the reconciliation and open items before it is signed off and filed with an audit trail.
What causes cash reconciliation breaks?
Most cash breaks come from a small set of causes. Knowing them speeds up investigation.
- Fees. Custody, wire, account and borrow fees are often debited by the counterparty before the fund books them.
- FX. A conversion booked at an expected rate settles at the executed rate, or an FX trade is booked in the wrong account.
- Wires in transit. A payment booked by the fund today reaches the bank statement tomorrow, or the reverse for incoming subscriptions.
- Interest accruals. The fund accrues interest daily, but the bank or prime broker pays it monthly, sometimes at a different rate or day count.
- Bank and broker netting. A counterparty nets several items, such as a dividend less withholding tax and a fee, into one movement that must be matched one-to-many.
- Value date vs booking date. The fund books on trade or instruction date while the statement reports on value date, so the same item sits in different days.
- Upstream errors. A trade booked at the wrong price or quantity settles for an unexpected amount.
Timing items clear on their own and only need tracking. Errors need a correction, and the root cause should be fixed so the same break does not return.
What does a cash reconciliation look like? A worked example
The figures are illustrative. A fund's USD operating account shows an internal book balance of USD 8,642,150.00 at close of business. The bank statement shows USD 8,893,570.00. The difference is USD 251,420.00.
The team finds five reconciling items:
| # | Item | Cause | Book | Bank |
|---|---|---|---|---|
| 1 | Redemption wire of USD 250,000.00 booked by the fund, value date tomorrow | Wire in transit; value date vs booking date | Recorded | Not yet on statement |
| 2 | Subscription of USD 400,000.00 credited as USD 399,960.00 | Bank netted a USD 40.00 incoming wire charge | Gross 400,000.00 | Net 399,960.00 |
| 3 | Monthly account fee of USD 3,200.00 | Bank debited fee before the fund booked it | Not recorded | Debited |
| 4 | September interest of USD 5,410.00 credited | Interest paid; fund had accrued USD 5,100.00 as a receivable | Not recorded as cash | Credited |
| 5 | EUR 500,000.00 sold; expected USD 542,500.00 at 1.0850, received USD 541,750.00 | FX executed at 1.0835 | 542,500.00 | 541,750.00 |
Adjust each side for the items it does not yet reflect:
| USD | |
|---|---|
| Book balance | 8,642,150.00 |
| Less wire charge (item 2) | (40.00) |
| Less account fee (item 3) | (3,200.00) |
| Add interest received (item 4) | 5,410.00 |
| Less FX difference (item 5) | (750.00) |
| Adjusted book balance | 8,643,570.00 |
| Bank balance | 8,893,570.00 |
| Less wire in transit (item 1) | (250,000.00) |
| Adjusted bank balance | 8,643,570.00 |
The adjusted balances tie. Item 1 is timing and should clear tomorrow. Items 2 and 3 are booked as expenses. Item 4 clears the interest receivable, and the USD 310.00 excess over the accrual is investigated as a rate or day-count difference. Item 5 goes to the trade desk to confirm the executed rate and correct the FX booking. A tie is not the end: every item still needs a cause and an owner.
How should cash breaks be aged and escalated?
Ageing turns a list of breaks into a control. Each open item carries its age and value, and the escalation rule depends on both. The buckets below are an example; set your own in the reconciliation procedure.
| Age bucket | Typical cause | Owner | Escalation |
|---|---|---|---|
| Same day | Wires in transit, value date timing | Reconciliation analyst | None if expected to clear next day |
| 1 to 2 business days | Unbooked fees, interest, netted items | Reconciliation analyst | Team lead review |
| 3 to 5 business days | FX differences, counterparty booking errors | Team lead with treasury or trade operations | Counterparty chased in writing; manager operations contact informed |
| Over 5 business days | Unexplained differences, disputed charges | Operations manager | Manager CFO or COO; flagged for NAV review |
| Any age above a value threshold | Large unexplained items | Operations manager | Escalated the same day |
Value thresholds matter as much as age. A two-day-old break of USD 5 is not urgent. A same-day unexplained break of USD 2,000,000 is.
What is a three-way cash reconciliation?
A three-way reconciliation compares the same cash across three sources: the street (banks, prime brokers and custodians), the fund administrator and the manager's internal books. A two-way reconciliation can hide an error. If the manager and the administrator both copied the same wrong booking, they agree with each other but not with the bank. Comparing all three shows which record is wrong.
Three-way reconciliation is common where a manager also runs shadow books. The street-to-internal cash reconciliation runs daily. The internal-to-administrator comparison runs daily or on the NAV cycle, and feeds the shadow NAV check. Our guide on how to compare shadow accounting providers covers how reconciliation fits into that process.
How much of cash reconciliation can be automated?
Matching can be automated well. Investigation still needs people. A good setup uses:
- Exact matching rules on reference, amount, currency and value date for high-volume items such as trade settlements.
- One-to-many and many-to-one rules for netted bank and broker movements.
- Date windows, for example a match allowed within two business days for wires in transit.
- Tolerances, kept small and approved, for example a few dollars for wire charge rounding. A tolerance should never hide a recurring error.
- Transaction code mapping so each counterparty's codes translate to the fund's own transaction types.
Automation reduces manual matching. It does not decide whether a break is an error, call a bank or correct a booking. Review the rules regularly, because a rule that auto-matches the wrong items is worse than no rule.
Where does Fundtec fit?
Fundtec runs cash, position, trade and three-way reconciliations for privately offered funds as part of its managed investment operations, on our proprietary platform, Tychi, with a dedicated team. The team ages each break, finds the cause, contacts the counterparty and tracks it to closure, with 24/5 coverage and ISO 27001 and ISO 9001 certified delivery. Where cash needs action, such as funding a margin call, our treasury operations team can take it on.
A cash reconciliation is only useful if every break has a cause, an owner and a closing date. If your team spends its mornings matching statements instead of resolving breaks, see how a dedicated reconciliation team for hedge funds and private funds would run your daily cycle.
Frequently asked questions
What is cash reconciliation?
Cash reconciliation is the process of comparing cash balances and movements in your own books with an external statement, such as a bank or broker statement, and explaining every difference. In a fund it is done daily, by account and currency, against each bank, prime broker and custodian. Differences are classified as timing or error, corrected where needed and tracked until they clear.
What is a cash reconciliation in a fund?
A cash reconciliation in a fund compares the fund's internal cash ledger with statements from its banks, prime brokers and custodians. It runs daily because cash feeds the NAV, margin and the trading desk's available funds. Common breaks include unbooked fees, wires in transit, FX differences, interest accruals and netted movements. Each break is aged, assigned an owner and escalated if it stays open.
What is the difference between cash and position reconciliation?
Cash and position reconciliation check different things. Position reconciliation compares the number of units held in each security with the prime broker or custodian, usually at zero tolerance. Cash reconciliation compares cash balances and movements by account and currency. Position reconciliation normally runs first, because a position error such as a missed corporate action often causes a related cash break.
How often should a fund reconcile cash?
Most hedge funds and private funds with active trading reconcile cash daily, for every account and currency. Funds with few transactions, such as some private equity vehicles, may reconcile less often, but daily or weekly checks catch fees, interest and wire errors sooner. A full reconciliation should always be completed and reviewed before each NAV is finalized.
What is a three-way cash reconciliation?
A three-way cash reconciliation compares the same cash across the street (banks, prime brokers and custodians), the fund administrator and the manager's internal books. A two-way check can miss an error that two parties share. Comparing all three shows which record is wrong. It is common for managers that run shadow books and want to verify the administrator's cash before NAV sign-off.
