A Family Office Reconciliation Process Built Around the Open Item

A family report can agree with the investment dashboard and still be wrong. Both may have copied the same missing transaction, duplicated sale or undated private-fund value. Reconciliation starts when the office compares records with independent evidence and keeps a difference open until someone can explain its effect on the books and the report.

The useful output is not a green “matched” badge. It is a recurring queue: compare named source pairs, start an age clock for each break, record a disposition and decide which scoped report may be released. This family office reconciliation process follows a fictional October close to show those decisions.

01Define the Records and the Question Each Comparison Answers

“One source of truth” is too blunt for a family office. A bank statement can establish the bank's posted cash balance at a date, but it does not decide which legal entity owns an investment. A custodian can establish a reported position and transaction, but a private-fund administrator may provide a later, separately dated NAV. The entity general ledger records accounting under the office's policy; the family report combines approved views across entities.

Before matching numbers, write down the comparison pairs and the fact each is meant to prove:

• Bank to entity cash ledger: Which payments and receipts have cleared, and which are documented timing items?
• Custodian to investment records: Do positions and transactions agree by account, security and date, after known corporate actions?
• Investment records to entity books: Are cash activity, income, fees and investment entries reflected in the right legal entity? Equal portfolio totals alone do not prove that.
• Manager or administrator statement to private-asset record: What value, cash movement and unfunded amount was actually reported, and as of which date?
• Approved records to family report: Are ownership, currency, valuation dates and unresolved exceptions represented honestly for each recipient?

The FOS data-aggregation guide covers how feeds and documents enter the stack. This process begins after intake: it asks whether the imported records are complete, correctly mapped and fit for release. The audit-trail guide covers the provenance of corrections; here the focus is the recurring queue that identifies, owns and closes them.

02Set a Cutoff, Matching Rules and Review Rights

The controller should identify the reporting date, source receipt cutoff, entity perimeter and required accounts before running a match. A bank feed received on 2 November may contain activity for 31 October; a fund statement received in November may still carry a 30 September NAV. Receipt date and as-of date are different fields.

Use stable identifiers where possible: legal entity, account, security, transaction ID, currency, source date and amount. Compare records on the same basis. A USD-converted family view can differ from a local-currency ledger because of an approved FX rate, even when the underlying position is correct. Record the rate and date before calling the difference an error.

Agree tolerances by risk, not convenience. A documented rounding threshold may be appropriate for a currency conversion. A duplicate transaction, unexplained cash movement, wrong legal entity or stale valuation label should not be waived simply because its dollar effect falls below a percentage of family wealth. Define who can approve a tolerance and what evidence is required.

The preparer runs the comparisons and creates open items. A reviewer who did not prepare the match challenges the source and proposed disposition. The owner of the underlying ledger or investment record makes an authorized correction. The person who approves the report release must see material open items and any qualified presentation. In a small office, roles may overlap; the review and release decision still need a visible record.

03Work an October Close Through Three Different Breaks

The following case is fictional. A service-company controller prepares an October report extract covering only three named records: service company SC-01 bank account B-01, trust TR-02 custody account C-07, and investment company INV-03 private-fund interest FUND-P1. Their internal books and the draft extract are in scope. Other family accounts and the complete family report are outside this example's release decision. The numbers illustrate the control; they are not a family's results or a mandated accounting policy.

1Cash: a Documented Timing Item, Not an Automatic Adjustment

At 31 October, the bank statement shows US$2,500,000 and the entity cash ledger shows US$2,490,000. A US$10,000 check was issued and entered in the ledger on 31 October but did not clear the bank until 2 November.

At the initial review on 1 November, the controller retains the check register, payment approval and payee evidence. The bank-side reconciliation is US$2,500,000 − US$10,000 outstanding check = US$2,490,000, matching the ledger. No second cash entry is posted merely to make the statement equal the ledger. The item stays open until the 2 November bank clearing is verified; if it fails to clear as expected, its owner reopens the investigation.

2Position: a Duplicate Sale That Needs More Than a Footnote

The custodian reports 1,000 shares of a listed security at 31 October. The office's investment record shows 900. The trade evidence shows one sale of 100 shares from an opening 1,100-share position, but the internal file imported the same transaction twice.

The investment-record owner checks the custodian transaction ID, trade confirmation and both internal import records, then reverses the duplicate under the office's correction approval. The corrected position is 1,000 shares. The owner also checks the duplicated cash proceeds, realized gain or loss and any downstream entity-book entry; correcting the share count alone would leave a different error. The reviewer reruns the position, transaction and linked cash comparisons before closing the item.

