Consolidated data report

Use Reporting to view consolidated financial data by book.

Consolidated data

You can view and analyze consolidation data by KPIs or by running reports. KPI data is automatically populated and accessible when KPI roll-up is selected on the Organization view. Use standard reports or create custom financial reports to show the consolidation data that best helps determine trends that often drive business decisions.

You can run reports:

• from the Reports section of the Consolidation navigation panel
• from an application menu
• from the Reports center

Drill down from book totals to see the individual totals and transactions that appear in the reports. Select any data that's shown as a link to access other reports or journals that contribute to a report.

View KPIs or reports

Get reports for a consolidation book

From the financial reports and graphs list, use the Reporting Book filter at the top of the page to specify the book of interest.

Select Edit to edit the report, or select the output in which you want the report results to appear, depending on the type of data you want to see.

KPIs

KPIs are visible from the Organization view, but not on the consolidation reports. KPIs are for entity/location, not consolidation book.

Organization view. From the main Consolidation menu, you can select the Organization view from the Reports section. It displays a diagram of the entire organization: top level, entities, and locations. Select any entity or location to view real-time financial data using key performance indicators (KPIs) displayed in the operating currency of the location or entity. All selected KPIs appear in the organization view details.

Reports

You can get two kinds of reports from your consolidation data: standard reports that are included in the setup, and Financial reports for consolidation books.

Standard reports

The standard reports included are listed separately under the Reports section of the navigation panel. Select from:

• Trial balance
• General ledger
• Customer aging
• Supplier aging

Consolidation book reports

Run reports for a selected consolidation book. By default, only reports for consolidation books appear on the list if you select Financial reports from the Consolidation navigation panel.

Easily select to drill down into the reports and see the transactions that comprise report totals.  To access consolidation reports, go to the Reports section of the Consolidation navigation panel.

Alternately, from Reports > All >Financial reporting > Financial reports, use the Reporting Book filter at the top of the page to limit the list of books to consolidation books, to help you find the book of interest. Filtering is case sensitive.

Select Edit to edit the report, or select the output in which you want the report results to appear, depending on the type of data you want to see.