Bank Statement Reconciler

    1

    Convert raw bank CSVs into a deduplicated, transfer-matched ledger with automated categorization and reporting.

    $9

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Bank Statement Reconciler

    Example session with this skill installed

    I've downloaded my Monzo and Starling CSVs for July. Can you add them to the ledger, match any transfers between them, and give me a summary of my spending?

    • Read your context and instructions
    • Compiled the bank statement reconciler
    • Generated the data export

    Processed 142 rows. 12 duplicates skipped. 4 internal transfers matched (Transfer Group ID: TG-882). Added 126 new entries to ledger.csv.

    July Summary

    • Income: £4,200.00
    • Spending: £2,850.50
    • Net: +£1,349.50
    • Transfer Volume: £1,200.00 (Excluded)

    Top Categories: Rent (£1,200), Groceries (£450).

    ledger.csv

    CSV · data export

    Generated

    Example file from a real run - the skill writes it into your workspace.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    The problem

    Manual bookkeeping often leads to double-counting transfers as income, duplicate entries from overlapping CSV exports, and inconsistent categorization that ruins financial reports.

    What it does

    • Ingests raw CSV exports from Monzo, Starling, Revolut, Wise, and other banks with automatic format detection.
    • Prevents double-counting by matching internal transfers (±3 days) and assigning unique transfer IDs.
    • Enforces strict deduplication using a uniqueness key of account, date, amount, and normalized description.
    • Generates monthly close reports with net totals, category deltas, and anomaly detection for large transactions.
    • Maintains a persistent rules.csv to automate categorization based on your historical decisions.

    Why this beats prompting it yourself

    General LLM prompts often hallucinate balances or fail to handle the complex logic of multi-leg transfers across different accounts. This skill implements a rigorous append-and-correct ledger system that ensures data integrity and produces figures an accountant can actually use.

    Use cases

    • Consolidating multiple bank exports into a single source of truth ledger.
    • Preparing clean income and spending reports for tax returns or accounting.
    • Auditing personal or business spending to find subscription leaks and anomalies.
    • Splitting business and personal expenses within a single shared bank account.

    Known limitations

    Requires transaction data to be provided in CSV format. Date ambiguity in files (e.g., 01/02/2024) may require a one-time user confirmation if the file lacks clear day-month indicators.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.

    Requires CSV input. Date format ambiguity (DD/MM vs MM/DD) in small files may require user confirmation. Does not provide formal tax advice.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 3 months ago

    Permissions

    No special permissions declared or detected

    Listed3 months ago

    What's inside

    Frequently Asked Questions

    This skill is designed for any agent capable of processing CSV files and maintaining a local file state, such as ChatGPT with Advanced Data Analysis or local AutoGPT setups. It relies on Python-based logic to ensure mathematical accuracy that standard LLM prompting cannot guarantee.

    The Reconciler uses a 'uniqueness key' strategy that compares the account ID, transaction date, amount, and a normalized version of the description. This ensures that even if you upload overlapping CSV exports from the same bank, your ledger won't have duplicate entries.

    Yes, the skill automatically identifies and links transfers between your own accounts by matching offsetting amounts within a ±3-day window. It assigns these a unique Transfer ID, preventing them from being incorrectly logged as new income or expenses.

    When you purchase this skill, you receive the core logic engine, a template for the persistent `rules.csv` file for automated categorization, and a configuration guide for various bank CSV formats. You will also have access to future updates that add support for new banking formats.

    The skill uses a local `rules.csv` file to remember how you categorized past transactions. Each time you run a reconciliation, it checks this file first to apply your preferred labels to recurring merchants, significantly reducing manual effort over time.

    New in Finance & Accounting