|
The MU Office of Student Financial Aid is responsible for
processing all financial aid payments. To facilitate the
exchange of information between awarding units and Student
Financial Aid, an Excel
spreadsheet is used by the awarding
unit to specify the student, account and distribution of
the funds. To obtain a Macintosh-friendly version of the Excel
spreadsheet, please contact Kathy Hernandez at HernandezK@missouri.edu.
The following is a step-by-step explanation
regarding the use of the spreadsheet. If you have any questions,
please
contact Kathy Hernandez at 882-5378 or HernandezK@missouri.edu.
The spreadsheet is designed to mirror the academic year
starting with August and ending in July. If you need a spreadsheet
that follows a fiscal year calendar, please contact Kathy.
Start by saving the spreadsheet to your computer. Please
do not change the widths of the columns. They are set to meet
the mainframe standards for that field.
Column A
Enter the name of the account once. Below
the account name enter the name(s) of the recipient(s). The
student name must
be entered as it appears on the CICS3 system - capitalized,
last name first, comma (no space), then first name. After
you have entered all of the recipients for that account, you
can continue to add accounts and recipients by following
the same process. Enter the next account name first, then
enter the name(s) of the recipient(s) below it.
Column B
Enter the MU student number for each recipient. The spreadsheet
will default to the '000000000' format.
Columns C and D
Leave these columns empty.
Columns E, F and G
Enter the account's DeptID, Program Code and MoCode in the
Columns E, F and G, respectively.
Column H
This column is optional. If you choose, you may make an early
payment to first-time graduate students for their first semester
of enrollment at MU. The amount in this column will be paid
in early August. The student is not required to be registered
to receive this payment.
Column I
Indicate the day of the month you want the payment to post
to the student's account in the Cashier's office. Remember
that posting the payment to the student's account is the beginning
of the process. For example, if you want the student to receive
a check on the first of each month, you should set the date
to release the funds three to five days earlier.
Columns J through U
Enter the amount to be released each month. Payments require
that the recipient be degree seeking, registered as a full-time
student and be financially enrolled. Payments in August through
December will look at fall semester registration; payments
in January through May will look at winter semester registration;
payments in June and July will at summer semester registration.
Column V
Enter the total payments for the year, August (including
any early payments) through July.
Back to Top |
