Square + QuickBooks Online
Import Square settlements into QuickBooks Online — with fees, tips, and sales tax split correctly
Square's native QBO sync records each deposit as a lump-sum net amount — accountants then rebuild fees, sales tax, tips, and refunds by hand. BridgeBooks reads Square Settlement and Transactions CSVs directly, splits every deposit into the right GL accounts, and preserves multi-location attribution.
Why this is painful
What Square statements cost you today
Square's QBO sync records net deposits without the breakdown
Each Square payout lands in QBO as a single net number. Fees, sales tax by jurisdiction, tips, refunds, and chargebacks all get lumped together — which means rebuilding detail manually for every deposit if you need GL-level reporting.
Sales tax breakdown matters and gets lost
Multi-jurisdiction retailers owe sales tax to multiple states / counties / cities. Square tracks it per transaction; the QBO sync flattens it. Without the breakdown, sales-tax filings turn into a spreadsheet exercise.
Multi-location and tipping complicate attribution
Restaurants with multiple Square locations want each location's revenue and tips in its own QBO class. Square's native sync doesn't preserve that mapping — accountants spend hours re-classifying.
Four steps
Square statement → QuickBooks Online
- 1
Download the Square Settlement report (CSV)
In Square Dashboard → Reports → Sales → Settlements → export as CSV for the period you need. Transactions report complements it for transaction-level detail.
- 2
Upload to BridgeBooks
Drop the CSV — or up to 12 reports in one batch — into BridgeBooks. Multi-location, multi-month, mixed report types all work in the same upload.
- 3
Our AI extracts and dedupes
Every settlement is parsed: gross sales, processing fees, sales tax (by jurisdiction), tips, refunds, chargebacks. 4-level duplicate detection flags anything already in your client's QBO file.
- 4
Review and push to QuickBooks
Adjust vendors, accounts, or QBO classes (for multi-location), flag anything uncertain, and push approved transactions directly into the client's QBO file via OAuth.
Square-specific details
Built around how Square statements actually look
- Works with Square Settlement reports (CSV) and Transactions exports.
- Each Square deposit becomes a clean QBO deposit with gross sales, processing fees, refunds, tips, and sales tax split into separate transactions on the right GL accounts.
- Sales tax breakdown by jurisdiction preserved — multi-state retailers see the tax owed per state, county, and city in QBO.
- Multi-location Square: each location maps to its own QBO class (or location) for clean per-location reporting downstream.
- Tip allocation across staff captured for payroll integration; can be coded to a tip-liability GL account before being paid out.
FAQ
Common Square questions
Comparing BridgeBooks to alternatives?
Side-by-side comparisons with the other tools accounting firms consider.
BridgeBooks vs AutoEntry
AutoEntry is a Sage-owned receipt + statement capture tool that supports QuickBooks Online as a secondary integration. BridgeBooks is purpose-built for QBO firms — multi-client workspaces, per-client vendor rules, 4-level dedupe against the QBO file, and a workflow tuned for the monthly accounting close.
Read moreBridgeBooks vs Booke.ai
Booke.ai is a broad AI-first bookkeeping automation play covering categorization, reconciliation, and chat-based clarification. BridgeBooks is purpose-built for one workflow — statement import into QuickBooks Online — with multi-cardholder attribution, 4-level QBO dedupe, and per-client vendor rules. Best fit when statement-import volume is the bottleneck and you want a focused tool, not a platform.
Read moreBridgeBooks vs Dext
Dext is a leader in receipt and supplier-invoice capture. It also handles bank statements, but as a secondary use case. BridgeBooks is purpose-built for statement import into QuickBooks Online — with multi-cardholder attribution, 4-level QBO dedupe, per-client vendor rules, and a workflow tuned for the accounting-firm monthly close. Most firms run both: Dext for receipts and bills, BridgeBooks for statements.
Read moreBridgeBooks vs DocuClipper
DocuClipper is a solid PDF-to-CSV OCR tool. BridgeBooks is a full statement-import workflow purpose-built for accounting firms: one workspace across every client, vendor rules that auto-code transactions on import, and a direct 1-click push to QuickBooks Online with duplicate detection — instead of a CSV you still have to map and upload by hand.
Read moreBridgeBooks vs Hubdoc
Hubdoc is a Xero-first product owned by Xero. It pushes to QuickBooks Online too, but the workflow is shaped around document fetching, not statement-volume processing. BridgeBooks is the QBO equivalent — purpose-built for firms importing dozens of bank, credit card, and Venmo statements per month into client QBO files, with vendor rules, multi-client switching, and duplicate detection built in.
Read moreBridgeBooks vs QuickBooks bank feeds
BridgeBooks isn't a QuickBooks Online replacement — it's a companion. QBO's bank feed handles the happy path. BridgeBooks handles the rest: broken or never-connected accounts, multi-month historical catch-ups, PDF-only sources (Venmo, merchant deposits, some credit unions), and multi-cardholder credit card statements. Same QBO file, same workflow, no duplication.
Read more
See BridgeBooks on your own client statements
Book a 20-minute demo — we'll walk through the full workflow on a real statement, answer your firm's questions, and put together a custom quote.
- Upload to reviewed push, end to end
- Run on a real client statement
- A custom quote for your firm
Request your demo
A real person responds — no automated follow-ups.