Overview
Settlements are the process in which the fees received from students/applicants are settled in your bank account(s). The Settlement Report contains details of the settlements processed to your account and helps you reconcile the settlements. The 2 types of settlement reports that are present on Collexo are as follows:-
Navigation
Menu -> Reports -> Settlement Report
Make sure you have access to Settlement Reports as well as your organization has subscribed to Settlement Reports.
In case your organization would like to subscribe to Settlement Reports, feel free to reach out to ticket@collexo.com.
Settlement Report By Date
As the name suggests, this report showcases the details of funds settled to your account in a date-wise manner.
A summary is provided on top which shows the following:-
- Total Amount Collected: The sum of amount of all transactions that have been paid online or via EMI (Collexo NBFC Partner)
- Total Amount Settled: The sum of amount of all transactions that have been settled into your account(s).
From the table below the summary, you can also view the details of each settlement which includes the following:-
- UTR/Reference No: Unique Transaction Reference Number generated by Banks/NBFCs when funds are transferred. You can use this to identify settlements on your Bank Settlement.
- Settlement Date: The day on which funds were settled into your account
- Settled To: The place where the amount was settled - PG/Bank Account/Bank Account mapped on NBFC
- Settled Amount: Total Amount Settled for the UTR
You can click on the UTR no. to view the orders that constitute the settlement.
In addition, you can search the records by UTR number, make use of the available filters, as well as download the selected records.
Settlement Report By Transactions
As the name suggests, these are the details of funds settled to your account by transactions. You can find all the individual transactions that have been settled in this report.
It contains the following details for each settled transaction:-
- Order Id: Collexo Order ID
- Order No: The application/reference no for the Order ID.
- UTR/Reference No: Unique Transaction Reference Number generated by Banks/NBFCs when funds are transferred. You can use this to identify settlements on your Bank Settlement.
- Settlement ID: The reference number for settlement from the PG/NBFC partner.
- Settled To: The place where the amount was settled - PG/Bank Account/Bank Account mapped on NBFC.
- Partner: The Payment Gateway/NBFC partner that facilitated the transaction.
- Payment Mode: The payment mode of the transaction - Online/EMI
- Settled Amount: Total Amount Settled for the transaction.
- Settled Date: The day on which funds were settled into your account
- Payment Date: The day on which payment was made by the applicant.
You can click on the Order ID to view the settlement details for each order ID.
Additionally, you can search transactions by Order ID, UTR No and Settlement ID. You can also filter the data using the available filters.
Downloading the selected records also adds the fields that have been added to reports to the CSV file.