What types of reconciliation does this skill support?

It covers position, cash, transaction, market value, accrued income, and cost basis reconciliation across multiple internal and external systems.

Can it help with multi-custodian data normalization?

Yes, it provides strategies for normalizing data across various custodian feeds, including major providers like Schwab, Fidelity, and Pershing.

Does it support three-way reconciliation?

Yes, it includes standard practices for matching records between an advisor's portfolio management system, the custodian, and the clearing firm.

Is this skill useful for regulatory compliance?

Absolutely. It helps ensure books and records accuracy to satisfy fiduciary obligations and prepare for regulatory examinations.

How does it handle reconciliation discrepancies or breaks?

The skill guides the design of break investigation workflows, including setting tolerance thresholds, classifying root causes, and managing aging and escalation.

Financial Data Reconciliation

Name: Financial Data Reconciliation
Author: JoelLewis

byJoelLewis

•

生产力与工作流

Designs and manages robust reconciliation workflows to ensure data accuracy across portfolio management, custodian, and clearing systems.

The Reconciliation skill provides comprehensive guidance for establishing and maintaining financial reconciliation processes within securities operations. It covers essential reconciliation types—including position, cash, transaction, and cost basis—while addressing complex scenarios like three-way reconciliation between advisors, custodians, and clearing firms. It helps users define tolerance thresholds, implement automated break investigation workflows, and ensure regulatory compliance for books and records, making it an essential tool for developers and operations teams building or optimizing investment management platforms.

主要功能

0118 GitHub stars

02Automated break identification, categorization, and aging workflows

03Data normalization patterns for multi-custodian feeds like Schwab and Fidelity

04Three-way reconciliation frameworks (Advisor vs. Custodian vs. Clearing)

05Cost basis and accrued income verification for tax reporting accuracy

06Multi-tier reconciliation logic for position, cash, and transaction matching

使用场景

01Diagnosing recurring breaks caused by corporate actions or pricing differences

02Preparing for regulatory examinations by validating books and records accuracy

03Building an automated daily position and cash reconciliation engine for an RIA

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add joellewis/finance_skills reconciliation

For use in Claude.ai and ChatGPT

Download Skill