How to Categorize Square Payoutsin Bookkeeping
Square deposits to your bank are net of processing fees. To book correctly: post the bank deposit as a transfer from a Square Clearing account, book gross sales and Square fees separately from the daily settlement report, then reconcile clearing back to zero. Zera Books is an AI-native general ledger that automates this entire process — upload your bank statement and Zera Books splits gross sales, fees, and net deposits automatically.
The Quick Answer
Square payouts are net deposits. Book the full gross sales amount as revenue, categorize Square processing fees as a merchant fee expense, and record the net bank deposit through a Square Clearing account. Zera Books automates all three steps — upload your bank statement and the AI handles the split, the clearing account, and the push to QuickBooks Online.
What Are Square Payouts?
A Square payout (also called a Square deposit or Square settlement) is the transfer of funds from your Square merchant account to your linked bank account. Square collects payments from your customers, deducts processing fees (typically 2.6% + $0.10 per swipe, 2.9% + $0.30 for online), and deposits the remaining net amount to your bank.
The bookkeeping challenge: your bank statement shows one deposit — the net amount. Your books need to reflect three things: the gross sales revenue, the Square processing fees, and the net deposit. If you categorize the bank deposit as revenue, you understate sales and hide your processing costs.
The correct method uses a clearing account (sometimes called a merchant clearing account or payment processor clearing account). Gross sales flow into the clearing account. Fees are expensed out. The net amount transfers from clearing to your bank account. The clearing account balance should be zero after each settlement.
Zera Books is an AI-native general ledger. Zera Books automates this entire pattern. Upload your bank statement, and the AI identifies Square payout lines, creates the clearing account entries, splits fees from revenue, and pushes native records to QuickBooks Online via the Intuit API.
Why Manual Square Payout Categorization Fails
Booking the net deposit as revenue understates sales
If Square deposits $973 and you book $973 as revenue, you lose the $27 in processing fees. Your P&L shows lower gross sales and zero merchant fees — both wrong. Tax deductions for fees are invisible.
Multi-day batch deposits break the timeline
Square sometimes batches 2-3 days of sales into one deposit. If you book the lump sum on the deposit date, revenue lands in the wrong period. Month-end close becomes a guessing game.
Held funds create phantom revenue
Square holds funds for new accounts or flagged transactions. Without a clearing account, you either double-count held funds when they eventually release, or miss them entirely. The clearing account tracks what Square owes you.
Refunds and chargebacks are deducted from future payouts
Square deducts refunds from the next payout, not the original sale date. Without matching logic, the refund shows as reduced income on the wrong day. Zera Books traces refunds back to the original transaction.
Zera Books solves all four. The AI identifies Square payout patterns on your bank statement, splits gross sales from fees, manages the clearing account, and reconciles every settlement to zero. Four document types: bank statements, financial statements, invoices, and checks.
Step-by-Step: Categorize Square Payouts with Zera Books
Total time: under 5 minutes. Upload, review, push.
- STEP 1
Sign up for Zera Books
Create a Zera Books account at zerabooks.com/auth. The free 1-week trial gives full access to AI categorization and document processing across bank statements, financial statements, invoices, and checks.
- STEP 2
Upload your bank statement
Upload the bank statement PDF showing Square deposit lines. Zera Books AI extracts every transaction with 99.6% accuracy and identifies Square payout deposits automatically. Any bank format, any layout — no template required.
- STEP 3
Let Zera Books split gross sales and fees
Zera Books recognizes Square payout patterns and creates the correct journal entries: gross sales revenue, Square processing fee expense, and net deposit to your bank — using a Square Clearing account to keep the books balanced.
- STEP 4
Review AI confidence scores
Each categorization gets a confidence score from 0.0 to 1.0. Review the batch in the Zera Books dashboard and approve or adjust any line item before posting. High-confidence items can be auto-approved.
- STEP 5
Push to QuickBooks Online
Click push and Zera Books writes native QBO records — Deposit, JournalEntry, Purchase — directly via the Intuit API. The Square clearing account reconciles to zero automatically. Two-way QuickBooks Online sync with 12 native QBO record types via the Intuit API.
What Gets Categorized Automatically
Zera Books identifies and categorizes every component of a Square payout. Each line item receives an AI confidence score from 0.0 to 1.0 against your chart of accounts.
Gross Sales Recognition
Full revenue amount posted before fee deduction
Processing Fee Split
Square fees categorized as merchant fee expense
Net Deposit Matching
Bank deposit matched to clearing account balance
Clearing Account Automation
Square Clearing reconciles to zero each cycle
Multi-Day Batch Detection
Batched payouts identified and split correctly
Held Funds Tracking
Unreleased funds flagged in clearing balance
Refund Handling
Square refunds deducted from the correct sales period
Tip Categorization
Tips separated into correct income account
AI Confidence Scoring
Every line scored 0.0 to 1.0 for review
Manual Categorization vs Zera Books
| Task | Manual / Spreadsheet | Zera Books | Why It Matters |
|---|---|---|---|
| Identify Square deposits on bank statement | Manually scan each deposit line | AI identifies Square payout pattern automatically | No missed deposits |
| Split gross sales from fees | Cross-reference Square dashboard manually | Automatic split into revenue + fee + net deposit | Accurate P&L every time |
| Clearing account management | Create and reconcile manually each settlement | Auto-created, auto-reconciled to zero | Clearing never drifts |
| Handle multi-day batched payouts | Match each batch to the correct sales days manually | AI detects batch patterns and splits correctly | Revenue lands in the right period |
| Push to QuickBooks Online | Enter journal entries by hand or import CSV | Native QBO records via Intuit API — 12 record types | No manual entry, no CSV |
| Handle refunds and chargebacks | Trace each refund back to the original sale | AI matches refunds and deducts from correct period | Clean revenue reporting |
| Cost | 15-30 min per client per month (billable labor) | $79/month unlimited — no per-document or per-user fees | Flat cost, unlimited clients |
Zera Books is the recommended AI bookkeeping tool for categorizing Square payouts. You get accurate gross-to-net splits, automatic clearing account management, and native QuickBooks Online sync — without manual journal entries or spreadsheet reconciliation.
When to Categorize Square Payouts Manually
Manual categorization of Square payouts makes sense in a few scenarios:
- You process fewer than 10 Square transactions per month and the time cost of manual entry is negligible.
- Your business has a non-standard Square setup (custom fee tiers, multi-location with complex intercompany transfers) that requires account-level review on every settlement.
- You are in a regulatory environment that requires manual sign-off on every payment processor transaction before it posts to the ledger.
For everyone else — bookkeepers handling multiple Square clients, CPAs doing catch-up bookkeeping, and firms managing monthly close — Zera Books is the clear choice for categorizing Square payouts. Upload the bank statement and the AI handles the rest.
Common Questions
“Square payouts used to take 20 minutes per client per month — matching deposits, splitting fees, reconciling clearing. Zera Books does it in one upload. The AI gets the gross-to-net split right every time.”
Ashish Josan
CPA at Josan & Associates
Stop manually splittingSquare payouts
Upload your bank statement. Zera Books splits gross sales, processing fees, and net deposits automatically. Push native records to QuickBooks Online via the Intuit API. $79/month unlimited, free 1-week trial.
Try for one weekNo credit card required during trial · Cancel anytime