What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/Square Integration with QuickBooks
QuickBooks + Square

Square Integration with QuickBooks: Set Up the Connector, Then Fix What It Lumps Together

Intuit makes the connector: Square Connector by QuickBooks, for QuickBooks Online. It brings in each sale with its fees and tax, and books each Square payout as one bank deposit. Here's the setup, the settings that decide how clean your books look, and the fixes for what usually goes wrong after.

How to connect Square to QuickBooks

In QuickBooks Online, open your integrations, search for Square Connector by QuickBooks, and select Get app now. Sign in to Square and select Agree and Connect.

My integrations Find integrations Square Connector by QuickBooks Get app now

Then three settings: the bank account Square pays into (the Deposit account), which Square locations to bring in, and the start date. History goes back up to two years. Select Sync Now.

The settings that decide how your books look

The defaults work, but a few choices made at setup are hard to undo once months of sales have come in.

  1. 1

    Pick the real deposit account

    Choose the bank account where Square payouts actually land. Each payout is booked as a deposit into it, which is what lets the bank feed match it.

    Watch for: the Square fees account. Fees post to a Square fees expense account you pick here. Point it at the merchant fees account your accountant already uses.

  2. 2

    Choose your locations and start date

    Tick every Square location you want in QuickBooks. Start the sync the day after your last hand-entered Square sales, so nothing comes in twice.

    Watch for: history. You can go back up to two years, but if those months are already booked by hand, importing them doubles your revenue.

  3. 3

    Leave customer and product tracking on

    With tracking on, the connector matches Square items, customers and vendors to your QuickBooks lists by name. Turn it off and every sale uses one default customer and product.

  4. 4

    Decide on Auto-add

    With Auto-add transactions on, QuickBooks posts the transactions it's confident about without waiting for you. Leave it off for the first few weeks, check what arrives, then turn it on.

  5. 5

    Review what came in

    Go to Integration transactions

    New sales usually appear in For Review within a couple of hours. There's no button to pull them sooner. Confirm sales before the payouts they belong to.

Connected, but the books still look wrong

Everything posts to "Square Sales"

How you'll know: Your products in QuickBooks get no sales, and one item called Square Sales gets all of them.

Fix: Items match by exact name. Rename the QuickBooks product or the Square item so they agree, letter for letter. Anything that doesn't match falls to the default item.

The deposit is bigger or smaller than the sales

How you'll know: A payout in the bank feed doesn't equal that day's sales in Square.

Fix: The payout is net of fees, refunds, holds and disputes. Open the deposit and check the Add funds to this deposit section, where the connector puts those items. If a sale is missing from it, confirm that sale first, then the payout.

Sales appear twice

How you'll know: The same Square sale shows from the connector and again from the bank feed, or from an older Square app.

Fix: Only one Square integration can be connected at once, so disconnect any older one. Then match payouts in Banking to the connector's deposits instead of adding them as new income. Our guide to undeposited funds covers the matching side.

Fees are nowhere to be seen

How you'll know: Merchant fees don't show on the P&L for the days you've synced.

Fix: Fees sit inside the deposit until you add or match the sale it came with. Clear the review queue and they appear in the Square fees account.

Where the connector stops: one business, several stores

You choose which Square locations sync, but Intuit's help doesn't describe posting each one to its own QuickBooks location or class. So a business with three storefronts on one Square account usually sees one combined revenue line, and the profit and loss can't tell you which store carries the others. Product categories can't be used on sales either, so the split by category isn't there.

QuickBooks Online Plus and Advanced already have class and location tracking. The missing piece is tagging each Square sale with its store before it reaches QuickBooks. n-frames builds that layer: it keeps the connector's payout matching, reads the location on each Square transaction, and posts revenue and cost of goods sold to the right store and category.

Three stores, one revenue line

Retailer · three locations on one Square account

Before

The Square Connector handled payouts cleanly. Every deposit matched the bank feed without anyone touching it.

All three stores landed in QuickBooks as one revenue line. At month end someone built a spreadsheet from Square's location reports by hand to see which store was doing the work.

After

A sync now reads the location tag on each Square transaction and posts its revenue to that store's class, on top of the payout matching that already worked.

The month-end spreadsheet went away. The owners pull a profit and loss by store straight from QuickBooks the same day.

Questions people ask

Does Square integrate with QuickBooks?

Yes. Square Connector by QuickBooks is Intuit's own app. It brings Square sales, fees, taxes, discounts and customers into QuickBooks Online, and books each Square payout as a deposit so it matches your bank feed.

How do I connect Square to QuickBooks?

In QuickBooks Online go to My integrations, then Find integrations, search for Square Connector by QuickBooks and select Get app now. Sign in to Square, select Agree and Connect, then choose your deposit account, locations and start date, and select Sync Now.

Does the Square Connector break out sales by location?

You pick which locations sync, but Intuit doesn't describe the connector posting each location to its own QuickBooks location or class. Businesses that need a P&L per store usually add a layer that tags each sale with its store before it posts. That's the piece n-frames builds.

Can I sync Square with QuickBooks Desktop?

Not with Square Connector by QuickBooks, which is for QuickBooks Online. Desktop users use a third-party connector instead. Square's help lists Connex for QuickBooks Desktop, and Intuit points Desktop users to Commerce Sync. Square notes its Desktop integration doesn't support its multiple-location feature. Square with QuickBooks Desktop covers that setup.

Why do my Square sales show up as "Square Sales" in QuickBooks?

Because the item name in Square doesn't exactly match a product in QuickBooks, or product tracking is turned off. Make the names match and leave product tracking on in the connector's settings.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.