You are here: CashBox2100UserGuide > 11 Transactions > 11.1 Searching for Transactions

11.1  Searching for Transactions

To access your Transactions, select Search > Transactions to open the Transaction Search page.

Figure 11-1: Transaction Search Page

1.  Enter your desired search parameters, and use the checkboxes provided to select the data to display.

Note:

If you want to view all transaction information associated with a particular customer, you may find it more useful to do an Account Search to display all AutoBills, Billing History and Activity History associated with the customer.

 

The following table lists available Search fields:

Table 11-1: Transaction Search Page Fields

Field

Matches

Merchant Transaction ID

Enter the complete Transaction ID, including any leading and trailing zeros. Case sensitive.

Processor ID

The name Vindicia uses to identify a CashBox Transaction to the associated payment processor. This is usually the CashBox Merchant Transaction ID. In some cases however, due to the format requirements of some payment processors, CashBox alters the Transaction name before sending it to the processor. In those cases, the name of a transaction in a report by the payment processor will differ from the name of the same transaction in a report by Vindicia. The enables you to reconcile the original CashBox Transaction name with the altered Transaction name CashBox sends to the payment processor, to identify the Transaction.

Merchant Customer ID

Enter the complete Merchant Customer ID, including leading and trailing zeros. Case sensitive.

Customer Email

Enter the entire email address of the customer. Case insensitive.

Affiliate ID

Enter the complete Affiliate ID. Case sensitive.

Payment Method Type

Select a payment type from the dropdown list.

For more information on Payment Method fields, see Table 3-2: CashBox Payment Method Parameters

(Boleto) Fiscal Number

