Fee collection sheet is very simple to use. fee entry will be done with only single input of Admission No (Student ID). See below “vlookup” formula has been inserted and when you will enter the Admission number of concern student, his fee entry will be made automatically. In above picture, ADM18-14 input fetched its related information from […]
This is the first sheet that is very important for the rest of evaluation and calculation. You can not calculate anything unless the completion of this sheet. In this first sheet you will find the following important headings Admission No. Student Name Guardian Class Fee Contact Gender DOB (Date of Birth) Admission Date You can […]
We will manage three sheets in this File, as seen below. Staff Member Database In this sheet, we will input data about staff, i.e. ID No. Employee Name Designation Joining Date Basic Pay Deduction Allowance Net Salary We will now give the name of staff member data table (Range). In this case Staff Data table […]
PL Account have two Main Side. that will display all the information about school cash flow. Revenue Side that contains all those entries which involve CASH IN Expense Side that contains all those entries which involve in CASH OUT
The following is the snapshot of inner side of school fee card of a student. On inner side of this card, there are two side, one have fee schedule of whole of the year and other side describes student detail (Name, Class, Guardian, and fee value) You can change it according to requirements. Right side […]
