You can use specific settings to gather all transaction activity for the month and download it in an Excel-compatible file format for recordkeeping, data visualizations, or general metrics tracking. This report supports your business’s accounting processes, merchant tracking and support, and manual or automated reconciliation processes. This tutorial shows you how to configure the Transactions report to retrieve all activity for the month in one report.
Audience: Partner
Generate a Monthly Transactions report
Complete all steps in the following sections to generate a Transactions report and see all transaction activity for the month within your portfolio.
Prerequisites
Before attempting this tutorial, you must:
Meet the general prerequisites described in Get Started with Use Case Tutorials.
Access the Reports Page
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.
Configure your Transactions Report
From the Select Report dropdown, select Transactions.
In the Report Date dropdown, select This month.
Tip
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.
(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.
Result: 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.
Next Steps
When you’re done reviewing the monthly transaction information, review the following guides for information on related topics:
Verify Transaction Activity with the Transaction Details Report: Review and verify the details of transaction activity in your portfolio.
Retrieve Active Merchant Account Balances: Generate a report to review all active merchant account balances.
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.
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.