Reconciliation
If you're building or fixing position, cash, or transaction reconciliation workflows for an RIA or broker-dealer, this walks you through the full stack: daily position matching across PMS and custodian, three-way reconciliation when you've got advisor system plus custodian plus clearing firm, break investigation patterns, tolerance thresholds, and cost basis reconciliation at the tax lot level. It covers the messy stuff like corporate action breaks, multi-custodian data normalization (Schwab, Fidelity, Pershing feeds), and accrued income discrepancies from day-count conventions. Useful if you're diagnosing recurring breaks, designing escalation workflows, evaluating platforms like Arcesium or Duco, or prepping for a regulatory exam on books and records accuracy.
- skills.sh installs
- 707
- GitHub stars
- 224
- last updated
- Aug 21, 2026
Install
$ npx -y skills add joellewis/finance_skills --skill reconciliation --agent claude-codeInstalls into .claude/skills of the current project.
Files
Reconciliation
Core Concepts
1. Reconciliation Types and Hierarchy
Reconciliation is the systematic comparison of records across two or more systems to identify and resolve discrepancies. In securities operations, reconciliation ensures that the firm's internal records (the investment book of record, or IBOR) match the custodian's official records (the official book of record, or OBOR) and, where applicable, the clearing firm's records. The reconciliation hierarchy proceeds from the most fundamental data element (positions) through increasingly derived data elements.
Position Reconciliation. The foundational reconciliation. Compares the number of shares or units held for each security in each account between the firm's portfolio management system (PMS) and the custodian. Position reconciliation is typically zero-tolerance: any share count difference, no matter how small, constitutes a break. Fractional share differences (common with dividend reinvestment plans) must also be identified and resolved. Position reconciliation is performed daily, using end-of-day files from the custodian compared against the PMS position ledger.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/joellewis/finance_skills
- Categories
- Design & UI/UX, Finance & Trading
- First seen
- Jun 3, 2026
More from joellewis/finance_skills
All 84- Regulatory Reporting707
- Exchange Connectivity706
- Operational Risk706
- Settlement Clearing706
- Performance Attribution705
- Alternatives703
- Margin Operations702
- Advice Standards701
- Client Onboarding701
- Fixed Income Structured701
- Counterparty Risk700
- Pre Trade Compliance699
- Order Management Advisor698
- Books And Records697
- Corporate Actions693
- Fixed Income Municipal693
- Reference Data692
- Crm Client Lifecycle691
- Post Trade Compliance691
- Advisor Dashboards690
- Gips Compliance689
- Integration Patterns688
- Account Opening Compliance687
- Account Maintenance686
Recommended
More Design & UI/UX
exchange-connectivityjoellewis/finance_skillsGuide the design and management of trading venue connectivity and market data infrastructure. Owns the FIX session layer (logon, heartbeats, sequence number gap706skills.sh installsperformance-attributionjoellewis/finance_skillsDecompose portfolio returns into explainable components to identify where value was added or lost. Use when the user asks about Brinson attribution, allocation 705skills.sh installs
agent-designeralirezarezvani/claude-skillsUse when the user asks to design a multi-agent system, pick an orchestration pattern (supervisor/swarm/pipeline), generate tool schemas for agents, or evaluate 703skills.sh installsclient-onboardingjoellewis/finance_skillsDesign and implement end-to-end client onboarding workflows from prospect intake through funded account, covering KYC verification, document collection, e-signa701skills.sh installspre-trade-compliancejoellewis/finance_skillsGuide the design and implementation of automated pre-trade compliance systems that validate orders before execution. Use when building a compliance rule engine 699skills.sh installs
view-transitionspatternsdev/skillsTeaches the View Transitions API for animating DOM changes. Use when you want smooth animated transitions between pages or UI states without manual animation co699skills.sh installs