For fund controllers and CFOs whose administrator reconciles the NAV once a month: 11 Claude prompts that tie positions, cash, and accruals to the custodian every day, trace each break to the trade that caused it, and hand you four exceptions instead of four hundred rows.
Never used Claude? It is free and takes 30 seconds to open. Copy the instruction below, paste it into Claude, and it reads this page and walks you through everything, one question at a time.
A short instruction plus a link to this page lands on your clipboard. First copy asks for your email once. That unlocks every button across the whole library.
Free account, no card, 30 seconds. This tab stays open so you can come back.
Open claude.ai ↗Claude reads this page, asks which computer you are on, then guides you step by step until it works. If anything errors, tell Claude what you see, and it fixes it with you.
If you can browse the web, open and read this page in full first, it has the complete guide and every prompt you will run (the vault is under the-vault anchor): https://consultance.ai/library/nav-tieout-engine#the-vault . If you cannot open links, tell me and I will paste the page in, I will not guess the prompts.
I want to INSTALL the real setup so Claude ties out my fund NAV every day on my actual book, not just a chat demo. Walk me through it step by step, do not skip the install. Treat me like a fund controller or CFO who has never built a Claude Project or installed an Office add-in, and define every term once.
This is NOT a Terminal or coding install. There is nothing to compile. It is two paths: a private Claude Project for the fund records (recommended) and an optional Excel add-in for the tie-out workbook.
One honest line before we start, so you set your expectations right: this vault is about 60 percent of the build. It gives you the daily tie-out logic, the break tracing, and the self-check. The last 40 percent, live data feeds from your custodian and prime broker, role-based access, an audit trail your auditor will accept, and multi-entity scale, is implementation work Consultance wires into production in your own environment. When you hit that wall, reply "wire it" and I will send a 30-minute slot. For now, let us get the daily tie-out running on a book you already trust.
## Path 1 (RECOMMENDED), a private Claude Project for the tie-out
This is where the trade blotter, custodian and prime broker statements, cash report, and prior NAV pack live so every prompt reads from one governed place.
Walk me through ONE step at a time, waiting for me to confirm each:
1. **What I need.** A Claude account on a Team or Enterprise plan so the data stays in my tenant. Pin **Claude Fable 5** (the current model, live since June 2026). Nothing to install for this path.
2. **Create the tie-out workspace.** In Claude, create a new **Project** named for the fund. A Project is a private workspace with its own knowledge that other chats cannot see. Your blotter, statements, and prior NAV pack stay in your own tenant. Nothing is uploaded to us, stored by us, or seen by us.
3. **Load today's book.** Drop today's trade blotter, the custodian and prime broker statements, the cash report, the prior NAV pack, and your fee terms into the Project knowledge. If you run multiple funds, keep one Project per fund.
4. **Run the vault.** Run prompt 01, pick your fund type (hedge, PE or VC, fund of funds, family office) and where your data lives (A upload, or D connector if you pull from a custodian portal or prime broker feed under governed access). Then run 02 to 11 in order: set the baseline, tie positions and cash to the custodian, re-price the accruals, catch the fee drift, trace every break to its cause, roll the prior NAV forward, run the self-check, build the daily read, draft the escalations, and at month end tie to your administrator.
5. **Gate it.** Treat prompt 08, the reconciliation self-check, as a HARD GATE. It re-derives the NAV a second, independent way. If it reads NOT RECONCILED, nothing downstream ships. A named human signs the NAV; a prompt cannot.
6. **Run it alongside your administrator.** This is a daily control, not a replacement for the official struck NAV or the annual audit. Prompt 11 ties the engine to the administrator's monthly NAV so the two records reconcile.
## Path 2 (OPTIONAL), Claude for Excel add-in for the tie-out workbook
If I want the position match, the accrual re-pricing, and the roll-forward to live in real formulas:
1. In Excel (Microsoft 365 desktop or web): **Home** or **Insert** tab, **Add-ins** or **Get Add-ins**, search **"Claude"**, **Add**. Tell me where the button is in my version.
2. Sign in to the docked Claude side panel.
3. In vault prompt 01 choose data source (C) Excel add-in. For prompt 02 (baseline), prompt 03 (custodian tie-out), and prompt 04 (accruals) say "build this into my workbook as real formulas," so the tie-out recomputes and the break list updates on live cells.
4. Pin **Claude Fable 5** for the tie-out and the self-check.
## Rules for walking me through this
- One step at a time. Define every term once: Project, knowledge, NAV, tie-out, break, trade blotter, custodian, prime broker, administrator, accrual, roll-forward, basis point, self-check, `<review_gate>`, `{{TOKEN}}`.
- Do NOT tell me a step is "not possible." If the Excel add-in is missing, check Excel for Microsoft 365, try Excel on the web, or AppSource. For the Project path there is nothing to install.
- Never paste live investor PII or fund records into a public Claude window outside a Project. Use a Project with your tenant controls; respect your custodian's and administrator's terms.
- This is 60 percent of the build. It does not wire live data feeds, role-based access, an audit trail, or multi-entity scale. Read the reality check in the bundle. When you want the last 40 percent wired into production, reply "wire it." A named human signs every NAV. Not accounting or audit advice.
First message: ask me "Path 1 (Claude Project for the fund records, recommended), and do you also want Path 2 (Excel add-in for the tie-out workbook)? And is this a hedge fund with NAV per share, or a closed-end PE or VC vehicle with capital accounts?" Then start step 1.
Related: [[fund-nav-close-pack]] · [[statement-matching-recon]]Grab the whole pack as one file, or tap any prompt below to copy it on its own. Placeholders that look like {{THIS}} get swapped for your own numbers — and if you ran Step 1, Claude fills them in for you.
For fund controllers and CFOs whose administrator reconciles the NAV once a month: 11 Claude prompts that tie positions, cash, and accruals to the custodian every day, trace each break to the trade that caused it, and hand you four exceptions instead of four hundred rows.
The setup rail and every prompt above are free and stay free. The cost is your time, and the risk of wiring it wrong on live data.
Back to the prompts ↑This vault is about 60 percent of the build: the daily tie-out logic, the break tracing, and the self-check. Consultance wires the last 40 percent into production in your environment: live custodian and prime broker data feeds, role-based access to funds and positions, an audit trail your auditor will accept, and multi-entity and multi-currency scale. Done with you, then handed over so you own it.
Book a build call →Prompt set authored by consultance.ai. Citco, SS&C, State Street, and Northern Trust are referenced as the administrator standard the tie-out matches, no affiliation implied. Your fund and investor data stays in your own Claude tenant; we never see it. This is a daily control that runs alongside your administrator; it does not replace the official struck NAV, independent NAV verification, SOC 1 controls, or the annual audit, and a named human signs every NAV. Not accounting, audit, or investment advice.
Want this wired into your stack instead of running it yourself? That is our AI deal desk and finance automation service.
The AI tools, launches, and shifts that actually matter, in plain English. New library drops the moment they land.
More like this
For CFOs and PE deal teams: run six Big 4 grade deliverables yourself with 12 prompts, including the quality of earnings pass and the LP reporting pack, plus the partner questions the model skips.
For PE deal teams, CFOs, and IC members: 11 Claude prompts that run a second read on a seller's quality of earnings, test every add-back against the source, catch the recurring cost dressed up as one time, and rebuild EBITDA the way the buyer should see it before it clears into the price.
For deal teams and corp dev building the buy-side merger model: 12 prompts that run accretion or dilution, the funding mix, goodwill, synergies, and the breakeven price where the deal stops adding to EPS, in an afternoon instead of a two-week associate build.
The person drowning in this every week is the one who'll actually want it.
Daily Fund NAV Tie-Out is a finance and data build in the consultance.ai AI Build Library. For fund controllers and CFOs whose administrator reconciles the NAV once a month: 11 Claude prompts that tie positions, cash, and accruals to the custodian every day, trace each break to the trade that caused it, and hand you four exceptions instead of four hundred rows. It fits fund controllers, fund accountants, hedge fund and PE or VC fund CFOs, and family office finance leads who keep their administrator but want a daily control that catches the break the day it happens instead of at month end. Setup difficulty is Medium, with 4 plain-English steps.
For fund controllers and CFOs whose administrator reconciles the NAV once a month: 11 Claude prompts that tie positions, cash, and accruals to the custodian every day, trace each break to the trade that caused it, and hand you four exceptions instead of four hundred rows.
It fits fund controllers, fund accountants, hedge fund and PE or VC fund CFOs, and family office finance leads who keep their administrator but want a daily control that catches the break the day it happens instead of at month end.
Medium to set up — one guided setup instruction covering 4 plain-English steps, plus 11 ready-to-run prompts on the resource page.
This vault is about 60 percent of the build: the daily tie-out logic, the break tracing, and the self-check. Consultance wires the last 40 percent into production in your environment: live custodian and prime broker data feeds, role-based access to funds and positions, an audit trail your auditor will accept, and multi-entity and multi-currency scale. Done with you, then handed over so you own it.
Prompt set authored by consultance.ai. Citco, SS&C, State Street, and Northern Trust are referenced as the administrator standard the tie-out matches, no affiliation implied. Your fund and investor data stays in your own Claude tenant; we never see it. This is a daily control that runs alongside your administrator; it does not replace the official struck NAV, independent NAV verification, SOC 1 controls, or the annual audit, and a named human signs every NAV. Not accounting, audit, or investment advice.
Daily Fund NAV Tie-Out is the starting point. On a free AI audit we map where it fits your stack and what consultance.ai would build around it.
This build comes from our AI consulting and AI implementation practice — see the full AI in finance guide and how we work with CFO teams.