School Financial Report

Fee Structure | Fee Balance | Inventory Report| School ERP Leave a comment

How to Retrieve Fee Structure and Balance Fee In School ERP?

Hello friends in this article we are going to learn “how we can retrieve Head wise Balance Fees and Individual students fee Structure from all the concerned classes for a particular period.”?


Firstly, let me know;

Are you first time visiting my blog?

If your answer is yes, then I request you to read these below mentioned blog posts to understand this erp software functionality and features,

How To Create Organisation In I-Genius School ERP Software
How To Record General Admission Inquiry in I-Genius School ERP Software
How To Convert Inquiry Into Admission In I-Genius School ERP Software
Fees Collection And Attendance Management In I-Genius



If you are a repeated visitor and have already read above article then Let us move on next step,

Go to Display menu and click on Fees Head Summary.

Select dates and click OK.

Fee Structure

It will display the report as shown in the above picture; here if you want you can take the Print out of Fees Structure also by clicking on Print button in Fees Summary window.
Fee Structure Head wise

Fees Monthly Summary Retrieval Method

We have done survey and came to know that some schools need class wise reports which shows monthly summary of fees for a particular fee head.

Let’s start
• Go to Display menu and click on Fees Monthly Summary.
• Type Fees Head and click OK. The report is shown as below.

Fee Structure Monthly
• Click on Print button if you wish to see the print out of the report.

Fee Structure Print Copy
Can we get Class wise, head wise Fees Dues List?

Yes, We can retrieve Fees due – in either ways or both like class wise, family wise, head wise etc along with its status report with detailed breakup of due list.

Follow the below steps;

• Go to Display menu and click on Fees Dues List
• You will get four options.
• Select class, Section, Route (Click here to see how to create different heads in this article), Family (If any or else apply N.A).
• Select Months for which we want to see Fees Due
• Check the check box “Consider Old Balance” as shown in the below picture.

Fee Balance inquiry

• Type Minimum and Maximum value. Minimum and maximum values is the range means between which range we want to see the fees due.
• Click Ok. The software show Fees Dues from correspondence class as shown below

Balance Fee Report
• If we want to see the report in Excel sheet, click on Open with Excel
• To send reminder or any information through SMS, click SMS.
• To print the list, select the records and click on Print button. The report will be shown as below.
Balance Fee Printed copy
Family Wise Fee Dues List

If we want to see the list of students of same family whose fees is due, we go to Family Dues List.
• In Fees Due List menu, click on Family wise Dues List. Family Dues List window will be opened.
• Select Family, Months.
• Type Minimum and Maximum values and click OK
• There is a search option also. We can search family by family name or class.
• If we want to see the report in Excel sheet, click on Open with Excel.

Family wise fee balance
To see the report, click on Print button.
Family wise fee balance Report

Fees Status Report

We can see complete Fees status of students, all the fees received and fees due for a particular family.
• In Fees Due List menu, click on Fees Status Report. Fees Status Report will be opened.

Fees Status
• Select Class, Section, Route, Family and click OK. Fee Status Report will be displayed. It shows the list of students with their fees being and fees dues for the respective months.
• If we want to see the report in Excel sheet, click on Open with Excel.

Fees Status in Excel

FEES DUES DETAILED

We can see Fees Due in detail.

  •  In Fees Due List menu, click on Fees Dues Detailed. Fees Dues Detailed window will be opened.

Fees Dues

  • Select Class, Section, Route, Family, Months and click OK. Total Fees Dues – Classwise will be displayed. It shows the list of students with their total fees dues for all the months.
  • If we want to see the report in Excel sheet, click on Open with Excel
  • To send reminder or any information through SMS, click SMS.

Class wise Fess due

DEFAULTERS LIST

