G/L Chart of Accounts Report

Overview

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.

Information Printed on This Report

The following information is 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. More...
  • 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 net changes in accounts for 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 amounts for 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.)
  • Account Configuration. The Account Configuration column displays letter codes for each account, with 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

    • 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
  • Control Accounts. 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.
  • Post In. 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.