How to reconcile Shopify Payments, PayPal and other gateways

The short answer

Do not reconcile every Shopify order to one bank deposit. Shopify can report sales paid through Shopify Payments, PayPal, Klarna, manual methods and other gateways, but those providers do not necessarily send one combined payout.

Treat every provider that controls and settles money as a separate route. Shopify Payments activity goes through a Shopify Payments clearing account. PayPal activity goes through a PayPal clearing account. Another gateway gets its own account when it holds funds, deducts fees and sends separate deposits.

At month end, each route should tell a complete story: customer payments entered the provider balance, fees and refunds changed it, deposits left it, and the remaining clearing balance agrees with money still held or in transit. Vatteo makes this separation part of the close, so one gateway cannot quietly hide a difference in another.

Why the Shopify total does not identify the deposit

Shopify's sales reports answer what the store sold. Its payments reports answer how customers paid. Shopify Payments payout reports answer how funds moved through the Shopify Payments balance. Those are related questions, but they are not the same total.

Shopify states that its payout reconciliation report covers Shopify Payments balance activity and excludes third-party processors and payment methods. A PayPal-funded order can appear in Shopify sales and payment reporting without appearing in any Shopify Payments payout.

That is why a merchant can see $42,000 of monthly Shopify sales, $35,000 of Shopify Payments activity and $7,000 paid through PayPal or other methods. Nothing is necessarily missing. The reports are describing different parts of the same month.

Start with a gateway map

Before posting anything, list every payment method used during the period. Shopify's payments-by-gateway report is a practical starting point because it groups captured payments by gateway. Compare that list with the providers enabled under Settings > Payments and with deposits visible in the bank.

Then decide which methods settle independently. Apple Pay or Shop Pay can be customer-facing methods while the underlying money still settles through Shopify Payments. PayPal Express normally follows PayPal's own balance and transfer process. A manual bank transfer may never touch a payment processor.

Save this gateway map with the accounting policy and revisit it whenever checkout settings change. A newly activated provider can create a new clearing route before the finance team notices a different bank reference.

Do not create a new account merely because the checkout shows a different brand. Create a separate clearing route when the provider holds funds, deducts its own charges, or sends its own bank deposits.

Use a separate clearing account for each settling provider

A clearing account represents money the store has collected through a provider but has not yet fully explained as fees, refunds, deposits or an ending provider balance. QuickBooks describes a clearing account as a temporary place for moving amounts between accounts.

For a Shopify store, useful names are Shopify Payments Clearing, PayPal Clearing and Gateway Name Clearing. Separate accounts let the merchant answer a simple question: how much does each provider still owe, and why?

Combining providers can make the total appear correct by accident. A $600 missing PayPal transfer can be hidden by $600 of Shopify Payments activity that belongs to next week's payout. The combined balance is zero, but both provider reconciliations are wrong.

Worked example: one week, three payment routes

A Shopify store records $20,000 of captured customer payments during the week. The payments-by-gateway report shows $15,200 through Shopify Payments, $4,300 through PayPal and $500 by manual bank transfer.

Shopify Payments deducts $460 of fees and $240 of refunds, then sends a $14,500 payout. PayPal deducts $160 of fees and $140 of refunds, then transfers $3,600 to the bank. The remaining $400 stays in the PayPal balance at week end. The $500 manual transfer arrives directly in the bank.

The $18,600 in bank deposits is not meant to equal the $20,000 captured payment total. The $1,000 of provider fees and refunds plus the $400 PayPal balance explain the difference. Each amount has one source and one owner.

Reconcile Shopify Payments first

1. Open Finance > Payouts and select a completed payout, or export payout transactions for the period.
2. Confirm captured charges, refunds, disputes, fees, reserves and adjustments included in the Shopify Payments balance.
3. Check that the net payout equals the matching bank deposit, allowing for bank posting time and currency.
4. Post or review one balanced payout summary that moves the net amount from Shopify Payments clearing to the bank.
5. Use the payout reconciliation report for the period to explain the starting balance, activity, total payouts and ending balance.
6. Keep third-party gateway payments outside this calculation because Shopify does not include them in the report.

The payout date controls the bank movement; it does not redefine when the underlying sale occurred. Keep revenue, tax and the provider settlement connected without forcing all three onto one date or one number.

Reconcile PayPal from PayPal evidence

Use the PayPal business account's transaction or settlement reports for the same period and currency. The report should show customer receipts, refunds, fees, disputes, withdrawals or transfers, and the opening and closing PayPal balance.

