Purchase & Refund Details Report

Purchase & Refund Details Report

The Purchase & Refund Details report lists (for a specific date) transaction data for all purchases and refunds processed by a merchant entity and the transaction fees that will result in an adjustment to the funding amount. The report defaults to the most current day for which information is available.

Generating the Report

To display the report directly on the Merchant Account Reports page, follow these steps:

Step 1

From the Hierarchy menu, select a hierarchy. The values in the hierarchy represent your merchant ID(s) and hierarchy ID. The hierarchy ID is the numerical identifier used to represent a hierarchy level. For more information on the hierarchy structure, see Hierarchy“.

Step 2

From the Report menu, select the Purchase & Refunds report, or select All to generate all reports.

Step 3

From the Frequency menu, select Daily or Custom.

Selecting Custom displays the Start Date field and End Date field, in which you enter appropriate dates.

Step 4

Click Submit.

A link to the report appears at the bottom of the page.

Step 5

To view the report in the Web browser, click on the Purchase & Refund Details link at the bottom of the page, or click View.

The report appears in the Web browser. Click the tabs at the top of the report to view the report data.

Step 6

To export the results in XML or CSV formats, click the associated link.

For merchants processing multiple currencies, the XML and CSV formats group the currencies together within the report.

If viewed in a Web browser, the top of the report will contain the fields for selecting the report criteria. You can select new criteria and click Submit to regenerate the report.

Viewing Additional Information

For detailed information about a transaction, click the Request ID number in the report. The Transaction Search Details results appear for that transaction, as shown below.

Below is the Payment Information section:

The table below describes each field in the Purchase & Refunds report.

Table 1

Purchase & Refunds Details Report

Header Section Fields

Hierarchy represents your organization structure. If you have not worked with CyberSource to define a customized hierarchy, the values in the hierarchy drop-down will represent your merchant IDs. If your company has more than one hierarchy level, you may choose a particular level to see activity aggregated on a particular report. You can use either the Hierarchy Level or the Hierarchy ID field to choose the level you wish to view. The corresponding ID or level field will automatically be adjusted.

Date the transactions in this report were processed by CyberSource.

Table 2

Purchase & Refunds Details Report

Report Section Fields

Request ID of the transaction.

CyberSource merchant ID.

Merchant ID assigned by the processor.

Hierarchy ID of the purchase or refund transaction.

Purchase Trans Ref Number

Transaction reference number assigned by CyberSource.

Merchant Ref Number

Reference number assigned to the purchase transaction by the merchant.

Transaction Type

Value defining the transaction type (Purchase or Refund).

Purchase/ Refund Submission Date

Date of the purchase or refund transaction.

Amount of the purchase or refund transaction. Amount in parentheses ( ) denotes a negative number.

Transaction Amount Currency

Transaction currency code.

Method of payment used in the original transaction: MasterCard, Visa, Discover, or American Express.

Mode of payment, such as credit card.

Last 4 digits of the account number.

CYBS Batch Date Time

Date and time the transaction was batched at CyberSource for submission to the processor.

Batch ID assigned by CyberSource.

Reference to the card product type used to define the interchange qualification level.

Indicates the Debit Network used for this transaction.

Auth Trans Ref Number

Transaction reference number of the authorization.

Date of the original authorization transaction.

Auth Request ID

Request ID of the original authorization transaction.

Amount of the associated authorization transaction.

Auth Currency Code

Currency code of the authorization transaction.

Authorization code returned by the issuer for the associated authorization transaction.

Auth Response Code

CyberSource response code to the authorization request that was associated with the purchase.

Interchange Description *

Description of the interchange qualification level. Interchange Qualification is used to determine the fees due to the card issuing banks for processing of payment transactions through the payment networks.

Interchange Percentage *

Fee paid to the issuing banks that is calculated as a percentage of the purchase amount which applies to the purchase transaction.

Interchange Percentage Amount *

Amount calculated when the interchange percentage is applied to the value of the purchase transaction. This amount is passed to the issuing bank.

Interchange Per Item Fee *

Portion of the interchange fee that is calculated as a per-item amount for this transaction.

Discount Percentage

Fee calculated as a percentage of the purchase amount, which may include interchange and other fees bundled together.

Discount Amount

Amount calculated when the discount percentage is applied to the value of the purchase transaction. Amount in parentheses ( ) denotes a negative number.

Discount Per Item Fee

Fee amount assessed for each transaction in addition to the discount percentage.

Total of fees collected for the transaction being reported. Amount in parentheses ( ) denotes a negative number.

Currency in which the fees were collected, which is always the same as the funding currency.

Dues and Assessments

Assessment fees paid to the card associations.

Merchant Defined Field 1

Field reserved for merchant to define.

Merchant Defined Field 1

Field reserved for merchant to define.

Merchant Defined Field 1

Field reserved for merchant to define.

Merchant Defined Field 1

Field reserved for merchant to define.

Amount of the transaction face value in funding currency. Amount in parentheses ( ) denotes a negative number.

Funding Currency

Funding currency code.

Customer’s first name.

Customer’s last name.

* Not applicable to bundled-pricing merchants