WorkflowDistribution & Client Service

Consultant Database Management

Consultant database management where you ask the agents, see the source behind every figure and approve before anything reaches a consultant

Every consultant profile current each quarter, every figure tied to its source.

See one case, screen by screen ↓
demo9,012fieldsin the sample firm's Q3 cycle — 60 strategies on 12 consultant portals, 8,798 filled from approved sources so far
demo$91.4Moverstatedstrategy assets live on one consultant's database, traced to two swapped digits in a hand-typed CRM edit
demo48conflictsfound this cycle by comparing live portals, drafts and sources: 35 resolved, 13 open on the sample morning
target8business daysto source, check and submit the quarter, not about five weeks of copy-paste
In short

What is Consultant Database Management?

Consultant Database Management is software that keeps every strategy profile current on every investment consultant database each quarter, from approved fund data: the consultant database updates an asset manager's RFP and consultant relations team carries. The coordinator works with seven agents in plain words — asks why a figure differs, sees the source behind every value, and approves or rejects each proposal with a reason. The agents plan the cycle, fill every field with its source, find conflicts across portals including wrong numbers already live, test gross and net performance presentation, draft notices and Japanese and German text, and submit each portal with a receipt and a read-back. Compliance approves every performance figure and Consultant Relations signs every message to a consultant.

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

Updated

The problem

Why consultant database management still takes five weeks a quarter

Consultant database management is the quarter-end work of keeping every strategy profile current in every investment consultant database: assets and accounts, returns gross and net of fees over standard periods, benchmark returns, risk statistics, holdings and characteristics, team, fees and commentary. Each portal has its own field names, precision, definitions and deadline — strategy assets or composite assets, effective or modified duration, composite or vehicle inception — and the RFP and database coordinators or consultant database analysts copy the numbers by hand from the performance system, factsheets and GIPS composite reports, then send everything to marketing compliance as a spreadsheet to re-check.

The risk is the number nobody compares. A value typed into the CRM or into one portal outside the cycle is never checked against the source, so a transposed figure can sit in front of a consultant for a whole quarter. Team bios go years out of date, a portfolio manager's departure reaches a consultant late, performance goes out gross without net, and when an examiner asks which source fed which performance figure, there is no record to show.

typical60%+of flowsof institutional flows intermediated by consultants, who screen managers on these profiles
typical91%of managers surveyed found it challenging to meet RFP and DDQ deadlines
Where a quarter's business days goestimated
By hand25 days
With the solution8 days
  • Rebuilding the portal calendar and waiting on data2 → 0.5 d
  • Copying fields into each portal's web form or template12 → 2 d
  • Chasing portfolio managers, HR and translators4 → 2 d
  • Marketing compliance re-checking every figure4 → 2.5 d
  • Submitting, screenshots and corrections3 → 1 d

Estimated split for a two-person team keeping 60 strategies on 12 consultant portals, by hand and with the solution. By hand is our estimate (9,012 fields at about 40 seconds each is about 100 hours of keying); with the solution is the design target.

How it works

How a quarter moves

Seven agents source, reconcile, check and submit every profile; the coordinator releases, Compliance approves figures, Consultant Relations signs.

What comes in
Approved data in60 strategies, 12 portals · 9,012 fields a quarter, any language
Agents at work
Planning agentdeadlines, owners
Then
Sourcing agentapproved data only
Freshness agentstale and changed facts
Then
Conflict agentlive value vs source
Compliance check agentpresentation rules
Then
Narrative agentin each portal's language
Submission agentreceipt and read-back
A person decides
Coordinator, Compliance, Consultant Relationsrelease, approve, sign
What comes out
Profiles current
Figures approved
Receipts kept
One case, step by step

One quarter-end morning of consultant database management

