Import Journals

Overview

"Import Journal" enables import of general ledger data from a comma separated variable (csv) file. A csv file can be created via export from any popular spreadhsheet or database program. Imported journal entry data is available for review and post via the "Journals-> Entry" menu option. The input source file is described by the import layout selected during the import process. Import layouts are defined via the "Administration->Import Map" menu option.

Processing

Type set description, reference, ledger, accounting year and period, import layout and optionally a gl account number translation code name and select a file to upload. If file is retrieved successfully, press Process to schedule the upload for journal creation. A notice will be received when the imported journal is available to post.

Entry tips

Type "?" in a promptable line edit and press TAB to view or select a code value. Click on the desired code in the related selection display to select the code.

Import fields