israeli-bank-reconciliation

Reconcile Israeli bank transactions against accounting records using israeli-bank-scrapers.

Updated Jan 9, 2026
One-click install
npx skills add https://github.com/amitpo23/cfo --skill israeli-bank-reconciliation-amitpo23
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: israeli-bank-reconciliation
Source: https://github.com/amitpo23/cfo/tree/main/.claude/skills/israeli-bank-reconciliation
Command: npx skills add https://github.com/amitpo23/cfo --skill israeli-bank-reconciliation-amitpo23

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires israeli-bank-scrapers, csv-parse, csv-stringify, dayjs, ofx-js.

What problem does it solve? Matching bank statement entries to invoices and receipts by hand is slow and error-prone, especially with Israeli-specific formats like DD/MM/YYYY dates, Hebrew merchant names, and lump-sum credit card settlements. This Skill automates fetching, matching, discrepancy detection, and reconciliation reporting for Israeli business accounts. ## Core Features & Use Cases - Automated transaction fetching: Pull transactions from Leumi, Hapoalim, Discount, Mizrahi Tefahot, and card companies (Isracard, Cal, Max) via the israeli-bank-scrapers library or MCP servers. - Multi-strategy matching engine: Exact reference matching, fuzzy date/amount matching, and regex-based recurring pattern rules, with results split into matched, unmatched-bank, and unmatched-accounting buckets. - Reconciliation bridge and reports: Builds the canonical book-to-bank bridge (outstanding checks, deposits in transit, unposted fees and interest) and outputs CSV, JSON, or console summaries, including foreign-currency handling at the Bank of Israel representative rate. - Use Case: Before filing an annual tax return, reconcile a full year of Discount Bank transactions against the invoice register to surface 34 expenses totaling 18,200 ILS that lack matching invoices, grouped by vendor for the accountant. ## Quick Start Ask the agent to reconcile your Bank Hapoalim business account for a given month against your accounting CSV export and produce a reconciliation report with matched, unmatched, and suspicious entries.

Frequently Asked Questions about israeli-bank-reconciliation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I reconcile Israeli bank statements against accounting records?

Fetch transactions with the israeli-bank-scrapers library, load invoices and receipts from CSV, then run matching rules in priority order: exact reference match, fuzzy date-plus-amount match, and recurring pattern match. Results are split into matched, unmatched-bank, and unmatched-accounting buckets with a reconciliation report.

Which Israeli banks does israeli-bank-scrapers support?

Supported identifiers include hapoalim, leumi, discount, mizrahi, otsar-hahayal, mercantile, max, visa-cal, and isracard. Credentials are passed via environment variables, and each bank has different export formats and date conventions.

How do I handle bank fees and standing orders with no invoice?

Bank-originated entries like fees, standing orders, interest, and returned-check charges are not missing invoices. Post them directly to the books with a journal entry as the appropriate expense or income instead of searching for a document that never existed.

Why does CSV parsing fail on Israeli accounting exports?

Israeli accounting software often exports CSV in Windows-1255 Hebrew encoding or with BOM markers that break UTF-8 parsers. Convert with iconv -f WINDOWS-1255 -t UTF-8, and check for semicolon delimiters common in Israeli Excel exports.

How are foreign-currency transactions reconciled?

Value book entries at the Bank of Israel representative rate for the relevant date. The gap between that rate and the bank's actual conversion rate is a real exchange-rate difference posted as gain or loss, and the matching tolerance should be widened to about 5 ILS.

When should this reconciliation approach not be used?

It is not designed for international bank accounts, cryptocurrency wallets, or investment portfolio reconciliation. It targets Israeli shekel-denominated business accounts and Israeli card companies only.