Create and Manage Reports

The portal automatically compiles data and statistics related to your sales, disputes, Merchants, and transaction information from your account. By using the platform’s Reports feature, you can efficiently organize meaningful data and increase the granularity of your business, helping you to make decisions based on details in recent business trends.

The following sections describe the delivered reporting capabilities.

Note

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

Access Reporting Functionality

You access reports in the Admin section in the left pane of the portal. Click Reports in this section to display the following pages:

• Create Reports: Offers a dropdown with all reports available to generate from the platform. You can select a report type, customize its output, and opt to generate this information as a downloadable CSV file. You also use this page to schedule reports.

• Report History: Displays a searchable list of recently generated Quick Reports.

Report Generation Options

This section describes how to generate either a Quick Report or a 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.

See also:

• Available Portal Reports for a list of all reports,along with their descriptions and samples.

• Reporting Values for a list of all descriptions for each report field.

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:

1. Access the Create Reports page.

2. Choose your desired Quick Report type from the Select Report dropdown list.

3. 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.

4. Select the date range for the report using Report Date and select any optional Filter By option.

5. 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.

6. (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.

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

1. Access the Create Reports page.

2. Choose your desired report type from the Select Report dropdown list.

3. Select Include all up to date data.

4. Select the date range for the report using Report Date and select any optional Filter By option.

5. 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.

6. (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:

1. Click the Schedule Reports tab at the top of the Reports page.

2. Click Schedule Report to open the New Report Schedule lightbox.

3. Select an available Quick Report from the Report dropdown.

4. Under Recurring, select the interval: Daily, Weekly, or Monthly.

5. Under Time, select the time of day. Note: This feature is based on the Eastern Time zone.

6. Under Add Emails, add each relevant email address you want to receive the scheduled report. Note: Emails are separated by a comma or return line upon entry.

7. (Optional) Under Filter By, include all divisions and Merchants, or choose a specific entity to filter the information by.

8. Click the Confirm button 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.

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:

1. Click Reports in the left navigation panel to open the Reports dropdown menu.

2. In the left navigation panel, click Monthly Statement to open the Monthly Statements page.

3. Select the Month and Year for the Monthly Statement you’d like to see.

4. 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.

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 following steps while logged in as the Merchant:

1. Select Reports in the left navigation panel.

2. Select the Tax Documents tab.

3. Select the tax year for which you want to retrieve a 1099-K form. The most recent tax year is selected by default.

4. Click PDF to download the 1099-K form for the selected year.