Skip to main content

Payout Fields

Transactions between your Shopify Payments account and your connected bank account

Updated this week

Note: Payouts are export-only and cannot be imported or updated through Altera.

General

ID

Description

Example Value

Shopify's unique payout identifier - Export only

789012345

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

paid

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

2024-03-22

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

2024-03

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

USD

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

2847.93

The total decimal amount of the payout transferred to your bank account. This field is export-only and cannot be imported.

Transactions

Transaction: ID

Description

Example Value

Unique identifier for the transaction - Export only

456123789012

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

charge

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

2024-03-22 09:15:00 -0400

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

USD

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

275.00

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

8.25

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

266.75

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

321654987123

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

charge

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

654789321456

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

789456123098

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

#2847

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

147258369741

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

FALSE

  • 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:

  • status: Filter by payout status (scheduled, in_transit, paid, failed, canceled)

  • date: Filter by payout date

  • currency: Filter by currency code

  • amount: Filter by payout amount

Did this answer your question?