# Reconciliation Analytics

> Performs reconciliation analysis between systems, ledgers, and reports to identify breaks, root causes, and corrective actions. Use when validating financial consistency across sources.

- Skill: `bkjohn2018/reconciliation-analytics` (Agent Skill)
- Install (CLI): `npx skillmds@latest add bkjohn2018/reconciliation-analytics`
- Raw SKILL.md: https://api.skillmd.com/api/skills/bkjohn2018/reconciliation-analytics/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: bkjohn2018 (https://skillmd.com/u/bkjohn2018)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/bkjohn2018/reconciliation-analytics

---


# Reconciliation Analytics

## When to Use
- System-to-system or report-to-ledger mismatch investigations.
- Period close control activities.
- Requests for break analysis and reconciliation packs.

## Workflow
1. Define reconciliation scope, grain, and matching keys.
2. Align extraction timing and cutoff assumptions.
3. Match records and classify unmatched or mismatched items.
4. Quantify breaks by type, aging, and materiality.
5. Propose fixes and prevention controls.

## Output Template
```markdown
# Reconciliation Pack

## Scope
- Source A:
- Source B:
- Cutoff:
- Grain:

## Match results
- Matched count:
- Unmatched count:
- Net break amount:

## Break categories
- Timing:
- Mapping:
- Missing records:
- Calculation differences:

## Actions
1. ...
```

## Quality Checklist
- Matching logic and assumptions are explicit.
- Breaks are categorized with root-cause hypotheses.
- Materiality and aging are quantified.
- Remediation owners and ETAs are assigned.