---
title: "Shopify payout reconciliation, order by order · Hypamoon"
description: "Shopify payouts that don't match the bank or the books? Get each payout split into orders, refunds, fees and adjustments, ready for your accountant."
url: https://hypamoon.com/connect-to/shopify/payout-reconciliation
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Shopify](https://hypamoon.com/connect-to/shopify)
3.  Payout reconciliation

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.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=shopify/payout-reconciliation)

## 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.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~shopify/payout-reconciliation&say=a%20breakdown%20of%20each%20Shopify%20payout%20into%20orders%2C%20refunds%20and%20fees%2C%20and%20a%20monthly%20file%20for%20our%20accountant.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=shopify/payout-reconciliation)

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

-   [**I want an invoice with its own number for each order, emailed to the customer.**](https://hypamoon.com/connect-to/shopify/invoices)
-   [**I work out what to reorder in a spreadsheet every week.**](https://hypamoon.com/connect-to/shopify/reorder-list)
-   [**I use a spreadsheet to track which wholesale customers have paid.**](https://hypamoon.com/connect-to/shopify/net-terms)
-   [**I track the real profit per order in a spreadsheet, and it takes days each week.**](https://hypamoon.com/connect-to/shopify/profit-per-order)
-   [**I spend hours fixing each supplier's file before I can import it.**](https://hypamoon.com/connect-to/shopify/supplier-price-list)
-   [**Each morning I open several reports and paste them into one sheet for the books.**](https://hypamoon.com/connect-to/shopify/end-of-day-report)
-   [**I want my sales reports emailed to me each week, not exported by hand.**](https://hypamoon.com/connect-to/shopify/scheduled-reports)
-   [**After a stock count I update the quantities one product at a time.**](https://hypamoon.com/connect-to/shopify/stock-count)
-   [**I click into each order and write a list of what to make.**](https://hypamoon.com/connect-to/shopify/pick-list)
-   [**When transfers come in, I mark each order as paid by hand.**](https://hypamoon.com/connect-to/shopify/bank-transfer-payments)
-   [**We have duplicate customers from the shop and the till, and I merge them one by one.**](https://hypamoon.com/connect-to/shopify/duplicate-customers)
-   [**I check each new order by hand to cancel the bot orders before shipping.**](https://hypamoon.com/connect-to/shopify/bot-orders)
-   [**Each quarter I split our sales per EU country and VAT rate in a spreadsheet.**](https://hypamoon.com/connect-to/shopify/oss-report)
-   [**Every morning we export the products, run a formula and import them again.**](https://hypamoon.com/connect-to/shopify/scheduled-price-changes)
-   [**Putting the evidence together for a small chargeback takes me half an hour.**](https://hypamoon.com/connect-to/shopify/chargeback-evidence)
-   [**We need to fill in the HS code and origin for each product, and I have no idea which ones are still empty.**](https://hypamoon.com/connect-to/shopify/customs-data)
-   [**Almost a third of our cash on delivery orders come back, and I check the courier's payouts by hand.**](https://hypamoon.com/connect-to/shopify/cash-on-delivery)
-   [**I'm still doing variant metafields one by one across hundreds of variants.**](https://hypamoon.com/connect-to/shopify/variant-metafields)
-   [**I've rewritten titles, descriptions and feed data three times and products still get rejected.**](https://hypamoon.com/connect-to/shopify/product-data-check)
-   [**I make most of my products from parts of many suppliers, and keeping the safety details per product means a lot of copy and paste.**](https://hypamoon.com/connect-to/shopify/gpsr-check)
-   [**Having to click on thousands of products to change the same words over and over.**](https://hypamoon.com/connect-to/shopify/translations-check)
-   [**Shopify only lets me issue one gift card at a time, and our bookkeeper is frustrated by the steps for the balance.**](https://hypamoon.com/connect-to/shopify/gift-cards)
-   [**Do I really have to give store credit one customer at a time when it is 200 of them?**](https://hypamoon.com/connect-to/shopify/store-credit)
-   [**Bulk creating coupon codes without third party apps, and seeing who used a code that made the order free.**](https://hypamoon.com/connect-to/shopify/discount-codes)
-   [**We track our creators on spreadsheets and discount codes, and partial refunds are not taken off the commission.**](https://hypamoon.com/connect-to/shopify/code-commissions)
-   [**That price list is not simple, with each SKU pre-calculated in a table, and setting it up in Shopify is a pain.**](https://hypamoon.com/connect-to/shopify/price-lists)
-   [**Eight sourdough loaves on order for tomorrow show up as eight times one, and I count them by hand.**](https://hypamoon.com/connect-to/shopify/production-list)
-   [**Once or twice a day I figure out what to buy across 100 orders and 500 SKUs, and I email late customers by hand.**](https://hypamoon.com/connect-to/shopify/backorder-updates)
-   [**If a supplier recalled a batch, could you identify which customers got it?**](https://hypamoon.com/connect-to/shopify/lot-expiry)
-   [**We are required to serialise sold goods, and the serial goes in the order note by hand.**](https://hypamoon.com/connect-to/shopify/serial-numbers)
-   [**An order of five 10ml decants should take 50ml off the main bottle, and now I do that in a sheet.**](https://hypamoon.com/connect-to/shopify/component-stock)
-   [**It is typed into a spreadsheet with colour coding, and I spend at least two to three hours at the end of the month.**](https://hypamoon.com/connect-to/shopify/consignment)
-   [**You need 30 days of price history before the sale starts, and I keep it in a spreadsheet.**](https://hypamoon.com/connect-to/shopify/lowest-price-check)
-   [**Shopify cannot calculate VAT on the margin, so I work it out per sale for the tax adviser.**](https://hypamoon.com/connect-to/shopify/margin-scheme)
-   [**Sales reports are built from orders, so if nobody ordered a product, it simply does not appear.**](https://hypamoon.com/connect-to/shopify/dead-stock)
-   [**Every day we get 30 to 50 customers signing up, and I don't know which to delete and which to keep for the mailing list.**](https://hypamoon.com/connect-to/shopify/spam-signups)
-   [**A customer places huge orders and sends it back right before the 30 day mark.**](https://hypamoon.com/connect-to/shopify/blocked-customers)
-   [**Some countries require invoices as structured files, not PDFs, and I retype them in the accounting software.**](https://hypamoon.com/connect-to/shopify/e-invoices)
-   [**Shopify cannot print a proper GST split by itself, and I prepare the summary for my auditor by hand.**](https://hypamoon.com/connect-to/shopify/gst-summary)
-   [**Read the uploaded PDF, check the certificate on the state's website, approve the customer, and remember when it runs out.**](https://hypamoon.com/connect-to/shopify/resale-certificates)
-   [**We sell workshop tickets and need to find the attendees without being at a laptop exporting a CSV.**](https://hypamoon.com/connect-to/shopify/class-lists)
-   [**I still work through each unit price by hand every time.**](https://hypamoon.com/connect-to/shopify/unit-prices)
-   [**Everything for Shopify**](https://hypamoon.com/connect-to/shopify)
