Creating Student Charges

Using tuition charges (fee code = TU ), suppose your organization charges $200 per credit hour for part-time students and charges a flat rate of $2,450 for full-time students. A part-time student takes less than 12 credit hours, and a full-time student takes 12 - 15 credit hours. A student with more than 15 hours is charged $200 for every hour over 15 (sample tuition structure).

The information below shows four students and the number of credit hours each student has taken in the current term.

Student ID

Student Name

Credit Hours

000000002

Amy Jones

12.00

000000003

Jim Thompson

0.00

000000004

Mary Nafziger

5.50

000000001

Tom Wise

17.00

When the program generates charges for each student, it goes through a three-step process:

1.    It chooses the appropriate Charge Detail entry. Based on this example, it chooses the entry on the basis of their credit hours total (part-time, full-time, or overload).

2.    Once the program selects the proper table entry, it calculates the transaction amount using the formula in the Charge Details.

3.    The program creates the debit and credit transactions by using the student's ID Number, the subsidiary control account, the offsetting account, the transaction description, and the calculated amount. It gets the transaction date from the person who is generating the charges.

Using the meal plan (fee code = ML), suppose your organization has two meal plans:

·       Meal Plan A, which includes 12 meals per week

·       Meal Plan B, which includes 21 meals per week (sample meal plan).

All income for meal plans goes to the same G/L income account.

The illustration below shows how you might create the charge Detail entries for the meal plans.

 

 

 

 

 

 

 

Fee Code

Student's Attribute

Subsidiary acct Inc/Exp acct

Description - initial Description - adjustment

Flat Fee

Per hour

Hrs Excl

ML

Requested

01-01-1020-1200

Meal Plan A (12 meals)

1,125.00

.00

0

Meal plan A

01-01-4020-4340

Adjustment - Meal Plan A

 

 

 

ML

Requested

01-01-1020-1200

Meal Plan B (21 meals)

1,950.00

.00

0

Meal plan B

01-01-4020-4340

Adjustment - Meal Plan B

 

 

 

The student list indicates which students purchased a meal plan, and the program must select the appropriate meal plan Charge Table entry for each student. In this case, a column that stores the meal plan code provides the criteria for this selection and the program chooses the Charge Table entry on the basis of the meal plan column.

One difference between the tuition fee code TU and the meal plan fee code ML is in the formula. In the case of meal codes, there is only a flat fee; there is no per hour calculation. Therefore, the meal plan formula is a bit different than the tuition formula. The meal plan transaction amount is equal to the flat fee amount on the Charge Table entry. The Charge Table entries will still contain the per hour column and the excluded hours column, but they are blank. For charges that do not include an hourly charge, the transaction amount equals the flat fee amount.

Examples

Amy Jones is classified as full time therefore the program selects the full time TU entry on the charge table.

Fee Code

Student's Attribute

Subsidiary Acct Inc/Exp Acct

Description - Initial Description - Adjustment

Flat Fee

Per Hour

Hrs Excl

TU

Full time

01-01-1020-1200

Tuition - full time

2,450.00

.00

0

 

 

01-01-4010-4010

Tuition Adjustment

 

 

 

Using the flat fee, per hour, and hours excluded, the program calculates the transaction amount.

Trans amt

Flat fee

(per hr charge

(student credit hrs# hrs excluded))

 

2,450.00

(0.00 (12.000))

 

2,450.00

(0.00 (12.00))

 

2,450.00

(0.00)

 

 

 

2,450.00

 

 

 

Amy's tuition amount is calculated using the columns from the charge table entry. Finally, the program creates the following tuition transactions for Amy.

Date

G/L Account

SBS

Transaction Description

ID Number

Amount

09/01/10

01-01-1020-1200

 

 

 

 

 

A/R - Regular

AC

Tuition - full time

000000002

2,450.00

09/01/10

01-01-4010-4010

 

 

 

 

 

FT Tuit. Income

 

Tuition - full time

 

2,450.00-