Page Comparison

When uploading journals you have created in excel

Step-by-step guide

First create the journal in excel

...

1. Drag the XLS over the grid in General Journal
   1. A confirmation will ask if you meant to do this
   2. A confirmation will confirm the file is available for the session you are logged in for (if you log out you will need to do upload the file again)
2. Action > Import from excel > Choose the tab on the spreadsheet you wish to import
   1. 1. 
   2. Journal screen will populate
      1. 
   3. Save
      1. If the journal does not balance you will get an error message and journal will not save
      2. If there are GL accounts the system does not recognise
         1. The journal will not save
         2. A note will popup with a list of the problems
         3. There will be an indicator on the lines in the journal for you to review / adjust
      3. If there are values outside a reasonable range (example very small values like 0.0000000000001
         1. The journal will not save
         2. A note will popup with a list of the problem accounts - review and adjust
   4. Save the Journal
   5. Clear
   6. Import the next tab.

Related articles

...