Quillfield Capital keeps 60 institutional strategies on 12 consultant portals: 300 profiles and 9,012 fields in the Q3 2026 consultant database updates. It is Thursday, October 15, business day 11. Here is how the coordinator works with the agents — asks, checks the evidence, approves — screen by screen, in the working solution.

  1. 018:41 a.m.

    Jamie asks the agents why a number is wrong

    Jamie Cole · RFP & Database Coordinator

    Jamie's Today screen opens on four numbers — 40 of 300 profiles submitted, 8,798 of 9,012 fields sourced with 0 sent without a source, 13 of 48 conflicts open, 1,744 fields waiting for approval — and on what each agent did since yesterday, every line cited. Jamie types the question on his mind: why does Fenwick Hale show $4.21B? The Conflict agent answers in plain words with three sources — the CRM history, factsheet page 1 and the performance system — and a button that opens the conflict.

    Conflict agent: “The performance system and the Sep 30 factsheet both say $4.12B. I changed nothing; the fix waits for Jamie Cole.”

  2. 02The freshness grid

    Every field against every consultant portal, one mark each

    Jamie Cole · RFP & Database Coordinator

    Global Small Cap Equity has 320 fields across the 12 portals: 160 fresh, 146 ready for approval, 12 stale, 1 waiting and 1 conflict. Jamie clicks the red mark. Fenwick Hale shows $4,210.0M live, typed by hand on October 7 with no source; the approved source, the performance system, says $4,118.6M. The panel beside the grid also shows Fenwick Hale's own definition of the field and who approves it.

    Portal asks: “Total strategy assets, USD millions, all vehicles and accounts.”

  3. 03One more click

    The source behind every value

    Sourcing agent

    Any value opens its source. Here the performance system record for composite QF-C-114, period Q3 2026 locked October 9 at 6:40 p.m. by Tomás Ferreira: strategy assets $4,118.6M, composite assets $3,871.2M, 14 accounts in the composite, returns gross and net for each period, and the net-of-fee method. The Sourcing agent filled 319 of the strategy's 320 fields from records like this one, never from the CRM.

    “Opened from the record · every value keeps its source, as-of date and version”

  4. 046:12 a.m.

    What each place says, side by side

    Conflict agent

    The conflict CF-0412 lays out every place the figure lives. The performance system and the 11 other portal drafts say $4,118.6M, and the September 30 factsheet says $4.12 billion: they match. Fenwick Hale's live value and the CRM product record differ. The composite report's $3,871.2M is not compared, because composite assets are a different field. The agent's fix has four parts: correct Fenwick Hale on release with a short correction note, keep the 11 drafts, ask the CRM record's owner to fix it, and send the figure to Compliance.

  5. 05Replay the check

    Seven steps, each with its evidence

    Conflict agent

    Jamie replays how the agent got there. It read strategy assets on all 12 portals, read the approved sources, matched Fenwick Hale's definition 2.1 to strategy assets, and traced $4.21B to a CRM record edited by hand on October 6 at 4:12 p.m. London with no linked source. It explained the $91.4M (2.2%) gap, found no RFP, DDQ or other portal that used the CRM figure, and escalated at 98% confidence.

    “Cause: a hand-typed CRM edit swapped two digits (4.12 → 4.21), then the CRM figure was typed into Fenwick Hale's form outside the cycle. The agent changed no value.”

  6. 06Asking back

    Jamie tests the reasoning before approving

    Jamie Cole · RFP & Database Coordinator

    Jamie tests the reasoning in the conversation beside the conflict: could $4.21B include model assets? The agent answers no, and cites the firm's AUM policy and Fenwick Hale's question. Satisfied, Jamie approves the fix with reason code AP-02, source error corrected. The decision is signed with his name and role and recorded on the audit trail.

    “Model-delivery assets for this strategy were $0.31B at Sep 30, and firm policy §3.2 reports them as assets under advisement, never as strategy assets. … And $4.12B + $0.31B is $4.43B, not $4.21B.”

  7. 078:47 a.m.

    Compliance approves every performance figure

    Elena Ruiz · Compliance Reviewer, Marketing Review

    Elena's queue holds the performance and AUM fields in strategy batches, each already tested by the Compliance check agent: net with gross for the same period, 1-, 5- and 10-year periods, benchmark named, composite disclosure attached. Clean batches can be approved together; flagged ones, like US High Yield with a benchmark revised October 8, open one by one. She approves the 145 performance and AUM fields for Global Small Cap. Jamie could not have approved them, and Elena cannot approve anything she prepared.

    “Clean batches can be approved together; flagged ones open one by one. Nobody approves what they prepared.”

  8. 08Released

    Ten portals submitted, two wait for their reviewers

    Submission agent

    Jamie releases the corrected strategy to all 12 portals. The Submission agent files each in its own format — web form, spreadsheet template or data feed — and the marks on the grid turn to submitted for ten portals. Rheintal and Aoba stay queued for their German and Japanese reviewers.

    “Submitted to 10 portals with receipts · 2 queued for reviewers.”

  9. 09Read back

    A receipt and a read-back for every portal

    Submission agent

    Every submission keeps its receipt and the result of reading each field back from the portal. Fenwick Hale's corrected profile is FH-Q3-26-0471, all fields match. When Wexmoor stored one decimal, Compliance accepted the two rounded fields with reason code OV-03. Aoba's sign-in expired overnight, so the agent paused: nothing was sent or lost, and Dana Whitaker renews the credential in the vault.

  10. 10On the record

    Who, what, when, why — and the evidence

    Owen Price · Internal Audit

    The audit trail shows the morning in order: the Conflict agent's escalation with its four sources, Jamie's approval with AP-02, Elena's approval of 145 fields against the marketing review policy, the release and the submission. It also shows the October 6 CRM edit and the October 7 hand entry — no reason, no approval. Every step in the cycle is hash-chained and kept 7 years, and Owen exports the evidence pack.

    The cycle report: 48 conflicts caught by the agents, 0 figures sent without a source.

