Versions Compared

Version Old Version 1 New Version Current
Changes made by

Miles Graves

Miles Graves

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Portal offers many different report options for Facilitators and Referrers with essential reports available for their Merchantsall levels of user. These reports can streamline your understanding of specific key performance indicators of your business, determine how much you’re making on transaction fees, the number of new merchants boarded, and more!

Report Actions

Our robust reporting options offer functionality allowing you to increase awareness of actions in your portfolio, profits & losses, new Merchants boarded, and many more exciting details. To maximize this report data, it’s important to know the options to:

...

Expand
titleClick here to see all Report Actions.

Create Reports

In order to see Report data, you’ll need to create a new report.

Learn how to generate any of the reports below using the Portal.

View Report Data

Each report generated or downloaded will feature a set of fields that represent different key reporting information, some specific to each report.

See descriptions for individual report columns or field values.

Sort and Filter Report Data

Each of our reports offers robust searching, sorting, and filtering options. These data viewing options can be critical to quickly retrieving important information related to risk, payout reconciliation, fees, billing, and more.

Learn how to use our filtering, searching, and sorting options to streamline your reporting usage.

Download Reports

Each of these reports can be downloaded in a CSV / XLS file format for accounting, reporting, and recordkeeping purposes.

Click the zip file below to download a sample Report Pack with examples of each type of report:

View file
nameReport Pack.zip

...

Report Types

...

  • Account updater

  • Active entity balance details

  • Balance details

  • Disbursement summary

  • Disbursement transaction details

  • Dispute details

  • Dispute Ratios

  • Invoices

  • Negative balances

  • Payment returns

  • Profit & loss statement

  • Transaction details

See the report matrix below to see a complete list of our report options.

...

Report

Quick Reports Available

Facilitator Level

Referrer Level

Merchant Level

Account Updater Report

X

X

X

Active Entity Balance Details Report

X

X

X

Balance Details Report

X

X

X

X

Disbursement Summary Report

X

X

X

X

Disbursement Txn Details Report

X

X

X

X

Disputes Report

X

X

X

Dispute Details Report

X

X

X

Dispute Ratios Report

X

X

X

Income & Cost Report 

X

Interchange Report

X

*X

Invoices Report

X

X

X

Negative Balances Report

X

X

X

Payment Returns Report

X

X

X

Profit & Loss Statement Report

X

X

X

X

Statement Details Transactions Report

X

X

X

Transactions Report

X

X

X

Transaction Details Report

X

X

X

X

Transaction Fee Transaction Details Report

X

X

Unpaid Statements Report

X

X

* = must be manually enabled by your Relationship Manager or the Payrix Implementations Team. Click here to submit a ticket.

...

Account Updater Report
Anchor
1
1

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.

...

Active Entity Balance Details Report
Anchor
2
2

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.

...

Balance Details Report
Anchor
3
3

The Balance Details Report displays an overview of your Processed and Pending Income, Expenses, and Net; indicating how many transactions make up the monetary amounts calculated.

...

Expand
titleBalance Details Report - More Info

The Balance Details Report is a resourceful tool that can be utilized for daily disbursement balancing, transactional entry research, negative disbursement reconciliation, and fee assessment names.

Tip

Tip: Set yourDate Range and Filter by Entity or Division and save search parameters via templates for future use. (Making no selection will query all Merchants that your user has access to.)

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 2 payouts.

  • Sort this report in chronological date order from oldest to the current date.

  • Merchant and Referrer balances will be included when generated from a Division level.

  • Update the J column (“Total”) to currency formatting with 2 decimal places.

...

Disbursement Summary Report
Anchor
4
4

At the top of this page, you will have the ability to change the date range and select (or deselect) specific merchants. Directly below this section will be a list of disbursements that have been processed with a list of the total amount of Sales, Refunds, Disputes, Fees, and Other amounts that make up the disbursement total.

...

 

...

Disbursement Txn Details Report
Anchor
5
5

Within this report, you will see a breakdown of all Sales and Refunds processed within the last disbursement. This will include details on each transaction 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. 

...

Disputes Report
Anchor
6
6

The Disputes Report displays a list of any (or all) Merchants/users that currently have or have had any disputes within the date range selected.

...

Dispute Details Report
Anchor
7
7

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.

...

Dispute Ratios Report
Anchor
8
8

The Dispute Ratio Report provides a ratio of Sales processed for merchants versus the total amount of disputes (chargebacks) that they have received. Within the report, you will see the total sale count followed by the total sale count that has had a chargeback filed. This then has the percentage of total sales vs disputes for the selected merchant and users. Additionally, this report displays the total amount of money from the processed sale count followed by the total amount of disputes filed. This then also has the percentage of volume from processed sales versus those that have been disputed and you can view a breakdown based on the card type (Visa, MC, Amex, and Disc). 

...

Note

Note: This report does not indicate the status of the Dispute/Chargeback. Thus, this report will display a Dispute as long as it is open or pending in our system. If the Dispute is Lost it will continue to display; however, if the Dispute is Won, it will be removed from the ratio report. 

...

...

Invoices Report
Anchor

...

11

...

The Income & Cost report provides a detailed list of net income and costs by individual merchants compiled into one report.

...

The Interchange report provides a comprehensive list of interchange rates assessed by cards and merchants within your account.

...

11

