Use Case: Generate Reports in the Portal

You can generate different reports offered through the platform to help you better track your business activity, reconcile withdrawals, and verify your business’s income and cost, among other data. This tutorial walks you through the steps to generate a new report from the options available to you.

Objective

Generate any report available to your entity.

Audience

Facilitators
Referrers
Merchants

Environment(s)

Portal (Production)

Prerequisites

Your Merchant, Referrer, or Facilitator account must be fully boarded.
Live or test data must be processed through the platform to be available to report.

Warnings

Warning: Not all reports offer a Quick Reports generation option. For reports that do not offer Quick Reports, the generation time can be up to several minutes based on your settings and filtering criteria.

Warning: Some reports for Referrers and Facilitators might become available through beta enablement offering. For access to these reports as they are offered, contact your Relationship Manager or Support.

Tips

Tip: If you create filters for a report that you will regularly generate, be sure to save it as a template under the Templates dropdown available on the page to automatically apply your report filtering settings from the previously generated report.

Tip: Some portal reports offer generation through Quick Reports, allowing faster load times with less recent data (up to 24 hours before the report generation). A checkbox is displayed to select whether to generate the report using Quick Reports or the Include all up-to-date data generation option, when available.

The report matrix at Available Portal Reports identifies which reports can use Quick Report generation option.

Tip: You can access your previously generated reports on the Report History page for a limited time. Each report shown on this page displays an expiration date indicating when it will no longer be available.

Additional Resources

See the tips below to help you get started.

See Available Portal Reports for a matrix of reports available on the portal, the applicable entity levels they’re available for, a brief description of each report, and its intended purpose.
See Reporting Values for a table displaying the descriptions of data shown on various reports. This can help identify the data on your reports.

Generate a Report

1: Access the Reports Page

Click the PLUS icon next to Reports in the left navigation panel to open a drop-down menu.
Click Create Reports in the Reports drop-down menu to open the Reports page.
Make sure the Generate Report tab is selected. This should be selected by default.

2: Select Your Report

From the Select Report dropdown, select the report you want to generate.
In the Report Date dropdown, select the custom reporting date range or select a preset option.
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, you can optionally add a filter for Users, Merchants, or Divisions.
(Optional) Click the Advanced Filters link in the upper right to further filter the data displayed in the report by the following:
- Processing Platform: VCore, Vantiv, or both with status filters (Created, Captured, and Settled) with an option to include Blocked payment transactions
- Payment Method: AMEX, MasterCard, Visa, Discover, Debit, Personal Checking/Savings or Business Checking/Savings with grouping (by Merchant or Division) and an option to include Failed payment transactions

Result: The type of report, filters, and other criteria have been applied, and your report is ready to be generated.

3: Generate your Report

Click Generate Report to begin generating the report and complete the process.

Result: The selected report data will be displayed on the same page and available for download in CSV and XLS format to import into your account software.

Next Steps

When you’re familiar with the report generation process, review the following use case guides for specific actions that can be taken using different reports:

Retrieve Active Merchant Account Balances: Generate a report to review all active Merchant account balances.
Verify Transaction Activity with the Transaction Details Report: Review and verify the details of transaction activity in your portfolio.
Schedule Reports for Regular Email Delivery: Set up your favorite Quick Reports to be generated and sent to your email regularly.
Reconcile Disbursements with a Disbursement Summary Report: Reconcile your account payouts under Net Billing.
Reconcile Negative Disbursements with a Disbursement Summary Report: Reconcile your account charges under Net Billing.
Generate a Monthly Transactions Report: Get detailed transaction activity for your business.
Balance Daily Disbursements: Use the Disbursement Summary Report to balance your daily disbursements on Daily Statement Billing.
Create a Granular Balance Details Report: Create a consolidated view of the Balance Details Report and Statement Details Report for Merchants on Daily Statement (Gross) Billing.
Create a Statement Billing Details Report: Create a consolidated view of the Disbursement Summary Report and Statement Details Report for Merchants on Monthly Statement (Gross) Billing.
Create a Net Billing Details Report: Create a consolidated view of the Disbursement Summary Report and Balance Details Report on Net Billing.

Conclusion

When the report has finished being generated, you can use the data in a variety of ways to help improve your business or just for metrics tracking.

The report will also be made available under the Report History page until the expiration date that is displayed on the page.