Shopify orders, taxes and all.
Every order matched to its payout and deposit, with GST, HST and PST kept in their place.
What comes in from Shopify
- Orders
Order number, items, shipping, discounts and the tax charged for the province it ships to.
- Payout transactions
Each charge, refund and adjustment inside a Shopify Payments payout, with its fee.
- Payouts
Transfers to your Canadian account, each covering several days of orders.
Why it won’t match on its own
The tax depends on the address
An order to Ontario carries HST, one to British Columbia GST and PST. Totals differ for the same cart.
Refunds reverse the tax too
A partial refund takes back part of the tax, weeks after the payout that carried the sale.
The deposit only names the payout
Your bank sees Shopify, not the order, 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, tax included, before fees.
order number = transaction order, gross with tax4,310 matched
The payouts then match the RBC deposits they became. An order paid another way, or not at all, stays open where you can see it.
What Numerics works out
Only orders matched to money in the bank are counted, so this is tax you collected, not tax you invoiced.
You go run your business.
Bring a month of Shopify records to the call. You’ll see them matched before it ends.