More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Bank Reconciliation: Statement vs Books

    1

    Reconcile a bank statement against the books in two commands and get the reconciliation statement, with Latin American and European formats built in.

    $15

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Bank Reconciliation: Statement vs Books

    Bank Reconciliation: Statement vs Books

    Example session with this skill installed

    Reconcile extracto_octubre.xlsx against libro_bancos_octubre.csv. The bank and the books don't agree this month.

    • Read your context and instructions
    • Compiled the bank reconciliation

    October reconciles except for one item to confirm. (Demo data is fictitious.)

    CheckResult
    Bank movements67 (opening and closing balance rows skipped)
    Book movements68
    Matched one to one60
    Matched as a group1 deposit of 2,500,000.50 = 3 cash receipts
    Only in the bank4, total -60,694.15
    Only in the books3, total -389,500.00
    To review2

    Reconciliation

    Amount
    Balance per bank83,050,022.74
    + Deposits in transit2,340,500.00
    - Outstanding checks-2,730,000.00
    Adjusted bank82,660,522.74
    Balance per books82,730,216.89
    + Interest not recorded4,118.22
    - Fees and 4x1000 not recorded-64,812.37
    Adjusted books82,669,522.74
    Difference-9,000.00

    The 9,000 is the international transfer: the books show 1,200,000.00 and the bank received 1,191,000.00, so the bank kept a fee. Confirm it and record the fee, and the difference goes to 0.

    To record in the books: management fee 19,900.00, 4x1000 tax 38,412.37, transfer fee 6,500.00 and interest 4,118.22. Just timing: checks 004512 (1,980,000.00) and 004513 (750,000.00), and the deposit of 2,340,500.00 on Oct 31.

    Saved as extracto_octubre_reconciliation.xlsx.

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

    About this skill

    Month end, and the bank balance doesn't match the books. Somewhere in two exports are the fees nobody recorded, the 4x1000 tax, the checks that haven't been cashed and the deposit that's still in transit.

    This skill gives your agent two Python scripts that line up the bank statement with the books and build the reconciliation for you. It reads Excel or CSV straight from the bank and from the accounting system, including Latin American and European formats (1.234,56, dd/mm/yyyy, Debe/Haber, Débitos/Créditos).

    It matches by amount and date, with a few days of tolerance, and uses the check or document number when there is one. It also catches one deposit that covers several receipts. What's left goes into two lists: what's only in the bank (fees, taxes and interest you still need to record) and what's only in the books (checks not cashed, deposits in transit). Lines that look related but don't match exactly, like a transfer that arrived net of a fee, go to a review list with the reason. Nothing is forced.

    You get a workbook with the reconciliation statement, the difference (green when it's 0) and every line in its place, with the row it came from.

    If a client reconciles every month, the agent can leave them a small folder with a .bat they double-click.

    It runs on your machine. No network calls, no API keys. Tested on 5,000 movements per side, which takes under a second.

    What it doesn't do: one bank account per run. Two identical amounts on the same day can pair the other way round; the totals stay right.

    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.

    One bank account per run and one table per sheet. Old .xls files need to be saved as .xlsx first. Two identical amounts on the same day can pair the other way round; the totals stay right.

    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 6 days ago

    Software
    Pythonopenpyxl for Excel files (pip install openpyxl)

    Permissions

    Terminal / Shell
    Write Files
    Read Files
    Listed6 days ago

    What's inside

    Frequently Asked Questions

    Yes. That's what it was built for: 1.234,56 amounts, dd/mm/yyyy dates, Debe/Haber in the books and Débitos/Créditos in the statement. US formats work too.

    It finds them. One line on one side that equals 2 or 3 lines on the other, within the date tolerance, is matched as a group.

    Two Python scripts (one matches, one builds the workbook), the instructions for your agent, and a .bat for clients who reconcile every month.

    Python 3.9+ and, for Excel files, openpyxl. It runs on your machine. No API keys, no network calls.

    No. It reads the statement and the books and writes a new workbook next to them.

    They go to a review list with the reason, like a transfer that arrived net of a fee or a check cashed a week late. Nothing is matched by force.

    New in Finance & Accounting