First confirm that you are comparing the same cash event
A payout date, bank transaction date, and accounting date can differ. Before investigating the amount, confirm the payout ID, currency, destination bank account, and settlement status.
Comparing a Shopify payout to the wrong bank transaction creates a false variance and can lead to duplicate accounting entries.
Common causes of a real difference
- Refunds or disputes were added after an earlier report was exported
- A reserve or adjustment changed the settlement amount
- The payout contains activity from more than one sales date
- Fees were recorded separately or omitted
- A multi-currency conversion affected the bank amount
- The bank grouped or split settlement transactions
- The payout was posted twice or matched to the wrong journal
Use a variance bridge
Begin with the gross captured amount and subtract refunds, fees, disputes, and negative adjustments. Add positive adjustments and compare the calculated net amount with the Shopify payout.
Then compare the Shopify payout with the bank deposit. Keeping those two comparisons separate tells you whether the issue is inside the payout reconstruction or between Shopify and the bank.
Do not force a match
A manual balancing line can make the journal appear correct while hiding the real accounting problem. If a variance remains, document it, identify its source, and correct the mapping or missing activity.
A clean reconciliation should explain the difference, not merely eliminate it.