Page 2 - Journal Spreadsheet Upload

Journal Spreadsheet Upload

• New - use to insert a new Journal Sheet. You can add as many Journal Sheets as necessary and enter as many journals
on each sheet.
• Edit. Allows you to select a select a previously created Journal Sheet within the workbook.
• Delete. Allows you to select one or more of the Journal Sheets within the workbook to delete.

• Copy. Allows you to copy a selected Journal Sheet to a new Journal Sheet.
• Import Now. Initiates the online import of one or more of your completed Journal Sheets.
• Write File. This option is not used at Emory.

2. To configure spreadsheet settings and upload parameters click the Setup button.

The Define Options and Defaults page opens.

1

2

Use the Define Options and Defaults page to enter values used for the vast majority of your journal entries.
• Header Defaults are used to set Journal Header defaults:
o Business Unit

o Date (leave blank for today’s date to populate)
Only Emory working days are allowed. Other dates (weekends or holidays) will result in an error.
o Ledger Group (ACTUALS)
o Source (ONL)

o User ID (Network ID)
• General Options should be left as English
• Message Option provides the choice to log errors or errors and successful loads as well as a checkbox to Display Messages
Online.

Page 2 of 8
Emory Confidential and Proprietary Last Revised on 2/28/2020 Return to Table of Contents