WorkflowSustainable Investing & Stewardship

ESG Data Extraction

ESG data extraction that moves your holdings from estimated to reported, every figure cited to its page

Holdings move from estimated to reported ESG data, each figure cited to its page.

See one case, screen by screen ↓
demo1,118of 1,686gap issuers on reported data (score 1–2) this season, from none at its start
demo88%of the listed book's financed emissions on reported data, up from 71%
target100%of published figures with a page, a table and two signatures
target3daysfrom a report's publication to its figures in the template
In short

What is ESG Data Extraction?

ESG data extraction, also called sustainability report data extraction, is reading the figures an issuer reports — Scope 1, 2 and 3 emissions, energy, water, waste, board gender diversity, the gender pay gap — out of its sustainability and annual reports and into a standard ESG template, for the SFDR PAI statement, PCAF financed emissions and client reporting. ESG Data Extraction does it with seven agents that read each report in its own language, twice, cite every figure to its page and table, and propose its data-quality score; an analyst confirms and a different steward approves each issuer.

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

Updated

The problem

Why ESG data extraction for the long tail of holdings is still done by hand

The SFDR principal adverse impact statement and PCAF financed-emissions reporting both reward a figure the issuer reported over one a vendor estimated. Vendor ESG data covers the large listed names, so the small-cap, emerging-market and frontier holdings of a global book sit on revenue-based estimates at PCAF score 4 or 5. Their own sustainability and annual reports exist — often only in Korean, Japanese, Chinese, Portuguese or Bahasa, with tables in thousands of tonnes or terajoules, fiscal years that end in March, and parent-only figures next to consolidated ones.

So ESG data collection for those holdings is manual: analysts copy the figures into a spreadsheet template by hand, thousands of reports a season, between April and October. A figure in thousands read as units moves a fund's carbon footprint by a factor of 1,000. A March year-end lands in the wrong reference year. The second check is a sample, not every figure, and when an auditor asks which page a published Scope 1 number came from, nobody can show it.

typical16,000issuerslisted issuers a leading vendor's carbon data covers — the rest of a global book sits on estimates
typical70%of a portfolio's financed emissions, at most, that vendor data alone reaches; the rest needs the issuer's own report
typical14indicatorsmandatory SFDR PAI indicators in the statement due every June 30
Where an analyst's hours go on one issuer reportestimated
By hand2.6 days
With the solution0.5 days
  • Finding, downloading and matching the right report0.3 → 0.1 d
  • Finding the tables, often in another language0.5 → 0.1 d
  • Copying 38 fields into the template0.7 → 0.1 d
  • Converting units, fiscal years and boundaries0.4 → 0.1 d
  • Second check, outliers and the data-quality score0.5 → 0.2 d
  • Loading and showing where each figure came from0.2 → 0.1 d

Estimated split for one report of about 150 pages and 38 template fields, by hand (about 2 to 3 analyst hours) and with the solution, where the analyst confirms what the agents read.

How it works

How an issuer's own report replaces a vendor estimate

Seven agents find, read twice, convert, check and score every figure; an analyst confirms, a steward approves.

What comes in
Reports in3,040 reports a season · sustainability, annual, integrated; any language
Agents at work
Intake agentfind and match
Then
Extraction agentevery table, cited
Second reader agentblind second read
Then
Units agentunits, years, boundary
Plausibility agentholds outliers
Then
Assurance agentproposes the score
Publishing agentload and read back
A person decides
Analyst and stewardconfirm, then approve
What comes out
Template, every figure cited
Warehouse loaded and read back
Evidence pack
One case, step by step

ESG data extraction for one Korean issuer, screen by screen

