Viewing and exporting Shopify Payments payout details
The Payouts page of your Shopify admin displays your pending funds, any reserved funds, and your scheduled and previous payouts grouped by payout date. You can review the details and transactions of each payout, export a list of your payouts, export your transactions as a CSV file to view the total fees for each payout and pending transaction, or export the transactions for a specific payout.
To reconcile balance activity across a date range, you can use the Shopify Payments activity report from Finance > Documents in your Shopify admin.
On this page
Understanding the Payouts page
The Payouts page lists your payouts by payout date. Depending on your store's payout setup, a payout date can include more than one payout. For each payout date, you can review the total amount paid or expected, the individual payouts for that date, and the transactions and adjustments that make up each payout.
The payout date is the date that Shopify sends the payout to your bank. After the payout is sent, it typically takes 1 to 3 business days to arrive, depending on your bank.
The Payouts page also includes the following sections:
- Pending: Funds that have been captured but not yet added to a scheduled payout, not including reserved funds.
- Reserve: Funds that are held in a reserve. This section is displayed only when your account has reserved funds. When a reserve is active, this section might also display why your funds are held and until when.
Pending amounts and payout dates are estimates. The final payout amount can change before funds are sent to your bank account because of refunds, chargebacks, reserves, adjustments, or processing updates.
The details of a payout include the following information:
- Payout status
- Payout ID
- Payout amount
- The bank account where the payout is being sent
- The bank reference number, when available
- A breakdown of charges, refunds, adjustments, fees, reserves, and retried payouts
- Transactions included in the payout
The Adjustments amount in a payout's breakdown combines several transaction types. For example, it can include chargebacks, chargeback fees, refund failures, bill payments, Shop Cash activity, Shopify Credit repayments, and transactions with the Adjustment type. To learn what makes up the amount, review the payout's transactions and their transaction types.
If your store receives payouts in multiple currencies, then payout and transaction details can be separated by currency. To learn more, refer to payouts in multiple currencies. If your store has more than one business entity, then you can select a business entity to view only its payouts.
Transaction types
Each transaction on the Payouts page has a type that describes the balance activity. Exported CSV files include the type in the Type column, but the type in a CSV file can be less specific than the type on the Payouts page. For example, Shopify Capital repayments, chargeback fees, and Shopify Protect credits all use the adjustment type in a CSV file. To identify one of these transactions, match its date and amount with the transaction on the Payouts page.
The following table describes common transaction types:
| Type on the Payouts page | Type in CSV files | Description |
|---|---|---|
| Charge | charge | A payment that a customer made for an order. |
| Refund | refund | A refund that you issued to a customer for an order. |
| Refund Failure | refund_failure | A refund that couldn't be completed. The refund amount is returned to your balance. |
| Chargeback | chargeback | A chargeback that a customer opened for an order. The disputed amount is deducted from your balance. |
| Chargeback Won | chargeback won | A chargeback that was resolved in your favor. The disputed amount is returned to your balance. |
| Chargeback Fee | adjustment | A chargeback fee that's recorded as a separate transaction. |
| Shopify Protect Credit | adjustment | A reimbursement from Shopify Protect for a fraudulent chargeback on a protected order. If the chargeback is resolved in your favor, then the credit is reversed. |
| Fraud Protect Adjustment | fraud protect adjustment | Fraud Protect coverage for a chargeback on an order, or a reversal of that coverage after the chargeback is resolved in your favor. |
| Reserved Funds | reserved_funds | Funds that are added to or released from a reserve. |
| Bill Payment | bill payment | A Shopify bill that's paid from your Shopify Payments balance. On the Payouts page, the Order column displays the bill number. |
| Bill Refund | bill refund | A refund of a bill payment. |
| Marketplace sales tax | marketplace sales tax | Marketplace sales tax that's deducted for an order, such as an order from the Shop sales channel in the United States, or returned when the order is refunded. |
| Capital repayment | adjustment | A Shopify Capital repayment that's deducted from your balance. |
| Credit repayment | adjustment | A Shopify Credit repayment that's deducted from your balance. |
| Shop Cash Credit | shop_cash_credit | The Shop Cash portion of one or more orders. Other Shop Cash activity uses its own types. Learn more about Shop Cash transaction types. |
| Adjustment | adjustment | A credit or debit to your balance that doesn't have its own type. Learn more about adjustments. |
Adjustments
An adjustment is a credit or debit to your Shopify Payments balance that isn't a charge or a refund. Some adjustments are linked to an order, and the Order column displays the order number. Other adjustments aren't linked to an order, so the Order column is empty.
Transactions with the Adjustment type can be for any of the following reasons:
- Fee refund: A refund of the fees for an order that you refunded.
- Credit from Shopify: A promotional credit or a goodwill credit, such as a credit from Shopify Support.
- Correction of a financial anomaly: A correction after a difference is found in your balance activity. A debit for this reason uses the Anomaly Debit type on the Payouts page.
- Sales channel credit: Funds that a sales channel app adds to your balance for an order.
- Failed bank payment fee: A fee for a customer's Automated Clearing House (ACH) bank payment in USD that failed.
- Managed Markets correction: A correction to a charge, refund, duty, import tax, or shipping label for an order that's sold through Managed Markets.
- Marketplace sales tax reversal: A reversal of a marketplace sales tax transaction.
If you need more information about an adjustment, then contact Shopify Support.
View your payouts
You can view your pending funds, scheduled payouts, and previous payouts from the Shopify admin. Payments are synced with their orders. This makes it easy to review the amount of funds that you receive for an individual order.
Desktop
- From your Shopify admin, go to Finance.
- In the Payouts section, click View payouts.
Mobile
From the Shopify app, tap the
icon.
Tap Finance.
In the Payouts section, tap View payouts.
Filtering payouts
You can filter your payouts by the following criteria:
- Status: Filter by payout status, such as Scheduled, Deposited, or Failed.
- Payout date: Filter by payout date, such as Today, This week, or This month.
Payout status
The Payouts page displays the current status of each payout:
| Status | Description |
|---|---|
| Scheduled | The payout is in the process of being sent to your bank account. |
| Deposited | The payout was sent to your bank. This doesn't mean that you have the funds in your bank account. Your bank might still need to process and deposit the funds into your account, which typically takes between 1-3 business days depending on your bank. |
| Failed | Your bank failed to successfully process the payout, and the funds weren't deposited. You should follow the prompts in your Shopify admin to learn about next steps. |
| Withdrawn | The withdrawal request was sent to your bank. This doesn't mean that the funds have been removed from your bank account. Your bank might still need to process the request, which typically takes between 1-3 business days depending on your bank. This status only applies in regions where Shopify Payments debits negative balances. |
View a specific payout
You can review the details and transactions of a specific payout.
Steps:
From your Shopify admin, go to Finance > Payouts.
Click the payout date.
Click the payout that you want to review.
If a payout includes the amount of a failed payout that was retried, then the payout details display the amount that was added or deducted for the failed payout.
For more information about the status of a specific payout, you can reach out to the bank connected to your Shopify Payments account and provide them with the payout's bank reference number. You can copy the bank reference number from the payout details.
View all transactions
Clicking View transactions on the Payouts page lists all transactions associated with all of your payouts.
Transactions share the same status as payouts with the addition of the Pending status. Transactions marked as Pending are for sales that you've made, but that haven't been added to a payout and sent to your bank account yet. The Payout Date for pending transactions is an estimate only.
Export your payouts and transactions
You can export a list of your payouts to a CSV file, with one row for each payout. You can also export the transactions for a specific payout, your pending transactions, or all of your transactions, to a CSV file. The transaction exports contain the same transaction CSV file columns.
Export your payouts
You can export a list of your payouts, either all of them or the payouts within a date range. Each row of the file is one payout, with its totals. Use this export when you need a summary of your payouts, for example for one month. To export the transactions that make up a payout, export a specific payout instead.
Steps:
From your Shopify admin, go to Finance > Payouts.
Click Export.
Select the payouts that you want to export:
- All payouts: Exports all of your payouts.
- All payouts by date: Exports the payouts within a date range.
Select a CSV file type, and then click Export payouts.
The exported file name starts with payouts_export, for example payouts_export_1.csv. Large exports are delivered as compressed .zip files. The file contains the following columns: Payout Date, Status, Charges, Refunds, Adjustments, Marketplace Sales Tax, Advances, Reserved Funds, Fees, Retried Amount, Total, Currency, and Bank Reference. If your store has more than one business entity, then the file also contains Business Entity Name and Business Entity ID. If your store uses Managed Markets, then the file also contains Duties and import taxes and Labels.
Export a specific payout
You can export only the transactions that are included in a specific payout. Use this export when you need to reconcile one payout or bank deposit.
Steps:
From your Shopify admin, go to Finance > Payouts.
Click the payout date, and then click the payout that you want to export.
Optional: To export only some of the payout's transactions, search or filter the transactions in the payout details.
In the payout details, click the
icon.
Click Export payout transactions.
Export pending transactions
You can export the transactions that haven't been added to a payout yet.
Steps:
From your Shopify admin, go to Finance > Payouts.
Click Pending.
Click the
icon.
Click Export pending transactions.
Export all transactions
You can export all of your transactions, the transactions that match your search or filters, or the transactions within a date range.
Steps:
From your Shopify admin, go to Finance > Payouts.
Click View transactions.
Optional: To export only some transactions, search or filter the transactions.
Click Export.
Select the transactions that you want to export:
- Current page
- All items: Exports all of your transactions, even if you've searched or filtered them.
- Items matching your search: Exports only the transactions that match your search or filters.
- Items by date: Exports the transactions within a date range.
Select a CSV file type, and then click Export items.
Transaction CSV file columns
The transaction CSV file contains the following information:
| Column | Description |
|---|---|
| Transaction Date | The date and time that the transaction occurred, including the time zone. Example: 2017-06-20 11:26:40 -0400 |
| Type | The type of transaction. Example: charge, refund, or adjustment. Learn more about transaction types. |
| Order | The number associated with the order. This column is empty for transactions that aren't linked to an order, such as reserved funds and some adjustments. |
| Card Brand | The type of card used for the transaction. Example: visa |
| Card Source | The method by which the card was charged. Example: swiped |
| Payout Status | The payout status of the transaction. Example: pending |
| Payout Date | The date that the payout was sent to your bank. For pending transactions, this date is an estimate. |
| Payout ID | The ID of the payout that includes the transaction. This column is empty for pending transactions. |
| Available On | The date that the funds from the transaction become available to include in a payout. |
| Amount | The amount of the transaction, in the currency in the Currency column. |
| Fee | The fee applied to the transaction, in the currency in the Currency column. |
| Net | The difference between the amount and the fee. |
| Checkout | The number of the checkout that the order was placed from, when it's available. |
| Payment Method Name | The type of payment method that the customer used. Example: card |
| Presentment Amount | The amount of the payment or refund that the transaction is linked to, in the currency in the Presentment Currency column. For a charge, this is the amount that the customer paid. For a refund, it's the refunded amount. For other transactions that are linked to a payment, such as chargebacks, it's the amount of that payment. This column is empty for transactions that aren't linked to a payment or refund. |
| Presentment Currency | The currency that the customer paid in. Example: GBP |
| Currency | The currency of the Amount, Fee, and Net columns, which is usually the payout currency of the transaction. Example: EUR |
Depending on your store, the CSV file can include more columns. The VAT, GST, or Effective Fee (%) column is included for the tax or fee information that applies in your region. The Business Entity Name and Business Entity ID columns are included if your store has more than one business entity.
Currency in CSV files
The amounts in an exported CSV file of your transactions are usually in the payout currency of each transaction, which can be different from your store currency. The Currency column lists the currency of each row. The columns use the following currencies:
- Amount, Fee, and Net: These columns use the currency in the Currency column, which is usually the payout currency of the transaction. In some cases, a row for the Shop Cash credit of a single order uses your store currency instead.
- Presentment Amount: This column uses the currency that the customer paid in, which is listed in the Presentment Currency column.
If a customer pays in a currency that you don't receive payouts in, then the payment is converted to your default payout currency, and the Amount, Fee, and Net columns contain the converted amounts. Learn more about considerations for Multi-Currency Payouts.
For example, your payout currency is EUR, and a customer pays £50 GBP for an order. In the CSV file, the Amount, Fee, and Net columns contain the converted amounts in EUR, and the Currency column lists EUR. The Presentment Amount column contains the amount in GBP that the customer paid, and the Presentment Currency column lists GBP.
The Shopify Payments activity report uses the payout currency that you select for the report.