• A GL Exchange import job includes data from different modules and dates
• For example, it can include Payroll entries dated 6/1/25 and General Ledger entries dated 7/21/25
• The import finishes when GL Exchange completes and updates the General Journal register
• The system groups journal entries by module and posting date
• You can import account, budget, and transaction data into the General Ledger module
• You can also export data from the General Ledger to another financial application
• After exporting, you can review GL transactions to analyze account activity and adjust budgets
• For example, export balances to a spreadsheet. Build next year’s budget, and import it back into the ledger
• You can move data between companies
• Set up export settings in the source company and import settings in the destination company
• When you import transactions, the system creates entries in the General Journal
• It posts them when the General Journal updates
• Exported transactions come from the Transaction Detail (GL_DetailPosting.m4t) file

Before You Begin

• You need exchange settings to import or export data
• If you haven’t set exchange settings, the wizard pops up and asks you to define them
• Before importing XML, check the software path on your workstation
  • You’ll find the path in Library Master Company Maintenance
• General Ledger Exchange supports ASCII, CSV, Excel, and XML file types

Source file layout requirements

Use the General Ledger Exchange FAQs in help files to determine the file types supported and the required layout of the source file. One way to view source file layouts requirements for General Ledger Exchange:

1. Open General Ledger, Utilities, General Ledger Exchange.
2. Click New Exchange Setting button.
3. In the "Welcome" window of the wizard, click General Ledger Exchange link.
4. Under the Related Topics section, click General Ledger Exchange FAQs.
5. Click the plus sign next to What general ledger exchange formats are supported?
6. Click the plus sign next to the applicable format to view file layout requirements.

Import Budget or Transactions

1. Open General Ledger, Utilities, General Ledger Exchange.
2. Click the New Exchange Setting.
3. Follow the Wizard to set up your import job.
4. At Define Account Creation Options, note: The system creates Main and Sub accounts with blank descriptions.
5. At Define Exchange File Type and Name, choose the file type. Click the yellow envelope to browse to the file.
6. Finish the Wizard and choose to run the import.
7. Click Yes when asked to test the exchange setting before importing.
8. Print or preview the import log to verify the results. Choose to print all, imported, or skipped records.
9. Click Yes at the "Continue with import" prompt.
10. Click Yes at the "# out of # records imported. Print an error log?" prompt.
11. Click Yes again at the second "Continue with import" prompt.
12. If importing G/L transactions,
    • Open General Ledger, Main, General Journal
    • After reviewing the import, click Yes to "Do you want to update the General Journal?"

Export General Ledger information

1. Open General Ledger, Utilities, General Ledger Exchange.
2. Click the New Exchange Setting.
3. Go through the wizard and choose the data you want to export.
4. In Define Exchange File Type and Name, pick the Exchange File Type.
5. Type just the file name in Exchange File Name, then press ENTER. The wizard adds the extension for you.
6. When you run the export, the file goes to the path you set in the Exchange File Name.

 NOTE: The default path for Sage 100 Advanced for importing and exporting is the MAS90/Home/Textout folder. 

Import accounts in the exchange setting

• Turn on "Create Main accounts" and "Create Sub accounts" during import if they don't already exist
• If you don't select this, the system only imports full account numbers into G/L Account Maintenance
• When you select this, it won't import account descriptions into Main Account Maintenance or Sub Account Maintenance

GL Exchange File Format Layouts.pdf

Determine the two-digit account code associated with account types in General Ledger
Import General Ledger Accounts with Visual Integrator, or Error: "is not on file" in Job Log
Account descriptions are missing in Main Account Maintenance or Sub Account Maintenance