Square Payments and QuickBooks Online: How the Sync Works
Connecting Square to QuickBooks Online saves manual entry, but fees, deposit timing, and duplicate invoices cause trouble. Here is what to check before and after setup.
Square takes the payment; QuickBooks Online keeps the books. Connecting the two saves hours of retyping, but it also creates fresh ways to double-count income. Here is a plain guide to the connection, its common failure points, and how to start it cleanly.
What does the Square app sync into QuickBooks Online?
Square offers a connector app for QuickBooks Online. After you authorize it, sales recorded in Square can be imported into the books automatically. Depending on its configuration, the import can arrive as a daily summary rather than one entry for every receipt.
Payments, refunds, and tips can ride along inside that summary. The detail you get depends on the settings chosen during setup, so review them instead of accepting the defaults.
Who records the invoice: Square or QuickBooks Online?
Square can email invoices to customers and collect payment into your Square account. QuickBooks Online can send invoices too, through its own payment service. Pick one system as the home for invoicing and let the other follow.
When the same job is invoiced in both places, two receivables exist, and both can end up marked paid. Untangling that after the fact is slow, tedious work.
Why doesn’t the bank deposit match the daily sales entry?
Processing fees come out before the money moves. The sales figure in the books is therefore larger than the deposit that lands in the bank.
That difference is not missing money; it is a fee expense. Posting it to a dedicated fees account keeps both the income and the cost of taking payment visible. Check the app’s settings, which typically let you choose where fees are posted.
How should the Square deposit be recorded in the bank feed?
A Square payout can cover more than one day of sales, or split a single day across deposits. Matching by amount alone will fail.
The payout should be matched against the clearing side of the sales entries, never coded to income again. Coding it to sales income when the sync already recorded the sale is the most common double-count we see in cleanup work. Where no matching entry exists, pause and investigate before forcing the match.
Do refunds and tips sync cleanly?
Refunds recorded in Square reduce takings, and the sync should carry that adjustment across. If a refund is issued outside Square, or keyed in by hand, the books and the sales reports start to drift.
Tips deserve their own account if you want them separate from service income. A short monthly comparison between Square’s report totals and the income accounts catches drift early.
Start with a clean cutoff
Close out any manually recorded Square sales in the books before you connect, and pick a firm start date for the sync. Review the settings for account mapping, fee posting, and summary detail on day one. Then watch the first week of imported entries closely.
Correcting a misconfigured sync after a month of entries is far more work than a few days of attention at the start.