Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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)
      1. Image Added
  2. Action > Import from excel > Choose the tab on the spreadsheet you wish to import
    1. Journal screen will populate
    2. 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
    3. Save the Journal
    4. Clear
    5. Import the next tab.

...