Close menu Resources for... William & Mary
W&M menu close William & Mary

FUPLOAD

FUPLOAD is a process that allows users to create and post journal entries to the Banner Finance System electronically. FUPLOADs are typically used for larger (More than 20 entries) departmental transfers and other journal entries.

FUPLOAD Template (XLS)

Instructions
  1. Enter the account index ("Account Index").
  2. Enter the account ("Account").
  3. Enter the activity code ("Activity"), if applicable.
  4. Enter the Amount.
  5. Enter "D" for debit and "C" for credit.
  6. Enter the description. Remember, there are only 35 characters; if you put more than 35, the macros program will automatically truncate the rest of the description.
  7. Check your totals.
  8. Rename the FUPLOAD spreadsheet to something else.
  9. Print FUPLOAD and get approval signature(s). The preparer must also initial or sign above their name.
  10. Email the following documents to [[edocs-datacontrol]] for processing.
    1. UPLOAD Excel
    2. Printed FUPLOAD with approval signature
    3. Backup documentation
Notes
  1. The "Show Controls" macros button is only used in the Data Control office. Please do not delete the button.
  2. Do not put any formulas in any of the cells.
  3. Do not put a space or special characters (tildes, accents, etc.) within the cells. For example, " 712640" is not the same as "712640"; " 712640" will cause an error.
  4. Enter the information in any order. In the sample here, the debits and credits alternate. Feel free to group them if you are more comfortable with this arrangement.
  5. Add more rows as needed, but do not delete any columns.