Blog · Ecommerce Bookkeeping
Does Shopify Integrate With QuickBooks? What the Connection Actually Does
By NenoBooks Editorial Team · Reviewed August 12, 2026
Yes. Shopify integrates with QuickBooks Online through Intuit's Shopify Connector by QuickBooks app. The connector can import Shopify sales, refunds, fees, payouts, products, customer information, and related transaction details into QuickBooks Online.
But connecting the systems is only the first step. A successful sync does not automatically prove that Shopify activity, QuickBooks records, payouts, and bank deposits have been reconciled correctly.
That distinction matters because a Shopify sale, a Shopify payout, and the deposit that appears in your bank account are related—but they are not the same accounting event.
Does Shopify integrate with QuickBooks?
Yes for QuickBooks Online. QuickBooks Desktop requires a more qualified answer.
| Version | Current official route | What to know |
|---|---|---|
| QuickBooks Online | Shopify Connector by QuickBooks from Intuit | Current connector imports Shopify transactions and supports a payout-to-bank reconciliation workflow |
| QuickBooks Desktop | Shopify's documented Desktop Connector workflow | Shopify's official help is specifically scoped to QuickBooks Desktop POS merchants migrating to Shopify |
Shopify and QuickBooks Online
Intuit's current U.S. documentation says Shopify Connector by QuickBooks automatically imports Shopify transactions and related details into QuickBooks Online. Setup options include the transaction start date, deposit and payment accounts, automatic transaction posting, Product Tracking, and Customer Tracking.
You can choose an import date going back up to 12 months. Intuit also notes that transactions imported from that historical period can be excluded or undone if they were previously entered.
That makes the start date important. If January Shopify sales are already in QuickBooks and you later install the connector with January 1 as the import date, you can create overlapping records that need to be reviewed.
The Shopify App Store currently lists the QuickBooks Online app as developed by Intuit and identifies sales, refunds, payouts, customers, inventory/products, historical importing, and bank reconciliation among its features.
What about QuickBooks Desktop?
Shopify does document a QuickBooks Desktop integration, but the scope is specific.
Its current help center says the information applies only to QuickBooks Desktop POS merchants migrating to Shopify. In that workflow, compatible QuickBooks Desktop accounting software can continue syncing business and accounting data with Shopify after the POS migration.
That should not be read as universal official Shopify-to-QuickBooks-Desktop compatibility for every Desktop user.
If you use QuickBooks Desktop outside that migration scenario, confirm that your exact Desktop edition and intended connector are supported before changing your books.
What does Shopify sync to QuickBooks Online?
The current Intuit connector brings in more than the net Shopify deposit.
Sales and payments
Intuit describes Payment Received transactions as individual Shopify sales. Imported details can include gross amount, shipping, discounts, taxes, fees, and the associated products or services.
When a payment is confirmed, QuickBooks Online creates a Sales Receipt for the sale and an Expense for associated fees. Intuit says those amounts are initially recorded in Undeposited Funds or Payments to deposit until the payout is processed.
This is why the amount reaching your bank can differ from the store's underlying sales activity.
Refunds, discounts, and processing fees
Refunds are imported as separate transactions. Discounts and fees are also represented in the connector's sales and payout workflow, with configurable accounts available for fees and other adjustments.
Recording those components separately preserves information that disappears when a merchant records a net Shopify bank deposit as revenue.
Shopify payouts
A Shopify payout groups underlying activity before the resulting amount reaches your bank.
The connector shows the transactions included in the payout and a separate section for payout adjustments. After the underlying transactions and adjustments have been processed, confirming the payout creates a Deposit transaction in QuickBooks Online for the net payout amount.
That Deposit is then matched to the corresponding transaction from the bank feed.
Products and customers
Product Tracking and Customer Tracking are optional connector settings.
With Product Tracking enabled, Intuit says the app attempts to match Shopify products against existing QuickBooks items using SKU and name information. Close matches can require review, while a product without a suitable match may need to be created manually.
When Customer Tracking is disabled—or no customer match is found—the connector can use a default Shopify customer. Similar default-item behavior applies when Product Tracking is off or no product match exists.
More detail is useful only when the resulting mappings are maintained and reviewed.
Sales-tax information
The connector also records tax-related information contained in Shopify transactions. Intuit separately documents marketplace taxes collected by Shopify and merchant-liable taxes in the QBO connector workflow.
That is a bookkeeping and software function. It does not determine whether your business has sales-tax nexus, where you must register or file, or how a particular transaction should be treated for tax purposes.
NenoBooks' Shopify bookkeeping service likewise excludes sales-tax filing, remittance, nexus advice, tax preparation, audits, legal advice, and licensed accounting opinions.
| Activity | What the connector can handle | What still deserves review |
|---|---|---|
| Shopify sales | Imports individual payment activity and details | Product, customer, and account mappings |
| Refunds | Imports refund transactions | Exceptions and correct treatment |
| Discounts | Records discount information | Mapping consistency |
| Processing fees | Creates fee activity within the workflow | Expense-account mapping |
| Payouts | Creates the payout and Deposit workflow | Adjustments and agreement to Shopify records |
| Products | Optional tracking and matching | Unmatched or incorrect matches |
| Customers | Optional tracking | Matching exceptions and desired detail |
| Bank deposit | Can suggest a match to the created Deposit | Confirm it is genuinely the same transaction |
How Shopify activity becomes a QuickBooks bank match
The simplest way to understand the accounting flow is:
Shopify sale → fees/refunds/adjustments → Shopify payout → QuickBooks Deposit → bank-feed match
Intuit's documented process has three practical stages:
- Review or confirm the individual Shopify transactions.
- Review the payout and its adjustments, then add or confirm the payout.
- Match the resulting QuickBooks Deposit against the Shopify deposit in the bank feed.
Illustrative payout example
These numbers are hypothetical and show only how the mechanics can work.
| Shopify activity | Illustrative amount |
|---|---|
| Gross sales before discounts | $10,000 |
| Discounts | -$500 |
| Refunds | -$300 |
| Processing fees | -$250 |
| Other payout adjustment | +$50 |
| Illustrative net payout | $9,000 |
The bank can therefore show a $9,000 deposit even though the store had $10,000 of gross sales before discounts.
If that $9,000 is entered simply as revenue, the books no longer show the $500 discount, $300 refund, $250 processing fee, or $50 adjustment separately.
Under Intuit's documented connector workflow, those underlying transactions are handled first. Confirming the payout then creates the net QuickBooks Deposit, which can be matched to the corresponding bank transaction.
Why “connected” does not necessarily mean “reconciled”
The connector can move data while still leaving items that need review.
Intuit's own workflow includes review states for missing customer, product, or account information, along with adjustment review and bank matching.
Incorrect or incomplete mappings
An imported transaction can require additional information before it is confirmed.
Product matching is one example. The connector attempts to match by SKU and name, but close matches can be sent for review and unmatched products can require manual creation.
Data reaching QuickBooks therefore does not prove that every transaction landed in the account or item you intended.
Duplicate transactions from overlapping dates
Imagine that a merchant manually recorded all January Shopify activity and then installs the connector in February with January 1 as the import date.
Because Intuit supports historical importing up to 12 months back, the connector can bring in activity from a period that already exists in the books. Intuit specifically provides exclude and undo options for previously entered imported transactions.
Check the import start date against the periods already completed in QuickBooks before importing historical activity.
Adding the bank deposit instead of matching it
This is one of the most important controls in the current workflow.
After confirming a Shopify payout, QuickBooks creates the corresponding Deposit. When the Shopify money appears in the bank feed, Intuit instructs users to match that bank transaction to the existing Deposit rather than adding another deposit manually.
Adding it again can duplicate activity that is already represented in QuickBooks.
Chargebacks and other payout adjustments
Shopify payouts are not always made up only of straightforward sales and processing fees.
Intuit's connector settings include accounts for miscellaneous adjustments, reserve balances, tips, gift cards, holds, and disputes. Some payout adjustments can require an account to be selected before the payout is confirmed.
Those exceptions are another reason to review the payout instead of treating every imported item as finished bookkeeping.
Test edited and foreign-currency orders carefully
There is also a current reason to test your own workflow before relying on it at scale.
In July 2026, individual Shopify App Store reviewers reported problems involving edited orders and foreign-currency transactions. Intuit responded to one July 20 review that its engineering team was working on the reported issues and limitations. These are merchant reports, not evidence that every Shopify store will experience the same problem.
If edited orders, delayed captures, or multiple currencies are common in your store, test representative transactions and confirm that the resulting payout agrees with Shopify and the bank.
Month-end timing differences
Sales, payout creation, QuickBooks activity, and the eventual bank deposit can occur on different dates.
A month-end review should distinguish a legitimate timing difference from a missing or duplicated transaction instead of forcing the records to agree prematurely.
Individual transactions vs payout summaries
Different Shopify accounting tools can put different levels of detail into QuickBooks.
Intuit's current connector imports individual Payment Received and Refund transactions and then associates those transactions with payouts.
By contrast, A2X's own Shopify documentation says its standard approach uses consolidated payout data to create a summary of the revenue, expenses, and other transactions that make up the payout rather than importing every Shopify order as an individual QuickBooks sales receipt or invoice.
That gives merchants a real architectural choice rather than a simple “more automation is better” decision.
| Consideration | Individual-transaction approach | Payout-summary approach |
|---|---|---|
| Detail inside QuickBooks | Higher | More summarized |
| Ledger volume | Higher | Lower |
| Customer/product visibility | Typically stronger | Usually less granular |
| Reconciliation focus | Transactions grouped into payouts | Summary tied closely to payout |
| Best fit | Businesses needing transaction detail in QBO | Businesses prioritizing compact payout-level accounting |
The right approach depends on what information you actually need in QuickBooks, transaction volume, and how your reconciliation and reporting process works.
How to connect Shopify to QuickBooks Online
For Intuit's current QuickBooks Online connector:
- Sign in to QuickBooks Online and open Integrations.
- Find Shopify Connector by QuickBooks.
- Authorize your Shopify store.
- Choose the transaction start date and relevant deposit, payment, product, and customer settings.
- Allow transactions to import.
- Review or confirm the individual transactions.
- Review the related payout and its adjustments.
- Confirm the payout.
- Match the resulting QuickBooks Deposit to the corresponding bank transaction.
Software menus and connector behavior can change, so use Intuit's current Shopify Connector documentation for the latest setup sequence rather than relying on an older screenshot tutorial.
What to check after connecting Shopify and QuickBooks
Before treating the setup as complete, check whether:
- the historical import date overlaps activity already recorded in QuickBooks;
- the intended deposit and payment accounts are selected;
- sales, refunds, fees, and payout adjustments use appropriate mappings;
- product and customer exceptions are being reviewed when those tracking options are enabled;
- each payout can be explained by its underlying Shopify activity;
- the QuickBooks Deposit agrees with the actual bank deposit;
- bank-feed deposits are matched rather than added again;
- duplicate sales or deposits have appeared;
- refunds, disputes, chargebacks, or other adjustments remain unresolved; and
- month-end timing differences are documented rather than treated automatically as missing cash.
These checks follow the risks visible in Intuit's current import, review, payout, and bank-matching workflow.
When the integration may need bookkeeping cleanup
Installing a connector does not repair historical bookkeeping problems automatically.
Cleanup may be needed when Shopify sales were previously entered manually, net deposits were booked directly as revenue, duplicate sales or deposits exist, prior months remain unreconciled, fees or refunds were mapped incorrectly, or account mappings changed over time.
For example, a connector can import an overlapping January transaction, but it cannot decide without context which historical entry should remain in a previously worked set of books.
NenoBooks offers catch-up and cleanup bookkeeping for agreed historical periods, including transaction review, correction of miscoded items, bank and credit-card reconciliation, and investigation of duplicate or unclear activity.
The goal is to establish a clean point from which an ongoing monthly process can continue.
When a Shopify bookkeeper can help
The technical question is:
Can Shopify connect to QuickBooks?
The bookkeeping question is:
Do Shopify, QuickBooks, and the bank agree after the connection is running?
NenoBooks' Shopify bookkeeping service currently includes Shopify payout reconciliation; sales, fee, refund, and discount categorization; bank and credit-card reconciliation; exception follow-up; and monthly P&L, balance-sheet, and cash-flow reporting. NenoBooks also states that it works in QuickBooks Online alongside Shopify store records.
For sellers using multiple stores, marketplaces, or processors, NenoBooks' ecommerce bookkeeping service covers broader sales-channel and processor activity. Its monthly bookkeeping service covers recurring transaction categorization, bank/card reconciliation, exception review, and agreed monthly reports.
NenoBooks does not provide Shopify sales-tax filing or nexus advice, tax preparation, payroll processing, audits, legal advice, or licensed accounting opinions as part of the Shopify bookkeeping service.
If your Shopify payouts still do not agree with QuickBooks and the bank, view Shopify bookkeeping services to see the scope of NenoBooks' payout-reconciliation and monthly-bookkeeping work.
Frequently asked questions
Does Shopify integrate directly with QuickBooks Online?
Yes. Shopify connects to QuickBooks Online through Intuit's Shopify Connector by QuickBooks app. It is more precise to describe this as an Intuit-developed connector than as a generic built-in Shopify accounting feature.
What Shopify data syncs to QuickBooks?
Intuit currently documents individual payments, refunds, fees, payouts, products, customer information, discounts, taxes, and related transaction details. The exact information recorded depends partly on your connector settings and mappings.
Can Shopify connect to QuickBooks Desktop?
Shopify has an official QuickBooks Desktop workflow, but its current help documentation says that material applies specifically to QuickBooks Desktop POS merchants migrating to Shopify. Desktop users outside that scenario should verify their exact edition and connector rather than assuming the QuickBooks Online instructions apply.
How do Shopify payouts reconcile in QuickBooks?
Under Intuit's current QBO workflow, the underlying transactions are processed first. Confirming the payout creates a QuickBooks Deposit for the net payout amount. When the corresponding Shopify deposit reaches the bank feed, it should be matched to that existing Deposit rather than added again.
Can connecting Shopify to QuickBooks create duplicates?
Historical importing can create overlapping records when the same transactions were already entered another way. Intuit currently allows imports from up to 12 months back and lets users exclude or undo previously entered imported transactions.
Should Shopify orders be synced individually or by payout?
It depends on the accounting workflow. Intuit's connector brings individual transaction activity into QBO before grouping it into payouts, while tools such as A2X document a consolidated payout-summary approach. The appropriate model depends on the detail required inside QuickBooks, transaction volume, and reconciliation needs.