Shopify orders, traced to the bank.
Every order followed through its gateway and payout into the deposit, and into the invoice your books hold.
What comes in from Shopify
- Orders
Order number, customer, line items, tax, shipping, discounts and the gateway that took payment.
- Payout transactions
Each charge, refund and adjustment inside a Shopify Payments payout, with its fee.
- Payouts
The bank transfers themselves, each one a batch of several days of orders.
Why it won’t match on its own
One order, several gateways
An order can be paid by Shopify Payments, PayPal, a gift card or a mix, and each settles somewhere else.
Orders change after the sale
Edits, partial refunds and returns change the total long after the payout that carried the first charge.
The bank never sees the order
A deposit only names the payout, so each order has to be found through the payout’s transactions.
One rule, in plain words
Match Shopify orders to payout transactions by order number, at the gross amount.
order number = transaction order, gross5,240 matched
The payouts then match the Chase deposits they became. An order paid by gift card, or never paid, stays open where you can see it.
What Numerics works out
Because every refund is matched to its order, Numerics can tell a refund rate apart from a payout that simply came in short.
You go run your business.
Bring a month of Shopify records to the call. You’ll see them matched before it ends.