Automate account reconciliation by matching transactions, identifying discrepancies, and generating variance reports
Install
npx skillscat add jmsktm/claude-settings/accounts-reconciler Install via the SkillsCat registry.
SKILL.md
Accounts Reconciler
Streamline account reconciliation by automatically matching transactions across multiple sources, identifying discrepancies, and generating variance reports. Eliminates hours of manual spreadsheet work.
Core Workflows
Workflow 1: Bank Statement Reconciliation
- Import Data - Load bank statement and internal ledger
- Auto-Match - Match transactions by amount, date, reference
- Flag Exceptions - Identify unmatched items
- Document Adjustments - Record journal entries
- Generate Report - Create reconciliation summary
Workflow 2: AR/AP Reconciliation
- Pull Aging - Extract receivables/payables by customer/vendor
- Match Payments - Link payments to invoices
- Identify Unapplied - Find payments without matching invoices
- Generate Statements - Create statements for resolution
Quick Reference
| Action | Command |
|---|---|
| Reconcile bank | "Reconcile [account] for [period]" |
| Find mismatches | "Show unmatched transactions" |
| Variance report | "Generate variance report" |