Why a payout is not sales revenue, and how to reconcile it with orders
If you are deciding whether to reconcile at payout level or order level, the short answer is this: use the payout view for cash movement and the order view for sales activity, then connect the two with the right report fields and IDs so you do not count the same amount twice.
TaxRouter editorial team
Payouts show settlement activity, not just sales
A payout is not the same thing as sales revenue because the payout view can include more than completed customer charges. Shopify says payout details may include charges, refunds, adjustments, fees, and reserves, which makes the payout view a cash-settlement view rather than a pure sales-revenue view. That distinction matters when you are comparing a bank deposit to your order records.
For that reason, a payout total can differ from the day’s order total even when the underlying sales activity is correct. A settlement view is designed to show what moved into or out of the payment balance, while the order view stays closer to customer-facing selling activity.
Sources: [1]
Choose the level that matches the question you are answering
If the question is whether a specific bank deposit matches what Shopify or PayPal says should have been paid out, reconcile at payout or settlement level. Shopify says its Payouts page is for details of a specific payout or bank deposit, while the activity report is intended for period-level review, month-end reconciliation, PDF record keeping, and accountant handoff.
If the question is whether the underlying sales, refunds, or disputes are recorded correctly, move to the order level and trace individual transactions. In practice, many finance teams use both views: settlement-level reconciliation to tie cash to the bank, then order-level review to explain differences in timing, refunds, fees, or reserve movements. That is especially useful when the operational question is not just 'what was paid out?' but 'which orders, refunds, and adjustments make up this payout?'.
The report fields that help you avoid double-counting
Shopify recommends connecting order activity, payout activity, and refund activity with order IDs, payout IDs, balance transaction IDs, transaction types, and refund transaction IDs. These fields give you a bridge between the sale recorded in the order system and the cash movement shown in the payout view.
The practical value is simple: the same event can appear in more than one report, but it should not be counted more than once in your revenue or cash reconciliation logic. Order IDs identify the sale, payout IDs identify the transfer, and transaction IDs help you match a specific movement or reversal to the right record.
When you review a report extract, pay attention to the transaction type as well. A charge, refund, or other movement should not be treated as the same thing as a payout line. Using the IDs together makes it easier to trace one order through sale, payout, and refund activity without inflating revenue or missing a reversal.
- Use order IDs to anchor the original sale.
- Use payout IDs to tie lines to a specific bank deposit or payout.
- Use balance transaction IDs and refund transaction IDs to match movements and reversals.
- Use transaction types to separate charges, refunds, and payout-related movements.
How refunds change the payout picture
Refunds can change which level is easiest to reconcile. Shopify says refunds can reduce the next payout or create a negative balance that must be covered. That means a refund may show up in a later payout rather than in the same payout as the original sale.
For reconciliation, this is why a payout total on its own can be misleading if you are trying to measure revenue by order date. A refund can appear as an offset in a later settlement, while the original sale stays tied to the order date. If you only look at one payout line, you may miss the connection between the sale and its reversal.
A hypothetical example helps: if an order is paid on Monday and refunded on Wednesday, the bank deposit you review on Friday may reflect both the original payout and the later deduction. In that case, the order-level trail is what explains the change, while the payout-level view shows the cash effect.
What to use for Shopify, PayPal, and Stripe-style transaction analysis
Shopify’s activity report and payout details are built for different tasks, so it is usually cleaner to reconcile the activity report to your accounting period and the payout page to the bank deposit. PayPal uses a similar split: its Balance report is designed to help merchants reconcile sales, refunds, disputes, fees, and withdrawals against end-of-day balances, and its Settlement report summarizes debits, credits, and beginning and ending balances for each currency.
If your team also works with Stripe-style data, balance transactions can include transaction types such as charge, refund, payout, reserve hold and release, and fee-related movements. That reinforces the same core principle: not every movement in a payment balance is revenue, and not every revenue event belongs in the payout line.
The cleanest reconciliation method is the one that matches the question you need to answer. For bank reconciliation, start with payout or settlement reports. For sales integrity, start with orders and then trace the IDs into the payment reports. For month-end review and handoff, use the provider report designed for period-level review rather than trying to force a bank deposit report to explain every order by itself.
This article provides general information and is not tax or legal advice.