Quillfield Capital, a fictional global asset manager, holds Daeyang Chemical Co., Ltd., a Korean chemicals issuer, across six funds: $412.6 million. Its Scope 1 sits on a vendor estimate of 1.18 Mt at score 4. Its 156-page Korean sustainability report came out on June 30, 2026; the English version is not expected before December. Here is what happens next, in the working solution.

  1. 019:00 a.m. London

    The agents brief her before she asks

    Helena Marsh · ESG data steward

    Helena's home screen shows 214 issuers waiting for a steward (23 due today, 4 overdue), 1,118 of 1,686 gap issuers on reported data, 287 open exceptions and 2,913 of 3,040 reports read. Overnight the Intake agent matched 212 new reports, the Second reader agent read 4,812 figures blind and sent 41 disagreements to analysts, and the Plausibility agent held 17 new outliers and found the issuer's own explanation for 11 of them.

    Morning brief: “41 issuers are ready for a steward since yesterday, Daeyang Chemical first: its Korean report moves Scope 1 from an estimate of 1.18 Mt to a reported 1.42 Mt. Client reporting read back 2 figures differently in this morning's load; I have not retried on my own.”

  2. 02One click

    The Scope 1 cell opens on the Korean table

    Helena Marsh · ESG data steward

    In the ESG template grid, every issuer is a row and every field a column, each value with its data-quality score. Daeyang's Scope 1 cell opens page 87, Table 4-2, 온실가스 배출량 (천 tCO₂eq): the cropped Korean table beside the English in template units, with the conversion written out. The holding moves from 4, estimated from revenue, to 1, reported and verified, on approval.

    Units agent: “1,421.6 thousand tCO₂eq × 1,000 = 1,421,604 tCO₂e” · fiscal year Jan 1 – Dec 31, 2025 → FY2025.

  3. 03How the agents got here

    Read twice, blind, then checked against last year and peers

    Extraction, Second reader and Plausibility agents

    The Extraction agent found Table 4-2 on page 87 and read 1,421.6 thousand tonnes at 96% confidence. The Second reader agent read the same cell blind and agrees. The Plausibility agent compared it with last year's 1,380,220 tCO₂e (+3.0%), chemicals peers at −4% to +7% and the vendor estimate of 1.18 Mt, which was 17% low: plausible. The Assurance agent found that limited assurance covers the figure on page 148.

  4. 04She asks

    “Use the parent-company figure” — and the agent says why it won't

    Helena Marsh, with the Units agent

    Helena asks the cell in plain words. The Units agent answers that the parent-company figures are in the exchange business report on page 212 — Scope 2 of 598.0 kt, with no Scope 1 for the parent alone — and that the template's boundary rule B-01 says consolidated. It will not switch on its own; an analyst can edit with a reason code, and the steward will see it.

    “Rule B-01 says consolidated, so I will not switch on my own.”

  5. 05One hold

    Hazardous waste up 75.4%, held, with the issuer's own reason

    Plausibility agent · Seo-yeon Kang, ESG data analyst

    Hazardous waste reads 38,412 t against 21,904 t last year, outside the ±50% band, so the Plausibility agent held it. Then it searched the report and found footnote 3 on page 89: a one-time disposal of spent catalyst after aged catalyst was replaced in 2025. Seo-yeon Kang, who reads Korean, accepted the hold at 9:10 a.m. with the reason code “One-time event explained by issuer”.

    The Plausibility agent never releases a hold itself.

  6. 06Issuer review

    Seven steps, from report found to steward approval

    Helena Marsh · ESG data steward

    The issuer review walks the run: report found, tables read twice (38 fields: 31 reported, 7 not disclosed), units and fiscal year, plausibility, the data-quality score, the analyst's confirmation at 9:12 a.m., and the steward's approval, by a different person. Beside it, what approval changes in Quillfield's financed emissions data: EVIC $14.9 billion, and financed Scope 1 from 32,675 t estimated to 39,366 t reported.

    “One boundary choice. Scope 2 uses the consolidated 608.3 kt from the report, not the parent-only 598.0 kt in the exchange filing (rule B-01).”

  7. 07The decision

    She approves with a reason code and an attestation

    Helena Marsh · ESG data steward

    The approval shows the Scope 1 score moving from 4 to 1, the 31 figures each with page and table, and Seo-yeon Kang's confirmation. Helena picks the reason “Figures match the report; assurance scope checked” and ticks the attestation. Had she edited a figure on this issuer, the solution would have offered the approval to another steward.

    “I checked the cited pages, the holds and the assurance scope, and I did not edit any figure on this issuer.”

  8. 08Approved

    Score 4 → 1, queued for tonight's load

    Publishing agent

    Daeyang Chemical is approved and queued for batch PB-2026-1019-B at 6:00 p.m. London. The Publishing agent will load it to the ESG data warehouse, the portfolio management system, the PAI engine, the financed-emissions engine and client reporting, then read every value back.

    The Publishing agent never publishes an issuer a steward has not approved.

  9. 09Every load

    Read back from five systems, with a way back

    Publishing agent · Marcus Feld, Chief Data Officer

    The next batch holds 42 issuers and 1,428 figures for 5 systems, Daeyang among them. In the morning's batch, client reporting read back 698 of 700 values: it stores water in thousands of m³ and rounded two values on the way in. The agent flagged the difference and did not retry on its own; out-of-cycle loads and rollbacks need the Chief Data Officer.

  10. 10The season

    From estimated to reported, issuer by issuer

    Catherine Lowe · Head of Sustainable Investing

    The data-quality screen recalculates after every approval: the 1,686 gap issuers have moved from an average score of 4.3 at the start of the season to 2.4, and 88% of the listed book's financed emissions now rest on reported data, from 71%. Coverage of all 14 PAI indicators is shown by fund, ahead of the PAI statement due June 30.

