israellias/reconcile

Weekly Reconciliation

All python commands MUST use .venv/bin/python (not python or python3).

When the user runs this skill:

Phase 1 — Sync all pipelines

Run all 4 pipelines sequentially. Track the import results (imported/duplicates) for each.

1. Invoke /sync-baneco --auto-accept — note the imported/duplicates counts from the output
2. Invoke /sync-bisa --auto-accept — note the imported/duplicates counts from the output
3. Invoke /sync-sol --auto-accept — note the imported/duplicates counts from the output
4. Run Binance pipeline directly (no AI categorization needed): .venv/bin/python -m binance Parse the "Imported X transactions (Y duplicates skipped)" line from output.

Phase 2 — Collect balances

5. Get bank/exchange balances from exported data:

   • Baneco: .venv/bin/python -c "from baneco import get_last_balance; print(get_last_balance())"
   • BISA: .venv/bin/python -c "from bisa import get_last_balance; print(get_last_balance())"
   • Banco Sol: .venv/bin/python -c "from sol import get_last_balance; print(get_last_balance())"
   • Binance: .venv/bin/python -c "from binance import get_usdt_balance; print(get_usdt_balance())"

6. Get YNAB account balances:

   • Baneco: .venv/bin/python -c "import json; from baneco import get_ynab_balance; print(json.dumps(get_ynab_balance()))"
   • BISA: .venv/bin/python -c "import json; from bisa import get_ynab_balance; print(json.dumps(get_ynab_balance()))"
   • Banco Sol: .venv/bin/python -c "import json; from sol import get_ynab_balance; print(json.dumps(get_ynab_balance()))"
   • Binance: .venv/bin/python -c "import json; from binance import get_ynab_balance; print(json.dumps(get_ynab_balance()))"

   YNAB balances are in milliunit format (× 1000). Divide by 1000.0 to get the human-readable amount.

Phase 3 — Reconciliation report

6. Print a summary using this format:

## Weekly Reconciliation — {today's date}

### Sync Results
| Pipeline   | Imported | Duplicates |
|------------|----------|------------|
| Baneco     | {n}      | {n}        |
| BISA       | {n}      | {n}        |
| Banco Sol  | {n}      | {n}        |
| Binance    | {n}      | {n}        |

### Balance Comparison (BOB Budget)
| Account    | Bank Balance | YNAB Balance | Diff    | Status |
|------------|-------------|--------------|---------|--------|
| Baneco     | {x} Bs      | {y} Bs       | {diff}  | {ok}   |
| BISA       | {x} Bs      | {y} Bs       | {diff}  | {ok}   |
| Banco Sol  | {x} Bs      | {y} Bs       | {diff}  | {ok}   |

### Balance Comparison (USD Budget)
| Account  | Exchange      | YNAB Balance | Diff    | Status |
|----------|--------------|--------------|---------|--------|
| Binance  | {x} USDT     | {y} USD      | {diff}  | {ok}   |

Status column rules:

• Diff == 0 (or within 0.01): show checkmark
• Diff != 0: show warning sign

7. If there are discrepancies, add a "### Discrepancy Analysis" section listing possible causes:

   • Recent transaction not yet synced
   • Rounding difference in conversion
   • Pending/uncleared transactions
   • Manual adjustment needed

8. NEVER make changes automatically to fix discrepancies. Only report them.

Notes:

• If Binance balance is None (balance.json not found), note it as "N/A" in the table
• If any pipeline fails, still continue with the others and note the failure
• Bank balances from CSVs reflect the balance at the time of the last transaction in the export