reconciliation

將已載入的費用與預先解析的發票資料庫進行比對，標記出金額不符、遺漏發票及商家不匹配等差異…

npx skills add https://github.com/google-gemini/gemini-managed-agents-templates --skill 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

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