Skip to content
Hypamoon

For teams that run on Shopify

Shopify payout reconciliation, order by order

Shopify Payments pays out in batches, after fees and refunds are taken off. Its payouts report shows the transactions, and Shopify's help says that report isn't a statement of revenue for the accounts. So matching a payout on the bank to orders and fees happens in a spreadsheet.

How it goes today

  1. Download the payout transactions for the month.
  2. Export the orders for the same dates.
  3. Match them in a spreadsheet and look up the refunds and chargebacks.
  4. Book the fees and the net amount by hand, or pass it to the accountant.

How it can go

Know which orders, refunds and fees make up each payout.

For each payout you get a breakdown: the orders paid, the refunds, chargebacks and adjustments taken off, and the fees, adding up to the amount on your bank. Each month the payouts come together in one file with the accounts your accountant gives, and a payout that does not add up is listed apart.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. Shopify works with a sign-in instead of a key: you sign in to Shopify once to give access, never in the chat.

Your request

With Hypamoon, for each Shopify Payments payout, list the orders, refunds, chargebacks, adjustments and fees in it, so they add up to the amount paid to our bank. At the start of each month, put last month's payouts in one file with the accounts my accountant gives for sales, fees and refunds, and email it to me and my accountant. Show any payout that does not add up apart.

You create your own app in the Shopify Dev Dashboard and install it on your store once, with the access you approve. Shopify's help says apps that use customer names, emails or addresses need the Grow plan or higher. It stays yours.

More for teams on Shopify