At the top of this page, you will see an overview of all Pending, Viewed, Paid, and Total invoices within the selected date range for the report, and how many of each calculate those totals. To change the date range and select (or deselect) specific users, merchants, or an invoice type, utilize the options underneath the date and click on the *icon to recalculate the totals on the page.

Directly below this section will be a list of merchants who have currently pending, viewed, and paid invoices, along with the total amount of invoices they have paid to date.

...

Negative Balances Report
Anchor
12
12

The Negative Balances Report provides you with an overview of all negative balances for your entities will be displayed at the top of the page, indicating the total negative balance they have occurred, and the total balance calculated based on the total negative balance and the pending balance. If you'd like to change the Users or Entities displayed click on the edit icon to add or remove selections. 

...

Expand
titleNegative Balances Report - More Info

Quick summary for a referrer to see the negative balances for a specified merchant(s).

Tip

Tip: Set your date range selection, filter by Entities or Users (Optional), and save search parameters via templates for future use. (Making no selection will query all Merchants that your user has access to.)

Additional Information:

  • Running this report for all entities at once returns a complete list of merchants with negative balances.

  • Generate the report using “Today” as the report date due to negative balances being current.

  • This report will always return current negative balances regardless of the filter date selected.

  • A reserve indicates money placed into reserve status by the Facilitator and/or Referrer’s platform requirements. Reserves happen when a Facilitator or Referrer sets parameters on their platform for Merchants.

...

Payment Returns Report
Anchor
13
13

You will see a breakdown of all rejected payouts within the last disbursement within this report. This will include details on each transaction such as the Status, Disbursement ID, Payment Amount, Requested Amount, and Fees. 

...

Profit & Loss Statement Report
Anchor
14
14

The Profit & Loss Statement report displays all of the data related to your company’s income and expenses for any given user, entity, income/expense status, and date range.

...

Expand
titleProfit & Loss Statement Report - More Info

The gross total of the Balance Details Report through fee events being assessed by Payrix/Facilitator and Referrer fees to their respective Merchants.

Tip

Tip: Set your date range selection, filter by Entities or Users (Optional), and save search parameters via templates for future use. (Making no selection will query all Merchants that your user has access to.)

Additional Information:

  • Do not use to calculate revenue in comparison to volume due to the timing of fee processing.

  • Actualized income is represented on the Standard Profit & Loss report.

...

Transactions Report
Anchor

...

The Statement Details Report presents granular details of statement entries shown in the Balance Details Report for Referrers and Merchants using Statement Billing.

Info

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 may correlate to entries in the February Balance Details.

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. Below is an example of the two reports and the Statement Detail fields.

...

A summarization of transactional activity for a specified merchant(s) under a Referrer.

...

15
15

A summarization of transactional activity for a specified merchant(s) 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), you will also see 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 will be a list of all merchants that have contributed to the amounts above.

...

Expand
titleTransaction Report - More Info

This report is only generated in real-time. The user must stay on the screen while the report is being generated.  If you leave the page, you will have to re-run the report. 

Tip

Tip: Set your date range selection, filter by Users or Merchants (Optional), and save search parameters via templates for future use. (Making no selection will query all Merchants that your user has access to.)

...

Transaction Details Report
Anchor
16
16

A list view of the total amount of transactions, fees, and net of the transaction amount will populate this page.

...

Expand
titleTransaction Detail Report - Quick Reports Parameters

Parameter

Required

Description

Date Range

Required

The timeframe you want to retrieve data from.

Filter by Division

Required

Filter by a Division that may contain multiple entities.

Filter by Merchant

Required

Filter by an individual Merchant.

Note

Note: The “Filter by” parameters only allow one selection. Meaning that one or the other is allowed and required, not both.

...

The Unpaid Statements report provides a list of merchants that have not paid their statements upon generation of the report and the amount and entity ID associated.

...

Expand
titleTransaction Detail Report - More Info

This report can be used to determine that transactional activity is accurately assessing contractual/agreed-upon fee Schedule(s) and revenue analysis.

  • For large data ranges or more advanced filtering, use Quick Reports. For smaller date ranges or less complex filtering, Real-Time Report.

Tip

Tip: Set your date range selection, filter by Users or Merchants (Optional), and save search parameters via templates for future use. (Making no selection will query all Merchants that your user has access to.)

Additional Information:

  • Includes Interchange Type, card brand, payment type (card, eCheck), percentage, and amount.

  • Do not use this report to reconcile disbursements or payouts

  • Does not include fees outside of transactional fees, such as chargebacks, payout fees, one-time charges, account updater, and monthly card brand-network fees (e.g., FANF, MC Location, & VS Integrity).

  • Utilize advanced filters when running the Real-Time report to get more granular details.

...

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.

 

...

fee Schedule(s) and revenue analysis.

  • For large data ranges or more advanced filtering, use Quick Reports. For smaller date ranges or less complex filtering, Real-Time Report.

Tip

Tip: Set your date range selection, filter by Users or Merchants (Optional), and save search parameters via templates for future use. (Making no selection will query all Merchants that your user has access to.)

Additional Information:

  • Includes Interchange Type, card brand, payment type (card, eCheck), percentage, and amount.

  • Do not use this report to reconcile disbursements or payouts

  • Does not include fees outside of transactional fees, such as chargebacks, payout fees, one-time charges, account updater, and monthly card brand-network fees (e.g., FANF, MC Location, & VS Integrity).

  • Utilize advanced filters when running the Real-Time report to get more granular details.

...