Available Portal Reports
This article describes the reports available in the portal to Referrers and Merchants.
The portal offers many different report options for Referrers with essential reports available for their Merchants. These reports can help you understand specific key performance indicators of your business, such as determining how much you’re making on transaction fees and the number of new merchants you’ve boarded.
Note
Reporting functionality is limited in the Sandbox environment because it is not a production environment with validated data and connectivity.
Report Actions
Our robust reporting functionality provides greater insight into the performance and health of your business. To maximize this report data, this section describes the actions you can take to manage and view report data.
Generate Reports
To see report data, you’ll need to generate a new report. Some reports allow for a Quick Reports option in addition to the traditional Include all up-to-date report generation. For more information, see Report Generation Options.
Schedule Reports
To create a convenient autogeneration and email delivery of reports in a recurring interval and time of your choice, use the Schedule Reports option.
View Report Data
Each generated or downloaded report features a set of fields that represent different key reporting information, some specific to each report. For more information about descriptions for individual report columns and field values, see Reporting Values.
Sort and Filter Report Data
Our reports offer robust searching, sorting, and filtering options. These data viewing options can be critical for quickly retrieving important information related to risk, payout reconciliation, fees, billing, and more. For more information on how to use the available data viewing options, see Table Search and Sort Instructions.
Create and Use Report Templates
Most reports provide the ability to use a template preconfigured with your preferred date and filter criteria. After you set a report date option and filter parameter criteria for a specific report, click Templates to add and save a template for future use with that report.
Download Reports
You can download reports in either CSV or XLS file format for accounting, reporting, and recordkeeping purposes. Click the following ZIP file to download a sample Report Pack with examples of each type of report.
Available Payrix Pro Reports
The table lists the available Payrix Pro reports. Click a link to access detailed report information.
When using Payrix Pro reporting functionality, note the following:
You can opt to include up-to-date data while generating any report. However, the report generation takes more time.
Certain reports are also available as Quick Reports. You can generate a Quick Report in a few minutes, but the displayed information excludes data from the past 24 hours.
You can select templates for most reports for ease of use. See Create and Use Report Templates.
Merchant reports might not appear for some merchants depending on their Portal Access role resources.
Regular Reports | Available as Quick Reports |
Account Updater Report
The Account Updater report provides details about customer card information updates, such as the same card with a new expiration date and CVV upon customer card renewal with the issuer. You can opt to filter by merchant.
Report Type
Regular
Audience
Merchant, Referrer
Active Entity Balance Details Report
The Active Entity Balance Details report shows a list of total account balances by entity. This is especially useful for merchants with the same business in multiple locations.
Report Type
Regular
Audience
Merchant, Referrer
Balance Details Report
The Balance Details Report is a resourceful tool that can be used for daily disbursement balancing, transactional entry research, negative disbursement reconciliation, and fee assessment names. The report displays an overview of your Processed and Pending Income, Expenses, and Net, indicating how many transactions make up the monetary amounts calculated. A collection of Processed or Pending transactions or fees are displayed in a list format along with the Entity, Date, Description, and Total that contributes to the report results tallied in the overview.
See also the related Statement Details Report.
Additional Information
To evaluate your balance, create a running total column from disbursement to disbursement.
To reconcile payouts, set the reporting date range to cover at least the past two payouts.
Sort this report in chronological date order from oldest to the current date.
Merchant and Referrer balances are included when generated from a Division level.
Update the Total column to currency formatting with two decimal places.
Report Type
Quick, Regular
Audience
Merchant, Referrer
Quick Reports Parameters
The primary parameters are Report Date, Category, and Filter by. The specific options for these parameters depend on your role, either Merchant or Referrer. Specify all required information to generate the Quick Report.
If you select Quick Reports for the Balance Details report, the Advanced Filters link displays and you can filter by disbursement.
Disbursement Summary Report
This report shows processed disbursements and displays a summarized list of the total amount of Sales, Refunds, Disputes, Fees, and Other amounts that make up the disbursement total.
When you opt to generate a report that includes all up-to-date data, the Advanced Filters link displays. You can choose to include up to four additional columns of information.
Report Type
Quick, Regular
Audience
Merchant, Referrer
Quick Reports Parameters
The primary parameters are Report Date and Filter by. The specific options for these parameters depend on your role, either Merchant or Referrer. Specify all required information to generate the Quick Report.
Disbursement Txn Details Report
This report provides a breakdown of all Sales and Refunds processed within the last disbursement. This includes details on each transaction (txn) such as the DBA, Cardholder, Last Four of the Card, Payment, Type, Created, Captured, Status, Transaction ID, Approved Amount, Requested Amount, Fees, and Net of the transaction processed.
When you opt to generate a report that includes all up-to-date data, the Advanced Filters link displays. You can choose to include up to two additional columns of information.
Report Type
Quick, Regular
Audience
Merchant, Referrer
Quick Reports Parameters
The primary parameters are Report Date and Filter by. The specific options for these parameters depend on your role, either Merchant or Referrer. Specify all required information to generate the Quick Report.
Disputes Report
The Disputes Report displays a list of any Merchants that currently have or have had any disputes within the date range selected. When including all up-to-date data, you can filter by users, merchants, or divisions.
When you opt to generate a report that includes all up-to-date data, the Advanced Filters link displays. You can choose to include one or more payment methods.
Report Type
Quick, Regular
Audience
Merchant, Referrer
Quick Reports Parameters
The primary parameters are Report Date and Filter by. The specific options for these parameters depend on your role, either Merchant or Referrer. Specify all required information to generate the Quick Report.
Dispute Details Report
The Dispute Details Report displays a list of any, or all, merchants including the dispute status, the reason for the dispute, the total disputed amount, and any applicable fees incurred from the dispute. You can opt to filter by users, merchants, or divisions.
The Advanced Filters link automatically displays for this report. You can choose to include one or more payment methods.
Report Type
Regular
Audience
Merchant, Referrer
Dispute Ratios Report
The Dispute Ratio Report provides a ratio of sales processed for merchants versus the total amount of disputes (chargebacks) that they have received. The report provides the following information:
The total sales count followed by the total sales count that has had a chargeback filed.
The percentage of total sales versus disputes for the selected merchant and users.
The total amount of money from the processed sale count followed by the total amount of disputes filed.
The percentage of volume from processed sales versus those that have been disputed.
You can view a breakdown based on the card type (Visa, MC, Amex, and Discover). When including all up-to-date data, you can filter by users, merchants, or divisions.
Important!
This report does not indicate the status of the dispute (chargeback). This means this report displays a dispute as long as it is open or pending in our system. If the dispute is lost it is still included in the report. However, if the dispute is won, it is excluded from the report.
Report Type
Quick, Regular
Audience
Merchant, Referrer
Quick Reports Parameters
The primary parameters are Report Date and Filter by. The specific options for these parameters depend on your role, either Merchant or Referrer. Specify all required information to generate the Quick Report.
Interchange Report
The Interchange report provides a comprehensive list of interchange rates assessed by cards and merchants within your account.
You can filter by users, merchants, or divisions.
The Advanced Filters link automatically displays for this report. You can choose to filter data by platform type, transaction type, interchange type, date, payment method, and cardholder information.
Important!
This report must be manually enabled by your Relationship Manager or the Payrix Pro Implementations Team. Use the Payrix Pro Implementation Team form to submit a request.
Report Type
Regular
Audience
Referrer
Invoices Report
This report provides an overview of all pending, viewed, paid, and total invoices within the selected date range for the report, and how many of each invoice type is including in the total calculation. To change the date range and select (or clear) specific users, merchants, or an invoice type, use the options underneath the date and click the *icon to recalculate the totals on the page.
Underneath this section is a list of merchants who have currently pending, viewed, and paid invoices, along with the total amount of invoices they have paid to date.
The Advanced Filters link automatically displays for this report. You can choose to include one or more invoice types.
Report Type
Regular
Audience
Merchant, Referrer
Monthly Statement Report
The Monthly Statement Report is a comprehensive summary of the business for the month, providing details of the monthly summary of sales, refunds, chargebacks, adjustments, and fees. Each previous month's Monthly Statement Report is available after the 5th of each month.
Unique to the Monthly Statement Report, a cover sheet is automatically created for each generated report, defining each line item for clearer understanding. The following PDF file is an example cover sheet that you can download to your device.
Monthly Statement Report Cover Sheet Example.pdf
Note
Monthly Statement reports are only available for Merchants under the Monthly Statements tab.
Report Type
Regular
Audience
Merchant
Negative Balances Report
The Negative Balances Report provides you with an overview of all negative balances for your entities.
Important!
This report always returns the current negative balance regardless of the specified filter date. Generate the report using Today as the report date due to negative balances being current.
A negative balance occurs when an account has incurred more Debits than Sales. This can occur if there is a large amount of Returns compared to processed Sales. This can be in addition to other Debit entries such as Fees and Chargebacks that can cause the available balance to decrease into the negative.
A negative balance can be retrieved via a Debit Withdrawal schedule, which typically takes five days to retrieve the negative amount from the merchant bank account.
The report includes the total negative balance and also the total balance calculated based on the total negative balance and the pending balance. The report displays the different values of a balance to help provide the full context of the account. The Schedule Withdrawal column indicates if the merchant has a pending disbursement and if a collection process has already been initiated.
Additional Information
Running this report for all entities at once returns a complete list of merchants with negative balances.
A reserve indicates money placed into reserve status by the Referrer’s boarding requirements. Reserves happen when a Referrer sets parameters on their platform for Merchants.
Report Type
Regular
Audience
Merchant, Referrer
Payment Returns Report
The Payment Returns Report displays a breakdown of all payment returns within the last disbursement. This includes details on each transaction such as the Status, Disbursement ID, Payment Amount, Requested Amount, and Fees.
The Advanced Filters link automatically displays for this report. You can choose to filter by cardholder information and date the payment return was created or captured.
Report Type
Regular
Audience
Merchant, Referrer
Profit & Loss Statement Report
The Profit & Loss Statement report displays all of the data related to your company’s income and expenses for any given user, entity, income or expense status, and date range.
Important!
The Profit & Loss Statement Report retrieves completed disbursement dates to reflect report data. This means that if a disbursement hasn’t been processed by the date you generate the report, the disbursement amount isn’t included as profit on your Profit & Loss Statement Report.
This report includes the following information:
Gross Income: The total amount of income collected.
Gross Expenses: The total amount of any deductibles such as fees, taxes, and refunds on the account.
Net Income: The total amount of income after expenses have been deducted.
The Income section provides the collective totals of Transactions, Disputes, Fees, Adjustments, and Revenue Shares that generate the Gross Income of the report. The Expenses section provides a calculated breakdown of your Gross Expense on the account.
You can retrieve two versions of this report when using Quick Reports:
Standard: For Referrers with Merchants charged using Net Billing This data is captured from entries (entries make up an account balance). This report is a more accurate version of true income and cost, as it represents the movement of funds through the partners and the merchant’s account balances.
Month-End: For Referrers with Merchants charged using Gross Billing. This data is captured from statement entries. This report is a representation of the cost that a Merchant or Referrer recorded, but it does not record the collection of that income.
Report Type
Quick, Regular
Audience
Merchant, Referrer
Quick Reports Parameters
The primary parameters are Report Date and Filter by. The specific options for these parameters depend on your role, either Merchant or Referrer. Specify all required information to generate the Quick Report.
Revenue Share Report
The Revenue Share Report is only available for Merchants. This report offers detailed data for income and costs shared between entities displayed as individual line items that include: All, Value-Added Service, ACH, Credit Card, and Excluded Fees. Merchants on Statement Billing with a Referrer with Revenue Share enabled will see each expense or income amount displayed individually on their Statement Entries.
Report Type
Regular
Audience
Referrer
Statement Details Report
The Statement Details Report presents granular details of statement entries shown in the Balance Details Report for Referrers and Merchants using Statement Billing.
The Balance Details report displays the total value of the statement, and the Statement Detail report provides the details of the entries that make up that line. Such details include the To and From entities, the type of fee, dates, and more.
Note
The Statement Detail dates are based on the statement entries, while the dates on the Balance Detail report are based on the statement billing.
Month-End Example: Entries on the Statement Detail of January can correlate to entries in the February Balance Details.
Report Type
Regular
Audience
Merchant, Referrer
Transactions Report
This report provides a summarization of transactional activity for one or more specified merchants under a Referrer.
Along with an overview of your Sales, Refunds, and Net sales (and how many of each were available in your selected date range), this report displays a chart depicting the data collected with the total amount of the Report Dates transactions, which pertain to the number of transactions and monetary values of your Sales, Refunds, and Net. Beneath the chart is a list of all merchants that have contributed to the amounts above.
This report is only generated in real time. You must stay on the Reports page while the report is being generated. If you leave the page, you must rerun the report.
See the Transaction Details Report for more specific information about a transaction.
The Advanced Filters link automatically displays for this report. You can choose to filter by payment method and date the payment return was created or captured.
Report Type
Regular
Audience
Merchant, Referrer
Transaction Details Report
A list view of the total amount of transactions, fees, and net of the transaction amount will populate this page.
Important!
Do not use this report to reconcile disbursements or payouts.
By default, the report will generate with Merchant, Cardholder, Card, Card type, Created Date, Type, Status, Amount, Fee, Assessment, Surcharge Amount, and Net.
You can always change the date range and fields from within advanced filters and click Generate Report to recalculate the report results on the page.
This report can be used to determine that transactional activity is accurately assessing contractual or agreed-upon fee schedules and revenue analysis.
When including all up-to-date data, the Advanced Filters link displays. You can filter the report data by platform, transaction type and status, transaction information, transaction creation or capture date, and cardholder information.
Additional Information:
Includes Interchange Type, card brand, payment type (card, eCheck), percentage, and amount.
Does not include fees outside of transactional fees, such as chargebacks, payout fees, one-time charges, account updater, and monthly card brand-network fees (meaning, FANF, MC Location, and VS Integrity). See the Balance Details Report for these values.
Report Type
Quick, Report
Audience
Merchant, Referrer
Quick Reports Parameters
The primary parameters are Report Date and Filter by. The specific options for these parameters depend on your role, either Merchant or Referrer. Specify all required information to generate the Quick Report.
Transaction Fee Report
The Transaction Fee Report provides an overview of the Total monetary amount of transaction fees accrued along with the number of fees, Payment Methods, Transaction Type, Status, Fee Types, Users, and Entities for the selected date range.
When including all up-to-date data, the Advanced Filters link displays. You can filter the report data by transaction type and status, payment method, and fee type.
Report Type
Quick, Regular
Audience
Merchant, Referrer
Quick Reports Parameters
The primary parameters are Report Date and Filter by. The specific options for these parameters depend on your role, either Merchant or Referrer. Specify all required information to generate the Quick Report.
Unpaid Statements Report
The Unpaid Statements report provides a list of merchants that have not paid their statements as of the specified report date option.
Report Type
Regular
Audience
Referrer
See also
Create and Manage Reports for descriptions of the delivered reporting functionality.
Reporting Values for a list of all descriptions for each report field.