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:
Create and Manage Reports for descriptions of the delivered reporting functionality.
Available Portal Reports for a list of all reports, descriptions and samples.
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 |
| None |
Card Present |
| 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 | 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. |