Note: Payouts are export-only and cannot be imported or updated through Altera.
If your store has multiple business entities (legal entities), payouts from every entity are combined into a single export. The Business Entity column tells you which entity each payout belongs to, and you can use the Business entity filter to export payouts for just one entity.
General
ID
Description | Example Value |
Shopify's unique payout identifier - Export only |
|
The unique identifier generated by Shopify for the payout. This field is export-only and cannot be imported.
Status
Description | Example Value |
Current status of the payout transfer - Export only |
|
The current status of the payout transfer. Possible values:
scheduled: Payment is collected and scheduled to be sent to the bank
in_transit: Payout has been submitted to the bank but not yet arrived
paid: Payout has been successfully deposited in the bank account
failed: Payout was not accepted by the bank
canceled: Payout was cancelled
This field is export-only and cannot be imported.
Date
Description | Example Value |
Date when the payout was issued - Export only |
|
The date when the payout was issued by Shopify Payments. This field is export-only and cannot be imported.
Month
Description | Example Value |
Year-month format for aggregation - Export only |
|
The year-month format useful for aggregation in reports. This field is export-only and cannot be imported.
Currency
Description | Example Value |
Currency code of the payout - Export only |
|
The three-letter currency code of the payout. This field is export-only and cannot be imported.
Amount
Description | Example Value |
Total decimal amount of the payout - Export only |
|
The total decimal amount of the payout transferred to your bank account. This field is export-only and cannot be imported.
Business Entity
Description | Example Value |
Business entity the payout belongs to - Export only |
|
The display name of the business entity (legal entity) the payout belongs to. Stores with a single business entity will see the same name on every row. This field is export-only and cannot be imported.
Trace ID
Description | Example Value |
Bank trace reference for the payout - Export only |
|
A unique trace reference from the financial institution that processed the payout. Use it to match a payout against the deposit on your bank statement. Not every payout has one. This field is export-only and cannot be imported.
Transactions
Transaction: ID
Description | Example Value |
Unique identifier for the transaction - Export only |
|
The unique identifier for the individual transaction within the payout. This field is export-only and cannot be imported.
Transaction: Type
Description | Example Value |
Type of transaction - Export only |
|
The type of transaction. Common transaction types include:
charge: Payment charged to customer
refund: Refund issued to customer
dispute: Chargeback or dispute transaction
reserve: Amount held in reserve
adjustment: Manual adjustment to account
credit: Credit added to account
debit: Debit removed from account
payout: Actual payout transfer (typically negative amount)
payout_failure: Failed payout transaction
payout_cancellation: Cancelled payout transaction
This field is export-only and cannot be imported.
Transaction: Processed At
Description | Example Value |
Date and time when transaction was processed - Export only |
|
The timestamp when the transaction was processed. This field is export-only and cannot be imported.
Transaction: Currency
Description | Example Value |
Currency code of the transaction - Export only |
|
The three-letter currency code of the transaction. This field is export-only and cannot be imported.
Transaction: Amount
Description | Example Value |
Gross transaction amount (includes fees) - Export only |
|
The gross transaction amount before fees are deducted. This field is export-only and cannot be imported.
Transaction: Fee
Description | Example Value |
Fee deducted by Shopify Payments - Export only |
|
The fee amount deducted by Shopify Payments for processing the transaction. This field is export-only and cannot be imported.
Transaction: Net
Description | Example Value |
Net amount after fees are deducted - Export only |
|
The net amount after fees are deducted from the gross amount. This field is export-only and cannot be imported.
Transaction: Source ID
Description | Example Value |
ID of the source that caused the transaction - Export only |
|
The unique identifier of the source object that caused this transaction. This field is export-only and cannot be imported.
Transaction: Source Type
Description | Example Value |
Type of source that caused the transaction - Export only |
|
The type of source that caused the transaction. Common source types include:
charge: Customer payment
refund: Customer refund
dispute: Chargeback or dispute
reserve: Reserved funds
adjustment: Manual account adjustment
payout: Payout transfer
This field is export-only and cannot be imported.
Transaction: Source Order Transaction ID
Description | Example Value |
Order transaction ID if source was an order - Export only |
|
The order transaction ID if the transaction originated from an order. This field is export-only and cannot be imported.
Transaction: Source Order ID
Description | Example Value |
Order ID if transaction originated from order - Export only |
|
The order ID if the transaction originated from an order. This field is export-only and cannot be imported.
Transaction: Source Order Name
Description | Example Value |
Order name that caused the transaction - Export only |
|
The order name (number) that caused the transaction. This field is export-only and cannot be imported.
Transaction: Source Order Checkout ID
Description | Example Value |
Checkout ID from the originating order - Export only |
|
The checkout ID from the originating order that caused the transaction. This field is export-only and cannot be imported.
Transaction: Test Mode
Description | Example Value |
Whether payment was made in test mode - Export only |
|
TRUE: Payment was made in test mode
FALSE: Payment was made in live mode
This field is export-only and cannot be imported.
Export Filters
You can use these filters to limit which payouts are exported:
Payout Date: Filter by the date the payout was issued
Business entity: Export payouts for a single business entity. Leave this filter off to combine payouts from all business entities.