Chart of Accounts Report — Features

This report lists all or a range of General Ledger accounts according to the selection criteria and the sort and format criteria you specify.

For instructions on printing the report, see Chart of Accounts — printing.

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.

Information printed on the report

• The range of account numbers, segment codes, account groups, or account sorted group you specified for the report.

• The order in which accounts are listed, by account number, segment, account group, or account sorted group.

• The type of information you are printing:

• 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 the 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 period balances of two fiscal sets. Your choices for comparison are Actuals, Budget 1 through Budget 5, Provisional Actuals, Quantity, and Provisional Quantity.

  You can also choose the Use Rolled Up Amounts option to print the amounts of the rollup account and all of its rollup member accounts (at any level), rolled up into a single amount for each period. (The rollup member account amounts are included only once in the rolled up amounts.)

• Rollup Accounts

  Choose either "Members" or "Rollup Accounts" to print the amounts of the parent account and/or all of its child accounts (at any level), rolled up into a single amount. (Child account amounts are included only once in the rolled up amounts.)

• The Account Configuration column displays letter codes for each account, in a definite order, each code followed by a comma. The first code represents the account type, followed by the code for the account balance type, followed by the code for the currency type, followed by the code for a rollup account (only when the account is a rollup account or a rollup member, if not, no code appears in this position).

Account Type codes include:

B = Balance sheet account

I = Income and expense account

R = Retained earnings account

Account Balance Type codes include:

CR = Credit account

DR = Debit account

Currency Type codes include:

M = Multicurrency account

F = Functional currency

Rollup Account codes include:

R = Rollup account

M = Member of a rollup account

B = Both a rollup account and a member of a rollup account

• The Control Accounts column indicates whether an account is a control account. To see which ledgers use the control account, print the Control Account Subledgers version of the report.

• The Post In column displays whether to post in detail or consolidated format, or whether posting to this account is prohibited.

• For a Rollup Account report, the report displays all rollup accounts, all of their directly-related rollup member accounts, and a Yes/No field to indicate if those rollup member accounts are themselves rollup accounts.

See also

General Ledger reports

Printing the Chart of Accounts report