Skip to content
CentriWeb
Not sure where to start?

Tell us how the business runs. We'll tell you what we'd build first.

Book a call
For builders and tradesPreBuildMore homeowner enquiries, more trust, more jobs won. For sole tradersOwner CFOA financial operating system for owners who do the books.
Need something of your own?

We build custom software too.

Talk to us

Square QuickBooks integration: syncing sales, fees and deposits

How to connect Square to QuickBooks Online, how sales, fees and deposits should land, and the mistakes that cause double counting.

The Square QuickBooks integration most businesses use is the Square Connector by QuickBooks, which you install from inside QuickBooks Online. It imports Square sales, fees and payouts, and records each payout as a bank deposit linked to the sales and fees behind it. Double counting is the usual mistake, and it comes from letting the bank feed and the connector both add the same money.

This article follows Intuit’s and Square’s own pages as read in November 2026. Check their pages for current details and prices.

What the Square QuickBooks integration brings in

Intuit’s help article says the connector imports sales with their gross amount, net amount, fees, taxes, discounts and line items. Each sale appears as a “Payment received” transaction. Payouts, the transfers from Square to your bank, usually come once per business day, and adding a payout records a bank deposit tied to the sales and fees in it.

Fees go to a Square Fees expense account. They sit inside the combined deposit, so you will not see them as separate lines until you add or match the related sale. Holds, disputes, adjustments and Square Capital payments appear in a funds section of the deposit (Intuit: connect and manage Square transactions).

How to set up the Square QuickBooks integration

  1. In QuickBooks Online, open My integrations, then Find integrations, and install “Square Connector by QuickBooks”.
  2. Sign in to Square and authorise the connection.
  3. Choose the bank account where Square pays your deposits and the Square locations you want to track.
  4. Pick a start date. Intuit says you can import up to two years of history.
  5. Wait for the first sync. Transactions usually appear within a few minutes.

Customers and vendors are matched to your lists when tracking is on. If it is off, the default Square customer or vendor is used. Items match by name, so a Square item called “Callout fee” lands on a QuickBooks product of the same name. Anything unmatched falls back to a “Square Sales” line with the Square item name in the description.

Reviewing and confirming what comes in

Items arrive on the Integration transactions page. Fully pre-filled ones can be added with one Confirm. Others need a Review step to supply missing details. You can confirm in bulk, but not if any item still needs review, and not when payments and payouts are selected together.

Plan a weekly ten minutes for this. Left alone, the queue grows and your books fall behind the bank. A tradesperson taking card payments on a Square reader after each job is a good example. If they take eight card payments a week, the queue is short. If a shop takes 200, they will want the daily summary approach covered later.

The mistakes that cause double counting

Double counting is what most people are searching for help with. Intuit’s article gives the key rules, and the rest follows from them.

  • Transaction already in QuickBooks. If it exists, match it rather than adding it again.
  • Bank feed running at the same time. Intuit says if you use bank feeds, add transactions through the Square app first, then match them in online banking. Doing it the other way round books the money twice.
  • Duplicate items. Matching your products and services prevents inventory being tracked in both apps.
  • Start date overlap. Importing history from before the date your bookkeeper started recording Square sales creates copies. Agree the date first.
  • Invoices. If you invoice in QuickBooks and the customer pays by Square, check how the payment lands before you turn the connector on, so the invoice is not paid twice in the books.

Limits to know before you commit

Intuit lists these on the same page.

  • Only one Square integration can be connected at a time.
  • You cannot refresh on demand. Completed Square transactions typically appear within about two hours.
  • Products that are categories in QuickBooks cannot be used as line items on sales.

Square’s own help page also lists a separate paid option, Commerce Sync, a third-party app on the Square App Marketplace. Square describes it as sending sales into QuickBooks and Xero every night, with a choice of a daily lump summary, custom categories or individual customers, plus deposit reconciliation. It describes pricing as flat rate with unlimited sales and gives no dollar figure on that page, so check the app’s page for what it costs. Square lists it for Canada, Spain, France, the United Kingdom, Ireland and the United States (Square: QuickBooks and Square).

A worked example from a trades business

Take an electrician who finishes a job and takes a $1,200 card payment on a Square reader. These numbers are made up to show the flow. Square keeps a fee, and the rest is paid to the bank the next business day along with the day’s other sales.

In QuickBooks the books should end up with three things. A sale for the full $1,200, a fee booked as an expense in the Square Fees account, and one bank deposit for what actually arrived, linked to the sale. If the connector has brought in the sale and the payout, and you add both, the deposit matches the bank feed line and reconciliation takes one click.

It goes wrong if the electrician also records the $1,200 by hand as an invoice payment. Now the sale exists twice, income is overstated, and the bank deposit has nothing left to match. The cure is a house rule: card payments taken in Square are recorded only through the connector. Everything else, cheques and bank transfers, is recorded the normal way.

A checklist to agree with your bookkeeper

  • The start date for imports, and who confirms nothing earlier is already in the books.
  • Which bank account receives Square deposits, and which Square locations count.
  • Which products and services in QuickBooks match Square items, and who renames the ones that do not.
  • Whether tracking customers is on, or whether everything goes to the default Square customer.
  • Who clears the review queue and how often, for example every Friday.
  • How refunds and disputes are handled, since they show up in the deposit as adjustments.

Write the answers on one page. When the person who set it up leaves, the next one starts from the page and not from guesses.

Which option suits which business

Option How it works Who maintains it Suits
Square Connector by QuickBooks Imports each sale and payout into a review queue Intuit Low to moderate volume, a bookkeeper who reviews weekly
Commerce Sync Nightly transfer with daily summary options The app’s developer High volume where a daily total is enough
Custom connection Rules written for your accounts and job system Whoever built it Payments that must be tied to jobs, deposits or other systems

When a custom connection fits better

Most businesses should start with the free connector. A custom connection starts to make sense when Square is one part of a larger flow: a job is booked in one system, a deposit is taken in Square, an invoice is raised in QuickBooks, and someone has to join the three by hand. CentriWeb builds these connections in n8n and looks after them under its run with less admin service. We build custom work, so weigh our view with that in mind.

It does not suit a business that takes a few card payments a week, or one whose bookkeeper is happy to match deposits by hand. For the same question with another processor, see Stripe and QuickBooks, and for job software that syncs invoices, Jobber and QuickBooks. The trades page shows how we work with owner-run service businesses.

Common questions.

Is the Square QuickBooks integration free?

Intuit offers the Square Connector by QuickBooks inside QuickBooks Online. Check Intuit's page for current terms, because pricing and plan rules can change. Square also lists Commerce Sync, a separate third-party app, and tells you to check that app's page for what it costs.

How do I stop Square transactions doubling up in QuickBooks?

Intuit says to match an existing transaction instead of adding it again. If you also use bank feeds, add transactions through the Square app first, then match them in online banking.

How do Square fees appear in QuickBooks?

Intuit says fees are recorded in a Square Fees expense account and appear inside the combined deposit. You see them as separate items only after you add or match the related sale.

How long until Square sales appear in QuickBooks?

Intuit says completed Square transactions typically appear within about two hours, and you cannot refresh on demand.

Related guides.

Talk to CentriWeb about this

CentriWeb sets up payments, business email, hosting and backups so they run quietly in the background. The first call takes 30 minutes and is free.

Or call +61 483 957 775 or email info@centriweb.com. CentriWeb is based in New Zealand and works online with businesses worldwide.

Ask a questionBook a call