We use SAP for accounting. As part of our new implementation for Shopify, we are planning to use the Shopify settlement functionality based on the delivery documents from SAP. Shopify generates the invoice for the delivery (partial or full) and settles using its native settlement functionality. SAP generates the invoice after the delivery documents interfaced with Shopify. How can SAP and Shopify reconcile invoice and settlement amounts? Also, how do other Shopify customers handle reconciliation between Shopify and SAP?
Best sorted out before you go live, because this shapes the integration and not just the reports.
You need two reconciliations, not one, and Shopify splits them itself. Sales reports show the value of goods in the sale, not the money you received, and the payments activity report says outright that it isn’t a statement of revenue for accounting. So invoices tie to orders, cash ties to payouts, and the two won’t agree inside the same period.
On the invoice side, one thing to know before you build. Shopify has no invoice number. Its invoice is an email carrying a checkout link, so your match keys are the order name, the PO number if the buyer gives one, and the payment reference in the orders export.
On the cash side, pull balance transactions filtered by payout id. The CSV export has no payout id column, so treat that file as a human check rather than the integration surface.
Three things will leave a permanent gap unless you model them. Payouts are recorded in UTC, and Shopify says finance reports and payout exports can use different time zones. Third party gateways never show up in Shopify payouts at all. And reserves reduce a payout without always being tied to an order.
SAP isn’t among Shopify’s named integrations, so the documented route for it is a custom build on the APIs.
In my experience reserves and refunds don’t bite in the first month of a reconciliation, they bite in the second. Worth building for them now rather than when they surprise you.