Every School management wants to see the list of students whose fees is pending. Don’t worry this software has  one ultimate option to see Defaulters list and not only this we can send SMS and Reminder Letter to parents, to remind them to pay the due fees.


  • Go to Display Menu and click on Defaulters List. Defaulters List window will open up.
  • Click on SMS button to send SMS about reminding parents to pay due fees.
  • We can specify the minimum and maximum values to specify the range of pending amount.

Defaulters list

  • Click on Reminder Letter button to send Reminder Letter to parents. The letter shows as below.

Defaulters letter

  • Click on Print button to take the print out of the Defaulters List

 

Balance Fees Report

We can see the list of students whose fees is balance.

  • Go to Display menu and click on Balance Fees Report. Balance Fees Report window will be opened.
  • Press Enter key to see the list.
  • If we want to see a particular student, there is a search option below. Type Admission No. or Name or Class etc and click OK. The list will be displayed.

Balance Fees

  • To take the print out of the list, click on Print button. The report will be displayed as below.

Balance Fee Printed copy2

YEARLY FEES RECEIVABLE

This software has option to see Yearly Fees Receivable, received fees and balance fees of individual class.

  • Go to Display Menu and click on Yearly Fees Receivable
  • Select Class and Section. Click OK.
  • Click on Export button to export the list of students to excel sheet

Yearly Fees

DEMAND REGISTER

This report shows monthly fees collection of all the classes.

  • Click on Demand Register button on main window. Demand Register window will be shown.
  • Select the month for which we want to see fee report and click OK.
  • We can take the print out also by clicking on Print button.

Fees Demand Register

Fees Card

If School wants to see the Received Fees and Due Fees of a particular student for a particular period

  • Click on Fees Card button on main window or Go to Display menu and click on Fees Card.
  • Type Admission No. or press F4 key to search for student, Select dates and click OK.
  • Select one of the two options – Show Received Fees Card or Show Due Fees Card.
  • Software will display the Fees details for whichever option is selected.

Below picture showing Fees Card for Received fees.

Fees Card

See the picture below to get Fees Card for Due fees.

Fee Card Due

  • Click on Print button if we want to take the print out of the Fees Card.

Fee Card print Copy

 

Class Wise Active Students Report

Sometimes, school wants to see Class wise report of students who are active or discontinued from school.

  • Go to Display menu and click on Class Report.
  • Select option – Active or Discontinued.
  • Select Class and click Ok.

Class Wise Strength Report

  • There is a Sort option below. We can sort the list of records by Admission No., Roll No. or Name of student.
  • No. of students are also displayed at the bottom right of screen.
  • We can take the print out of this report. Click on Print.

Class Strentgh Report

CLASS WISE AND ROUTE WISE STUDENT STRENGTH

Sometimes, we want to see how many students are there in a class and how many students come from which route.

  • Go to Display menu and click on Class Wise Strength.
  • Click Ok.

Route wise strength

  • We can take the print out of this report also. Click on Print button.

Strength Report

SCHOOL RECEIPT BOOK

We can maintain a Receipt Book for the total Fees collected during a particular period. This book shows the list of all students from whom fees is being collected along with their fees amounts. The total amount of fees collected is also shown.

  • Go to Display Menu and click on Receipt Book. Receipt Book window will be opened.
  • Select dates and click OK.

School Receipt Book

  • There is a search option also shown at the bottom of the above window. We can search Fees Receipt Record based on Student Name or Admission No. or Class.
  • Click on Print button to see Fees Book Report as below.

Receipt Book print

FEES DAY BOOK

This report will show daily fees collection. It shows collection of all the fees Heads, Late fees, Concession, Net fees, Fees Received, Balance.

  • Click on Fees Day Book button on main window. Fees Day Book window will open up.
  • Select dates and click OK. Fees Collection details will be shown.

Fees Day Book

  • There is a search option below. We can see report class wise, Admission No. wise.
  • We can take print out of the report. Click on Print button and the complete list will be opened in MS-Excel sheet.
  • Click on Summary button to see the Fees collection Summary report.

Fees Day Book Print Copy

