Import General Ledger journal entries

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

Solution Properties

Solution ID: 223924450035010
Last Modified Date: Wed Feb 25 20:13:03 UTC 2026
Views: 0