ÃÛ¶¹ÊÓƵ

Payouts Report

Payment Services for ÃÛ¶¹ÊÓƵ Commerce and Magento Open Source offers you comprehensive reporting so that you can get a clear view of your store’s transactions, orders, and payments.

There are two available Payouts reporting views to enable you to see in-depth information about all of your payouts:

  • Payouts data visualization view—Chart available on the Payment Services Home that is a visual representation of aggregated amounts per day from the Payouts report view
  • Payouts report view—Report available in Payouts that shows detailed payout information for all transactions

The Payouts views show comprehensive payout information at-a-glance, allowing you full transparency into the payment amount, processed volume, and detailed reporting on the transaction level for financial reconciliation.

You can download payout transactions in a .csv file format for use in existing accounting or order management software.

NOTE
Payouts reports only show orders that are captured (payment action is set to Authorize and Capture)—o°ù marked as Invoiced.

Payouts data visualization view

The Payouts data visualization view is available in the Payment Services Home. It is a visual representation of the aggregated amounts per day from the detailed tabular Payouts report view.

On the Admin sidebar, go to Sales > Payment Services to see the data visualization chart of credits vs. debits and the moving averages over time.

Payout data visualization in the Admin {width="800" modal="regular"}

Click View Report to navigate to the detailed tabular Payouts report view.

Customize transactions timeframe

By default, 30 days of transactions are shown.

From the Payouts data visualization view, you can customize the timeframe for the payout transactions you want to view by selecting a date range:

  1. On the Admin sidebar, go to Sales > Payment Services. The Payouts data visualization view is visible in the Payouts section.
  2. Click the Range selector filter.
  3. Choose the applicable date range—30 days, 15 days, or 7 days.
  4. View the transactions info for your specified dates.

Transactions information

The transaction amounts for a selected date range are shown on the left of the Payouts data visualization view. The dates for the selected date range are shown on the bottom of the view. If there were no payouts on a particular date, that date will not be appear.

The Payouts data visualization view includes the following information.

Data
Description
Transaction amount
Amount range for transactions in specified time frame; data on the Y axis (left)
Date range
Date range for the specified time frame; data on the X axis (bottom)
Credit
Payments for the specified time frame
Debit
Debits (refunds) for the specified time frame
Moving average
Representation of the average payout for each date in the specified time frame
Net for range
Net payout amount for the specified time frame (range)

Payouts report view

The Payouts report view is available in the Payouts view of Payment Services. It includes all available information about payouts for your store(s).

On the Admin sidebar, go to Sales > Payment Services > Payouts > View Report to see the detailed tabular Payouts report view.

Payout transactions in the Admin {width="800" modal="regular"}

You can configure this view, per the sections in this topic, to best present the data you desire to see.

See linked Commerce order and transaction IDs, transaction amounts, payment method per transaction, and more, all within this report.

You can download payout transactions in a .csv file format for use in existing accounting or order management software.

NOTE
The data shown in this table is sorted in descending order (DESC) by default using the TRANS DATE. The TRANS DATE is the date and time when the transaction was initiated.

Select data source

In the Payouts report view, you can select the data source—Live or Sandbox—for which you want to see report results.

Data sources selection {width="300" modal="regular"}

If Live is the selected data source, you can see report information for stores in production mode. If Sandbox is the selected data source, you can see report information stores in sandbox mode.

Data source selections work as follows:

  • If you do not have any stores that are in Live mode, the data source selection defaults to Sandbox.
  • If you have any stores (one or multiple) in Live mode, the data source selection defaults to Live.
  • Report exports always honor the data source selection.

To select the data source for your Order Payment Status report:

  1. On the Admin sidebar, go to Sales > Payment Services > Payouts > View Report.

  2. Click Data source and select Live or Sandbox.

    The report results regenerate based on the data source selected.

View transactions

By default, 30 days of transactions are shown.

The number of rows returned in a search, or shown in the default 30 days of transactions, are shown above the Payouts view grid alongside the Transaction dates calendar selector filter.

Scroll to the left and right to view information for each payout transaction in the daily report, including transaction date, reference ID, invoice number, and payment method details.

Customize transactions timeframe

