Upload a General Journal from Excel - example Opening Balance Journal

When uploading journals you have created in excel

Step-by-step guide

First create the journal in excel

Mandatory Columns in the spreadsheet (use these headers)
1. Date (of journal)
2. Account (Can be Acct)
3. DR (or can use Debit)
4. CR ( or can use Credit)
Optional columns that may follow mandatory columns in the spreadsheet (use these headers) - check with us before using these as they are not yet tested.
1. Link (from list on Journal - Asset, BusinessEntity, Stock, ItemForSale, CompanyDivision, Brand) - note Brand will link to the supplier.
2. Search code (eg for a brand that would be the supplier search code in the system, for Asset it is the Asset Search Code in our system)
3. External reference (normally this would hold the reference that was in the old system)
4. Notes
5. Qty
6. Amount
Note GST is not relevant for General Journals

Once the journal is ready to import

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)
Action > Import from excel > Choose the tab on the spreadsheet you wish to import
2. Journal screen will populate
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.