See what each field/column from our “Payouts” template means including possible allowed values and examples.
Payouts are transactions between Shopify Payments account and a connected bank account.
You can use Payouts for reports or accounting.
Payouts are export only and cannot be imported or updated.
Read more about Shopify Payments.
Excel Sheet Name
Payouts
Need a quick start?
Columns Available For Export
Basic Columns
| Column | Description / Example Value |
|---|---|
| ID | ID is automatically generated number by Shopify to identify the item. It is filled in by an Export.If including Transactions then this value is duplicated also for each Transaction row so that you can use it in Pivot tables. ValuesNumber |
| Status | Status of the Payout money transfer.
If including Transactions then this value is duplicated also for each Transaction row so that you can use it in Pivot tables. Valuesscheduled in_transit paid failed canceled |
| Date | Date when the Payout was issued.
The Date will be in the format so that the Excel will recognize it and show in the format according to your Regional Settings. If including Transactions then this value is duplicated also for each Transaction row so that you can use it in Pivot tables. ValuesDate |
| Month | Date in the YYYY-MM format so that you can use it in Pivot tables to aggregate amounts by Month.
ValuesYear-Month Example2019-01 |
| Currency | The currency code of the Payout.
ValuesCurrency |
| Amount | The decimal total amount of the Payout.
If exporting also Transactions, this value is only inserted to the first row of each Payout so that you can still sum by this column to calculate the aggregate amount in Pivot table. ValuesDecimal Number |
Transactions
Each Payout can have several Transactions.
And each Transaction can have data about the related Order where it originated.
| Column | Description / Example Value |
|---|---|
| Transaction: ID | ID of the Payout Transaction.
ValuesNumber |
| Transaction: Type | Typically for each Payout you will have one Transaction of the type “payout” with the negative amount.
The rest will be transactions which make up the total payout amount for that day. The total amount usually for the day is 0. You can assume the Payouts as “your account in Shopify”. Shopify collects money in that account for each day as credit, and then sends the payout to your bank as a debit. Valuescharge refund dispute reserve adjustment credit debit payout payout_failure payour_cancellation |
| Transaction: Processed At | The date and time of the financial transaction.
Date and time will be in the format so that the Excel will recognize it and show in the format according to your Regional Settings. ValuesDate & Time |
| Transaction: Currency | Currency code of the transaction.
ValuesCurrency |
| Transaction: Amount | Gross amount of the transaction (includes also the Fee).
Typically for each Payout, you will have one Transaction of the type “payout” with a negative amount. The rest will be transactions which make up the total payout amount for that day. The total amount usually for the day is 0. You can assume the Payouts as “your account in Shopify”. Shopify collects money in that account for each day as credit, and then sends the payout to your bank as a debit. ValuesDecimal Number |
| Transaction: Fee | Fee which is deduced from the Amount by Shopify Payments.
ValuesDecimal Number |
| Transaction: Net |
Net amount which is gross amount minus the fees.
ValuesDecimal Number |
| Transaction: Source ID | ID of the source which caused the Transaction. Usually, that is the Order.
ValuesNumber |
| Transaction: Source Type | A type of the source which caused the Transaction.
Valuescharge refund dispute reserve adjustment payout |
| Transaction: Source Order Transaction ID | If the transaction was caused by an Order, then the Order Transaction ID will be written in this column.
ValuesNumber |
| Transaction: Source Order ID | If the transaction was caused by an Order, then the Order ID will be written in this column.
ValuesNumber |
| Transaction: Source Order Name |
Name of the Order which caused the Transaction. Usually, it looks like #xxxx.
ValuesText |
| Transaction: Source Order Checkout ID | Checkout ID from the Order that caused the Transaction.
ValuesNumber |
| Transaction: Test Mode | If the payment was made in the Test Mode, then this value will be TRUE.
ValuesTRUE FALSE |
Export Filters
In the Matrixify app, you can apply filters to Export only specific items from your Shopify Store.
When creating new export, select what you wish to export, and under that entity click on the “Filters” button.
Note: total displayed item count and estimated time won’t be affected by the filters applied.
| Filter | Description |
|---|---|
| Date | Allows exporting Payouts from a specific date range.
Relative date condition allows you to export Payouts from the last full amount of time. For example – Last 1 Days, would export Payouts from last full day, so yesterday. Possible Conditions
|
Good To Know
- You cannot import Payouts – you can just export them.
- Payouts only have any data if you are using Shopify Payments.
- To get the most out of the Payouts export, please, look into this Payouts tutorial.
