Finance and data
Allocator Manager DD Pack
Manager due diligence built inside Claude on your own materials, for the price of a Claude seat instead of a $500,000 OCIO retainer. 9 prompts screen the manager universe, run the investment DD and the operational DD, attribute performance net of fees, size the allocation against your roster, review the fees and terms, tie every number out, and write the IC memo. The work a family office runs over a quarter before funding a manager, in days.
Rent it forever, or own it once.
Manager due diligence built inside Claude on your own materials, for the price of a Claude seat instead of a $500,000 OCIO retainer
Path A
Set it up yourself
The setup prompt and 9 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 private diligence workspace: the 9 prompts loaded into your Claude tenant, governed connectors to your manager database and custodian, the screen and sizing wired to your roster and risk budget, your DDQ and IC memo built to your committee's format, and review gates so no allocation reaches committee unchecked. 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 manager due diligence on the actual manager materials, not just a chat demo. Walk me through it step by step, do not skip the install. Treat me like an allocator or family-office CIO 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 manager documents (recommended) and an optional Excel add-in for the screen and the sizing math.
## Path 1 (RECOMMENDED) — a private Claude Project for the diligence
This is where the DDQ, pitchbook, audited financials, returns series, and terms 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 **Opus 4.8**. Nothing to install for this path.
2. **Create the diligence workspace.** In Claude, create a new **Project** named for the manager or the mandate. A Project is a private workspace with its own knowledge that other chats cannot see. Your manager materials and client data stay in your own tenant.
3. **Load the materials.** Drop the DDQ, pitchbook, audited financials, the monthly returns series, and the offering/terms documents into the Project knowledge. For a roster review, load each manager's pack or summarize the key files.
4. **Run the vault.** Run prompt 01, pick your allocator type, what you are vetting, and data source (A) upload (or (D) connector if you pull from Albourne / Morningstar / a manager database under governed access). Run 02 to 09 in order: universe screen, investment DD, operational DD, performance attribution, portfolio sizing, fees and terms, the reconciliation self-check, and the IC memo.
5. **Gate it.** Run prompt 08 before the memo. The ODD fail (prompt 04) is absolute — a strong return never overrides an operational red flag. Any reconciliation FAIL is a number to fix, not a footnote.
6. A named human signs the allocation. This is a working tool, not investment advice.
## Path 2 (OPTIONAL) — Claude for Excel add-in for the screen and sizing
If I want the manager screen and the portfolio sizing 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 (screen) and prompt 06 (sizing) say "build this into my workbook as real formulas," so the screen ranks and the allocation recomputes and the prompt 08 tie-out runs on live cells.
4. Pin **Opus 4.8** for the DD, sizing, and memo.
## Rules for walking me through this
- One step at a time. Define every term once: Project, knowledge, DDQ, ODD, administrator, high-water mark, side letter, beta vs alpha, `<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 PII or a manager's confidential materials into a public Claude window outside a Project. Use a Project with your tenant controls; respect each data provider's and manager's terms.
- A named human signs the allocation. Claude runs the diligence and ties the numbers; a person owns the decision. Not investment advice.
First message: ask me "Path 1 (Claude Project for the manager materials, recommended) and do you also want Path 2 (Excel add-in for the screen and sizing)? And are you vetting one manager, ranking a shortlist, or building a full portfolio?" Then start step 1.Step 2
Step 1 installed it. Now run these 9 prompts on your own data.
the vault
The 9 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. Cambridge Associates, Mercer, Bridgewater, and BlackRock are referenced as the standard the pack matches, no affiliation implied. Your manager and client data stays in your own Claude tenant; we never see it. Respect each manager's and data provider's terms. This is not investment advice; a named human signs every allocation before capital is committed.
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.