General Ledger Account Export

Menu Path: General Ledger $Images\bluerarw.gif$ Consolidated Ledger Management $Images\bluerarw.gif$ General Ledger Account Export

Purpose

Export general ledger accounts to an external file.

Overview

Use General Ledger Account Export to export general ledger accounts to an Excel file. The accounts can then be imported into a different ledger or database in General Ledger Account Import.

Note Variable allocation, fixed allocation, and summary accounts are not exported. You must delete the column headings in the Excel file before importing it back into Apprise.

Exporting General Ledger Accounts

To export general ledger accounts:

If you are using consolidated ledgers, enter or select the ledger for which you want to export accounts.
Click the Export button in the ribbon to export accounts to an Excel file. The Excel file includes all columns required to import accounts into Apprise. For import format information, see General Ledger Account Import Format.

Ribbon Home Tab Buttons

Button	Description
Exit	Click this button to close the General Ledger Account Export window.
Export	Click this button to start the export process.

Select Tab Fields and Buttons

Note This tab is only available if you are using consolidated ledgers.

Field or Button	Description
Ledger ID	Enter a ledger for which you want to export general ledger accounts, or click the Lookup button to select a ledger.

Print Options Tab Fields and Buttons

Field or Button	Description
Output Option	The Excel radio button is selected to indicate you are exporting to Excel.
Excel Format Name	Enter an Excel format name, or click the Lookup button to select an Excel format name. Excel formats can be set up to specify which fields are output to Excel, and the order and sort order of the fields.
Format Maintenance	Click this button to display Excel Format Maintenance, which allows you to set up Excel formats.
Print Full Heading on All Pages	This check box is disabled in this window.
Print Title Line on All Pages	This check box is disabled in this window.
Report Language 1	Enter the first language for the report, or click the Lookup button to select a language.
Report Language 2	Enter the second language for the report, or click the Lookup button to select a language. If you enter a language in this field, the report is printed in this language and the language entered in the Report Language 1 field.
Horizontal Shading	This check box is disabled in this window.
Collate	This check box is disabled in this window.
Horizontal Shading Color	This field is disabled in this window.
Number of Copies	This field is disabled in this window.