How To Reconcile Shopify Payouts That Dont Match Sales | Build with Bookkeep

On this page

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:

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:

This is especially common with:

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:

This creates a mismatch between:

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:

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:

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

Recommended Accounting Flow

Step 1: Record Sales Activity

Record:

Step 2: Record Shopify Clearing Activity

Use a Shopify clearing or payout account to track:

This acts as a reconciliation bridge between:

Step 3: Match Payout Deposits

When Shopify deposits funds into the bank:

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:

Best Practice for Shopify Accounting

The recommended best practice is:

This becomes increasingly important for:

How Bookkeep Helps

Bookkeep automatically separates:

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

This creates cleaner:

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