How to reconcile Shopify payouts without mistaking timing for loss
To reconcile Shopify payouts, compare the transactions expected to settle with the payouts actually recorded, explain every difference and leave unresolved items clearly marked for review. Matching a sales total to a bank total is only the beginning.
Why your sales and deposits can differ
A sales report and a payout report measure different events. The order date can differ from the processing date, payout date and the date your bank posts a deposit. Refunds, processing fees, chargebacks, reserves and adjustments can further change the amount that arrives.
Shopify Payments also does not represent every possible payment method. Sales collected through a different gateway, manual payment method or another channel may settle separately. Compare each payment source with its own settlement records before combining totals.
Collect the evidence before matching totals
Start with orders and refunds, Shopify Payments payout details and the corresponding bank statement. Include external-gateway settlement reports when relevant. If you work from a CSV, check the currency, date interpretation and whether amounts are gross or already net of fees.
Use transaction or payout references wherever available, not just similar amounts. Keep the original source reports so another person can follow the reconciliation. Never put customer names, account numbers or unredacted statements into public support threads.
A practical reconciliation sequence
Work from the same reporting period and time zone. A daily comparison is useful for spotting issues, but unresolved timing items may need a wider window to settle.
- Group the expected transactions by payment gateway and currency.
- Account for refunds, fees and documented adjustments using their actual signs and dates.
- Match settled payouts to deposits using references and amounts, accounting for the bank posting date.
- Keep pending and in-transit payouts separate from confirmed deposits.
- Investigate any remaining difference and record its evidence; do not force a match just to make totals agree.
Example: explain the gap, not just the total
Illustrative example: $10,000 of payments, minus $500 of refunds and $300 of fees, produces $9,200 before any other adjustments. If only $8,000 has reached the bank, the initial difference is $1,200.
If payout details confirm that $1,000 is still pending, that explains part of the timing gap, not a loss. The remaining $200 still needs investigation. It should not be silently labeled as a fee, written off or treated as matched without supporting evidence.
Use AIOM to keep unresolved amounts visible
AIOM's Cash Truth workflow compares payout evidence with expected cash and separates reconciled differences from items needing review. Profit tracking then answers a different question: how much remains after product costs, shipping, ad spend and other recorded expenses?
Review exceptions before making budget decisions. If a difference cannot be explained from your reports, check Shopify payout details and your bank's posting records, then involve your bookkeeper or payment provider. AIOM provides analysis; it does not move funds or change your store.