/
How to create a custom journal import template

How to create a custom journal import template

Description of Issue

How to create a custom journal import

Context
  • Import journal

  • Custom

  • GNI

  • GEN

  • Budget

  • Encumbrance

Cause

Resolution

General Ledger Menu > Journal Entry / History > Import Journals


  1. Click Custom Templates

  2. Click Create Template

  3. Select the Template layout

  4. Enter a Name for the template

  5. Enter a Delimiter (if needed)

  6. Use browse to locate the saved excel file

  7. Check off First line contains headers or Attempt field matching based on headers if they are applicable.

  8. Click Upload

At this time the Journal Import Templates program opens

For each column select a header that explains what that column is being used for. (example: Org, Object, Project, Full Account, Debit Credit, Gross, etc.)

       9. Click Save 

      10. Exit the program

Now the Import journal program can be accessed and the new Import journal template used.

Additional Information

Once the journal is imported, it can be released and posted from Accounting Entries or the specific proof program for the journal type:

  • GNI (GEN), GCR : General Journal Entry/Proof

  • BGA/BGT : Budget Transfers/Amendments

  • GEL : Encumbrance Journal Entry/Proof









Related content

Import Journals- template to use for Standard Excel Import
Import Journals- template to use for Standard Excel Import
More like this
Journal Import error Unable to import journals - custom import template has a blank column header
Journal Import error Unable to import journals - custom import template has a blank column header
More like this
Import Journals using Template - Error Gross 0.00 No amount exists for import
Import Journals using Template - Error Gross 0.00 No amount exists for import
More like this
Error importing using a custom template - The selected template expects a file with more columns
Error importing using a custom template - The selected template expects a file with more columns
More like this
Import Journals - Neither account number nor allocation code can be found Pre-edit error
Import Journals - Neither account number nor allocation code can be found Pre-edit error
More like this
How to import a journal
How to import a journal
More like this