Accounts Reconciler

Automate account reconciliation by matching transactions, identifying discrepancies, and generating variance reports

Lord1Egypt Updated 2 repo stars

File contents

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

  1. Import Data - Load bank statement and internal ledger
  2. Auto-Match - Match transactions by amount, date, reference
  3. Flag Exceptions - Identify unmatched items
  4. Document Adjustments - Record journal entries
  5. Generate Report - Create reconciliation summary

Workflow 2: AR/AP Reconciliation

  1. Pull Aging - Extract receivables/payables by customer/vendor
  2. Match Payments - Link payments to invoices
  3. Identify Unapplied - Find payments without matching invoices
  4. 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"

Lord1Egypt/awesome-skill-forge/tree/main/community/skills_sh/s/skills-sh_jmsktm_claude-settings_accounts-reconciler commit e646cfcaa7

Frequently asked questions

npx skillmds@latest add lord1egypt/accounts-reconciler