Shopify sales vs payouts: why the numbers are different

The short answer

Shopify sales and Shopify payouts are different because sales show what customers bought, while payouts show how much Shopify Payments sent to your bank. A sale belongs to the date of the order. A payout arrives later and can include transactions from several days, minus fees, refunds, disputes, reserves, and other adjustments.

That means a store can report $10,000 of sales this week without receiving a $10,000 payout this week. Some money may still be pending. Part of the sales may have been paid through PayPal or another gateway. Shopify Payments may also deduct fees or a refund for an older order before transferring the balance.

The difference is usually timing and composition, not missing money. The useful question is not “Why does today's payout fail to equal today's sales?” It is “Can I explain every transaction included in this payout and match the result to the bank?”

Sales, payments and payouts are not interchangeable

Shopify presents several financial totals because a customer order, a successful payment and a bank transfer are separate events. They can happen on different dates and can carry different amounts.

Shopify's finance documentation makes the distinction explicit. Sales reports are based on order activity. Payments reports are based on captured payment activity. The payout reconciliation report follows money through the Shopify Payments balance and is not a revenue statement.

A card payment captured tomorrow will not necessarily appear in today's payments report even if the order was placed today. A payment included in next Tuesday's payout will not appear in today's bank account either. If you compare all three as though they share one clock, the numbers will look wrong even when each report is correct.

A simple example: $1,080 of sales becomes a $932 payout

Suppose your store records $1,000 of product sales and $80 of sales tax on Friday. All customers pay through Shopify Payments. At first glance, you might expect $1,080 to reach the bank.

Shopify deducts $30 of payment-processing fees. On Saturday, you issue a $68 refund for an order sold the previous week. A $50 payment from Friday is still pending when Shopify closes the next payout. The resulting payout is $932.

Nothing in this example is missing. The $50 remains in the Shopify Payments balance and should enter a later payout when it becomes available. The refund belongs to the current payout even though the original sale appeared in last week's sales report. The fee is a cost of processing the customer payments.

The example also shows why subtracting a flat percentage from sales will not reliably predict a payout. Timing, older refunds and pending transactions can matter more than the fee rate on any one day.

The most common reasons Shopify sales and payouts differ

More than one reason can affect the same payout. A weekend payout might include three days of sales, exclude several pending card payments, deduct a refund from last month, and omit PayPal completely. Start with the payout's own transaction list rather than trying to recreate it from one sales dashboard total.

Why payout timing changes the comparison

A sale becomes available for payout only after the payment has been captured and completed the applicable pay period. Shopify then groups available transactions according to the store's payout schedule. Weekends, bank holidays, account reviews and the receiving bank can affect when the transfer arrives.

Consider a merchant with daily payouts. Orders placed late on Friday might be paid in a Monday or Tuesday payout, while Monday's payout can contain Thursday transactions. Comparing Friday sales with a Friday bank deposit pairs two groups of activity that may have little overlap.

Use the payout ID and the transactions assigned to it as the boundary. Dates are still important for month-end cut-off, but the payout membership tells you what Shopify actually transferred together.

Third-party gateways create a separate trail

Shopify's total sales can include orders paid through Shopify Payments, PayPal, manual payment methods and other gateways. A Shopify Payments payout includes only the activity that moved through Shopify Payments. Shopify's payout reconciliation report specifically excludes third-party processors and third-party payment methods.

If $5,000 of store sales includes $900 paid through PayPal, the Shopify Payments payout will not include that $900. PayPal should have its own balance, fees and bank transfer. Treating both providers as one payout hides fees and makes the bank comparison impossible.

Run the payments-by-gateway report to see where customers paid. Reconcile every provider to its own settlement and bank deposit. A manual or unpaid order can appear in sales without creating any payment-provider deposit at all.

• List every payment method used during the period.
• Confirm which methods are processed inside Shopify Payments.
• Download the settlement report from each independent provider.
• Use a separate clearing account for providers that settle separately.
• Check that all provider deposits appear in the expected bank accounts.

