Printing the G/L Chart of Accounts Report

The Chart of Accounts Report lists all or a range of General Ledger accounts according to the selection criteria and the sort and format criteria you specify.

At printing time, you can select accounts by account number, segment, account group, account sorted group, or optional field. Then specify the type of report and range of entries, either accounts or segments, you want to print.

To print the Chart of Accounts report:

1. Open General Ledger > G/L Reports >  Chart of Accounts.

2. In the Report Format field, select one of the following formats from the list:
   • Detail – Short Form. Shows basic setup information, including account number, description, status, account configuration, and consolidation and allocation options.
   • Detail – Long Form. Prints short form information plus account groups and segment closed to.

     You can also choose whether to include the optional account and transaction details fields (and their values) that are defined for each account.

   • Valid Currencies. Shows the currencies that are valid for each multicurrency account, whether revaluation is allowed, and, if so, the revaluation code.
   • Allocation. Shows the accounts to which balances are allocated, along with the percentages going to each account.
   • Control Account Subledgers. Lists the control accounts in the general ledger, along with the subledgers that use them.
   • Fiscal Set Comparison. Lets you compare the net changes in accounts for two fiscal sets. Your choices for comparison are Actual, Budget 1 through Budget 5, Provisional, Quantity, and Provisional Quantity.

     Fiscal set comparison options include Budget sets 2 through 5 only if you are using Sage 300 Premium ERP.

   • Rollup Accounts. A report that shows all rollup accounts and their directly related rollup member accounts. You can also print a list of all rollup accounts related to a member account or to a group of member accounts.

3. If you selected Fiscal Set Comparison as the report format, on the screen that appears, specify the two sets of figures you want to compare:

   1. In the Compare Fiscal Set 1 and Compare Fiscal Set 2 fields, specify the fiscal set data type.
   2. Specify the year for each fiscal set you are comparing.
   3. If General Ledger is multicurrency:
      1. In the Using field, specify whether to display figures in Functional or Source currency
      2. In the For Currency field, specify the currency.

         If the euro is your functional currency and you specified a reporting currency, you can select the Reporting Currency option. The report then prints amounts in the reporting currency (obtained from the reporting fiscal set).

4. To exclude accounts that have zero balances and that had no transactions in the specified period range, select Exclude Accounts with No Activity.

   Note: You must select the same year in both the From field and the To field.

5. To print a set of common account groups, but not other account groups, select Select Account Groups by Sort Code Range.

   Note: All account groups in the set must use the same sort code to print in order of sort code.

6. To exclude inactive accounts, select Exclude Inactive Accounts.

7. If you use optional fields and you are printing the long form of the report, you can include optional field information on the report.

   Click the Include Optional Field option to include this information on the report.

8. If you are printing the Rollup Accounts report, in the Show field, select Members or Rollup Accounts.
9. Select the sort order for the report, and a range of the item by which you are sorting. More...
   • You can order the report by account number, any segment of the account number, account group, account sorted group.
   • You can sort by account group by choosing the Select Account Groups By Sort Code Range option.
10. Select accounts by specifying ranges of account groups, account sorted groups, account number segments (that you have not already been specified as the sort order), or the range of optional fields.
11. Click Print.

Related Topics