Table of Contents

When uploading journals you have created in excel

Step by step example of uploading file from ePayroll

Export the file from ePayroll 

1. Ensure your ePayroll account has had the GL Accounts uploaded and mapped first
2. Export the file from epayroll = this will be a csv normally.

Make some changes to the file to get it ready for import - and save it as a .XLS file (File-save as)

Drag the XLS file over the general Journal grid

Step-by-step guide example of opening balances journal

First create the journal in excel

1. 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)
2. 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
3. Note GST is not relevant for General Journals

Once the journal is ready to import - Drag the XLS over the grid in the General Journal 

1. 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. 

Choose the Excel Tab to import

1. Action > Import from excel > Choose the tab on the spreadsheet you wish to import
   1. 1. 

The Journal screen will populate

Save

1. If the journal does not balance you will get an error message and journal will not saveIf there are GL accounts the system does not recognise
2. 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
   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

Save the Journal

Clear

Import the next tab.

Related articles