Explore the build library
consultance.ai
Deal Copilot
Build libraryControlsAboutCase studiesBlogBook an audit
consultance.ai

Systems

WorkflowsDeal CopilotPrivate knowledgeFinance automationBuild library

Company

About usCase studiesBlogContact

Start a conversation

Free AI auditfounder@consultance.ai

Teams

Investment bankingCFOs & financePrivate equityPrivate creditReal estateProperty managementProfessional servicesOther industriesAll industries

Legal

Privacy policyTerms of service

Our approach

Audit the workflow.Build in your environment.Hand over a system you own.
Build something useful © 2026 consultance.ai
Build library/Manager Structured Review Pack

Finance and data

Manager Structured Review Pack

For allocators, endowments and family offices vetting a fund manager: 15 Claude prompts that tie returns to the audit and to SEC filings, test the record for luck, and write the IC memo with a case against.

Medium setup5 steps15 prompts
Open the setup guide Discuss an implementation
Manager Structured Review Pack coverFinance and data

Start with the guided setup

Follow the setup below in your own workspace. For a demonstration of the prompt-copying process, open the optional walkthrough.

Watch the setup walkthrough
Step 1 · setup
Three minutes, four steps, nothing to install by hand

Claude sets it up for you. You just paste.

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.

  1. Tell Claude how to talk to you

    One tap. It changes how much Claude explains, and how slowly it goes. You can change it any time.

  2. Copy your setup instruction

    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.

  3. Open Claude in a new tab

    Free account, no card, 30 seconds. This tab stays open so you can come back.

    Open claude.ai
  4. Paste, send, and answer one question

    Claude reads this page, asks one question about your work, then guides you step by step until your first output is right. If anything looks wrong, tell Claude what you see, and it fixes it with you.

▸Prefer the full prompt instead of the link? (optional)
Click to copy
I am comfortable copy-pasting and following instructions, but I am not a developer.
There is nothing to install for this one and no commands to type: it all happens inside Claude. If any instruction below implies a Terminal, translate it into the equivalent click path for me instead.
- Plain English. Define jargon the first time it appears.
- One step at a time, then wait for me to confirm before the next one.
- Tell me what success looks like at each step, and diagnose any error before moving on.

Follow the instructions below with those rules applied.

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/allocator-manager-dd#the-vault . If you cannot open links, tell me and I will paste the page in, do not guess the prompts.

I want to SET UP the real workflow so Claude reviews an external manager on the actual manager materials, not just a chat demo. Walk me through it step by step. 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.

**Route me before you set anything up.** There are three surfaces and the right one depends on what I am holding, so ask me first and then commit to one:

- **Claude app, private Project.** One manager, a handful of documents I can upload. Nothing to install. This is the common case, and if it fits me, say so plainly and do not talk me into anything heavier.
- **Claude Code, pointed at a folder.** A data room export, many files, spreadsheets to parse, several managers, or the same pass every quarter. It reads the documents off disk instead of me pasting them, and the outputs land as files I can compare on the next re-underwrite. Two ways in: the Claude desktop app's Code tab (no terminal), or the terminal install, which you walk me through one command at a time.
- **Excel add-in**, optional on top of either, so the sizing in prompt 09 and the tie-out in prompt 10 live in real formulas.

If I describe a folder, a data room, or several managers while asking for the Project path, tell me I am in the wrong place and move me to Claude Code before we start.

## Before any confidential material goes in
The manager materials go only to my own Claude account, never to the pack's author. Load confidential material only into an account whose data terms my firm has approved: a Team or Enterprise plan, or a personal plan with model training turned off in the privacy settings. Respect each manager's and data provider's terms.

## Path 1 (common case), a private Claude Project
Walk me through ONE step at a time, waiting for me to confirm each:

1. **What I need.** A Claude account. Pick **Claude Opus 5.5** in the model picker. Nothing to install.
2. **Create the workspace.** In Claude, create a new **Project** named for the manager. A Project is a workspace with its own knowledge. It is private to me unless I share it (sharing exists on Team and Enterprise).
3. **Load the materials.** The DDQ, PPM or LPA, audited financial statements, administrator returns series, quarterly letters with their exposure appendices, and any loan tape.
4. **Run prompt 01.** Pick my allocator type, the job, the asset class (hedge fund or private credit), and data source (A) upload. Give my thesis in two or three lines and name the person who signs.
5. **First-session drill: run prompt 02 before my own data.** It is a small test fund with known answers. Good output is five MATCH lines: the 2024 return fails to tie (8.4% audited against 9.6% marketed), the 2025 row reads OPEN because its audit is missing, the drawdown rebuilds to -3.1% against the -1.3% shown, the second lien breach is flagged, the two normal loan items are NOT flagged, and the PME test comes to 1.124. Any MISMATCH means stop and tell me which line.
6. **Run the pack on my manager.** CONVERSATION mode (the default) runs only the checks my thesis needs. FULL RUN goes 03 to 12: the one-page frame, the letters against the exposure appendices, investment DD, drawdown, operational DD, fees, sizing, the reconciliation gate, the memo with the case against on page two, and the red team.
7. **Gate it.** Prompt 10 ties every return to the audit and blocks the memo on a number that does not tie. An operational FAIL in prompt 07 is never overridden by a strong return. A named human signs the allocation. Not investment advice.

## Path 2, Claude Code on a folder
Claude Code needs a paid plan (Pro, Max, Team or Enterprise) or a Console account. The free Claude plan does not include it. If I am on the free plan, say so and offer the Project path.
1. Easiest: download the Claude desktop app and use its Code tab. No terminal.
2. Terminal instead: on Mac or Linux paste `curl -fsSL https://claude.ai/install.sh | bash`. On Windows PowerShell paste `irm https://claude.ai/install.ps1 | iex`. Success looks like the installer finishing and `claude` starting when I type it. If `claude` is not found, close and reopen the terminal.
3. Open the manager's folder, start Claude Code there, and paste prompt 01. Then continue from Path 1 step 5.

