reconciliation
Reconcile loaded expenses against the pre-parsed invoice database, flagging discrepancies like amount mismatches, missing invoices, and merchant mismatches locally.
ソース情報
- リポジトリ
- google-gemini/gemini-managed-agents-templates
- ソースの最終更新活動
- 2026年5月16日 16:27
- 検出された SKILL.md の言語
- 英語
- スター
- 95
- フォーク
- 38
インストール方法
デフォルトでは、最初にソースを確認する Prompt が選択されています。直接コマンドに切り替えるか、ローカルコピーをダウンロードすることもできます。
ソースファイルを確認
インストールを決める前に、SKILL.md と SkillsMP に表示されている付属ファイルをお読みください。
ファイルエクスプローラー
2 ファイルSKILL.md を表示中
SKILL.md
ソースの指示 · 読み取り専用プレビュー- 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
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 |
GitHubで見る