Shopify Change Log

Shopify Payments: Easily reconcile bank deposits with payouts

Author

klaus.jpg
Klaus

Published

Updated


Diesen Artikel anhören

Classification of the feature

Shopify has introduced a change that simplifies the process of reconciling Shopify Payments disbursements with actual bank deposits. This addresses a common issue in the financial and accounting processes of many stores: the amounts received in the bank account cannot always be immediately and clearly matched to a disbursement in the Shopify admin. The new process improves the matching between Shopify-Payments-Payouts and Bank deposits. According to Shopify, this is intended to make it easier to identify which orders, fees, and adjustments correspond to a specific bank statement entry. For larger stores that handle multiple daily payouts or various payment sources, this primarily reduces the need for manual research.

What the feature is—and what it isn't

What the feature is

The update improves the Traceability between Shopify Payments payouts and bank transactions. Essentially, the goal is to make it easier for merchants to see the following in the admin panel:

  • Which payments correspond to which bank account balance
  • which orders are included in a payout
  • which fees or adjustments are included

This results in the Reconciliation of Shopify data with the bank account easier.

This applies in particular to teams from:

  • Accounting
  • Finance
  • Operations

who regularly check incoming payments.

What the feature is not

The update replaces no accounting software. It is also no automated accounting system and does not create journal entries. Equally important: It does not change not the payout speed, not the fee structure and not how Shopify Payments itself works. This feature improves only the Transparency in reconciling disbursements and bank deposits.

Requirements & Data Set

In order to use this feature effectively, certain requirements must be met.

Shopify Payments enabled

This feature applies exclusively to stores that Shopify Payments use. Other payment providers, such as PayPal or Klarna, will continue to be processed separately.

Consistent bank account information

Payments are made to the bank account on file in the Shopify admin. If multiple bank accounts are used (e.g., for international stores), the process becomes more complex.

Data Quality

The following data is essential for an accurate comparison:

  • Complete order history
  • accurate fee calculation
  • no manually altered payment data

If orders are modified after the fact, the payout amounts may differ from those of the original sale.

Countries and Availability

Shopify Payments is not available in all countries. Withdrawal processes may also vary by region. As of today, Shopify refers users to the Regional documentation in the Help Center.

Here's how to use it in the Shopify admin

The process is relatively simple and takes place entirely within the Shopify admin.

Open Payout

In the Shopify admin:

Settings → Payments → Shopify Payments → Withdrawals

There you can see all scheduled and already paid amounts.

Select payment method

When you open a payment, Shopify displays:

  • orders included
  • Refunds
  • Fees
  • Adjustments

This shows how the amount is broken down.

Compare bank deposits

Now the amount can be compared with the actual bank deposit.

Example:

Bank statement shows:

3.482,17 €

In the Shopify admin, a payout for exactly that amount is visible. This makes it clear which transactions are included.

Check the details

If there are differences, you can check:

  • Refunds
  • Chargebacks
  • Transaction fees

These will be listed individually in the payment statement.

Practical logic that determines cost and quality

Shopify's payment system follows a simple logic that you should understand.

Payout intervals

Shopify groups orders into payouts. The interval may vary depending on the country and the store's history, for example:

  • daily
  • every other day
  • weekly

This affects how many orders are included in a payout.

Fee Structure

The payout amount is calculated as follows:

Orders
minus transaction fees
minus refunds
plus adjustments

That is why the bank balance is rarely the same as the total of all sales.

Delays

Individual payments can be made at a later date, for example:

  • during risk assessments
  • for certain types of cards

This allows orders to be split across multiple payments.

Typical practical applications

Accounting reconciliation

Finance teams review the following on a daily or weekly basis:

"Which deposit corresponds to which sale?"

With the improved classification, the bank balance can be explained more quickly.

Month-end closing

Cash flows must be traceable during month-end closing. This feature helps identify outstanding discrepancies more quickly.

Tax audit

During tax audits, cash flows must be traceable. A detailed payment history makes it easier to document individual transactions.

Segment Recipes

