Shopify payouts vs. sales: reconciling to bank deposits

Published on Beamarc: September 30, 2026.

In this illustrative example, gross order value before discounts is $47,832, while bank deposits total $42,156. The $5,676 difference needs to be explained.

The difference can include discounts, fees, refunds, disputes, reserves and payout timing. A reconciliation identifies the actual reasons using the underlying reports.

A difference may reflect settlement mechanics, report definitions or a posting error. Reconcile the details before drawing a conclusion. Shopify Payments (and/or any third‑party providers you enable) collects customer payments, nets deductions, and deposits the remainder on a schedule. “Sales” and “cash” move together, but they’re not the same metric.

If you’re running a multi-channel ecommerce operation, this compounds fast. Shopify is just one leg. But get Shopify right and you’ve got a repeatable model for the rest.

Why Shopify sales don’t match bank deposits

Start by identifying the following common differences, then investigate any remaining amount.

• Processing fees. Shopify Payments fees are deducted before funds hit your bank. Rates vary by plan, region, and card type. Don’t hardcode a percent. Tie to payout detail.
• Refunds. Refunds are generally deducted from future Shopify Payments payouts. If future payouts can’t cover refunds, Shopify can debit your bank account, and your Shopify Payments balance can go negative until repaid by future payouts.
• A chargeback can remove the disputed funds and a fee from the processor balance. When a dispute is resolved, record the actual recovery and fee adjustment shown in the account; treatment and timing depend on provider terms and location.
• Holds / reserves / risk controls. Shopify can impose custom payout schedules, implement reserves, or place holds on payouts/charges during review. These reduce near-term deposits without changing what the sales dashboards show.
• Payout timing depends on the account’s settlement period, schedule, bank processing, weekends and holds. Use the expected dates shown in your payout records rather than a fixed assumption.
• Payment-method routing. Shopify Payments payouts cover payments processed through Shopify Payments (including Shop Pay and wallets processed through it). Third‑party providers (for example PayPal) can settle separately with different fees, reports, and deposit patterns.
• Definition mismatch (tax/shipping). Shopify has multiple “sales” definitions. Your bridge needs to start from the same basis your GL uses (commonly net of sales tax collected on behalf of states).

Several differences can affect the same month. Retain enough detail to explain each one without treating the combined gap as an expense.

The clearing account model

A processor clearing account or a suitably supported existing workflow connects sales activity to payouts. The account name matters less than the ability to explain every remaining balance.

The workflow looks like this:

• Apply the revenue-recognition requirements. Under U.S. GAAP, recognize revenue when or as the customer obtains control of the promised goods or services. Assess the contract, shipping terms and any acceptance conditions; a payment or payout date alone does not establish revenue.
• Post settlement activity (fees, refunds, disputes, adjustments, holds/reserves) so the clearing balance stays explainable.
• When a payout deposit hits your bank, clear the related clearing activity so the remaining balance equals only what’s truly pending (plus documented holds/reserves).

At month-end, the clearing account should reconcile to pending/unpaid payouts plus any documented hold/reserve/timing items. If it doesn’t, something is mis-mapped or missing.

If you want this set up cleanly across Shopify + other processors, see Shopify accounting.

The monthly bridge (sales → expected deposits)

Every month, build a bridge: start with your GL-aligned sales basis and end with what deposited. The bridge explains every dollar in between.

Illustrative payout bridge

• Gross order value before discounts. Amount: $47,832.00
• Less: discounts. Amount: ($2,145.00)
• Customer payments captured after discounts, before refunds. Subtotal: $45,687.00
• Less: refunds. Amount: ($1,823.00)
• Less: processing fees. Amount: ($1,412.67)
• Less: dispute/chargeback losses + fees (if applicable). Amount: ($195.00)
• Less: reserve/holdback (if applicable). Amount: ($950.00)
• Add: reserve released (if applicable). Amount: $420.00
• Timing: prior-period activity paid this month (clearing decrease). Amount: $1,242.00
• Timing: current-period activity paid next month (clearing increase). Amount: ($812.33)
• Expected bank deposits. Amount: $42,156.00
• Actual bank deposits (per statement). Amount: $42,156.00
• Variance. Amount: $0.00

