Consolidation reports

Use the Reports section of the Consolidation menu to run financial, trial balance, and aging reports for consolidated data by book. You can run standard out-of-the-box reports or you can run reports customized to display consolidated data in almost any combination you want.

Quickly drill down through consolidated totals to view the transactions that make up the totals, in the operating currency of the reporting entity or location.

Consolidation reports

Immediately after you run a consolidation, you can access the consolidation reports. This ensures that you have the latest data based on the consolidation.

As well as the Organization chart with the KPI information, there are 4 standard reports always available for every consolidation book:

  • Customer Aging
  • Supplier Aging
  • Trial Balance
  • General Ledger

You can create any number of custom financial reports to view consolidation data for other items, such as:

  • financial ratios
  • net income
  • side-by-side financial statements
  • cash flow
  • other financial reports for which you want to view consolidation data
Custom financial reports are specific to each book.

On the Financial reports list, reports are listed by name, owner, and reporting book. Custom financial reports are created in the General Ledger (General Ledger > All > Financial reporting > Financial reports).

You set the consolidation book associated with the report when you create the report. When you access Financial reports in Global Consolidation, only those reports for consolidation books appear in the list.

Run a report

  1. Go to Consolidation > All > Reports.
  2. Select the standard report or select Financial reports to see the list of included reports. Only reports relating to consolidation appear in the list when you access it from the Global Consolidation reports menu. Standard reports are output in HTML only; custom financial reports can be output in additional formats.
  3. Choose the output you want: Process & store, HTML, CSV, PDF, or Excel*.
  4. If the report requires further selections, such as location or customer, a popup or filters form appears. Select the options needed for this report and select OK.

The report will run and the output will appear in the format you've selected. These reports display consolidated data in the reporting currency for the book.

* Changes to Microsoft security can cause issues when exporting to Excel. See Can't export a report to Excel for details.

Drill down to view transactions included in report totals

Reports that are output in HTML allow you to drill down from book totals to see the individual totals and transactions that comprise report totals. This makes it fast and easy to analyze data.

Line items and totals that can be drilled down are displayed in reports as blue links. Just select the link, and the report or transactions from which this report's total is derived is displayed. You can continue to drill down through any blue links available, until you reach the transaction level. As you drill down, each report or transaction that displays identifies the currency in which it is displayed. In this way, you can drill down through consolidation reports and review amounts in the operating currency of each entity or location.

Example

You're working with a company that has a consolidation book for Australia that includes the entities of Australia and Japan.

You run a custom report for Net Income by location Japan. When the HTML report appears, it has 3 columns, one each for Osaka, Tokyo, and Japan, with line item totals for Sales, Salaries, Outside Services, Insurance, Office Supplies, Rent, and Utilities. The report currency displays at the top (AUD) and all of the line item totals display as blue links.

You notice a fairly large amount of 6,509.82 for Outside Services in the Japan column and you want to know more about what comprises that amount.

You select that amount, and a GL report of individual consolidation entries that comprise that total appears. It shows both currencies—the original transactions in JPY and the consolidation entries in AUD.

You select further and reach a GL report of the AUD Book Japan Journal, where you can view individual transactions that contribute to the line totals, in the JPY operating currency.

You can drill down in this manner any time report totals display as blue links.

Read-only fields

Name

The first column of the spreadsheet on the Reports tab displays the name of each report available for the selected book. The standard reports are listed first. Below that is a Financials folder icon, with a collapse/expand icon next to it. Select the icon to hide or show the custom reports available for the selected book.

Owner

The Owner column displays either Public or the name of the report owner for each report.

Reporting book

The reporting book field lets you filter for a specific reporting book. This can't be edited directly.