Who it’s for

Built for the ESG data team that signs every figure.

The same issuer, seen by five of the people who carry the season — what their work looked like, and what it looks like now.

HM
Helena MarshESG Data Steward · London
ESG data steward
Before
Signs what goes into the PAI statement, and is shown a score where she needs the page it came from.
Now
Opens each issuer with every figure cited, the holds explained and the assurance scope read, and approves with a reason code.
SK
Seo-yeon KangESG Data Analyst, Asia · Singapore
ESG data analyst
Before
Reads Korean, Japanese and Chinese, and spends that skill retyping tables into a spreadsheet.
Now
Confirms what two agents read, with the original table beside the English, and decides the holds with a reason code.
RD
Rafael DuarteESG Data Analyst, Americas and EMEA · New York
ESG data analyst
Before
Knows the unit is where it goes wrong: ten thousand tonnes or ten million, or a table whose header says kilograms.
Now
Works an exceptions queue where each unit, boundary or conflicting figure comes with the agent's proposal and the source.
CL
Catherine LoweHead of Sustainable Investing · New York
Head of Sustainable Investing
Before
Needs reported data for the holdings clients ask about, before the June 30 PAI statement.
Now
Sees how many holdings moved from estimated to reported, PAI coverage by fund, and approves every rule and threshold change.
MF
Marcus FeldChief Data Officer · New York
Chief Data Officer
Before
Owns the ESG data warehouse and wants nothing in it without a read-back and a way back.
Now
Every load is read back from five systems; he approves out-of-cycle loads, rollbacks and every agent or model change.
Built on the engine

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

Seven agents find, read twice, convert, check and score every figure; an analyst confirms, a steward approves.

Intake agent

Watches filing calendars, exchange feeds, issuer sites and the document store; matches each report to its issuer by ISIN, LEI or name in any script, and detects its type, language, fiscal year, restatements and duplicates.

  • Never guesses a match below 95%: asks a person
  • Compares a restated report with the version already read
Extraction agent

Finds the tables that hold each template field and reads the value, unit, year and boundary, with page, table and cell.

  • Never fills a field without a page and table
  • “Not disclosed” is an answer, recorded with the pages searched — never a blank
Second reader agent

Reads the same tables blind, with a different method, and compares its reading with the first.

  • Never sees the first reading before its own
  • Any disagreement goes to an analyst with both readings
Units agent

Converts units, fiscal years, currencies and boundaries by the template's rules, and writes the arithmetic out.

  • Never changes a rule
  • Flags every boundary choice
Plausibility agent

Compares each figure with last year, restated years, sector peers and vendor estimates; holds outliers and looks for the issuer's own explanation in the report.

  • Never releases a hold itself
Assurance agent

Reads the assurance statement and its scope, page by page, and proposes the PCAF data-quality score for each scope.

  • Never moves a score: the steward's approval does
Publishing agent

Prepares deltas for approved issuers, loads them to the warehouse and downstream systems, reads every value back and keeps versions for rollback.

  • Never publishes an issuer a steward has not approved
  • Out-of-cycle loads need the Chief Data Officer
Data analyst and data steward

Confirm, approve. The agents propose; a named person decides.

Ask in plain words

Ask about any issuer, figure, fund or queue

Ask a question or say what to do. Every answer cites the page, and the agents act only with a person's say-so.

Why did Daeyang Chemical's score move from 4 to 1?

Because its own report replaces the vendor estimate. Page 87 of the Korean sustainability report gives Scope 1 of 1,421.6 thousand tCO₂eq, which is 1,421,604 tCO₂e, up 3.0% on last year and inside the peer range. Hanbit Assurance's limited assurance covers Scope 1 and 2 on page 148, so the score becomes 1 once a steward approves.

Which Asia Pacific UCITS holdings are still on estimates?

In the Asia Pacific Equity UCITS Fund (Art. 8), four holdings still carry estimates (score 4 or 5): Daeyang Chemical (awaiting your approval), Hoshimura Electric Works (2 exceptions due today), Tung Hsin Semiconductor (being read, 62%) and Siam Riverside Foods (report expected Nov 14).

Hold every Scope 3 rise above 40% for a second look

That changes threshold T-03 (Scope 3 band, today ±35%), which I can't change myself. I have drafted proposal RP-122 for the Head of Sustainable Investing: on last season's data it would have held 23 more issuers and missed no known error.

Prepare the evidence pack for Daeyang Chemical

