Using Shopify Connector by QuickBooks
Follow the Integration transactions sequence below. The connector records individual activity and then creates the payout Deposit. The downloaded bank line should be matched to that Deposit.
Shopify Connector by QuickBooks
Match the Shopify payout deposit. Do not add it twice.
In the current connector workflow, the QuickBooks deposit is created from reviewed Shopify activity before the downloaded bank line is handled. The bank line is the match—not a second sale or deposit.
Positive Shopify Payments payout · External bank deposit · One currency
Quick answer
App transactions first. Payout second. Bank match third.
Intuit's current Shopify Connector instructions put the work in that order. Review or confirm the individual Shopify transactions, make sure every transaction inside the payout is categorized, and resolve the account selection for every adjustment line. In Integration transactions, select Add (or Confirm) for the payout. QuickBooks then creates a Deposit for Shopify's net payout.
Only after that should you open Bank transactions. Intuit says to match the downloaded Shopify bank deposit to the connector-created Deposit and explicitly says not to manually Add the bank line. If no match appears, go back to the app transactions and payout instead of creating a second deposit or subtracting the Shopify fee again. If those steps are complete and no match appears, use Intuit's connector support rather than inventing a transaction.
This page covers a positive Shopify Payments payout arriving as an incoming bank deposit. A Withdrawn negative balance is an outgoing request and follows the connector's separate Payments account path; it is outside this guide.
Choose the right lane
Do not mix a connector workflow with a manual one.
Not using the connector
Do not imitate connector controls or invent QuickBooks entries from this page. First tie Shopify's payout activity to its displayed net payout, then give the evidence and unresolved treatment questions to the person responsible for the books.
Use the manual payout CSV guideConnector sequence
Trace one payout without creating a duplicate deposit.
- 01
Identify the payout in Shopify.
Open the specific Shopify Payments payout. Record its total, currency, status, destination account, transfer reference where available, and included transactions. Shopify says Deposited means the payout was sent, while the bank can still need 1–3 business days to process it. Match only an actually downloaded, same-currency incoming bank line; status by itself is not bank evidence. Failed means no deposit was made, and Withdrawn is outside this positive-deposit workflow.
- 02
Review the imported activity in QuickBooks.
In Integration transactions, distinguish items that are For Review, Categorized, or Excluded. Intuit says the individual transactions included in the payout must be categorized before the payout is added. A bookkeeper should approve the connector's account mappings and any missing customer, product, tax, gift card, fee, reserve, dispute, or adjustment treatment.
- 03
Resolve every “Funds in this payout” line.
The payout can contain adjustments beyond the individual sales and refunds. Intuit says each adjustment line must have an account selected before the payout is confirmed. Do not use an unsupported adjustment as a plug just to make the bank line fit.
- 04
Add (or Confirm) the payout once—in Integration transactions.
QuickBooks then creates a Deposit for the net payout, moving the related amount from Undeposited Funds or Payments to deposit into the Deposit account selected in the connector settings. The Deposit includes the related confirmed receipts, payments, expenses, and payout adjustments described by Intuit.
- 05
Use Match in the bank feed.
Find the downloaded Shopify deposit in the same bank account and match it to the Deposit created in the prior step. If QuickBooks does not suggest the match, recheck the payout's included transactions and adjustment lines. If those steps are correct, contact Intuit's connector support from the app tile. In Bank transactions, do not manually Add the downloaded line as another deposit.
Shopify source for the first step: viewing a payout's total, status, destination, reference, breakdown, and transactions. QuickBooks source for the remaining steps: Connect Shopify to QuickBooks Online.
Synthetic check
One US$900 payout should produce one US$900 bank match.
Assume the Shopify admin establishes that the invented USD activity below belongs to one payout. The values are only a trace; a real payout's own transaction types, signs, fees, and included rows control the real total.
| Synthetic activity | Signed effect on payout |
|---|---|
| Captured charge activity | + US$1,000.00 |
| Refund | − US$70.00 |
| Processing fee | − US$30.00 |
| Shopify net payout | US$900.00 |
Shopify composition tieUS$1,000.00 − US$70.00 − US$30.00 = US$900.00
Connector-created DepositUS$900.00 after the included activity is reviewed
Observed bank lineUS$900.00 in the same currency and destination account
Bank matchUS$900.00 − US$900.00 = US$0.00 variance
The US$30 fee already helped produce the US$900 net payout and is represented inside the connector workflow. Subtracting it again at the bank step would turn a passing match into a false US$30 gap.
If the downloaded US$900 line is manually added instead of matched, this synthetic file now has the connector-created US$900 Deposit and a second US$900 QuickBooks deposit transaction created from the bank feed for one observed US$900 deposit. That is a duplicate record condition—not evidence that US$1,800 arrived.
When no match appears
Locate the broken equality before changing QuickBooks.
01
Shopify activity does not tie to Shopify's payout.
Stop at the source. Confirm that you have the right payout and every included transaction type. Do not use a QuickBooks bank adjustment to hide a Shopify-side composition question.
02
The Shopify payout ties, but the QuickBooks Deposit differs.
Recheck the connector's included transaction statuses and every Funds in this payout line. Keep the proposed account treatment visible for bookkeeper approval rather than forcing a category.
03
Both records tie, but the bank line is absent or different.
Recheck payout status, currency, destination account, transfer reference, Shopify payout date, actual bank-posted date, and bank processing. A Shopify-side fee already inside the net payout does not explain a new bank variance.
Processor boundary
Keep PayPal and other processors out of the Shopify Payments payout.
Intuit's current third-party-sales guidance says that when an ecommerce sales channel and a separate payment processor are used, QuickBooks can import the sales amount without automatically recording that processor's final payout and fees. That is a separate source trail and may require a different QuickBooks workflow.
Do not blend another processor's deposit, fee, refund, or timing into a Shopify Payments payout just because the underlying orders came from Shopify. This guide and the workbook CTA below cover Shopify Payments only.
Why this page exists
A current merchant question combines three different records.
In a current QuickBooks discussion, a single-store merchant says the bank payout, fees, refunds, adjustments, gift cards, and multi-day batching do not line up with what appears in QuickBooks. The question motivates this source-routing guide. It does not establish that the connector is defective, that one accounting setup fits every store, or that the merchant will buy a workbook.
Merchant-language source: How do you currently reconcile Shopify payouts in QuickBooks?. Procedural claims on this page come from Shopify and Intuit, not from the thread's replies.
Prepare the exception before posting anything
Carry one verified Shopify net payout into bookkeeper review.
The US$9 Shopify Payout Reconciliation Workbook keeps the Shopify payout-composition check separate from the payout-to-bank check and leaves a difference visible instead of forcing a match. Use it to organize the Shopify and bank evidence before changing connector settings or asking the person responsible for QuickBooks treatment.
The ZIP contains one editable .xlsx workbook with worked synthetic examples and a checklist tab. It does not connect to Shopify, QuickBooks, or a bank; import transactions; choose accounts; create, categorize, match, or post QuickBooks entries; calculate tax; or replace a bookkeeper.
View the US$9 workbook on GumroadShopify Payments only. One currency per workbook. Requires an app that can open and recalculate Excel formulas; compatibility with Google Sheets, Apple Numbers, mobile apps, and browser-only editors is not verified.
Boundary
A source-routing guide—not accounting or connector support.
This page does not choose a chart of accounts, accounting basis, tax treatment, inventory or cost-of-goods method, gift-card liability treatment, connector setting, manual-entry method, or correction. It does not prove a Shopify, Intuit, bank, app, or bookkeeper defect. Preserve the controlling records and ask the qualified party responsible for the store's books, tax position, connector, processor, or bank to resolve questions in their scope.