Use payout, transaction, order, fee, refund, and adjustment data together instead of trying to match the payout total directly to gross order sales.
Official answer
A Shopify payout is the net result of multiple transactions, not simply the total of orders paid on one day. Reconciliation should connect payout transactions to orders, refunds, fees, disputes, and adjustments.
Useful fields include Payout ID, Payout Date, Transaction Type, Order Name, Transaction Amount, Fee, Net Amount, and Currency.
Timing differences matter. An order can be captured on one date but included in a later payout, so reconciliation should follow transaction and payout identifiers rather than relying only on order dates.
Follow-up questions
Why does a payout not match the sales total for the same date?
Payouts are based on processed transactions and payout timing, so they can include fees, refunds, adjustments, and orders captured on different dates.
Which identifier is best for reconciliation?
Use payout and transaction identifiers first, then connect those records back to the related order. Date-only matching is less reliable.