Family office AI prompt

Holding statement

A downloadable statement of every position, grouped by entity.

For
COO, MFO/advisor
Topic
Principal briefings
The prompt
Copy

Build a holding statement for [Client 1] at [month-end]: every position by investment vehicle with quantity, price, market value and share of the total, as a document I can download.

Example output · Claude with Masttro connected
Example answer from Claude connected to Masttro MCP: a downloadable statement of every position, grouped by entity

Illustrative output based on Masttro's demo family office data.

What to look for
1
Every position

Quantity, price, market value and currency at month-end.

2
Grouped by entity

Positions listed under the investment vehicle that holds them.

3
Downloadable

Built as a document you can save and send.

Before you run it

Replace [Client 1] with the client or family and [month-end] with the statement date.

Ask next

Follow-up prompts

Add each position’s year-to-date return.

Copy

Make a version for [JW Foundation] only.

Copy

Export it as a spreadsheet.

Copy
Why it's useful

Why generate holding statements with AI?

Clients and trustees ask for statements in different formats and at short notice. Producing a clean, grouped statement usually means exporting data and formatting it by hand.

This prompt builds the statement from month-end positions in Masttro, with each position's share of the total, and returns it as a document.

01
On demand

A statement whenever someone asks for one.

02
Grouped and totaled

Clear by entity, with share of the total.

03
Flexible formats

Follow-ups add returns or export a spreadsheet.

FAQ

Questions about this prompt

What does the statement include?

Every position at month-end with quantity, price, market value, currency and entity, plus its share of the total.

Can I download it?

Yes. The prompt asks for a document, and a follow-up exports it as a spreadsheet.

Can I add performance?

Yes. The first follow-up adds each position's year-to-date return.

Is it an official statement?

No. It is built from Masttro data for convenience. Official custodian statements remain the record.

Masttro MCP

Run this prompt on your own Masttro data

Connect Claude or ChatGPT to the data you consolidate in Masttro. Read-only, scoped to each person's permissions, and switched on by your Super Admin.

Claude or ChatGPT
You paste the prompt here
Your AI tool
Masttro MCP
Applies your Masttro permissions
Read-only
Your Masttro data
Holdings, transactions and performance across every entity