Payouts

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.

Excel Sheet Name

Payouts

Need a quick start?

See Tutorials about Payouts

Columns Available For Export

Basic Columns

Column Description / Example Value

Column	Description / Example Value
ID *Export Only*	ID is an 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. Values Shopify internal ID
Status *Export Only*	Status of the Payout money transfer. `scheduled`: payment is collected and is scheduled to be sent to the bank. `in_transit`: the payout has been submitted to the bank, but haven’t yet arrived there. `paid`: the payout has been deposited in the bank account. `failed`: the payout was not accepted by the bank. `canceled`: the payout was cancelled. If including Transactions then this value is duplicated also for each Transaction row so that you can use it in Pivot tables. Values scheduled in_transit paid failed canceled
Date *Export Only*	Date when the Payout was issued. The Date will be in the format so that 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. Values Date
Month *Export Only*	Date in the YYYY-MM format so that you can use it in Pivot tables to aggregate amounts by Month. Values Year-Month Example 2019-01
Currency *Export Only*	The currency code of the Payout. Values Currency
Amount *Export Only*	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. Values Decimal number

Export Only

ID is an 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.

Values

Shopify internal ID

Status

Export Only

Status of the Payout money transfer.

scheduled: payment is collected and is scheduled to be sent to the bank.
in_transit: the payout has been submitted to the bank, but haven’t yet arrived there.
paid: the payout has been deposited in the bank account.
failed: the payout was not accepted by the bank.
canceled: the payout was cancelled.

If including Transactions then this value is duplicated also for each Transaction row so that you can use it in Pivot tables.

Values

scheduled
in_transit
paid
failed
canceled

Date

Export Only

Date when the Payout was issued.

The Date will be in the format so that 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.

Values

Date

Month

Export Only

Date in the YYYY-MM format so that you can use it in Pivot tables to aggregate amounts by Month.

Values

Year-Month

Example

2019-01

Currency

Export Only

The currency code of the Payout.

Values

Currency

Amount

Export Only

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.

Values

Decimal 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

Column	Description / Example Value
Transaction: ID *Export Only*	ID of the Payout Transaction. Values Number
Transaction: Type *Export Only*	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. Values charge refund dispute reserve adjustment credit debit payout payout_failure payour_cancellation
Transaction: Processed At *Export Only*	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. Values Date & Time
Transaction: Currency *Export Only*	Currency code of the transaction. Values Currency
Transaction: Amount *Export Only*	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. Values Decimal Number
Transaction: Fee *Export Only*	Fee which is deduced from the Amount by Shopify Payments. Values Decimal Number
Transaction: Net *Export Only*	Net amount which is gross amount minus the fees. Values Decimal Number
Transaction: Source ID *Export Only*	ID of the source which caused the Transaction. Usually, that is the Order. Values Number
Transaction: Source Type *Export Only*	A type of the source which caused the Transaction. Values charge refund dispute reserve adjustment payout
Transaction: Source Order Transaction ID *Export Only*	If the transaction was caused by an Order, then the Order Transaction ID will be written in this column. Values Number
Transaction: Source Order ID *Export Only*	If the transaction was caused by an Order, then the Order ID will be written in this column. Values Number
Transaction: Source Order Name *Export Only*	Name of the Order which caused the Transaction. Usually, it looks like #xxxx. Values Text
Transaction: Source Order Checkout ID *Export Only*	Checkout ID from the Order that caused the Transaction. Values Number
Transaction: Test Mode *Export Only*	If the payment was made in the Test Mode, then this value will be TRUE. Values TRUE FALSE

Transaction: ID

Export Only

ID of the Payout Transaction.

Values

Number

Transaction: Type

Export Only

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.

Values

charge
refund
dispute
reserve
adjustment
credit
debit
payout
payout_failure
payour_cancellation

Transaction: Processed At

Export Only

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.

Values

Date & Time

Transaction: Currency

Export Only

Currency code of the transaction.

Values

Currency

Transaction: Amount

TRUE
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 on or after on or before date range relative date

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

on or after
on or before
date range
relative date

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.

Excel Sheet Name

Need a quick start?

Columns Available For Export

Basic Columns

Values

Values

Values

Values

Example

Values

Values

Transactions

Values

Values

Values

Values

Values

Values

Values

Values

Values

Values

Values

Values

Values

Values

Export Filters

Possible Conditions

Good To Know

Start managing your Shopify data today!