Versions Compared

Version Old Version 2 New Version 3
Changes made by

P Sawkins (Unlicensed)

P Sawkins (Unlicensed)

Saved on

Key

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

...

  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

...