How to Reconcile Multiple Shopify Payment Gateways

Define the payment channels

A Shopify store can show order activity across Shopify Payments and other payment providers or methods. The order or sales report answers what sales activity Shopify recorded under its report definitions; each gateway's payout or settlement report answers how that channel moved money. Those are related datasets, not interchangeable totals.

Begin with a channel map: provider, payout currency, settlement account, report owner, and the identifier used to match a transaction. Include manual or offline methods only if they are part of your store process, and label them separately. This prevents a finance team from comparing every bank deposit to the full Shopify sales report or counting a gateway deposit twice.

Know what Shopify Payments includes

Shopify says the Shopify Payments activity report covers movement through the Shopify Payments balance. It can show charges, refunds, fees, disputes, reserves or holds, and payouts for the selected period and payout currency. The same documentation says it does not include Shopify billing fees, third-party payment processors, or third-party payment methods such as Authorize.net or Afterpay.

Therefore, do not use the Shopify Payments activity report as a consolidated multi-gateway cash report. Pull the comparable activity or settlement detail from every other provider, preserve each provider's currency, and reconcile those channels independently before comparing the combined result to the bank.

A repeatable multi-gateway workflow

First, choose a period boundary and capture the order or sales report. Second, split transactions by payment channel and currency. Third, reconcile each channel's captured payments, refunds, fees, disputes, reserves or holds, and payouts to its clearing balance. Finally, match deposits to the correct settlement account and document timing items such as a payout initiated near month-end.

Use stable identifiers whenever possible: order number, gateway transaction ID, payout ID, and bank reference. Where one payout contains many orders, retain the gateway detail behind the summary. Where a refund or dispute settles later than the original order, link it to the original transaction without rewriting the original sales record.

For a Xero or QBO team, separate clearing accounts by provider can make ownership visible. That is generic workflow guidance, not a prescribed chart of accounts or tax treatment. The adviser should decide whether the store's reporting policy recognizes a sale, fee, refund, or gateway adjustment at a particular stage.

• Do not net Shopify Payments fees into a third-party gateway's deposit.
• Do not combine currencies just because deposits share a bank statement.
• Do not post a bank deposit as new revenue when it clears a payment balance.

Fictional simplified example

This is a fictional simplified example, not a quote of any provider's fees. Assume a sales report shows $8,000 of order or sales activity for the review period. Channel transaction detail identifies $6,000 captured through Shopify Payments and $2,000 through a third-party gateway. The Shopify Payments detail shows a $180 fee, a $60 refund, and a $5,760 payout. The arithmetic for that channel is $6,000 - $180 - $60 = $5,760.

The third-party report separately shows a $70 fee, a $100 refund, and a $1,830 payout: $2,000 - $70 - $100 = $1,830. Combined payouts are $5,760 + $1,830 = $7,590, while combined reviewed fees and refunds are $180 + $70 + $60 + $100 = $410. The channel evidence explains the $8,000 captured activity without pretending that one provider's report includes the other. A bank statement match still depends on each provider's payout date and settlement account.

Investigate the mismatch by layer

If the combined sales report and combined deposits differ, test one layer at a time: missing channel, capture versus order timing, payout currency, refunds, disputes, reserves or holds, provider fees, and bank processing. Shopify documents that capture timestamps use UTC and that Friday through Sunday captures can be grouped; payout timing and bank arrival can therefore cross a reporting cutoff.

Keep an exceptions list with the amount, channel, identifier, first date seen, evidence checked, and next owner. A reviewer should be able to tell whether an item is still in a provider balance, belongs to another gateway, or needs a source correction. This is more useful than a single unexplained “gateway variance” line.

Sources and further reading

Read Shopify's Shopify Payments activity report for scope and category definitions. Read Understanding Shopify Payments payout timing for capture, settlement, weekend grouping, and bank-processing boundaries.

Payout Explainer is coming soon

Payout Explainer is coming soon. Join the waitlist for a review-before-posting way to organize multi-gateway payout explanations. It will not provide tax or FX advice, and no current upload or connect availability is implied.