Fee Collection Report Overview

This report will give receipt wise collection details within the selected date range
It will only have original fee collection receipts (It won’t show any reallocation related receipts)
There are 3 reports shown in the fee collection report:
- Normal Collection
  1. Normal Collection report gives the report of all the active collections in the selected date range, for either the confirmed students or the admission students
  2. If any collection has been cancelled, those receipts don’t show up in the report
- Gross Collection
  1. Gross Collection gives the report of all the active/cancelled collections in the selected date range
  2. If any collection has been cancelled, those receipts still show up in the report on the date when the actual collection had happened
  3. As fee receipts cancellation is allowed only for confirmed students, student type selection is not needed in this report
- Gross-Net Collection
  1. Gross-Net Collection gives the report of all the active/cancelled collections in the selected date range
  2. Over and above that, it gives all the Cancelled receipts with negative Values, on the date when the receipt had been cancelled
  3. If any collection has been cancelled, those receipts still show up in the report on the date when the actual collection had happened as status ‘Collected’ and are there on the date when the receipt had been cancelled as status ‘Cancelled’ with negative values
  4. As fee receipts cancellation is allowed only for confirmed students, student type selection is not needed in this report
Explanation of filters:
- Student/Admission No:
  1. Collection report can be downloaded for:
    - Fee Collection Done for the new Admission students who are yet to be confirmed
    - Note that, Once the student is confirmed, fee collection done against the student during admission would be shown as part of existing student only
    - Day wise/ Monthly:
      1. Report can be downloaded for custom date range or Monthly. A user can choose monthly, if he wants to do details of the collection done in a particular month
      2. Date range selection example: Suppose date range selected in 1st April 2017 – 31st Mar 2018. Now in that year, there has also been some advance fee collection for the next year 2018-19. If a school wants to find out how much advance collection has come in this time duration, then they can select Academic Session value as 2018-19
    - Academic session can be selected to get collection data of fee dues of the selected Academic session. For eg., if Academic session 2018-19 is selected, all the payments done against fee dues of 2018-19 session would be shown in the report.
    - Payment Mode: Schools can also filter it out using Payment Mode. Eg. If a school wants to know the cheque collections, they can select the mode of payment as: Cheque
    - Student Status filter can help the School understand the amount of collection that has come from active students, and the collection that happened from the students who already left the school.
    - Fee Collected By: School can get the details of the fees collected by particular Logged in user through the filter.Student Fee Category: If the School wants to know the collection done for a particular Student fee category in a selected duration, then they can filter it out using the filter
    - Show Concession as a separate Column:
      1. By selecting the option, the total concession availed by that student in a particular fee receipt would come as a separate column.
      2. Fee type wise amount would show the overall fee amount collected without reducing the concession.
      3. For Eg., Tuition Fee: 5000 Rs, Concession on Tuition Fee:1200 Rs, Overall Tuition Fee paid: 3800 Rs. If this option is selected to show concession as a separate column, then Tuition Fee would only show 5000 Rs. Concession would be a separate column with amount as 1200 Rs
  2. Fee amount specific information:
    - This report shows receipt wise details of the fees collected against the student’s fee dues.
    - It shows following components:
      1. Basic Student details
      2. Payment Mode specific details
      3. Fee type wise paid details
    - If the ‘Show Concession as a separate Column’ is selected, Fee amount shown against any fee type is the total fee type amount of the student. Concession against the fee type amount is shown as a separate column.
    - Concession column has a consolidated detail of overall concession given in that particular fee collection.
    - By default, if the ‘Show Concession as a separate Column’ is not selected, Fee amount shown against any fee type is the amount actually paid by a student (Fee amount – Concession availed).
    - Transaction charges is not included in total amount. Transaction Charges are the charges collected during fee payment through: Credit Card, Debit Card, Online (NEFT, IMPS, RTGS), or Payment Gateway.
    - Fine paid against the fee type or against the fee instalment, if any, is always shown in the separate Fine Column.
    - ‘Payment Date’ column is always the date on which the fee is collected in the NLP system. It is the date which is selected in ‘Payment Date’ field in Collect Fee Screen.

Was this article helpful to you?

Yes3

No3