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

python3 skills/reconciliation/scripts/reconcile.py --workspace .agents/workspace

Arguments

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

Output