- Home
- Skills
- Finance & Accounting
- Square Payout Reconciler: Card Sales vs Bank Deposits
Works with the AI Agents you already use
Square Payout Reconciler: Card Sales vs Bank Deposits
Matches every Square deposit to your bank statement and explains each one that doesn't tie out.
$9
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
| Deposit | Date | Expected | In bank | Status |
|---|---|---|---|---|
| DEP-B1 | Sep 29 | $270.55 | $270.55 | OK |
| DEP-B2 | Sep 30 | $220.35 | $220.35 | OK |
| DEP-B3 | Oct 1 | $165.81 | - | not in this bank file |
| DEP-B4 | Oct 2 | $291.15 | $291.15 | OK |
| DEP-B5 | Oct 5 | $448.19 | $448.19 | OK (Fri + Sat sales) |
Needs attention
| # | Item | Likely reason | What to check |
|---|---|---|---|
| 1 | DEP-B3, $165.81, Oct 1 | The bank file covers that date and nothing close to the amount arrived, so it may have gone to a different linked account | Square Balance -> Transfers -> DEP-B3: which bank account it went to, and its status |
| 2 | Pending payment, Oct 3, net $53.42 (T8018720157) | Not complete yet, so no deposit | Whether it completed or was cancelled. If it completed, it'll be in a later deposit |
| 3 | Card 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 one | Look it up in Square Transactions. If it failed, collect again from the client |
| 4 | "ONLINE TRANSFER FROM SAV 4471", $500.00, Oct 6 | Not Square. The description says it came from a savings account | Not 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.
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
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
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
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