Upload a Journal from Excel

When uploading journals you have created in excel

Step-by-step guide

First create the journal in excel

1. Mandatory Columns in the spreadsheet (use these headers)
   
   1. Date (of journal)
   2. Account
   3. DR
   4. CR
2. Optional columns that can follow mandatory columns in the spreadsheet (use these headers)
   
   1. Tax Code
   2. GST inc (0 or 1)
   3. Link (from list on Journal - Order, Event, Asset, BusinessEntity, StockTranItem, Stock, ItemForSale, CompanyDivision, Brand) - note Brand will link to the supplier.
   4. Search code (eg for a brand that would be the supplier search code in the system
   5. Notes
   6. Qty
   7. Amount

Once the journal is ready to import

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