How to connect QuickBooks Online and Square
You connect Square to QuickBooks Online by installing a connector app and authorizing it to read your Square account. The app then posts sales, refunds, and processing fees into your books on its own, usually within a day. Pick one method and stay with it, because a connector and manual entry running together produce duplicates that take real effort to clean up.
How does the connection work?
A connector sits between the two services. It reads activity from your Square account and writes it into QuickBooks Online as ordinary transactions: sales receipts, refunds or credit memos, and fee entries. Some apps post every sale individually; others post one daily summary, so check that setting before your first sync.
Square deducts its fee before depositing your money. The connector records the fee separately, so the deposit in your bank account should match recorded sales minus fees, which keeps reconciliation simple.
Connecting your Square account
Start in the Apps area inside QuickBooks Online and search for Square. The results may include a connector published by Square itself and others from independent developers. Intuit has changed its own Square offering over the years, so check who publishes each app and what it syncs before installing. Some connectors are free and some carry a subscription, and the listing states the current terms.
- In QuickBooks Online, open Apps from the left menu.
- Search for Square and read the listings, noting the developer behind each one.
- Select the connector that fits and choose Get app now.
- Sign in to your Square account when prompted and authorize the connection.
- Note the start date the app assigns, since most connectors do not reach back before it.
Choosing where transactions post
Open the app’s settings to map accounts. You can accept the defaults or point deposits, fees, and taxes at specific accounts in your chart of accounts. If you track products, decide there whether Square items link to QuickBooks items.
Refunds follow the same settings. Depending on the app, they post as refunds against the original sale or as credit memos.
Avoiding duplicate transactions
The most common mistake is running two methods at once. With a connector active, stop entering Square sales by hand and stop importing the same activity from a spreadsheet. Two connectors running together cause the same problem, so pause or disconnect the old one before installing a new one.
If you recorded sales manually before connecting, choose a clean cutoff date and start the sync after it. Then review the first two deposits line by line to confirm nothing posted twice.
Missing or late transactions
Start with the app’s dashboard or History tab, where most connectors show the last run and any errors. From there, check three things:
- The sync status and the timestamp of the last successful run.
- The start date, because activity before it is generally not imported.
- The posting accounts in settings, in case entries landed somewhere unexpected.
For faults inside the connector itself, contact the developer through the app’s listing; the developer supports how the sync behaves. Apps bought through the QuickBooks app store are billed through Intuit.
One thing a connector will not do is rebuild years of prior history. Importing older Square sales as a one-time conversion is a separate job from a live sync, and it is work we handle.