Who it’s for

Built for everyone who touches a consultant database profile.

The same quarter, seen by the four people who carry it — what it looked like by hand, and what it looks like with the agents.

JC
Jamie ColeRFP & Database Coordinator · 60 strategies on 12 portals
RFP & Database Coordinator
Before
“I can type 9,000 numbers. I can't prove where each one came from.” Rebuilds the portal calendar every quarter and copies fields by hand while also answering RFPs.
Now
Opens a freshness grid already filled from approved sources, reviews the conflicts the agents traced, approves fixes with a reason code and releases each portal.
ER
Elena RuizCompliance Reviewer, Marketing Review · approves every performance figure
Compliance Reviewer, Marketing Review
Before
“Show me net next to gross, the period and the source, and I'll sign.” Re-checks a spreadsheet against the performance system, figure by figure.
Now
Gets a packet where every figure is pre-tested against the presentation rules with its source beside it; approves clean batches together and opens only the flagged ones.
NR
Nadia RahmanHead of Consultant Relations, Americas · signs every message to a consultant
Head of Consultant Relations
Before
“I'd rather call a consultant about a mistake than have them find it.” Hears about team changes and wrong figures late, and so do the consultants.
Now
Signs drafted notices and correction notes built from the HR record and the approved figures — one notice to every consultant that carries the strategy.
TF
Tomás FerreiraPerformance Analyst · locks the quarter in the performance system
Performance Analyst
Before
“The number is in the system. The problem is everything copied from it.” Answers “which number is right” by email all quarter.
Now
Locks the period once; every portal value points back to his record, and a field whose source is not final waits and asks him instead of reusing last quarter.
Built on the engine

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

Seven agents source, reconcile, check and submit every profile; the coordinator releases, Compliance approves figures, Consultant Relations signs.

Planning agent

Builds the quarter's plan from each portal's deadline and each source's arrival date, assigns owners, watches the SLAs — every portal ready 3 business days before its deadline — and drafts escalations and extension requests.

  • Never moves a deadline
  • Never writes to a consultant itself; it asks the coordinator
Sourcing agent

Fills every field from approved sources only — performance system, portfolio accounting, firm AUM report, factsheets, composite reports, prospectuses, content library, fund administrator and market data — and stamps each with its source, as-of date and version.

  • Never takes a number from the CRM, a prior portal answer, an email or free text
  • Below 95% confidence it leaves the field waiting and asks its owner
Conflict agent

Compares each field across every portal's live value, this quarter's drafts and the sources; matches each portal's definition so different fields are left alone; traces the cause and proposes a fix with its confidence.

  • Never overwrites a value
  • Below 90% confidence it escalates without a proposal
Compliance check agent

Tests every performance figure against the presentation rules in the firm's marketing review policy — net with gross for the same period, 1-, 5- and 10-year periods, benchmark named, composite disclosure attached, as-of date — and builds the reviewer's packet.

  • Never approves; it can only flag and hold
  • Clean batches still need a Compliance reviewer to approve them
Freshness agent

Watches the as-of date of every source and the HR, product and ESG records; raises stale and change alerts, such as team bios over 12 months or a co-PM's resignation, and drafts the notice to every consultant that carries the strategy.

  • Never sends a notice — Consultant Relations signs it
  • Never marks stale data fresh
Narrative agent

Drafts commentary, team and change text from approved English only, in each portal's language — Japanese and German — with the original beside it and names checked against the firm's register.

  • No new claims: every sentence maps to the approved English
  • A native-language reviewer approves every non-English text
Submission agent

Formats each portal's update as a web form, spreadsheet template or data feed, submits released batches, captures the receipt, reads every field back from the portal and drafts correction notes.

  • Never submits a field that is not approved and released
  • Uses credentials only from the vault and pauses on any error
Coordinator, Compliance reviewer, Head of Consultant Relations

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

Ask in plain words

Ask about any strategy, portal or figure

Every screen has an ask box: Today, each conflict, each review queue, submissions and the audit trail. The agents answer in plain words, cite the record behind the answer and open the screen where you act.

Why does Fenwick Hale show $4.21B?

Because a CRM record was edited by hand on Oct 6 (4.12 → 4.21) and typed into Fenwick Hale's form on Oct 7, outside the cycle. The performance system and the Sep 30 factsheet both say $4.12B. I changed nothing; the fix waits for Jamie Cole.

Which portals are at risk this week?

One: Fenwick Hale, due Thu Oct 22, with Global Small Cap held behind CF-0412 and the EM Local Debt notice unsigned. The SLA wants it ready by Mon Oct 19. Corvane (Oct 23) is on track once Compliance clears 52 profiles. Pellham needs an extension for two private credit funds whose marks arrive Nov 12.

What still needs Compliance?

1,296 performance and AUM fields across 60 strategy batches, one per strategy. Three carry a flag: Global Equity (Calloway's template has no net column), US High Yield (benchmark revised Oct 8) and Direct Lending IV (net IRR waits for Q3 marks). Global Small Cap is held behind CF-0412; the other 56 pass every presentation check.

How sure are you?

Two approved sources agree to the tenth of a million, the definitions match, the CRM change has no linked source, and the swapped digits explain the exact gap of $91.4M (2.2%). That is why I am at 98%. Below 90% I would have escalated without a proposal.

Every screen

The working solution, as it ships.

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

Today, and a question answeredThe coordinator's day in consultant database management: what needs a decision, what each agent did since yesterday with its source, and a plain-words question answered by the Conflict agent with the records behind it.
The consultant database freshness gridEvery database field against all 12 consultant portals for one strategy, one mark per cell, with the selected value, its approved source and the portal's own definition.
The source behind a valueThe performance system record a value came from: period locked and by whom, strategy and composite assets, returns gross and net, the net-of-fee method.
A conflict on a live consultant databaseStrategy assets in the performance system, the factsheet, 11 drafts, the live consultant database and the CRM, with the agent's proposed fix and the approval chain.
How the Conflict agent checkedSeven replayable steps from reading every portal to tracing a hand-typed CRM edit, each with its evidence and the agent's confidence.
Asking the agent backThe coordinator asks whether model assets explain the gap; the agent answers no and cites the firm's AUM policy and the portal's definition.
Gross and net performance approvalsMarketing compliance's packet: every performance and AUM field tested for net with gross, 1-, 5- and 10-year periods, benchmark and disclosure; clean batches approved together.
Release to 12 consultant portalsThe corrected strategy released: ten consultant portals submitted with receipts, two queued for their German and Japanese reviewers.
Submissions, receipts and read-backsEvery consultant database update with its method, receipt and read-back result — and an expired portal sign-in paused safely with nothing lost.
A key-person change noticeA co-PM's resignation found in the HR record, with a notice drafted to the 9 consultants that carry the strategy for Consultant Relations to sign.
Japanese and German profile textCommentary drafted from the approved English, side by side in Japanese and German, with a name register check, for native reviewers to approve.
Audit trail and evidence packEvery person and agent action with its evidence, reason code and hash, kept 7 years as books and records and exported as an evidence pack per cycle, strategy or portal.
Rules and thresholdsWhich approver each field family needs, confidence thresholds, staleness limits, matching and currency rules — saved as versions a second person approves.
Governance

Consultant database management your compliance team can sign: cited, approved, on the record.

Every value cites its sourceEach field carries its source, as-of date and version, and every agent statement links the passage it used — the performance system record, the factsheet page, the composite report, the prospectus in its original language.
Maker and checker on every figureAgents prepare. The coordinator approves fixes and releases, Compliance approves every performance and AUM figure, Consultant Relations signs every message to a consultant, and nobody approves what they prepared.
Presentation tested before Compliance sees itEvery performance figure is checked against the firm's marketing review policy, which applies the SEC Marketing Rule to database profiles — net with gross, 1-, 5- and 10-year periods, benchmark, composite disclosure — and a batch releases only when every figure is approved.
Agents never approve, release or overwriteThese controls are locked on: the Submission agent sends only what a person released, the CRM is reference only and never a source for numbers, portal credentials stay in a vault where nobody sees them, and a submission pauses on any error rather than send half a profile.
A hash-chained audit trail, kept 7 yearsWho, role, action, record, evidence, reason code and hash for every person and agent step, with an evidence pack per cycle, strategy or portal. Books and records are kept 7 years; SEC Rule 204-2 asks for 5.
Rules and agents are versionedA change to thresholds or approval rules is saved as a version that stays pending until a Compliance reviewer who did not make it approves. Agents and prompts carry versions and golden-set scores; a rollback is saved with a reason and goes live only after Compliance approves it.
Configuration

Your marketing review policy, as settings

Thresholds and definitions are versioned — version 14 is live since October 1 — and a change waits for a second approver in Compliance.

SettingDefaultChoose from
Sourcing agent fills a field at or above95% confidenceA percentage the firm sets · below it, the field waits and asks its owner
Conflict agent proposes a fix at or above90% confidenceA percentage the firm sets · below it, the agent escalates without a proposal
Compliance check flags below97% confidenceA percentage the firm sets
Team bios are stale after12 monthsIn months · firm diversity data has its own limit, also 12
ESG policy is stale after12 months18 months proposed as version 15, pending Compliance's approval
Values match whenEqual after rounding to the portal's precisionSet by the firm
Currency conversionLondon 4 p.m. fixing, last business day of the quarterSet by the firm
CRMReference only: never a source for numbersLocked
Connections

Works with the systems your profiles already come from

Performance systemreturns gross and net, assets, accounts, risk statistics, read once the period is locked
Portfolio accountingholdings and characteristics at quarter end
Factsheets, GIPS composite reports, prospectusesread in their original language, every value cited to its page
Content libraryapproved commentary, philosophy and team bios
Fund administrator and market dataprivate markets marks, benchmark returns and vendor estimates
Consultant portalsweb forms, spreadsheet templates and data feeds, each submitted with a receipt and read back
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
0
performance or AUM figures sent without a cited source and a compliance approval
Todaynumbers retyped, no record of the source
With agentsevery figure cited and approved
target
100%
of profiles current on every portal before each consultant's deadline
300 profiles
12 portals
target
8days
to source, check and submit the quarter, not 5 weeks of copy-paste
By handabout 5 weeks (estimated)
With agentsabout 8 business days

“demo” = seen in the working solution, on its sample data · “target” = the design goal, measured in the live solution · “estimated” = our estimate (about five weeks by hand: 9,012 fields at about 40 seconds each, about 100 hours for two people who also answer RFPs) · “typical” = published figures (Cerulli Associates via Institutional Investor — consultants have intermediated more than 60% of institutional flows; in 2019, 91% of managers found it challenging to meet RFP and DDQ deadlines). Rules named: SEC Rule 206(4)-1 (Marketing Rule; compliance date Nov 4, 2022) and staff FAQ; SEC Rule 204-2; GIPS. People, firms, consultants, portals and strategies named on this page are fictional — characters and sample data in the working solution.

Questions

What asset managers ask us about consultant database management.

What is Consultant Database Management?

Consultant Database Management is software that keeps every strategy profile current on every investment consultant database each quarter, from approved fund data: the consultant database updates an asset manager's RFP and consultant relations team carries. The coordinator works with seven agents in plain words — asks why a figure differs, sees the source behind every value, and approves or rejects each proposal with a reason. The agents plan the cycle, fill every field with its source, find conflicts across portals including wrong numbers already live, test gross and net performance presentation, draft notices and Japanese and German text, and submit each portal with a receipt and a read-back. Compliance approves every performance figure and Consultant Relations signs every message to a consultant.

How do asset managers keep consultant database profiles current every quarter?

Consultant database maintenance starts from a calendar. The Planning agent builds the quarter from each portal's deadline and each source's arrival date, and the Sourcing agent fills every field as data is final — the performance system once the period is locked, holdings from portfolio accounting, factsheets and composite reports from document management. A field whose source is not final waits and asks its owner, and the Freshness agent flags stale bios, policies and diversity data before a consultant sees them.

What are the SEC Marketing Rule performance requirements for consultant database profiles?

Where a database profile is an advertisement under SEC Rule 206(4)-1, gross performance must be shown with net performance over the same period and with the same methodology, and the performance of a portfolio other than a private fund needs 1-, 5- and 10-year time periods. Your compliance team decides when a profile is an advertisement; the Compliance check agent tests every figure against those points and your marketing review policy — net with gross, the periods, the benchmark named, the composite disclosure, the as-of date — and hands the reviewer a packet. It never approves.

How do you find a wrong number already live on a consultant database?

The Conflict agent reads each portal's live value alongside this quarter's drafts and the approved sources, matches the portal's definition so composite assets are not compared with strategy assets, and traces the cause — in the demo, a hand-typed CRM edit with two digits swapped. It proposes a fix with its confidence and never overwrites a value; the coordinator approves it with a reason code.

Can we prove which source fed each performance figure?

Yes. Every field keeps its source, as-of date and version, and every approval, release and submission is on a hash-chained audit trail with the evidence and reason code. Internal Audit or Compliance exports an evidence pack per cycle, strategy or portal, and records are kept 7 years, longer than the 5 that Rule 204-2 asks for.

Does the AI submit anything or change our numbers on its own?

No. The agents prepare, check and explain; they never approve, overwrite a value, take a number from the CRM or send a message to a consultant. A batch releases only when every performance and AUM figure is approved by Compliance, nobody approves what they prepared, and the Submission agent submits only released fields, using credentials from the vault.

Does it handle consultant portals in Japanese and German?

Yes. The Narrative agent drafts commentary and change text from the approved English in each portal's language, with the original beside it and names checked against the firm's register. A native-language reviewer approves every non-English text, and those portals stay queued until they do.

How long does it take to go live?

The Agentic Solution Engine builds and deploys it from your requirements and documents — your marketing review policy, field definitions, last quarter's portal answers and source systems — and it goes live once every quality gate has passed. We will walk you through it on your own strategies first.

See it on
your strategies.

We'll run Consultant Database Management on a sample of your own strategies and last quarter's portal answers.