The pack holds all 38 fields with page, table and the cropped Korean source beside the English, the report's fingerprint, nine agent steps with their versions, the accepted hold on hazardous waste, Seo-yeon Kang's confirmation and the steward's approval.

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 steward's home screen: issuers waiting for approval, gap issuers on reported data, open exceptions, reports read, what the agents did overnight and a conversation with the agents.
The ESG template and the cell tracerOne issuer per row, Scope 1, 2 and 3, GHG intensity, energy and fossil-fuel exposure across the top, each value with its PCAF data-quality score; the selected cell shows the Korean source table beside the English and the conversion.
Asking the agents about a valueThe Plausibility agent explains why Scope 1 is plausible, and the Units agent explains why it keeps the consolidated figure, with page citations.
An outlier held, with the issuer's reasonHazardous waste up 75.4% year on year, held by the Plausibility agent, with the footnote on page 89 that explains it and the analyst's accepted hold.
Issuer review in seven stepsFrom report found to steward approval: fields reported and not disclosed, the hold and the boundary choice, every template field with its page, and what approval changes in financed emissions.
Approve with a reason and an attestationThe steward's approval: the score movement, the figures with page and table, the analyst who confirmed, a reason code and the attestation.
Approved and queuedScore 4 → 1 for Daeyang Chemical, queued for the evening load to the warehouse, the PAI engine and client reporting.
Report intake3,040 reports expected this season, each matched to its issuer by the Intake agent; a restated integrated report matched at 93% waits for a person, with what the restatement changes.
Exceptions287 open exceptions in five kinds — outliers, unit and boundary, conflicting figures, assurance scope, low-confidence reads — each with the agent's proposal, the source and an SLA.
ESG data quality and PAI coverageGap issuers by PCAF data-quality score at the start of the season and today, the share of financed emissions on reported data, and reported, estimated and not-disclosed shares for the 14 SFDR PAI indicators.
Publishing with read-backThe next batch, the five target systems with their read-back, the client-reporting difference flagged by the Publishing agent, and every load with its status and rollback.
Audit trail and evidence packsEvery action by a person or an agent with who, what, when, why and the evidence page, kept 10 years and read-only; the evidence pack export for auditors.
Thresholds and SLAsWhen the agents pre-confirm, hold or note a vendor gap, the score 1 rule, analyst and steward SLAs, and the threshold changes waiting for approval.
Governance

Built for the PAI statement: cited, signed twice, on the record.

Every figure cites its page and tableEach value in the ESG template opens to the cropped table in its original language, beside the English and the conversion applied. Every agent statement cites a passage, and “not disclosed” is recorded with the pages searched.
Two readers, one of them blindThe Extraction and Second reader agents read every table with different methods, and the second never sees the first reading. Agreement at 97% or more is pre-confirmed for the analyst; any disagreement goes to a person with both readings side by side.
Two people sign every issuerThe analyst confirms and a different person, the steward, approves, with a reason code and an attestation. A steward cannot approve an issuer whose figures they edited; another steward must.
The agents propose; people decideAgents never publish, never release a hold, never move a data-quality score and never change a rule. Rule and threshold changes are approved by the Head of Sustainable Investing; agent and model changes by the Chief Data Officer, against a golden set of 1,200 figures.
Every load read back, every batch reversibleApproved issuers load to the warehouse and four other systems twice a day, and every value is read back. A mismatch is flagged, not retried in silence; out-of-cycle loads and rollbacks need the Chief Data Officer.
An audit trail kept for 10 yearsEvery action by a person or an agent is logged with who, what, when, why, the evidence and the agent's version, read-only for everyone. Internal audit exports an evidence pack per issuer or per PAI indicator.
Configuration

Your template, your rules, your thresholds

The thresholds and template rules the agents work to are settings. Each change is proposed by one person, approved by another, versioned and logged.

SettingDefaultChoose from
Pre-confirm for the analystBoth readers agree at 97% or moreBelow it, the analyst decides with both readings
Hold an emissions figureYear on year beyond ±35%, or outside the sector peer bandProposal RP-121 to widen the Scope 3 band to ±45% waits for the Head of Sustainable Investing
Hold water or wasteYear on year beyond ±50%The hazardous waste band was widened from ±40% by change T-07: too many one-off disposals were held
Match a report automaticallyIntake confidence 95% or moreBelow it, a person confirms or changes the issuer
Score 1 (verified)Signed limited or reasonable assurance that covers the figureReported without that assurance scores 2
Boundary (rule B-01)Consolidated figuresThe parent-only figure is recorded when both exist
Fiscal year (rule F-01)The calendar year holding most of itFY ending Mar 31, 2026 → FY2025
Steward approval2 business daysEscalation to the Head of Sustainable Investing after 3 business days
Connections

