Skip to content
logo Knowledgebase

Import General Ledger journal entries

Created on  | Last modified on 

Summary

Information on importing General Ledger (GL) journal entries Sage BusinessWorks.

Description

 CAUTION: Before importing, backup company files.  If a problem occurs with the import, restore the backup, correct the import file, and complete the import process.

Resolution

  • For instructions on importing journal entries, see Import GL journal entries.pdf.
  • For a company-specific example file, select GL, Transfer, Export Journal Entries. Then export today's journal entries.
  • Also, you can review an example of the import file called jdtrans.csv.

Tips

  • The system verifies the import file before processing journal entries and generates an Import File Exception Report.
  • During processing, the system checks each entry’s date, account number, and balance.
  • The system doesn’t transfer entries that fail validation.
  • The system imports only comma‑delimited (.CSV) files.
  • Refer to the other program’s documentation for instructions on creating a .CSV export file.
  • Use a text editor to review the import file and confirm it meets all formatting requirements before importing.

NOTE:

This is important for the journal entry date. It must be in the format MM/DD/YY.

  • If the data doesn’t transfer correctly, open the file in a text editor. Then correct any issues and try the import again.
  • Keep the import file until you confirm the results of the transfer.
  • If you cancel the import before it finishes, some journal data imports that will create incomplete information.
  • Review the data carefully and delete or correct any issues as needed.
  • If necessary, restore your original data from a backup and reattempt the import.

Need more help?

Chat now

 

Related Solutions