Even though this isn't about marketing segments, payments can be grouped logically.

Active sales

Rule:

When placing an order paid and non-refundable, then it will be included in the next payout.

Refunds

Rule:

When placing an order will be reimbursed, it reduces a future payout.

Chargebacks

Rule:

If a A chargeback occurs, the amount will be deducted from a future payment.

Text / Template Examples

These brief notes are often used internally, for example in financial documentation.

Included in the order

"This order is part of the Shopify Payments payout from March 12."

Refund

"The refund will be included in your next payment."

Chargeback

"The chargeback amount will be deducted from a future payment."

When it makes sense—and when it doesn't

Reasonable

This feature is especially helpful for stores with:

  • high order volume
  • multiple daily payouts
  • in-house finance or accounting department

A clear classification saves a lot of time here.

Less relevant

For small shops with only a few orders per week, the benefits are limited. In such cases, the allocation is usually easy to understand even without an additional structure.

Mistakes to Avoid

Confusing sales with payouts

Revenue is not an immediate payout. Fees, refunds, and adjustments affect the amount.

Integrate PayPal with Shopify Payments

PayPal payments do not appear in Shopify Payments payouts. These must be reviewed separately.

Incorrectly grouping bank transactions

Some banks combine multiple deposits. As a result, the amounts do not match the withdrawal exactly.

Technical implications for larger online stores

In larger Shopify setups, this feature affects multiple systems.

Data flows

Typical procedure:

Order → Payment → Shopify Payments → Withdrawal → Bank Account → Accounting

Many stores also export this data to:

  • Enterprise Resource Planning
  • Accounting systems
  • BI-Tools

Integration

Typical integrations:

  • DATEV Connector
  • NetSuite
  • Zero
  • in-house finance pipelines

It is important here that the payout is mapped correctly.

Test cases

Recommended tests:

  • Order with no refund
  • Order with refund
  • Chargeback Cases
  • Multiple orders in a single payment

This allows you to check whether all systems are synchronizing correctly.

Governance

In larger teams, the following should be clearly defined:

  • who reviews payments
  • who resolves differences
  • who approves bookings

Moving Primates Perspective

In projects involving medium-sized and larger Shopify stores, we regularly see that finance teams initially review payouts based on sales data. This almost always leads to discrepancies because fees, refunds, and chargebacks appear in payouts with a time lag. The actual risk does not arise in the payment process, but rather in the Interpretation of the data. Our practical recommendation: Always treat payouts as a separate data stream and do not compare them directly with order revenue. Only once it is clear which transactions are included in a payout should you reconcile them with bank deposits. This significantly reduces the need for manual research.

10-Point Checklist Before Go-Live

  • Check if Shopify Payments is enabled
  • Bank account correctly entered in the admin panel
  • Payout interval known
  • Test orders placed
  • Refund tested
  • Simulated chargeback case
  • Export verified in accounting
  • ERP Integration Tested
  • Finance Team Trained
  • Company documentation updated

Frequently Asked Questions

How much does this feature cost?

There are no additional costs. It is part of Shopify Payments.

What information do I need for this?

An active Shopify Payments integration, as well as correctly recorded orders, fees, and refunds.

Does this work with PayPal or Klarna?

No. This feature applies exclusively to Shopify Payments.

Can I use this to do my bookkeeping automatically?

No. It simply makes it easier to reconcile payments. Accounting systems are still necessary.

For which stores is this particularly relevant?

Especially for stores with high order volumes or their own finance team.

When is this feature less helpful?

For stores with few orders, where payments are easy to track anyway.

List of Links

Shopify Changelog – Better way to match Shopify Payments payouts with bank deposits

https://changelog.shopify.com/posts/better-way-to-match-shopify-payments-payouts-with-bank-deposits
Official Shopify changelog for the feature.

Shopify Help Center – Shopify Payments

https://help.shopify.com/en/manual/payments/shopify-payments
Documentation on Shopify Payments, payouts, and fees.

Shopify Developer Documentation

https://shopify.dev
Technical documentation for integrations and payment data.