Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Square Payout Reconciler: Card Sales vs Bank Deposits

    1

    Matches every Square deposit to your bank statement and explains each one that doesn't tie out.

    $9

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Square Payout Reconciler: Card Sales vs Bank Deposits

    Square Payout Reconciler: Card Sales vs Bank Deposits

    Example session with this skill installed

    [FICTIONAL business and data, written for this test]
    User: "Monthly check for my barbershop, week of Sep 28. Square export + bank CSV from my credit union (ex2-barbershop-square.csv, ex2-barbershop-bank.csv). Bookkeeper wants to know everything ties out."

    --- ex2-barbershop-square.csv ---
    Date,Time,Time Zone,Gross Sales,Discounts,Net Sales,Tax,Tip,Partial Refunds,Total Collected,Source,Card,Cash,Fees,Net Total,Transaction ID,Payment ID,Card Brand,Event Type,Transaction Status,Deposit ID,Deposit Date,Customer Name
    2026-09-28,10:30:00,Central Time (US & Canada),20.00,0.00,20.00,0.00,10.00,0.00,30.00,Square Point of Sale,30.00,0.00,-0.93,29.07,T1815623033,P1799609893,Visa,Payment,Complete,DEP-B1,2026-09-29,
    2026-09-28,10:30:00,Central Time (US & Canada),45.00,0.00,45.00,0.00,7.00,0.00,52.00,Square Point of Sale,52.00,0.00,-1.50,50.50,T1609005468,P3724953954,Visa,Payment,Complete,DEP-B1,2026-09-29,
    2026-09-28,10:30:00,Central Time (US & Canada),20.00,0.00,20.00,0.00,10.00,0.00,30.00,Square Point of Sale,30.00,0.00,-0.93,29.07,T9438570424,P3269380278,Visa,Payment,Complete,DEP-B1,2026-09-29,
    2026-09-28,10:30:00,Central Time (US & Canada),30.00,0.00,30.00,0.00,0.00,0.00,30.00,Square Point of Sale,30.00,0.00,-0.93,29.07,T7287550638,P4618196973,Visa,Payment,Complete,DEP-B1,2026-09-29,
    2026-09-28,10:30:00,Central Time (US & Canada),20.00,0.00,20.00,0.00,5.00,0.00,25.00,Square Point of Sale,25.00,0.00,-0.80,24.20,T8044999245,P3146509353,Visa,Payment,Complete,DEP-B1,2026-09-29,
    2026-09-28,10:30:00,Central Time (US & Canada),30.00,0.00,30.00,0.00,10.00,0.00,40.00,Square Point of Sale,40.00,0.00,-1.19,38.81,T8107318928,P9947290794,Visa,Payment,Complete,DEP-B1,2026-09-29,
    2026-09-28,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,7.00,0.00,42.00,Square Point of Sale,42.00,0.00,-1.24,40.76,T4255542466,P7497790074,Visa,Payment,Complete,DEP-B1,2026-09-29,
    2026-09-28,10:30:00,Central Time (US & Canada),30.00,0.00,30.00,0.00,0.00,0.00,30.00,Square Point of Sale,30.00,0.00,-0.93,29.07,T5758509870,P6544385715,Visa,Payment,Complete,DEP-B1,2026-09-29,
    2026-09-28,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,0.00,0.00,35.00,Square Point of Sale,0.00,35.00,0.00,35.00,T3941612270,P1916982751,,Payment,Complete,,,
    2026-09-29,10:30:00,Central Time (US & Canada),45.00,0.00,45.00,0.00,10.00,0.00,55.00,Square Point of Sale,55.00,0.00,-1.58,53.42,T7001892043,P9903631892,Visa,Payment,Complete,DEP-B2,2026-09-30,
    2026-09-29,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,7.00,0.00,42.00,Square Point of Sale,42.00,0.00,-1.24,40.76,T2446943725,P6631602494,Visa,Payment,Complete,DEP-B2,2026-09-30,
    2026-09-29,10:30:00,Central Time (US & Canada),30.00,0.00,30.00,0.00,10.00,0.00,40.00,Square Point of Sale,40.00,0.00,-1.19,38.81,T1506770417,P1433990593,Visa,Payment,Complete,DEP-B2,2026-09-30,
    2026-09-29,10:30:00,Central Time (US & Canada),30.00,0.00,30.00,0.00,10.00,0.00,40.00,Square Point of Sale,40.00,0.00,-1.19,38.81,T8718148638,P3402154336,Visa,Payment,Complete,DEP-B2,2026-09-30,
    2026-09-29,10:30:00,Central Time (US & Canada),45.00,0.00,45.00,0.00,5.00,0.00,50.00,Square Point of Sale,50.00,0.00,-1.45,48.55,T4305071838,P2648201399,Visa,Payment,Complete,DEP-B2,2026-09-30,
    2026-09-29,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,0.00,0.00,35.00,Square Point of Sale,0.00,35.00,0.00,35.00,T6990849600,P5252242025,,Payment,Complete,,,
    2026-09-30,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,7.00,0.00,42.00,Square Point of Sale,42.00,0.00,-1.24,40.76,T1084313279,P6099446279,Visa,Payment,Complete,DEP-B3,2026-10-01,
    2026-09-30,10:30:00,Central Time (US & Canada),20.00,0.00,20.00,0.00,0.00,0.00,20.00,Square Point of Sale,20.00,0.00,-0.67,19.33,T1628605420,P7191374370,Visa,Payment,Complete,DEP-B3,2026-10-01,
    2026-09-30,10:30:00,Central Time (US & Canada),30.00,0.00,30.00,0.00,7.00,0.00,37.00,Square Point of Sale,37.00,0.00,-1.11,35.89,T8861033459,P2658587350,Visa,Payment,Complete,DEP-B3,2026-10-01,
    2026-09-30,10:30:00,Central Time (US & Canada),30.00,0.00,30.00,0.00,0.00,0.00,30.00,Square Point of Sale,30.00,0.00,-0.93,29.07,T3734122106,P9656545549,Visa,Payment,Complete,DEP-B3,2026-10-01,
    2026-09-30,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,7.00,0.00,42.00,Square Point of Sale,42.00,0.00,-1.24,40.76,T7967077895,P7817278176,Visa,Payment,Complete,DEP-B3,2026-10-01,
    2026-09-30,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,0.00,0.00,35.00,Square Point of Sale,0.00,35.00,0.00,35.00,T2658274117,P3693996244,,Payment,Complete,,,
    2026-10-01,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,5.00,0.00,40.00,Square Point of Sale,40.00,0.00,-1.19,38.81,T4115530475,P3379116370,Visa,Payment,Complete,DEP-B4,2026-10-02,
    2026-10-01,10:30:00,Central Time (US & Canada),45.00,0.00,45.00,0.00,10.00,0.00,55.00,Square Point of Sale,55.00,0.00,-1.58,53.42,T3592159721,P2810144999,Visa,Payment,Complete,DEP-B4,2026-10-02,
    2026-10-01,10:30:00,Central Time (US & Canada),30.00,0.00,30.00,0.00,0.00,0.00,30.00,Square Point of Sale,30.00,0.00,-0.93,29.07,T9756134681,P9429652896,Visa,Payment,Complete,DEP-B4,2026-10-02,
    2026-10-01,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,10.00,0.00,45.00,Square Point of Sale,45.00,0.00,-1.32,43.68,T6398693998,P7856770577,Visa,Payment,Complete,DEP-B4,2026-10-02,
    2026-10-01,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,5.00,0.00,40.00,Square Point of Sale,40.00,0.00,-1.19,38.81,T5196948493,P1542884616,Visa,Payment,Complete,DEP-B4,2026-10-02,
    2026-10-01,10:30:00,Central Time (US & Canada),45.00,0.00,45.00,0.00,0.00,0.00,45.00,Square Point of Sale,45.00,0.00,-1.32,43.68,T2203533128,P1071188213,Visa,Payment,Complete,DEP-B4,2026-10-02,
    2026-10-01,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,10.00,0.00,45.00,Square Point of Sale,45.00,0.00,-1.32,43.68,T2914290650,P1259654723,Visa,Payment,Complete,DEP-B4,2026-10-02,
    2026-10-01,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,0.00,0.00,35.00,Square Point of Sale,0.00,35.00,0.00,35.00,T6051971519,P1565125450,,Payment,Complete,,,
    2026-10-02,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,10.00,0.00,45.00,Square Point of Sale,45.00,0.00,-1.32,43.68,T9506154484,P5371822290,Visa,Payment,Complete,DEP-B5,2026-10-05,
    2026-10-02,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,7.00,0.00,42.00,Square Point of Sale,42.00,0.00,-1.24,40.76,T5135070017,P9681242054,Visa,Payment,Complete,DEP-B5,2026-10-05,
    2026-10-02,10:30:00,Central Time (US & Canada),30.00,0.00,30.00,0.00,10.00,0.00,40.00,Square Point of Sale,40.00,0.00,-1.19,38.81,T9878859492,P6630972959,Visa,Payment,Complete,DEP-B5,2026-10-05,
    2026-10-02,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,0.00,0.00,35.00,Square Point of Sale,35.00,0.00,-1.06,33.94,T5618219000,P7640429005,Visa,Payment,Complete,DEP-B5,2026-10-05,
    2026-10-02,10:30:00,Central Time (US & Canada),30.00,0.00,30.00,0.00,5.00,0.00,35.00,Square Point of Sale,35.00,0.00,-1.06,33.94,T9224873447,P2511115941,Visa,Payment,Complete,DEP-B5,2026-10-05,
    2026-10-02,10:30:00,Central Time (US & Canada),45.00,0.00,45.00,0.00,0.00,0.00,45.00,Square Point of Sale,45.00,0.00,-1.32,43.68,T4395309096,P9003554196,Visa,Payment,Complete,DEP-B5,2026-10-05,
    2026-10-02,10:30:00,Central Time (US & Canada),20.00,0.00,20.00,0.00,0.00,0.00,20.00,Square Point of Sale,20.00,0.00,-0.67,19.33,T6937077295,P3502586802,Visa,Payment,Complete,DEP-B5,2026-10-05,
    2026-10-02,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,0.00,0.00,35.00,Square Point of Sale,0.00,35.00,0.00,35.00,T3615063448,P1344465116,,Payment,Complete,,,
    2026-10-03,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,10.00,0.00,45.00,Square Point of Sale,45.00,0.00,-1.32,43.68,T8422592892,P7790140909,Visa,Payment,Complete,DEP-B5,2026-10-05,
    2026-10-03,10:30:00,Central Time (US & Canada),45.00,0.00,45.00,0.00,10.00,0.00,55.00,Square Point of Sale,55.00,0.00,-1.58,53.42,T9949776499,P5422913636,Visa,Payment,Complete,DEP-B5,2026-10-05,
    2026-10-03,10:30:00,Central Time (US & Canada),20.00,0.00,20.00,0.00,0.00,0.00,20.00,Square Point of Sale,20.00,0.00,-0.67,19.33,T3065693802,P3999324637,Visa,Payment,Complete,DEP-B5,2026-10-05,
    2026-10-03,10:30:00,Central Time (US & Canada),45.00,0.00,45.00,0.00,10.00,0.00,55.00,Square Point of Sale,55.00,0.00,-1.58,53.42,T5343531383,P2292925355,Visa,Payment,Complete,DEP-B5,2026-10-05,
    2026-10-03,10:30:00,Central Time (US & Canada),20.00,0.00,20.00,0.00,5.00,0.00,25.00,Square Point of Sale,25.00,0.00,-0.80,24.20,T3226487959,P9290581534,Visa,Payment,Complete,DEP-B5,2026-10-05,
    2026-10-03,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,0.00,0.00,35.00,Square Point of Sale,0.00,35.00,0.00,35.00,T6332131908,P2076315812,,Payment,Complete,,,
    2026-10-03,10:30:00,Central Time (US & Canada),45.00,0.00,45.00,0.00,10.00,0.00,55.00,Square Point of Sale,55.00,0.00,-1.58,53.42,T8018720157,P6214903295,Visa,Payment,Pending,,,
    2026-10-01,10:30:00,Central Time (US & Canada),35.00,0.00,35.00,0.00,5.00,0.00,40.00,Square Point of Sale,40.00,0.00,-1.19,38.81,T9249787798,P1901481624,Visa,Payment,Complete,,,

    --- ex2-barbershop-bank.csv ---
    Posting Date,Details,Credit,Debit
    09/29/2026,SQUARE INC 260929 L2X,270.55,
    09/30/2026,SQUARE INC 260930 L2X,220.35,
    10/01/2026,PEARL BARBER SUPPLY,,212.80
    10/02/2026,SQUARE INC 261002 L2X,291.15,
    10/05/2026,SQUARE INC 261005 L2X,448.19,
    10/06/2026,ONLINE TRANSFER FROM SAV 4471,500.00,

    • Read your context and instructions
    • Compiled the square payout reconciler

    Square <-> Bank Reconciliation - Barbershop, Sep 28 - Oct 3, 2026

    Result: 4 of 5 Square deposits match the bank to the cent. The Oct 1 deposit ($165.81) isn't in this account at all. There are also two card payments with no deposit yet (one pending, one with no deposit ID), worth $92.23 together.

    Square summary

    Amount
    Gross sales$1,510.00
    Tips$234.00
    Total collected$1,744.00
    Fees-$45.72 (2.62% of total collected)
    Net total$1,698.28
    Cash (not deposited by Square)$210.00

    Expected in the bank from Square: $1,698.28 net - $210.00 cash - $53.42 pending - $38.81 with no deposit ID =

    $1,396.05. The bank shows $1,230.24, a difference of $165.81, which is exactly DEP-B3.

    Deposit match

    DepositDateExpectedIn bankStatus
    DEP-B1Sep 29$270.55$270.55OK
    DEP-B2Sep 30$220.35$220.35OK
    DEP-B3Oct 1$165.81-not in this bank file
    DEP-B4Oct 2$291.15$291.15OK
    DEP-B5Oct 5$448.19$448.19OK (Fri + Sat sales)

    Needs attention

    #ItemLikely reasonWhat to check
    1DEP-B3, $165.81, Oct 1The bank file covers that date and nothing close to the amount arrived, so it may have gone to a different linked accountSquare Balance -> Transfers -> DEP-B3: which bank account it went to, and its status
    2Pending payment, Oct 3, net $53.42 (T8018720157)Not complete yet, so no depositWhether it completed or was cancelled. If it completed, it'll be in a later deposit
    3Card payment with no deposit ID, Oct 1, net $38.81 (T9249787798)Card payment with no deposit attached. Could be an offline-mode payment that hasn't processed, or a declined oneLook it up in Square Transactions. If it failed, collect again from the client
    4"ONLINE TRANSFER FROM SAV 4471", $500.00, Oct 6Not Square. The description says it came from a savings accountNot part of this reconciliation; mention it to your bookkeeper

    Totals for your bookkeeper

    • Gross sales $1,510.00; tips $234.00; sales tax collected $0.00.
    • Card processing fees: $45.72.
    • No refunds this period.
    • Cash taken in person: $210.00 (not part of any Square deposit).
    • Amounts only. How and when to record them is your bookkeeper's call.

    Not checked

    • Whether DEP-B3 reached another account (needs Square's Transfers page or that account's statement)
    • Cash deposits and the till count
    • Tip payouts to barbers

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

    About this skill

    For small businesses on Square and their bookkeepers. Give it the Square Transactions CSV and a bank statement CSV for the same period. It groups card sales by Square Deposit ID, matches each deposit to a bank credit by amount and date, and explains the rest in plain words.

    What it handles:

    • Fees as negative numbers (Net Total = Total Collected + Fees), cash sales that are never deposited, and Payout/Transfer rows that aren't revenue
    • Refunds that shrink a deposit (or turn it into a debit), pending payments, card payments with no deposit ID yet, and deposits that fall after the bank file ends or went to another account
    • Square-looking bank lines that match no deposit (for example a possible instant transfer) are listed for you to confirm in Square
    • Bank CSVs with one signed Amount column or separate Credit/Debit Amount columns; ISO, MM/DD or DD/MM dates, with or without a time; amounts with a decimal point (e.g. 223.10)

    A bundled Python script (standard library only, no network, writes nothing) does the matching. The skill writes the report: a one-line result, a deposit-by-deposit match table, a "needs attention" table with the likely reason and where to check in Square, and the totals for your bookkeeper (sales, tips, fees, refunds, cash). Amounts only: it gives no tax or accounting-policy advice.

    Not affiliated with Block, Inc. or Square.

    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 Square Transactions CSV (not Items/Summary exports). Instant transfers may need manual verification. No support for tax or accounting-policy 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 23 days ago

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Listed23 days ago

    What's inside

    Frequently Asked Questions

    This skill automates the tedious task of matching hundreds of individual Square transactions to the final lump-sum deposits in your bank account, flagging discrepancies like missing transfers or unexpected fee deductions.

    You will receive the specialized Python reconciliation script, a step-by-step user guide, and a template for mapping your specific bank's CSV format to ensure accurate processing.

    The script is optimized for the standard Square 'Transactions' CSV export; please note that it does not currently support 'Items' or 'Sales Summary' report formats.

    It handles complex scenarios like negative fee values and multi-day deposit windows that generic AI prompts often miscalculate, ensuring your net totals are accurate to the penny.

    This skill is designed for use with AI agents capable of running Python code locally or in a sandboxed environment, providing secure data processing without sending your financial details to an external server.

    New in Finance & Accounting