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