Skip to main content

Settlements

Overview​

Settlements in the Payments module provides a comprehensive reconciliation system for matching and verifying transactions recorded by the merchant with those recorded by the institution. This feature enables accurate financial accounting by allowing administrators to review settlement data date-wise, examine detailed transaction records, and export information for further analysis and record-keeping purposes.

Key Features​

→ Transaction Reconciliation for matching merchant and institutional records.
→ Date-wise Settlement Data organized for easy review and analysis.
→ Merchant ID Filtering to view settlements for specific payment processors.
→ Detailed Settlement Views providing comprehensive transaction information.
→ Excel Export Functionality for external analysis and record-keeping.

Accessing Settlements​

  1. On the left side of the main menu, go to Payments >> Settlements.
  2. The Settlements interface will display with filtering options and settlement data.

Using Settlements​

Step 1: Filter Settlement Data​

Filtering Requirements

Merchant ID selection is mandatory for retrieving settlement data. Date filters help narrow down the results to specific time periods.


Steps to filter settlements:

  1. Select the Merchant ID from the dropdown (mandatory field)
  2. Apply Date filters to retrieve settlements done between the selected dates
  3. Click Apply or Search to load the filtered data

Step 2: Review Settlement Data​

Settlement data is displayed date-wise with the following information:

  1. Settlement dates and amounts
  2. Transaction counts and totals
  3. Merchant-specific settlement details
  4. Processing status and completion information

Step 3: View Detailed Settlement Information​

To access detailed settlement information:

  1. Locate the specific date or settlement entry you want to review
  2. Click on the 'View' (eye) icon next to the settlement entry
  3. Review the detailed breakdown of transactions for that particular day
  4. Examine individual transaction records, amounts, and processing details

Step 4: Export Settlement Data​

To save settlement data to MS Excel:

  1. After filtering and reviewing the desired settlement data
  2. Click on the Export button (typically located at the top or bottom of the data table)
  3. The system will generate and download an Excel file with the settlement information
  4. Save the file to your desired location for further analysis or record-keeping

Expected Results​

After using the Settlements feature, users should be able to:

  • Successfully filter settlement data by merchant and date range
  • View comprehensive settlement information organized by date
  • Access detailed transaction breakdowns for specific settlement periods
  • Export settlement data to Excel format for external analysis
  • Perform accurate reconciliation between merchant and institutional records
  • Maintain proper financial documentation for accounting purposes

Common Issues & Solutions​

🛑 Issue✅ Solution
No settlement data appearsEnsure Merchant ID is selected and date range is appropriate
Export function not workingCheck browser permissions for downloads and try again
Detailed view not loadingRefresh the page and ensure stable internet connection
Date filter showing no resultsVerify date range includes actual settlement periods
Settlement amounts don't matchContact support for reconciliation assistance and data verification
Useful Tips
  • Use specific date ranges to improve data loading performance
  • Export data regularly for backup and audit trail purposes
  • Review detailed views to understand transaction patterns
  • Keep merchant credentials and access permissions updated

FAQs​

Q: How often are settlement records updated? A: Settlement records are typically updated based on the merchant's settlement cycle, usually daily or weekly depending on the payment processor.

Q: Can I view settlements for multiple merchants at once? A: Currently, you need to select one merchant ID at a time to view settlement data. Use the filter to switch between different merchants.

Q: What file format is used for exports? A: Settlement data is exported in Microsoft Excel (.xlsx) format for easy analysis and compatibility.

Q: How far back can I view settlement history? A: The available history depends on your institution's data retention policy and merchant account setup. Contact support for specific timeframe information.

Support​

Need Help?
Access Support Portal from the footer and click on "Login with CampX."