Shopify QuickBooks integration that reconciles on the first try
The Shopify QuickBooks integration from Adapters posts orders as sales receipts, books Shopify Payments fees as an expense, and records refunds in the period they happened. Because fees are split out, the payout in QuickBooks matches the deposit on your bank statement.
No credit card required.
Field mapping auto-plugged · tap a port to rewire
Plug a source port into
Transform on this cable
JSON in
JSON out
5 sample records ready
Last updated September 2026
What running Shopify to QuickBooks by hand costs you
- Shopify pays out net of fees, so the deposit never equals the order total and reconciliation stalls.
- Refunds and chargebacks land in the wrong month and overstate revenue at close.
- CSV exports create duplicate customers every time a shopper checks out with a new email case.
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 / SHOPIFY
Output / QUICKBOOKS
Transforms included
Shopify money strings cast to QuickBooks decimal amounts, payout fees post to the expense account you choose, and order timestamps convert to your books timezone so revenue lands in the right period.
Shopify to QuickBooks in depth
This is the most commonly built ecommerce integration and the most commonly built wrong, because the bank deposit is not revenue. Both platforms also meter you, in completely different ways. Read from Shopify and Intuit documentation on 22 August 2026.
The deposit is not revenue, and that is the whole project
A Shopify Payments payout is gross sales minus discounts, refunds, processing fees and adjustments. Booking it as a single revenue line understates revenue, hides every expense inside it, and guarantees a variance nobody can explain at year end. Gross sales go to income, tax collected to a liability account, discounts to contra-revenue, processing fees to an expense, refunds to credit memos, and the payout becomes the bank deposit that clears all of them.
Shopify money is decimal, Stripe money is not
Shopify MoneyV2 carries an amount typed as Decimal!, for example 12.99, with a separate currencyCode. It is not in minor units. This is the exact opposite of Stripe, where amounts are integers in the smallest currency unit. A connector written against one and pointed at the other is off by a factor of one hundred, in whichever direction hurts most, and neither platform errors.
Two meters, two different models
Shopify GraphQL meters calculated query cost in points per second: 100 on Standard, 200 on Advanced, 1,000 on Plus, 2,000 on Enterprise, with no single query allowed to exceed 1,000 points. QuickBooks meters 500 requests per minute per realmId with a maximum of 10 concurrent connections. The read side is limited by query shape, the write side by connection count. Tuning one does nothing for the other.
Batch the QuickBooks writes to thirty operations
The QuickBooks batch endpoint accepts up to 30 operations per request, mixing creates, updates and queries. A connector writing one sales receipt per request is thirty times slower against the same allocation. Batches have their own separate ceiling of 40 per minute per realm, so fill each one rather than sending more, smaller batches. Thirty times forty is still 1,200 operations a minute, which is far more than any store needs.
Use a bulk operation for the history load
Paging several years of Shopify orders stalls at the 25,000 object pagination ceiling and burns points for hours. A bulk operation runs asynchronously, returns JSONL, and is not subject to the normal cost limits. From API version 2026-01 you can run five concurrent bulk queries per app per shop. The signed result URL expires after one week, so download it as soon as the job reports complete.
Decide summarized journals or order-level detail before you build
These are different products, not different settings. Summarized daily or per-payout journals give a bookkeeper one clean entry that ties to the bank, which is what most accountants want and what high-volume stores need. Order-level detail puts every transaction in the ledger, which suits B2B sellers who invoice and need document-level history. Building one and then being asked for the other means starting over, so get the answer in writing first.
Map to the existing chart of accounts, not to invented ones
Left to themselves, connectors create their own income, clearing and fee accounts, and you end up with a chart of accounts nobody recognizes and a reclassification project at year end. Pull the existing accounts first, agree the target for gross sales, tax, discounts, fees, refunds and gift cards, and map to those. It takes an hour. Related route: Stripe to QuickBooks.
Never verify the load by comparing counts
Shopify counts are only accurate up to 25,000 items, so a team that compares a Shopify order count to a QuickBooks transaction count and sees a match may be comparing two numbers that were both capped in the same place. Verify by walking one real payout end to end through gross, tax, discounts, fees and refunds to the bank deposit. Full limit sets: Shopify API rate limits and QuickBooks API rate limits.
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 Shopify 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.
Prefer to understand the moving parts first? Our long-form guide to how to sync Shopify orders to QuickBooks covers the field-by-field detail, the failure cases, and what changes at volume.
Shopify to QuickBooks sync: common questions
How do I connect Shopify to QuickBooks Online?
Authorize both accounts, map Shopify orders to QuickBooks sales receipts or invoices, point Shopify Payments fees at an expense account and sales tax at your liability account, then set a schedule. The fee mapping is the step people skip and the reason reconciliation stalls.
How do I categorize Shopify sales in QuickBooks?
Post the gross order as revenue, sales tax to a sales tax liability account, shipping income to its own account, and the payment processing fee as an expense. Categorizing the net payout as one lump of sales income hides the tax you owe and understates real revenue.
Why does my Shopify payout not match the order total in QuickBooks?
Shopify pays out net of processing fees, refunds, and chargebacks, so the bank deposit is always smaller than the sum of the orders in it. Splitting each payout into its gross sales, fees, and adjustments is what makes the deposit reconcile on the first try.
Does Shopify replace QuickBooks?
No. Shopify records what you sold, QuickBooks records what that did to your books, and only QuickBooks produces the financial statements your accountant and the IRS expect. Shopify reporting is a sales view, not a general ledger, so the two run side by side.
How does the Shopify to QuickBooks sync work?
The Shopify QuickBooks integration from Adapters posts orders as sales receipts, books Shopify Payments fees as an expense, and records refunds in the period they happened. Because fees are split out, the payout in QuickBooks matches the deposit on your bank statement.
Is there a prebuilt Shopify connector for QuickBooks?
Yes. This Shopify 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 Shopify 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 Shopify 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 Shopify and QuickBooks?
No. Fields are auto-mapped the moment you pick the pair, and you can rewire any mapping visually before the first sync. Shopify money strings cast to QuickBooks decimal amounts, payout fees post to the expense account you choose, and order timestamps convert to your books timezone so revenue lands in the right period.
More pairs from the API connector library
Browse the full api connector library, or request a pair you do not see.
Shopify 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.
No credit card required.