What Makes Square Reconciliation Different?

Square is different from Stripe and PayPal in a fundamental way: it is a point-of-sale system, not just a payment gateway. Square handles in-person card payments, contactless payments, cash, checks, gift card purchases, gift card redemptions, tips, discounts, comps, and refunds — sometimes all in a single business day at a single location.

This creates several accounting challenges that gateway-only tools never face:

• Cash sales do not flow through Square's electronic deposit. They are physically handled by the business but appear in Square reports — meaning Square reports and bank deposits will never match without accounting for cash separately.

• Tips collected through Square terminals belong either to the business (service fee) or to individual employees (requiring payroll treatment) — and this affects which QBO account they go to.

• Gift cards create a liability when purchased and only become income when redeemed — a two-step accounting entry that most Square integrations handle incorrectly.

• Square deposits are labeled "SQ *[Business Name]" or "Square Inc" in bank statements — not a problem once you know it, but a mystery to first-time bookkeepers who can't identify the deposit source.

• Split payments (e.g., customer pays half by card and half by cash) are commonly mishandled by the Square-QBO connector, which sometimes assigns the entire amount to the electronic deposit.

Understanding Square Transaction Types and PayTraQer Sync Logic

Square's daily sales reports contain these transaction categories, all of which PayTraQer maps to QBO:

Square Transaction Types

How PayTraQer Syncs Square to QBO

PayTraQer connects to Square via API and downloads all Square transactions. It follows the clearing account model:

1. Each Square sale (cards, cash, invoice) and fee is posted into your Square Clearing account in QBO.

2. When Square processes a payout (typically next-business-day for card payments), PayTraQer creates a Bank Transfer from Square Clearing → Checking Account.

3. The Bank Transfer matches the "SQ *[Business Name]" deposit in your bank feed.