Works with the reports, feeds and systems your ESG data management runs on

Issuer reportssustainability, annual and integrated reports, assurance statements and local filings, in the issuer's own language
Exchange filing feeds and issuer websitesnew filings, restatements and English editions, watched through the season
ESG data vendorsvendor estimates, ratings and controversy data, kept as comparisons under your licenses
Security master and portfolio accountingISIN, LEI, holdings and EVIC for every gap issuer
ESG data warehouse and portfolio management systemapproved figures loaded and read back
PAI, financed-emissions and client reportingthe PAI statement engine, the financed-emissions engine, client reporting and the EET file
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
1–2
data-quality score for every held issuer that publishes a report
Todayestimates at score 4–5
With agentsreported, score 1–2
target
100%
of published figures with a page, a table and two signatures
every figure
analyst and steward
target
3days
from a report's publication to its figures in the template
By handweeks to months in season
With agents≈ 3 business days

“demo” = seen in the working solution, on its sample data · “target” = the design goal, measured in the live solution · “estimated” = our estimate · “typical” = published figures (a leading ESG data vendor — carbon data on about 16,000 listed issuers; a carbon-data provider — vendor data reaches up to about 70% of a portfolio's financed emissions; SFDR Delegated Regulation (EU) 2022/1288 — 14 mandatory PAI indicators, statement each June 30; PCAF — data-quality score 1, reported and verified, to 5, estimated). Quillfield Capital and the people, issuers, funds, assurance providers and figures named on this page are fictional — characters and sample data in the working solution.

Questions

What ESG data teams ask about ESG data extraction.

What is ESG data extraction?

ESG data extraction, also called sustainability report data extraction, is reading the figures an issuer reports — Scope 1, 2 and 3 emissions, energy, water, waste, board gender diversity, the gender pay gap — out of its sustainability and annual reports and into a standard ESG template, for the SFDR PAI statement, PCAF financed emissions and client reporting. ESG Data Extraction does it with seven agents that read each report in its own language, twice, cite every figure to its page and table, and propose its data-quality score; an analyst confirms and a different steward approves each issuer.

Does it handle PAI data collection for the SFDR PAI indicators and the European ESG Template?

Yes. The standard template has 38 fields mapped to the 14 mandatory PAI indicators, the PCAF inputs and European ESG Template (EET) fields, or the agents fill your own template, imported from Excel or CSV. The data-quality screen shows reported, estimated and not-disclosed shares for each of the 14 indicators, by fund.

How is the PCAF data quality score decided?

The Assurance agent reads the assurance statement and its scope. A figure covered by signed limited or reasonable assurance is proposed at score 1; a reported figure outside that scope at score 2. In the demo, limited assurance over Scope 1, Scope 2 and energy gives score 1, and its Scope 3 emissions data, 9.86 Mt across five reported categories and not covered, gives 2. The score on the holding moves only when a steward approves.

Can it read sustainability reports that are not in English?

Yes. The demo season covers reports in Korean, Japanese, Chinese, Portuguese, Spanish, Indonesian, Turkish, Polish, German, French and other languages. Every cell shows the cropped table in its original language beside the English, so an analyst can check it without translating, and the agents translate a footnote when asked.

How does it handle units, fiscal years and parent versus consolidated figures?

The Units agent applies your template rules and writes the arithmetic out: thousands of tonnes to tonnes, terajoules to MWh, a fiscal year ending March 31, 2026 to FY2025, and consolidated over parent-only figures, with the parent-only figure recorded. It never changes a rule and flags every boundary choice for the analyst.

What happens when a figure looks wrong?

The Plausibility agent compares it with last year, restated years, sector peers and the vendor estimate, and holds it when it falls outside the band. It then looks for the issuer's own explanation in the report and shows it to the analyst, who accepts with a reason code or edits. It never releases a hold itself.

Do people stay in control of the ESG data?

Yes. The agents read, convert, check and propose; they never publish, release a hold, move a score or change a rule. An analyst confirms every issuer, a different steward approves it with a reason code and attestation, and every load to the warehouse is read back, with rollbacks approved by the Chief Data Officer.

How long does it take to go live?

The Agentic Solution Engine builds and deploys it from your requirements and documents — your ESG template, unit and boundary rules and a sample of past issuer reports — and it goes live once every quality gate has passed. Setup includes a pilot back-test on issuers your analysts already did by hand, compared figure by figure.

See it on
your gap issuers.

We'll run ESG Data Extraction on a sample of your own issuers' reports, against the figures your analysts already keyed.