| name | reconciliation |
| description | Reconcile loaded expenses against the pre-parsed invoice database, flagging discrepancies like amount mismatches, missing invoices, and merchant mismatches locally. |
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
| 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
- Loads
expenses.csv from .agents/workspace/ (columns: date, employee, merchant, category, amount, memo).
- Loads
parsed_invoices.json from .agents/workspace/ (generated by the pdf-parsing skill).
- Performs local fuzzy matching between expenses and invoice records (normalized merchant names, amount tolerance).
- Flags discrepancies: Amount Mismatch, Missing Invoice, Unmatched Invoice, Merchant Mismatch.
- Generates
.agents/workspace/reconciliation_report.md with summary stats and discrepancy tables.
- 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 |
