Consolidated General Ledger Reports Overview
If you use the Multicompany feature, you can run consolidated versions of Vision's 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 General tab of the Options dialog box 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, 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. The Consolidated Eliminations report 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.
Multicurrency
If you also use the Multicurrency feature, 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, and 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
The Consolidated Balance Sheet displays the distribution of your firm's assets, liabilities, and net worth as of the current date of a consolidation group. The report also includes totals for assets, liabilities, net worth, and liabilities + net worth. Total assets should equal total liabilities plus net worth. If these totals do not agree, Vision displays the amount of the discrepancy at the end of the report. - Consolidated Eliminations Report
Use the Consolidated Eliminations report to review the accounts and amounts that were eliminated during consolidation processing. The report displays to-date elimination totals for balance sheet accounts and fiscal year-to-date totals for income statement accounts, through the current accounting period. Any income statement account eliminations from prior years are summarized on a single, separate report line. You can drill down to see the supporting transaction detail for any amount on the report. - Consolidated Income Statement
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 firm's current period and year-to-date operating profit or loss amounts. - Consolidated Profit Planning Monitor
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. It also shows totals for actual and budgeted revenue and expense, and calculates actual and budgeted profit or loss.