Skip to main content
Platform Agent library
Marketing and referrals Prospects and proposals Client onboarding Client meetings Client service Portfolio oversight Billing and fees Data and reporting Compliance and risk
Wealth Management / RIA Family Office Fund Administration Asset Management Private Equity Venture Capital Pension / Endowments RIA Aggregators
Factory Platform of Work Trust About Us Login Get in touch
Agent library / Data and reporting / Custodian to CRM reconciliation

Custodian to CRM reconciliation

PitCrew compares records across your custodian data, CRM and portfolio system, resolves formatting differences by your rules, and flags real differences for your team. Nothing is changed without approval.

When it runsDaily, or on the schedule you set
Who approvesOperations
Works withCustodian data, CRM, portfolio system export
Get in touchDescribe your version of this task

How it works

5 steps. Nothing is written or sent until step 4.

  1. Pulls the recordsFrom each source
  2. Compares every recordNot a sample
  3. Sorts the differencesFormatting versus real breaks
  4. A person approvesOperations reviewsApproves fixes
  5. Logs itEvery decision with the reason

What it reads and what it produces

Reads

  • Custodian data
  • CRM records
  • Portfolio system export

Produces

  • An exception report
  • Proposed fixes
  • A log of every decision

Rules it follows

  • Never changes data on its ownFixes wait for approval.
  • Explains each breakWhich systems disagree and how.

Questions firms ask

Last updated: October 2026

Will it change our data?

No. It proposes fixes. Your team approves before anything is written.

Where does the account data come from?

From the custodian and portfolio data your firm already receives each day, such as positions, balances and transactions.

How long does it take to set up?

5 working days from data access to the first production run. PitCrew experts connect your systems and enter your firm's rules.

More in Data and reporting

See all of Data and reporting →

Statement parsing, Schwab and FidelityReads Schwab and Fidelity statements into clean, structured data.Custodian data feed monitoringChecks custodian data arrives complete and on time, before your team works from stale data.Missing data fill-inFinds blank fields in your CRM and proposes values from documents on file.CRM clean-up and duplicatesFinds duplicate contacts and messy records in your CRM and proposes clean-ups.Change sync across systemsTakes one approved change, such as a new address, and updates it in every connected system.Settings change detectionSpots changes to settings that matter, such as fee schedules and permissions, and asks who approved them.Source documents into the CRMPulls key facts from client documents into the right CRM fields, with a link to the source.Document filing and clean-upNames and files documents into the right household folder, and tidies old folders.Quarterly reporting assemblyAssembles quarterly client reports and checks the numbers before they go out.Management reporting packAssembles the monthly pack for partners: assets, flows, new and closed accounts by advisor.Form ADV numbersPulls the assets, account and client counts your Form ADV amendment needs.RFP and due diligence questionnairesDrafts answers to RFPs and due diligence questionnaires from your approved past answers and documents.
Don't see your work?

We build it with you, from data access to the first production run in 5 working days.

Tell us the task