At quarter close, portfolio data, benchmarks and commentary blocks assemble themselves into a branded report pack for every client, with an AI-drafted performance summary each advisor reviews and approves. What used to consume a full week now takes one afternoon.
Typical results
1 afternoon
Quarterly reporting cycle
120+
Report packs per quarter
2 days
Quarter-end to dispatch
0
Data errors reaching clients
Figures reflect typical results for this kind of automation.
The challenge
Every quarter, the firm's advisors lost a week to reporting: exporting positions from the custodian, rebuilding charts in Excel, pasting numbers into Word templates, and writing a hundred-plus individual summaries. Late nights produced inconsistent packs, copy-paste errors occasionally reached clients, and the people paid to manage money spent days doing document production instead.
Before and after
Reporting effort per quarter
−90%Quarter-end to dispatch
−83%Data errors reaching clients
−100%The automation
We built a pipeline that triggers on quarter close: portfolio holdings, performance figures and benchmark data are pulled from the custodian feed, charts and tables are generated automatically, and each client's branded pack is assembled from approved commentary blocks. OpenAI drafts a personalized performance summary in the firm's voice, and every pack lands in an approval queue where the advisor reviews, tweaks and signs off; approved packs are dispatched and filed to the client vault.
How it works
- 01
Data pulled
On quarter close, holdings, performance figures and benchmark data are pulled from the custodian and market feeds.
- 02
Pack assembled
Charts, tables and approved commentary blocks drop into the firm's branded template, one pack per client.
- 03
AI drafts the summary
OpenAI writes a personalized performance summary for each client in the firm's tone of voice.
- 04
Advisor approves
Each pack lands in an approval queue where the advisor reviews, tweaks and signs off in minutes.
- 05
Dispatched and filed
Approved packs go out by branded email and a copy is filed to the client's document vault.
Starts from
- Portfolio data feeds
- Benchmarks & holdings
Delivers
- Branded report packs
- Advisor approval queue
- Client dispatch
The impact
The quarterly reporting cycle collapsed from a full week to a single afternoon of review and approval, and packs now reach clients two days after quarter-end instead of twelve. Copy-paste errors disappeared, every report carries the same polish, and advisors reinvested the recovered week into client meetings and portfolio work.
Questions about this automation
Where does the portfolio data come from?
At quarter close, the flow pulls holdings, performance figures and benchmark data from the custodian feed and market data sources. Charts and tables are generated from those numbers directly, so no figures are copied by hand. Commentary comes from a library of approved text blocks that the firm maintains and updates.
Does the AI summary go to clients without review?
No. OpenAI drafts each client's performance summary in the firm's tone, and every pack then lands in an approval queue. The advisor reads, edits and signs off before anything is sent. Packs that are not approved stay in the queue, so nothing reaches a client without an advisor's sign-off.
How are approved packs delivered and stored?
Once approved, each pack goes to the client by branded email, and a copy is filed to the client's document vault with a consistent name and quarter label. The firm keeps a clear record of which version each client received. This is a multi-step build, usually rolled out in stages, starting with the data pulls and charts.