For family offices and CFOs vetting a wealth advisor: 11 Claude prompts that pull the all-in fee, unstack the fund fees under the headline rate, model the ten-year drag, and write the questions to ask before signing a mandate.
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/advisor-fee-audit#the-vault . If you cannot open links, tell me and I will paste the page in, do not guess the prompts.
I want to INSTALL the real setup so Claude runs the advisor fee audit on the actual advisory agreement, fee schedule, and fund fact sheets, not just a chat demo. Walk me through it step by step, do not skip the install. Treat me like a family-office principal or CFO who has never built a Claude Project or installed an Office add-in, and define every term once.
An honest note before we start: this bundle is about 60% of the build. It gets me to an all-in fee number, a ten-year drag, a benchmark, and a question list on one advisor's documents, run in my own Claude. Consultance wires the last 40% into production: live data off the custodian and the fund database, role-based access so the CFO and the principal see different views, an audit trail counsel will accept, and multi-entity scale across every account. That last 40% is implementation work, a call not a prompt. Set me up for the 60% now; if I want the rest wired live I reply "wire it" for a 30-minute slot.
This is NOT a Terminal or coding install. There is nothing to compile. It is two paths: a private Claude Project for the advisor's documents (recommended) and an optional Excel add-in for the fee model and the drag schedule.
## Path 1 (RECOMMENDED), a private Claude Project for the fee audit
This is where the advisory agreement, fee schedule, fund fact sheets, ADV Part 2A, proposal deck, and statements 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. Pin **Claude Fable 5** for the audit and the modeling. Nothing to install for this path.
2. **Create the audit workspace.** In Claude, create a new **Project** named for the advisor or the mandate. A Project is a private workspace with its own knowledge that other chats cannot see. My statements and fee data stay in my own tenant. Nothing is uploaded to consultance, stored by consultance, or seen by consultance.
3. **Load the documents.** Drop the advisory agreement, the fee schedule, the fund fact sheets or prospectuses, the ADV Part 2A, the proposal deck, and a recent statement into the Project knowledge. If I am comparing two or three proposals, load each one.
4. **Run the vault.** Run prompt 01, pick who is running this, what I am auditing, and where my data lives. Then run 02 through 11 in order: pull the all-in fee, unstack the fund fees, surface the revenue share, model the ten-year drag, RECONCILE (prompt 06), benchmark, write the questions, the one-page memo, the negotiation brief, and the ongoing fee watch.
5. **Gate it.** Prompt 06 is the hard gate. It re-derives the all-in fee a second way and must read STATUS = RECONCILED before I trust the benchmark, the memo, or the questions. A FAIL is a number to fix, not a footnote.
6. A named human signs the decision to sign, negotiate, or pass. This is a working tool, not investment advice.
## Path 2 (OPTIONAL), Claude for Excel add-in for the fee model
If I want the fee stack and the ten-year drag 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 (the fee stack) and prompt 05 (the drag) say "build this into my workbook as real formulas," so the all-in fee recomputes and the prompt 06 reconciliation ties out on live cells.
4. Pin **Claude Fable 5** for the audit, the drag model, and the memo.
## Rules for walking me through this
- One step at a time. Define every term once: Project, knowledge, all-in fee, headline rate, expense ratio, share class, revenue share, 12b-1, ADV Part 2A, breakpoint, `<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 client statements or account numbers into a public Claude window outside a Project. Use a Project with my tenant controls.
- A named human signs the decision. Claude runs the audit and ties the numbers; a person owns whether to sign. Not investment advice.
First message: ask me "Path 1 (a private Claude Project for the advisor's documents, recommended) and do you also want Path 2 (the Excel add-in for the fee model)? And are you auditing one proposal before signing, re-underwriting an advisor you already pay, or comparing two or three side by side?" Then start step 1.
</content>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 family offices and CFOs vetting a wealth advisor: 11 Claude prompts that pull the all-in fee, unstack the fund fees under the headline rate, model the ten-year drag, and write the questions to ask before signing a mandate.
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 ↑The prompts are about 60% of the build. Consultance wires the last 40% into production: live data off the custodian and fund database, role-based access, an audit trail your counsel accepts, and multi-entity scale across every account and vehicle.
Book a build call →Yours to run and adapt on your own advisor documents. A working tool for a professional, not investment advice; a named human owns the decision to sign, negotiate, or pass.
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.
Advisor Fee Audit Before You Sign is a finance and data build in the consultance.ai AI Build Library. For family offices and CFOs vetting a wealth advisor: 11 Claude prompts that pull the all-in fee, unstack the fund fees under the headline rate, model the ten-year drag, and write the questions to ask before signing a mandate. It fits Family offices and CFOs, PE and fund finance leads, and high-leverage principals vetting a wealth advisor before signing a mandate.. Setup difficulty is Medium, with 5 plain-English steps.
For family offices and CFOs vetting a wealth advisor: 11 Claude prompts that pull the all-in fee, unstack the fund fees under the headline rate, model the ten-year drag, and write the questions to ask before signing a mandate.
It fits Family offices and CFOs, PE and fund finance leads, and high-leverage principals vetting a wealth advisor before signing a mandate..
Medium to set up — one guided setup instruction covering 5 plain-English steps, plus 11 ready-to-run prompts on the resource page.
The prompts are about 60% of the build. Consultance wires the last 40% into production: live data off the custodian and fund database, role-based access, an audit trail your counsel accepts, and multi-entity scale across every account and vehicle.
Yours to run and adapt on your own advisor documents. A working tool for a professional, not investment advice; a named human owns the decision to sign, negotiate, or pass.
Advisor Fee Audit Before You Sign 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.