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
How it works
5 steps. Nothing is written or sent until step 4.
- Pulls the recordsFrom each source
- Compares every recordNot a sample
- Sorts the differencesFormatting versus real breaks
- A person approvesOperations reviewsApproves fixes
- 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?
Tell us the taskWe build it with you, from data access to the first production run in 5 working days.