WorkflowInvestment Risk Management

Look-Through Risk Analysis

Look-through analysis that reads every manager report to its holdings and ties each fund to the manager's own NAV

Every manager report read to its holdings, and every figure tied to the manager's own NAV.

See one case, screen by screen ↓
demo89,612linesread from 104 manager reports in 12 languages, each cited to its page
demo3.2%China real estate once looked through, against 0.4% visible at the fund level and a 2.5% limit
target100%of NAV looked through to holdings or labeled as an estimate, every quarter
targetDay 7quarter-end look-through signed by the CIO, not day 23
In short

What is Look-Through Risk Analysis?

Look-through analysis means looking through the funds an investor holds to the securities inside them, so its real exposure to issuers, sectors, countries of risk, currencies and leverage can be measured and tested against limits. Look-Through Risk Analysis does this from each manager's own reports: six agents read every fund and GP report in its original language, map each holding, tie each fund to the manager's NAV, estimate what has not been reported and surface the concentrations only visible after looking through, for the risk analyst, the Head of Investment Risk and the CIO to approve and sign.

AI in asset management: a buyer's guide to agentic AI for investment managers →

Updated

The problem

Why look-through analysis still takes weeks after quarter end

Look-through analysis is how a pension or insurer that invests through external managers sees what it really owns. It holds funds, not securities, so its issuers, sectors, countries of risk, currencies and leverage sit one or two layers down, in each manager's quarterly report, capital account statement or holdings file. Those arrive as PDFs, spreadsheets and the occasional Tripartite Template file, in the manager's own layout and often its own language. Risk analysts do the fund look-through by hand: they key the holdings, map them to the security master, tie each fund back to the NAV the manager reported, and roll forward the funds that have not reported yet.

The risk sits in what nobody had time to see. A developer registered in the Cayman Islands is mapped by domicile instead of country of risk, so a China property exposure never shows. It is the classic fund of funds risk: an issuer held by eleven funds of eight managers stays under every single manager's radar. Tie-out differences are waved through, and last quarter's holdings pass as this quarter's. Under Solvency II, a fund an insurer cannot look through is charged as type 2 equity.

typical49%Solvency II type 2 equity charge on a fund an insurer cannot look through, before the symmetric adjustment
typical~30%NAIC risk-based capital charge for a US life insurer on most equity-like fund interests held on Schedule BA
demo23business daysto sign last quarter's look-through at the example firm
Where a quarter-end look-through's business days goestimated
By hand23 days
With the solution7 days
  • Collecting reports and chasing late managers4 → 2 d
  • Keying holdings from PDFs, in the manager's language7 → 0.5 d
  • Mapping identifier, sector, country of risk and currency4 → 1 d
  • Tying each fund to the manager's NAV3 → 0.5 d
  • Estimating unreported funds and testing limits2 → 0.5 d
  • Committee papers, client files, review and signature3 → 2.5 d

Estimated split for the demo's multi-manager portfolio of 38 managers and 120 funds, by hand and with the solution.

How it works

How a quarter moves

Six agents read, map, tie out, estimate and test every manager report; analysts map, the CIO signs.

What comes in
Manager reports in38 managers, 120 funds · PDFs and files, any language
Agents at work
Reader agentany language, cited
Then
Mapper agentcountry of risk
Checker agenttie to NAV
Then
Gap agentlabeled estimates
Concentration agentlimits and path
Then
Reporting agentpack and client files
A person decides
Analyst, Head of Risk, CIOmap, review, sign
What comes out
Holdings-level risk, cited
Hidden concentrations decided
Insurer and pension files
One case, step by step

One quarter's look-through analysis, worked with the agents

