How Do You Connect Square to QuickBooks Online?

Connecting Square to QuickBooks stops you re-typing every sale, but it also opens the door to the one mistake that quietly understates revenue. Square deposits your money after taking its fee.

So if you record only what hits your bank, your books show less income than you earned and miss a deductible expense. The integration is easy; recording it correctly is the part that matters.

This guide covers your integration options, how to connect Square, why the deposit isn't your revenue, how the data should post, and how to reconcile payouts against your bank.

Why connect Square to QuickBooks?

If you take payments through Square and keep your books in QuickBooks, syncing the two saves hours. Instead of manually entering sales, the integration pulls your Square activity into QuickBooks automatically.

Done right, it brings across not just sales totals but the detail that makes your books accurate: gross sales, processing fees, refunds, tips, and taxes, each recorded properly. That detail is what lets your profit and loss show true revenue and true cost rather than a single net number.

The alternative, typing it all in by hand or dumping in net deposits, is slow and error-prone. The integration exists to fix both, provided it's set up to capture the pieces correctly.

Your integration options

There are two broad paths, and the right one depends on how much detail and control you need.

The native option is the Square Connector by QuickBooks, developed and supported by Intuit. It automatically imports Square sales, refunds, fees, tips, discounts, and taxes, supports multiple locations, and can pull historical transactions.

Setup is covered in Intuit's official documentation. For most small businesses, it's enough.

The other path is a third-party sync app from the QuickBooks App Store. These add features like more detailed payout reconciliation, per-transaction inventory and cost tracking, multi-channel support, and finer mapping rules, usually for a fee. If you sell across Square plus other platforms or need tighter reconciliation, a dedicated app can be worth it.

How to connect Square to QuickBooks Online

Using the native connector, the setup takes a few minutes. Here's the flow.

1. Open your integrations. Sign in to QuickBooks Online, go to Apps or My integrations, and select Find integrations.
2. Find the connector. Search for Square Connector by QuickBooks and select Get app now.
3. Authorise Square. Enter your Square login and select Agree and Connect to let Square send transactions to QuickBooks.
4. Set your deposit account. Choose the bank account where Square deposits your payouts, so the connector can match them.
5. Pick your locations. Select all the Square locations you want tracked in QuickBooks.
6. Choose a start date and sync. Set when to begin importing, optionally pull historical transactions, then run the sync.

From there, transactions import automatically on a schedule. You don't create separate sales entries in QuickBooks; the connector brings them in for you.

The fee problem: why the deposit isn't your revenue

Here's the trap the whole article turns on. Square takes its processing fee before depositing your money. Sell $100 and Square might deposit $97.10, keeping $2.90.

If you record that $97.10 bank deposit as your income, two things go wrong. Your revenue is understated by the fee, and you've missed a legitimate, deductible business expense, the processing cost. Do this all year and your P&L is wrong on both the top and the expense lines.

The correct treatment records the full $100 as sales, the $2.90 as a Square fee expense, and the $97.10 as the net that reaches your bank. Your revenue is accurate, and your fees are captured.

Everything still ties to the deposit. This is the same issue businesses hit with Stripe fee separation, and it's handled the same way.

How Square data should post

A good setup breaks each payout into its parts rather than booking one net figure. Sales, fees, refunds, tips, and taxes each post as their own entry, so your books reflect what really happened.

Many integrations use a clearing account to do this cleanly. Square activity posts to the clearing account in detail, then the net payout transfers out to match your bank deposit. When the deposit lands in your bank feed, you match it, and everything reconciles. Cash sales and pending orders post separately as they settle.

The goal is simple: your profit and loss should show gross sales and processing fees as distinct lines, never a single net number. That's what makes the payment data reconcile and your reporting trustworthy.

Reconciling Square payouts to your bank

Even with a sync in place, reconciliation is what confirms it's right. Square typically batches a day's transactions into one payout, so one bank deposit represents many individual sales minus fees.

Your job at reconciliation is to match each Square payout in QuickBooks to the corresponding bank deposit and to confirm the sales, fees, and refunds behind it add up. When they do, your books and your bank agree. When they don't, a fee wasn't separated, a refund was missed, or a payout didn't sync.

