Skip to content
adapters.io

Square QuickBooks integration that ties payouts to sales

The Square QuickBooks integration from Adapters posts Square sales, tips, sales tax, and processing fees into QuickBooks and matches each Square payout to the deposit in your bank feed. It is no-code and runs on the schedule you set.

No credit card required.

Field mapping auto-plugged · tap a port to rewire

5 sample records ready

Last updated September 2026

What running Square to QuickBooks by hand costs you

  • Square batches a day of sales into one payout, so a lump deposit hides the tips, tax, and fees inside it.
  • Booking gross sales without splitting out the Square fee overstates revenue every single day.
  • Sales tax collected at the register has to land in a liability account, not in income.

The field mapping, out of the box

These cables are pre-wired when you pick the pair. Rewire any of them, or add your own, in the same visual data mapping tool you use for every adapter.

Input / SQUARE

payment.id
SalesReceipt.PaymentRefNum
order.total_money
SalesReceipt.TotalAmt
order.tax_money
SalesReceipt.TaxLine
payment.tip_money
SalesReceipt.TipLine
payment.processing_fee
Expense.TotalAmt
payout.arrival_date
Deposit.TxnDate

Transforms included

Amounts convert from Square minor units to QuickBooks dollars, tax posts to your sales-tax liability account, tips post to a separate line, and the processing fee books as an expense so each payout reconciles against the matching bank deposit.

Square to QuickBooks in depth

Card payments into a ledger. The Square side is straightforward once you respect the integer amounts and the cursor; the QuickBooks side is metered tightly enough that concurrency, not volume, decides your throughput. Read from Square and Intuit documentation, facts current as of 1 September 2026.

Square money is an integer in the smallest denomination

Square documents that a monetary amount is specified in the smallest denomination of the currency, so USD amounts are cents and 4250 means $42.50. Currencies such as the Japanese Yen are zero-decimal, where the smallest unit is one yen and no division applies. Any pipeline that hardcodes a divide by 100 misstates every zero-decimal currency by a factor of one hundred, with no error raised anywhere. Branch on the currency code.

The last page of a Square result set has no cursor

Square paginates with an opaque cursor. The first call omits it, each response carries the cursor for the next page, and the last page does not include one. That absence is the terminator, and it is the single most common place this integration breaks: code that loops while a cursor is truthy works, code that loops on a fixed page count silently drops the tail of the data. Default and maximum page sizes vary per endpoint, so read the limit for each one rather than assuming a shared value.

Square does not publish a rate limit number, so do not hardcode one

We are not going to print a figure here, because Square does not publish one and its own developer forums carry unanswered questions asking for it. That is worth stating plainly rather than repeating a number from a blog post. The correct design is to treat the rate limit as unknown and discoverable: handle the rate limit error explicitly, back off exponentially with jitter, and let observed throughput settle wherever it settles rather than tuning to a constant that was never documented.

QuickBooks meters per company file, and concurrency bites first

Intuit allows 500 requests per minute per realmId and a maximum of 10 concurrent connections to the same company. The concurrency ceiling is the one that catches people: a worker pool sized for throughput throws 429 errorCode 003001 while nowhere near the per-minute budget, and each retry adds another in-flight connection to the pile. Cap the pool at ten and the errors stop without any change in total throughput.

Batch the writes, thirty operations at a time

The QuickBooks batch endpoint takes up to 30 operations per request and will mix creates, updates and queries in one call. Writing one sales receipt per request is thirty times more expensive for identical work. The batch endpoint has its own ceiling of 40 requests per minute per realm, so fill each batch rather than sending twice as many half-empty ones.

Fees are a separate posting, not a smaller sale

Square keeps a processing fee, and the deposit that reaches the bank is net of it. Booking the net amount as revenue understates income and hides the expense entirely. Post the gross as income and the fee as a merchant fee expense, so the two together reconcile to the deposit. Refunds are a credit dated when issued, not when the original sale happened.

Deposit timing is not sale timing

One Square deposit covers a batch of transactions from a settlement window, which near a month end can straddle two accounting periods. A connector that books everything on the deposit date misstates the period cutoff every month. Book each payment on its own date and use the deposit only to clear those payments against the bank line. Related route: Stripe to QuickBooks.

How it goes live

