How to Connect Square to QuickBooks

Connect Square to QuickBooks only after you define locations, items, revenue categories, taxes, tips, service charges, discounts, gift cards, refunds, fees, payouts, and the bank account receiving transfers. The integration should preserve gross activity and reconcile to net deposits without duplicating sales.

Current Intuit documentation describes the Square Connector by QuickBooks for supported QuickBooks Online products, with transaction review and mappings. Current Square reports provide the independent source needed to prove the imported accounting.

Choose the posting level

Method	Useful when	Control risk
Transaction or line-item detail	Customer, item, tax, and transaction detail is needed in QuickBooks and volume is manageable.	High volume can crowd the ledger and amplify duplicates or mapping errors.
Daily summary	Square remains the sales-detail source and accounting needs controlled daily financial components.	Summary design must preserve all liabilities, fees, tenders, and locations.
Payout summary	Settlement reconciliation is central and timing is well controlled.	A payout can combine days or adjustments and may not support tax or daily close needs.

Do not change methods mid-period without a cutoff and duplicate review. Confirm current connector options and limits in the exact US product.

Prepare Square master data

Clean locations, items, categories, modifiers, discounts, taxes, service charges, payment methods, employees, and gift-card settings. Square notes that changing certain names can create separate report entries, so use a controlled naming policy.

Identify every sales source using Square, including point of sale, invoices, online store, payment links, subscriptions, and manual entries. Confirm which are included in the connector and reports.

Prepare QuickBooks

Reconcile the QuickBooks bank account that receives Square transfers. Create or confirm accounts for relevant revenue, refunds or contra-revenue under the company’s policy, Square fees, sales-tax liabilities, tips or payroll liabilities, gift-card liabilities, customer deposits, and Square clearing.

Map products and services only at a level the business will maintain. If detailed inventory is managed elsewhere, determine whether importing Square items into QuickBooks would duplicate quantity or cost records.

Set a controlled start date

Choose a date after the prior bookkeeping is complete and reconciled. Export Square sales, payment, fee, tax, gift-card, dispute, and transfer reports through the day before connection. Preserve QuickBooks financial statements and transaction detail at the same cutoff.

Current QuickBooks guidance describes selecting an import start date and allows historical imports within stated current limits. Never select a broad historical range merely because it is available. First identify which Square sales and payouts already exist in QuickBooks.

Configure locations and deposit accounts

Connect the authorized Square account and select the intended locations. Map each location to the proper accounting dimensions and the actual deposit account where supported. Intuit’s current documentation notes limitations around multiple Square integrations, so confirm structure before connecting several accounts or entities.

Use separate QuickBooks company files for separate legal entities unless a qualified design supports another structure. Do not combine Square accounts owned by different taxpayers into one ledger merely for convenience.

Illustrative daily close

Assume an illustrative Square day includes $8,000 of item sales, $640 of sales tax, $900 of tips, $300 of gift-card sales, $250 of refunds, $120 of discounts, and $260 of Square processing fees. Card, cash, and gift-card tenders differ, and the card transfer arrives later.

The Square QuickBooks integration should preserve revenue, refunds or discounts under the reviewed policy, sales-tax liability, tip liability or payout treatment, gift-card liability, fees, cash, and Square clearing. The net card deposit is not sales.

The reviewer compares the Square sales summary and payment methods with the accounting entry. Then the Square reconciliation or transfer report explains the clearing movement that matches the bank.

Review before confirming transactions

Current QuickBooks guidance describes a For Review or integration-transactions workflow with category suggestions and imported details such as gross and net amounts, fees, taxes, discounts, service charges, products, and customer or vendor information.

Treat suggestions as drafts. Review account mappings, tax, location, date, customer, item, and duplicate risk. During the pilot, disable any auto-add behavior that prevents sufficient review. Increase automation only after repeated clean reconciliations.

Sales tax, tips, and service charges

Map Square tax categories to the current business registrations and QuickBooks workflow. Determine which system calculates tax and which filings remain outside both. Reconcile tax collected, adjustments, returns, payments, and ledger liabilities.

Separate voluntary tips from mandatory service charges and determine payroll and reporting treatment with qualified advisors. Do not map either to ordinary sales merely because Square includes it in a collected total.

Gift cards and customer deposits

Gift-card sale and redemption are different events. Prevent the initial sale and later product sale from both becoming new cash revenue. Reconcile outstanding gift-card balances and review promotions, expirations, refunds, and multi-location use.

Square reports now distinguish several deferred-sales concepts. Confirm the accounting treatment for invoices, deposits, and other amounts not yet earned under the company’s policy.

Refunds, disputes, and chargebacks

Test full and partial refunds, refunds after payout, canceled transactions, disputes, fees, and recovered disputes. Connect each event to the original sale and later Square transfer or bank movement.

Do not post a chargeback withdrawal as a generic expense without reviewing revenue, receivable, fee, and recovery implications. Maintain an exception list for items the connector does not support fully.

Cash and noncard tenders

Square can report cash and other payment methods that never enter a Square bank transfer. Reconcile expected cash to drawer counts, paid-outs, deposits, and over or short amounts. Prevent a later cash bank deposit from creating revenue again.

Daily and month-end reconciliation

1. Compare Square sales, tenders, taxes, tips, gift cards, refunds, discounts, and fees with imported accounting.
2. Reconcile Square clearing to transfer and reconciliation reports.
3. Match transfers and cash deposits to the QuickBooks bank feed.
4. Review failed, excluded, duplicate, pending, or manually changed imports.
5. Reconcile sales-tax, tip, gift-card, deposit, fee, and dispute balances.
6. Compare location and item totals between Square and QuickBooks.

Common failures

• Adding imported Square sales and treating payouts as sales again.
• Choosing a historical start date that overlaps completed bookkeeping.
• Posting net transfers without gross taxes, fees, tips, and gift cards.
• Ignoring cash because it is absent from card payouts.
• Turning on detailed imports that overwhelm QuickBooks at high volume.
• Trusting a zero bank difference while tax or liability mappings are wrong.

Decision rule

Sync Square with QuickBooks Online only when one full operating day and its later transfer reconcile from Square reports through QuickBooks to the bank. The connector is ready when it preserves the financial components, prevents duplicates, and exposes every exception.

Continue with the Accounting Software and Tools hub, review restaurant accounting software, and compare retail accounting software.

Educational information only. Tax, payroll, and compliance rules change and may vary by jurisdiction. Confirm the current requirements for your facts with the appropriate agency or a qualified professional.

If Square sales, liabilities, payouts, and the bank do not reconcile, review Steady’s QuickBooks services.