reconciliation

by google-gemini

Reconcile loaded expenses against the pre-parsed invoice database, flagging discrepancies like amount mismatches, missing invoices, and merchant mismatches…

npx skills add https://github.com/google-gemini/gemini-managed-agents-templates --skill reconciliation

Download ZIP GitHub

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