Generate List of Students with Outstanding Fees

This function allows the users to generate a list of all students who have outstanding fees as of a certain date. This report can be used by the class teacher to remind students to pay their fees.

Roles Involved: Class Teacher or School Finance Officer or School Admin - Billing

1. Navigate to Main Menu > Reporting Tools > Query > Query Viewer.

2. Select 'Query Name' in the Search By field.

3. Enter the name of the report which is 'MOE_BI_OUTSTANDING_FEES' in the Begins With field.

Note: User can enter 'MOE' first in the Begins With field as to easily find the query.

4. Click on the Search button.

5. Search for the Query Name and click on the HTML link.

6. On the report page, enter the required values in the Institution, Campus and the Due Date fields.

Note: Enter value in Due Date field as to generate students who have not paid their fees as of the due date.

7. Click on the View Results button.

8. The list of students with outstanding fees will be generated.

9. The user can either Open or Save the report when clicking the Excel SpreadSheet link.

10. The report will be shown and is generated in .XLSX file.

↑ Back to Top