UAFR - Completing & Submitting Year End Fact Sheets

This article provides step-by-step instructions for completing and submitting year-end fact sheets.

Follow the steps below to complete and submit a Year-End Fact Sheet, including the Fact Sheet Excel Attachment (if applicable). For further details on Fact Sheets, visit the OBFS Year-End Fact Sheets webpage.

  1. Go to Year-End Fact Sheet and log in with your credentials.
  2. Type your applicable one-digit chart code into the Chart field.
  3. Type your applicable six-digit fund code in the Fund Code field.
    NOTE: This fund code must be for a self-supporting fund (3nnnnn) or a health service plan fund (6nnnnn).
  4. Click the Create button to create the Fact Sheet for this particular fund code. A new application window opens when you click on the Fact Sheet, and your name will automatically be assigned to this Fact Sheet.
    NOTE: The fund number will appear under the In-Process Fact Sheets section of the application. The only people who have access to edit and submit the Fact Sheet are the creator and the financial manager of the fund.  
  5. To begin completing the Fact sheet, start with Item 1 — Describe the type of revenue-generating activity which takes place within this fund. Type a detailed description of the current product or services sold by this fund.
  6. Click the Save for later button at the bottom of the form to save your information.
    NOTE: Any unsaved responses will be lost when the application times out. The application times out after 30 minutes.
  7. Next, answer Item 2—Does this fund need to be terminated after year-end close?  Select Yes or No from the drop-down menu to indicate whether this fund should be terminated in the fall.
  8. Next, answer Item 3—Do you have any accrual, deferral, and/or inventory for resale amounts to report from the list below? Select Yes or No from the drop-down menu.
    NOTE: Accruals and deferrals are an accounting method which records revenue and expenses when they are earned and incurred, regardless of when payments are received or paid.
    1. If No is selected, skip to Step 21.
    2. If Yes is selected, continue on to Step 11.
      NOTE: Select Yes if there are accruals (e.g., Accounts Receivable, Accounts Payable), deferrals (e.g., Prepaid Expenses, Unearned Revenue), and/or inventory for resale items to report on your Fact Sheet.
  9. Click the Save for later button at the bottom of the form to save your information.
  10. If you selected Yes for having accruals, deferrals, and/or inventory for resale to report, complete the following steps:
    1. Click the Download Excel File button to download the current year’s Fact Sheet Excel Attachment; and
    2. Save it to your computer’s desktop or shared drive.
      NOTE:It is essential that you use the current year’s Fact Sheet Excel Attachment. You must use the current version to ensure that the proper year-end cutoffs are being utilized within the related formulas. If you use an older version of the attachment, you’ll have to re-submit your information with the current version.
  11. Accounts Receivable: Complete the Accounts Receivable tab in the Fact Sheet Excel Attachment, if applicable. Review all information and cell comments on the tab for additional guidance in completing the tab.
    NOTE: See Accounts Receivable Reference Tool for further procedures on how to complete this tab.
  12. Inventory for Resale: Complete the Inventory for Resale tab in the Fact Sheet Excel Attachment, if applicable. Review all information and cell comments on the tab for additional guidance in completing the tab.
    NOTE: See Inventory for Resale Reference Tool for further procedures on how to complete this tab.
  13. Prepaid Expenses: Complete the Prepaid Expenses tab in the Fact Sheet Excel Attachment, if applicable. Review all information and cell comments on the tab for additional guidance in completing the tab.
    NOTE: See Prepaid Expenses Reference Tool for further procedures on how to complete this tab.
  14. Accounts Payable: Complete the Accounts Payable tab in the Fact Sheet Excel Attachment, if applicable. Review all information and cell comments on the tab for additional guidance in completing the tab.
    NOTE: See Accounts Payable Reference Tool for further procedures on how to complete this tab.
  15. Unearned Revenue: Complete the Unearned Revenue tab in the Fact Sheet Excel Attachment, if applicable. Review all information and cell comments on the tab for additional guidance in completing the tab.
    NOTE: See Unearned Revenue Reference Tool for further procedures on how to complete this tab.
  16. Save the Fact Sheet Excel Attachment to your desktop or shared drive, using a unique file name.
  17. If your Fact Sheet Excel Attachment is complete, attach it to the Year-End Fact Sheet application by clicking the Choose File button. Locate your completed Fact Sheet Excel Attachment from your desktop or shared drive and double-click the name of the file to attach it to your Fact Sheet within the application.
    NOTE: Only one Excel file can be attached to each Fact Sheet. If a corrected file needs to be attached, delete the current file and upload a new copy that includes your changes. All saved Excel files will be converted to a standard naming convention.
  18. Item 4—Comments you’d like to add (optional) Type any comments into this field if needed. This is optional and is simply available in case there are any specific notes you would like to point out to the UAFR processor.
  19. Click the Save for later button.
    NOTE: Skip this step if you are ready to submit the Fact Sheet.
  20. Click the Print Fact Sheet button if you would like a printed copy of your completed Fact Sheet.
  21. Phone—Update the listed phone number, if necessary.
    NOTE: Provide your direct phone number to enable UAFR to contact you with any questions, should they arise.
  22. Click the Submit Fact Sheet button.
    NOTE: Once you click this button, your Fact Sheet is then submitted to University Accounting and Financial Reporting for review.
  23. This message will appear: “The fact sheet has been successfully submitted”. Click the Close Window button.
    NOTE: You are returned to the Year-End Fact Sheet dashboard within the application. The Fact Sheet’s status is then updated to show that it has been submitted and display under the Submitted Fact Sheets section.
  24. Click Logoff to exit the Year-End Fact Sheet application. If you need to complete another Fact Sheet for a different fund code, then re-start the process for the next Fact Sheet.
    NOTE: Each unique self-supporting or health service plan fund needs to have its own Fact Sheet completed and submitted.


Keywords:
factsheets 
Doc ID:
129052
Owned by:
Learning Systems Support in UI Training and Development Resources
Created:
2023-06-15
Updated:
2023-08-07
Sites:
University of Illinois Training and Development Resources