Why Shopify payouts do not match the bank

The comparison that cannot work

Comparing a day's order total to a bank deposit assumes those two figures describe the same population. They do not. A deposit covers orders from a settlement window that rarely matches a calendar day, net of fees deducted per transaction, reduced by refunds that may relate to entirely different orders.

Reconstruct the deposit instead

The reliable method is to build the expected deposit from its components and then compare:

1. Identify the orders in the payout window.
2. Subtract processing fees attributed to those orders.
3. Subtract refunds deducted from this payout, regardless of when the original sale occurred.
4. Subtract any dispute activity charged against this payout.
5. Compare the result to the bank credit.

If the residual is inside a small tolerance, the payout is explained. If not, the difference is a genuine exception worth investigating, and it will usually fall into one of a small number of recurring categories.

A payout can arrive as two bank lines

Worth knowing before assuming a mismatch: a single payout may reach the bank as more than one credit. A reconciliation that assumes one payout equals one bank line will report a false break, and false breaks cost more trust than unmatched items, because they train people to ignore the output.

Where this gets genuinely hard

Single-channel Shopify Payments is the easy case. Difficulty scales when Shopify Payments runs alongside PayPal, when wholesale invoices settle into the same account, or when two currencies are involved. Each stream reconciles on its own logic and the clearing account becomes a composite.

When standard software is enough

One store, one processor, a configured connector, and a clearing account that resolves each month. Nothing here needs building.

When custom automation may be justified

When the reconstruction above is performed by hand every month, across more than one settlement stream, and the same categories of exception recur. That is a rule, executed manually.