Use Case: Generate a Monthly Transactions Report

You can utilize specific settings to gather all transaction activity for the month and download it in a convenient Excel-compatible file format for easy record keeping, data visualizations, or general metrics tracking. This tutorial will walk you through the steps to configure the Transactions report to retrieve all activity for the month in one report.

View of the Create Reports page set for generating the Transactions Report with the proper Report Date parameter set as “This month”.

Objective

Generate a Transactions report with specific report date to see all transaction activity for the month within your portfolio.

Audience

Facilitators
Referrers

Environment

Portal (Production)

Prerequisites

Prerequisites:

You must have a fully boarded Payrix account to perform any of the actions described in the use case guides.

Warnings

Warnings will provide insight or advice to avoid issues related to risk, visibility, and overall product performance during this use case.

Warning: Depending on the volume of transactions for active Merchants in your portfolio, the Transactions report may take several minutes to generate.

Tips

Tips will provide suggestions to streamline or better prepare you to apply this use case tutorial.

Tip: To gather as much up-to-date data as possible, run this Monthly Transactions report on the last day of each month, or use the “Custom” option in date range to set your reporting to exactly 1 month before.

Additional Resources

See the tips below to help you get started.

See Reporting Values for a table with descriptions of data shown on various reports to help better interpret the report for reconciliation.

Generate a Monthly Transactions report

1: Access the Reports Page

Step 1: Click the PLUS icon next to Reports in the left-hand navigation panel to open a drop-down menu.
Step 2: Click Create Reports in the Reports drop-down menu to open the Reports page.

2: Configure your Transactions Report

Step 1: From the Select Report dropdown, select Transactions.
Step 2: In the Report Date dropdown, select “This month”.

Note: If you're running this report any time other than the last day of each month, use the “Custom” option in the Report Date dropdown and select the start date as one month before your reporting date.

Step 3: (Optional) In the Templates dropdown, select a previously saved report template or create a new one from the parameters being set by clicking the Add Template button within.

Note: To view all your Merchant balances in the same report, do not adjust any Filter By or Advanced Filter settings.

Step 4: Click the Generate Report button to begin generating your Transactions report.
Step 5: Click the CSV or XLS download icon in the upper right-hand corner of the page to download the report to an Excel-readable format. You can also view the data right in the Portal.

Result: In your newly downloaded Transactions report with the date range for the month, you’ll be able to see a consolidated view of your entire portfolio transaction activity at once.

Next Steps

Once you’re done reviewing the monthly transaction information, review the following use case guides for additional information on related topics:

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

Conclusion

Generating a monthly transaction report can be beneficial for your business’s recordkeeping and accounting processes, Merchant tracking and support, and can help in the manual or automated reconciliation process.

References

Click the links or items below to access any of the following pages: