Versions Compared

Key

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

...

When uploading journals you have created in excel - see also Importing Open Transactions

Columns in XLS to create multiple journals in the system

One Journal will be created for each date listed.

Note

GST direction must be chosen when uploading to a general journal


  1. Date = D/MM/YYYY
  2. Account = Account Code
  3. Notes
  4. Dr = $ Amoujnt
  5. Cr = $ Amount (only one column to have a value
  6. Tax = Tax code eg GST or NA
  7. Tax Amt = GST tax $ amount
  8. GST Inc = Y or NA

Step by step example of uploading file from ePayroll

...