Page 6 - Journal Spreadsheet Upload
P. 6

Journal Spreadsheet Upload








                                   1      2      3         4                    5      6







        1.  Enter the Business Unit in the Unit cell.
            •   At least one journal line must contain the Business Unit in the Header Line.

        2.  Enter ACTUALS (all caps) in the Ledger cell.

        3.  Enter the five-digit Account number in the Account cell.

        4.  Enter the ten-digit SpeedType in the SpeedType cell.

        5.  Enter an Amounts with no more than two decimal places in the Amount cell.  Make sure the
            journal balances.
        6.  Enter a Description of 30 characters or less in the Description cell.

            •   Review the information in each cell and edit as needed.
            •   Save your spreadsheet as you would any other spreadsheet.
            •   Your journal entry is ready to be imported into Compass.


        Importing Journals

        It is not necessary to be logged into Compass to import journals. However, you must be connected to the
        Emory network.
        You can import directly from an open journal sheet by clicking the database icon or from the Home page as
        shown below.




          1



        1.  Click the Import Now button from the Spreadsheet Journal Import Home page.


















                                                                                                            Page 6 of 8
        Emory Confidential and Proprietary           Last Revised on 2/28/2020                  Return to Table of Contents
   1   2   3   4   5   6   7   8