<< All versions
Skill v1.0.0
Trusted Publisher100/100google-gemini/gemini-managed-agents-templates/reconciliation
──Details
PublishedMay 19, 2026 at 10:30 PM
Content Hashsha256:d7006449932abe83...
Git SHA
──Files
Files (1 file, 2.3 KB)
SKILL.md2.3 KBactive
SKILL.md · 52 lines · 2.3 KB
version: "1.0.0" 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
bash
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.csvfrom.agents/workspace/(columns: date, employee, merchant, category, amount, memo). - Loads
parsed_invoices.jsonfrom.agents/workspace/(generated by thepdf-parsingskill). - 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.mdwith summary stats and discrepancy tables. - Generates
.agents/workspace/reconciliation_data.jsonwith 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 |