Transaction Status Reports

Transaction Status reports provide details about all transactions matching the status (authorized, staged, settled, etc.) for the selected source system (XIID).

The default sorting for the columns on all pages is by Date/Descending. You can drill down into the transaction information screen by clicking the hyperlinked Transaction ID or Batch ID number.

Report Descriptions

Report descriptions include the following.

All

The All Transactions report lists all transactions processed by the XiPay server for the selected system, regardless of transaction status, within the given time period.

Use the All Transactions Report when you are interested in transactions of various statuses within the same time period, or when there is no featured report available for the specific transaction status for which are looking.

Authorized

The Authorized Transactions Report lists all transactions authorized but not yet settled (Status 100). This view allows the user to distinguish the number of transactions at this stage, and access to each of those transactions.

Credit

The Credits Report lists all transactions with negative totals. To comply with XiPay and SAP workflow, credits follow the same authorization and settlement procedure as normal debit transactions.

Staged

The Staged Transaction Report lists all transactions authorized, but not yet settled (Status 200, 210, and 300). This report lists the number of transactions at this stage, and allows access to each transaction. The transactions at this stage represent orders that have been pre-authorized and that have been granted authorization for settlement, captured. Click the Batch ID value to drill down into the batch detail information.

In Progress

The Staged Transaction Report lists all transactions authorized, but not yet settled (Status 200, 210, and 300). This report lists the number of transactions at this stage, and allows access to each transaction. The transactions at this stage represent orders that have been pre-authorized and that have been granted authorization for settlement, or "captured".

Settled

The Settled Transactions Report lists processed batches with totals of transactions that have been fully settled (Status 400). In a production setting, this report provides quicker access to batches of transactions that have completed both the authorization and settlement process.

Each line item given represents any number of transactions, organized by a batch identification number.

Errors

The Errors Transactions Report lists all the transactions in the XiPay database for the environment that incurred an error, abortion, or failure during some part of the authorization and/or settlement process (resulting in a negative status code). This report isolates these transactions.

Sales

All, Open, or Closed Sales

The Sales reports includes transactions that were submitted to XiPay using the Sale Operation (rather than the standard two-step Auth & Settle workflow) for the selected environment, by status. Choose Open Sales or Closed Sales to limit the displayed results by status, or choose All Sales to include all Open and Closed sales at the same time.

Run a Transaction Status Report

  1. From the Reports menu, select the Transaction Status Report you want to run (All, Authorized, Credits, Staged, In Progress, Settled, or Errors).

  2. From the Report Date Start and End drop-downs, choose the date range whose data you want displayed in the report.

  3. You can limit the report to display only transactions of a given status, using the Status Code drop-down.

  4. You can limit the report to display a maximum number of records, using the Records Limit drop-down.

  5. Click Apply. If transactions exist for the date chosen, the report opens. If no transactions exist, a No Data to Display message is displayed; choose another date and try again. The following table provides more details about the columns included in the All Transactions Report.

    Column Description

    Server ID

    The Server ID assigned to the transactions.

    Transaction ID

    Number issued by XiPay to identify a specific transaction.

    PO Number

    The purchase order number associated to the transaction for business purposes to reconcile the purchase request.

    Sales Order #

    The sales order number associated to the transaction by the merchant.

    Batch ID

    The identification number to organize batch settlements. This ID number is assigned by either the source system or XiPay and does not affect reference batch numbers the clearinghouse.

    Bank Batch ID

    Transaction ID assigned by the bank to the authorized or settled credit card transaction.

    Authorization Date and Time

    Time and date of the initial authorization request given by XiPay.

    Status

    Current status of the transaction in XiPay.

    Authorization Code

    Authorization code issued by the clearinghouse.

    Authorization Amount

    Amount the transaction was authorized.

    Settle Amount

    Settled total of the transaction, if it has been settled. This column will be blank for all transactions not yet settled.

    Currency

    Displays the currency type.