Reconcile monthly at least, following the same bank reconciliation process you'd use for any account. With payment processors, the reconciliation is where understated revenue and missing fees get caught before they reach your tax return.

Common Square and QuickBooks mistakes

The biggest mistake is recording net deposits as income, which understates revenue and hides fees. It's easy to do if you skip the integration and just categorise bank-feed deposits.

Others include double-counting, recording both the synced sale and the manual bank deposit, forgetting that only one Square connection is allowed per QuickBooks company file, and not reconciling payouts so sync errors go unnoticed. Mixing up gross and net is the thread through most of them.

Each of these distorts either your revenue or your expenses, and both feed your taxes. Getting the setup right once prevents a year of small errors compounding.

Keeping it clean at scale

For a business doing a handful of Square sales a day, the native connector plus monthly reconciliation is plenty. The work grows with volume: more payouts, more fees to separate, and more matching at month-end.

That's where automation on the accounting side earns its place. Finlens keeps categorisation and reconciliation current on top of QuickBooks, so Square payouts are matched and fees separated as they flow in.

Combined with the right sync tool, your Square revenue is always recorded at gross, your fees are captured, and month-end is a quick check. The broader stack is covered in our roundup of QuickBooks automation tools.

Conclusion

Connecting Square to QuickBooks Online is quick with the native Square Connector, and it saves the tedious work of entering sales by hand. The setup isn't where businesses go wrong; the accounting treatment is.

Never record a Square deposit as your revenue. The deposit is net of fees, so book the full gross sale, record the processing fee as an expense, and let the net match your bank. A good integration does this automatically by posting sales, fees, refunds, and tips as separate entries through a clearing account.

Then reconcile payouts to your bank each month. Get the treatment and the reconciliation right, and Square becomes a clean, hands-off source of accurate revenue in your books rather than a quiet drain on the numbers you report.

Frequently asked questions

How do I connect Square to QuickBooks Online?

In QuickBooks Online, go to Apps or My integrations, search for Square Connector by QuickBooks, and select Get app now. Log in to Square and authorise the connection, set the bank account where Square deposits your payouts, choose your locations, pick a start date, and sync. Transactions then import automatically.

Why is my Square revenue lower in QuickBooks than my actual sales?

Because Square deposits your money after taking its processing fee, and you're likely recording only the net deposit as income. To fix it, record the full gross sale as revenue and the Square fee as a separate expense, so the net still matches your bank but your revenue is accurate.

How should Square fees be recorded in QuickBooks?

Square fees should be recorded as a separate expense, not netted against sales. For each payout, book the gross sales as income, the Square processing fee as a fee expense, and the net amount as what reaches your bank. This keeps both your revenue and your costs accurate.

What is the difference between the Square Connector and third-party apps?

The Square Connector by QuickBooks is Intuit's native, free integration that imports sales, fees, refunds, and taxes automatically. Third-party sync apps from the App Store add features like detailed payout reconciliation, inventory and cost tracking, and multi-channel support, usually for a fee. Most small businesses are fine with the native connector.

How do I reconcile Square payouts in QuickBooks?

Square batches transactions into payouts, so one bank deposit represents many sales minus fees. At reconciliation, match each Square payout in QuickBooks to the corresponding bank deposit, and confirm the sales, fees, and refunds behind it add up. Do this monthly to catch any sync errors or missing fees.

Can I import historical Square transactions into QuickBooks?

Yes. The native Square Connector lets you import historical transactions on setup, typically up to 18 months, and some third-party apps offer longer ranges. Be careful not to import dates you already have transactions for, which would create duplicates.

Can I connect more than one Square account to QuickBooks?

The native Square Connector supports one Square account per QuickBooks company file, though it does support multiple Square locations under that account. If you need to connect multiple separate Square accounts, a third-party sync app is usually required.

Do Square sales sync automatically to QuickBooks?

Yes. Once connected, the Square Connector imports transactions automatically on a schedule, usually within a few hours, so you don't create sales entries by hand. There's no manual sync button on the native connector; updates are scheduled, and you match the resulting payouts in your bank feed.