What we do
Tools
Industries
Department
How we workLet's talk →
Home/Square QuickBooks Desktop Integration Paths
Square + QuickBooks Desktop

Square QuickBooks Desktop Integration: Which Route Suits Your Books

Square Connector by QuickBooks, the app most guides describe, only works with QuickBooks Online. A Desktop company file needs a third-party connector, a manual routine from Square's exports, or a sync written for your file. Which one fits depends on how many sales you post and whether Square payments ever settle invoices you raised in Desktop.

Square and a Desktop file: the four routes

Your setup Route What to check first
Daily Square sales from one account, posted as summaries A connector app. Intuit points Desktop users to Commerce Sync, and Square's App Marketplace lists Connex for QuickBooks Desktop. Desktop connectors reach the company file through software on the PC that holds it, so that machine has to be on when they sync. Check the listing for locations and split payments.
A few dozen sales a month By hand: export the period from Square's reports and enter one sales receipt or journal entry per day or week. Fees and refunds have to be split out by hand. If a bookkeeper offers an IIF import instead, back up the company file first.
Moving to QuickBooks Online soon anyway Square Connector by QuickBooks, Intuit's own app, once you've moved. Only worth it if the move is already planned. Setup is in our QuickBooks Online Square guide.
Square takes payments on invoices you raise in Desktop, or posting rules no app maps A Web Connector sync written for your company file. This is the build n-frames does, below.

Why Square's deposit and your Desktop books disagree

Sales posted net of fees

How you'll know: Income in Desktop is lower than Square's sales report, and processing fees never show as an expense.

Fix: Post gross sales, with Square's fee as its own expense line, so the deposit equals sales minus fees and both reports agree.

A refund comes out of a later payout

How you'll know: One deposit is short by an amount no sale on that day explains.

Fix: Record the refund against the day Square took it back, not the day of the original sale, and the payout ties again.

The deposit is in the books twice

How you'll know: The connector created the deposit, and the bank feed added it again.

Fix: In Bank Feeds, match the downloaded line to the deposit that's already there instead of adding it.

What this looks like in practice

Shopify retailer

Shopify to QuickBooks sync

A retailer's Shopify sales synced into QuickBooks as one number a day, and every month someone spent half a day working out why a payout didn't match. We rebuilt the sync to itemize by product category, use real product costs, and match each payout to the orders, fees and refunds behind it. The half-day reconciliation became a five-minute check.

A Square sync written for your company file

Square has a full API on its side. QuickBooks Desktop has no cloud API, so n-frames writes the sync as a Web Connector service, the scheduled qbXML route described on our QuickBooks Web Connector page. It posts Square sales to the accounts and items you choose, books fees on their own line, and breaks each payout back into the sales and refunds it covered.

The case connector apps don't describe is the customer you invoice from Desktop who then pays on your Square reader or through a payment link. A sales sync books that payment as a new sale, so the income lands twice and the invoice stays open. Ask your connector's vendor whether it handles this. When it doesn't, the n-frames sync applies the Square payment to the open Desktop invoice it paid.

Let's talk

Square at the counter, Desktop in the back office

n-frames builds the Web Connector service that posts Square sales, fees, refunds and invoice payments into your QuickBooks Desktop file, each payout tied to its deposit. You keep the Desktop file you already run.

Quote for a Square to Desktop sync →

Square to Desktop: locations, refunds and the quote

Does Square integrate with QuickBooks Desktop?

Not through Square Connector by QuickBooks, which is for Online. Desktop files connect through third-party apps such as Commerce Sync or Connex, through manual entry from Square's exports, or through a custom Web Connector service.

Does this handle multiple Square locations?

Yes. The sync n-frames builds can post each location's sales to its own class in the Desktop file, so a report by store stays accurate. If you're comparing connector apps, check each one's listing for multi-location support first.

What about Square refunds and chargebacks?

They post to the account you choose and link back to the original sale, and they're taken out of the payout Square actually deducted them from, so the deposit still matches the bank.

Is the quote for a Square to Desktop connection really free, with no obligation?

Yes. The quote costs nothing, and whether to go ahead with the Square connection afterwards is entirely your call.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.