School Bill Maker

The Bill Maker

Struggle no more with bills. With a click of a button send bills via email to all your students at once.

Good for all educational and non-educational institutions where fees are received from students or candidates.

By Gbenga Ayanfe

School Bill Maker App is a Simple, Editable, Effective and User-friendly School Bill Maker. It runs off-line on Microsoft Excel, designed with Ms VBA.

IT AUTOMATICALLY COMPUTES A CUSTOMISED SCHOOL FEES DETAILS FOR EACH STUDENT AND SENDS IT TO EMAIL.

Features of School Bill Maker

  • It is a macro-enabled excel app therefore, it opens up in excel.
  • It is editable and can be customized to meet your needs.
  • It runs off-line. you only need the internet to send mails.
  • It is easy to use and user-friendly.
  • It can be used for the whole school. It can accommodate over 3,500 students at once.
  • You can send mails via outlook, gmail or yahoo.
  • You can print or send termly fees or session fees.
  • You can use up to 5 different currencies.

The Details of The App

The INFO PAGE

This is the information page where the following information are inputted:

  • The School Details
  • The Name of the Classes– Do not put SPACE or any other special characters (/ – : ; ‘()!@#$%^&*) in the Classes column.
  • The terms
  • The Present Session
  • The Name, position and signature of the head of School or Account officer: To change the signature, Right-Click on it and Click Change Picture, then select your own signature from your system.

Note: It should be an image, i.e. jpeg of png.

The next column is the Students’ details column.

Based on the name of the classes inputted the classes column, a database template is created for each class. Where you type the name, email and discount (if any) for each student. In the discount column, only the number is typed while the number is automatically formatted as percentage. That is, just type 15 instead of 15%.

School Fees Details Page

On this page, you select the currency from the drop-down.

In the detail column, you list the details of your school fees.

The next thing is to write the amount of each detail of the school fees for each class term by term.

Term Bill Page

This is the page that displays the termly school fees for each student in the school according to their class and term.

To change the logo, Right-Click on it and Click Change Picture, then select your own logo from your system.

The procedure for displaying the school fees of a student is as follows:

  • Click the TERM box, select the term from dropdown
  • Click the CLASS box, select the class from dropdown
  • Click the NAME box, select the name of the student

Then, you’ll have his School fees details displayed.

Don’t forget to include the school’s Bank details and school fees due date.

Session Bill Page

This is the page that displays the total session school fees for each student in the school according to his class.

The procedure for displaying the school fees of a student is as follows:

  • Click the CLASS box, select the class from dropdown
  • Click the NAME box, select the name of the student

Then, you’ll have his School fees details displayed.

Don’t forget to include the school’s Bank details and school fees due date.

“This App can be used for over 3,500 students at once, shared into almost 20 classes. It’s extremely simple to use and highly efficient”

Printing and Email Section

To Print the Current Page, Click “Print Current Fee in PDF”. This will convert the current School Fees details to PDF, then you can send to printer.

To Print all the School Fees of the Students in the Current Class on the Page, Click “Print ALL Fees in PDF”. This converts all the fees of the students in the class to PDF, then you can send them to printer.

Sending Email

The Email Template: This shows the information that will go with the attached School fees you are sending for each child.

The variables in the two #, i.e. “# #” will be replaced by the actual names in the Email.

For example

#StdName# represents the Student’s name. If the Student’s name is Anna, #StdName# will be replaced with Anna in the Email.

Be careful when editing the Email Template. Do not change the texts of the variables. You can change other things if you need to.

Sending Mails

You can send the email with

  • Outlook
  • Gmail or
  • Yahoo

FOR OUTLOOK: If you have Microsoft outlook installed on your system;

Click “Send Current Fee With Outlook” to send the current fee displayed to the parent’s email as computed on the info page. This opens Outlook with the customized message and the student’s school fees attached. You the click send.

Click “Send ALL Fees With Outlook” to send all the school fees of students of the current class displayed at once.

This opens Outlook with the customized message and the students school fees attached. You then click send for each student.

FOR GMAIL AND YAHOO

First, click “CLICK TO SET USERNAME AND PASSWORD FOR GMAIL & YAHOO” tab to set mail address you are sending the message from. Note that this must be a valid Email and Password!

Click “SEND CURRENT FEE WITH GMAIL” to send the current fees displayed via GMAIL.

Click “SEND ALL FEES WITH GMAIL” to send to all the students in the current class displayed at once via GMAIL.

Click “SEND CURRENT FEE WITH YAHOO” to send the current fees displayed via YAHOO.

Click “SEND ALL FEES WITH YAHOO” to send to all the students in the current class displayed at once via YAHOO

REMEMBER, YOU NEED INTERNET TO SEND MAILS!!!

ADMIN PAGE

When an Admin logs in, the Admin page opens.

Admin details;

USERNAME: Admin

PASSCODE: 9999

You can change this after you log in.

Main Feature

  • Log in name and time: This is where the user name and log in time is stored.
  • Users Details Section: This is where you have the following:
  • Username: This is where you put names for users
  • Passcode: This is where you put password for each user
  • Allow Page: Click in the column and select pages (from drop down) in front of each user to assign pages that can be viewed by the user.
  • Current User: This displays current user’s name
  • Pages Name: This column displays the name of all the pages in the Application
  • Admin Username and Passcode: This is where you input Admin usernames and passwords. Admins have access to this page.

Other Tabs include

  • Show Users: The users username and password are automatically hidden. To show these you click this button
  • Show Admins: The users username and password are automatically hidden. To show these you click this button
  • Log in: Click to log in again or as a different user.
  • Show All Pages: Click to show all pages
  • Hide All Pages:  Click to hide all the pages
  • Navigate: Click to navigate to another page

If you need a different customization for your institution, we can do that for you. Contact us.

If you need a different customization for your institution, we can do that for you. Contact us.

Leave a Reply

Your email address will not be published. Required fields are marked *