Transaction Activity Reports

The Transaction Activity reports provide data on all transactions processed by XiPay for the selected source system (i.e. XIID) for the specified day, week, or month.

As indicated by the tan background color, this report pulls from the reporting (RPT) database by default. Any transactions/batches submitted within the timeframe defined in the New Live Transactions/Batches - Last XX Minutes report it will not be included on this page; you must view that report for recently submitted items. They will be available in this report after they are replicated to the RPT database.

The transaction will show up in the report results list if there was any change in Status within the specified timeframe. You can filter reports by Transaction Status Code and limit the maximum number of records. Columns can be added or removed using the Field Chooser.

Run a Transaction Activity Report

  1. From the Reports menu, select the Transaction Activity Report you want to run:

    • Daily = Transactions submitted on the selected date.

    • Weekly = Transactions submitted from Sunday through Saturday of the week in which the selected date falls.

    • Monthly = Transactions submitted from the first to the last day of the selected month and year.

  2. From the Selected Date drop-down list, choose the date (or any date within the week or month) 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 the page reads "No Data to Display"; choose another date and try again.

  6. At the bottom of the report page, the total authorized and settled amounts are displayed for the current page and for all report pages.

  7. Click Export to export the report results to MS Excel. It only exports the fields (columns) that are displayed on the page.

    Columns can be added or removed using the Field Chooser.

    Field Definition

    Server ID

    The Server ID assigned to the transactions.

    Trans 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

    The identification number given by the bank to reference a group of transactions.

    Auth Date and Time

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

    Status

    Most current status of the transaction in XiPay.

    Auth Code

    Authorization code issued by the clearinghouse.

    Auth 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.