Import Journal Entries

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.