Consolidated GL Reports
If you use multiple companies, you can generate consolidated versions of the general ledger reports to show financial data for a group of companies. For example, you might include all North American companies in one consolidation group, and all European companies in another.
Security and the Consolidation Group Lookup Option
The options for the consolidated versions of the general ledger reports are identical to those for the standard versions, with the following exceptions:
- You use the Consolidation Group lookup option on the Options tab to select a consolidation group for each report, rather than selecting an organization. Security roles determine your access rights to companies. On the Access Rights tab of the Roles form (in Settings), your security administrator specifies whether you and the other employees in your security role have access to just one company or to multiple companies. You can select a consolidation group for a report only if you have security access to all companies in that consolidation group.
- The firm name on the report is the name of the consolidation group.
- The first drill-down level defaults to the company level of the organization code.
Consolidated Eliminations Report
The only consolidated general ledger report that does not have an equivalent standard version is the Consolidated Eliminations report, which lists the accounts excluded from the consolidated general ledger reports.
Drill Down for Detail
If you preview a consolidated general ledger report, you can drill down on all numerical data in that report. The reports provide the standard general ledger options for multiple drill-down levels.
Multiple Currencies
If you also use multiple currencies, the currency for each consolidated general ledger report is based on the currency of the consolidation group. However, each drill-down report displays amounts in the functional currency of the company that owns the transaction. Because the first drill-down level defaults to the company level, you can see company totals first, then drill down on that company's data to see supporting transaction detail in the functional currency of the company that owns the transactions.
- Related Topics:
- Consolidated Balance Sheet Report
The Consolidated Balance Sheet displays the distribution of your enterprise's assets, liabilities, and net worth as of the current date of a consolidation group. - Consolidated Eliminations Report
Use the Consolidated Eliminations report to review the accounts and amounts that were eliminated during consolidation processing. - Consolidated Income Statement Report
The Consolidated Income Statement provides a detailed statement of your revenue and expense account balances for the current period and year to date for a consolidation group. The report also displays the current period and year-to-date operating profit or loss amounts. - Consolidated Profit Planning Monitor Report
Use the Consolidated Profit Planning Monitor to monitor performance against budgets for any consolidation group. For each revenue and expense account, the report displays the budgeted and actual amounts for the current period and year to date.