CSV Reconciliation Engine

Spreadsheet reconciliation is tedious and error-prone. This engine takes two or more CSV/Excel files, matches records using configurable rules (exact match, fuzzy match, threshold-based), identifies discrepancies, and produces a clean exception report. Built for finance teams who spend hours cross-referencing data every week.

What's included

• Python reconciliation engine with configurable matching rules
• Fuzzy matching for names, addresses, and reference numbers
• Multi-file support (CSV, Excel, JSON inputs)
• Exception report generator (CSV + HTML summary)
• Threshold-based matching with confidence scores
• Scheduled run support with email notifications
• Sample datasets for testing
• README with configuration examples

Who this is for

• Finance teams reconciling bank statements against ledgers
• Logistics companies matching delivery records to orders
• HR departments comparing payroll data across systems
• Any business matching data from two or more sources weekly