Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Use the Journal Entry screen to import Journal Entry detail lines.

Pre-Requisites

  1. G/L Accounts
  2. Accounting Periods
  3. Journal Entry Import Template

Step-by-Step Guide

  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
  • No labels