Invoice-level linkage for SAP clearing (how we tie Shopify settlements back to SAP)

Ask Me Anything Q&A Payouts Q&A
1

What is the recommended way to include our ERP reference (e.g., SAP invoice number) in Shopify Payments exports/settlement reporting so we can reconcile at an invoice level? Specifically: can Shopify produce a daily settlement view/feed that includes an order identifier and a merchant-provided invoice reference, to support clearing our SAP credit-card clearing account?

2

Are you talking about your shopify payments payout OR your shopify billing invoice?

3

I am talking about Shopify Payment Payouts.

We’re specifically trying to understand how Shopify Payments payout reporting can support ERP‑level reconciliation, including whether there’s a supported way to reference or align payouts back to SAP invoice numbers or order-level financial identifiers.

4

On the payout, you’ll also get a transfer reference. That ID will match deposited transactions from your bank on SAP so you can reconcile a payout and it’s orders from shopify payments to SAP. LMK if I’m misunderstanding.

5

Hi there! @S.T

For Shopify Payments payouts, the “settlement” data is payout/transaction‑based, not invoice‑based, so Shopify won’t natively generate a daily payout feed that also carries an arbitrary merchant ERP invoice number unless that value already lives on the order in Shopify.

What usually works in practice:

  • Store the SAP invoice # on the order (most common: an order metafield or an additional detail/attribute set by your ERP/middleware). Then you have something to join on later.
  • Use Shopify’s built‑in Finance/Payouts reports + exports to get the daily payout/transactions view (payout ID, charge, fees, order ID/name, etc.), and join it back to the order data that contains your SAP invoice metafield.
  • If you need this as a repeatable “daily settlement file” that already includes payout → order → SAP invoice # in one export, a reporting app is often the simplest route. Mipler reports ( Mipler ‑ Advanced Reports - Build custom reports & analytics for sales, inventory & profit | Shopify App Store ) can pull payout/transaction fields and merge in order fields (including metafields) so you can schedule a daily export that your SAP clearing process can ingest.

If you tell me where you’re planning to store the SAP invoice number (metafield vs order attribute) and whether you need payout-date or charge-date settlement, I can point you to the cleanest join keys and export layout.