3Private Fund: a Valuation-Date Break, Not a US$300,000 Plug

The administrator's latest approved statement reports US$4.2 million as of 30 September. A draft 31 October extract labels US$4.5 million as the fund's October value, but the file behind it is an unapproved internal estimate. Subtracting the two amounts yields US$300,000; it does not prove a gain, a posting error or a current administrator value.

The private-assets owner finds the original statement, checks for later calls and distributions, and asks whether the office's valuation policy permits an October estimate. Until the appropriate reviewer approves a basis and date, the extract must not present US$4.5 million as an approved October mark. One possible release under the fictional office's policy is to carry the 30 September US$4.2 million value with its date and any intervening cash activity separately explained. Another is to hold that section. Neither route is chosen by an automated match or an arbitrary US$300,000 adjustment.

04Keep One Exception Register Through Resolution

A useful register follows each difference from detection to closure. It does not replace the source documents or journals. For each item, record the period, entity/account, source versions, comparison, unit and amount, type, first-seen date, age, owner, due date, decision, approver, posting or report reference, and evidence that the rerun passed.

For the fictional close, the compact records below determine whether the named October extract can be released. The IDs, actors and dates are illustrative.

1CASH-01 — Cleared Timing Item

• Comparison and sources: SC-01 / B-01; 31 October bank statement BANK-OCT-v1 US$2,500,000; SC-01 cash ledger GL-OCT-v1 US$2,490,000; issued-check register CHK-10 US$10,000. The documented outstanding check bridges the balances.
• Owner and clock: Cash accountant; first seen 1 November, due for follow-up 3 November. It remains open through the 2 November evidence receipt and closes at controller acceptance on 3 November—two days after detection.
• Disposition and proof: The 2 November bank statement shows the US$10,000 clearing under BANK-NOV02-10. The cash accountant logs it on 2 November as post-cutoff resolution evidence, not as a missing 31 October source file. The controller accepts that supplement and signs BR-OCT-1 on 3 November. No extra ledger entry is posted. Status: cleared.

2POS-02 — Corrected Duplicate Sale

• Comparison and sources: TR-02 / C-07 / SEC-44; 31 October custodian statement CUST-OCT-v1 shows 1,000 shares; trust investment record INV-OCT-v1 shows 900. A trade confirmation and custodian ID show one 100-share sale; the internal import log shows that sale twice.
• Owner and clock: Investment-operations lead; first seen 1 November, due 3 November. At sign-off the item is two days old.
• Disposition and proof: Under controller approval CTRL-REV-7, operations reverses the second import in the investment record (INV-REV-77). The duplicate cash proceeds and realized result in that record reverse with it. The entity GL is checked against bank/custody evidence and was not fed the duplicate (GL-CHECK-31), so no GL journal is invented. The 3 November rerun MATCH-3 agrees at 1,000 shares and one sale; reviewer signs. Status: corrected.

3NAV-03 — Qualified Dated Value

• Comparison and sources: INV-03 / FUND-P1; administrator statement FUND-SEP-v1 reports US$4.2 million as of 30 September. Draft extract FAM-OCT-v1 labels an unapproved US$4.5 million estimate as an October mark. US$300,000 is a difference between unlike bases, not an adjustment.
• Owner and clock: Private-assets lead; first seen 1 November, decision due 4 November. At decision the item is three days old.
• Extract treatment and proof: The lead confirms no approved October fund mark is available and reconciles any intervening calls and distributions separately. Under this fictional office's policy permitting a dated prior mark with an explicit lag note, the report approver signs REL-4 on 4 November: remove the US$4.5 million claim and carry US$4.2 million in FAM-OCT-v2 with this recipient-facing note: “Fund NAV is the administrator's 30 September mark; no approved 31 October NAV is available. October cash movements, if any, are reported separately.” The reviewer checks the extract against FUND-SEP-v1. Extract treatment: approved for qualified disclosure, not “October value verified.”
• Open follow-through: The valuation question remains open after the extract is released. The private-assets lead requests an approved October NAV or approved alternative basis and checks for it by 20 November. If still unavailable, the lead records that result, escalates under the valuation policy and carries NAV-03 into the next reporting queue. The checkpoint is an illustrative control date, not a promise that the administrator will provide a value then.

