How to create a custom journal import template

Owned by Knowledge Assistant
Oct 15, 2024
1 min read
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