WELCOME TO GMS ACCOUNTING ONLINE HELP
The help you need at your fingertips.
You are here: General Ledger > G/L Supplements > #418 Journal Entry Import
#418 Journal Entry Import
Function
The Journal Entry Import supplement allows you to import Excel, comma delimited or tab delimited files to form a journal entry batch.
Things You Should Know
Column B Program Element
Column C Project
Column D GL Code
Column E Debit
Column F Credit
Column G Vendor Code
Note: column g is used if you are importing a journal entry that represents an ACH debit payment to a vendor.
Instructions
File Format: Select Excel, Text or CSV
Import From: Browse to locate the file you wish to import.
Date: Select the date you wish entered in the Date field in each journal entry in the batch.
Posting Period: Select the Posting Period. This must be the last day of the month.
Batch Description: Type in the batch description (optional)
Import: Click this button to create the journal entry batch.
The message “The General Journal Batch has been imported. You need to check the General Journal Batch to make sure all data has imported correctly” will appear. Click OK.
The General Journal Batch will appear on the screen. Check the batch, edit if needed, and Post.
The Journal Entry Import supplement allows you to import Excel, comma delimited or tab delimited files to form a journal entry batch.
Things You Should Know
- If you wish to import journal entries from a file prepared in spreadsheet software, the structure needs to be entered in the following manner:
Column B Program Element
Column C Project
Column D GL Code
Column E Debit
Column F Credit
Column G Vendor Code
Note: column g is used if you are importing a journal entry that represents an ACH debit payment to a vendor.
- Should you be importing a journal entry for an ACH Debit and there is a vendor code in column G, the GL code in column D must represent an asset account for the line that contains the credit side of the entry. This is because a typical ACH transaction is a credit to a cash account.
- Put in both a debit and credit for each line by entering a zero under column E or F as appropriate.
- Save the file with an Excel file extension or the extension of the spreadsheet software you are using.
- The same description needs to be entered for every record of the journal entry. Document numbers will be assigned for each different description that is found.
- If you prepare your spreadsheet to be imported using more than 2 digits to the right of the decimal point, please be aware that the amounts in the file will be rounded to whole cents during the import process.
- Should you import a file containing inactive elements or GL codes, the process will be stopped and a list provided of the inactive codes.
Instructions
File Format: Select Excel, Text or CSV
Import From: Browse to locate the file you wish to import.
Date: Select the date you wish entered in the Date field in each journal entry in the batch.
Posting Period: Select the Posting Period. This must be the last day of the month.
Batch Description: Type in the batch description (optional)
Import: Click this button to create the journal entry batch.
The message “The General Journal Batch has been imported. You need to check the General Journal Batch to make sure all data has imported correctly” will appear. Click OK.
The General Journal Batch will appear on the screen. Check the batch, edit if needed, and Post.