Fees Group Ledger

This report shows Head wise fees collection of particular Fees Group, Account Posting or Account Group.

  •  Go to Display and click on Fees Group Ledger. Fees Group Ledger window will b opened.
  • Select any of the options among Fees Group, Account Posting and Account Group.
  • Select sub option and date range. Click OK.
  • The list of students along with their total fees received will be displayed as below.
  • Click on Print button and the list will be opened in MS-Excel where we can print the list.
  • Click on Summary button to see this report.

Fees Ledger

  • There is a search option at the bottom of the window wherein we can search the data accoring to Class, Section, Adm. No., Name or Family.
  • There are two options to show Student Detail also and Show Late Fees Also.

FEES SUMMARY – DATE WISE

We can see Fees Summary date wise means if we want to see fee collection of students in a particular period, we can go to this report.

  • Go to Display menu and click on Fees Summary-Datewise. The Fees Summary Datewise window will be opened.
  • Select any option among Fees Group, Fees Head, Account Posting and Account Group.
  • Select sub option below the above four options. The list will be displayed as per the selected option.
  • There is one more option ‘ Club Fees Groups ‘. If we do not select any option and select only this option, software will club all the Fees Groups and will display the fees collection list.

Date wise Fees Summary

  • We can take the print out of this report also. Click on Print

Date wise Fees Summary Report

FEES CATEGORY WISE DETAILS

This report shows fee details of students belonging to particular category.

  • Go to Display menu and click on Fees Category Wise Details. The window will be opened.
  • Select Category and click OK

Fees Category

  • We can take the print out of this report also by clicking on Print button.

Fees Category Print Copy

Fees Head-wise Concession Report

This report shows list of students who are given Fees concession on particular Fees Head by school. We can see Fees concession on particular Fees Head or particular class or particular student.

  • Select Fees Head or Class or Name of student and click OK
  • OR We can simply click Ok without specifying any Fees Heas or Class or Stduent name. It will show Fees Concessions given on all Fees Heads, Class or Student.

Fees Concession

  • We can take the print out of the report also by clicking on Print button.

Concession Report Print

CONCESSION REGISTER

We can see Concession Register also in which all the students who are given total Concession by the school. will be shown.

  • Go to Display menu and click on Concession Register. Concession Register window will be opened.
  • We can see Fees Concession list by Student Name or by Class
  • Fees Concession given to all students are shown. Total amount of Concession is shown at the bottom.

Concession Register

  • We can take the print out of the report also by clicking on Print button.

Concession Register Print

Material (Stock) Issue Register

This report shows list of students who purchased books and stationery from school.

  • Go to Display menu, Stock Reports and click on Material Issue Register
  • Select Dates and click OK
  • There is a search option below like Regd No., Bill No., Student Name according to which we can search records.

Stock issue Register

  • Total Quantity of items, Bill Value, Cash Received and Balance Amount are also shown at the bottom.
  • We can take the print out of the report also by clicking on Print button.

Invenotry Management Report

Stock (Inventory) Purchase Register

This report shows list of items purchased by school from different suppliers.

  • Go to Display menu, Stock Reports and click on Stock Purchase Register
  • Select Dates and click OK.
  • There is a search option also like Bill No., Party Name, Item Name according to which we can search item records.

Inventory Purchase register

  • We can take the print out of the report also by clicking on Print button.

Inventory Status Report

Stock Register

This report shows list of available and zero balance stock items kept by School, its opening stock quantity and value, closing stock quantity and value, its sale and purchase quantity and value.

  • Go to Display menu, Stock Reports and click on Stock Register.
  • Select Dates and click OK.
  • There is a search option also like Item Name and Company Name according to which we can search stock item records.




If you really enjoyed reading this post Do share with your friends too and leave your feedback bonus subscribe to my blog post to receive upcoming posts notifications on your mail.

To try our demo software click here 

And don’t hesitate to contact us via mail or visit our nearest service center.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: