Client Reporting
Regulated environments where trust, compliance, and operational resilience are non-negotiable.
This interactive experience is the shipped product itself — the same application code customers run in production, mounted read-only in your browser over a real sample journey. Not a video, not a mockup: because the demo and the product are one codebase, it can never drift from the real thing.
Inside this journey
-
Outcome Discovery
Align on the missed-reporting root causes, stakeholders, reconciliation pain points, and measurable success criteria for timely, accurate quarterly reporting.
Discovery Questions
Tell the story of the quarter that missed its deadline
- Tell me about the most recent quarter-end where reports were late, what happened and who first raised the issue?
- Estimate how many client accounts required manual reconciliation during that cycle
- Which report types and client deliverables were delayed or required post-delivery corrections
- Who on your team handled the reconciliation work and how many full time equivalents did that consume for the quarter
- When you compare the final reports to the source systems, what were the most common reconciliation discrepancies you found
Where the data flow breaks and why it matters
- If another late or inaccurate quarter could cost you a client, which single reporting failure would make you walk away immediately
- Walk me through the reconciliation path from the custodian feed to the final client report for a single account, naming the systems and manual steps
- Describe the specific data fields or record types that most frequently mismatch between sources, for example positions, prices, or corporate actions
- On a typical quarter, where do exceptions most often appear in the pipeline — upstream in feeds, during calculations, or in template rendering
- If you could remove one manual step in that flow, which would it be and would removing it materially reduce your risk of late delivery
Who bears the risk and who makes the call
- Who ultimately signs off on quarterly client reports, and what objective criteria would lead them to withhold approval
- Which internal stakeholder groups must be informed before a production cutover and which must give explicit approval
- How many people across operations, compliance, and relationship teams are required to sign or review client reports
- Identify any internal groups that would resist replacing the current reporting process and the primary reason for their resistance
- Are you able to run a parallel production for one quarter while maintaining current client commitments, yes or no
What accuracy and timing actually look like for you
- What accuracy and delivery windows must any replacement achieve for you to be willing to commit within a single quarter
- Select the primary success metrics you will use during the sample-quarter evaluation
- Choose which tradeoffs would be acceptable during an initial rollout, minor formatting differences, small valuation footnotes, or phased cutover by client segment
- Estimate the annual revenue or assets under management at risk if a key institutional client left following a reporting failure
- Would procurement and legal be prepared to sign within two weeks if the sample-quarter met your stated metrics
The alternatives on your table
- Name the option you are most likely to pursue next, incumbent retention, building internally, or engaging a new vendor, and why
- List the vendors or internal efforts you have evaluated so far and the maturity stage of each effort
- Describe the specific improvements in reliability or cost that would make retaining your current process the rational choice
- Has anyone on your team proposed solving this without an outside vendor and what resource estimate did they provide in person-months
- Indicate which option would move to contract fastest if a sample quarter validated its value
Concrete readiness and technical gates
- Point to the single technical dependency that could stop the project before it begins, for example missing API access, unavailable custodian feeds, or no dedicated data owner
- Select the source systems that must be connected for the evaluation
- Who in your organization owns credentials and API access to each source system and are those credentials currently available for a vendor sandbox
- Provide your best percent range for how much of the source data you expect will require cleansing before ingestion, for example missing identifiers or stale prices
- Would you pause the evaluation if required systems could not provide data within two weeks, or would you extend internal deadlines to accommodate integration
Pilot criteria, cutover authority, and deal accelerators
- Point to the single failure mode during the sample-quarter that would cause you to halt the program immediately, for example a systemic valuation variance or more than 2% unresolved exceptions
- Choose the acceptance criteria you will use to judge the sample-quarter
- Who will be the formal sign-off authority for the sample-quarter results from compliance, operations, and client reporting
- Indicate the artifacts you expect to review during evaluation, for example raw reconciliation logs, a set of sample client reports, calculation worksheets, and run-time metrics
- Assuming the pilot meets all acceptance criteria, who can approve a phased cutover and what is the shortest realistic contract timeline you can accept
-
Solution Scope
Define integrations, performance-calculation rules, report template requirements, responsibilities, and acceptance criteria for the evaluation and rollout.
Scope Configuration
- Integrate custodian data feeds
- Connect portfolio accounting system
- Aggregate market and reference data feeds
- Map and normalize source data
- Run performance calculations and composite construction
- Configure report templates and branding
- Enable advisor self-service template builder
- Configure compliance disclosures and GIPS settings
- Generate client-ready reports (PDF, CSV, portal)
- Set up delivery workflows and digital portal access
- Run parallel production with legacy comparison
- Investigate and resolve reconciliation exceptions
Scope Questions
Integrate custodian data feeds
- Do you currently receive custodian feeds via SFTP, REST API, cloud bucket, or another transport? Indicate all that apply.
- Which custodians supply the feeds you want integrated for the evaluation quarter?
- What file formats and schemas do the custodian feeds use for positions and transactions (for example: CSV with CUSIP/ISIN columns, JSON position snapshots)?
- How often do those custodian feeds refresh during a quarter (end-of-day, intra-day, end-of-day plus trade blotter) for the accounts in scope?
- Who on your operations team owns custodian connectivity and can provide test endpoints and credentials for the sample quarter?
- When you run the evaluation, do you require historical feed replay for the quarter (full dated snapshots) or only a closing snapshot per day?
Connect portfolio accounting system
- Where does your primary portfolio accounting export come from (name your current platform category: hosted accounting system, in‑house ledger export, or administrator batch file)?
- Are ledger-level files available for positions, cash ledgers, corporate actions, and fees for the evaluation quarter?
- List the position identifier conventions used in your accounting export for the quarter (for example CUSIP, ISIN, internal position id).
- Provide the sample file or schema for trade-level and position-level exports that the integration will map against.
- Specify whether the accounting export includes composite tags or strategy codes needed to build performance composites for the sample quarter.
- Identify any known gaps between the accounting export and custodian feeds that historically cause reconciliation flags (for example missing corporate actions, cash mismatches).
Aggregate market and reference data feeds
- Confirm which pricing sources should be used for the evaluation quarter (vendor prices, custodian prices, in-house pricing, or a blended rule).
- Estimate how many unique securities (by CUSIP/ISIN) appear in the sample quarter that require pricing and corporate action handling.
- Indicate whether you require FX rates for cross-currency positions and, if so, the vendor or internal FX table to use for the quarter.
- Choose the reference data attributes required for reporting and reconciliations (for example: issuer name, security type, settlement currency, lot-level cost).
- Upload or describe any corporate-action rules or overrides you expect applied when reconstructing NAVs for the quarter (for example, treatment of spin-offs or mergers).
- Attach any SLA or currency valuation cut-off times the platform must obey for generating quarter-end pricing.
Map and normalize source data
- Enter the primary mapping keys to align custodian and accounting records (for instance: account number, position id, trade id).
- Select which identifier precedence rule to use when resolving mismatched securities across feeds.
- Describe any custom normalization rules needed for security descriptions, corporate actions, or fee codes in your operations workflow.
- Outline expected tolerances for numeric normalization (price rounding, quantity rounding) used when comparing position-level values across sources.
- Explain how you currently handle orphan trades or unmatched cash items so the mapping rules can mirror or improve that process.
- State whether you require an automated mapping workbook that documents field-level transforms for handoff to your operations team.
Run performance calculations and composite construction
- Name the performance standards you require for the evaluation (for example: GIPS total return, time-weighted rate of return).
- Share your current composite definitions and the rules used to include accounts in each composite for the sample quarter.
- Mark whether you require gross-of-fees, net-of-fees, or both performance series for each composite.
- Flag any adjustments or overrides applied in your legacy calculations that must be reproduced (for example: manual cash flow timing corrections).
- Clarify the desired attribution granularity for the evaluation (composite-level, account-level, sector allocation).
- Verify whether you require a reconciliation report that traces each performance line back to the source ledger entries for audit purposes.
Configure report templates and branding
- Approve the list of templated report sections required for the quarter (for example: executive summary, performance tables, holdings, transactions, disclosures).
- Set the branding and style constraints for PDF output (logo placement, fonts, color palette, page size) that must be enforced for compliance review.
- Apply any client-specific layout requirements that advisors currently request and want available in the template builder.
- Map which disclosure blocks must be conditionally included based on composite type or jurisdiction (for example: GIPS composite disclosure, country-specific tax notes).
- Normalize your current PDF generation cadence and indicate whether single PDF per client or split PDFs per account are required.
- Describe any accessibility or archive format requirements for generated reports (for example: searchable PDF, PDF/A, CSV attachments).
Enable advisor self-service template builder
- Define which advisor roles should have template edit rights and which should be view-only during the evaluation period.
- Describe the types of drag-and-drop template elements advisors must be able to configure (tables, charts, disclosures, custom text blocks).
- Name any template validations required by compliance (for example: mandatory disclosure present, minimum font size) that the builder must enforce.
- Share whether you need version history and approval workflows inside the template builder for each template change.
- Indicate whether advisor templates must support conditional content per client jurisdiction or investor type.
- Verify the maximum number of distinct advisor templates you will provision for the evaluation (estimate).
Configure compliance disclosures and GIPS settings
- Name the specific GIPS reporting elements you require in the evaluation (composite descriptions, benchmark definitions, performance history).
- Share whether your compliance team requires automated verification of GIPS-required fields before PDF generation.
- Mark any jurisdictional disclosure text blocks that must be included based on client country in the sample quarter.
- Outline how fees, soft dollars, or fee waivers are recorded in your accounting export so net-of-fees calculations align with compliance expectations.
- Clarify whether you need a compliance sign-off workflow for each template iteration during evaluation.
- Confirm any record-retention or audit log requirements for generated reports tied to GIPS validation.
Generate client-ready reports (PDF, CSV, portal)
- List the report outputs you need for the quarter: consolidated client PDF, per-account PDF, CSV holdings, or portal-only dashboards.
- Which export formats require exact legacy parity in layout and pagination for client comparison?
- How long is acceptable for the platform to generate the full set of evaluation quarter PDFs compared with your legacy process (provide a target threshold).
- Provide a measurable acceptance criterion for report accuracy and formatting parity for the evaluation (for example: >= 99.5% position-level match, PDF page sequence identical).
- Select whether the evaluation must include embedded drill-downs in the portal and which user groups should access them.
- State any encryption, watermarking, or redaction rules that must be applied to PDFs before delivery in the sample run.
Set up delivery workflows and digital portal access
- Select the delivery channels required for the evaluation quarter: secure portal push, SFTP delivery to custodian, email with secure link, or API delivery to an LMS.
- Assign the stakeholder list who must receive reports or notifications for the evaluation (operations contact, compliance reviewer, relationship manager).
- Set any delivery timing constraints relative to quarter close (for example: reports delivered within 3 business days of quarter close).
- Establish portal authentication method for client and advisor users during the evaluation (single sign-on, email magic link, username/password).
- Determine retention and access controls for delivered reports in the portal (how long should historical quarter PDFs be retained and who can access them).
- Authorize any required network or firewall changes to allow portal callbacks or SFTP deliveries for test endpoints.
-
Sample-Quarter Evaluation
Load one quarter of the buyer's actual portfolio data to validate performance calculations, formatting flexibility, reconciliation handling, and production speed versus legacy outputs.
- success_criteria
- gaps
- current_state
- desired_state
- stakeholders
- decision_readiness
- stakeholders
- gaps
- desired_state
- success_criteria
- decision_readiness
- current_state
- stakeholders
- current_state
- desired_state
- decision_readiness
- gaps
- success_criteria
- decision_readiness
- decision_readiness
- decision_readiness
- decision_readiness
-
Mutual Commit
Finalize commercial and legal terms, sign off on evaluation acceptance criteria, and confirm the parallel-production cutover plan and timeline.
Agreement Modules
- Master Services Agreement (MSA)
- Order Form / Subscription Agreement
- Statement of Work (SOW)
- Evaluation Acceptance Certificate
- Parallel Production Cutover Plan & Timeline
- Financial Services Data Addendum (DPA & Residency/SOC 2)
- Service Level Agreement (SLA)
- Commercial Terms Appendix (Pricing & Payment Details)
- Change Order Agreement
-
Deployment
Lock readiness facts and configuration values before execution begins.
-
Pre-Deployment Readiness
Confirm concrete readiness facts the deployment depends on — data feed endpoints, reconciliation exception owners, test windows, and stakeholder contacts.
Pre-Deployment Questions
Environment and site access
- Which production environments/endpoints will the deployment connect to? (Select all that apply — we use these categories to scope connectors and test environments.)
- Are production integration credentials and required service accounts available for the endpoints you selected? (If partially available or not available, we will schedule follow-up to capture availability dates.)
Data and configuration
- Which system has been agreed as the single source of truth for positions, trades, and corporate actions used in performance calculations?
- Is the field-mapping approach and the performance-calculation rule set approved, and who owns final approval? (Provide owner name and role — this person will sign off on sample-quarter acceptance.)
People and ownership
- For reconciliation exception types (price mismatch, position mismatch, cash movement, corporate actions), list the named owner (name and role) for each exception type — these owners will receive escalation items during evaluation and production.
- Who is the primary deployment-day contact and the designated backup (name, role, preferred phone or email)? The deployment team will contact them for coordination and incident escalation.
Timing and constraints
- Are there blackout windows, regulatory filing freezes, or quarter-end access restrictions that prohibit testing or cutover? (If yes, list date ranges — this prevents scheduling conflicts.)
- Has a parallel-production test window (minimum one full quarter run) been approved and scheduled? If yes, indicate the target start date; if not, name the approval owner required to schedule it.
-
Integration & Configuration
Capture exact integration credentials, field mappings, reconciliation rules, template mappings, and compliance checkpoints the deployment team will use.
Configuration Details
Environments & Endpoints
- Enter the canonical name for the production environment this deployment will target (e.g., 'prod-reporting-01') — exact value the build will use
- Enter the production API base URL for the platform (format: https://your-subdomain.example.com/) — the connector settings page requires this exact URL
Authentication & Credential Handover
- Select the authentication method your custodian/feed endpoint requires (the build will configure the connector to expect this method)
- Enter the non-secret integration identifier your source requires (e.g., client_id, integration user name, or API key name). Do NOT paste secrets or tokens.
- Enter the role or title of the person who owns the credential exchange for the source (e.g., 'Reconciliation Team Lead') — used to schedule secure transfer
- Select the secure channel you will use to transmit secrets at deployment kickoff (the build will expect secrets to arrive via this channel)
Data Field Mappings
- Choose the primary source system type for positions and transactions that the integration will ingest
- Enter the canonical field-mapping document location the build should consume (format: s3://bucket/path OR https://host/path OR SharedDrive:/folder/path) — must point to the authoritative mapping file
- Enter the exact source field name used as the primary account key in your source data (case-sensitive; e.g., 'AccountNumber') — the build will use this field to join data
Reconciliation Rules & Exceptions
- Enter the numeric tolerance (%) the automated reconciliation engine should treat as acceptable mismatch before opening an exception. Default is 0.05 — enter number only (e.g., 0.05)
- Enter the role/title that will own reconciliation exceptions raised by the automated process (e.g., 'Head of Client Reporting') — single role title only
- Select how reconciliation exceptions should be routed/alerted (the build wires notifications to your chosen channel)
Report Template Mapping & Acceptance
- Enter the report-template mapping file location the build will import (format: s3://bucket/path OR https://host/path OR SharedDrive:/folder/path) — must be the exact file the template engine will read
- Select the acceptance criteria variant the buyer will use for the sample-quarter evaluation (the evaluation runner will apply this rule)
- If you selected 'Within formatting/performance tolerance' above, enter the numeric tolerance (%) to apply (Default 0.10). If not applicable, enter 0
-
Deployment
Execute feed integrations, build and test report templates, run parallel production, train advisors, and manage cutover with clear owners and milestones.
-
-
Success
Validate that production reports meet the agreed accuracy and timeliness metrics, capture lessons learned, and track issues and enhancement requests.
Success Reviews
- Go-live health check (weeks 1-4)
- First measurement review (weeks 4-10)
- Acceptance gate review (around day 90)
- Quarterly success review (ongoing)
Issues & Enhancements
- Run a quarterly training refresher for advisor teams on template configuration to reduce ad-hoc requests and formatting exceptions.
- Document any calculation differences versus legacy outputs with a client-facing explanation for advisor review.
- Deliver the finalized acceptance dataset and report package to reviewers ahead of the acceptance gate meeting.
- Restate acceptance criteria and targets
- Formal acceptance decision recorded with a named buyer signatory for the acceptance outcome.
- Remediation items for any failed criteria documented with owners and resolution dates.
- Incumbent system decommissioning or retention and data archive plan documented to prevent dual-running.
- Publish the acceptance decision and remediation log including the named buyer signatory into the shared workspace.
- Execute the agreed incumbent decommission or read-only retention steps and deliver the data archive/migration status report.
- Open tickets for each remediation item with target resolution dates and escalate any items that block full acceptance.
- KPI trend review since acceptance
- Maintain or improve percent of reports delivered within the target window and reduce reconciliation exception rate quarter over quarter.
- Ensure critical tickets are on a documented burn-down path with owners and dates.
- Agree a prioritized list of enhancement requests that impact delivery or accuracy with scheduling decisions.
- Close or escalate high-priority production tickets and publish the updated burn-down status before the next review.
- Schedule approved enhancement work into the next delivery window and publish scope and timelines.
- Re-confirm success criteria and owners
- Confirm integrations are running and scheduled jobs completed without critical errors.
- Verify that core users have access and initial training is complete.
- Triage and assign owners and target dates for all open blockers requiring remediation in the first 30 days.
- Produce a short remediation plan listing each open integration or data exception, its root cause hypothesis, and an owner with a target resolution date.
- Run a signed-off smoke test of the primary report generation flow and circulate results to stakeholders.
- Enable monitoring alerts for connector errors and scheduled a daily check-in until stability is confirmed.
- Present first-period metrics and legacy comparison
- Establish whether average days late per quarter and reconciliation exception count per quarter are trending toward Solution Scope targets.
- Agree the top 3 root causes for any metric gaps and assigned corrective actions with dates.
- Confirm the timeline and dataset readiness for the acceptance gate review.
- Implement agreed reconciliation rule changes and retest the sample-quarter calculation to verify exception reduction.
- Present outcome data against each acceptance criterion
- Operational issues and ticket burn-down
- Deployment and integration validation
- Diagnose gaps and root causes
- Document pass or fail per criterion and capture acceptance
- User access and onboarding status
- Enhancement requests and prioritization
- Validate performance-calculation alignment
- Verify incumbent system is not being used
- Agree remediation plan for any failed criteria
- Early adoption and usage signals
- Prioritize corrective actions and timeline to acceptance gate
- Confirm readiness items for the acceptance dataset
- Incumbent system wind-down confirmation
- Agree next steps and owners
- Open issues, blockers, and immediate remediation