Transactions Report

Last update: 2024-01-25
  • Created for:
  • Intermediate
    User

Payment Services for Adobe 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.

Transactions report

The Transactions report provides visibility into transaction authorization rates and negative transaction trends so that you can effectively monitor the health of your store and preemptively identify and address any transaction issues.

See individual transactions for orders placed on the storefront and their payment methods, result, payment response codes, and more.

The information provided in the Transactions report is intended only for merchant use. Do not share this info with customers or other potential fraudsters. Transactions information could be used to bypass security checks or place orders that result in chargebacks.

You can download the Transactions report in a .csv file format for use in existing accounting or order management software.

NOTE

You cannot view financial reports if you have not onboarded and activated Live mode for Payment Services.

Transactions report view

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

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

Transactions report view

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 provider transaction IDs, transaction amounts, payment method per transaction, and more, all within this report.

Not all payment methods provide the same granularity of information. For instance, credit card transactions provide response, AVS, and CCV codes, and the last four digits of the card in the Transactions report; PayPal payment buttons do not.

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

Select data source

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

Data sources selection

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

Data source selections work as follows:

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

To select the data source for your Transactions report:

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

  2. Click Data source and select Live or Sandbox.

    The report results regenerate based on the data source selected.

Customize dates timeframe

From the Transactions report view, you can customize the timeframe of the transactions you want to view by selecting specific dates. By default, 30 days of transactions are shown in the grid.

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

Filter report info

From the Transactions report view, you can filter the statuses results you want to view by selecting filter criteria.

  1. On the Admin sidebar, go to Sales > Payment Services > Transactions > View Report.
  2. Click the Filter selector.
  3. Toggle the Transaction Result options to see report results for only selected order transactions.
  4. Select the Card Type to see report results for the selected card type. A tooltip with more information is shown when the payment processor is unable to identify the card type.
  5. Select the Card Brand to see report results for the selected card brand. A tooltip with more information is shown when the payment processor is unable to identify the card brand.
  6. Toggle the Payment Method options to see report results for only selected payment methods.
  7. Enter a Min Order Amount or Max Order Amount to see report results within that order amount range.
  8. Enter an Order ID to search for a specific transaction.
  9. Enter the Card Last Four Digits to search for a specific credit or debit card.
  10. Click Hide filters to hide the filter.

Show and hide columns

The Transactions report shows all available columns of information by default. You can, however, customize which columns you see in your report.

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

  2. Click the Column settings icon column settings icon.

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

    The Transactions report immediately shows any changes you made in the Column settings menu. The column preferences are saved and remain in effect if you navigate away from the report view.

Update report data

The Transactions report view shows a Last updated timestamp that shows the last time that the report information was updated. By default, Transactions report data is auto-refreshed every three hours.

You can also manually force a refresh of the report data to see the most up-to-date report information.

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

  2. Click the Refresh icon (refresh icon).

    The Transactions report data is refreshed, an Update complete confirmation appears, and the latest information is present in the grid.

Download transactions

You can download a .csv file with all transactions visible in the transactions view grid, whether you are viewing the default 30 days of transactions or a customized timeframe.

  1. On the Admin sidebar, go to Sales > Payment Services > Transactions.
  2. If you want to see transactions for a timeframe other than the last 30 days, customize the date range timeframe for your statuses.
  3. Click the Download download icon icon.

Your transactions are downloaded in a .csv format.

Column descriptions

Transactions reports include the following information.

Column Description
Order ID Commerce order ID (contains only values for successful transactions and is empty for rejected transactions)

To see related order info, click the ID.
Provider Transaction ID Transaction ID provided by the payment provider; contains only values for successful transactions and contains a dash for rejected transactions.
Transaction Date Transaction date timestamp
Payment Method Payment method of transaction with detailed information about brand and card type. See card types for more information; available for Payment Services versions 1.6.0 and newer
Card Last Four Digits Last four digits of the credit or debit cards used for the transaction
Result The result of the transaction—OK (successful transaction), Rejected by Payment Provider (rejected by PayPal), Rejected by Bank (rejected by bank that issued card)
Response Code Error code that provides rejection reason from payment provider or bank; see list of possible response codes and descriptions for Rejected by Bank status and Rejected by Payment Provider status.
AVS Code Address Verification Service code; the processor response information for payment requests. See list of possible codes and descriptions for more information.
CVV Code Card verification value code for credit and debit cards; see list of possible codes and descriptions for more information.
Amount Order amount of transaction
Currency Currency used for order in transaction
Type Payment action for transaction—Authorize or Authorize and Capture

Error response codes

The Response Code column shows a specific error or success code related to the transaction. Some common error codes you might see displayed include:

  • PAYMENT_DENIED—Transaction was declined by PayPal because it was suspected to be fraud.
  • INTERNAL_SERVER_ERROR—Transaction was declined by PayPal and incurred a PayPal server error. The transaction can be retried.
  • INSTRUMENT_DECLINED—Customer was declined by PayPal per selected payment method. Transaction can be retried with a different payment method.
  • 9500—Transaction was declined by the associated bank because it was suspected to be fraud.
  • 5120—Transaction was declined by the associated bank because the customer had insufficient funds for the payment.
  • 5650—Transaction was declined by the associated bank because the bank requires strong customer authentication (3DS).

Detailed error response codes for failed transactions are available for transactions newer than June 1, 2023. Partial report data will appear for transactions that occurred before June 1, 2023.

On this page