You can see the account balances for each merchant account in your portfolio at the same time. This is useful for internal reporting and merchant metrics tracking such as sales volume. This tutorial shows you how to generate a Balance Details report with the appropriate settings and values to see merchant balances across your portfolio at once.
Audience: Partner
Retrieve Active Merchant Account Balances
Complete all steps in the following sections to generate a Balance Details report and have a clearer understanding of the financial health of your merchant portfolio as a whole.
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-hand navigation panel to open a dropdown menu.
Click Create Reports in the Users dropdown menu to open the Reports page.
Configure your Balance Details Report
From the Select Report dropdown, select Balance Details report.
Select Include all up-to-date data.
In the Report Date dropdown, select Today.
Note
Running too large of a date range can cause delays in generation and make consolidating merchant totals more difficult. Using a daily date range (Today or Yesterday) makes the total consolidation process easier.
(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 Balance Details Report.
Click the CSV or XLS download icon in the upper-right corner of the page to download the report to an Excel-readable format.
Sorting Balances by Merchant
In Excel (or another spreadsheet software), create an A to Z sorting filter on the Entity column, grouping each merchant’s entries by merchant.
Insert a new row below each grouping of merchant entries.
Create a SUM function in the blank row under the Total column to calculate the daily balance of each merchant.
Result: With the resulting totals of each merchant’s entries, you can quickly identify top-performing merchants by balance or see trends of other merchants with low volume or balances daily.
Next Steps
After validating the daily balance of each merchant in your portfolio, review the following 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.
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.
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.