17 prompts that run your monthly fund NAV close in-house, so COOs and controllers reconcile, book fees, run the LP waterfall, and draft investor letters without a fund administrator.
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.
I want to INSTALL the real setup so Claude runs the monthly NAV close on my actual fund books, not just a chat demo. Walk me through it step by step, do not skip the install. Treat me like a fund controller or COO 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 NAV strike, the reconciliations, and the fee math.
## Path 1 (RECOMMENDED) — a private Claude Project for the close
This is where the trade blotter, prime broker and custodian statements, general ledger, and LP register 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 **Opus 4.8**. Nothing to install for this path.
2. **Create the close workspace.** In Claude, create a new **Project** named for the fund and the period. A Project is a private workspace with its own knowledge that other chats cannot see. Your blotter, statements, GL, and LP register stay in your own tenant.
3. **Load the records.** Drop the trade blotter, the prime broker and custodian statements, the GL or trial balance, the LP register, 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/VC, fund of funds, family office), and data source (A) upload (or (D) connector if you pull from an administrator portal, prime broker feed, or fund-accounting system under governed access). Run 02 to 13 in order: strike the NAV, reconcile to the broker and custodian, book the fees, run the waterfall, reconcile the capital accounts, work the breaks, draft the letter, build the statements, re-derive the numbers a second way as a self-check, sign off, accrue expenses, and assemble the audit binder.
5. **Gate it.** Treat prompt 10 (the reconciliation self-check) and prompt 11 (the controller sign-off) as hard gates. Any red item or any self-check FAIL blocks publication. The person who strikes the NAV is not the only one who reviews it. A named human signs the NAV, a prompt cannot.
6. **Parallel run first.** Run the close alongside your administrator for one or two cycles and tie your NAV to theirs within tolerance before you trust it or change anyone's scope. See the 90 day rollout in the bundle.
## Path 2 (OPTIONAL) — Claude for Excel add-in for the strike, recon, and fee math
If I want the NAV strike, the reconciliations, and the fee schedule to live in real formulas:
1. In Excel (Microsoft 365 desktop or web): **Home** or **Insert** tab, **Add-ins** / **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 (NAV), prompt 03 (reconciliation), and prompt 04 (fees) say "build this into my workbook as real formulas," so the NAV recomputes, the breaks list updates, and the high-water mark math runs on live cells.
4. Pin **Opus 4.8** for the strike, the fee and allocation math, and the sign-off.
## Rules for walking me through this
- One step at a time. Define every term once: Project, knowledge, NAV, trade blotter, prime broker, custodian, administrator, high-water mark, hurdle, waterfall, capital account, equalization, Level 3, SOC 1, `<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 administrator's and data providers' terms.
- This moves the labor in-house. It does not replace independent NAV verification, SOC 1 controls, or the annual audit. Read the audit and compliance overlay before you reduce your administrator's scope. 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 NAV strike and fee math)? 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.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.
Browser-based. No signup. Drop in your numbers and see the trade in real time. Opens in a new tab so the prompts stay where you left them.
17 prompts that run your monthly fund NAV close in-house, so COOs and controllers reconcile, book fees, run the LP waterfall, and draft investor letters without a fund administrator.
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 ↑We would deliver a deployed close workspace: the prompts loaded into your Claude tenant, governed connectors to your prime broker, custodian, and fund-accounting system, the NAV strike and fee math wired to your terms, a parallel-run tie-out against your administrator, segregation-of-duties review gates, and an auditor-ready PBC binder. Done with you, then handed over so you own it.
Book a build call →Prompt set authored by consultance.ai. SS&C, Citco, State Street, and Northern Trust are referenced as the administrator standard the pack matches, no affiliation implied. Your fund and investor data stays in your own Claude tenant; we never see it. This moves the labor in-house, it does not replace independent NAV verification, SOC 1 controls, or the annual audit; 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 founders, CFOs, and deal teams: 9 Claude prompts that rebuild the cap table from the signed documents instead of the spreadsheet, run the waterfall clause by clause against the actual LPA or charter, and recompute fee and carry independently, so a stale sheet gets caught before a round closes on it.
For CFOs and finance leaders: the map of seven finance desks, deal, diligence, close, tax, underwriting, family office, and market, each one a free prompt vault that runs inside your own Claude, plus the order to install them in so a team actually adopts them.
For CFOs and controllers: 11 Claude prompts that run the month end close reconciliation itself, match bank and subledgers both directions, catch the account that will not foot, and draft the flux memo, so a 6 day close lands in 2.
The person drowning in this every week is the one who'll actually want it.
In-House Fund NAV Close is a finance and data build in the consultance.ai AI Build Library. 17 prompts that run your monthly fund NAV close in-house, so COOs and controllers reconcile, book fees, run the LP waterfall, and draft investor letters without a fund administrator. It fits hedge fund COOs, PE and VC fund CFOs, fund controllers, emerging managers, and family office finance leads paying an administrator basis points on AUM for the monthly NAV close. Setup difficulty is Medium, with 4 plain-English steps.
17 prompts that run your monthly fund NAV close in-house, so COOs and controllers reconcile, book fees, run the LP waterfall, and draft investor letters without a fund administrator.
It fits hedge fund COOs, PE and VC fund CFOs, fund controllers, emerging managers, and family office finance leads paying an administrator basis points on AUM for the monthly NAV close.
Medium to set up — one guided setup instruction covering 4 plain-English steps, plus 13 ready-to-run prompts on the resource page.
We would deliver a deployed close workspace: the prompts loaded into your Claude tenant, governed connectors to your prime broker, custodian, and fund-accounting system, the NAV strike and fee math wired to your terms, a parallel-run tie-out against your administrator, segregation-of-duties review gates, and an auditor-ready PBC binder. Done with you, then handed over so you own it.
Prompt set authored by consultance.ai. SS&C, Citco, State Street, and Northern Trust are referenced as the administrator standard the pack matches, no affiliation implied. Your fund and investor data stays in your own Claude tenant; we never see it. This moves the labor in-house, it does not replace independent NAV verification, SOC 1 controls, or the annual audit; a named human signs every NAV. Not accounting, audit, or investment advice.
In-House Fund NAV Close 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.