# Reconciliation

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

- Skill: `google-gemini/reconciliation` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add google-gemini/reconciliation`
- Raw SKILL.md: https://api.skillmd.com/api/skills/google-gemini/reconciliation/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Finance & Business
- Author: Google Gemini (https://skillmd.com/u/google-gemini)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/google-gemini/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

```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

1. Loads `expenses.csv` from `.agents/workspace/` (columns: date, employee, merchant, category, amount, memo).
2. Loads `parsed_invoices.json` from `.agents/workspace/` (generated by the `pdf-parsing` skill).
3. Performs local fuzzy matching between expenses and invoice records (normalized merchant names, amount tolerance).
4. Flags discrepancies: Amount Mismatch, Missing Invoice, Unmatched Invoice, Merchant Mismatch.
5. Generates `.agents/workspace/reconciliation_report.md` with summary stats and discrepancy tables.
6. 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 |