Skip to main content
Skip table of contents

Reporting Values

This article describes the column field values in downloaded files of Payrix Pro portal reports.

As a Payrix Pro portal Referrer or Merchant, you can download generated reports to your device as a CSV or XLS file for further analysis and recordkeeping.

The table provides description and additional information for field values that display as column headings in the top row of the file. The field values that display in a downloaded file vary, depending on the following factors:

  • The specific report.

  • The role of the person who generated the report, either Referrer or Merchant.

  • Any filter options set when the report was generated, including the use of a template.

See also:

Field

Description

Notes

Date

Date of the report (YYYY-MM)

None

Entity ID

Unique identification number that is used to represent an entity. This is generated by the Platform.

None

Entity Type

Each unique identification number represents either a referrer or merchant.

None

Entity Name

Legal business name of the merchant or official name of the referrer

None

Entity DBA

Name that the entity is Doing Business As

None

Entity Custom

Indicates if the entity has an active custom data set

None

Merchant ID

Merchant Identification Number (MID)

None

Merchant Name

Name of the Merchant Business

None

Merchant Boarded

The date the merchant was boarded on the platform

None

Merchant DBA

Merchant Doing Business As

None

Merchant Custom

Merchant Custom Description

None

Login Name

Primary platform portal login for the Merchant account

None

Txn ID

Unique identifier of a transaction

None

Txn Type

Sales, Refund, Reverse Authorization, eCheck Sale (ACH)

None

Created

Time the transaction was created and/or authorized

None

Captured

Time the authorized transaction was batched out

None

Status

Settled (Batched Out), Approved (Successfully authorized), Failed (Decline)

None

Cardholder

Name on Card

None

Company

Name of Company of Card Holder (if business card)

None

Description

Client description of bank account

None

Order Number

Order Number

None

Card Brand

Card Brand (Visa, MasterCard, Discover, or AMEX) or Bank Account (ACH)

None

Card Type

Type of Card (Debit, Credit, Prepaid) or eCheck (ACH)

None

BIN Routing

Bank Identification Number specific to issuing pay

None

Last Four

Last Four of Card Number

None

Origin

eCommerce (card not present) or Terminal (card present)

None

Imported

TRUE: Payment is not moving through our gateway
FALSE: Payment process through gateway

None

Card Present

TRUE: Card present transaction
FALSE: ard not present transaction

None

Amount

Amount of transaction at initial authorization

None

Approved

Approved amount of transaction

None

Net

Final amount of transaction after settlement

None

Refunded

Refunded amount if applicable

None

AMEX Sale Volume

Total count of AMEX sales

None

AMEX Refund Volume

Total count of AMEX refunds

None

AMEX Net Volume

Total of AMEX net sales

None

AMEX Txn Count

Total count of AMEX transactions

None

Visa Sale Volume

Total count of VISA sales

None

Visa Refund Volume

Total count of VISA refunds

None

Visa Net Volume

Total of VISA net sales

None

Visa Txn Count

Total count of VISA transactions

None

MC Sale Volume

Total count of MasterCard sales

None

MC Refund Volume

Total count of MasterCard refunds

None

MC Net Volume

Total of MasterCard net sales

None

MC Txn Count

Total count of MasterCard transactions

None

Discover Sale Volume

Total count of Discover sales

None

Discover Refund Volume

Total count of Discover refunds

None

Discover Net Volume

Total of Discover net sales

None

Discover Txn Count

Total count of Discover transactions

None

eCheck Sale Volume

Total count of eCheck sales

None

eCheck Refund Volume

Total count of eCheck refunds

None

eCheck Net Volume

Total of eCheck net sales

None

eCheck Txn Count

Total count of eCheck transactions

None

Other Sale Volume

Total count of other sales

None

Other Refund Volume

Total count of other refunds

None

Other Net Volume

Total of other net sales

None

OTHER Txn Count

Total count of other transactions

None

Total CC Sale Volume

Total count of credit card sales

None

Total CC Refund Volume

Total count of credit card refunds

None

Total Net CC Volume

Total of Credit Card net sales

None

Total eCheck Sale Volume

Total count of eCheck sales

None

Total Check Refund Volume

Total count of eCheck refunds

None

Total Net Check Volume

Total count of net eCheck sales

None

Total Net Volume

Total count of net sales

None

Total Txn Count

Total count of transactions

None

Int Type

Interchange Category Type which determines the interchange fee pricing.

None

Int Percentage

Interchange volume-based percentage of transaction amount.

Interchange percentage assessed to the transaction, based on card type/card brand on the volume (amount) of the transaction. Interchange rates are published by the card brands and updated twice a year (April and October.).

None

Int Flat

Interchange fee assessed on a Per Item basis. These rates are published by the card brands and updated twice a year (April and October).

