Shopify Payments + PayPal Express Checkout + QuickBooks Online
One Shopify order list can feed more than one payment processor. A Shopify Payments payout and a PayPal payout are separate cash trails, even when both sales began in the same Shopify store. Keep a PayPal Wallet row in the Shopify Payments lane when the actual payout proves it belongs there, as can occur in France and the United States.
Provider routing · Evidence handoff · No journal-entry instructions
Quick answer
If Shopify Payments processed the payment, follow the Shopify payout through Shopify's payout record. If the Shopify Connector is configured for this store and QuickBooks company, use its documented payout-review and bank-match sequence; otherwise use the Shopify payout evidence and manual CSV workflow. If PayPal Express Checkout processed the payment and PayPal paid the merchant, Shopify says the third-party-gateway payout information is not available in the Shopify admin.
Intuit also states a specific current limitation: the PayPal Connector by QuickBooks cannot import PayPal transactions originating from Shopify. A Shopify-originated transaction paid out by PayPal that is absent from that connector is therefore not, by itself, evidence that the money is missing. It needs the PayPal-side transaction and payout or transfer trail, bank evidence only if the funds reached a bank, and a check for any record already present in QuickBooks through another route.
Do not route by the word PayPal alone. Shopify's current payment-method table says PayPal Express Checkout is paid by PayPal, while PayPal Wallet is paid through Shopify Payments only in France and the United States. The actual processor and payout record control the lane.
Sources: Shopify's current payment-provider and payout routing and Intuit's current PayPal Connector limitation.
Two payout lanes
01
Start with the specific Shopify Payments payout and its included transactions. If the Shopify Connector is configured for this store and QuickBooks company, review the imported activity, confirm the payout in Integration transactions, and match the connector-created Deposit to the downloaded bank line. Otherwise, use the Shopify payout evidence and manual CSV workflow.
Use the Shopify-to-QBO payout guide02
Start with the PayPal transaction and PayPal's own payout or transfer evidence. Record whether the funds remained in the PayPal balance or were transferred; only a transfer that reached a bank should have a matching bank line. Do not expect PayPal-paid cash to appear inside a Shopify Payments payout, and do not assume Intuit's PayPal Connector imported a Shopify-originated PayPal transaction.
Source map
| Question | Shopify Payments | PayPal Express Checkout paid by PayPal |
|---|---|---|
| Who processed the payment? | Shopify Payments | PayPal |
| Where is the payout evidence? | Shopify Finance > Payouts | The merchant's PayPal records |
| Can Shopify show the provider payout? | Yes, for Shopify Payments payouts | No, not for a third-party-gateway payout |
| What current connector boundary matters? | The Shopify Connector has a payout review and bank-match sequence | Intuit says Shopify-originated PayPal transactions cannot be imported by its PayPal Connector |
| What is the bank-facing anchor? | That Shopify payout's net amount and bank deposit | The PayPal transaction plus payout, transfer, and destination evidence; a bank line only if funds reached the bank |
QuickBooks sources: Shopify Connector workflow, PayPal Connector scope and limitation, and Intuit's separate third-party sales and fees workflow. This page does not select or reproduce a posting method from those workflows.
Routing workflow
For the exact Shopify order or payment in question, record the payment provider, amount, currency, date, and available transaction identifier from the store's own evidence. Do not assign it to Shopify Payments merely because the sale began in Shopify.
For Shopify Payments, identify the specific Shopify payout and included activity. For a payment paid out by PayPal, retain the PayPal transaction and payout or transfer evidence. Keep each currency and destination account visible.
Check Integration transactions when a connector is configured, Bank transactions for the expected destination, date, currency, and amount, and the manual or import batch used for that provider. Compare any preserved provider transaction ID plus gross, net, currency, and date. Stop without adding a record if one event appears through more than one route or the evidence does not prove which QuickBooks record represents it.
Keep the Shopify payout and any PayPal payout or transfer as separate cash checks. Use QuickBooks' specific Match action only for a connector-created Deposit supported by its documented workflow. A combined period summary can help explain overall cash, but it is not one payout and should not erase provider, timing, currency, fee, refund, or dispute differences.
Preserve the source, provider payout, bank line, existing QuickBooks records, and exact missing or duplicate condition. The qualified person responsible for the books chooses the account mapping, transaction type, correction, and period.
Synthetic two-provider trace
The invented values below illustrate routing only. They are not provider prices, a universal fee formula, or a QuickBooks posting instruction.
| Synthetic record | Provider lane | Bank-facing result |
|---|---|---|
| Order SP-101: US$120.00 charge, US$4.00 invented fee | Shopify Payments payout S-1 | US$116.00 Shopify deposit |
| Order PP-202: US$80.00 charge, US$2.50 invented fee | PayPal Express Checkout payout P-1 | US$77.50 PayPal deposit |
Shopify laneUS$120.00 − US$4.00 = US$116.00
PayPal laneUS$80.00 − US$2.50 = US$77.50
Two observed depositsUS$116.00 + US$77.50 = US$193.50
Period summary differenceUS$200.00 − US$193.50 = US$6.50
The US$6.50 summary difference is the two invented provider fees in this deliberately complete example. It does not turn S-1 and P-1 into one payout. If the transaction paid out by PayPal is forced into S-1, the Shopify lane gains US$80 of activity that never belonged to that payout. If a new QuickBooks record is added without checking existing imports, the same cash can also be represented twice.
What “missing” can mean
01
A PayPal-paid order is being searched for inside a Shopify Payments payout, or a Shopify Payments deposit is being treated as PayPal cash.
02
Intuit's PayPal Connector does not import the Shopify-originated PayPal transaction. That explains a source gap, not a missing bank deposit or a completed QuickBooks correction.
03
Another integration, bank feed, prior import, or manual entry may already represent the event. Check before adding anything new.
04
The transaction exists, but its provider payout, transfer, destination, currency, timing, or bank evidence is incomplete. Resolve that source trail before changing QuickBooks.
05
Source evidence is complete, but the account mapping, transaction type, correction, or reporting period is disputed. That is a bookkeeper or accountant decision, not a connector guess.
06
Store sales, two provider payouts, and bank deposits are being compared across different cutoffs or currencies. Split them before interpreting the remainder.
Why this split matters
In one public Shopify discussion, a merchant compared store sales with combined Shopify and PayPal payouts and still had a large unexplained difference after checking payment records. A separate current discussion asks for a single QuickBooks workflow across Shopify and another processor. Those are real routing pains, but neither discussion proves that one connector, one payout, or one spreadsheet should absorb every provider.
Pain sources: merchant comparison of sales with Shopify and PayPal payouts and current multi-processor QuickBooks reconciliation discussion. These sources establish problem language only, not product demand or technical instructions.
Shopify Payments lane only
The US$9 Shopify Payout Reconciliation Workbook keeps one verified Shopify Payments payout-composition check separate from its payout-to-bank check and leaves a difference visible for review. Start a separate workbook copy for each currency.
Keep rows paid out by PayPal Express Checkout, Stripe, or another third-party processor outside this Shopify Payments workbook. Retain a PayPal Wallet row when the actual payout evidence proves it belongs to a Shopify Payments payout, as can occur in France and the United States. The ZIP contains one editable .xlsx workbook with worked synthetic examples and a checklist tab. It does not connect to Shopify, QuickBooks, PayPal, 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
This page does not choose a chart of accounts, accounting basis, transaction type, tax treatment, journal entry, connector setting, import method, correction, or reporting period. It does not prove a Shopify, PayPal, Intuit, bank, app, or bookkeeper defect. Preserve the controlling source records and ask the qualified party responsible for the store's books, processor, connector, or bank to resolve the decision in their scope.