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
- In QuickBooks Online, open My integrations, then Find integrations, and install “Square Connector by QuickBooks”.
- Sign in to Square and authorise the connection.
- Choose the bank account where Square pays your deposits and the Square locations you want to track.
- Pick a start date. Intuit says you can import up to two years of history.
- 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.