Versions Compared

Key

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

...

  1. Download the Journal Entry Import Template Excel file: Journal Entry.xlsx
     
  2. Open the file in Microsoft Excel

    1. Column A: G/L Account # - Required - This must be a valid Aeros ERP G/L Account #
    2. Column B: Debit Amount - Required - This must be a positive numeric value. Either 0 or greater.
    3. Column C: Credit Amount - Required - This must be a positive numeric value. Either 0 or greater.
    4. Column D: Qty Debit - Optional - This must be a numeric value.
    5. Column E: Qty Credit - Optional - This must be a numeric value.
    6. Column F: Description - Optional - Text string.
       
  3. Save the file to your computer or network location and close Excel.

  4. Access the Ledger module.

  5. Click Journal Entries.

  6. Click New.

  7. Specify a Method option.

  8. Optional: If Cash Basis method, select a JE Date.

  9. Select a Period option.
     

  10. Optional: Enter a Description.

  11. Click Save.

  12. Click Import Journal Entry.

  13. Locate the Journal Entry Excel Template file you saved. Click Open.
    The system will now attempt to parse the file and will warn you of any errors.

  14. Click Save. 

 

Video
Multimedia
width800
nameimport_journal_entry.swf
autostarttrue
height600