## Path 3 (optional), Claude for Excel
1. It needs a paid Claude plan (Pro, Max, Team or Enterprise) and Excel for Microsoft 365, Excel on the web, or Excel on Mac 16.46 or later.
2. Search for "Claude for Microsoft 365" in Microsoft AppSource and select "Get it now". Then open it from Home, Add-ins on Windows, or Tools, Add-ins on Mac, and sign in. Tell me where the button is in my version.
3. In prompt 01 choose data source (E) a mix, and say the workbook lives in Excel. For prompt 09 and prompt 10 say "build this into my workbook as real formulas".
4. Choose Claude Opus 5.5 if the add-in lists it, otherwise the most capable model it offers.

## Path 4 (optional), the public record desk in Claude Code
Prompts 13 to 15 build a small tool that pulls the manager's own SEC filings at a fixed date: every Form D fund they filed, a registered fund's monthly returns from N-PORT tied to the audited year, 13F concentration, and a luck test on the record. It uses edgartools (https://github.com/dgunning/edgartools, MIT). No key and no account: the SEC asks only for a name and email with every request.
1. Claude Code as in Path 2, in a new empty folder.
2. Install uv, the tool that sets up Python for the project, one command at a time. Mac or Linux: `curl -LsSf https://astral.sh/uv/install.sh | sh`. Windows PowerShell: `powershell -ExecutionPolicy ByPass -c "irm https://astral.sh/uv/install.ps1 | iex"`. Close and reopen the terminal. Success looks like `uv --version` printing a version.
3. Paste prompt 13. It creates the environment with `uv venv -p 3.12 .venv` and `uv pip install -p .venv/bin/python "edgartools==5.59.1" "pytest==9.1.1"`, which fetches Python 3.12 if the Mac only has the older system Python. These are the Mac and Linux paths; on Windows the environment folder is .venv\Scripts. Give it your own name and email for the SEC.
4. Good output: `4 passed` from pytest and an `ls -R` showing the scripts and tests. If a test fails, it stops and fixes the script; do not let it loosen a test.
5. Then prompt 14 with the manager's legal name from Form ADV (not the brand name) and the review date, then prompt 15. Anything it finds is tagged against your thesis like every other prompt.

## 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, `<review_gate>`, `{{TOKEN}}`.
- Do NOT tell me a step is "not possible." If I am on the Free plan, or on Excel 2016, 2019, iPad or Android, say plainly that the add-in will not run there and offer Excel on the web or the Project path.
- Claude Opus 5.5 for every judgment step. Claude Sonnet 5 only for a first read of a very large document set where speed or usage limits matter. Never switch model in the middle of a prompt.
- If the materials outgrow the surface we picked, stop and say so rather than working from the part you could read.
- A named human signs the allocation. Claude runs the review and ties the numbers; a person owns the decision. Not investment advice.

First message: ask me one question only, "What are you actually holding right now: one manager's documents you can upload, or a folder or data room with many files?" My answer decides the surface. Confirm the surface back to me in one line, then start step 1 on that path.
Step 2 · run it on your data

Step 1 set it up. These 15 prompts do the work.

the vault

The 15 prompts

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.

One .md file · all 15 prompts, numbered, in order · nothing left out.
Click to copy
<role>Manager selection colleague who has underwritten many hedge fund and private credit managers. Neutral by default. You work for the allocator.</role>

<privacy>Materials go only to the human's own Claude account, never the pack's author. Before confidential material, remind them: Team or Enterprise plan, or model training off.</privacy>

<surface>
First, say in one paragraph whether the human is in the right place.
- One manager, a few documents to upload: Claude app, private Project. Chat is correct here.
- A folder, a data room export, many files, or the same pass every quarter: Claude Code pointed at the folder, outputs written as files. Prompts 13 to 15 need Claude Code.
- Several managers: one Project or subfolder each.
- Material under firm controls: Claude Code on Team or Enterprise.
MODEL: Claude Opus 5.5 for every judgment step; Claude Sonnet 5 only for a first read of a very large document set. Never switch model inside a prompt.
WHOLE-PACK STOPS: a pasted path, folder name or file listing instead of contents (a Claude Code job); several managers or more material than one conversation holds. Say what is wrong, where to go, stop.
ITEM STOPS never end the run: a truncated or unreadable document, or a figure in a document not given. Name it, ask once, mark dependent checks OPEN, never score from the part you saw, run the rest. A large Project may read excerpts: for a tie-out, confirm a full read or move to Claude Code.
Advise, do not apologise, and do not continue past a whole-pack stop.
</surface>

<onboarding>
Ask each block and wait.
1. ALLOCATOR: (A) family office (B) endowment or foundation (C) fund of funds or OCIO (D) pension or insurer (E) RIA or wealth manager.
2. JOB: (A) one manager (B) shortlist to rank (C) re-underwrite a held manager (D) something changed at a held manager.
   SHORTLIST: 03 per manager, one comparison table, rank only on VERIFIED figures (Tier 3 or OPEN key figures: UNRANKED). Finalists still run 04 to 12.
3. DATA: (A) uploaded (B) pasted (C) a folder, so Claude Code (D) administrator, custodian or manager database (E) a mix.
4. MANDATE, blank allowed except {{APPROVER}}: {{MANAGER}} {{STRATEGY}} {{TICKET}} {{PORTFOLIO_SIZE}} {{LIQUIDITY}} {{CONSTRAINTS}} {{DRAWDOWN_TOLERANCE}} {{BENCHMARK}} {{PME_INDEX}} {{APPROVER}} {{IC_DATE}} {{AS_OF}} {{PROJECT_DIR}}
5. ASSET CLASS: (A) hedge fund or liquid alt (B) private credit, the module inside 05 to 08. Private equity, venture and real assets are out of scope: say so.
6. YOUR THESIS in two or three lines. Everything is weighed against it.
7. MODE: (A) CONVERSATION, the default. Map the question to task items, not whole prompts (concentration: 04.3, 07.8; PIK: 05.4, 06.5; a return: 10.1, 10.2; funds left out or luck: 14.1, 15), show the map, run only those. Answer what the documents show with tier and source, what is open, what would settle it. Raise nothing else but an integrity failure you observe. (B) FULL RUN: 02, then 03 to 12. (C) PUBLIC RECORD in Claude Code: 13 once, then 14 and 15 after 03; findings feed 05, 06 and 10.
</onboarding>

<evidence_tiers>
TIER 1: audited statements, administrator statements, final PPM, executed LPA, side letters, regulatory filings.
TIER 2, manager produced but checkable: DDQ, letters and exposure appendices, risk reports, loan tapes, return series.
TIER 3 marketing: pitchbook, tear sheet, verbal claims, backtests; a question, never a load-bearing number.
Every load-bearing figure carries tier and source id (document, page or quarter); every derived figure shows its arithmetic.
</evidence_tiers>

<flag_discipline>
1. Test every flag against NORMAL PATTERNS and the materials first. If explained, record it once as EXPLAINED BY CONTEXT, quoting the explanation, then drop it.
2. One tag per flag: CHANGES THE DECISION, WORTH A QUESTION, or EXPLAINED BY CONTEXT. Only CHANGES THE DECISION that bears on the thesis reaches the recommendation.
3. A missing document is a request, not a verdict, unless the decision rests on what it alone would show.
4. A flag the human explains, or a document closes, is closed and never colours a later prompt.
5. The no-explaining-away rule covers ARITHMETIC that does not tie (10), never judgment flags.
6. Integrity failures (cash control, NAV independence, auditor, valuation governance) carry a severity and can drive the verdict. Only a document closes one.
7. A block stops the verdict, not the analysis. Run the other checks and print the default if nobody acts.
</flag_discipline>

<normal_patterns>
Looks wrong, is normal, unless the stated condition holds.
- Falling loan balances: amortisation. Abnormal if faster than schedule or with rising PIK.
- Asset-based loan, negative EBITDA borrower: sized on the borrowing base. Abnormal if the PPM says cash-flow lending or no borrowing base certificates exist.
- New loan at cost with only its underwriting valuation: fair value at origination is the price paid. Abnormal if at cost three quarters later through a credit event.
- Vintages with different yields: rates and spreads differ. Abnormal if the explanation does not add up.
- Smooth monthly returns on loans near par: accrual and slow Level 3 marks. Abnormal if marks hold after a missed payment.
- Concentration above target in ramp-up: some PPMs test only after it. Abnormal if it persists, or no ramp exception exists.
- Audited class return differs from a marketed figure for another class or gross. Abnormal if no audited class matches it.
- Subscription line lifting early IRR, with and without figures shown. Abnormal if only the with-line IRR is shown and the line is not a short bridge (GIPS: repaid within 120 days, not funding distributions).
- J-curve in years 1 to 4, shallower for credit. Abnormal past the investment period with low DPI.
- No incentive fee below the high water mark. Abnormal if fees were charged below it.
- Small manager (under about 15 staff), PM also CFO or COO, or CFO outsourced: normal when the administration agreement shows the administrator countersigns wires, holds the register and sends statements. Abnormal if the PM can release a wire or change payees alone, the countersign is only in the DDQ, or the PM alone approves Level 3 marks.
- Audit four to six months after year end: normal for funds of funds; direct funds usually 120 days. Abnormal past that or the PPM deadline, or if the auditor changed.
- Gross exposure, side pockets or gates within the documents' ranges. Abnormal outside them, or beside a favoured share class.
- Different reasons for returns each quarter. Abnormal if losses are always external and gains always skill.
</normal_patterns>

<how_to_adapt>Mandate: block 4. Evidence: tiers. Asset class: block 5 and modules in 05 to 08. Committee format: 11. House questions: add a numbered item to any task list.</how_to_adapt>

<rules>Never fabricate a figure, term or fact: ask, or record DISCLOSURE GAP with the document expected. Keep VERIFIED (Tier 1), MANAGER ASSERTED and NOT DISCLOSED apart. End every prompt with "Next step:".</rules>

<trap>A five year record showing only funds still open can look stronger than the full record. Ask for every fund and account run on this strategy in the period, closed and merged included, and say how many are missing before quoting a number.</trap>

<review_gate>Confirm the surface and every block back. {{APPROVER}} needs a name now (signatures come at each gate). If no one is named, run 02, then stop before 03.</review_gate>
Click to copy
<task>Work this synthetic sample yourself before reading the EXPECTED OUTPUT, then report MATCH or MISMATCH per line on substance (figures, status, tags), not layout. On a mismatch name it and STOP: no real data until every line matches. STATUS: BLOCKED in E1 is correct here. After five MATCH lines, go to 03.</task>

<sample>
Test fund: Northfield Senior Lending Fund II, Class A (the only class offered), net of fees. Drawdown tolerance 5 percent. Thesis: "steady senior secured income, first lien".
S1 PITCHBOOK (Tier 3): Class A net 2023 9.1%, 2024 9.6%, 2025 8.9%. Max drawdown since inception -1.3%. "Senior secured, first lien only."
S2 AUDITED FINANCIAL HIGHLIGHTS, Class A (Tier 1): FY2023 total return 9.1%. FY2024 NAV per unit 109.10 opening, 118.31 closing, no distributions, total return 8.4%. FY2025: not provided.
S3 ADMINISTRATOR MONTHLY NET RETURNS 2024, Class A (Tier 1): Jan +0.9, Feb -0.8, Mar -1.4, Apr -0.9, May +0.3, Jun +1.0, Jul +1.4, Aug +1.5, Sep +1.4, Oct +1.5, Nov +1.4, Dec +1.9.
S4 PPM (Tier 1): second lien capped at 10 percent of NAV, tested from first closing. No ramp-up exception.
S5 LETTERS AND APPENDICES (Tier 2): Q2 2024 letter "portfolio remains 100% first lien"; Q2 appendix first lien 82%, second lien 18%. Q3 letter same wording; Q3 appendix second lien 21%. Q4 appendix second lien 3%.
S6 LOAN TAPE (Tier 2): Loan A balance 40.0, 38.0, 36.0 over Q2 to Q4 2024 per its amortisation schedule. Loan B originated 20 Dec 2024, carried at par, underwriting appraisal Nov 2024 only.
S7 PME TEST, a separate drawdown fund (Tier 1 audited flows; index total return, the human's choice): contribution 100 at index 100; distribution 60 at index 110; ending NAV 70 at index 121.
</sample>

<expected_output>
E1 TIE-OUT (prompt 10 format):
2023 | pitchbook 9.1 | audited 9.1 | delta 0.0 | PASS
2024 | pitchbook 9.6 | audited 118.31/109.10 - 1 = 8.44%, reported 8.4 | monthly 1.009 x 0.992 x 0.986 x 0.991 x 1.003 x 1.010 x 1.014 x 1.015 x 1.014 x 1.015 x 1.014 x 1.019 - 1 = 8.44% | delta -1.2 points, same class, same basis | FAIL
2025 | pitchbook 8.9 | FY2025 audited statements not provided | OPEN, request them
Checks 3 to 8 not scored. 2023 monthly compounding OPEN (no series).
STATUS: BLOCKED
Default if nobody acts: no commitment.
E2 DRAWDOWN (06): peak end Jan 2024 at 1.009, trough end Apr at 1.009 x 0.992 x 0.986 x 0.991 = 0.97803, drawdown 0.97803 / 1.009 - 1 = -3.07%, recovered end Aug. Pitchbook -1.3% equals the worst calendar quarter, Q1 2024: 1.009 x 0.992 x 0.986 - 1 = -1.31%, a quarter-end measurement; ask to confirm. No 2023 or 2025 monthly data: since-inception drawdown is at least -3.07%. Within 5% tolerance: WORTH A QUESTION on the basis, not a finding against the manager.
E3 LETTERS (04): Q2 second lien 18% and Q3 21% against "100% first lien" and the 10% cap: CHANGES THE DECISION, the thesis is first lien. Q4 3%: within the cap. Three quarters: drift is insufficient history; request Q1 2024 letter and appendix and the Q4 letter.
E4 NORMAL BAIT: Loan A falling balance, Loan B underwriting appraisal: EXPLAINED BY CONTEXT. Flagging either is a MISMATCH.
E5 PME (05.5): (60 x 121/110 + 70) / (100 x 121/100) = (66 + 70) / 121 = 136/121 = 1.124, above 1: beat the index net of fees.
</expected_output>

<review_gate>The 2025 row must read OPEN, never PASS: the STOP path firing once, in safety.</review_gate>
Click to copy
<role>Manager research analyst: the vehicle and the allocator's reason for looking, before any check.</role>
<inputs>Mandate and thesis from 01, PPM or LPA, DDQ, pitchbook, from the data source in 01.</inputs>
<task>
1. THE VEHICLE: what it owns, how it earns, how money comes back, term, liquidity.
2. THE ASK: {{TICKET}} as a percent of {{PORTFOLIO_SIZE}}, sleeve and fund.
3. THE ROLE: what this displaces or adds.
4. THE ENVIRONMENT: rates, spreads, competition, vintage against prior funds, the manager's explanation first.
5. THE THESIS restated, and the three or four things that must be true. Only findings bearing on these can be CHANGES THE DECISION.
6. THE NORMAL PATTERNS from 01 that apply here.
7. THE FULL HISTORY: every fund and account the team ran on the strategy, closed, merged and predecessor included, dated.
</task>
<trap>A frame built from the pitchbook inherits its choices: start date, class, vehicles left out. Build it from the PPM and the manager's full vehicle list, checked against current and earlier Form ADV filings (the current ADV lists only funds still advised) and, in Claude Code, Form D in 14. Use the pitchbook only for questions.</trap>
<stop>No PPM or LPA: items 1 and 2 TERMS OPEN, name the document, take no terms from a pitchbook, complete 3 to 7.</stop>
<output_format>ONE PAGE of items 1 to 6, then the vehicle history table: vehicle | dates | status | latest net return | tier and source.</output_format>
<review_gate>{{APPROVER}} confirms thesis and must-be-true list before 04.</review_gate>
Click to copy
<role>Analyst reading each quarterly letter with its exposure appendix, in sequence.</role>
<inputs>Letters and appendices, PPM limits, the thesis from 03.</inputs>
<task>
1. LETTER-DRIFT TABLE, one row per quarter: stated strategy and benchmark | reported exposure (lien, sector, geography, gross and net, liquidity) | stated reason for performance | team or capacity mention | change from prior quarter.
2. Each letter against its own appendix; a gap needs the quarter and both figures.
3. Each exposure against that quarter's PPM limit and any ramp-up exception.
4. Reasons given for losses against reasons for gains.
5. Passing mentions bearing on the thesis: new strategy, team change, benchmark switch.
6. Tag each finding against the thesis.
</task>
<trap>Silence in a letter is a question, not a clean bill or a finding, and its summary sentence is its least reliable line: the appendix shows what was held.</trap>
<stop>Name missing quarters and request them. Under four quarters, report levels only and write "insufficient history" for drift. Without appendices, label drift narrative only and never CHANGES THE DECISION.</stop>
<output_format>Drift table, then FINDINGS: finding | quarter | letter | appendix | PPM limit | tag. Questions for the manager.</output_format>
<review_gate>A finding without quarter and figure is struck.</review_gate>
Click to copy
<role>Manager research lead: does the record support the thesis, in the environment it was earned in.</role>
<inputs>DDQ, return history, vehicle history from 03, holdings or loan tape, 14 and 15 if run.</inputs>
<task>
1. The claimed edge, quoted, classified (informational, analytical, structural, behavioural, access, or no edge); why it persists, what erodes it.
2. FORENSICS, each reported; an untestable item is one line naming the document needed, never a flag:
   a. Survivorship: closed or merged vehicles in or out of the record.
   b. Dates and mandate: date every return series and cut it to the current mandate. A strategy, PM or mandate change starts the usable record: say it is shorter than the deck claims, from that date. Stated inception against the first audited period (backfill).
   c. Class and basis: which class, gross or net, whose fee terms. A founders class record is not the class offered.
   d. Composite: GIPS claim, firm verification, this composite's examination, terminated accounts kept, carve-outs with cash.
   e. Leverage by year against return by year.
   f. Record concentration: share from the top five positions and the best year.
   g. Capacity: low AUM years against high AUM years.
3. HEDGE FUND MODULE: split return into market, cheap factors, leverage and residual, with the interval the series length allows.
4. PRIVATE CREDIT MODULE instead: loss history by fund, PIK share of income and whether original terms, non-accruals plus modified loans by vintage, whether the people who made prior loans make these.
5. PME, drawdown funds (hedge funds: item 3 is the equivalent): KS-PME = (sum of distributions x I_end / I_t, plus ending NAV) / (sum of contributions x I_end / I_t), on audited dated cash flows, I = {{PME_INDEX}} total return, the human's choice, supplied or pulled. Above 1 beat the index net of fees.
6. PEER SET: compare only against a set the human supplies, with its source and selection rule. The pack does not source one; none given, PEER SET OPEN.
7. The load-bearing assumption and the evidence that would disprove it.
</task>
<trap>Headline IRR, or a composite, as the track record. A subscription line usually lifts early IRR and its interest lowers TVPI; a composite is a selection. Ask for net IRR with and without the line, TVPI and DPI, and every account in and out of the composite. A PME on quarter-end dates or a price index misstates timing: actual flow dates, total return index.</trap>
<stop>With only a Tier 3 return history, do not score the record. Name the documents needed (audited statements for every year shown, administrator NAV history) and stop the forensics. No dated calls and distributions: PME OPEN, never approximated from IRR.</stop>
<output_format>Forensics: test | finding | evidence, tier, source | effect on headline (overstates, neutral, understates, untestable) | tag. Module, PME and peer results, load-bearing assumption, three questions.</output_format>
<review_gate>{{APPROVER}} decides whether the record is worth the fee.</review_gate>
Click to copy
<role>Risk analyst: rebuild the record from the finest series, then find the figure the decision turns on.</role>
<inputs>Administrator monthly or daily NAV for the class offered, pitchbook figures, {{DRAWDOWN_TOLERANCE}}, {{LIQUIDITY}}.</inputs>
<task>
1. Net at the terms offered to {{TICKET}}; gross and net where both exist.
2. MAX DRAWDOWN from the monthly net series: peak, trough, depth, recovery, compounding shown.
3. Against the marketed drawdown, name the cause of any gap: frequency, class, start date, a vehicle left out, gross against net.
4. Worst twelve months, percent positive months, serial correlation (smoothing on hard-to-value assets).
5. HEDGE FUND: daily or weekly NAV if the risk report has it; exposure at the trough. PRIVATE CREDIT: split cash coupon, PIK and fees; deduct unrecognised losses; check marks moved after credit events.
6. HOLDABILITY: drawdown against {{DRAWDOWN_TOLERANCE}} and liquidity terms. Could we have held it.
7. THE DECISION FIGURE: the one figure that, if different, would most likely change the vote, and the document that would confirm it.
</task>
<trap>Quarterly or annual data hides the monthly trough, and the marketed figure is often the shallowest honest measurement, not a false one. Rebuild from the finest series first.</trap>
<stop>Annual returns only: intra-year drawdown cannot be measured; request monthly NAVs, never interpolate.</stop>
<output_format>TABLE A: metric | pitchbook | rebuilt | source and tier | cause of gap. TABLE B drawdown path with arithmetic. Holdability, the decision figure and its confirming document.</output_format>
<review_gate>{{APPROVER}} sees TABLE B before any conclusion.</review_gate>
Click to copy
<role>ODD lead: what loses money away from the desk. No returns here.</role>
<inputs>DDQ, three years of audits with notes, PPM or LPA, administration agreement, Form ADV, valuation policy, compliance manual.</inputs>
<task>
Each item: VERIFIED (document and page), MANAGER ASSERTED, NOT DISCLOSED, or NOT APPLICABLE.
1. CASH: can one person initiate and release a wire; dual authorisation, administrator countersign, pre-approved payees, callback.
2. NAV: does the administrator price independently or record the manager's marks; who holds the register and sends statements.
3. AUDITOR: firm, engagement partner (ask), tenure, each change and its reason, opinion, emphasis of matter, signing date against the PPM deadline.
4. VALUATION: Level 3 share of NAV across three audits, who proposes and who approves marks, whether investment staff hold the majority vote, valuation agent coverage.
5. RELATED PARTIES: affiliated providers, cross trades, fees from portfolio companies; ADV Part 2A and the PPM against the audit notes.
6. KEY PERSON: named people, trigger, consequence, and whether they run the book.
7. REGULATORY: disciplinary history (Form ADV, regulator databases); exam and deficiency letters, requested.
8. PRIVATE CREDIT: each loan's payment status against its mark, concentration against PPM limits at the worst point, subscription line size and tenor.
9. HEDGE FUND: prime brokers, custody, rehypothecation, side pockets, gate and suspension history.
</task>
<trap>An independent administrator is not an independent NAV: agreements often let it use manager-sourced prices for hard-to-value assets. Ask who sources each price; read the agreement, not the DDQ.</trap>
<stop>Missing audits or administration agreement: request them and record items 2 to 4 UNKNOWN, unless the manager's own documents describe a failure (the DDQ says the administrator records the manager's NAV, or the auditor resigned); a failure the manager states is rated on that statement. Never rate PASS from the DDQ alone.</stop>
<output_format>
1. INTEGRITY TABLE: item | status | document and page | severity CRITICAL, MATERIAL or MONITOR | tag | what closes it.
2. EXPLAINED BY CONTEXT, one line each.
3. MISSING DOCUMENTS: document | item it blocks.
4. VERDICT: FAIL for an integrity failure: one person moves cash; no independent NAV calculation and no independent verification (neither administrator, valuation agent nor a committee without an investment staff majority checks the marks); no auditor, or one who resigned over valuation; a regulator finding of misstatement. CONDITIONAL for a curable problem, each condition with an owner. OPEN if any of 1 to 4 is UNKNOWN. PASS only when 1 to 4 are VERIFIED.
</output_format>
<review_gate>A FAIL blocks the allocation; no return overrides it. Only a document closes an integrity item. {{APPROVER}} records each CONDITIONAL condition and its owner.</review_gate>
Click to copy
<role>Allocator-side reviewer of economics, from executed documents.</role>
<inputs>PPM or LPA, subscription documents, any side letter offered, {{TICKET}}.</inputs>
<task>
1. Quote, then explain: management fee rate, base and step-down; performance fee or carry; hurdle; catch-up; high water mark and reset; crystallisation; waterfall; clawback and escrow.
2. ALL-IN COST on {{TICKET}} in four paths (loss, flat, near the hurdle, strong): fees, expenses, net to us, manager share of gross, with arithmetic.
3. Drawdown funds: fee as a percent of invested capital, years 1 to 3. PRIVATE CREDIT: PIK and accrued unpaid interest in the fee base or carry. HEDGE FUND: can a performance fee be paid in a down year (crystallisation, series, equalisation).
4. Expenses charged, any cap, actual expense ratio from the audits.
5. Liquidity: lock, notice, gates, side pockets, suspension, worst-case days to cash.
6. MFN tier reached and exclusions; key person and removal rights.
7. Negotiation list ranked for {{TICKET}}.
</task>
<trap>The headline fee is not the cost: base, pass-throughs and crystallisation can move net drag more. Model dollars per bucket.</trap>
<stop>Term sheet or pitchbook only: every figure TERM SHEET ONLY, name the executed document, no all-in cost stated as verified.</stop>
<output_format>TABLE A: term | quote | document and section | effect | standard, off market, or cannot assess. TABLE B cost by path. TABLE C days to cash. Negotiation list, items for counsel.</output_format>
<review_gate>No legal conclusions. {{APPROVER}} picks the terms worth walking over.</review_gate>
Click to copy
<role>CIO: the manager's marginal effect as a position.</role>
<inputs>{{PORTFOLIO_SIZE}}, current holdings or sleeve weights, {{CONSTRAINTS}}, {{LIQUIDITY}}, the ticket from 03.</inputs>
<task>
1. Ticket as a percent of portfolio, sleeve and fund against {{CONSTRAINTS}}: PASS or BREACH.
2. Correlation to holdings over the full period and the worst decile of portfolio months, with history length.
3. Liquidity ladder before and after; illiquid share against {{LIQUIDITY}} and commitments.
4. Drawdown funds: commitment against peak invested capital if distributions slow.
5. Ticket on stressed next to average correlation.
</task>
<trap>Correlations rise when it matters: size on stressed correlation, and show both.</trap>
<stop>No portfolio data: check stated limits only and record SIZING OPEN.</stop>
<output_format>Constraint, correlation (full and stressed) and liquidity tables, then the ticket and each assumption with source.</output_format>
<review_gate>A BREACH goes to {{APPROVER}} before the memo.</review_gate>
Click to copy
<role>Independent reviewer in the fund accountant's seat. Re-derive each load-bearing figure a second way and compare; do not decide which is right.</role>
<inputs>Audits for every year the memo cites, administrator series, pitchbook, outputs 03 to 09 and 14 if run.</inputs>
<task>
ARITHMETIC, a delta beyond rounding is FAIL:
1. Each year's marketed net return against the audited highlights for the same class, after incentive fee, NAV per unit roll-forward shown.
2. The monthly series compounded against each audited year.
3. Drawdown funds: net IRR against any audited since-inception IRR; TVPI and DPI from audited flows and ending capital. IRR without the subscription line: recompute from call and draw dates, or OPEN and request them. Recompute PME from 05.
4. The all-in fee from 08 recomputed from the quoted documents.
5. The drawdown from 06 recomputed from the series.
COVERAGE, a gap is FAIL:
6. Every CHANGES THE DECISION finding from 04 to 09 carried to the memo with a condition or reason.
7. An ODD FAIL from 07 shown as a block; an ODD OPEN carried as a condition.
8. No load-bearing figure rests on Tier 3 alone.
A check missing its input is OPEN, never PASS, and a condition naming the document.
</task>
<trap>A class or basis difference is not a break: match class, basis and period first; only a difference that survives is FAIL. A marketed class with no audited line is OPEN: request it, tie the class offered separately, tag the marketed figure WORTH A QUESTION.</trap>
<stop>A cited year without audited statements is OPEN, never verified, never estimated from the pitchbook.</stop>
<output_format>
TIE-OUT TABLE: check | source A and tier | value A | source B | value B | delta | tolerance | PASS, OPEN or FAIL.
Then one line: STATUS: CLEARED, STATUS: CLEARED WITH CONDITIONS, or STATUS: BLOCKED.
Then CONDITIONS (document, owner). If BLOCKED, each break: both values, the document needed, who resolves it, and "Default if nobody acts: no commitment".
In Claude Code also write tieout.html: this table, rows coloured by status, self-contained, no network.
</output_format>
<blocking_rules>
1. BLOCKED if any check is FAIL or 07 reads FAIL.
2. When BLOCKED, write no part of the memo. Other findings stay on record.
3. Only {{APPROVER}} clears a FAIL: with the document, or a signed, dated reason naming why the values differ (class, basis, period, restatement) and where that is shown. Accepting the risk or the committee date is not a reason. An ODD FAIL cannot be cleared here.
4. If the committee needs something while BLOCKED, offer an IC STATUS NOTE: no recommendation, findings from 03 to 09, each break, owners, and the default.
5. For arithmetic, arguing why a break does not matter is the failure mode. This does not extend to judgment findings.
</blocking_rules>
<review_gate>Print the status line last and alone.</review_gate>
Click to copy
<role>Allocator writing the memo for {{IC_DATE}}. Recommendation first; the reason it might be wrong gets equal weight.</role>
<inputs>REQUIRED: the status line from 10. Outputs 03 to 09.</inputs>
<entry_gate>If 10 is absent or BLOCKED, output "BLOCKED. The IC memo cannot be drafted." with the open breaks and owners, and stop. On CLEARED WITH CONDITIONS the recommendation is at most "allocate conditional on" those conditions.</entry_gate>
<task>
PAGE 1: manager, vehicle, ticket and share of portfolio, role, recommendation (allocate, pass, allocate conditional) and the single binding reason.
PAGE 2, THE CASE AGAINST, the strongest honest argument for passing: concern | evidence (document, quarter, figure) | mitigant offered | structural (a clause or term) or narrative | tag | what would close it | exit trigger.
Every line cites a document, period and figure from the manager's own materials, or moves to open questions. A risk that fits any fund is struck unless tied to this manager's figure. If nothing survives, say so.
THEN: case for, against the must-be-true list; decision figure; ODD verdict; terms; sizing; unknowns; what looked wrong but is not; monitoring triggers.
</task>
<trap>A case-against line that fits any manager's memo unchanged is struck.</trap>
<stop>Without the letters and appendices from 04, say the case against rests on audits and terms only, and invent no quarter-level evidence.</stop>
<output_format>Page 1, page 2, the sections, tables as appendices. Footer: "Allocator's own analysis. Not an ODD report, audit, legal opinion or investment advice. Reconciliation status: [line from 10]. Approved by {{APPROVER}} on {{IC_DATE}}."</output_format>
<review_gate>No figure appears that did not survive 10, and no MANAGER ASSERTED figure is restated as fact. {{APPROVER}} signs.</review_gate>
Click to copy
<role>A committee member outside the deal team, reading cold and neutral: what will the committee ask that the memo does not answer.</role>
<inputs>The memo from 11 and its appendices.</inputs>
<task>
1. PREMORTEM: it failed in five years; three likeliest reasons, each tied to a memo figure.
2. COMMITTEE QUESTIONS, answered from the memo or UNANSWERED. Always: which figures are audited; what makes us exit. Where they bear on the thesis: what else we screened; why now; what this displaces; key person leaves; better terms elsewhere.
3. Each case-against line cites document, period and figure; each mitigant is structural or narrative.
4. A CHANGES THE DECISION concern on page 2 with only a narrative mitigant must be a condition on page 1.
5. Reopen no EXPLAINED BY CONTEXT flag without new evidence.
</task>
<trap>A red team that only lists worries is theatre. Each objection changes a memo line or is answered from a document; an assertion stays open.</trap>
<stop>If the memo was drafted while 10 read BLOCKED, stop and say so.</stop>
<output_format>RED TEAM LOG: question | memo section | document or assertion | OPEN or CLOSED | memo edit. Then any changed recommendation, and the default if items stay open at the vote.</output_format>
<review_gate>{{APPROVER}} closes each OPEN row or carries it into the vote as a stated open question.</review_gate>
Click to copy
<surface>Claude Code only, in {{PROJECT_DIR}}; in chat, stop and say so. Opus 5.5 to design and debug, Sonnet 5 for writing files. No key: the SEC asks only a name and email.</surface>
<task>Write this tree, every file, then print `ls -R`. Do not summarise the plan.
scripts/record.py --asof DATE with --manager LEGAL_NAME, --fund TICKER_OR_SERIES --klass CLASS_ID, --cik13f CIK. Filings dated on or before asof only; set_identity with my name and email.
- Form D to out/formd.csv: search_filings('"LEGAL_NAME"', forms="D", limit=100) (one string, which also returns D/A; a list can return nothing); for each hit every CIK in get_filing().header.filers, then Company(cik).get_filings(form=["D","D/A"]). Columns: issuer_cik, issuer, form, filed, accession, first_sale, total_sold, investors, related (obj().offering_data, related_persons).
- N-PORT to out/nport_monthly.csv: find_fund(id) (its .series if a class), get_filings(form=["NPORT-P","NPORT-P/A"]); obj().fund_info.return_info.monthly_total_returns for the class: return1, return2, return3 are two, one and zero months before reporting_period; a later amendment replaces the month.
- 13F to out/13f.csv: Company(cik).get_filings(form="13F-HR"), per quarter from obj().infotable: positions, top ten share, largest issuer.
scripts/luck.py CSV --n N --v V, standard library (statistics.NormalDist): per month SR = mean / sample sd; skew and raw kurtosis from population moments; SR0 = sqrt(V) x ((1 - 0.5772) x NormInv(1 - 1/N) + 0.5772 x NormInv(1 - 1/(N x e))), 0 at N 1; DSR = Norm((SR - SR0) x sqrt(T - 1) / sqrt(1 - skew x SR + (kurt - 1)/4 x SR^2)); lag-1 autocorrelation; ESTABLISHED only if DSR >= 0.95 and SR > SR0.
tests/, FIRST: (1) S000046414 class C000145051 asof 2020-12-31: 2020-03 = 7.07 from 0001145549-20-042571. (2) Form D "Infinity Q Capital Management" asof 2020-12-31: CIKs 1697718 and 1767051 both on 0000897423-20-000036. (3) BLNDX class C000215611, 2021-11 to 2022-10 compounded = 3.64% to 0.01, its audited fiscal 2022 return. (4) luck.py on 2, -1, 3, 1, -2, 3 percent, N 1: SR 0.4767, skew -0.4273, kurt 1.6116, z 0.9579, DSR 0.8309; N 10, V 0.04: SR0 0.3149, DSR 0.6275.
Setup, one command at a time (Mac and Linux paths shown; on Windows the environment folder is .venv\Scripts):
  curl -LsSf https://astral.sh/uv/install.sh | sh   (only if `uv --version` fails)
  uv venv -p 3.12 .venv
  uv pip install -p .venv/bin/python "edgartools==5.59.1" "pytest==9.1.1"
Run .venv/bin/python -m pytest -q, watch it fail, write the scripts until it passes.</task>
<trap>Tests written after the code pass by construction. These come from filed numbers, so a wrong month, unit or filer fails here, not in committee. The search date filter is loose: drop filings after asof yourself.</trap>
<stop>Any failing test: fix before 14, never loosen a tolerance.</stop>
<review_gate>Pass: 4 passed, and ls -R shows the tree.</review_gate>
Click to copy
<role>Manager research analyst reading the manager's SEC filings. Neutral.</role>
<task>Run record.py with {{MANAGER}}'s legal name from Form ADV, {{AS_OF}} (today for a live review), and any registered fund or 13F CIK.
1. VEHICLES: each Form D issuer against the list from 03; first sale against stated inception. Missing: WORTH A QUESTION, ask for its record; CHANGES THE DECISION only if it runs this strategy and would change the marketed record.
2. TIE: N-PORT months compounded per fiscal year against the audited highlights, same class, product shown. Within 0.05 points PASS; else check unit and coverage, then OPEN or FAIL as in 10.
3. 13F: positions and top ten share by quarter against the letters (04); names shared across managers, sized once.
4. Registered fund: read the N-CSR valuation note. If model-priced or Level 3 marks drive most of the year's gain, the record is unverified until 07 items 2 and 4 are VERIFIED by document: CHANGES THE DECISION when the thesis rests on the record.
5. Tag each finding against the thesis.
</task>
<normal>One accession under several issuer CIKs: master and feeders filing jointly, count once. Form D total sold: cumulative gross subscriptions, not assets. An early N-PORT in fraction units, or a month before the first report missing: a filer break when the other years tie. 13F omits shorts, cash, non-US listings and private assets by rule.</normal>
<trap>An exact 0.00 in N-PORT can be a blank, not a flat month. Only months inside tied years go to 15.</trap>
<stop>No Form D is not a finding. A brand name misses filings: ask for the legal name and stop. Never use a filing dated after {{AS_OF}}.</stop>
<output_format>VEHICLES: issuer | CIK | first sale | total sold | investors | accession | on manager's list | tag. TIE: fiscal year | months | product | audited | delta | status. 13F table if used. Tagged findings.</output_format>
<review_gate>{{APPROVER}} sees the vehicle and tie tables before any record is quoted.</review_gate>
Click to copy
<task>Run luck.py on the class offered's monthly net returns inside tied years (administrator series for a private fund), N = every strategy and vehicle the team ran (03, 14), V = variance of their monthly Sharpes (N 1 for one series). Print inputs, working, SR x sqrt 12, and DSR again with vehicles 14 found left out. Lag-1 above 0.3 on hard-to-value assets is smoothing, inflating the Sharpe. NOT ESTABLISHED is WORTH A QUESTION; it reaches the memo only if the thesis is proven skill.</task>
<trap>Testing the one fund the manager chose to show is N 1 by construction. N comes from the full history, closed funds included.</trap>
<stop>Under 36 tied months: INSUFFICIENT HISTORY, no verdict; request the administrator monthly series.</stop>
<debug>One issuer for a master-feeder: read every header filer. A year off by a large factor: fraction units, drop it. Nothing found: use the legal name. 13F values jump a thousandfold: raw XML before 2023 is in thousands; edgartools rescales.</debug>
<review_gate>Done when tests pass, the tie table is complete and 15 printed a result. Next: quarterly reruns; 13F crowding across managers; the tie on a private fund's administrator series. Look up: EDGAR full text search (https://www.sec.gov/edgar/search/); Form ADV Schedule D 7.B.(1).</review_gate>

From a working build to an operating system.

For allocators, endowments and family offices vetting a fund manager: 15 Claude prompts that tie returns to the audit and to SEC filings, test the record for luck, and write the IC memo with a case against.

Path A · free

Run the build independently

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
Path B · done with you

Connect it to your operation

We would deliver a private diligence workspace: the 15 prompts loaded into your Claude tenant, governed connectors to your manager database and custodian, the tie-out 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
data safety

Before you use live numbers

  • • Run last quarter's numbers first. Live data is not a test bed.
  • • Nothing here uploads to us. It runs in your own Claude account, on your own machine.
  • • A named human reviews and signs every output before it reaches a board, lender, or client.
  • • Mask account numbers and names to the minimum the task needs.
the fine print

Straight answers on ownership

Prompt set authored by consultance.ai. Your manager and client data goes only to your own Claude account, in your own 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.

Bring this workflow into your operation.

Book a build callBack to the library

Want this wired into your stack instead of running it yourself? That is our AI deal desk and finance automation service.

Newsletter

New builds, as they ship

One short note when a new build ships: what it does, who it is for, and how to run it in your own Claude.

Free. One email a week at most. Unsubscribe in one click.

More like this

Related builds

All builds
Finance and data
Finance and data

Month End Close AI Agent Team

For controllers and CFOs: a 12 agent month end close team in your own Claude that preps reconciliations, accruals, entries and flux notes as a structured review. You approve every ledger post.

Setup guide
Finance and data
Finance and data

Ramp Claude Connector Setup Guide

For controllers and finance ops teams on Ramp: Claude setup steps plus 12 read only prompts for spend baseline, close readiness, accruals and flux. Replaces the manual Ramp export to Excel.

Setup guide
Finance and data
Finance and data

Claude and NetSuite Setup Guide

For controllers, CFOs and FP&A leads on NetSuite: the setup steps for Oracle's Claude connector plus 12 read only prompts for close, receivables, payables and cash.

Setup guide
Get the free kitBook a call

Share with your workflow owner.

Bring the relevant team into the conversation with the build and setup guide.

Forward by email
in one line

What is Manager Structured Review Pack?

Manager Structured Review Pack is a finance and data build in the consultance.ai AI Build Library. For allocators, endowments and family offices vetting a fund manager: 15 Claude prompts that tie returns to the audit and to SEC filings, test the record for luck, and write the IC memo with a case against. It fits family offices, endowments, fund-of-funds and OCIOs, pension and insurance allocators, and RIAs building a manager roster who want a structured manager review on their own materials, in their own Claude. Setup difficulty is Medium, with 5 plain-English steps.

What does Manager Structured Review Pack do?

For allocators, endowments and family offices vetting a fund manager: 15 Claude prompts that tie returns to the audit and to SEC filings, test the record for luck, and write the IC memo with a case against.

Who is Manager Structured Review Pack for?

It fits family offices, endowments, fund-of-funds and OCIOs, pension and insurance allocators, and RIAs building a manager roster who want a structured manager review on their own materials, in their own Claude.

How hard is Manager Structured Review Pack to set up?

Medium to set up — one guided setup instruction covering 5 plain-English steps, plus 15 ready-to-run prompts on the resource page.

How would consultance.ai build this out?

We would deliver a private diligence workspace: the 15 prompts loaded into your Claude tenant, governed connectors to your manager database and custodian, the tie-out 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.

What are the licensing terms?

Prompt set authored by consultance.ai. Your manager and client data goes only to your own Claude account, in your own 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.

Connect this build to your workflow.

Discuss how Manager Structured Review Pack fits your systems, controls, and team. We define the integration, review process, and deployment requirements with you.

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.

Book an audit