The age clock begins when an item is detected, not when someone last edited the spreadsheet. An owner who cannot resolve it by the cutoff must escalate it with an explanation and next action. Aging alone does not determine accounting materiality, but it shows whether a supposedly temporary item has become a recurring blind spot.

Classify each outcome. Cleared means source evidence explains a timing item and the follow-up was verified. Corrected means an authorized change was posted and the comparison rerun. Approved for qualified disclosure means the open limitation and date are visible to the report approver and recipient. Held means the item blocks an affected balance or report. “Ignored because immaterial” is not an outcome unless the office's documented policy, qualified approver and supporting analysis actually permit it.

05Reconcile the Reconciliation Before Releasing a Report

The controller's final test is not whether every screen is green. For each scoped account and entity, confirm that the source file arrived, expected transaction and position counts were considered, matches and open items explain the difference, and approved adjustments appear in the correct record. A cash bridge can tie while an ownership mapping remains wrong; a family total can tie while one trust and one LLC are offsetting each other.

The sign-off packet should let a second reviewer answer five questions without calling the preparer:

1. What period and perimeter were covered? List entities, accounts, sources, source dates and receipt cutoffs.
2. Which comparisons passed? Keep match totals and versioned source references, not just a “done” label.
3. Which items remain open? Show amount or unit, age, owner, deadline, financial/report impact and proposed release treatment.
4. What changed? Link approved adjustments to both the source investigation and the rerun, including entity-book and report references where affected.
5. Who accepted the result? Record preparer, independent or delegated reviewer, and report-release approver with dates and qualifications.

The fictional sign-off packet can be read in four lines:

• Perimeter and cutoff: At 31 October, only SC-01 / B-01, TR-02 / C-07 / SEC-44 and INV-03 / FUND-P1 are covered. By 1 November, 18:00, all three expected external statements and the corresponding internal records and draft extract are logged by version. The fund statement's value remains dated 30 September.
• Population and matches: Twelve bank-posted October items compare with 13 cash-ledger items; the issued but uncleared check explains the extra book item. One custodian sale compares with two internal imports, corrected to one. The security closing position reruns at 1,000 shares. One private-fund interest has the dated administrator statement. All other in-scope items match.
• Later proof and disposition: The 2 November bank clearing is a separately logged, accepted post-cutoff resolution supplement. BR-OCT-1 clears CASH-01 on 3 November; MATCH-3 proves POS-02 corrected on 3 November; REL-4 approves dated disclosure for NAV-03 on 4 November. NAV-03's valuation question stays open with its 20 November checkpoint.
• Approved output: On 5 November, the authorized approver releases only the named extract FAM-OCT-v2, with the fund's September date and explicit lag note visible and the October estimate removed. Broader family reporting waits for its own perimeter and exception sign-off.

These are fictional counts for the named extract, not evidence that other family accounts were reconciled.

An office may instead hold an affected balance or report if its policy, purpose or recipient requires a current approved value. A sign-off is a decision about known evidence and open risk; it is not a guarantee that no error exists.

Vendor material such as Masttro's reconciliation overview and Asora's automation guide describes automated intake and exception routing. Those tools may reduce matching work. The office still has to establish source authority, approve adjustments and decide what an unresolved item permits it to say.

06Frequently Asked Questions

1Is Data Aggregation the Same as Reconciliation?

No. Aggregation brings source records into one view. Reconciliation checks whether selected fields agree with independent evidence on the same entity, account and date basis, then routes differences to a documented decision. One imported value appearing in two systems does not make it independently verified.

2How Often Should a Family Office Reconcile?

Set cadence by account activity, risk and reporting use. High-volume cash and trade records may need more frequent matching than a private-fund NAV issued quarterly. The policy should name a source cutoff and exception deadline for each report cycle. This article does not establish a universal monthly requirement for every asset.

3Can a Reconciliation Be Signed Off With Open Items?

Sometimes, under a documented policy and an authorized report decision. A small, evidenced timing item may remain open until bank clearing. An unexplained duplicate trade or a private-fund estimate mislabeled as an approved current mark may require correction, disclosure or a hold. The owner, age and report effect must be visible; a green overall status cannot substitute for that decision.

4Which System Is the Source of Truth?

Name an authoritative source for each fact. The bank establishes posted bank cash at its statement date; the custodian supplies its account positions and activity; fund administrators provide statements with their own as-of dates; the entity ledger carries approved accounting; and the family report presents a governed combination. Source precedence and exceptions belong in the reconciliation policy, not in a single universal vendor label.