How to Reconcile Shopify Orders and Payment Settlements with SAP ECC and SAP S/4HANA
Reconciling financials between SAP and Shopify is one of the most common questions eCommerce and ERP managers face while launching their online store. In many cases, this comes as an afterthought when order volumes increase. Though Shopify as a sales channel gets added and starts contributing to revenue, reconciliation becomes a nightmare for the finance team in this case.
Being prudent about having a proper solution to integrate Shopify with S4 HANA is therefore an important consideration.
Unlike traditional B2B transactions, most Shopify B2C orders are paid online using a credit card or another digital payment method. Payment is typically authorized at checkout and, depending on the Shopify payment configuration, may also be captured at that time.
This changes how the order should be handled in SAP.
In a traditional SAP B2B process, a sales order is created, followed by an outbound delivery, invoice, and subsequent payment collection. For a prepaid Shopify order, however, the payment authorization has already happened outside SAP. Following the same B2B process without accounting for this difference can create reconciliation challenges.
In this article, we will walk through how to integrate Shopify orders with SAP while bringing payment authorization, fees, and settlement information directly into SAP.
Although we will primarily refer to Shopify and SAP ECC as well as SAP S/4HANA, the underlying approach can also be adapted to other SAP ERP systems, including SAP Business One and SAP Business ByDesign.
How to reconcile Shopify with SAP S4 HANA Accounts Receivable?
Note that reconciliation is a downstream issue and to be able to solve it reliably, the underlying transaction must be accurate. Let us see how this can be done in a way that maximizes standard SAP functionality and least customization.
Step 1: Bring Payment Information into SAP When Creating the Order
For this article, we will assume that SAP does not have its own payment processing engine and that Shopify handles payment authorization and capture. Even if you already have a payment processing solution in SAP, the overall reconciliation approach remains largely the same.
When downloading an order from Shopify into SAP, two additional pieces of information are particularly important:
- Shopify fees and charges associated with the transaction.
- Payment authorization details, including the external authorization or transaction reference that can be used for subsequent reconciliation.
SAP ECC and SAP S/4HANA provide a standard Payment Cards tab in the sales order.
This allows you to record an externally authorized payment, indicating that the authorization has already taken place in Shopify. The corresponding authorization number and amount can be maintained against the SAP sales order.
By marking the transaction as externally authorized, SAP can be configured to recognize that authorization has already been performed by the external payment system, rather than initiating a fresh authorization.
Importantly, there is no need to transfer sensitive customer credit card information into SAP simply to maintain this reference.
The authorization or transaction reference also provides an important link between the original Shopify order and the payment information that will later appear in the settlement records.
A preconfigured integration solution such as APPSeCONNECT can automate this process. If you are using another integration platform, you may need to call additional Shopify APIs to retrieve the payment transactions, authorization references, and applicable charges.
These details should ideally be captured every time a new order is created in SAP, rather than trying to reconstruct the payment information during settlement reconciliation.
Step 2: Account for Shopify Fees and Charges in SAP
Another important consideration is how Shopify fees and charges are represented in SAP.
Depending on your pricing procedure and accounting requirements, you may need to configure a manual condition type in SAP to account for the applicable Shopify charges.
This condition type can also be maintained at the sales order header level, allowing it to apply to the entire order instead of individual line items.
The relevant account determination should ensure that these charges are ultimately posted to the appropriate General Ledger (G/L) account.
The objective is to maintain a clear relationship between:
- The amount paid by the customer on Shopify.
- The corresponding sales order and invoice value in SAP.
- The Shopify processing fees and other deductions.
- The net amount expected from Shopify during settlement.
An important litmus test: Can you reconcile the Shopify order value with the corresponding SAP order value and explain the difference between the gross customer payment and the net settlement amount?
Getting this right at the order creation stage makes subsequent settlement reconciliation considerably easier.
Step 3: Fulfillment, Billing, and Payment Posting
Once the sales order is created in SAP, the normal fulfillment process can continue.
An outbound delivery is created, goods are shipped, and the corresponding billing document is generated.
Since the original payment information was already brought into SAP, the billing and payment posting process can use the external authorization details, subject to the payment card and accounting configuration maintained in SAP.
This allows the invoice and related payment information to be accounted for without treating the Shopify transaction as a traditional unpaid B2B order.
The associated Shopify charges can also be posted to their designated G/L accounts using the condition type configured earlier.
The result is a much cleaner financial trail, connecting the original Shopify order, the SAP sales document, billing document, payment reference, and applicable charges.
Step 4: Reconcile Shopify Settlements with SAP
Shopify periodically remits the collected funds to the merchant based on the configured payout schedule. Depending on the merchant's arrangement, this could be daily, weekly, or at another interval. You can download the file from Settings → Payments → View payouts → View Transactions → Export
Select the required date range and export the balance transactions CSV. Shopify documents fields such as Order, Transaction Date, Type, Amount, Fee, Net, Payout Status and Payout Date.
A single Shopify settlement may contain payments from multiple orders, along with deductions such as processing fees, refunds, and adjustments.
This is where maintaining the original payment references in SAP becomes particularly useful.
How to Retrieve Shopify Processing Charges and Fees Using APIs
When a customer places an order in Shopify and pays using a credit card, Shopify captures the order details along with the payment transaction information. In addition to the gross order value, Shopify also provides APIs to retrieve the actual processing fees charged against the transaction.
These fees can be retrieved using the Shopify GraphQL Admin API through the OrderTransaction.fees field. The API can provide details such as the processing fee amount, percentage rate, flat fee, currency, and applicable taxes. This allows the integration to retrieve the actual Shopify charges rather than calculate them using an assumed processing rate.
However, the processing fee may not be available immediately when the order is created. In some cases, Shopify calculates and records the fee only after the payment has been captured and processed. Therefore, the integration should first retrieve the order and payment transaction details and subsequently check whether the processing fee is available.
For Shopify Payments, APPSeCONNECT can use the following approach:
- Retrieve the order details when an order is created in Shopify using the
orders/createwebhook. - Retrieve the associated payment transaction using the GraphQL Admin API.
- Read the
OrderTransaction.feesfield to obtain the actual processing charges, if available. - If the fee is not yet available, retrieve it again after payment capture or through a scheduled reconciliation process.
- Store the Shopify Order ID, Transaction ID, gross payment amount, processing fee, and currency for subsequent reconciliation with SAP.
For final settlement reconciliation, Shopify also provides the shopifyPaymentsAccount.balanceTransactions API. This API returns the gross transaction amount, processing fee, net amount, associated order, and payout information. It can be used to reconcile individual Shopify transactions against the consolidated amount transferred to the merchant's bank account.
Why This Approach Matters
One of the biggest challenges with high-volume Shopify integrations is that reconciliation is often treated as a periodic financial activity rather than an integral part of order processing.
As order volumes increase, this creates a significant workload for the finance team, particularly during settlement reconciliation and month-end closing.
By bringing payment authorization details and applicable Shopify charges into SAP at the time of order creation, much of this work can be addressed upfront.
The approach also makes use of standard SAP capabilities, including externally authorized payment cards and pricing condition types, without necessarily introducing additional custom fields.
With an integration solution like APPSeCONNECT, the required Shopify API calls, order creation, payment references, and subsequent settlement reconciliation can be automated.
Creating a Clear Financial Trail Between Shopify and SAP
Reconciling Shopify orders with SAP ECC or SAP S/4HANA becomes much easier when payment data is treated as part of the order integration rather than as a separate finance activity at the end of the settlement cycle.
By capturing Shopify payment references and applicable transaction charges when the SAP sales order is created, businesses can maintain a clearer relationship between the customer payment, SAP order and invoice, processing fees, and the final amount deposited into the bank account.
SAP’s standard payment-card and pricing capabilities can support much of this process, while Shopify’s transaction and payout APIs provide the information required for detailed reconciliation.
With APPSeCONNECT, these data flows can be automated across Shopify and SAP, helping finance and eCommerce teams maintain a traceable order-to-settlement process with less manual reconciliation and better visibility into exceptions.