Three steps, minutes end to end, covered by flat data integration pricing from $49 a month.

STEP 01

Pick the pair

Connect Square and QuickBooks with scoped credentials. About a minute each.

STEP 02

Confirm the mapping

The cables above are pre-wired. Adjust any field, preview the transform on sample records, done.

STEP 03

Schedule the sync

Hourly down to every minute, with retries, alerting, and a full log on every run.

Try it in the live demo Preloads SQUARE → QUICKBOOKS with sample records

Square to QuickBooks sync: common questions

Does Square integrate with QuickBooks?

Square data can reach QuickBooks Online several ways, but the useful question is whether the integration splits each payout into sales, tax, tips, and processing fees. If it posts only the net deposit, your sales tax liability and fee expense are both wrong from day one.

How do I connect Square to QuickBooks Online?

Authorize both, then map four destinations: an income account for sales, your sales tax liability account, a tips liability account, and an expense account for Square processing fees. Set the schedule and backfill period, and confirm the first payout reconciles before moving on.

How do I record Square fees in QuickBooks?

Book them as an expense against a merchant fee account on the transaction date, keeping gross sales intact. Square deducts fees before the payout, so if you record only what arrived in the bank you have quietly understated both revenue and cost of sales.

How do I handle Square tips and sales tax in QuickBooks?

Tips are a liability until you pay them out, not revenue, so they belong on their own line rather than in sales. Sales tax collected goes to a liability account. Rolling either into income inflates revenue and leaves you short when the filing is due.

How does the Square to QuickBooks sync work?

The Square QuickBooks integration from Adapters posts Square sales, tips, sales tax, and processing fees into QuickBooks and matches each Square payout to the deposit in your bank feed. It is no-code and runs on the schedule you set.

Is there a prebuilt Square connector for QuickBooks?

Yes. This Square to QuickBooks connector ships prebuilt: the field mapping is wired the moment you pick the pair, transforms are included, and you can try it against sample records in the live demo. No code or engineering sprint required.

How much does the Square QuickBooks integration cost?

Pricing is flat and monthly: Starter at $49, Growth at $149, Scale at $399. Every plan includes this pair, visual field mapping, and per-record logs. There are no per-task or per-row fees, so the bill stays the same as volume grows.

How often can Adapters sync Square to QuickBooks?

Hourly on Starter, every 5 minutes on Growth, and down to every minute on Scale. Failed records retry automatically with backoff, and alerting plus a full per-record log come standard on every run.

Do I need to write code to connect Square and QuickBooks?

No. Fields are auto-mapped the moment you pick the pair, and you can rewire any mapping visually before the first sync. Amounts convert from Square minor units to QuickBooks dollars, tax posts to your sales-tax liability account, tips post to a separate line, and the processing fee books as an expense so each payout reconciles against the matching bank deposit.

More pairs from the API connector library

stripe quickbooks integration shopify netsuite integration salesforce hubspot integration airtable google sheets sync postgres to snowflake sync shopify quickbooks integration salesforce netsuite integration paypal quickbooks integration stripe netsuite integration hubspot quickbooks integration quickbooks to xero migration shopify xero integration salesforce to snowflake integration square netsuite integration hubspot xero integration salesforce to bigquery integration postgres to bigquery netsuite to snowflake integration quickbooks to bigquery integration stripe to snowflake integration shopify to snowflake integration quickbooks to snowflake integration hubspot to snowflake integration netsuite to bigquery integration stripe to bigquery integration shopify to bigquery integration paypal to snowflake integration square to snowflake integration square to bigquery integration netsuite to postgres integration salesforce to postgres integration xero to snowflake integration hubspot to bigquery integration xero to bigquery integration paypal to bigquery integration stripe to postgres integration snowflake to bigquery migration shopify to postgres integration hubspot to postgres integration bigquery to snowflake migration quickbooks to postgres integration xero to postgres integration square to postgres integration paypal to postgres integration snowflake to postgres mysql to postgres migration mysql to snowflake redshift to snowflake migration mysql to bigquery sql server to snowflake sql server to postgresql migration

Browse the full api connector library, or request a pair you do not see.

Square and QuickBooks, finally in agreement

Map the pair once and let it sync on schedule. Flat price from $49 a month, no per-task fees.

Try the live demo

No credit card required.