General Ledger Journal Entry Import

The General Ledger Journal Entry Import allows you to create journal entries in Agility using a spreadsheet. Agility allows you to create multiple journal entries into different periods with one import. The Posting period and year must be specified to do multiple period journal entries.

To access the Journal Entry Import:

General Ledger > Journal Entries > Import Journal Entry 

Create new Journal Entry Import Definition

Select to Add new record

The JE Import Definition Maintenance window will open. Name the Definition and select the path to the saved file.

In the Action section, assign the number of header rows and where the posting period and year will be specified (journal entry header tab or journal entry import screen). If you have multiple journal entries, specify how they are broken out on your spreadsheet.

On the JE Header tab, populate the fields/values you need specified.

On the JE Detail tab, populate the fields/values-these should match the same fields/values you would see when manually entering a journal entry. Click Save in the top left corner when done assigned the columns and data.

The spreadsheet can contain separate columns for credits and debits or a single column that contains both amounts. If the amounts are within a single column, the credit amounts need to be negative or the spreadsheet must include a column that identifies the amounts as credits or debits to create the journal entry.

Process the JE Import

If you will be using the Main screen to specify the posting period, year, and Batch ID, enter those values after selecting the Import definition.

Prior to processing, use the Validate command to create and review the audit report which identifies invalid accounts, invalid amounts and prints a message at the end of the report if the journal entry is not balanced.

Once you have verified the audit report is in balance and correct, click "Process". When the entry is made you will see a message with your journal entry number as well as be provided an audit report.