Your bridge may also include sales tax collected (liability), shipping, FX/multi-currency payouts, payout adjustments, and third-party providers (PayPal/Amazon Pay/etc.).

The goal is not “never have reconciling items.” The goal is: every reconciling item is identified, labeled, and supported.

Month-end checklist

• Pull Shopify payouts (deposit amounts and dates) for the period
• Pull bank statement for the same period
• Match each payout to a bank deposit (date + amount)
• Pull payout transaction detail and tie fees/refunds/disputes/adjustments/holds
• Confirm whether Shopify debited the bank for refunds/negative balances (and map those entries)
• Reconcile clearing: balance equals pending/unpaid payouts (+ documented holds/reserves/timing)
• Build the bridge: sales → expected deposits → actual deposits
• Document variances (rounding, timing, adjustments, provider routing)
• Reconcile any third-party providers separately (PayPal/Amazon Pay/other gateways)
• Verify sales tax liability mapping (if applicable to your setup)
• File workpapers and sign off

A repeatable close identifies missing records and mapping errors while the transactions are still easy to trace.

Common failure modes

Using Undeposited Funds as an unsupported holding account

Undeposited Funds (or your clearing account) should be explainable and actively reconciled. If it has a permanent mystery balance, something is mis-mapped or missing.

Booking deposits as revenue

Posting a payout as new revenue can hide deductions or duplicate a sale already recorded by an integration.

Ignoring negative balances / bank debits

Refunds and disputes can create negative Shopify Payments balances or trigger bank debits. If you only reconcile “payout deposits” and ignore debits, your clearing will never tie.

Ignoring provider routing

Some Shopify checkout payments don’t settle through Shopify Payments depending on your configuration. If you don’t reconcile those providers separately, you’ll have Shopify sales that never trace cleanly to cash.

Historical differences may require a separate cleanup before the recurring process can produce reliable balances.

Completion checks

Bridge ties to zero. Sales adjusted for fees/refunds/disputes/holds/timing equals deposits (including any bank debits tied to Shopify Payments activity).

Clearing reconciles. Clearing balance ties to pending/unpaid payouts (+ documented hold/reserve/timing items).

Workpapers exist. Bridge, bank match, payout detail support, and notes, saved and repeatable.

Keep the payout bridge distinct from revenue

The revenue discussion assumes a merchant acting as principal for its goods. Under U.S. GAAP, the assessment turns on whether the merchant controls the specified goods or services before they transfer to the customer. A principal reports the revenue for those goods or services; an agent reports its fee or commission. Gross-versus-net presentation is not a policy choice and is not determined by how the processor settles cash.

Customer payments received before the related goods or services transfer generally remain liabilities until the related revenue-recognition requirements are met. A processor payout moves cash; it does not by itself establish when revenue is earned.

The numerical bridge starts with gross order value before discounts for orders paid through one processor. Subtracting $2,145 in discounts from $47,832 gives $45,687 in captured customer payments before refunds. If your starting report already shows payments net of discounts, start at $45,687 and do not subtract the discounts again. The example excludes sales tax, shipping charges, gift cards, foreign currency and unpaid orders. Include those items where applicable to a real reconciliation. A hold transfers a recoverable amount to funds held; releasing that amount is not new revenue. Actual refunds may settle an existing refund liability. Reconcile opening and closing balances so releases and timing items are counted once.

How Beamarc can help

Beamarc provides bookkeeping, monthly close, financial reporting and accounting advisory. We can discuss the records available, the questions you need answered and the support that fits your business. Scope, responsibilities, timing and fees are agreed before work begins.

Request a consultation.

Related reading

• ChatGPT-referred orders: fees, payouts and attribution
• Clearing-account aging for ecommerce payouts
• Amazon settlements vs. deposits: a reconciliation guide

General information only. Accounting and tax treatment depend on your facts and reporting framework. This article does not provide assurance or establish a client relationship.