Squarespace sales in QuickBooks Online: the connector settings that matter
Squarespace merchants syncing into QuickBooks Online with QuickBooks Connector face setup choices that change what lands in the books.
The question keeps surfacing wherever Squarespace sellers compare notes: orders stack up in the store, and nothing reaches QuickBooks Online unless someone types it in again. The formally accepted answer is an Intuit-published walkthrough for QuickBooks Connector, the integration service also known by the OneSaas name. We walked through it in order. The link-up itself takes minutes. The settings inside it deserve a slower look, and the guide says plainly that it assumes basic accounting knowledge.
The connection comes first
You begin by authorizing both systems inside the connector. Squarespace goes on one side, QuickBooks Online on the other, and each link is confirmed from a manage screen. No data moves until both accounts are connected. Once they are, the service opens a configuration flow that asks a run of accounting questions rather than technical ones.
Settings that shape the books
The first decisions are housekeeping. You set the account timezone so timestamps line up between store and ledger. You set an integration start date, which controls how far back the connector reaches for orders. Get that date wrong and you either miss recent sales or re-import history you already recorded.
Then comes the scope of the sync. Squarespace sales and products can flow into QuickBooks Online. If you track inventory there, the connector can read stock levels and push updates back to the storefront, so Squarespace reflects what you actually hold.
Which order states should the connector pull?
This is the choice merchants most often get wrong. The integration only retrieves Squarespace orders from the states you select. The walkthrough recommends including pending and fulfilled orders, not just completed ones, because the right mix depends on when your business recognizes revenue. Tighten the list too far and finished orders sit unsynced. Loosen it carelessly and half-finished activity becomes noise in the ledger.
Should orders arrive as invoices or sales receipts?
QuickBooks Online can receive each Squarespace order as a sales receipt or as an invoice, and the guide leaves that judgment to you. Receipts suit storefront sales paid by card at checkout. Invoices suit orders you bill now and settle later. It is far easier to choose correctly before real volume flows than to unwind the wrong document type afterward.
Prefixes, shipping, discounts, and gift cards
Four smaller mappings follow, and each sends money somewhere specific. An order number prefix keeps multi-channel bookkeeping sane. Order 1234 from Squarespace can arrive tagged SQ-1234, so it never collides with an identically numbered order from another channel. Shipping charges can be assigned to a dedicated item, turning postage into a trackable revenue line instead of an orphan amount. Discounts get their own item for the same reason. Gift card sales map to a product you name, keeping that obligation visible rather than buried in generic sales.
Refunds, edits, and stalled transfers
The accepted answer is a setup guide, and setup guides end where the awkward questions begin. Refunds are the first gap worth probing. Refund one test order in Squarespace and confirm the reversal reaches QuickBooks Online in the form you expect. If it does not, record refunds by hand until you understand the pattern.
Edits are the second gap. Change a test order after it syncs and watch the books: a corrected record is the good outcome, a duplicate is the bad one. Gift cards deserve their own test, since the sale and the later redemption are two different accounting events, and the mapping in the walkthrough covers the first.
Stalled transfers are the third. Connectors fail quietly when a login expires or a product mapping breaks. Put one person in charge of checking sync status on a schedule rather than discovering gaps at month end.
A first week that earns trust
Run a small live batch before you connect a busy season to this. Reconcile the connector’s totals against your Squarespace dashboard and your bank feed, and treat any difference as a configuration question rather than a rounding quirk. Duplicates are the loudest early symptom of a wrong order-state or document-type choice.
If you enabled the inventory return path, sell a single unit and confirm the count moves in QuickBooks Online before trusting it across the catalog. The walkthrough, which Intuit maintains and updated recently, points to its own help channel for setup questions. The accounting judgments, though, stay with you and your bookkeeper.