Journal Entry Import
The Journal Entry import is designed to import simple journal entries using non sub-ledger accounts.
1. Create the template
To export the template, navigate to General Ledger -> Adjusting Journal Entries and use the Action Menu -> Import Entry.
The import template is designed to import a single journal entry. If you need to import multiple entries, you can export multiple templates or make copies of the first template you create.
Leave this window open to import the completed template.
At the prompt, select Template then click OK to choose the location to save the file. The template will be saved as: AJE_Import_Template.xlsx
2. Enter the journal entry info
Enter the info in the template as per the instructions below. Save the file before importing.
- Post To Date: This will be auto-assigned with the current date, which can be modified if necessary.
- Memo: The template is exported with a default memo, which can be modified.
- GL Account Code and/or Account Import Code: At least one of these fields is required to map the journal entry to the correct accounts.
- Debit & Credit: One these fields is required per line item.
The template can have as many line items as necessary as long as the debit and credit totals are in-balance.
3. Import the template
To import the template, use the Action Menu -> Import Entry, select Import at the prompt then click OK and select the XLSX file.
The system will alert the user and reject the import if any necessary data is missing, invalid or out of balance.
4. Journal entry has been imported
Here is an example of the journal entry that was imported based on the above template example.
This entry can now be modified or voided, if necessary, and it still needs to be posted in order to be recorded on the general ledger.
