Consolidated Ledger > Consolidation Reports > Consolidated Ledger Listing

The Consolidated Ledger Listing displays detailed debit and credit transaction amounts that were posted to the consolidation company GL Account IDs. These transactions are consolidated from the subsidiaries to the consolidation company. You can run a report for any period of the prior, current and future year; however, the range of periods that you select should be within the same fiscal year.

This report has the following uses:

•To aid in reviewing and verifying the detailed transactions of a particular GL Account ID against the subsidiary ledger and supporting documents.

•For reference in reconciling balances displayed in the Trial Balance.

Note: This report is only accessible from within the consolidation company.

To print the Consolidated Ledger Listing, follow these steps:

1.Access the Consolidated Ledger Listing function from the Consolidation group of the Reports main menu.

2.Select the report configuration that you want to use by clicking the List box button beside the Configuration field.

3.Click the List box button beside the Sort By field and select one of the following sorting options:

•Account ID

•Specific segment type such as Account #, Division or Department

4.Click the List box button next to the Layout field and select the desired layout for the report.

5.In the Type area select whether you want the report to be displayed in Detail, Subtotal or Grand Total.

6.Mark the applicable checkboxes in the Report Header area if you want to Include Time or Include Printed By information in the report header.

7.In the Report Configuration area, define the desired report filters. You may mark the Individual checkbox if you want to generate the report for a single record and enter the appropriate value in the adjacent field; otherwise, select in the Filters area the desired criteria in generating the report.

Note: The available fields in the Filters area may vary when you select a different sorting option.

8.In the Period Range area specify the range of periods to which the transactions that you want to include in the report are posted. You can choose the range of period by clicking the Year and Period fields.

Note: You can choose any fiscal year since the consolidation company was created provided that historical data was not pursed.

9.If applicable, mark any or all of the following checkboxes:

oInclude Accounts with No Transactions

Mark this checkbox if you want the report to display the GL Account IDs with no transactions.

oInclude Zero Balance Accounts

Mark this checkbox if you want the report to display the GL Account IDs with zero balances.

oEach Account on New Page

Mark this checkbox if you want the report to display the transactions posted to each GL Account ID on a page that is separate from the other GL Account ID’s transactions.

oIgnore Summary Settings

Mark this checkbox if you want AccountMate to ignore the “Transfer as Summary” setup in the GL Account ID record and display the GL Account ID details.

10.Click the Preview or Print button to preview or print the report. Click the Configure tab to return to the report configuration page.

The Consolidated Ledger Listing function also provides you with flexibility to perform the following:

Consolidated Ledger Listing

Consolidated Ledger Listing

See Also