The Reports page contains a set of reports that help you gather information and measure performance indicators about your business. In addition to generating and scheduling reports, you can download tax documents relevant to the payment and transaction activities of your business.
To access the Reports page:
Select Reports in the Admin category of the left navigation panel.
If you’re not automatically directed to the Reports page, select Standard Reports from the Reports submenu.
The following sections describe each feature of the Reports page.
Standard Reports Tab
You can customize reports after selecting the report type from the dropdown menu. After you generate the report, you can download a copy in CSV and XLS format.
Report Types
The following report types are available in the portal:
Transactions: Displays an overview of your sales, refunds, and net sales. Displays a chart depicting the data collected with the total amount of the report dates transactions, the number of transactions and monetary values of your sales, refunds, and net.
Transaction Details: Provides additional data on the transactions such as cardholder info, which is compiled in a checklist format that you can opt to add or omit from the report.
Payment Returns: Provides a list of eCheck/ACH transactions that have been rejected by banks.
Account Updater: Checks for and provides a list of all updates to stored, tokenized credit cards on merchant accounts.
Unpaid Statements: Displays a list of any unpaid statements associated with your merchants' accounts.
Profit & Loss Statement: Exports data about your company’s income and expenses for any given user, entity, income/expense status, and date range.
Negative Balances: Provides a list of entities that have negative balances within your portfolio.
Invoices: Displays 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.
Balance Details: Exports the balance details for any given date for any (or all) of your merchants on your account to see where your balance stands in terms of your income, expenses and net.
Dispute Details: Generates an indication of which disputes were initiated during the selected date range and the reason for the dispute.
Disbursement Summary: Disbursements are used to credit or debit the entity bank account to the primary account setup. This report provides details on disbursements that have been processed on your account. You will see an overview of the disbursement ID and processed date in addition to the total calculation of what composed the disbursement total.
Disbursement Txn (Transaction) Details: The transactions within a disbursement determine what will be paid out or credited to an entity’s bank account. This report provides a breakdown of the sales and refunds within the last processed disbursement.
Disputes: Generates all dispute-related actions (such as opened, closed, or won/lost disputes) during the selected date range.
Dispute Ratios: Provides the ratio of disputes to successful transactions a merchant receives. This ratio is compared against industry guidelines to help determine if a merchant’s dispute ratio is outside acceptable practices.
Statement Details: Provides details of statement entries shown in the Balance Details report for merchants using Statement Billing. Details include the date of the statement entry, the type of fee, and the event that triggered the fee.
See Available Standard Reports for more information about each report and which types of users can access them.
Generate a Standard Report
Complete the following steps on the Standard Reports tab to create and view a report:
Open the Select Report dropdown menu and select a report type.
Choose the Report Date or range of dates that the report will span. You can choose from Today, This Week, This Month, or a custom range.
Note
For some report types, you can only choose between a Quick Report (which omits data from today) or an Include all Up-to-date Data Report.
Choose a template from the Templates dropdown menu.
Templates allow you to save settings for future report creation.
You can add a new report template by clicking Add Template.
(Optional) Choose any additional filters by clicking Advanced Filters in the upper-right corner of the tab.
Click Generate Report. Depending on the options you choose, your report will be available within a few minutes or might take longer.
After you generate a report, the report appears on the Reports page below the dropdown menu. If you selected a Quick Report, it will also be visible on the Report History page. To download a copy of the report, click .XLS or .CSV in the upper-right corner of the report.
For more information on downloaded Portal reports, see Reporting Values.
Common Standard Reports
The following sections contain instructions for common report-generation scenarios.
Create a Granular Balance Details Report
As a merchant on Statement (Gross) Billing, you can use the Statement Details and Balance Details reports with the same date range to create a Granular Balance Details report. The consolidated report provides a unified view of the individual statement entries that make up the greater balance details of the daily statement balance.
To create a Granular Balance Details report:
Click the PLUS icon next to Reports in the left-hand navigation panel to open a dropdown menu.
Click Create Reports in the Reports dropdown menu to open the Reports page.
Create a Statement Details report and a Balance Details report with the following configuration:
Select Include all up-to-date data.
In the Report Date dropdown, set the same date range for both reports.
Click the CSV or XLS download icon in the upper-right corner of the page to download both reports to an Excel-readable format.
Consolidate both reports into a Granular Balance Details report:
Using Excel, create a new file called Granular Balance Details Report.
Paste the following columns and data from the Statement Details report into the new Excel file:
Date: The date of the sale, capture, fee, refund, or other entry type
Event: The type of entry event
Event ID: Description as supplied with the entry event, where applicable
Description: Description as supplied with the entry event, where applicable
Total: The entry line’s total amount
ID: The entry ID for the associated entry event
Original Event ID: The original transaction or fee
Reference Entity: The paying or collecting entity reference number
Reference Entity Name: The name of the entity
From Entity Name: The name of the entity sending the funds (Payer); empty for merchants
To Entity Name: The entity that is receiving the funds (Collector).
On Entity: Triggering entity that generated the event, usually the same as From Entity
On Entity DBA: The display name of the triggering entity that generated the event
Statement Date: The date when the statement entry occurred
Statement ID: Statement ID that correlates to the Statement ID on the Balance Details Report
Fee Name: The name of the fee being charged
Fee Rate (% or $): Fee $ or % depending on fee setup
Fee Amount: Total amount of the line-item fee
Fee Interchange/Assessments: Clarity on an assessment when the event is interchange
Fee Interchange/Assessments Rate (% or $): Interchange $ or % depending on fee setup
Fee Interchange/Assessments Amount: Total amount of the interchange line-item fee
Disbursement ID–Payout: The Disbursement ID of the payout, an event line item
Disbursement ID–Payout Status: Status of the disbursement payout
Create new columns to the right of these columns pasted from the previous step: Date, Event, Event ID, Description, Total, ID, and Original Event ID.
Paste the following columns and data from the Balance Details report into the Excel file:
Date: The date of the sale, capture, fee, refund, or other entry type
Event: The type of entry event
Event ID: The specific ID for the event (when transaction)
Description: Description as supplied with the entry event, where applicable
Total: The entry line’s total amount
ID: The entry ID for the associated entry event
Original Event ID: The original transaction or fee
From Entity ID: Displays the ID of the entity sending the funds (Payer); empty for merchants
On Entity: Triggering entity that generated the event, usually the same as From Entity
On Entity DBA: The display name of the triggering entity that generated the event
Align each column with the corresponding title to ensure the data is correctly lined up. For example, align Date next to Date, Event next to Event, and so on.
Delete any duplicate data to complete consolidation.
Result: Use this Granular Balance Details report to get consolidated details of each Balance Details entry including fees and interchange rates to find trends or for general record keeping. You can use search and filtering options in your spreadsheet software to sort the entry data by entity to identify patterns and trends.
Create a Statement Billing Details Report
As a merchant on Statement (Gross) Billing, you can use the Disbursement Summary and Statement Details reports to create a Statement Billing Details Report. The consolidated report provides a unified view of the statement billing information to streamline the analysis and reconciliation of Statement Billing.
To create a Statement Billing Details report:
Click the PLUS icon next to Reports in the left navigation panel to open a dropdown menu.
Click Create Reports in the Reports dropdown menu to open the Reports page.
Create a Statement Details report and a Disbursement Summary report with the following configuration:
Select Include all up-to-date data.
In the Report Date dropdown, set the same date range for both reports.
Click the CSV or XLS download icon in the upper-right corner of the page to download both reports to an Excel-readable format.
Consolidate both reports into a Statement Billing Details report:
Create a new Excel file called Statement Billing Details Report.
Paste the Disbursement Summary report data into the new file:
ID: The ID for the statement entry event
Date: The date of the sale, capture, fee, refund, or other entry type
Entity ID: The entity receiving the disbursement
Entity Name: The display name of the entity receiving the disbursement
DBA - Statement Descriptor: The custom name for the business as it appears on a customer’s bank statement
Sales: The combined total of all transactions sales making up the disbursement
Refunds: The combined total of all transactions refunds making up the disbursement
Disputes: The combined total of all withheld chargeback dispute funds making up the disbursement 
Fees: Total amount of fees for the disbursement
Other: Any miscellaneous amounts from other types of charges or revenue for the disbursement
Total: The total of all Sales, Refunds, Disputes, Fees, and others making up the total disbursement amount
Add new columns in the file to create space to the right of each column pasted from the previous step.
Paste the Statement Details report data into the file:
Date: The date of the sale, capture, fee, refund, or other entry type
Event: The type of entry event
Event ID: Description as supplied with the entry event, where applicable
Description: Description as supplied with the entry event, where applicable
Total: The entry line’s total amount
ID: The entry ID for the entry event
Original Event ID: The original transaction or fee
Reference Entity: The paying or collecting entity reference number
Reference Entity Name: The name of the entity
From Entity Name: The name of the entity sending the funds (Payer); empty for merchants
To Entity Name: The entity that is receiving the funds (Collector)
On Entity: Triggering entity that generated the event, usually the same as From Entity
On Entity DBA: The display name of the triggering entity that generated the event
Statement Date: The date when the statement entry occurred
Statement ID: Statement ID which correlates to the Statement ID on the Balance Details Report
Fee Name: The name of the fee being charged
Fee Rate (% or $): Fee $ or % depending on fee setup
Fee Amount: Total amount of the line item fee
Fee Interchange/Assessments: Clarity on an assessment when the event is interchange
Fee Interchange/Assessments Rate (% or $): Interchange $ or % depending on fee setup
Fee Interchange/Assessments Amount: Total amount of the interchange line-item fee
Disbursement ID–Payout: The Disbursement ID of the payout, an event line item
Disbursement ID–Payout Status: Status of the disbursement payout
Align each column with the corresponding title to ensure the data is correctly lined up. For example, align Date next to Date, Fee Amount next to Fees, and so on.
Delete any duplicate data to complete consolidation.
Result: Use this Statement Billing Details report to get consolidated details of each statement entry including fees and interchange rates to find trends or for general record-keeping. You can use search and filtering options in your spreadsheet software to sort the entry data by entity to identify patterns and trends.
Create a Net Billing Details Report
As a merchant on Net Billing, you can use the Disbursement Summary and Balance Details reports to create a Net Billing Details Report. This type of report provides a unified view of the individual statement entries that make up the greater disbursed balance details.
To create a Net Billing Details report:
Click the PLUS icon next to Reports in the left navigation panel to open a dropdown menu.
Click Create Reports in the Reports dropdown menu to open the Reports page.
Create a Disbursement Summary report and a Balance Details report with the following configuration:
Select Include all up-to-date data.
In the Report Date dropdown, set the same date range for both reports.
Click the CSV or XLS download icon in the upper-right corner of the page to download both reports to an Excel-readable format.
Consolidate both reports into a Net Billing Details report:
Using Excel, create a new file called Net Billing Details Report.
Paste the following columns and data from the Disbursement Summary report into the new Excel file:
ID: The ID for the statement entry event
Date: The date of the sale, capture, fee, refund, or other entry type
Entity ID: The entity receiving the disbursement
Entity Name: The display name of the entity receiving the disbursement
DBA - Statement Descriptor: The custom name for the business as it appears on a customer’s bank statement
Sales: The combined total of all transactions sales making up the disbursement
Refunds: The combined total of all transactions refunds making up the disbursement
Disputes: The combined total of all withheld chargeback dispute funds making up the disbursement
Fees: Total amount of fees for the disbursement
Other: Any miscellaneous amounts from other types of charges or revenue for the disbursement
Total: The total of all Sales, Refunds, Disputes, Fees, and others making up the total disbursement amount
Create new columns to the right of each column pasted from the previous step.
Paste the following columns and data from the Balance Details report into the Excel file:
Date: The date of the sale, capture, fee, refund, or other entry type
Event: The type of entry event
Event ID: The specific ID for the event (when transaction)
Description: Description as supplied with the entry event, where applicable
Total: The entry line’s total amount
ID: The entry ID for the associated entry event
Original Event ID: The original transaction or fee
From Entity ID: The ID of the entity sending the funds (Payer); empty for merchants
On Entity: Triggering entity that generated the event, usually the same as From Entity
On Entity DBA: The display name of the triggering entity that generated the event
Align each column with the corresponding title to ensure the data is correctly lined up. Date next to Date, Event next to Event, and so on.
Delete any duplicate data to complete consolidation.
Result: Use this Net Billing Details report to get consolidated details of each Net entry including fees and interchange rates to find trends or for general record-keeping. You can use search and filtering options in your spreadsheet software to sort the entry data by entity to identify patterns and trends.
Scheduled Reports Tab
You can use the Scheduled Reports tab to set up email delivery of future reports that are available as Quick Reports. See Available Standard Reports for more information and a list of available Quick Reports.
Select the Quick Report of choice, enter a recurring time interval (Daily, Weekly, or Monthly) and time of day (in Eastern Time), along with any email addresses you want to receive the email delivery of the report with any applied Filter by options configured during scheduling.
Important!
Reports that contain more than 24 MB of data cannot be attached to an email and as a result will be available only on the Report History page after the given date and time.
Monthly Statements Tab
The Monthly Statements tab allows you to generate a statement of your business activity over a single-month period.
Monthly Statement Information
The Monthly Statement contains information about your account for a specific period, and includes the following information:
Monthly Summary: This section summarizes each category: total sales, refunds, chargebacks, adjustments, and fees. The section displays these as the number of items and the dollar amount for each category.
Deposit Summary: This section displays a table of any deposits made to your account, including deposit amounts and other information.
Processing Summary: This section displays a table of credit card transactions and related information.
Processing Fees: This section displays a table of any fees associated with card processing that occurred during a transaction.
Interchange Fees: This section displays a table of any interchange fees associated with a transaction.
Other Fees: This section displays a table with information about any other fees that were charged to your account during the month and year of the generated statement.
Generate a Monthly Statement
To generate a new statement:
Select the month and year of interest from the dropdown menus on the page.
Click Generate to generate the statement. The statement appears below the dropdown menus on the page.
You can download the statement as a CSV file by clicking the Down Arrow icon in the upper-right corner of the statement. Print or save the statement as a PDF file by clicking the Printer icon in the upper-right corner of the statement.
Tax Documents Tab
You can download your business’s 1099-K forms through the portal. Tax documents for the current tax year will be available by January 31 of the following year. If you were actively transacting on the Payrix Pro platform in prior tax years, tax documents dating back to 2018 are also available for download.
Note
For tax years prior to 2018, contact your payments provider for a copy of your tax documents.
Download a 1099-K Form
To download a 1099-K form, complete the following steps on the Tax Documents tab:
Select the tax year for which you want to retrieve a tax document. The most recent tax year is selected by default.
Click PDF to download your 1099-K form for the selected year.