4. Cash sales that were deposited separately into your bank (not via Square's payout) require a separate Bank Deposit in QBO — they do not flow through the Square electronic payout.

Sync Mode for Square

Consolidated (Summary) Sync: Creates one daily Sales Receipt summarizing all Square sales for the day. Best for retail stores, restaurants, and any business with more than 20 transactions per day. This is what most bookkeeping professionals recommend.

Itemized (Individual) Sync: Creates one QBO Sales Receipt per Square transaction. Best for service businesses using Square for invoicing or appointment-based businesses where per-client records in QBO are valuable.

Step 1 — Prerequisites and QBO Setup

Create the Square Clearing Account

1. QBO → Accounting → Chart of Accounts → New

2. Account Type: Bank

3. Detail Type: Checking

4. Name: Square Clearing (or Square Bank Account)

5. Save and Close.

Create Additional Accounts for Square-Specific Items

These need to exist in QBO before you configure PayTraQer:

• Gift Card Liability (Other Current Liability)

• Tips Payable (Other Current Liability — if distributing tips to employees)

• Square Processing Fees (Expense)

• Square Chargebacks (Expense)

Download Your Square Source of Truth

From Square Dashboard → Reports → Sales Summary:

• Sales Summary Report: Shows total card sales, cash sales, tips, discounts, gift card activity, and fees for any period.

• Deposit Report: Shows each Square payout amount and date — this is what you match to your bank deposits.

• Payout Details: Available under Payments → Payouts — shows the exact components of each ACH transfer.

The Deposit Report ending balance per payout period is what you use when reconciling Square Clearing in QBO.

Create a QBO Bank Rule for Square Deposits

In QBO Banking → Rules → New Rule:

• Condition: Bank Text contains "SQ" or "Square"

• Action: Transfer from Square Clearing

This rule auto-categorizes all Square bank deposits as Transfers from the clearing account, reducing manual matching work every month.

Step 2 — Product Mapping and Income Classification in PayTraQer

Auto-Create vs. Common Item for Square

Use a Common Item (Recommended for retail/restaurant Square users):

Turn OFF Auto-Create in PayTraQer Products & Services Settings. Enable Common Product/Service and name it Square Sales. Map it to Square Sales Income in QBO. This prevents PayTraQer from creating hundreds of individual QBO items for every menu item, product SKU, or service in your Square catalog.

Use Auto-Create if: You run a low-volume appointment-based business (salon, consultant, therapist) using Square for appointments and need each service type to appear on QBO reports by name (e.g., "Haircut," "Color Treatment," "Blow-dry").

Mapping Special Square Transaction Types

In PayTraQer's Products & Services Settings, you must explicitly map these beyond the default "Common Item":

Step 3 — Configuring PayTraQer Settings for Square

In PayTraQer → Settings → Square.

Sales Settings

• Bank Account to Deposit: Square Clearing

• Payment Method: Square

• Customer: Common Customer (Square Customer) for Consolidated mode

Tax Settings

• Map Square's collected sales tax to Sales Tax Payable in QBO

• For tax-exempt sales (nonprofit or wholesale): create a separate product mapping with Exempt tax code

Fees Settings

• Processing Fees:

  • Vendor: Square

  • Expense Account: Square Processing Fees

  • Bank Account: Square Clearing ← Critical: must match Sales Settings

• Dispute Fees: Map separately to Square Chargebacks expense account

Payout Settings

• Enable "Process the Payout": Toggle ON

• Transfer Account: Business Checking Account

Cash Sales Note: Cash collected at the register goes into your physical cash drawer, not into the Square electronic payout. Cash sales appear in the Square Sales Summary report but NOT in the Square Deposit Report. You must record cash sales as a separate Bank Deposit from Square Clearing → Cash Drawer or Petty Cash account in QBO, completely independently of PayTraQer's payout sync.

Step 4 — The QBO Bank Feed Matching Process

When Square sends a payout to your bank account (typically the next business day after card transactions):

1. Go to QBO Banking → For Review (Checking Account).

2. Find the deposit labeled "SQ *[Your Business Name]" or "Square Inc."

3. If you created the bank rule in Step 1, QBO will automatically categorize it as a Transfer from Square Clearing.

4. Click Match — QBO will find the PayTraQer Bank Transfer for the same amount.
   Never click "Add." Adding the Square deposit records it as standalone income in your checking account, duplicating all the revenue already posted by PayTraQer into Square Clearing.

Handling Cash Sales in the Bank Feed

Cash sales deposited to your bank (e.g., from a physical cash drop at the bank) appear as a raw bank deposit with no Square label. These need to be manually matched or categorized:

1. In QBO Banking → For Review, find the cash deposit.

2. Click Categorize → Account: Square Cash Sales Income (or Cash Sales).

3. Alternatively, if you post cash sales to Square Clearing via PayTraQer, create a Bank Deposit from Square Clearing → Checking Account for the cash amount, then match it to the bank feed deposit.

Split Payment Issue

Square allows customers to pay part by card and part by cash in a single transaction. The QBO native Square connector has a known bug where it assigns the full transaction amount to the card deposit rather than splitting it. PayTraQer handles this correctly, but always verify after the first sync by checking that the sum of card deposits + cash deposits from Square matches the Square Sales Summary totals exactly.

Step 5 — Reconciling the Accounts in QBO

Reconcile the Square Clearing Account

1. QBO → Accounting → Reconcile → Square Clearing

2. Ending Balance: From Square Dashboard → Payouts → the outstanding balance left in Square at month end (usually $0 if all funds were paid out, or the next-day payout amount if a payout is in transit)

3. Ending Date: Last day of the month

4. Click Start Reconciling

5. Check off all Sales Receipts, Fee Expenses, Refunds, Gift Card Liability transfers, and Bank Transfers to Checking

6. Difference should be $0.00

7. Click Finish Now and save the PDF

Common Square reconciliation discrepancy cause: Square deducts fees before the payout — the payout in your bank is already net of fees. But if PayTraQer also records fee entries in Square Clearing, you may see the fees deducted twice. Verify that PayTraQer's payout sync correctly accounts for fees so they are not double-deducted.

Reconcile the Checking Account

Cash deposits from Square cash sales must be cleared here alongside the electronic Square transfers. If you created separate Bank Deposits for cash, they will appear in the checking reconciliation as distinct entries.

Troubleshooting: Manual Deposits vs. PayTraQer Single Transfers

A common scenario for Square businesses: the owner or bookkeeper manually deposits cash from the register to the bank, then also records a Square payout from the Square Dashboard. Both entries appear in QBO's bank feed but come from different sources and must be handled separately — not combined into one match.

The Problem:
Bookkeeper manually creates QBO Bank Deposits for both cash and card Square sales together, bundling them. PayTraQer then creates a separate Bank Transfer for the card-only Square electronic payout. The card deposit in the bank feed doesn't match the bundled manual deposit (because it includes cash), and it doesn't match the PayTraQer Transfer either (wrong amount).

The Fix:

1. Delete the bundled manual Bank Deposit in QBO.

2. Create a separate Bank Deposit for the cash portion only: Square Clearing → Checking Account for the cash amount.

3. Let PayTraQer handle the card payout portion — it creates its own Bank Transfer for the card-only payout amount.

4. Match the card deposit in the bank feed to PayTraQer's Transfer.

5. Match the cash deposit in the bank feed to the manually created cash Bank Deposit.

Common Square-Specific Scenarios and Fixes

Final Month-End Checklist for Square + QBO Reconciliation

• Square Sales Summary and Deposit/Payout Report downloaded for the month

• Gift Card sales mapped to Gift Card Liability — not to Sales Income

• Tips mapped to Tips Payable (if employee tips) — not to Sales Income

• Cash sales recorded as separate Bank Deposit entries in QBO

• PayTraQer Fees Settings confirmed — fees pointing to Square Clearing

• QBO Bank Rule for "SQ" deposits confirmed and active

• Each Square electronic payout Matched (not Added) in QBO Banking For Review

• Each cash deposit separately matched in QBO Banking For Review

• Square Clearing reconciled against Square Payout Report ending balance — Difference $0.00

• P&L reviewed: Square Sales correct, Processing Fees as expense, Gift Card Liability on Balance Sheet not P&L

• Tips Payable balance on Balance Sheet — cleared to $0 through payroll

• Reconciliation PDF saved to client folder.