How to reconcile Shopify sales and payouts without guessing

Reconciliation starts from completed payouts, not from an attempt to make a daily sales card equal the bank. Work through one payout at a time until its activity explains the exact deposit.

1. Open Shopify admin and go to Finance → Payouts. Choose one completed payout and note its payout ID, currency, amount and destination bank account.
2. Open or export the payout's transactions. Identify charges, refunds, fees, disputes, reserves and adjustments included in that transfer.
3. Confirm that the transaction total, after deductions and adjustments, equals the completed payout amount.
4. Separate any third-party gateway activity. Do not expect PayPal or another independently settled provider to appear in this payout.
5. Record the approved payout breakdown in QuickBooks, using a Shopify clearing account when that is your accounting method.
6. Match the exact payout amount to the downloaded bank deposit. Do not add the deposit as new sales if the underlying sales are already recorded.
7. Investigate any remaining clearing balance as pending money, a hold, a timing difference, a duplicate or an omitted transaction.

This method does not require the sales report and payout report to show the same total. It requires each report to agree with the event it describes: orders agree with sales activity, payout detail agrees with the Shopify balance movement, and completed payouts agree with bank deposits.

Which Shopify report should you use?

Avoid switching between reports until two totals happen to look similar. Write down the question first, choose the report designed to answer it, and keep its date basis in view.

How to handle the difference at month end

At month end, some money from completed sales will not yet be in the bank. That does not mean the sales should be moved into the next month. It means Shopify or another provider still owes the business money at the reporting date.

A clearing account can show that amount in transit. Record the month's sales and approved deductions, then reconcile completed payouts to the bank. The remaining clearing balance should be supported by pending transactions, payouts still travelling to the bank, reserves, holds or a specific error being investigated.

The first payout received next month may clear part of the prior month's balance. Keep the original sales date for revenue reporting and the actual bank date for cash. Ask your accountant to approve the cut-off method, particularly when refunds, tax, multiple currencies or material holds cross the period end.

When the gap may signal a real problem

Most differences have an ordinary explanation, but a difference should never be dismissed without evidence. Investigate when the payout detail itself does not add to the stated payout, a completed payout fails to reach the bank after its expected date, or the same transaction appears more than once in your books.

• A payout is marked completed but has not reached the correct bank account.
• The bank amount differs from the completed payout amount in the same currency.
• A refund, dispute or reserve cannot be traced to a Shopify transaction.
• A payment remains pending longer than the timing shown in Shopify admin.
• The clearing balance grows every month without a list of identifiable items.
• Sales or deposits appear twice after a connector or bookkeeping method changed.
• A gateway shown in the payments report has no separate settlement record.

Preserve the payout ID, order IDs, transaction export and bank reference when raising a support request. Those identifiers are more useful than a screenshot of two headline totals.

What this means in QuickBooks Online

Do not enter the Shopify bank deposit as sales just because it is the cash you can see. Doing so records only the net amount, hides processing fees and can duplicate revenue that another entry already recorded.

A payout-based workflow records the gross components—sales, shipping, tax, refunds, fees and adjustments—then places the net amount in Shopify clearing. When the bank feed downloads the deposit, match it to the corresponding payout movement. The clearing amount and bank deposit should agree exactly.

If order-level sales already arrive in QuickBooks from Shopify or another connector, do not post the same sales again in a payout summary. Decide which system owns sales, payments, fees, refunds and deposits before importing history.

Where Vatteo fits

Vatteo does not try to make a sales dashboard equal a bank deposit. It builds the accounting trail around completed Shopify payouts: the transactions included, the deductions applied, the proposed QuickBooks entry and the matching bank amount.

The merchant or accountant approves the account mappings. Vatteo checks that the payout breakdown adds up, keeps the Shopify payout ID with the record and prevents the same payout from being posted twice. That turns a vague gap between sales and cash into a list of specific, reviewable items.