Finance and data
Fund NAV Close Pack
Strike the monthly fund NAV in-house instead of paying an administrator basis points on AUM for a 10 to 15 day close. 17 prompts (13 core plus 4 bonus) strike the NAV from the blotter, reconcile to the prime broker and custodian, book the management and performance fees with the high-water mark math, run the investor allocation waterfall, reconcile every LP capital account, work the breaks, draft the investor letter, build the LP statements, and assemble the audit binder. The work an administrator charges bps on AUM to run, on your own books, in your own Claude. Plus a live admin-fee savings calculator.
🔥 optional · live interactive tool
Open the Admin Fee vs In-House Savings Calculator
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.
Rent it forever, or own it once.
Strike the monthly fund NAV in-house instead of paying an administrator basis points on AUM for a 10 to 15 day close
Path A
Set it up yourself
The setup prompt and 13 task prompts are below — free. The cost is your time, and the risk of wiring it wrong on live data.
Jump to the prompts ↓Path B
We wire it into your business
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 →Step 1
Paste this setup prompt — Claude installs it for you
Easy mode · paste this into Claude
Claude installs it for you, step by step.
Never used Claude before? It is free to start. Open it in a new tab, copy the prompt, paste it in. It asks one question, then walks you through everything.
- Step 1Open claude.ai ↗
Sign up free. No card. Takes 30 seconds.
- Step 2
One click. Lands on your clipboard.
- Step 3Paste + send
Claude asks what you need + guides you the rest of the way.
▸Tune the prompt for your level (optional)
▸Preview the prompt (you do not need to read it)
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.Step 2
Step 1 installed it. Now run these 13 prompts on your own data.
the vault
The 13 prompts
Tap a prompt to jump to it. Hit copy. Replace the tokens. Paste into Claude Opus 4.7.
where it breaks
Before you connect live data
- • Run dummy data first. Real client data is not a test bed.
- • API keys never go in a public repo. Use env vars and a secrets manager.
- • Add logging, access control, monitoring, and a rollback path before launch.
- • Read the license. Forking a repo without checking is how lawsuits start.
license note
Credit the original author
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.
the newsletter
AI news worth opening.
The AI tools, launches, and shifts that actually matter, in plain English. New library drops the moment they land.
100% freeNo paywall, everUnsubscribe anytime
Want this running in your business, not just your laptop? We build it and hand you the keys.
More like this
Other builds worth a weekend
Finance and data
Setup guide →Fincept Terminal
Kill your Bloomberg envy with a free download. Live stocks, bonds, crypto, and 37 AI agents that pick like Buffett, Munger, and Lynch.
Finance and data
Setup guide →Finance Reporting Pack — Claude vs the BI stack
AI now builds financial reporting that rivals JPMorgan analysts, packaged as 12 prompts your finance team runs on its own data. Board P&L packs, 3-statement models, variance commentary, KPI scorecards, cash forecasts, and consolidations, for the price of a Claude seat instead of Power BI plus Tableau plus a BI hire. Plus a live Reporting Stack Spend Calculator.
Finance and data
Setup guide →Firefly CFO Trust Ladder
No CFO trusts AI with company books on day one. Firefly III plus Claude is the trust ladder. Personal books first. Real reps. Then the company.