Agent library / Data and reporting / Quarterly reporting assembly
Quarterly reporting assembly
PitCrew assembles quarterly client reports from your portfolio and custodian data and checks them before release: totals agree, periods line up and unusual returns are flagged for review.
When it runsEach quarter
Who approvesOperations and advisors
Works withPortfolio system export, custodian data
How it works
5 steps. Nothing is written or sent until step 4.
- Pulls the dataFor every household
- Assembles reportsTo your template
- Checks the numbersTotals, periods, outliers
- A person approvesA person reviewsFlagged reports
- ReleasesOn approval
What it reads and what it produces
Reads
- Portfolio data
- Your report template
Produces
- Client reports
- A list of reports needing review, with the reason
Rules it follows
- Flags outliersUnusual returns are checked before release.
- Never releases on its ownA person approves.
Questions firms ask
Last updated: October 2026
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 →
Custodian to CRM reconciliationCompares custodian, CRM and portfolio records and flags the real differences.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.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.