Skip to main content

IMPORT Journal Transactions

Journal Transaction Import Process

Preparing the file for import

  1. Create the Excel® import file using the following format:

  • Column A contains the effective date.

  • It is required that the effective date (format: mm/dd/yyyy) exists on Row 1.

  • It isn't necessary to have the effective data on all rows but it's ok if it exists on all rows of Column A as the system will ignore the additional rows.

 

  • Column B contains the General Ledger Account number.

  • A valid GL Account number is required in Column B on ALL rows.

 

  • Column C contains the debit or credit amount

  • The format must be a negative or positive number with 2 decimal places. No commas are allowed.

  • Column C cannot be blank (you may enter 0).

  • Column C total must be in balance (0.00) but do not include the total for the import!

 

  • Column D contains the Journal Transaction description.

    • Type: JT Import Single Desc

  • It is required that a description exists on Row 1

    • This becomes the description for every other line that shows on the GL activity.

  • Type: JT Import Single Desc

  • Each row can have a unique description that will show on your GL activity.

 

 

 

  1. Example data file(s): Do not use a header row

Type: JT Import Single Desc                                 Type: JT Import Multiple Desc

Image                      Image

 

Column A: For the Date formatting, if you don’t see mm/dd/yyyy then use custom format and change the Type:

Image

Column C: Make sure the value/amount column is formatted correctly.  Number, 2 Decimal, NO Comma!

Image

Save as:  CSV (Comma delimited)

Image

  1. Importing the Journal Transaction

System Administration>Utilities>Import Files>Import Files

 

  • Choose file import: Right click or F6 in the Import Name field and choose the JT Import option Single or Multi as described above.
  • At the File Location Browse for the file you want to import.
  • You may choose to check or ignore the Remove After Update option (Note: if the option to Remove After Update is checked, your file will be deleted after import).
  • Leave ‘There is a Header Row’ option unchecked!
  • Ignore the Import Parameters grid.
  • Click the Process icon.

Image

 

  • The import will process and return a JT number if successful.

          Image

 

              If you encounter an error, it is most likely due to a formatting issue, check your file formatting (Date formatting, Number formatting, no headers, no column totals)

             

  1. You are now ready to review and post the Journal Transaction

 

General Ledger>Journal Transactions>Enter Journal Transactions.

 

This transaction will be suspended. Enter the Journal Transaction number or right click and choose the F8 List Suspended option to find the Journal Transaction.

 

Then save to be added to normal Post Subsidiaries process, or click the Post icon. 

**If at any point you run into any issues, feel free to email [email protected] for assistance.**