Quillfield Capital's Multi-Asset Portfolio is $14.62B at September 30, 2026, invested through 38 external managers and 120 funds for pension and insurance clients. It is Thursday, October 8, business day 6 of the Q3 close, and the CIO's sign-off is due Friday. Here is what happens next, screen by screen, in the working solution.

  1. 01Thursday morning

    The agents worked overnight; four numbers tell her where the quarter stands

    Claire Dubois · Investment Risk Analyst

    Claire's home screen shows 93.1% of the portfolio looked through ($13.61B from 104 of 120 funds), 6.9% not yet reported and held at a labeled estimate, 3 exposures over a limit that are invisible at the fund level, and 2,148 mappings waiting for a person. Under Needs you, the first item reads: China real estate is 3.2% against a 2.5% limit.

    Concentration agent, 2:15 a.m.: “Overnight: 3 exposures over a limit appear only after looking through; the largest is China real estate at 3.2% against 2.5%. Nine mappings need you before the alert is final.”

  2. 02She asks

    “How much China property do we hold through credit funds?”

    Claire Dubois and the Concentration agent

    On the look-through screen the portfolio unfolds ring by ring, from 38 managers to 120 funds to their holdings, colored by sector, country or currency, with the unreported $1.01B as a gray, labeled wedge. Claire asks in plain words. The agent answers with the path and the pages: $292M through credit funds, $468M in all, and it highlights the ten funds on the chart.

    “Through credit funds: $292M, 2.0% of the portfolio: Valmorel Crédit Opportunités $251M (page 14) and Kittiwake Asia Private Credit III $41M (page 11). With the equity and property funds the total is $468M (3.2%) against a 2.5% limit.”

  3. 03The exposure

    Hidden in a French credit fund, page 14

    Concentration agent · Mapper agent

    The look-through exposure is 3.2% ($468M) against 0.4% ($58M) at the fund level, over the limit by 0.7 points. The path runs through 10 funds of 8 managers; $251M is in Valmorel Crédit Opportunités, whose quarterly report lists nine bonds of Chinese property developers registered in the Cayman Islands and the British Virgin Islands. The French page sits beside the English, line for line.

    Mapper agent: “My confidence is 89–93%, below the 95% needed to approve on my own, so the mapping waits for an analyst. Without it, $251M would sit in ‘Cayman Islands’ and the breach would not show.”

  4. 04One approval

    She approves country of risk China, with a reason code

    Claire Dubois · Investment Risk Analyst

    Claire approves the 9 mappings: $251.0M from the Cayman Islands and the British Virgin Islands to China, real estate, with report page 14 and the security master record as evidence. The reason code is MP-02, country of risk from parent revenue and listing, not domicile. Seconds later the Concentration agent re-tests the limit: the alert is final and goes to Isabel Moreno, and it now appears in the draft committee papers.

    “Signed as Claire Dubois · Investment Risk Analyst · 9:54 a.m. ET · recorded on the audit trail.”

  5. 05The breach

    The checker decides, and signs the decision

    Isabel Moreno · Head of Investment Risk

    Isabel picks one of four decisions: escalate to the investment committee, ask manager research to engage the manager, put on watch, or accept within tolerance, with the rationale in the note. A breach needs a note. She escalates to the October 22 committee and asks Hannah Weiss in manager research to engage Valmorel Gestion; the Reporting agent drafts the engagement note for Hannah to approve and send.

    Until the mapping is approved, her Decide button says why it is locked: “The analyst approves the mapping first (maker), then you decide (checker).”

  6. 06Tie-out

    Every fund tied to the manager's own NAV

    Checker agent · Hannah Weiss, Manager Research Lead

    101 of 104 reported funds tie to the manager's NAV within 2%. Two are escalated to Hannah. Rheinfeld Infrastruktur Fonds II reads €307.6M of holdings against a NAV of €318.4M, −3.39%, and the Checker finds a €10.8M sale receivable on page 31 that closes the gap exactly. Kittiwake Asia Private Credit III is +2.59%, two real estate loans listed at par instead of fair value. A question to each manager is already drafted.

    Checker agent: “I suggest treating it as cash, with the manager’s confirmation.” It never closes a gap itself.

  7. 07A faint scan

    A value it cannot read is marked, not guessed

    Reader agent · Claire Dubois

    Serra Alta Brasil Crédito sent its report by email as a scanned PDF in Portuguese. The Reader read 88 lines and tied them to the NAV within 0.18%, but the gross leverage on page 6 is smudged. It marks the value unreadable and sends it to an analyst, who enters it from the page with a reason code, and the checks run again.

    “Unreadable on page 6 · not guessed.”

  8. 08The gray wedge

    Sixteen funds not yet reported, estimated and labeled

    Gap agent

    Sixteen funds, $1.01B or 6.9% of NAV, mostly private funds that report 45–75 days after quarter end, are held at an estimate under method v2.1, approved by Isabel Moreno. Larkspur Hill Capital Partners VII is $182.0M: its June 30 capital account of $178.9M, plus a $4.2M call, less $2.9M distributed, rolled forward 1.0%. When a report lands it replaces the estimate and the variance is recorded.

    “Last quarter the estimates were within 3.4% of the reported values on average.”

  9. 09Business day 7

    Prepared, reviewed, signed, by three different people

    Claire Dubois, Isabel Moreno and Daniel Okoro

    The sign-off checklist shows what is left: every received report read, mappings over $10M a line decided, tie-out gaps resolved or noted as exceptions, the unreported share estimated and labeled, breaches decided, client files validated. Claire submits, Isabel reviews, and Daniel Okoro, Chief Investment Officer, Multi-Manager, signs the quarter with the investment committee papers the Reporting agent drafted. Last quarter was signed on business day 23.

    “The preparer cannot review or sign. The reviewer cannot sign. The CIO did not prepare or review this quarter. Agents drafted; people decided.”

  10. 10Client files

    One signed look-through, every client's file

    Rajiv Menon · Regulatory Reporting Manager

    From the same signed data, the Reporting agent drafts each client's look-through reporting: the Tripartite Template (TPT) files for Halden Mutual Life (Solvency UK) and Aurelia Assurances Vie (Solvency II, with S.06.03 support), the NAIC look-through support file for Pinecrest Life & Annuity (NAIC risk-based capital) and the exposure report for the Marlow County Employees' Retirement System. Rajiv validates each one (a CIC code on every line, ISIN check digits, holdings that sum to the client's share of NAV, estimates flagged) and prepares it; a second person approves the release.

    The Aurelia file holds 87,102 lines; the estimated share is labeled in the file, 16 funds, 6.9%.

Who it’s for

Built for everyone who signs the quarter.

The same Q3 look-through, seen by five of the people who carry it — what quarter end looked like, and what it looks like now.

CD
Claire DuboisInvestment Risk Analyst · London · prepares the quarter
Investment Risk Analyst
Before
“I can read the French report myself; I just can't key 214 lines a fund for 120 funds.”
Now
Opens a quarter already read, mapped and tied out, and spends her time on the 2,148 lines that need judgment, each with its page beside it.
IM
Isabel MorenoHead of Investment Risk · New York · reviews and decides breaches
Head of Investment Risk
Before
“Show me what we would not have seen at the fund level.”
Now
Gets each hidden concentration with the path through funds and the page behind it, and signs her decision with a reason code.
DO
Daniel OkoroChief Investment Officer, Multi-Manager · New York · signs the quarter
Chief Investment Officer
Before
“If I sign it, I want every number to open its page.”
Now
Signs a look-through he did not prepare or review, with every figure traceable to its lines, mappings and report pages.
HW
Hannah WeissManager Research Lead · New York · owns manager relationships
Manager Research Lead
Before
“Tell me which manager to call and what to ask.”
Now
Receives each tie-out gap over 2% with the Checker's explanation and a drafted question, and approves every message before it goes.
RM
Rajiv MenonRegulatory Reporting Manager · London · prepares client files
Regulatory Reporting Manager
Before
“The insurer needs a CIC code on every line, not a PDF.”
Now
Validates and prepares Tripartite Template, S.06.03 support and NAIC files from the signed look-through; a second person releases them.
Built on the engine

6 agents. Each with one job, and hard limits.

Six agents read, map, tie out, estimate and test every manager report; analysts map, the CIO signs.

Reader agent

Reads every manager report, capital account statement, holdings file and Tripartite Template file in its original language, and extracts each holding, the NAV, cash and leverage, cited to its page.

  • Cites the page for every value
  • Never guesses an unreadable value; it sends it to an analyst
  • Keeps the original wording beside the English
Mapper agent

Maps each line to an identifier, issuer, sector, country of risk and currency against the security master and vendor reference data.

  • Approves on its own only at 95% confidence or more and $25M or less a line
  • Never maps by domicile alone
Checker agent

Ties each fund's extracted holdings to the NAV the manager reported for Quillfield's share, and explains the gap from the report: cash, receivables, accruals, par versus fair value.

  • Escalates every gap over 2% to manager research
  • Never closes a gap itself
Gap agent

Estimates the share not yet reported from the last holdings, market proxies and known capital calls and distributions, and replaces the estimate when the report lands.

  • Every estimate is labeled on every screen, file and report
  • Never presented as reported
Concentration agent

Tests looked-through exposures by issuer, sector, country, currency and leverage against the investment policy and the restricted list, compares them with the fund-level view and explains the path.

  • Never changes a limit or trades
  • Decisions belong to the Head of Investment Risk
Reporting agent

Drafts the investment committee papers, each insurer's Tripartite Template file with CIC codes, S.06.03 support, the NAIC support file and the pension exposure report, validates them, and drafts messages to managers.

  • Drafts only
  • Nothing leaves without regulatory reporting and a second approver
Risk analyst, Head of Risk, CIO, regulatory reporting

Maker, checker, signature, release. The agents propose; a named person decides.

Ask in plain words

Ask the portfolio, in plain words

Ask about total portfolio exposure to any issuer, sector, country or currency, about any manager, fund, mapping or estimate, or say what to do. The agents answer with the path through managers and funds and the pages behind it, and act only with a person's approval.

How much China property do we hold through credit funds?

Through credit funds: $292M, 2.0% of the portfolio: Valmorel Crédit Opportunités $251M (page 14) and Kittiwake Asia Private Credit III $41M (page 11). With the equity and property funds the total is $468M (3.2%) against a 2.5% limit. The ten funds are highlighted on the chart.

Why China and not the Cayman Islands?

The report lists where each issuer is registered: the Cayman Islands or the British Virgin Islands (page 14). Risk follows the business: each parent is listed in Hong Kong and earns 100% of its revenue from mainland China property. The data vendor agrees. That is why the exposure is invisible at the fund level and visible looked through.

What can we do about it?

I do not trade or change limits. The usual options, for Isabel Moreno to decide: escalate to the October 22 committee with a plan; ask manager research to engage Valmorel; reduce the allocation to Valmorel Crédit Opportunités by about $300M to bring the total under 2.5%; or accept with a rationale. Each is recorded with a reason code.

Why does Rheinfeld not tie to its NAV?

The asset list sums to €307.6M against a NAV of €318.4M. Page 31 lists a €10.8M receivable from a sale, which closes the gap exactly. It is with Hannah Weiss to confirm with the manager.

Every screen

The working solution, as it ships.

13 screens from the working solution, on its sample data. Pick one to see it large.

TodayThe quarter-end look-through analysis at a glance: share of NAV looked through, the unreported estimate, hidden concentrations over a limit, mappings waiting, what needs each person and what the agents did overnight.
The look-through, and a questionThe portfolio unfolded from managers to funds to holdings, the exposures visible only after looking through, and the agents' cited answer on China property held through credit funds.
A hidden concentrationThe look-through exposure to China real estate against the fund-level view and the limit, the path through ten funds, and the French manager report page beside the English.
Approving country of riskNine developer bonds mapped from the Cayman Islands and the British Virgin Islands to country of risk China, with the report page, the security master record, a reason code and the analyst's signature.
Deciding a limit breachThe Head of Investment Risk escalates the breach to the investment committee and asks manager research to engage the manager, with a reason code and a required note.
Mappings that need judgmentThe lines the Mapper is unsure of, grouped by reason: country of risk differs from domicile, private companies with no identifier, sector disagreements, identifiers not in the security master.
Tie-out to the manager's NAVEach fund's holdings against the NAV the manager reported, with the Checker's explanation of every gap over 2% and a drafted question to the manager.
A report in PortugueseA scanned manager report beside its English reading, each holding cited, and a leverage figure marked unreadable instead of guessed.
Unreported funds, estimatedThe sixteen funds not yet reported, each held at a labeled estimate with its method, last report date and expected date.
Quarterly sign-offThe checklist, preparer, reviewer and CIO, segregation of duties, and the draft investment committee papers built from the look-through.
Client and regulatory filesTripartite Template files with S.06.03 support, the NAIC look-through support file and the pension exposure report, each validated before release.
Audit trailEvery reading, mapping, tie-out, estimate and decision by people and agents, with the evidence and reason, hash-chained and exportable.
Rules and limitsTie-out tolerance, mapping confidence, approval limits, report due dates and the look-through limits, with a proposed change waiting for the Head of Investment Risk.
Governance

Built for the regulator's questions: cited, signed, on the record.

Every holding cites its pageEach looked-through line opens the manager report page it came from, in the original language beside the English, and every agent statement shows its source and confidence. “Trace this figure” follows any number back to its lines, mappings and pages.
Maker, checker, signatureThe risk analyst maps and submits, the Head of Investment Risk reviews and decides breaches, and the CIO signs the quarter. The preparer cannot review or sign, the reviewer cannot sign, and bulk approvals over $50M need the Head of Investment Risk.
Agents propose; people decideThe agents never sign, release a file, message a manager or a client, change a limit or close a tie-out gap. Locked buttons say why, and every human decision carries a reason code and a note.
Estimates are always labeledThe share not yet reported is a gray wedge on the chart and a labeled line in every file. A signed figure shows how much of it is estimate, and a late report replaces its estimate with the variance recorded.
Client files under maker-checker, kept in regionRegulatory reporting prepares each client file and a second person releases it. EU and UK clients' files are processed and stored in the EU region, US clients' in US East, and manager reports are never used to train models.
A hash-chained audit trailEvery reading, mapping, tie-out, estimate and decision, by people and agents, is recorded with who, what, when, why and the evidence. The chain can be verified, the evidence exported for a regulator or auditor, and each agent's version, and who approved it, is on record.
Configuration

Your investment policy, your thresholds

The rules every quarter is tested against are settings. The administrator proposes a change, the Head of Investment Risk approves it, and both are on the audit trail.

SettingDefaultChoose from
Tie-out tolerance (escalate above)2.0%Gaps above it go to manager research with the Checker's explanation
Auto-approve a mapping at confidence of at least95%Lines below it wait for a risk analyst
Auto-approve limit per line$25MLarger lines always go to a risk analyst
Second approval for bulk approvals over$50MApproved by the Head of Investment Risk
Report dueLiquid funds 10 business days · private funds 45–75 days by fund termsOverdue reports are flagged, with reminders drafted for manager research to approve
Country and sector limit (look-through)2.5% of NAVSet from your investment policy
Single issuer limit1.5% of NAVSet from your investment policy
Private credit leverage, watch level1.75xSet from your investment policy
Connections

Works with the systems a look-through already runs on

Manager reportsquarterly reports, capital account statements and holdings files from manager portals, the risk mailbox, fund administrators and SFTP, in any language
Tripartite Template fileswhere managers send them, read alongside the PDFs
Security master and data vendorsidentifiers, issuer hierarchy, country of risk, sectors and prices
Portfolio accounting and custodianyour holding in each fund, units held and cash
Risk enginea positions feed from the signed look-through, for limits and stress tests
Client deliveryTripartite Template, S.06.03 support, NAIC support and pension exposure files over SFTP
What it changes

The difference, in numbers.

Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.

target
100%
of NAV looked through to holdings or labeled as an estimate, every quarter
every fund
none left at fund level
target
0
tie-out gaps over 2% left unexplained at sign-off
Todaydifferences waved through
With agentseach gap explained or escalated
target
Day 7
quarter-end look-through signed, not day 23

“demo” = seen in the working solution, on its sample portfolio · “target” = the design goal, measured in the live solution · “estimated” = our estimate · “typical” = published figures (Delegated Regulation (EU) 2015/35, Articles 84 and 169 — look-through and the 49% type 2 equity charge before the symmetric adjustment; NAIC life risk-based capital — about 30% for most equity-like Schedule BA interests; EIOPA template S.06.03; FinDatEx Tripartite Template). Day 23 is the example firm's last-quarter baseline. People, firms, managers, funds, issuers and clients named on this page are fictional — characters and sample data in the working solution.

Questions

What risk teams ask about look-through analysis.

What is look-through analysis?

Look-through analysis means looking through the funds an investor holds to the securities inside them, so its real exposure to issuers, sectors, countries of risk, currencies and leverage can be measured and tested against limits. Look-Through Risk Analysis does this from each manager's own reports: six agents read every fund and GP report in its original language, map each holding, tie each fund to the manager's NAV, estimate what has not been reported and surface the concentrations only visible after looking through, for the risk analyst, the Head of Investment Risk and the CIO to approve and sign.

What is the look-through approach under Solvency II?

The Solvency II look-through approach asks insurers to look through collective investment undertakings to their underlying assets when calculating the solvency capital requirement (Delegated Regulation (EU) 2015/35, Article 84). A fund that cannot be looked through is charged as type 2 equity, 49% before the symmetric adjustment. Insurers report the look-through in template S.06.03 and receive most fund data on the Tripartite Template; the solution drafts both from the signed look-through.

Can it read manager reports that arrive as PDFs or in other languages?

Yes. The Reader agent reads quarterly reports, capital account statements and holdings files in their original language (the sample quarter has reports in 12 languages) and cites every holding to its page, with the original beside the English. A value it cannot read, such as a smudged figure in a scanned report, is marked unreadable and sent to an analyst rather than guessed.

What is the difference between country of risk and country of domicile?

Domicile is where an issuer is registered; country of risk is where its business and revenue are. A Chinese property developer registered in the Cayman Islands is a China risk. The Mapper agent maps each line to country of risk and never by domicile alone, and sends anything below 95% confidence to an analyst with its evidence.

How does it handle tie-out gaps and funds that have not reported?

The Checker agent ties each fund's extracted holdings to the NAV the manager reported for your share, explains the difference from the report and escalates every gap over 2% to manager research. The Gap agent estimates funds not yet reported from their last holdings, capital activity and market proxies, labels the estimate everywhere, and replaces it with the variance recorded when the report arrives. Most of the unreported share is private funds that report 45–75 days after quarter end, so private markets exposure analysis rests on these labeled roll-forward estimates until each capital account statement arrives.

Can it produce Tripartite Template (TPT), S.06.03 and NAIC files?

Yes. The Tripartite Template (TPT) is the standard file asset managers send insurers for Solvency II look-through reporting. From the CIO-signed look-through, the Reporting agent drafts each insurer's Tripartite Template file with CIC codes, S.06.03 support, the NAIC look-through support file and pension exposure reports, and validates them: CIC codes, identifier check digits, totals against the client's share of NAV and labeled estimates. Regulatory reporting prepares each file and a second person releases it.

Do people stay in control of the look-through?

Yes. The agents read, map, tie out, estimate, test and draft; they never sign, release a file, message a manager, change a limit or close a gap. The risk analyst approves mappings and submits, the Head of Investment Risk reviews and decides breaches, the CIO signs, and every decision carries a reason code on a hash-chained audit trail.

How long does it take to go live?

The Agentic Solution Engine builds and deploys it from your requirements and documents — your investment policy, client reporting templates and a quarter of past manager reports — and it goes live once every quality gate has passed. We will walk you through it on your own manager reports first.

See it on
your manager reports.

We'll run Look-Through Risk Analysis on a quarter of your own manager reports and the systems they tie to.