From the Payouts report view, you can customize the timeframe for the payout transactions you want to view by entering specific dates or selecting a date range from the date picker:

  1. On the Admin sidebar, go to Sales > Payment Services > Payouts > View Report.
  2. Click the Transaction dates calendar selector filter.
  3. Choose the applicable date range.
  4. View the payouts statuses in the grid for your specified dates.

Show and hide columns

The Payouts report view shows most available columns of information by default. You can, however, customize which columns you see in the report.

  1. On the Admin sidebar, go to Sales > Payment Services > Payouts > View Report.

  2. Click the Column settings icon ( column settings icon {width="20" modal="regular"}).

  3. To customize which columns you see in the report, check or uncheck columns in the list.

    The Payouts report view will immediately show any changes you made in the Column settings menu. The column preferences will be saved and will remain in effect if you navigate away from the report view.

Download transactions

You can download a .csv file containing all the transactions visible in the Payouts view grid.

  1. On the Admin sidebar, go to Sales > Payment Services > Payouts > View Report.

  2. Customize the date range timeframe for your transactions.

  3. Click the Download (

    Download icon {width="20" modal="regular"}

    ) icon.

Your payout transactions are downloaded in a .csv format.

Column descriptions

Payout reports include the following information.

Column
Description
Provider
Payment provider
Provider trans
Transaction ID
Trans date
Date and time transaction was initiated
Type
Transaction type—PAYMENT, BONUS, CHARGEBACK, CORRECTION, CURRENCY_CONVERSATION, DEPOSIT, DISBURSEMENT, DISPUTE, FEES, HOLD, HOLD_RELEASE, INCENTIVES, OTHERS, RECOUP, REFUND, REVERSAL, WITHDRAWAL

See Transaction types for more information.
Status
Current status of the transaction—SUCCESS, DENIED, PENDING
Code
Transaction code that indicates either Credit (CR) or Debit (DR)
Reference ID
Original transaction ID for which this event is related
Invoice
Invoice ID (one per order) of the transaction
Commerce order
Commerce order ID

To see related order info, click the ID.
Commerce trans
Commerce transaction ID
Pay method
Credit card type—BANK, PAYPAL, CREDIT_CARD—and associated card provider (such as Visa or MasterCard)
TRANS AMT
Amount of the transaction
CUR
Currency unit for transaction amount
PENDING
Amount yet to be disbursed
CUR
Currency unit for the pending amount
SELLER AMT
Amount of funds transferred to or from a customer

Funds moving out of the seller account show a dash (-) prefix.
CUR
Currency unit for the seller amount
PARTNER FEE
Partner fees associated with the transaction

Funds moving out of the partner fee account show a dash (-) prefix.
CUR
Currency unit for the partner fee
PROV FEES
Fees associated with the transaction

Funds moving out of the provider’s fee account show a dash (-) prefix.
CUR
Currency unit for the provider fee
FEE %
Percentage of the transaction amount charged as a fee
FIXED FEE
Fixed provider fee amount
CHBK FEE
Chargeback fee associated with the transaction

A dash (-) prefix indicates that the chargeback fee was reversed.
CUR
Currency unit for the chargeback fee
HOLD AMT
Amount put on hold or released from hold

A dash (-) prefix indicates that on-hold funds are being released.
CUR
Currency unit for the hold amount
RECOUP AMT
Amount recouped from the recoup account

Funds moving out of the recoup account show a dash (-) prefix.
CUR
Currency unit for the recoup amount

Transaction types

These transaction types may be noted in the payout transactions.

Report
Description
PAYMENT
Money moved between a buyer and a seller for an order
AUTH
Authorization and authorization void transactions
BONUS
–
CHARGEBACK
Chargeback fee and chargeback fee reversal transactions
CORRECTION
–
CURRENCY_CONVERSION
–
DEPOSIT
–
DISBURSEMENT
–
DISPUTE
–
FEES
Partner fees, payment fees, and fee reversal transactions
HOLD
–
HOLD_RELEASE
–
INCENTIVES
–
OTHERS
–
RECOUP
Recoups from bank or loss accounts
REFUND
–
REVERSAL
–
WITHDRAWAL
–
recommendation-more-help
87189544-c8b9-4aef-af07-ed3578763c38