Journal Spreadsheet Upload Process
The journal spreadsheet upload replaces the eIV/JV(Electronic IntraInstitutional Voucher/Journal Voucher) upload process. Rather than using the NUPortal, you may want to use the journal spreadsheet method if you have many Actuals Journals to process.
Registered users will use an Excel template to record journal lines. These journal lines may include any combination of ChartFields for general purposes, (including balance sheet transactions, adjusting, and correcting entries) but are limited to one purpose per journal spreadsheet. The journal spreadsheet may contain hundreds of lines, but will be processed as one journal. Charges are submitted, using the spreadsheet naming conventions described below, as a standardized excel spreadsheet via e-mail to email@example.com. Refer to detailed instructions regarding Creating a Journal Spreadsheet. Current registrants and assigned masks can be found here.
When saving your Journal Spreadsheet us the following format: your 3-character code (mask) plus today’s date.
If you submit more than 1 spreadsheet per today the format should be your 3-character mask plus today’s date plus an alpha character A, B, C, etc.
After the journal spreadsheet has been approved by Accounting Services, the Excel file will be converted into a text file (flat file) and uploaded into NUFinancials. Charges appear in NUFinancials generally on the same day. Charges can be verified by performing an Actuals Journal Search on the NUPortal under the Finance & Accounting tab. See the NUFinancials training materials for Searching for Actuals Journals Using the Actuals Portal.
Note: If there is a problem with the submission and the journal spreadsheet cannot be processed, you will be notified by email. You will be required to correct errors and then resubmit the journal spreadsheet. Once the new spreadsheet has been received the original (flawed) spreadsheet will be deleted by Accounting Services.
To begin using the Journal Spreadsheet, departments must be enrolled in the program. Departments must first complete a Journal Spreadsheet Registration Form. This form provides Accounting Services with the information necessary for approving a department for journal spreadsheet submissions into NUFinancials. Three character alpha codes (masks) are assigned to each department. (You may request a specific mask.) Additionally, masks may be set up for each submitter within a department.
If you were previously registered for the eIV/JV process in CUFS, please complete the Journal Spreadsheet Re-Registration Form.
Please complete form, print out, sign and date, and return to:
Dave Ackermann, Accounting Services
619 Clark Street, Room 222
Evanston, IL 60208
When the registration is approved, your department mask will be e-mailed to you and you’re ready to start submitting Journal Spreadsheets. The Registrants Spreadsheet has a complete listing of registered journal spreadsheets and their corresponding masks & contact information. These masks are incorporated in the first 3 characters of the Journal ID (ie. BUR – Bursar's Office Spreadsheet), which is helpful when searching for transactions. The source on all journal spreadsheets is ASC.
For NUcore Users/Administrators Only - visit the NUcore website to download the NUcore Journal Upload Registration form and for additional information about the NUcore transaction processing system
- See the Creating a Journal Spreadsheet Training Guide for detailed instructions regarding how to complete the journal spreadsheet.
- Searching for Actuals Journals Using the Actuals Portal training materials
- Journal Spreadsheet Excel template (zipped file)
- NUPortal https://nuportal.northwestern.edu
- Journal Upload Registration Form
- Journal Upload Re-Registration Form
- 90-day Policy for Journal Entries
- NUCore User/Administrator website
Using the journal spreadsheet?
Contact Elizabeth Gladic of Accounting Services, at firstname.lastname@example.org or 847-491-5338