Match PayPal bank transfers to the actual bank deposits. A PayPal transaction date and the bank arrival date can differ, so preserve both. If the merchant spends from the PayPal balance or pays a supplier directly, that movement also needs an account and evidence; it is not a missing bank deposit.

Compare Shopify's PayPal-tagged payments with PayPal's captured receipts, but expect legitimate scope differences. PayPal may include activity unrelated to Shopify, while timing, currency conversion and refunds can place events in different periods. Investigate by transaction ID rather than forcing the two report totals to agree.

Handle other gateways with the same pattern

For Klarna, Authorize.net, Amazon Pay or another gateway, obtain the provider's settlement report and identify the bank deposits it produced. Capture provider fees, refunds, holds, reserves and any balance that remains after the final settlement in the period.

Some payment methods route through Shopify Payments even when the customer sees another brand. Others settle entirely outside Shopify. Check the current provider arrangement instead of relying on the name shown on an order.

If the provider cannot produce a usable settlement report, keep the gateway as a named close exception. A merchant should not post a guessed fee or clear the balance to sales merely to finish the month.

Refunds and disputes must stay with their provider

A refund reduces the provider balance that funded it. A Shopify Payments refund belongs in the Shopify Payments reconciliation; a PayPal refund belongs in PayPal. The order refund can affect revenue and tax, but the cash route remains provider-specific.

Disputes can create holds, chargebacks, fees and later reversals. Record the provider activity shown in the settlement evidence and keep the case ID. Do not use a PayPal dispute to explain a Shopify Payments shortage, even when both relate to orders in the same Shopify store.

Cross-period refunds are normal. Preserve the original order reference and record the provider movement in the period it occurred under the approved accounting policy.

Treat currency as another settlement boundary

A provider can maintain balances and send payouts in several currencies. Reconcile each provider and payout currency separately before translating balances into the QuickBooks home currency.

A USD PayPal balance, a GBP PayPal balance and a USD Shopify Payments payout are three separate checks. Combining them before reconciliation can turn an ordinary exchange difference into an unexplained gateway variance.

Keep the provider's original-currency report, the bank amount, the exchange rate or conversion evidence, and the resulting gain or loss. BLOG-021 covers the full multi-currency workflow.

Match bank-feed deposits only after the settlement is complete

When the provider summary is balanced, match its net deposit to the bank-feed transaction in QuickBooks. Do not add the bank-feed deposit as new sales if the underlying sale and clearing movement are already recorded.

A match should preserve the provider name, payout or transfer ID, currency and settlement period. If several provider transfers are batched into one bank deposit, retain a schedule that adds to the bank amount. If one transfer arrives as several deposits, retain the split.

QuickBooks' matching workflow can connect an existing recorded transaction with downloaded bank activity. Review the match rather than accepting a suggested category that sends every e-commerce deposit to Sales.

What to do when the numbers still do not agree

• Confirm the same date range, timezone and currency are used.
• Check whether the Shopify report uses order, payment, payout or bank dates.
• Look for pending or held funds at the provider.
• Check refunds, disputes, reserves and fee adjustments posted after the sale.
• Find provider transfers used for non-Shopify activity or direct spending.
• Confirm a payout was not imported twice or matched to the wrong deposit.
• Check whether a customer-facing wallet settles through another processor.
• Trace the remaining difference by provider transaction ID.

How Vatteo keeps gateway reconciliation clear

Vatteo is built for Shopify merchants who want a controlled QuickBooks close, not a pile of unlabelled deposits. It reconstructs Shopify Payments payouts from their own evidence and keeps externally settled gateway activity outside that journal.

The payments-by-gateway view exposes what was paid outside Shopify Payments. Missing PayPal or other provider evidence becomes a named exception with an owner instead of a balancing number hidden in Shopify sales or fees.

Mappings, payout review, variances, COGS, tax checks and close sign-off stay together. The merchant can see which gateways are complete, which balances remain in transit, and which evidence is still required before posting to QuickBooks.

Month-end gateway checklist

• Every Shopify payment method is mapped to its underlying settlement provider.
• Each independently settling provider has its own clearing account or documented route.
• Shopify Payments payout totals agree with Shopify evidence and bank deposits.
• PayPal and other providers agree with their own reports and bank transfers.
• Fees, refunds, disputes, reserves and direct provider spending are recorded once.
• Ending provider balances agree by currency with money still held or in transit.
• Bank-feed deposits match existing settlements rather than creating duplicate sales.
• Every remaining variance has a provider transaction ID, owner and next action.