Shopify Payments and Stripe Terminal: Why You Get Two Separate Payouts (and how to reconcile them correctly)
If you run a Shopify store online and also use Stripe Terminal for in-store or point-of-sale transactions, you will have noticed something confusing: two separate deposits arriving in your bank account, from two different sources, with no obvious link between them.
This is the dual-processor problem. And it causes more reconciliation headaches than almost anything else in Shopify accounting.
Why Shopify Payments and Stripe Terminal are separate
When you process an online sale through Shopify, the payment goes through Shopify Payments — which is built on Stripe under the hood but operates as a separate entity. Shopify batches your online orders and sends you a consolidated payout every 2–3 business days.
When you process an in-store sale through Stripe Terminal, the payment goes through your Stripe account directly — not through Shopify Payments. Stripe sends you a separate payout, also every 2–3 days, but on its own schedule.
The result: two separate payout streams, arriving at different times, for transactions that happened at the same business.
The reconciliation problem
Most accounting tools — including A2X — reconcile the Shopify payout and the Stripe payout separately. That works for simple cases. But when you try to reconcile your bank statement, you see two deposits and need to match them to two different journal entries in QuickBooks or Xero.
The deeper problem is that the same customer may have placed an online order (Shopify Payments) and an in-store order (Stripe Terminal) on the same day. Your P&L needs to reflect both — but the money arrives at different times, from different sources, and your GL needs to account for both without double-counting revenue.
The clearing account solution
The correct way to handle dual-processor stores is with clearing accounts. Here is how it works:
Instead of posting directly to your bank account when revenue is recognised, you post to an intermediate clearing account. There are two clearing accounts — one for Shopify Payments, one for Stripe Terminal:
- Clearing Account — Shopify Payments (current asset)
- Clearing Account — Stripe Terminal (current asset)
When an order is placed:
DR Clearing Account — Shopify Payments £143.51
CR Revenue — Online Sales £148.00
CR Sales Tax Payable £0.00
DR Processor Fees £4.49When the Shopify Payments payout arrives in your bank:
DR Bank Account £12,904.12
CR Clearing Account — Shopify Payments £12,904.12The clearing account zeros out when the payout matches. If it does not zero, you have a discrepancy — which is exactly what you want your reconciliation to surface.
Stripe Terminal uses the same pattern with its own clearing account. The result: your bank account reconciliation shows two entries (one per payout), both matching exactly, and your clearing accounts are always zero at month end if everything reconciled.
What makes this hard to do manually
Doing this manually requires:
- Exporting Shopify payout reports
- Exporting Stripe balance transaction reports
- Matching transactions across both exports
- Building separate journal entries for each payout period
- Verifying that clearing accounts zero out
- Investigating any residual balances
For a store doing 500 orders per month across both processors, this takes a skilled bookkeeper 3–6 hours per month. Mistakes are easy to make and often are not caught until quarter-end.
How Rappel handles it automatically
Rappel implements the clearing account pattern automatically for dual-processor stores. When you connect both Shopify and Stripe, Rappel:
- Detects that you are running dual processors based on transaction metadata
- Sets up clearing accounts for each processor in your chart of accounts (or maps to existing ones)
- Reconciles each payout stream independently
- Flags any discrepancies before posting — not after
- Posts a single balanced journal entry covering both processors for each day
The payout detail page in Rappel shows the waterfall for each payout — gross amount, fees, refunds, adjustments, and net — with a confidence score for the reconciliation match.
A note on A2X
A2X is a well-regarded Shopify reconciliation tool. But it does not handle dual-processor reconciliation automatically. If you are running Shopify Payments and Stripe Terminal, you will need to reconcile the Stripe Terminal payout manually or maintain a separate Stripe integration outside A2X.
This is one of the key reasons finance teams switch to Rappel — particularly stores with physical retail alongside their online channel.
Try Rappel
Automate your dual-processor reconciliation
Connect Shopify and Stripe. Rappel sets up the clearing accounts, reconciles both payout streams, and posts balanced journal entries to QuickBooks or Xero — automatically.