Create and Manage Standard Reports

The Reports page allows you to generate reports that can help you gather information and measure performance indicators about your business, as well as schedule reports to be generated. You can customize the reports after selecting the report type from the dropdown menu. Once you generate the report, you can download a copy in CSV and XLS format.

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.

Note
Reporting functionality is limited in the sandbox environment because it is not a production environment with validated data and connectivity.

Report Generation Options

This section describes how to generate either a Quick Report or an Include All Up-to-date Data report.

Important!
Quick Reports can only generate report data from 24 hours prior and earlier, and does not include data from the date of generating the report.

Generate Quick Reports

A subset of the Payrix Pro reports are available as Quick Reports, which can be generated in a few minutes. Quick Reports are limited to data reported from 24 hours prior at the earliest.

To generate a Quick Report:

Access the Reports page.
Choose your desired Quick Report type from the Select Report dropdown list.
Under How would you like to generate your report?, select Quick Reports: Generate reports within a few minutes. Data from today will not be included.
Select the date range for the report using Report Date and select any optional Filter By option.
Click Generate Report.
After generating your report, you’ll see the prompt stating Your report is ready to be downloaded.
You can download the report in CSV or XLS format.
(Optional) Click the CSV or XLS icon located to the right of the report heading to download the file to your device.

You can find previously run Quick Reports on the Report History page.

Generate Include All Up-to-date Data Reports

Include all up-to-date data is available for all reports and provides a more comprehensive report generation option at the expense of speed. It can take several minutes to complete generation but the data is available from up to the moment of generation. This report is useful for retrieving active merchant account balances.

To generate an Include All Up-to-date data report:

Access the Reports page.
Choose your desired report type from the Select Report dropdown list.
Select Include all up to date data.
Select the date range for the report using Report Date and select any optional Filter By option.
Click Generate Report.
After generating your report, you’ll see the prompt stating Your report is ready to be downloaded.
You can download the report in CSV or XLS format.
(Optional) Click the CSV or XLS icon located to the right of the report heading to download the file to your device.

Previously run Include All Up-to-date data reports are not available on the Report History page.

Schedule Reports

The provided scheduling functionality enables you to set up report generation ahead of time and deliver them to specified email addresses. Reports that contain more than 24 MB of data cannot be attached to an email and, as a result, are available only in the Report History page after the given date and time.

To generate a scheduled report:

Select the Schedule Reports tab at the top of the Reports page.
Click Schedule Report to open the New Report Schedule dialog.
Select an available Quick Report from the Report dropdown.
Under Recurring, select the interval: Daily, Weekly, or Monthly.
Under Time, select the time of day. Note: This feature is based on the Eastern Time zone.
Under Add Emails, add each relevant email address you want to receive the scheduled report. Note: Emails are separated by a comma or a return line upon entry.
(Optional) Under Filter By, include all divisions and merchants, or choose a specific entity to filter the information by.
Click Confirm to finish setting up the scheduled report.
After generating your report, you’ll receive an email with the report in PDF and Excel-compatible format (CSV) with your filtering preferences applied.

Generate Monthly Statements

The Monthly Statements page is a unique reporting option that allows merchants exclusively to generate a statement of their transaction activity, interchange rates, fees, refunds, disputes, and more for a given month and year. This type of report is provided in a simple-to-understand document format that includes a coversheet explaining the meanings of each line item to assist in recordkeeping and reconciliation processes.

To generate a Merchant Monthly Statement report:

Select the Monthly Statements tab at the top of the Reports page.
Select the Month and Year for the Monthly Statement you’d like to see.
Click Generate next to the Month and Year to generate the Monthly Statement to be displayed on the page.
After the statement has been generated, review the data using the following methods:
- Review in the Portal with the Understanding Your Statements section.
- Download the report in a PDF or Excel-compatible format with an Understanding Your Statements coversheet.

Create Common Standard Reports

The following sections contain instructions for common report-generation scenarios.

Generate a Monthly Transactions Report

You can use specific settings to gather all transaction activity for the month and download it in an Excel-compatible file format for record keeping, data visualizations, or general metrics tracking. This report supports your business’s accounting processes, merchant tracking and support, and manual or automated reconciliation processes. To gather as much up-to-date data as possible, run this Monthly Transactions report on the last day of each month. If you're running this report any other time, use the Custom option and set the start date as one month before your reporting date.

