Short answer: the payout transactions export is a CSV with one row for every movement of money in your Shopify Payments balance. Shopify documents eleven columns. Net is Amount minus Fee, and the Type column says what kind of transaction each row is. Shopify publishes the list of Type values, but not what each one means.
Exporting one payout, or everything
There are two exports, and Shopify says both have the same columns. Use the one for a single payout when you are matching one bank deposit. Use the one for all transactions, or a date range, when you want a whole month or more.
One payout
Shopify is rolling out a new payouts view to some merchants, so the steps depend on which view you have, as of 6 October 2026.
- New payouts view. In your Shopify admin go to Finance, then Payouts. Click the payout date, then the payout itself. You can search or filter its transactions first if you only want some of them. Then use the export icon in the payout details and choose Export payout transactions.
- Original payouts view. Go to Finance, then Payouts, and click the date of the payout. If more than one payout went out that day, click the one you want. Then click Export and Export payout transactions.
All transactions, or a date range
The route is step 2 of our guide to why a Shopify payout is less than your sales. You choose the range and the type of CSV there. Shopify does not describe the CSV types on that page.
Either way, the file does not download in your browser. Shopify sends it by email, to you and to the store owner.
What each column means
These are the eleven columns Shopify lists, in its order, described in our words.
| Column | What it tells you |
|---|---|
| Transaction Date | When the transaction happened, with the time and the time zone. |
| Type | What kind of transaction the row is, for example a refund. See the Type section below. |
| Order | The order number the row belongs to, where it belongs to one. |
| Card Brand | Which card was used, for example Visa. |
| Card Source | How the card was taken, for example swiped. |
| Payout Status | Where the row's money is: pending, or the status of the payout it is in. |
| Payout Date | The date of the payout the row is in. For a pending row it is an estimate. |
| Available On | The date the money becomes available to pay out. |
| Amount | The gross amount of the transaction. |
| Fee | The fee Shopify took on that transaction. |
| Net | Amount minus Fee: what the row added to, or took from, your balance. |
If your file has columns that are not in this list, Shopify’s Help Center page does not describe them.
Net is Amount minus Fee
Shopify defines Net as the difference between the amount and the fee, and its developer documentation describes the fee as deducted from the transaction amount. So on every row, Amount minus Fee should equal Net, and Net is what actually moved your balance.
Example only. The rows below are made up, in US dollars, to show the arithmetic. They are not from a real store, and a real export has more columns.
| Type | Order | Amount | Fee | Net |
|---|---|---|---|---|
| charge | #1041 | 120.00 | 3.78 | 116.22 |
| charge | #1042 | 45.00 | 1.61 | 43.39 |
| refund | #1038 | -30.00 | 0.00 | -30.00 |
| adjustment | -15.00 | 0.00 | -15.00 | |
| Total | 120.00 | 5.39 | 114.61 |
Each row’s Net is its Amount less its Fee, and the four Net figures add up to $114.61. If these four rows were one whole payout, $114.61 is what the payout would be.
Payout status, and why pending dates move
The Payout Status column tells you where a row’s money is. On its Payouts page, Shopify uses four statuses for a payout, and transactions can have a fifth:
- Pending (transactions only): a sale that is not in a payout yet. Its Payout Date is only Shopify’s estimate.
- Scheduled: the payout is on its way to your bank.
- Deposited: Shopify has sent the payout. Shopify notes that your bank typically takes 1 to 3 business days more to show it.
- Failed: your bank could not process the payout, and the money did not arrive. Shopify says to follow the prompts in your admin.
- Withdrawn: a request to take money from your bank account was sent. Shopify says this only happens in regions where it debits negative balances.
Shopify also says that pending payout amounts and dates are estimates that can change before the money is sent, because of refunds, chargebacks, reserves, adjustments or processing updates. So a pending row is a forecast, not a payment.
The words can differ. These are the labels on the Payouts page. Shopify’s developer documentation names payout states differently (paid, scheduled, failed and canceled, with in transit marked as deprecated). Shopify does not say which words the CSV itself prints, so read the column as it appears in your own file.
The Type column
Shopify’s developer documentation publishes the full list of Type values, and it is long: 114 of them as of 6 October 2026. It is linked under Sources. Here they are in broad groups. The grouping is ours, not Shopify’s.
- Sales and refunds: charge, refund, charge_adjustment, refund_adjustment, refund_failure
- Disputes: chargeback_fee, chargeback_fee_refund, chargeback_hold, chargeback_hold_release, dispute_reversal, dispute_withdrawal
- Reserves and risk: reserved_funds, reserved_funds_reversal, reserved_funds_withdrawal, risk_reversal, risk_withdrawal
- The payout itself: transfer, transfer_cancel, transfer_failure, transfer_refund
- Shopify Capital: lending_credit, lending_debit, lending_capital_remittance and related reversals
- Shopify Balance: balance_transfer_inbound, balance_transfer_outbound
- Shipping labels: shipping_label and several shipping adjustments
- Taxes and duties: import_tax, customs_duty, tax_adjustment_credit, tax_adjustment_debit, vat_refund_credit
- Promotions, sales channels and programmes: promotion_credit, merchant_goodwill_credit, and credits and debits for channels, Shopify Collective and Shop Cash
- Other charges: billing_debit, application_fee_refund, stripe_fee, referral_fee
What Shopify does not tell you. The developer list describes each value only as “the … transaction type”, and we found no Shopify page that explains what each one means. Shopify’s own lists also disagree on the words:
- The Help Center gives just two examples for the Type column, adjustment and refund.
- The older REST API lists ten types, including dispute, reserve and payout.
- The newer GraphQL API lists 114, and has no plain dispute, reserve or payout. It uses names such as dispute_reversal, reserved_funds and transfer instead.
Shopify does not say which of these lists the CSV follows. If a Type in your file is not in either developer list, or you are not sure what it means for your money, Shopify Support is the place to ask.
When it is worth a look
Most rows are ordinary. These are worth a second look:
- A row whose Net is not Amount minus Fee. That is how Shopify defines the column, so a row that breaks it is worth raising with Shopify.
- A payout whose Net column does not add up to what reached your bank, once the bank has had its 1 to 3 business days.
- A payout marked Failed, which means the money did not arrive.
- A Withdrawn row. Shopify describes Withdrawn as a withdrawal request sent to your bank, so money is going out of your bank account rather than into it.
- A Type you cannot find in Shopify’s published lists.
How PayoutCheck shows it
PayoutCheck recognises this export by its Transaction Date, Type, Amount, Fee and Net columns. It also needs a currency column; a file without one is turned away, with a note saying why.
- Every row is read and counted. Each Type is mapped to a line of the reconciliation, such as sales, fees, refunds, chargebacks, adjustments or reserves. A Type it does not recognise is still counted, and is listed under data quality with the word from your file. Rows that are the payout itself are left out, so a payout is not counted twice.
- Rows are grouped by Payout Date, or by Available On when the Payout Date is blank, and kept apart by currency.
- Payout Status decides what counts as paid. Rows marked paid or deposited are counted. Pending, scheduled and in transit rows are kept out of the paid figure and listed as not yet paid out; failed and cancelled rows are kept out too. Any other word, including withdrawn, is kept out and shown with the exact word your file used. A file with no Payout Status column is read as paid throughout.
- Net is checked on every row. PayoutCheck works out each row from the Amount and Fee columns, then checks that your Net column agrees, as Shopify defines it. A row where it does not is reported with its three figures. If most rows disagree, the report says PayoutCheck may be reading the file wrongly instead.
One thing it cannot do with this file. This export contains no payout total, so PayoutCheck cannot confirm that what it adds up is what reached your bank; the report says so rather than guess.
Questions
How do I export the transactions for one Shopify payout?
In your Shopify admin go to Finance, then Payouts, and open the payout. In the new payouts view, click the payout date and then the payout, then the export icon and Export payout transactions. In the original view, click the payout's date, then Export and Export payout transactions. Shopify sends the file by email, to you and to the store owner.
What is the difference between Amount, Fee and Net?
Amount is the gross amount of the transaction, Fee is what Shopify took on it, and Net is Amount minus Fee. Net is what changed your balance, so it is the column to add up for a payout.
Why does a pending transaction show a payout date?
Shopify gives pending transactions an estimated payout date. It says pending amounts and dates are estimates and can change before the money is sent, for example because of refunds, chargebacks, reserves or adjustments.
Where can I find what each Type value means?
Shopify publishes the list of Type values in its developer documentation, but describes each one only by its name, and we found no Shopify page that explains them one by one. Its Help Center, its older REST list and its newer GraphQL list also use different words. If a Type in your file is unclear, ask Shopify Support.
Can PayoutCheck tell me whether this export matches my bank deposit?
Not from this file alone. The payout transactions export contains no payout total, so PayoutCheck can add up the rows but cannot confirm the figure against what reached your bank, and its report says so.
Sources
- Viewing and exporting your Shopify Payments payout details: help.shopify.com
- ShopifyPaymentsTransactionType, the full list of Type values (GraphQL Admin API): shopify.dev
- Balance transactions, with the older list of types (REST Admin API): shopify.dev
- ShopifyPaymentsPayoutStatus, payout states (GraphQL Admin API): shopify.dev
This guide describes Shopify’s own published documentation as of 6 October 2026, which can change. It is not accounting, tax or legal advice, and PayoutCheck is not affiliated with Shopify.