QuickBooks Online · Integration
Square + QuickBooks Online: what the integration does & how to set it up well.
Square is a point-of-sale and payments platform; a connector app syncs your Square sales, tips, sales tax, processing fees, and daily batch deposits into QuickBooks Online so the books reflect what actually happened at the register. The part that quietly breaks books: Square pays out in daily batches net of fees that bundle sales, sales tax, tips, and refunds into one deposit — record that deposit as a single lump sum and you hide the sales tax you owe, the tips you’re holding, and the fees you paid. Below: what the integration does, how to connect it so each piece lands in the right account, and when a ProAdvisor should set it up. Independent firm, not affiliated with Square or Intuit Inc.
A Square–QuickBooks Online integration is a connector app that brings your Square activity into QuickBooks automatically — sales, tips, sales tax collected, processing fees, refunds, and the deposits Square sends to your bank. Square is a POS and payments platform; QuickBooks is your accounting system; the app is the bridge between them. The detail that matters most: Square settles in daily batches net of fees. A single deposit can bundle a day of sales, the sales tax you collected, tips you’re holding for staff, refunds you issued, and Square’s processing fee — all netted into one number. Record that deposit as a lump sum and the books are wrong: sales tax owed disappears, tips payable disappear, and the fee you paid never shows as an expense. Done well, the integration maps sales, tax, tips, and fees to the right accounts and you reconcile to the Square batches.
Reference maintained by the Certified QuickBooks ProAdvisor team at TechBrot Inc., an independent firm — not Square, not Intuit, and not Intuit’s official software support. Not affiliated with Square or Intuit Inc.
The Square–QuickBooks integration, in five questions.
What does a Square–QuickBooks Online integration do?
It connects Square — a point-of-sale and payments platform — to QuickBooks Online through a connector app, so your Square sales, tips, sales tax, processing fees, refunds, and daily batch deposits sync into the books automatically instead of being keyed in by hand. Set up well, each piece posts to the right account so revenue, tax, tips, and fees are all stated correctly.
How does Square deposit money, and why does it matter for the books?
Square settles in daily batches net of fees. The deposit that hits your bank is not your sales total — it bundles a day’s sales, the sales tax you collected, tips you’re holding, and refunds you issued, minus Square’s processing fee, all netted into one number. That is why the deposit can’t simply be booked as “sales.”
Why is recording a Square deposit as a lump sum a problem?
Booking the netted deposit as one lump sum of sales hides three things at once: the sales tax you owe the state gets buried in revenue instead of sitting as a liability, the tips you’re holding for staff are counted as your income, and the processing fees you paid never show up as an expense. The right approach maps sales, tax, tips, and fees to separate accounts.
Is the Square integration the same as reconciling in QuickBooks?
No. The integration imports and splits Square activity; reconciliation is the separate step that ties the connected bank account to the actual Square batch deposits, confirming every payout is present, nothing is duplicated, and the account closes to the right balance. You still reconcile to the Square batches regardless of how the sync is configured.
Do I need a ProAdvisor to set up the Square integration?
Not always — a simple, low-volume setup can be done by an owner. A Certified ProAdvisor earns the fee on mapping sales, tax, tips, and fees correctly, configuring the daily batch to post as its true parts rather than a lump sum, and untangling history where lump-sum deposits have already hidden tax and fees. We configure the sync inside your own QuickBooks file; an independent firm can’t touch your Square or Intuit account.
What a Square–QuickBooks integration is, plainly.
Square is a point-of-sale and payments platform: it rings up sales, takes card payments, calculates sales tax, captures tips, and deposits the money to your bank. QuickBooks Online is your accounting system. A Square–QuickBooks integration is a connector app that sits between the two and brings your Square activity into QuickBooks automatically — sales, tips, sales tax collected, processing fees, refunds, and the deposits Square sends — so you’re not re-keying the day’s register into the books by hand.
Here is the part that decides whether the books come out right. Square settles in daily batches net of fees. The deposit that hits your bank is not your sales total — it is one day’s sales, plus the sales tax you collected, plus tips you’re holding for staff, minus any refunds you issued, minus Square’s processing fee, all netted into a single number. If that deposit is recorded as one lump sum of “sales,” three things go wrong at once: the sales tax you owe the state is buried inside revenue instead of sitting as a liability, the tips you’re holding for employees are counted as your income, and the processing fees you paid never appear as an expense.
Done well, the integration splits each batch the way it really happened: sales to income, sales tax to a tax-liability account, tips to a tips-payable liability, and fees to an expense account — and then you reconcile the connected bank account to the actual Square batch deposits so the books tie to what Square paid out. We describe how the integration behaves and how to configure it accurately — we don’t claim capabilities the apps don’t have, and we’re not affiliated with Square or Intuit.
What a Square–QuickBooks integration does.
The moving parts of the integration, in the order they flow — from a sale at the register through the netted deposit that lands in your bank.
Part 01 · Square rings up the sale, tax, and tips
Square is the point-of-sale and payments platform: at the register or terminal it records the sale, applies the sales tax for the location, captures any tip, and takes the card payment. Everything the integration later syncs starts here — the gross sale, the tax collected, and the tip are all separate amounts at the moment of the transaction, even though they’ll be paid out together.
Part 02 · The connector app syncs Square activity into QuickBooks
A connector app links your Square account to QuickBooks Online and brings the day’s activity across automatically — sales, sales tax, tips, processing fees, and refunds — so you’re not re-keying the register into the books. The app is the bridge: Square stays the system of record for what happened at the point of sale, QuickBooks becomes the system of record for the accounting.
Part 03 · Square pays out in daily batches, net of fees
This is the part that decides whether the books come out right. Square doesn’t deposit each sale — it settles in a daily batch, and the deposit is net of fees. One deposit bundles the day’s sales, the sales tax collected, tips being held, and refunds issued, minus Square’s processing fee, into a single number that lands in your bank. The deposit is not your sales figure.
Part 04 · Each batch must be split into its true parts
Because the deposit is netted, the integration has to break it back apart: sales to an income account, sales tax to a tax-liability account, tips to a tips-payable liability, and processing fees to an expense. Configured this way, every piece is stated correctly — revenue isn’t inflated by tax and tips, the tax you owe is visible, and the fees you paid are on the books as an expense.
Part 05 · You reconcile to the Square batch deposits
The connected bank account in QuickBooks gets reconciled against the actual Square payouts — each batch deposit on the statement tied to the batch the integration recorded. This is the control that proves the sync captured everything, nothing is duplicated, and the books match what Square truly paid out, not just what the app thinks it sent.
The trap · Booking the deposit as a lump sum
The most common and most damaging mistake: recording the netted daily deposit as one lump sum of “sales.” It hides the sales tax you owe the state, counts tips you’re holding for staff as your income, and leaves the processing fees off the books entirely. The numbers look plausible and are quietly wrong — map sales, tax, tips, and fees to separate accounts instead.
How to connect Square to QuickBooks well.
Six steps, in order. The first set is the connection and account mapping; the rest are the habits that keep the books tied to what Square actually paid out.
Choose and connect the right connector app
Decide how Square will sync to QuickBooks Online — the connector app you use — and connect your Square and QuickBooks accounts to it. Confirm the connection covers what you need: sales, sales tax, tips, fees, refunds, and the deposits. The connection is the foundation; map it to the correct QuickBooks company file and the right bank account from the start.
Map sales, tax, tips, and fees to separate accounts
Before any data flows, set where each piece lands: Square sales to an income account, sales tax collected to a sales-tax-liability account, tips to a tips-payable liability, and processing fees to a fee expense account. This mapping is the whole game — get it right and every daily batch posts as its true parts instead of a misleading lump sum.
Configure the daily batch to post as its parts
Set the sync so each daily batch deposit is recorded broken out — gross sales, tax, tips, refunds, and the fee deduction — netting to the deposit that actually hit the bank. The goal is that the recorded deposit matches the bank deposit to the penny while still showing tax, tips, and fees separately. Never let the batch collapse into a single “sales” line.
Match the deposit to the bank, daily to weekly
Don’t let synced batches pile up unreviewed. Working the activity daily to weekly — confirming each recorded batch matches the corresponding bank deposit and catching anything odd — keeps the books current and makes problems small and obvious instead of large and buried. A backlog of unmatched Square activity is how a clean sync turns into a cleanup.
Handle refunds and chargebacks deliberately
Refunds and chargebacks reduce a batch and have to land in the right place — reversing sales and the related tax, not just shrinking the deposit. Confirm the integration is recording them as actual refunds against income and tax, so your revenue and sales-tax liability stay accurate. Left unhandled, refunds quietly overstate both income and the tax you appear to owe.
Reconcile to the Square batches every month
The integration is not a reconciliation. Each month, reconcile the connected bank account against the statement, tying each Square batch deposit to the batch the sync recorded, and confirm sales tax and tips payable carry the balances they should. The sync makes this faster because the data is already in; it never replaces the step. This is the control that proves the books are true.
Want the Square sync set up right, or netted-deposit books untangled?
A Certified ProAdvisor reviews the file free, then connects Square, maps sales, tax, tips, and fees to the right accounts, and reconciles to the batches — a focused setup is typically a $1,200–$3,000 fixed-fee scope; cleanup runs $1,500–$15,000+ if lump-sum deposits have been hiding tax and fees. Independent firm.
When a ProAdvisor should help.
High volume, multiple locations, or mixed tax
A busy register, several Square locations, or sales taxed at different rates multiplies the chances of mis-mapped tax, miscounted tips, and batches that don’t tie to deposits. Getting the mapping and the batch splits right from the start is far cheaper than unwinding months of netted lump sums — and it’s exactly what a ProAdvisor sets up cleanly inside your own file.
Sales tax and tips have to be exactly right
Sales tax is money you owe the state and tips are money you owe staff — both are liabilities, not income, and both are buried the moment a deposit is booked as a lump sum. When the tax filing or the tip payout has to be defensible, the mapping that keeps those liabilities visible and accurate is judgment work, and it’s where a ProAdvisor prevents the most expensive mistakes.
When lump-sum deposits have already hidden tax and fees
If Square deposits have been booked as lump-sum sales for months, the file is already understating tax owed and fees paid and overstating revenue and tips income — that’s not a sync tweak, it’s a cleanup. It starts with a file review and a fixed-fee restatement, after which the integration is configured properly so it stays clean. Restaurants and bars, where tips and tax both run through Square, hit this most often.
A Certified ProAdvisor configures the sync inside your own books.
Turning on the connector takes a minute; making the Square data land correctly is the real work. A Certified QuickBooks ProAdvisor maps Square sales to income, sales tax to a tax-liability account, tips to a tips-payable liability, and processing fees to an expense — then sets the sync so each daily batch posts as its true parts rather than a single lump sum, and reconciles the connected account to the actual Square payouts. Where lump-sum deposits have already buried tax and fees for months, we untangle the history, restate the splits, and bring reconciliation back into line — against a written scope, inside your own QuickBooks Online file. Independent firm — not Square, not Intuit, and not Intuit’s software support; a Square payout question or an Intuit account, login, or billing matter stays with the vendor.
Free
file review first — we look before we scope
$1,200–$3,000
typical fixed-fee scope to set up the sync and account mapping
Independent
Certified ProAdvisor firm — not Square, not Intuit, not Intuit’s software support
What people ask about the Square–QuickBooks integration.
Is this Square’s or Intuit’s official support?
What does a Square–QuickBooks integration actually sync?
Why can’t I just record the Square deposit as sales?
How should sales tax and tips be handled in the integration?
Does the Square integration reconcile my account for me?
We’ve been booking Square deposits as lump sums — can you fix it?
Can you set up the Square integration in my QuickBooks Online file?
Want the Square sync set up right, or netted-deposit books untangled?
We configure the Square integration inside your own QuickBooks file.
Connecting Square, mapping sales, tax, tips, and fees to the right accounts, and reconciling to the Square batches is operational bookkeeping — the work an independent ProAdvisor firm does inside your books. Start with a free file review; a focused setup is typically a $1,200–$3,000 fixed-fee scope, and if lump-sum deposits have been hiding tax and fees for months, a full cleanup runs $1,500–$15,000+. Written scope before any work begins.