PROPOSED PROJECT
Investor Report Builder
Turn approved investment tables and analyst notes into quarterly charts and draft investor updates. Keep every figure linked to its spreadsheet cell, and flag explanations or required details that the reporting team needs to check.
The number. The story. The source.
Draft for reporting review
Quarter-end
portfolio value
₱107mValue includes money added and withdrawn. This is not a rate of return.
A report that can
show its workings.
A fictional quarterly reporting team starts with a ₱100m portfolio value. Its approved table records ₱8m of subscriptions, ₱3m of redemptions, ₱2.4m of market movement, and ₱0.4m in fees. The closing value is ₱107m. The report shows the movements and source cells, and holds back a sentence about technology shares because no supporting breakdown was supplied.
WHAT IS USUALLY DONE
The reporting team copies figures into slides, redraws charts, and rewrites last quarter’s commentary. When a workbook changes, the team must find every affected number and sentence. A polished report can still contain an old figure or an explanation the source notes never supported.
WHAT SOVRUN CAN DO FOR YOU
Sovrun would build a report workspace around the firm’s approved workbook and report template. Document models identify tables and supporting analyst passages; software reads the exact values, reconciles the totals, and builds editable charts. AI drafts commentary with links to those values and notes. A revised workbook highlights affected figures and paragraphs for the reporting lead before export.
The explanation
has to earn its place.
AI can draft the commentary, but a fluent sentence does not make a financial explanation true. The review view separates verified figures from explanations that still need evidence.
Summary sheet
- B4 · Opening
- ₱100,000,000
- B5 · Subscriptions
- +₱8,000,000
- B6 · Redemptions
- −₱3,000,000
- B7 · Market movement
- +₱2,400,000
- B8 · Fees
- −₱400,000
- B9 · Closing
- ₱107,000,000
The exported chart and the draft text use these same cells.
Keep the fact.
Question the reason.
“Portfolio value closed at ₱107m. Net subscriptions were ₱5m.”Supported by B5, B6 and B9
“Technology shares drove the quarter’s gains.”No sector breakdown or analyst note supplied. Leave out of the draft.
Open request: the reporting lead still needs to supply the approved explanation of market movement.
A report pack.
With the trail intact.
A first build connects one approved workbook format, analyst notes, and the firm’s report template. The reporting lead receives these three connected outputs.
₱107m
Portfolio value at quarter end
Includes net subscriptions of ₱5m. Not a rate of return.
Follow any number.
- Closing value
- Summary!B9
- Net subscriptions
- B5 + B6
- Market movement
- Summary!B7
- Workbook
- Quarterly / v3
Still needed.
- Approved market commentary
- Required report sections
- Reporting lead’s sign-off
No automatic release to investors.
How we’d make it happen.
Connect the approved sources
Agree on one workbook format and report template. Read the original cell values and record their units, dates, and versions before drafting any commentary.
Draft from checked figures
Reconcile the tables with code, build charts, and draft text tied to the source cells and analyst notes. Leave unsupported explanations on the review list.
Review the complete report
The reporting lead checks the draft, resolves missing sections, and approves the export. A new workbook version flags affected content for another review.
Where AI helps
We compare document and language models on the client’s own difficult tables, negative numbers, units, and analyst notes. The selected models identify evidence and draft explanations. Workbook formulas and tested code calculate every figure; the model cannot invent a return, explain a movement without evidence, or replace a missing value with zero.
What people approve
The reporting lead approves the source workbook, reporting basis, chart labels, commentary, and required disclosures. The team checks whether a value includes subscriptions or withdrawals before describing performance. Only an approved version is released; this project does not select investments or send investment advice.
What we’d need to start
- Approved investment tables with workbook versions, units, reporting dates, and cell references
- Analyst notes with permission to use them and any required report sections
- The firm’s editable report template, reviewer roles, and release process
How we’d test it
Check every displayed number against its source cell and reproduce each calculation independently. Test updated workbooks, blank cells, negative values, duplicate tables, changed units, and unsupported explanations. Confirm that a cash-flow-inclusive value change is never labeled as an investment return. Compare report preparation time and corrections with the team’s current process.
Prepared for Financial services. We would agree on the work after reviewing your brief, materials, and requirements.
This is a proposed project, not completed client work. The visuals and numbers show example outputs, not measured results.
