app.gopitcrew.com / skills / reconcile-data
Step 1 / 4
Pulling records from connected systems
contacts
CRM
Connecting...
-- records
Name Address Phone Email Account Owner
account_balance
Custodian
Connecting...
-- records
Account # AUM Contact Address
pie_chart
Portfolio System
Connecting...
-- records
Holdings AUM Model Performance
receipt_long
Accounting
Connecting...
-- records
Fees Billed Revenue Invoices
Step 2 / 4
Comparing records across systems
Matching fields across 4,568 records...
0 / 4,568 0%
Client Name
Johnson Family Trust vs Johnson Family Trust
check_circle
Account Number
4821-7734 vs 4821-7734
check_circle
Address
142 Oak Ln vs 142 Oak Lane
sync
AUM
$4,231,500 vs $4,231,500
check_circle
Contact
Priya Patel vs Priya R Patel
sync
Account Owner
M. Brooks vs T. Brooks
error
Step 3 / 4
Exception Report
check_circle Reconciliation Complete
0
Compared
0
Matched
0
Auto-resolved
0
Needs Review
Client Field Source A Source B Status
Johnson Family Trust AUM $4,231,500 $4,231,500 Match
Chen, Margaret Address 142 Oak Ln 142 Oak Lane Resolved
Patel Holdings LLC Contact Priya Patel Priya R Patel Resolved
Rivera, Carlos AUM $892,100 $847,300 Review
Brooks Irrevocable Trust Account Owner M. Brooks T. Brooks Review
Step 4 / 4
Evidence Trail
download Export PDF
09:00:01 AM
Reconciliation initiated across 4 systems
CRM, Custodian, Portfolio System, Accounting
09:00:03 AM
Pulled 4,568 records, 18 fields per record
Full population comparison, no sampling
09:00:12 AM
4,412 records matched across all systems
96.6% match rate, 0 conflicts
09:00:14 AM
Address normalized: 142 Oak Ln → 142 Oak Lane
Rule: Street suffix expansion, confidence 99.8%
09:00:14 AM
Name normalized: Priya Patel → Priya R Patel
Rule: Middle initial expansion, custodian is source of truth
09:00:15 AM
AUM mismatch flagged: $892,100 vs $847,300
Rivera, Carlos. Variance: $44,800 (5.0%). Requires human review.
09:00:15 AM
Account owner conflict: M. Brooks vs T. Brooks
Brooks Irrevocable Trust. No auto-resolve rule. Flagged for review.
09:00:16 AM
Reconciliation complete. Report delivered.
143 auto-resolved, 13 flagged for review, full audit trail generated