1

    bankreconciliatie

    by Nex AI

    Automated bank reconciliation skill that matches CSV exports and identifies accounting exceptions.

    Updated Jun 2026
    Security scanned

    $19

    · or 95 credits

    30-day refund guarantee

    Secure checkout via Stripe

    Included in download

    • Identify timing differences between bank clearing and manual bookkeeping.
    • Detect potential double-bookings or missing invoices automatically.
    • terminal, file_read, file_write automation included
    • Instant install

    Sample input

    Match bank_export.csv and general_ledger.csv with a 3-day tolerance. Show me the exceptions.

    Sample output

    Reconciliation Summary:

    • Total Matched: 42 (38 exact, 4 within 3 days)
    • Unmatched Bank: 2 (€124.50, €15.00)
    • Unmatched Ledger: 1 (€124.55 - potential rounding error)

    Exceptions found:

    1. 2023-10-15 | €124.50 (Bank) vs €124.55 (Ledger) - Amount mismatch.
    2. 2023-10-18 | €15.00 (Bank) - No ledger entry.

    About This Skill

    What it does

    This skill automates the tedious process of bank reconciliation by programmatically matching bank statements against accounting records. It processes two CSV files and identifies matches based on amounts and dates, incorporating a configurable tolerance window for timing differences.

    Why use this skill

    Manual reconciliation is prone to human error and time-consuming. This developer-focused tool uses a Python-based logic engine to perform mechanical matching, allowing accountants to focus exclusively on exceptions. Unlike simple prompts, this skill handles various CSV formats (European and US decimal/date separators), detects column headers automatically, and provides a structured audit trail of matched versus unmatched items.

    Supported tools

    • Standard CSV exports from banking portals and accounting software
    • Python 3 backend for robust data processing
    • Flexible data parsing (supports dd/mm/yyyy and yyyy-mm-dd)

    The Output

    The agent generates a summary report including the number of exact matches, tolerance matches (date drift), and a detailed list of unmatched items with hypothetical reasons (e.g., timing difference, missing entry, or rounding error) to guide final human verification.

    Use Cases

    • Automate matching of hundreds of bank transactions against ledger entries.
    • Identify timing differences between bank clearing and manual bookkeeping.
    • Detect potential double-bookings or missing invoices automatically.
    • Generate a "to-investigate" list for month-end closing procedures.

    Reviews

    No reviews yet - be the first to share your experience.

    Only users who have downloaded or purchased this skill can leave a review.

    Security Scanned

    Passed automated security review

    Permissions

    Terminal / Shell
    Read Files
    Write Files

    File Scopes

    bankreconciliatie/**

    Terminal/Shell: the agent runs the bundled Python script (argparse CLI). Read/Write Files: the script reads user-supplied local input files (CSV/JSON) and writes the result to a user-specified path. No network access, no environment variables, no secrets.

    Compatible with SKILL.md-compatible agents including Claude Code and Aider.

    Creator

    Founder of Nex AI. I build production-grade Claude Skills from systems that actually run: multi-tenant SaaS, Telegram agents, Raspberry Pi infrastructure, 3D multiplayer rooms. Every skill ships battle-tested patterns, not theory. 33+ open source skills published, commercial catalog growing.

    Frequently Asked Questions

    More Premium Skills