- Controller’s Office
- Reports and Forms
Reports and Forms
Below are business forms for submission of financial transactions to the Financial Management System. These are Excel and Word files.
Online Financial Forms
Credit Card Journal (XLSM) Rev. 11/11/21
Interagency Journal (XLSM)
Rev. 11/11/21
-- Instructions (DOC)
Interdepartmental Sales Journal (XLSM)
Rev. 11/11/21
-- ISJ Instructions (PDF)
Journal Entry - Long (XLSM)
Rev. 11/11/21
Journal Entry - Short (XLSM)
Rev. 11/11/21
Payroll Transfer Journal (XLSM)
Rev. 11/11/21
-- Instructions (DOC)
Scholarship Form (XLSX)
Rev. 9/8/21
Scholarship Form - Foundation (XLSX)
Rev. 2/18/16
Reference Information
- Account Code List (XLS)
Full listing of detail Account Codes for Revenues, Expenses, Assets, Liabilities, and Equity.
Rev 5/14/10 - Account Code Quick List (XLS)
List of the most commonly used Expense Account Codes.
Rev. 6/6/07 - Campus Query Overview (XLS)
- Cost Center Listing (XLSX)
List of full Fund Source Information (Fund, Cost Center, Class and where applicable, Project/Grant) for each Cost Center and Project/Grant.
Updated daily - HR Account Quick List (XLS)
List of Account Codes used in processing Payroll charges.
Rev.10/14/02 - Journal Helper (XLS)
A worksheet aid for finding full Fund Source information.
Rev. 9/4/08 - Reporting Tree - Bond Revenue (PDF)
Hierarchical listing of Bond Revenue Cost Centers grouped by organization structure.
Rev. 8/27/2021 - Security Tree - NIU (PDF)
Hierarchical listing of NIU Cost Centers grouped by organization structure.
Rev. 8/27/2021 - Source Code Listing (XLS)
- Sample HR Detail w/Overtime Reporting (XLS)
Sample Personnel Service Detail Report showing how overtime is included in the report.
Rev. 6/4/02 - Sample FSR with Fund 41 (XLS)
Sample of Fund 41 on the Financial Summary Report
Rev. 12/6/04
Unrelated Business Income Tax (UBIT)
Questionnaire to determine compliance with Internal Revenue Service requirements on Unrelated Business Income Tax
Important Note: On July 1, 2022, links on the Organizational Report Index were updated to reflect the new location of reports due to the relocation of the university divisional and department reports. If you use desktop shortcuts, browser favorites, network links or mapped drives, you may need to update these references using the updated Organizational Report Index.
If a user only logs into their local workstation or logs into a domain other than NIUNT, the user will be challenged with a login prompt when initially accessing a report directory.
All users have a Windows NIUNT managed by DoIT. If you are having access problems, contact the Service Desk.
DoIT provides a password checker function on the Password Self-Service.
It may be necessary for you to visit the DoIT Accounts page and change your password according to DoIT password specifications to force a password synchronization and to ensure that the password conforms to DoIT guidelines. Users may contact the help desk at 815-753-8100 for assistance regarding their NIU login ID and password.
Latest Report Posting Information
- The Organizational Report Index Document and associated WEB financial report directories have been updated to reflect the new university structure as of the close of business Friday, July 1, 2022.
- FY2024 Period 9 Summary, Period Detail, Obligation, Account Receivable, Human Resources and current Budget Detail Reports with activity posted through 3/29/2024 were added to the web on 3/29/2024 at 11:05 p.m.
- FY2024 Period 8 Summary, Period Detail, Obligation, Account Receivable, Human Resources and current Budget Detail Reports with activity posted through 3/11/2024 were added to the web on 3/11/2024 at 10:45 p.m.
- FY 2024 Period 7 Summary, Period Detail, Obligation, Accounts Receivable, Human Resources and current Budget Detail Reports with activity posted through 2/9/2024 were added to the web on 2/9/2024 at 10:20 p.m.
- FY 2024 Period 6 Summary, Period Detail, Obligation, Accounts Receivable, Human Resources and current Budget Detail Reports with activity posted through 1/10/2024 were added to the web on 1/11/2024 at 1:30 a.m.
- FY 2024 Period 5 Summary, Period Detail, Obligation, Accounts Receivable, Human Resources and current Budget Detail Reports with activity posted through 12/1/2023 were added to the web on 12/1/2023 at 11:20 p.m.
- FY 2024 Period 4 Summary, Period Detail, Obligation, Accounts Receivable, Human Resources and current Budget Detail Reports with activity posted through 11/9/2023 were added to the web on 11/9/2023 at 10:50 p.m.
- FY 2024 Period 3 Summary, Period Detail, Obligation, Accounts Receivable, Human Resources and current Budget Detail Reports with activity posted through 10/9/2023 were added to the web on 10/10/2023 at 10:45 p.m.
- FY 2024 Period 2 Summary, Period Detail, Obligation, Accounts Receivable, Human Resources and current Budget Detail Reports with activity posted through 9/11/2023 were added to the web on 9/20/2023 at 2:30 a.m.
- All files are named to provide distinctive names within the 21 character web filename limitation. The following are the report naming conventions:
OOOOOOO_FF_YYYY_PP_NRRRgl.xls
Where OOOOOOO is the cost center, FF is the fund, YYYY is the fiscal year, PP is the accounting period, N designates an NIU developed report layout, and RRR is the report name as follows: FSR - Financial Summary Report, HRS - Human Resources Period To Date, OBL - Obligations Period To Date, PRD - Period Actuals Detail.
Organizational Report Index (XLSM) (Last Updated July 1, 2022)
These files require log-in with NIU faculty/staff or student ID and password in order to download.
Saving and Accessing Files
- Click on the desired form name.
- At the prompt save it to disk, navigate to the appropriate folder to save the file and save it.
- Minimize the browser and go to the folder where the file has been saved.
- Double click on the file to execute Excel and load the form.
Some adjustments and minor page tuning for your particular workstation and printer(s) may be necessary depending on your video resolution and printer characteristics.
General Notes Regarding Forms
- To access Word or Excel files, please use Office 2000, Office XP, or Office 2003. The macro security level for Office 2000, XP, or 2003 needs to be set to Medium for the forms to function properly.
- For Internet Explorer 6.0 and higher browser, the forms may be opened and completed in the browser. The macro buttons are fully functional in the browser. Be sure to save your completed form for your records.
- The PDF versions require Adobe Acrobat Reader 5.0 or higher installed on your system.
Download the latest version of Adobe Acrobat.
Contact Us
Controller’s OfficeLowden Hall 201
815-753-6178
Fax: 815-753-6446
controlleroffice@niu.edu
