Use Case: Create a Statement Billing Details Report
As a Merchant on Statement (Gross) Billing, you can use the Disbursement Summary Report and Statement Details Report to create a Statement Billing Details Report, providing a unified view of the statement billing information to streamline the analysis and reconciliation of Statement Billing. This tutorial will walk you through the steps to generate and consolidate the Disbursement Summary Report and Statement Details Report to create a Statement Billing Details Report.
![image-20240201-143703.png](../__attachments/23618652952/image-20240201-143703.png?inst-v=0ddc2d53-a548-4624-9646-d52b510a0ee7)
Objective
Consolidate a Disbursement Summary Report and Statement Details Report into a Statement Billing Details report.
Audience
Merchants
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.
Microsoft Excel or another spreadsheet software.
You must be a Merchant on Statement (Gross) Billing.
Warnings
Warnings will provide insight or advice to avoid risk, visibility, and product performance issues during this use case.
Warning: Carefully verify data columns when consolidating the source reports together to ensure accuracy.
Tips
Tips will provide suggestions to streamline or better prepare you to apply this use case tutorial.
Tip: After consolidation, use search and filtering options in your spreadsheet software to sort the entry data by entity to identify patterns and trends.
Additional Resources
See Reporting Values for a table with descriptions of data shown on various reports to help better interpret the report for reconciliation.
See Available Portal Reports for more details about each report type mentioned within.
For clarification on Statement (Gross) Billing vs. Net Billing, visit the Billing & Statements page.
Balance a Daily Disbursement
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 Statement Details Report
Step 1: From the Select Report dropdown, select Statement Details Report.
Step 2: For “How would you like to generate your report?”, select “Include all up-to-date data”.
Step 3: In the Report Date dropdown, set your preferred date range. You’ll also use it as your Disbursement Summary report date.
Step 4: (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.
Step 5: (Optional) In the Filter By dropdown, you can optionally add a filter for Divisions, Merchants, or include both.
Step 7: Click the Generate Report button to begin generating your Statement Details Report.
Step 8: 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.
3: Configure your Disbursement Summary Report
Step 1: From the Select Report dropdown, select Disbursement Summary Report.
Step 2: For “How would you like to generate your report?”, select “Include all up-to-date data”.
Step 3: In the Report Date dropdown, set the same date range as the Statement Details report.
Step 4: (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.
Step 5: (Optional) In the Filter By dropdown, you can optionally add a filter for Divisions, Merchants, or include both.
Step 6: Click the Generate Report button to begin generating your Disbursement Summary Report.
Step 7: 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.
4: Consolidate into a Statement Billing Details Report
Step 1: Create a new Excel file called “Statement Billing Details Report”
Step 2: Paste the Disbursement Summary Report data into the new file:
Step 3: Add new columns in the file to create space right of each column pasted from Step 2.
Step 4: Paste the Statement Details Report data into the file:
Step 5: Align each column with the corresponding title to ensure the data is correctly lined up. Date next to Date, Fee Amount next to Fees, and so on.
Step 6: Delete any duplicate data to complete consolidation.
Result: Use this Statement Billing Details Report to get consolidated details of each Statement entry including fees and interchange rates to find trends or for general recordkeeping.
Next Steps
Once the Statement Billing Details Report has been created, review the following use case guides for additional information on related topics:
Verify Transaction Activity with the Transaction Details Report: Use the Transaction Details report to see more details about specific transaction activity that makes up your sales with the Verify Transaction Activity with the Transaction Details Report use case.
Conclusion
Once the report is created, you now have a unified view of your statement billing information in a single spreadsheet.
References
Click the links or items below to access any of the following pages: