How to Reconcile Square in QuickBooks Online (Step-by-Step)
Stop struggling with mismatched bank feed deposits. Learn how CPAs and professional bookkeepers use the **Clearing Account Method** to record gross revenue, capture deductible merchant fees, and match net payouts to the penny.
When a customer pays $100 via Square, Square deposits $97.30 into your checking account (deducting the 2.6% + $0.10 in-person fee). If you categorize that $97.30 bank deposit as "Sales Income", you make two critical errors:
- Your top-line Gross Revenue is understated by $2.70 on your P&L.
- Your $2.70 merchant processing fee is never recorded as a tax-deductible expense.
- If you also recorded a $100 invoice, the bank feed cannot find an exact match, creating phantom discrepancies.
The Standard CPA Method: Square Clearing Account
The cleanest, most audit-proof way to handle high-volume Square sales without bloating your books.
Create the "Square Clearing Account" in Chart of Accounts
In QuickBooks Online, navigate to Accounting > Chart of Accounts > New.
Record Total Gross Sales into the Clearing Account
Whether you pull daily summary reports from Square or enter monthly figures, create a Sales Receipt or Journal Entry that credits your Gross Sales and debits the Square Clearing Account:
Match Bank Feed Deposits as "Transfers"
When Square deposits the net payout (e.g. $9,720.00) into your actual checking account, do NOT categorize it as income. In your QuickBooks Bank Feed, choose Record Transfer and select Square Clearing Account as the source.
Record Total Square Processing Fees to Zero Out the Balance
At the end of your billing cycle or month, run Square's Fees Summary report. Create an Expense or Journal Entry to clear the remaining balance in the clearing account:
Method 2: Splitting Bank Feed Transactions (For Daily Invoices)
If you send individual Square invoices and only have a few transactions per week, you can split the transaction directly in the QuickBooks Bank Feed:
- Open the incoming Square bank feed line item and click Find Match or Split.
- Line 1: Select Sales Income and enter the full Gross invoice amount ($100.00).
- Line 2: Select Bank & Merchant Fees and enter the Square fee as a negative amount (-$3.20).
- The total matches your net bank deposit of $96.80 exactly with zero discrepancy.
Try the Free Square Fee & Surcharge Calculator
Calculate exact 2.6% + 10¢ in-person and 2.9% + 30¢ invoice fees, determine reverse surcharge billing amounts, and copy pre-formatted QuickBooks split deposit entries.
Frequently Asked Questions (Troubleshooting Square & QBO)
Why does my Square deposit not match my QuickBooks sales receipt?
Square deducts its processing fee (e.g., 2.6% + $0.10 for in-person or 2.9% + $0.30 for invoices) before transmitting funds to your bank. If you created a sales receipt for the gross customer charge of $100, your bank feed will show a deposit of only $97.30 or $96.80. Matching them directly fails because there is an unaccounted fee variance.
What type of account should a Square Clearing Account be in QuickBooks?
Set up the Square Clearing Account as a Bank type account (or Other Current Asset). Using a Bank account type allows you to record transfers directly from your bank feed and run monthly reconciliation reports to verify the balance reaches $0.00.
Should I use the official "Connect to Square" app in QuickBooks Online?
While convenient for small single-register stores, experienced bookkeepers frequently report that the automated app can duplicate transactions, misallocate sales tax, or create individual transaction clutter in your general ledger. If you have high volume, using a clearing account with summary journal entries keeps your chart of accounts fast and spotless.
How do I handle Square sales tax in QuickBooks Online?
When posting your daily or monthly gross sales summary to the Square Clearing Account, split the income line into Gross Sales (Income) and Sales Tax Payable (Current Liability). When paying state tax authorities, write the check against Sales Tax Payable.
What if my Square Clearing Account has a leftover balance at month-end?
A small ending balance is normal if Square executed transactions on the final 1-2 days of the month that were not deposited into your bank until the 1st or 2nd of the next month (in-transit payouts). Log into your Square Dashboard under Balance to verify that the pending payout matches your clearing account balance.