Enter the customer’s full fiscal number ((CPF/CNPJ).

Credit Card Number

Enter either a full credit card number or the last four digits of the card.

Carrier Billing Phone Number

Enter either the regular or encoded phone number.

Direct Debit Account Number

Enter a full or partial bank Account number.

Direct Debit Bank Sort Code

Enter the full bank sort code.

(ECP) Account Number

Enter either a full bank Account number of the last four digits of the Account number for the ECP.

(ECP) Account Routing Number

Enter the full bank routing number for the ECP.

PayPal Email Address

Enter the email address associated with the PayPal account.

Token Type

The default selection and only choice is All.

 

Check Printer Friendly to produce printable results. Click Choose display columns to specify the information shown on the Transactions List page when CashBox processes your search.

 

The following table describes the available display options.

Table 11-2: Transactions Search Page: Display Options

Field

Description

Order #

Checked by default. When checked, displays the order number for each listed Transaction in the search results.

Processor ID

The name Vindicia uses to identify a CashBox Transaction to the associated payment processor. This is usually the CashBox Merchant Transaction ID. In some cases however, due to the format requirements of some payment processors, CashBox alters the Transaction name before sending it to the processor. In those cases, the name of a transaction in a report by the payment processor will differ from the name of the same transaction in a report by Vindicia. The enables you to reconcile the original CashBox Transaction name with the altered Transaction name CashBox sends to the payment processor, to identify the Transaction.

Transaction Date

Checked by default. When checked, displays the Transaction date for each listed Transaction in the search results.

Status

Checked by default. When checked, displays the current status of each listed Transaction in the search results.

Payment Type

If checked, displays the Payment Method for the Transaction in the search results.

Transaction Amount

Checked by default. When checked, displays the monetary amount of each listed Transaction in the search results.

Affiliate ID

If checked, displays the affiliate ID of each listed Transaction in the search results, if any.

Chargeback Risk

Checked by default. When checked, displays the chargeback risk assigned to each listed Transaction in the search results.

Geo/IP Distance

If checked, displays the physical distance between the customer’s IP address and the customer’s billing address for each listed Transaction in the search results. Distance can be a factor in determining chargeback risk.

Customer Email

If checked, displays the email address associated with each listed Transaction in the search results.

Account #

If checked, displays the account number for the Payment Method associated with each listed Transaction in the search results.

Customer ID

If checked, displays the merchant-specific ID for the customer associated with each listed Transaction in the search results.

Exceptions

If checked, displays any exception related to each listed Transaction in the search results, if any.

VID

If checked, displays the Transaction VID.

Billing Cycle

Lists whether a Transaction was the initial or subsequent Billing Cycle on the AutoBill. 0 (zero) indicates an initial Billing Cycle; any number greater than zero indicates a subsequent Billing Cycle.

Note: The Billing Cycle number is based on the Billing Plan, which may include free Billing Cycles. This number will include both free and paid Billing Cycles.

Retry Number

The number of retry attempts to bill for this transaction. This index begins with 0 for the initial attempt to charge for a particular billing. A value of 1 indicates the first retry, 3 indicates the third retry, and so on. For one-time transactions, this value is null.

Original Billing Date

Lists the date of the original transaction attempt for this billing period—null for one-time transactions or any transaction not part of an AutoBill.

 

2.  Click the Submit button to process your search request.

CashBox processes your search request and displays a list of Transactions that match your criteria on the Transaction List page.

Figure 11-2: Transaction List Page

In some cases you may see more information than you requested from the Search page. For example, if you request the amount of each Transaction, the Transaction List page also displays the Currency type in the CUR column. (Currency is displayed in ISO-4217 three-letter format.)When Transaction amounts are displayed, any refund amounts are also displayed. If a Transaction is fully or partially refunded, the Status column, when displayed, shows a status of “Refunded.” The Tx Amount column always displays the original Transaction amount, and the Tx Refunds shows the refunded amount (which will always be less than or equal to the Tx Amount).

When displayed in search results, the Transacted In and Token Type fields show only that Tokens were used as a payment method for the Transaction. They will not indicate whether or not a Transaction resulted in granting Tokens to a customer. For information about viewing Token balances related to the customer Account associated with a Transaction, see Section 9.5: Searching for Token Activity.

The Status column, when displayed, indicates the current processing state for each Transaction.

 

The following table describes CashBox Transaction statuses:

Table 11-3: Transaction List Page: Status Definitions

Status

Description

Captured

Payment processor successfully captured the Transaction.

Cancelled

The Transaction was cancelled because of a hard or soft failure, or because the merchant chose not to capture the transaction, for example, based on fraud screen result.

Refunded

The Transaction was successfully refunded, either fully or partially.

The amount of the refund is displayed in the Tx Refund column to the right of the Tx Amount column. If the Tx Refund amount is the same as the Tx Amount, the Transaction was fully refunded, and if Tx Refund is less than Tx Amount, the Transaction was partially refunded.

New

Transaction is created, but not yet submitted for payment.

Authorized

Transaction is successfully authorized and awaiting a capture call.

Auth Expired

Transaction was Authorized, but no Capture was made within the payment processor’s authorization time frame and the authorization has expired.

Authorized for Validation

Transaction is successfully validated (for example, $1.00 authorization).

Deposit Retry Pending

Transaction is being retried within the payment processor system (ECP Transactions only).

Authorized Pending

Transaction passed authorization with the payment processor and the capture of funds is pending.

Authorization Pending

Transaction is created (customer clicked the PayPal button on a merchant site), but has not completed the PayPal payment process.

Note: Customer has three hours to complete the transaction before it times out. If the transaction times out, Status remains Authorization Pending indefinitely.

Void

Transaction previously classified as Auth Expired has been reversed.

Note: Voiding a transaction avoids Visa fees for Authorizations that are not captured.

Undefined (Status column is empty)

Transaction has not yet been submitted to payment processor. This may be because the Transaction is currently in the middle of processing when viewed.

A summary of all Transaction results totaled by Transacted In and Transaction status appears below the list of Transactions displayed on the Transaction List page. For example, Figure 11-3: Transaction List Page: Totals shows the totals for the list of Transactions shown in Figure 11-2:

Figure 11-3: Transaction List Page: Totals

Click the Download results as CSV link to download the Transaction list to a CSV file.

Your browser displays its standard Save As dialog box, where you are prompted to provide a name for the downloaded file, and to specify a location to store it.

Click Issue Multiple Full Refunds... at the upper right of the page to issue refunds on multiple listed transactions. For more information, see Section 11.3: Transaction Details.

Click an Order # to open the Transaction Details page for the selected Transaction. For more information, see Section 11.3: Transaction Details.