To generate a Monthly Transactions 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.
From the Select Report dropdown, select Transactions.
In the Report Date dropdown, select This month.
(Optional) In the Templates dropdown, select a previously saved report template or create a new one from the parameters being set by clicking Add Template.
Note
To view all your merchant balances in the same report, do not adjust any Filter By or Advanced Filter settings.
Click Generate Report to begin generating your Transactions report. Depending on the volume of transactions for active merchants in your portfolio, the Transactions report can take several minutes to generate.
Click the CSV or XLS download icon in the upper-right corner of the page to download the report to an Excel-readable format. You can also view the data right in the portal.

In your newly downloaded Transactions report with the date range for the month, you can see a consolidated view of your entire portfolio transaction activity at once. See Reporting Values for a table with descriptions of data shown on various reports to help better interpret the report for reconciliation.

Verify Merchant Transaction Activity

You can use the Transaction Details report to verify specific transaction activity from merchants. Including all data is recommended to help verify all transaction activity when reviewing your portfolio.

To generate a Transaction Details report to verify merchant transaction activity:

Click the PLUS icon next to Reports in the left navigation panel to open a dropdown menu.
Click Create Reports in the Users dropdown menu to open the Reports page.
From the Select Report dropdown, select Transaction Details.
Select Include all up-to-date data.
In the Report Date dropdown, select the date range for the transaction activity you want to review.
(Optional) In the Templates dropdown, select a previously saved report template or create a new one from the parameters being set by clicking Add Template.
(Optional) In the Filter By dropdown, add a filter for Users, Divisions, or merchants.

(Optional) Click Advanced Filters in the upper right to set your preferred data sources and add the following filters to the Transaction Details report. See the table below for available filters:

Advanced Filter	Description	Filter/Data Options
Platform	Include the platform column in the report and filter transactions by platform processor.	All Vantiv VCore
Date Field	Deciding what the Date field value will represent for listed transactions. (Created by default.)	Created Captured Settled
Include Blocked	Whether to include blocked transactions in the report (Checkbox. Unchecked by default).	Yes (Checked) No (Unchecked)
Payment Methods	Select the payment methods you want to include (you can select more than one).	Amex Visa Mastercard Diners Discover Debit Personal Checking Personal Savings Business Checking Business Savings
Cardholder Info	Select the cardholder information you want to include (you can select more than one).	Cardholder Company Card Address City State Zip Phone Email
Transaction Info	Whether to include the Order ID with listed transactions in the report.	Order ID
Transaction Types	Select the transaction types you want to include (you can select more than one).	Sale Auth Capture Reverse Auth Refund eCheck Sale eCheck Refund eCheck Presale eCheck Prefund eCheck Redeposit
Status	Select the transaction statuses you want to include (you can select more than one).	Pending Approved Failed Captured Settled Returned

Click Generate Report to begin generating your Transaction Details Report.
(Optional) Click the CSV or XLS download icon in the upper-right corner of the page to download the report to an Excel-readable format for review outside of the portal and import it into your preferred accounting software.

After you download your report, you can use it to verify your merchant transaction activity. To review merchant transaction activity in the downloaded report:

Sort or filter the Merchant column to group listed transactions by merchant.
Use the Date, Type, and Net columns to identify any discrepancies in amounts, or identify a trend in negative merchant activity, such as large amounts in the Refunded column.
Review transactions for accuracy for reported merchants and identify positive or negative trends in their activity.
- No Discrepancies: If the disbursement totals have no discrepancies, you can finalize and complete your transaction activity review.
- Transaction Discrepancy or Negative Activity: If you identify any discrepancies in amounts for listed transactions, review your advanced filters and ensure any transactions that have not been settled or batched can be included.
Using the corresponding Date, Merchant ID, and Merchant Name column information, investigate and resolve any issues, coaching merchant behaviors that normally result in negative transaction activity including chargebacks and refunds.

After resolving any discrepancies, and working with merchants to adjust any negative behaviors, you can finalize your transaction activity review and compare the overall total of the NET column value against your or your merchants' available balance. Through regular transaction activity reviews for your merchants, you’ll be able to quickly identify trends in merchant behavior and assist in your reconciliation process by verifying your merchant’s amounts, followed by your payout totals.

Download Tax Documents

Worldpay files a 1099-K form with the Internal Revenue Service (IRS) for any US merchant that uses the Payrix Pro platform to process payments and transactions. Merchants can access the portal to download a PDF file of their 1099-K form for the tax year 2018 or later. Worldpay issues each merchant’s 1099-K form by January 31 for the previous tax year. If a merchant processes payments on both VAP and VCore within the same tax year, the PDF file will include two 1099-K forms.

To download a 1099-K form for a merchant, complete the steps in Download a 1099-K Form while logged in as the merchant.