Skip to main content

How To Reconcile Shopify Payouts That Don't Match Sales

One of the most common questions from Shopify merchants and accountants is:

“Why doesn’t my Shopify payout match my sales?”

The short answer is that Shopify payouts are cash movements, while Shopify sales reports are operational sales activity. These two numbers are rarely expected to match exactly for a given day.

Understanding the difference is critical for accurate ecommerce accounting and reconciliation.

Why Shopify Payouts Do Not Match Sales​

A Shopify payout is the net cash transferred from Shopify Payments to your bank account. A payout can include transactions from multiple order dates and many different financial events.

Meanwhile, Shopify sales reports are based on order activity and sales timing.

Additionally, you may have multiple payment methods such as PayPal, Affirm, etc. Shopify payouts only capture payouts related to orders processed through Shopify, e.g., Shopify Payments, Shop Cash, and Shop Pay Installments.

This creates timing and classification differences between:

  • Sales

  • Refunds

  • Fees

  • Taxes collected and withheld

  • Adjustments

  • Campaign billing

  • Managed Markets adjustments

  • Chargebacks

  • Duties

As a result:

Your payout amount is usually not equal to your daily sales total.

Common Reasons Shopify Payouts Don’t Match​

1. Orders Are Included in Different Payout Periods​

An order placed today may not be paid out until:

  • tomorrow

  • several days later

  • or the next payout cycle

This is especially common with:

  • weekends

  • bank holidays

  • international payments

In some cases, payouts may also be delayed until the order is fulfilled.

Because of this, payouts often include sales from multiple days.

2. Loan Repayments Reduce Payouts​

In some cases, payouts may be reduced due to loan repayment or advance repayment activity rather than sales activity.

If a merchant has a financing product enabled, repayments are often automatically deducted from future payouts.

Example:

  • Loan advance received earlier in the month

  • Daily or periodic repayment begins

  • Shopify deducts repayment amounts from subsequent payouts

This creates a mismatch between:

  • current payout cash

  • underlying sales activity

As a result, part of the payout reduction is driven by loan repayment obligations rather than order-level transactions.

3. Shopify Fees Are Deducted​

Payouts are net of:

  • processing fees

  • campaign fees

  • dispute fees

  • adjustment fees

Your sales reports typically show gross sales, while payouts reflect net cash after deductions.

4. Chargebacks and Disputes​

Disputes and chargebacks can reduce payouts independently of the original sale date.

This creates additional reconciliation timing differences.

5. Marketplace Facilitator Tax Withholding​

If you sell through Shopify's marketplaces, taxes may be withheld before payout.

6. Multi-Currency and FX Adjustments​

International orders may create:

  • foreign exchange gains/losses

  • currency conversion timing differences

  • settlement adjustments

This is common when using Shopify Managed Markets.

The Correct Way to Reconcile Shopify​

The most accurate approach is to separate:

  1. Sales activity

  2. Payment processor clearing activity

  3. Actual bank deposits

Step 1: Record Sales Activity​

Record:

  • gross sales

  • discounts

  • refunds

  • taxes

  • gift cards

  • shipping

  • liabilities

Step 2: Record Shopify Clearing Activity​

Use a Shopify clearing or payout account to track:

  • amounts owed by Shopify

  • pending payouts

  • refunds

  • fees

This acts as a reconciliation bridge between:

  • operational sales

  • bank cash deposits

Step 3: Match Payout Deposits​

When Shopify deposits funds into the bank:

  • reduce the clearing account

  • reconcile to the payout statement

This creates clean bank reconciliation and accurate accounting.

Why Direct Cash Accounting Creates Problems​

Many merchants attempt to book revenue directly from payout deposits.

This often causes:

  • incorrect revenue timing

  • refund mismatches

  • fee confusion

  • sales tax inaccuracies

  • reconciliation issues

  • inaccurate month-end financials

Best Practice for Shopify Accounting​

The recommended best practice is:

  • Separate sales from cash timing

  • Use clearing accounts

  • Reconcile payouts independently

  • Track pending balances

  • Automate reconciliation where possible

This becomes increasingly important for:

  • high-volume merchants

  • multi-channel sellers

  • international sellers

  • accrual accounting

How Bookkeep Helps​

Bookkeep automatically separates:

  • Shopify sales activity

  • payout clearing activity

  • fees

  • refunds

  • withheld taxes

  • pending balances

This allows merchants and accountants to properly reconcile Shopify payouts without manually rebuilding payout logic in spreadsheets.

This creates cleaner:

  • month-end closes

  • deferred revenue tracking

  • refund accounting

  • financial reporting

Please reach out to support@bookkeep.com if you have any questions.