None

Int Amount

Total Interchange fees (INT PERCENTAGE + INT FLAT) assessed on the transaction, reflected as a dollar amount.

None

Assessments

Total of all assessment fees (fees charged by card brands) reported on a per transaction basis

None

Payrix Pro Fees

Reflects the Payrix Pro Buy-Rates

None

Merchant Cost

Fee charged to merchant by referrer

None

Merchant Cost Refund

Total Fee Refunded to the merchant

None

Merchant Net

Total settled amount lesser Vendor fees. This column reflects the total final amount disbursed to the merchant. If a partner is on statement entries this would be totaled monthly.

None

Vendor Fee

Fee charged to merchant by referrer

None

Vendor Fee Refund

Total Fee Refunded to the Vendor. This field only populates on transactions associated with refunds.

None

Vendor Cost

Total fee cost to Referrer/Partner, calculated as sum of “INT AMOUNT”, “ASSESSMENTS” and “PAYRIX FEES”.

None

Vendor Cost Refund

Vendor Cost that is refunded

None

Vendor Net

Total Revenue to Referrer/Partner based on transaction level

None

Disbursement ID - Payout

This is the Disbursement ID of the payout, an event line item.

Available for Balance Details and Statement Details reports only.

Note: Contact your relationship manager to enable this setting.

Disbursement ID - Payout Status

Status of the disbursement payout

Available for Balance Details and Statement Details reports only.

Note: Contact your relationship manager to enable this setting.

Disbursement ID - Line Item

Displays individual entry items for a balance disbursement

Available for Balance Details report only.

Note: Contact your relationship manager to enable this setting.

Disbursement ID - Line Item Status

Status of the balance disbursement line item

Available for Balance Details report only.

Note: Contact your relationship manager to enable this setting.

Disbursement Entry Status

Status of balance disbursement entry

Available for Balance Details report only.

Note: Contact your relationship manager to enable this setting.

Reference Entity

Displays the paying or collecting entity reference number

Available for Statement Details report only.

Reference Entity Name

Displays the name of the entity

Available for Statement Details report only.

From Entity Name

Displays the name of the entity sending the funds (Payer).

This field is always blank when using the merchant view.

Available for Statement Details report only.

To Entity Name

Determines the entity that is receiving the funds. (Collector)

Available for Statement Details report only.

On Entity

Triggering entity that generated the event.

Typically this is the same as the Payer or From entity.

Available for Statement Details report only.

On Entity DBA

The display name of the triggering entity that generated the event.

Available for Statement Details report only.

Date

The date when the statement entry occurred.

Note: This is not the statement billing date.

Available for Statement Details report only.

Statement ID

Statement ID which correlates to the statement ID on the Balance Details Report (STM).

Available for Statement Details report only.

Event

The event type that triggered the fee.

This can include events such as Authorization, Boarding, Capture, Interchange, Refund, and Reverse Authorization.

Available for Statement Details report only.

Event ID

ID of the event triggered

Available for Statement Details report only.

Description

Description of the fee

Available for Statement Details report only.

Total

Total value of the entry within the statement.

Positive values: Collecting funds
Negative values: Paying funds

Available for Statement Details report only.

ID

Statement Entry ID or the unique ID of the entry within the statement (STE)

Available for Statement Details report only.

Original Event ID

ID of the original Event that triggered the fee

Available for Statement Details report only.

<<Discretionary>>

A field that is customizable from the Partner to collect certain information

Available for Transaction Details report only.

Visa Fixed Acquirer Network Fee

Lists all Visa FANF fees; formerly Network Participation Fee or NPF

Available for Profit & Loss, Balance Details and Statement Details reports only.

Visa Transaction Integrity Fee

All Visa TIF fees for transactions using Visa debit and prepaid cards that do not meet Visa CPS (Custom Payment Services) requirements.

Available for Profit & Loss, Balance Details and Statement Details reports only.

Merchant Location Fee

Mastercard Merchant Location Fees

Available for Profit & Loss, Balance Details and Statement Details reports only.

Fee Interchange / Assessments

When the event is interchange this provides more clarity on the assessment

Available for Balance Details and Statement Details reports only.

This field displays for merchants using Interchange Plus (IC+)

This field will not display for merchants using “Flat” fee types.

Fee Interchange / Assessments Rate (% or $)

$ or % depending on the way the fee is set up

Available for Balance Details and Statement Details reports only.

This field displays for merchants using Interchange Plus (IC+)

This field will not display for merchants using “Flat” fee types.

Fee Interchange / Assessments Amount

Total amount of the line-item fee

Available for Balance Details and Statement Details reports only.

This field displays for merchants using Interchange Plus (IC+)

This field will not display for merchants using “Flat” fee types.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.