Get Excelify now
Get Excelify now

Payouts

Excel Sheet Name

Payouts

Summary

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.

Columns Available For Export

Payouts 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.Number
Status 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.

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

Date

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

Year-Month

2019-01
Currency The currency code of the Payout.

Currency

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.

Decimal Number

Payout Transaction Columns

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.

Number

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.

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

Date & Time

Transaction: Currency Currency code of the transaction.

Currency

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.

Decimal Number

Transaction: Fee Fee which is deduced from the Amount by Shopify Payments.

Decimal Number

Transaction: Net
Net amount which is gross amount minus the fees.

Decimal Number

Transaction: Source ID ID of the source which caused the Transaction. Usually, that is the Order.

Number

Transaction: Source Type A type of the source which caused the Transaction.

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

Number

Transaction: Source Order ID If the transaction was caused by an Order, then the Order ID will be written in this column.

Number

Transaction: Source Order Name
Name of the Order which caused the Transaction. Usually, it looks like #xxxx.

Text

Transaction: Test Mode If the payment was made in the Test Mode, then this value will be TRUE.

TRUE
FALSE

 

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.