BUNDLE Security scanned2 skills

    Month-End Excel Kit: Clean + Reconcile

    Two skills that usually get used back to back at month end.

    First your agent cleans the export that came out of the ERP, the bank or the POS: title rows on top of the header, amounts stored as text, dates in three formats, a TOTAL row in the middle. Then it reconciles the bank statement against the books and gives you the reconciliation statement, with what matched, what needs a second look and what shows up on only one side.

    Both were built for Latin American and European files, where the decimal comma and dd/mm dates are the norm. They handle US formats too.

    Everything runs on your machine with Python and openpyxl. No network calls, no API keys.

    Includes Messy Excel Fixer and Bank Reconciliation: Statement vs Books. Each one still works on its own.

    Works with any agent that signs in to Agensi, such as Claude, ChatGPT, Claude Code, Cursor and Codex CLI.

    Juan Berrio
    Created by
    Juan Berrio
    $19$24
    Save 21% · $5

    One payment, lifetime access. 2 skills unlock instantly in your library.

    Money-back guarantee

    Instant unlock in your library

    Free updates from the creator

    What's included

    2 skills

    See it in action

    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.

    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 these skills and uses them on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every skill in this bundle goes through our trust checks.

    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.

    Frequently asked questions

    Yes — every skill in Month-End Excel Kit: Clean + Reconcile is also sold on its own product page. The bundle just packages them together at a discount (save 21% vs buying each one separately).

    Yes. When you own the bundle your connected agent can load the latest version of any included skill. Updates the creator publishes after your purchase are included at no extra cost.

    All skills in this bundle use the open SKILL.md standard and work with Claude Code, Cursor, Codex CLI, Gemini CLI, GitHub Copilot, Windsurf. The compatibility list on this page is computed from the included skills.

    The bundle price is set 21% below the combined retail price of the 2 paid skills included. You pay once and unlock every skill in your library instantly.

    Bundles are covered by the same money-back guarantee as individual skills. Doesn't do what its page promises? You get your money back.