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
Try BridgeBooks on your own client statements
First 30 days free, up to 500 reviewed transactions. No card required. Connect QuickBooks and upload your first statement in minutes.
- Connect QuickBooks Online
- Upload a real client statement
- Review and push extracted transactions to QBO