reconciliation

# Reconciliation Reconcile expenses from `expenses.csv` against the pre-parsed invoice database (`parsed_invoices.json`) completely locally (offline). It compares records, performs fuzzy merchant matching, and generates a detailed discrepancies report. ## Embedded Script ```bash python3 skills/reconciliation/scripts/reconcile.py --workspace .agents/workspace ``` ### Arguments | Argument | Default | Description | |----------|---------|-------------| | `--workspace` | `.agents/workspace` | Workspace directory containing expenses.csv and parsed_invoices.json | | `--tolerance` | `0.01` | Amount match tolerance in dollars | ### What it does 1. Loads `expenses.csv` from `.agents/workspace/` (columns: date, employee, merchant, category, amount, memo). 2. Loads `parsed_invoices.json` from `.agents/workspace/` (generated by the `pdf-parsing` skill). 3. Performs local fuzzy matching between expenses and invoice records (normalized merchant names, amount tolerance). 4. Flags discrepancies: Amount Mismatch, Missing Invoice, Unmatched Invoice, Merchant Mismatch. 5. Generates `.agents/workspace/reconciliation_report.md` with summary stats and discrepancy tables. 6. Generates `.agents/workspace/reconciliation_data.json` with machine-readable matched results. ### Dependencies *None! This script runs 100% locally with zero external API calls.* ## Discrepancy Types | Type | Description | |------|-------------| | **Amount Mismatch** | Expense and invoice matched by merchant but amounts differ beyond tolerance | | **Missing Invoice** | Expense record exists with no matching invoice document | | **Unmatched Invoice** | Invoice document exists with no matching expense record | | **Merchant Mismatch** | Expense and invoice matched by amount but merchant names differ significantly | ## Output | File | Path | Description | |------|------|-------------| | Reconciliation Report | `.agents/workspace/reconciliation_report.md` | Human-readable markdown report with summary stats, discrepancy table, and matched items | | Reconciliation Data | `.agents/workspace/reconciliation_data.json` | Structured JSON with expenses, invoices, matches, and discrepancies |