Which Option Should I Select for Consolidated Reporting?

The appropriate consolidated reporting solution for your organization is based on your specific needs and circumstances. See the table below for some guidelines that will point you in the right direction. Remember, you can also use multiple options in a combination.

Option Purpose
Consolidation Company

A consolidation company lets you transfer balances from multiple general ledger companies for the purpose of consolidating financial information. What Is a Consolidation Company?

Use a consolidation company if:

  • You have multiple companies with different structures and you want to report at a level higher than the detail level.

  • You have multiple companies that operate in different base currencies and you need to report in one base currency.

  • You have multiple companies and one company serves the sole purpose of holding eliminating or adjusting entries.

Report Currency

A report currency is an additional nonbase currency assigned to a company for reporting and analysis. You can use report currencies in combination with select data dictionary items in the Report Writer application. What Are Report Currencies?

Report currency is a viable option if:

  • You have no more than three different currencies in which you need to report within a single company. (You can only assign two report currencies and one base currency to a company.)

  • You have multiple companies that operate in different base currencies but have accounts and accounting units in common. You can assign a common report currency to each company and produce consolidated reports in that reporting currency.

    Note: Accounts Payable and Accounts Receivable do not interface gain/loss amounts in a report currency. If this information is essential to you, you will want to consider another alternative.
Report Writer

You can use the Report Writer application to produce consolidated financial statements. Using report currencies with Report Writer gives you the flexibility to consolidate multiple currencies. Run reports by company group, level group, or a list to bring together data from multiple companies. What Are Company Groups, Level Groups, and Lists?

If you are using the Financials Data Mart this capability is also available. Using Lawson Business Intelligence to create data marts