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